Urban Sidewalk Uplift, Street Defect, and Streetlight Outage Hotspots: Reconciled Municipal 311 Infrastructure Backlogs
Across 509,867 reconciled municipal 311 service requests audited against U.S. Census TIGER/Line 2025 street networks and San Francisco Enterprise Addressing System (EAS) points, 322,712 San Francisco street, sidewalk, and obstruction filings and 167,530 Los Angeles streetlight outage reports cluster along high-volume transit and commercial corridors.
Separating Direct Right-of-Way Hazard Filings From Municipal Lighting Context
Municipal 311 open-data portals do not use uniform taxonomies across California cities, and combining raw city tables without explicit grain separation creates misleading cross-city rankings. In Safer Places, our pipeline preserves strict jurisdictional and evidentiary boundaries across 509,867 deduplicated service requests spanning 223,574 distinct reported locations. San Francisco's DataSF 311 archive (data.sf.gov/resource/vw6y-z8j6.json) contributes 322,712 direct public-right-of-way hazard requests since July 2008, covering pavement defects, broken curbs, uplifted sidewalk slabs, and blocked pedestrian walkways.
Los Angeles's MyLA311 annual archives (data.lacity.org, 2020 through partial 2025) contribute 178,950 environmental context records, consisting of 86,791 multiple-streetlight outage filings, 80,739 single-streetlight outage filings, and 11,420 water-waste reports that occasionally indicate runoff across walkways. Keeping direct surface-defect categories separate from lighting and water context ensures analysts never mistake differences in city portal scope for differences in physical sidewalk damage.
| Jurisdiction & Official 311 Category | Deduplicated Requests | Share of Archive | Evidence Classification |
|---|---|---|---|
| sf: Street Defects | 99,858 | 19.6% | Direct street, sidewalk, pothole, or municipal 311 report |
| la: Multiple Streetlight Issue | 86,791 | 17.0% | Lighting outage or water-waste corridor context |
| sf: Sidewalk or Curb | 86,623 | 17.0% | Direct street, sidewalk, pothole, or municipal 311 report |
| la: Single Streetlight Issue | 80,739 | 15.8% | Lighting outage or water-waste corridor context |
| sf: Blocked Street or SideWalk | 44,067 | 8.6% | Direct street, sidewalk, pothole, or municipal 311 report |
| sf: Blocked Street and Sidewalk | 36,951 | 7.2% | Direct street, sidewalk, pothole, or municipal 311 report |
| sf: Sidewalk and Curb | 32,765 | 6.4% | Direct street, sidewalk, pothole, or municipal 311 report |
| sf: Street Defect | 22,448 | 4.4% | Direct street, sidewalk, pothole, or municipal 311 report |
| la: Report Water Waste | 11,420 | 2.2% | Lighting outage or water-waste corridor context |
| nyc: Blocked Driveway | 739 | 0.1% | Direct street, sidewalk, pothole, or municipal 311 report |
| sea: Streetlight Maintenance | 476 | 0.1% | Direct street, sidewalk, pothole, or municipal 311 report |
| chi: Street Light Out Complaint | 405 | 0.1% | Direct street, sidewalk, pothole, or municipal 311 report |
Where Surface and Pedestrian Access Reports Concentrate in San Francisco
Within San Francisco's 322,712 direct hazard filings, pavement and roadway surface complaints (Street Defects plus Street Defect) total 122,306 requests, sidewalk and curb damage categories total 119,388 requests, and blocked street or sidewalk obstruction categories account for 81,018 requests. When standardized against 178,833 authoritative San Francisco EAS address points and 96,594 street-intersection records, high-density transit spines along Market Street, Mission Street, Van Ness Avenue, Folsom Street, Geary Boulevard, and 19th Avenue lead citywide reporting volume.
Why Address and Intersection Standardization Changes Hotspot Rankings
Raw 311 submissions routinely record the same corner or transit plaza under five or more text variants, such as reversing cross-street order ("4TH ST & FOLSOM ST" versus "Intersection of FOLSOM ST and 4TH ST") or alternating ZIP suffixes along boundary streets. Safer Places normalizes 498,223 address labels across 377,868 distinct coordinate-address inputs while withholding 138,723 unverified or missing-location requests from map plotting so default municipal centroids cannot create false hotspot spikes.
| Verified Location / Intersection | Neighborhood | 311 Requests | Open Backlog | Subtypes | Median Closure |
|---|---|---|---|---|---|
| 830 MARKET ST | Financial District/South Beach | 305 | 239 | 8 | 0.7 d |
| 3455 VAN NESS AVE | Marina | 178 | 1 | 5 | 0.0 d |
| 42 THE EMBARCADERO | Financial District/South Beach | 157 | 1 | 5 | 0.0 d |
| 1206 MISSION ST (APPROXIMATE ADDRESS) | South of Market | 144 | 4 | 1 | 2.7 d |
| 1888 MISSION ST | Mission | 140 | 3 | 7 | 4.5 d |
| 4TH ST & FOLSOM ST | South of Market | 135 | 1 | 13 | 4.1 d |
| ALANA WAY & EXECUTIVE PARK BLVD | Bayview Hunters Point | 132 | 9 | 6 | 2.2 d |
| 1 7TH ST (APPROXIMATE ADDRESS) | South of Market | 129 | 0 | 3 | 4.2 d |
| 3RD ST & FOLSOM ST | Financial District/South Beach | 122 | 1 | 16 | 4.0 d |
| CLARENDON AVE & LAGUNA HONDA BLVD | Inner Sunset | 112 | 7 | 13 | 6.5 d |
Practitioner Guidance for Reading High-Count Urban Locations
1. Foot-Traffic Exposure Amplifies Reporting Density
Commercial transit portals such as 830 Market Street (305 requests) and multimodal arterial intersections experience tens of thousands of daily pedestrian crossings. Higher 311 counts reflect both physical infrastructure wear and bystander reporting frequency rather than per-pedestrian injury risk.
2. Separate Repeated Single-Event Filings From Multi-Year Chronic Recurrence
One uplifted tree-well slab or sunken utility trench cover can generate half a dozen citizen reports within a single week. Comparing first-recorded and latest-recorded dates alongside subtype diversity (40 distinct subtypes in fact_service_request) distinguishes one-time construction disruptions from multi-year corridor deterioration.
3. Cross-Check Authoritative Address Points Against Street-Range Interpolations
Raw municipal 311 intakes mix rooftop parcel pins, mobile GPS snaps, street-segment midpoint interpolations, and unnumbered intersection labels across 377,868 distinct raw address-coordinate inputs. Before Safer Places plots a San Francisco corridor point, our pipeline reconciles 498,223 normalized labels against San Francisco Enterprise Addressing System (ramy-di5m) authoritative points (178,833 exact matches) and validates 96,594 corner filings against U.S. Census TIGER/Line street edges. Consequently, 371,144 requests map to 148,015 boundary-verified entities, while 138,723 unverified requests (75,559 locations in mart_entity) remain searchable in tabular directories without distorting spatial corridor density maps or falsely attributing approximate block coordinates to adjacent parcels.
Methodology and Coverage Boundaries
All statistics derive from primary municipal open-data captures (2026-11-18, publication 50dbca75a30e78114a6b). Service requests document reported conditions, not verified physical defects, injuries, or legal responsibility. Search all 223,574 locations in Explore and inspect SHA-256 source hashes on Method & sources.