In 30 years of being around SF, this is really only accurate of Tenderloin,
Civic Center, SOMA, Market and Mission St, roughly 10% of SF
Most of San Francisco has been pretty rough for most of its history. The Haight has struggled with being a destination for street kids for going on fifty years. Vis Valley? Probably the most infamous projects west of the Mississippi. Chinatown? That's pretty much always been tenement housing and the sort of grunge that you get with that many people essentially living on top of each other.