None of us on here are well-versed in city government, the myriad laws that would apply at the state and federal levels, etc.
You might as well be asking a bunch of accountants how they would fix Toyota's competitiveness in the EV market or something.
There's really only one way. Get Arnold back somehow. I am not sure how, but put him in control of S.F and watch the city prosper again.
As the policy appears to be die-them-out with 3/day OD rate downtown it should reolve itself in a few years.
And if enough techies leave the dystopian hellscape for better opportunities in Nashville that should free up enough SROs for the survivors.
Step one: Reach a consensus on what the city's problems are.
Step two: Reach a consensus on what causes them.
The rest will follow from there.
Crowdsource crimefighting. $10k bounty per thief or drug dealer brought to police. $100k per violent criminal, dead or alive. Bounty is doubled for repeat offenders.
Advertise the bounty program in rural America. Trucks full of armed rednecks will arrive within a week and the criminal underclass will scurry like rats.
Funding comes from the city's billion-dollar-plus homeless benefits programs.