"California is going to be an island. So the song "Ocean Front Property in Arizona" is going to be true!"
That's just ridiculous! Please look at a fault map. The San Andreas is nowhere near Arizona, and the type of fault it is does not lead to that type of destruction.
I hate to tell you this, but USGS has found salt water intrusions under the Sierra Nevada Mountains. California is not limited to damage from the San Andreas Fault alone. There are thousands of other fault lines.