That phenomenon isn't isolated to San Francisco, nor even to the US. The same mindset is also widespread in "progressive" Canadian cities like Vancouver, Toronto, and Ottawa, for example.
From what I can tell, one of the main pillars of the "progressive" ideology that's prevalent in such cities is that certain specific groups of people are declared to be "victims" or "disadvantaged", and these people are put on a pedestal and held in high esteem for some reason, no matter how awful they behave in public.
I suspect that most "progressives" inherently know that these sanctified people aren't the "victims" they're ideologically portrayed as being. Even if the "progressives" don't openly admit it, they themselves don't like dodging human feces on the sidewalk, nor the stench of urine emanating from building walls, nor used needles left in parks, nor addicts overdosing in bus shelters, nor smelly unwashed hobos sleeping on public transit, nor aggressive panhandlers demanding money from passersby, nor crucial retail stores closing due to rampant shoplifting, and so forth.
Yet, these "progressives" seem unwilling to admit that this main pillar of their ideology is fundamentally wrong. Perhaps they know that if they admit this, even to themselves, then the rest of their belief system will inevitably come crashing down because it, too, isn't built on reality.