I'm not sure there are simple solutions to this that don't have side effects. Mostly, the goal seems to be to move it out of sight, and to be fair many of the people came to SF on bus tickets provided by other localities with the same goal. At the same time there's a level of permission in some areas that doesn't seem to change (kind of like the smash and grabs in all the tourist areas) what ever they say about law and order.
It's not like police have been motivated to do much about it for at least the last 30 years.
https://drugabusestatistics.org/drug-overdose-deaths/
Assuming 900000 people in San Francisco, the national average would say about 190/yr. One every 10hrs would mean 876/yr, or 4.6x the national average.