Another issue I see with the slide of the SF Metro area is the somewhat idyllic and idealized settings that some movies, especially those with Starfleet Command headquartered in San Francisco, show for a future SF that, quite frankly, is really, really hard to see from its current state both in terms of some physical transmogrification as well as shift in the urban environment for living there.
David