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.