hebernielsen/chicago-traffic-analysis

Analysis of Traffic Crashes in Chicago Since 2013

URL for Chicago Crash Data

Attributes and Definitions

• RD_NO - Chicago Police Department report number. This number can be used to link to the same crash in the Vehicles and People datasets. This number also serves as a unique ID in this dataset.

• CRASH_DATE_EST_I - Crash date estimated by desk officer or reporting party (only used in cases where crash is reproted at police station days after the crash)

• CRASH_DATE - Date and time of crash as entered by the reporting officer.

• POSTED_SPEED_LIMIT - Posted speed limit, as determined by reporting officer. (strange speed limits)

• TRAFFIC_CONTROL_DEVICE - Traffic control device present at crash location, as determined by reporting officer. (unclear)

• DEVICE_CONDITION - Condition of traffic control device, as determined by reporting officer.

• WEATHER_CONDITION - Weather condition at time of crash, as determined by reporting officer.

• LIGHTING_CONDITION - Light condition at time of crash, as determined by reporting officer.

• FIRST_CRASH_TYPE - Type of first collision in crash

• TRAFFICWAY_TYPE - Trafficway type, as determined by reporting officer.

• LANE_CNT - Total number of through lanes in either direction, excluding turn lanes, as determined by reporting officer (0=intersection)

• ALIGNMENT - Street alignment at crash location, as determined by reporting officer.

• ROADWAY_SURFACE_COND - Road surface condition, as determined by reporting officer.

• REPORT_TYPE - Administrative report type (at scene, at desk, amended)

• CRASH_TYPE - A general severity classification for the crash (Either Injury and/or Tow Due to Crash or No Injury / Drive Away)

• INTERSECTION_RELATED_I - A field observation by the police officer whether an intersection played a role in the crash. Does not represent whether or not the crash occurred within the intersection.

• NOT_RIGHT_OF_WAY_I - Whether the crash begun or first contact was made outside of the public right-of-way.

• HIT_AND_RUN_I - Crash did/did not involve a driver who caused the crash and fled the scene without exchanging information and/or rendering aid.

• DAMAGE - A field observation of estimated damage.

• DATE_POLICE_NOTIFIED - Calendar date on which police were notified of the crash.

• PRIM_CONTRIBUTORY_CAUSE - The factor which was most significant in causing the crash, as determined by officer judgment.

• SEC_CONTRIBUTORY_CAUSE - The factor which was second most significant in causing the crash, as determined by officer judgment.

• STREET_NO - Street address number of crash location, as determined by reporting officer.

• STREET_DIRECTION - Street address direction (N,E,S,W) of crash location, as determined by reporting officer.

• STREET_NAME - Street address name of crash location, as determined by reporting officer.

• BEAT_OF_OCCURRENCE - Chicago police department beat id. Boundaries URL

• PHOTOS_TAKEN_I - Whether the Chicago Police Department took photos at the location of the crash.

• STATEMENTS_TAKEN_I - Whether statements were taken from unit(s) involved in crash.

• DOORING_I - Whether crash involved a motor vehicle occupant opening a door into the travel path of a bicyclist, causing a crash.

• WORK_ZONE_I - Whether the crash occurred in an active work zone.

• NUM_UNITS - Number of units involved in the crash. A unit can be a motor vehicle, a pedestrian, a bicyclist, or another non-passenger roadway user. Each unit represents a mode of traffic with an independent trajectory.

• MOST_SEVERE_INJURY - Most severe injury sustained by any person involved in the crash.

• INJURIES_TOTAL - Total persons sustaining fatal, incapacitating, non-incapacitating, and possible injuries as determined by the reporting officer.

• INJURIES_FATAL - Total persons sustaining fatal injuries in the crash.

• INJURIES_INCAPACITATING - Total persons sustaining incapacitating/serious injuries in the crash, as determined by reporting officer. An incapacitating injury is any non-fatal injury that prevents the injured person from walking, driving, or normally continuing the activities they were capable of performing before the injury occurred. Includes severe lacerations, broken limbs, skull or chest injuries, and abdominal injuries.

• INJURIES_NON_INCAPACITATING - Total persons sustaining non-incapacitating injuries in the crash as determined by reporting officer. Any non-fatal, non-incapacitating injury that is evident to observers at the scene of the crash. Includes lump on head, abrasions, bruises, and minor lacerations.

• INJURIES_REPORTED_NOT_EVIDENT - Total persons sustaining posssible injuries in the crash as determined by the reporting officer. Includes momentary unconsciousness, claims of injuries not evident, limping, complaint of pain, nausea, and hysteria.

• INJURIES_NO_INDICATION - Total persons sustaining no injuriesi n the crash as determined by reporting officer.

• CRASH_DAY_OF_WEEK - The day of the week component of CRASH_DATE. Sunday=1

• CRASH_MONTH - The month component of CRASH_DATE

• LATITUDE - The latitude of the crash location, as determined by the reporting officer.

• LONGITUDE - The longitude of the crash location, as determined by reporting officer.

• LOCATION - The crash location, as determined by the latitude and longitude.

UP-TO-DATE TYPICAL SHIFT OF POLICE OFFICERS CAN BE FOUND AT https://chicago.suntimes.com/city-hall/2019/10/7/20903404/chicago-police-department-officers-start-times-rescinded-fraternal-order-union

GOOGLE ROADS API for retrieving speed limits for dataset. https://developers.google.com/maps/documentation/roads/speed-limits