I couldn't find one done by city, but this report shows the estimated percentage of same sex couples across the states in 2004. Washington DC was the highest, with 4.58%. California's was only 1.38%. http://www.gaydemographics.org/USA/ACS/2004/ACS2004statelist.htm
However, San Francisco falls way below the "most bankrupt, disease infested, drug addicted, crime ridden city" category. By all measures, that would be Detroit and many other cities in that region of the country.
Feel free to continue to attempt to get the rest of the world to hate gays as you do by applying statistics that don't exist to problems irrelevant to homosexuality.