There used to be various sites that allowed you to listen in on the SFPD frequencies, but they switched to a digital version that you'd have to crack, and they're not handing out access to it
Palo Alto started encrypting the police radio a few years ago, but a new chief of police was hired last year and reversed the decision and made it public again. Palo Alto cares more about transparency than the average city though.