Sacramento Street Safety Lab

Why this exists

A civic safety website, not just a map.

Sacramento publishes rich transportation and public-safety datasets, but they live in separate catalog entries. This site fuses them into a single exploratory product: find high-risk corridors, compare crash severity, and bring the surrounding context into the same view.

Prioritize corridors

Rank streets by injuries, fatalities and crash volume rather than raw counts alone.

Inspect context

Overlay mapped crashes, streetlights, detours and county fatal zones while keeping traffic counts as exposure context in the summary data.

Copy the brief

Turn the selected corridor into a concise planning note for a Vision Zero-style intervention discussion.

Open data stack

Built from City and County public ArcGIS services.

City crash data

Mapped crash records, injury severity, collision factors, roads and years.

Traffic counts

ADT records used as non-spatial exposure context for corridors and intersections.

Streetlights

Lighting assets visible at neighborhood scale for local inspection.

Road detours

Current construction and closure context for operational awareness.

County fatal zones

Sacramento County motor-vehicle accident death geography for regional comparison.

Derived summaries

Python scripts validate services and generate the compact dashboard JSON.

Method

Severity-weighted scoring with defensible provenance.

Validate services. REST metadata, fields, counts, date coverage and sample records are checked before the app builds.
Aggregate corridors. Public crash records are grouped by primary road for the 2021–2025 analysis window.
Weight harm. Fatalities and injuries carry more signal than property-damage-only crashes.
Publish static. The live map reads public FeatureServer layers; summary JSON ships with the site for fast dashboard rendering.