SF residents don't want the solution.
Real estate is the primary wealth building asset class of long-term residents who bought property ages ago or inherited it.
In California property taxes as assessed at time of sale, so you hold onto properties realistically valued at multiple millions while paying taxes at rate appropriate to tens of thousands.
Bulldozing a single family home to build a multi-family unit has an enormous cost on the back end given re-assessment.
Any potential drop in property values has massive protest. It's such a nice free-ride you will fight tooth and nail for.
These residents just want the homeless population "dealt with".
The only solution viable for these residents is getting rid of homeless people through force.
This in untenable give that these residents also have internalized a set of liberal moral values, which mostly means alleviating guilt by dumping money onto ineffective non-profit organization who at worst are siphoning public funds for themselves or at best are trying their best at executing strategies which have minimal impact.
Consider that between 2010 and 2020, SF built ~25,000 new housing units.
Charlotte, NC, a city with a lower population, built 160,000 new units.
Norway has homeless population of 0.07% by mostly doing one thing: building and giving homes to people who don't have them.
That would cause property values to plummet. Many long-term residents would have to seek employment after a lifetime of living off rents.