No current climate projection expects this kind of sea level rise. But, if human carbon dioxide emissions continue unabated and the climate models are anything close to right, on climactic time scales — hundreds of years — the San Francisco Archipelago could come to pass.
If you'd like to see what a range of sea level rise scenarios would do to your city, check out Surging Seas, Climate Central and Stamen Design's gorgeous and devastating mapping project.
The local project, though, personalizes the landscape. In any climate change scenario, people will keep living and naming the places in which they live. What was once "that hill by Candlestick Park" will become Isla Candelero.