Fundamentally, we need to recognize that in a certain sense, San Fransisco is a Malthusian nightmare. Expanding population, limited resources. No matter what you do, someone will go without - that's just simple math.
San Francisco's population is only a little above its 1950 population. Its not an example of uncontrolled, unsustainable growth.
(Same situation with food. Demand is inelastic, so a small scarcity hurts a lot.)