San Francisco coming 4th most dangerous in your table might be correlated with a reluctance to go there.
Anecdotally, I've been here 30 years and never victim of a "dangerous" crime. Fat chance you move to Mountain View to work at Google and anything happens to you.
The only place in CA someone reading a "Best City for Techies" will encounter crime is Market St. and Tenderloin in SF. The rest of it in deep Oakland, Stockton, Modesto, San Bernardino, and pockets of LA, they will never end up.
Also as of two years ago, the chances that your Catalytic converter was stolen unless you parked your car in your garage was getting near 50% as well.
I suppose if you limit crime to just "dangerous" maybe it comes out on top, but I would prefer to be somewhere that I don't have to worry about 50,000 of my neighbors OD'ing on the street every year.
Also, these statistics measure crime according to the laws, their enforcement and reporting. SF has lax laws, lax enforcement and underreporting.