My friends in the geological sciences have told me there will be a big earthquake, but it will be capped at around magnitude 8.0; the faults here are not capable of a 9.0. Buildings in SF have been constructed or retrofit for modern earthquake safety by law.
An 8.0 would still cause massive devastation. Even if structures mostly survive there is the threat of fire and tsunami. This antenna tower looks like it is likely to survive though.