Red Light Camera Violations

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id spqx-js37
Name Red Light Camera Violations
Attribution City of Chicago
Category Transportation
Tags citations, violations, transportation, public safety
Created 2014-08-08T00:09:40Z
Publication Date 2016-11-29T23:16:25Z

Description

This dataset reflects the daily volume of violations created by the City of Chicago Red Light Program 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 during this period. The reported violations are those that have been collected by the camera 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 actually issued, which provides an accurate view into the Red Light Program. Because of occasional time lags between the capturing of a potential violation and the processing and determination of a violation, as well as the occasional revision of the determination of a violation, this data may change. More information on the Red Light Program can be found here: http://www.cityofchicago.org/city/en/depts/cdot/supp_info/red-light_cameraenforcement.html. The corresponding dataset for speed camera violations is https://data.cityofchicago.org/id/hhkd-xvj4.

Columns

| Included | Schema Type    | Field Name     | Name           | Data Type     | Render Type   |
| ======== | ============== | ============== | ============== | ============= | ============= |
| Yes      | series tag     | intersection   | INTERSECTION   | text          | text          |
| Yes      | series tag     | camera_id      | CAMERA ID      | text          | text          |
| No       |                | address        | ADDRESS        | text          | text          |
| Yes      | time           | violation_date | VIOLATION DATE | calendar_date | calendar_date |
| Yes      | numeric metric | violations     | VIOLATIONS     | number        | number        |
| No       |                | x_coordinate   | X COORDINATE   | number        | number        |
| No       |                | y_coordinate   | Y COORDINATE   | number        | number        |
| No       |                | latitude       | LATITUDE       | number        | number        |
| No       |                | longitude      | LONGITUDE      | number        | number        |

Time Field

Value = violation_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = address,x_coordinate,y_coordinate,latitude,longitude

Data Commands

series e:spqx-js37 d:2014-08-02T00:00:00.000Z t:intersection="31ST ST AND MARTIN LUTHER KING DRIVE" t:camera_id=2121 m:violations=16

series e:spqx-js37 d:2014-07-15T00:00:00.000Z t:intersection="MADISON AND CENTRAL" t:camera_id=1751 m:violations=5

series e:spqx-js37 d:2014-07-27T00:00:00.000Z t:intersection="HOMAN/KIMBALL AND NORTH" t:camera_id=1771 m:violations=1

Meta Commands

metric m:violations p:integer l:VIOLATIONS d:"Number of violations for each camera on a particular day." t:dataTypeName=number

entity e:spqx-js37 l:"Red Light Camera Violations" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/spqx-js37

property e:spqx-js37 t:meta.view v:id=spqx-js37 v:category=Transportation v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Red Light Camera Violations" v:attribution="City of Chicago"

property e:spqx-js37 t:meta.view.owner v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"

property e:spqx-js37 t:meta.view.tableauthor v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:roleName=administrator v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"

Top Records

| intersection                         | camera_id | address                 | violation_date      | violations | x_coordinate | y_coordinate | latitude | longitude | 
| ==================================== | ========= | ======================= | =================== | ========== | ============ | ============ | ======== | ========= | 
| 31ST ST AND MARTIN LUTHER KING DRIVE | 2121      | 3100 S DR MARTIN L KING | 2014-08-02T00:00:00 | 16         |              |              |          |           | 
| MADISON AND CENTRAL                  | 1751      | 0 S CENTRAL AVENUE      | 2014-07-15T00:00:00 | 5          |              |              |          |           | 
| HOMAN/KIMBALL AND NORTH              | 1771      | 1600 N HOMAN AVENUE     | 2014-07-27T00:00:00 | 1          |              |              |          |           | 
| IRVING PARK AND LARAMIE              | 1533      | 5200 W IRVING PARK ROA  | 2014-08-07T00:00:00 | 6          |              |              |          |           | 
| ASHLAND AND MADISON                  | 1911      | 0 N ASHLAND AVE         | 2014-07-23T00:00:00 | 1          |              |              |          |           | 
| IRVING PARK AND KILPATRICK           | 2763      | 4700 W IRVING PARK ROA  | 2014-07-11T00:00:00 | 8          |              |              |          |           | 
| ASHLAND AND DIVERSEY                 | 1623      | 1600 W DIVERSEY PARKWA  | 2014-07-04T00:00:00 | 3          |              |              |          |           | 
| ELSTON AND IRVING PARK               | 1503      | 3700 W IRVING PARK ROA  | 2014-07-26T00:00:00 | 5          |              |              |          |           | 
| IRVING PARK AND LARAMIE              | 1533      | 5200 W IRVING PARK ROA  | 2014-08-01T00:00:00 | 2          |              |              |          |           | 
| 31ST AND CALIFORNIA                  | 2064      | 2800 W 31ST             | 2014-07-13T00:00:00 | 1          |              |              |          |           |