In your linked article, the city with the lowest climate change risk in the USA is San Franciso, CA. What they don't mention is that SF is also one of the most expensive cities to live in. Less wealthy residents have been priced out of the city over the last decade as high tech money raised housing prices. Another curious fact about SF is that it is one of the only places where the city and the county have the same boundaries. SF has no potential for expansion due to its location at the tip of the west bay peninsula. It has nowhere to grow but up, and up is iffy due to the high earthquake risk. And we are long overdue for "the big one" to strike.