https://www.sfchronicle.com/projects/2021/san-francisco-drug...
https://www.sfchronicle.com/projects/2021/san-francisco-drug...
If you look at more data, you see that even in California (https://www.countyhealthrankings.org/app/california/2021/mea...), SF is not at the top (Lake, Mendocino and Inyo rank higher). I'm not saying drug use is not a problem in SF. I'm just saying it's not the primary reason why we have a big homeless problem.
That said, compare with Ohio (https://www.countyhealthrankings.org/app/ohio/2021/measure/f...) where there are dozens of counties that more than double SF's overdose rate. And still, their homelessness rate is a fraction of California's.
sfchronicle has the overdose death rate for:
SF at 61 per 100k
Humboldt at 31 per 100k
Cited from Cali Dept of public health
CountryHealthRankings has:
SF at 23 per 100k
Humboldt at 32 per 100k