About this Dataset

Speed Camera Locations

This dataset shows the location, first operational date, and approaches of the speed cameras in the City of Chicago. The approach describes the originating direction of travel which is monitored by a speed camera.

To attempt to make historical versions of this dataset more available, "Dataset Changelog" is enabled at the bottom of the main page. We cannot guarantee that the archival records will remain permanently so advise downloading any you think you may want. Some intermediate versions, especially minor changes, may not be visible. The map based on this dataset will not have past versions.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:22.422272
Tags: speed-cameras, traffic, transportation

Tables

Table 1

@usgov.city_of_chicago_speed_camera_locations.table_1

17.42 KB
189 rows
9 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "location_id" VARCHAR,
  "address" VARCHAR,
  "first_approach" VARCHAR,
  "second_approach" VARCHAR,
  "go_live_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);