Dataset: Speed Camera Violations

About this Dataset

Speed Camera Violations

This dataset reflects the daily volume of violations that have occurred in Children's Safety Zones for each camera. The data reflects violations that occurred from July 1, 2014 until present, minus the most recent 14 days. This data may change due to occasional time lags between the capturing of a potential violation and the processing and determination of a violation. The most recent 14 days are not shown due to revised data being submitted to the City of Chicago. The reported violations are those that have been collected by the camera and radar system and reviewed by two separate City contractors. In some instances, due to the inability the registered owner of the offending vehicle, the violation may not be issued as a citation. However, this dataset contains all violations regardless of whether a citation was issued, which provides an accurate view into the Automated Speed Enforcement Program violations taking place in Children's Safety Zones. More information on the Safety Zone Program can be found here: http://www.cityofchicago.org/city/en/depts/cdot/supp_info/children_s_safetyzoneporgramautomaticspeedenforcement.html. The corresponding dataset for red light camera violations is https://data.cityofchicago.org/id/spqx-js37.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:58.660382
Tags: public-safety, traffic, transportation

Tables

Table 1

@usgov.city_of_chicago_speed_camera_violations.table_1

3.92 MB
408261 rows
9 columns


CREATE TABLE table_1 (
  "address" VARCHAR,
  "camera_id" VARCHAR,
  "violation_date" TIMESTAMP,
  "violations" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);