apart from the fact that CA and SF's homeless problem is not entirely "Home Grown", this problem does have some roots going back to when Ronald Reagan was governor of the state...he passed the Lanterman-Petris-Short Act that made it very difficult to institutionalize many mentally ill persons...(he later, as President, took the federal government out of the business or assisting the mentally ill)...together, these actions have made it difficult for CA to manage the influx of homeless. I'd also like to add that our burgeoning issue of "Wealth Inequality" is having an effect on the homeless problem as well, in less obvious ways...Oh, and let's not forget CA's population has nearly doubled since 1980.
As to strategies and tactics, it's a very challenging problem...a lot of trial and yes, error, involved...feel free to offer your own "Solution" in light of all the influencing factors...no, really...feel free to share your opinion on how to resolve this...as for myself, I'd need to do a LOT more research before being so bold as to say I knew what the answer was.
I will say, however, that SF and the whole Bay Area is a fabulous environment and at least the equal of any other part of the USA that I've lived in, or visited...
Link: https://marcus-ruiz-evans.medium.com/texas-may-not-be-the-main-source-but-newsom-is-right-a-lot-of-the-homeless-in-california-are-f43a3a2aa84e