San Francisco hoods. SOMA is "South of Market" and is kind of industrial; It's being revamped with live/work lofts and lots of SMB / Shared office spaces.

Mission is another neighborhood which is pretty much a shit-hole, but IS a cool place. There are lots of great places to eat and drink and there are festivals, parties and parades most every night.

Usually when you hear about someone being shot, it's either in Oakland or the Mission.

"shit hole" is extraordinarily relative, apparently, and reflects more on the person using the term than the place being described.