About this Dataset

Automated Speed Enforcement Citations

A. SUMMARY This dataset contains daily counts of warnings and citations issued by the SFMTA’s Automated Speed Enforcement program, broken down by camera. Some enforcement locations have two cameras to monitor traffic in both directions. To show which direction a camera is facing, a directional abbreviation is used—like NB for northbound, meaning traffic heading north. The dataset also includes the average speed of vehicles that received warnings or citations, as well as citation counts categorized by how much the vehicle exceeded the speed limit:

11–15 mph over
16–20 mph over
21+ mph over For more information about the program, visit SFMTA.com/SpeedCameras. B. HOW THE DATASET IS CREATED Data is collected through SFMTA's Automated Speed Enforcement Program. C. UPDATE PROCESS We will update this data set once a month. D. HOW TO USE THIS DATASET You can filter warnings issued by day, site/location, number of warnings issued, posted speed limit, average speed, and speed distribution bucket.
Organization: City of San Francisco
Last updated: 2025-05-24T18:28:14.991615

Tables

Table 1

@usgov.city_of_san_francisco_automated_speed_enforcement_citations.table_1

22.89 kB
409 rows
19 columns

CREATE TABLE table_1 (
  "date" VARCHAR,
  "site_id" VARCHAR,
  "location" VARCHAR,
  "enforcement_type" VARCHAR,
  "dow" VARCHAR,
  "issued_warnings" BIGINT,
  "issued_citations" BIGINT,
  "posted_speed" BIGINT,
  "avg_issued_speed" DOUBLE,
  "n__11_to_15_mph_over" BIGINT  -- 11 To 15 Mph Over,
  "n__16_to_20_mph_over" BIGINT  -- 16 To 20 Mph Over,
  "n__21_plus_mph_over" BIGINT  -- 21 Plus Mph Over,
  "point" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);