Learning the lessons of past Red River floods