Home › Sources › sfpd_traffic_violation_reports
SFPD Traffic Violation Reports and Focus-Five Citation Scorecard
Source ID sfpd_traffic_violation_reports. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfpd_traffic_violation_reports |
| Name | SFPD Traffic Violation Reports and Focus-Five Citation Scorecard |
| Owner | San Francisco Police Department / DataSF |
| Layer | traffic_enforcement_context |
| Coverage | Official SFPD page exposed 125 traffic-violation PDF links; a bounded modern-layout PDF extractor parsed five recent reports for January-May 2025 into 140 table rows and 2,100 aggregate court_metric rows with zero PDF failures. DataSF Scorecard measure 1058 exposes 60 monthly focus-five citation source rows from 2021-07-31 through 2026-06-30; bounded parser promotes 117 additional aggregate traffic-enforcement metric rows. |
| Formats | HTML, PDF, JSON API, CSV |
| Join keys | calendar_month, report_period, police_district, station, unit, violation_type, citation_category |
| Caveats | Traffic citation aggregates are enforcement context, not court case outcomes., PDF table extraction requires a quarantine path for layout changes before promotion. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfpd_traffic_violation_reports | official_pdf_index_plus_socrata_metric | - | - | - |
Full source record
| Access Mode | official_pdf_index_plus_socrata_scorecard_metric |
| Cadence | monthly report/scorecard updates |
| Coverage | Official SFPD page exposed 125 traffic-violation PDF links; a bounded modern-layout PDF extractor parsed five recent reports for January-May 2025 into 140 table rows and 2,100 aggregate court_metric rows with zero PDF failures. DataSF Scorecard measure 1058 exposes 60 monthly focus-five citation source rows from 2021-07-31 through 2026-06-30; bounded parser promotes 117 additional aggregate traffic-enforcement metric rows. |
| Government Level | local_police |
| ID | sfpd_traffic_violation_reports |
| Layer | traffic_enforcement_context |
| Name | SFPD Traffic Violation Reports and Focus-Five Citation Scorecard |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_bounded_pdf_table_and_scorecard_extract |
| Canonical Records | court_metric, agency_profile, source_record |
| Caveats | Traffic citation aggregates are enforcement context, not court case outcomes., PDF table extraction requires a quarantine path for layout changes before promotion. |
| Evidence | artifacts/source-discovery/sfpd-traffic-violation-reports.profile.json, artifacts/source-discovery/sfpd-traffic-violation-reports-page.html, artifacts/source-discovery/sfpd-traffic-violation-report-pdf-links.txt, artifacts/source-discovery/sfpd-traffic-violation-pdf-extract.profile.json, artifacts/source-discovery/sfpd-traffic-violation-pdfs/, artifacts/source-discovery/sfpd-traffic-violation-text/, artifacts/source-discovery/datasf-scorecard-measures-kc49-udxn.view.json, artifacts/source-discovery/datasf-scorecard-police-focus-five-kc49-udxn.sample.json, data/court_metrics_raw/sfpd-traffic-violation-scorecard-metrics.json, data/court_metrics_raw/sfpd-traffic-violation-scorecard-metrics.manifest.json, data/court_metrics_raw/sfpd-traffic-violation-pdf-metrics.json, data/court_metrics_raw/sfpd-traffic-violation-pdf-metrics.manifest.json, scripts/parse_sfpd_traffic_violation_reports.py |
| Formats | HTML, PDF, JSON API, CSV |
| Join Keys | calendar_month, report_period, police_district, station, unit, violation_type, citation_category |
| Known Endpoints | Socrata /resource/kc49-udxn.json |
| Rate Limit Notes | Parse PDFs offline with layout validation and PDF-level quarantine; the Scorecard metric is small enough for scheduled Socrata sync., Historical PDF vintages still need parser expansion before claiming full 125-report coverage. |
| Source Urls | https://www.sanfranciscopolice.org/stay-safe/crime-data/traffic-violation-reports, https://data.sfgov.org/City-Management-and-Ethics/Scorecard-Measures/kc49-udxn, https://data.sfgov.org/resource/kc49-udxn.json |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/sfpd_traffic_violation_reportsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfpd_traffic_violation_reports&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON