About this Dataset

Red Light Camera Citations

A. SUMMARY The SFMTA’s Automated Enforcement Program uses a network of automated cameras to enforce illegal red-light running and illegal right turns. This dataset is a monthly aggregation of issued citations by intersection and direction. B. HOW THE DATASET IS CREATED All citations are added to a database overseen by SFMTA. This data is aggregated on a monthly basis. During the publishing process, the intersections are geocoded, adding in Latitude, Longitude, Analysis Neighborhood, and Supervisor District. C. UPDATE PROCESS This dataset will be updated on a monthly basis. Updates can lag by a month or more. D. HOW TO USE THIS DATASET Intersections can be listed multiple times in the dataset based on the direction of traffic and turning lanes in some cases. E. RELATED DATASETS

Parking Citations_
Organization: City of San Francisco
Last updated: 2025-03-29T17:12:18.223041

Tables

Table 1

@usgov.city_of_san_francisco_red_light_camera_citations.table_1

9.99 kB
457 rows
10 columns

CREATE TABLE table_1 (
  "intersection" VARCHAR,
  "directions_enforced" VARCHAR,
  "violation_type" VARCHAR,
  "month" TIMESTAMP,
  "count" DOUBLE,
  "point" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);