I think that most large city police departments aren't popular with the locals, not just SFPD. A lot of unjustified shootings going on, in my opinion. I grew up on Bernal Heights in the Mission District, cops were always unpopular there. When I was a teen, I got stopped on my motorcycle on my street near my home. The cops were unfairly giving me a bad time, and a crowd gathered. I began laughing out loud when the cops turned around and saw some neighborhood punks rifling through their police car and trying to kick the shotgun loose. They chased the punks and left me alone. SFPD was always intimidating the locals and not making friends. Not the first time I was hassled, happened several other times. Later on, I went to work for them and saw what goes on from the inside. A few are bad and not out to make friends with the public.
In the 1950's very much better, only a couple of bad apples, steady deterioration to present.
SFPD robbed me of my cash on the street.
On my phone now so typing is slow but the short story is they handed me back my wallet and I realized a minute later that it no longer contained cash.
I am still thunderstruck and no longer trust cops, especially not SFPD, full of dishonest gays and other scum.