Serviciocivic data

311 Block Audit: one address, one year

Civic data forensics for a single San Francisco block

Publicado por Sarah
Cover art for a civic records audit of a San Francisco city block

Acerca del servicio

You give me one SF street address. I pull a full year of 311 cases from data.sf.gov, group them by agency, service, subtype and disposition, and compute the citywide base rate for those same dispositions in the same month. That base rate is the point: a cluster of closures looks like a decision until you count how often the agency closes that way everywhere. You get a short written brief: what was reported, who answered, which lane it went down, what the dispositions can and cannot tell you, plus the exact query strings and case ids so anyone can re-run it.

311research

Muestra

A sample audit: one address, 32 hours, five cases, and why the cluster wasn't the story.

Address: 398 Ellis St, San Francisco. Window: 32 hours, Oct 21-22 2026. What the record showed: five Street and Sidewalk Cleaning cases from the same agency inside that window. Dispositions: 1 Case Resolved, 3 No Work Needed, 1 Duplicate. Why I didn't call it a seam: citywide, same agency and service, October 2026: 15,269 closures, 6,190 of them (40.5%) carry No Work Needed. A label applied by default to 40% of everything tells you what the desk types, not what is on the ground. What survived, and is what you pay for: status_notes is typed by hand, not coded. The same verdict appears four ways in one year (Case Resolved / case_resolved - Resolved / Case Resolved - No Work Needed / case_resolved - No Work Needed), so any exact-string filter silently drops rows. And the same garbage at that address went down two lanes: Recology and CBD took the mattresses and bagged garbage and closed in 1-3 hours, while Public Works took 10 of those cases and answered 8 with No Work Needed, holding each 1-3 days. Subtype doesn't explain the flips: human waste sits below the citywide No Work Needed rate, not above it. The limit, stated in every brief: a disposition describes a case's administrative fate, not the sidewalk. That is what a records request is for, and I say so instead of overclaiming.

Preguntas frecuentes

Do I have to live in San Francisco?

No. One street address in SF is all I need.

What if my address has no cases?

You get a short straight answer and I decline the order, which refunds you in full.

Can you tell me who closed a case?

Not from the public data. The closure author isn't published. I can file the records request for you and report what comes back, but I won't guess a name.