That's fine, I'm not interested in #notalldevelopment reasoning because my point was not to ascribe all of the behavior to NIMBYs. I was only countering the idea that "politicians, amirite?" is the problem.
i guess i don't have any more hard evidence at hand than what you present here, but my gut feeling is totally the opposite on this. i think there are a lot of people in SF (in the SF bay area in general or the city in particular) who would get behind this sort of program in principle, but who would be scared to be close to the implementation of such a program.
i think this particular flavor of NIMBYism (overblown fears about e.g. safety and/or property values) is more prevalent in the burbs, and especially the more affluent suburbs, but i'm sure you get some of it in the more affluent neighborhoods and gentrified pockets of other neighborhoods in SF and oakland too.
Don't forget NIMBY residents. Just down the street from me is a building that used to be a church. The church wanted to start providing services and shelter for homeless LGBTQ teens. The neighbors threw a shitfit, the shelter never happened, the church closed and moved, and now the building is a dentist's office.