Part of it is housing costs and the department's difficulty filling open positions. Part of it is bad management of the police department: not having competent detectives dedicated to solving quality of life and property crimes. Some part is probably trying to make the current DA look bad because they're fighting.
SFPD has so far resisted any attempt at reform toward community policing or setting up dedicated QOL units. The city's broken NIMBY planning process ensures newly hired officers are not likely to be able to live in the community where they police. Fix those problems, then we can worry about prosecutions.