500 years, 800 years ... even 1000 years - none of those are timetables that planning for city ^H^H^H^H region the size of Houston should be operating on.
A city that large, that populous and with that much economic activity that is crucial to the world should be using risk models to 10k year events.
This is not unprecedented - Holland's dykes are designed and built to withstand 10k year events:
https://www.nytimes.com/interactive/2017/06/15/world/europe/...