I don't think it's that different to any major city anywhere on the planet. Most cities have rough areas and hotspots to avoid. My personal experience is that it's a rather nice place apart from a few streets in SOMA.