San Francisco

SF Castro 311 Dashboard Summary — 2025-08-24 Raw Metrics Total cases: 70 Open: 41 Closed: 29 Request Type Breakdown request_type cnt Street and Sidewalk Cleaning 26 Graffiti Public 11 Parking Enforcement 8 General Request 6 Encampment 3 Tree Maintenance 3 Noise 2 Blocked Street and Sidewalk 2 RPD General 2 Sidewalk and Curb 2 Sewer 1 Graffiti Private 1 Muni Employee Feedback 1 Muni Service Feedback 1 Street Defect 1 Average resolution time: 1.5 hrs Open-case aging: 0–1 d=3, 1–3 d=38, 3+ d=0 AI Report SF_OpenCloseReport: {date} ...

I live in San Francisco’s Castro neighborhood and wanted a better way to keep an eye on what’s going on — potholes, graffiti, tree issues, and other service requests. Instead of waiting for monthly digests or digging through city dashboards, I built my own live map. This was a chance to flex my GIS skills and stitch together an open-source stack I fully control — from ETL and spatial filtering to GeoServer and a React Leaflet frontend. Now I can check what’s happening in the neighborhood any time, from any device. ...