Navigating the challenges of flood risk for planning