I'm not sure but from what I've read about the numbers of homeless people and those with mental health issues left on the streets I wouldn't say it's that socially aware.
You've got this almost completely ass-backwards. It's a far more complicated issue than that.
Paradoxically, places with more homeless-friendly policies attract far more homeless people (for obvious reasons). As a famous example, Santa Monica has a history of hassling homeless people and effectively criminalizing homelessness, which has the effect of forcing the homeless population elsewhere.
Also, relative to a lot of other places in the US, SF's far-more temperate weather increases the appeal for those living outside. On top of all that, you get asshole states like Nevada bussing homeless people to places like San Francisco[1] (SF is actually suing the state of Nevada for this).
Now granted, the way _anywhere_ in the US treats their homeless and mentally ill is not particularly "socially aware", but looking at SF's relatively large homeless population and assuming that it comes from a relative lack of social awareness is a completely wrong-headed approach.
Isn't San Francisco pretty "socially aware" already?