Updating flood records using historic water profiles