SFPD (as well as other Bay Area law enforcement agencies) are hamstrung by the judicial system. From policies that effectively eliminate accountability (thefts below a dollar amount, individuals below an age, etc) to DAs cutting people loose as soon as they are booked so they never even see a day in court.
Think of it this way: If you are a QA engineer working on a video game, and week after week 100% of your bugs get closed as WONTFIX. Are you going to continue finding 10 bugs a day, or will maybe 2 a day get you by?
To be perfectly clear... I believe policing should be hard work. From an investigative perspective they should have to put in the hours and not just get a surveillance state handed to them. But I also recognize that once a potential perpetrator is located, we give them no good options for how to proceed and make our community safer.