2020 Tabular Transportation Collision Data (English, CSV)
Explore the interactive map. 2020 Tabular Transportation Collision Data: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Ottawa, updated Apr 2024.
- Format
- CSV
- Access
- Table on demand (prepared when opened) and interactive map
- Fields
- 20
- Publisher-reported update
- 2024-04-30
Date created: January 28, 2022 Update frequency: Annually Attributes: X and Y coordinate format is projected in MTM Zone 9, NAD83 (CSRS) KML and CSV/XLS formats are projected in latitude, longitude (WGS84) Date Time Location description (RD1 @ RD2 or RD from RD 1 to RD 2) Classification of collision (non-fatal, fatal, property damage only) Collision location (Intersection, non-intersection, at/near private driveway) Road surface condition (Ice, wet, dry snow...) Environment (Clear, rain, snow…) Light (daylight, dawn, dusk…) Initial impact type (Angle, turning movement, rear-end…) Traffic control (stop, traffic signal, no control…) No. of Bicycles No. of Motorcycles Max Injury (Highest injury level in the collisions) No. of Injuries No. of Minimal (Person did not go to hospital when leaving the scene of the collision) No. of Minor (Person went to hospital and was treated in the emergency room, but not admitted) No. of Major (Person admitted to hospital. Includes person admitted for observation. This could be either life threatening or non-life threatening) No. of Fatal (Person killed immediately or within 30 days of the motor vehicle collision) Latitude and longitude Author:…
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Explore table (prepared automatically) · Explore map · Access original file
Available fields (20/20)
Fields from the recorded map schema.
| Field | Recorded type |
|---|---|
| ObjectId | esriFieldTypeOID |
| Anom_ID | esriFieldTypeString |
| Accident_Date | esriFieldTypeString |
| Accident_Time | esriFieldTypeString |
| Location | esriFieldTypeString |
| Geo_ID | esriFieldTypeString |
| Accident_Location | esriFieldTypeString |
| Classification_of_Accident | esriFieldTypeString |
| Initial_Impact_Type | esriFieldTypeString |
| Environment_Condition | esriFieldTypeString |
| Light | esriFieldTypeString |
| Road_Surface_Condition | esriFieldTypeString |
| Traffic_Control | esriFieldTypeString |
| Traffic_Control_Condition | esriFieldTypeString |
| No__of_Vehicles | esriFieldTypeInteger |
| No__of_Bicycles | esriFieldTypeInteger |
| No__of_Motorcycles | esriFieldTypeInteger |
| No__of_Pedestrians | esriFieldTypeInteger |
| Max_Injury | esriFieldTypeString |
| No__of_Injuries | esriFieldTypeInteger |
Sample rows
The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-14. Showing 20 of 28 columns.
| Anom_ID | Accident_Date | Accident_Time | Location | Geo_ID | Accident_Location | Classification_of_Accident | Initial_Impact_Type | Environment_Condition | Light | Road_Surface_Condition | Traffic_Control | Traffic_Control_Condition | No__of_Vehicles | No__of_Bicycles | No__of_Motorcycles | No__of_Pedestrians | Max_Injury | No__of_Injuries | No__of_Minimal |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20--1127 | 2020/01/22 | 9:10 AM | GREENBANK RD @ WEST HUNT CLUB RD (0005167) | 5167 | 02 - Intersection related | 03 - P.D. only | 04 - Sideswipe | 01 - Clear | 01 - Daylight | 01 - Dry | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 20--1128 | 2020/01/22 | 9:10 AM | HIGHWAY 417 btwn HWY417 IC110 RAMP64 & HWY417 IC104 RAMP16 (__3ZA2W9) | __3ZA2W9 | 01 - Non intersection | 03 - P.D. only | 03 - Rear end | 01 - Clear | 01 - Daylight | 02 - Wet | 10 - No control | 3 | 0 | 0 | 0 | 0 | |||
| 20--1129 | 2020/01/22 | 9:16 AM | LEMIEUX ST @ ST. LAURENT BLVD (0002021) | 2021 | 03 - At intersection | 03 - P.D. only | 02 - Angle | 01 - Clear | 01 - Daylight | 02 - Wet | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 20--113 | 2020/01/04 | 12:45 PM | CEDARVIEW RD @ KENNEVALE DR (0010465) | 10465 | 03 - At intersection | 03 - P.D. only | 02 - Angle | 03 - Snow | 01 - Daylight | 02 - Wet | 02 - Stop sign | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 20--1130 | 2020/01/22 | 9:21 PM | TWIST WAY btwn EGO TERR & TRIANGLE ST (e___2HXL) | e___2HXL | 04 - At/near private drive | 03 - P.D. only | 06 - SMV unattended vehicle | 03 - Snow | 07 - Dark | 04 - Slush | 10 - No control | 1 | 0 | 0 | 0 | 0 | |||
| 20--1131 | 2020/01/23 | 1:09 PM | MEADOWLANDS DR @ MERIVALE RD (0000625) | 625 | 02 - Intersection related | 03 - P.D. only | 03 - Rear end | 01 - Clear | 01 - Daylight | 02 - Wet | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 20--1132 | 2020/01/23 | 1:28 PM | STIRLING AVE btwn SCOTT ST & LADOUCEUR ST (__3ZAAI6) | __3ZAAI6 | 01 - Non intersection | 03 - P.D. only | 06 - SMV unattended vehicle | 01 - Clear | 01 - Daylight | 04 - Slush | 10 - No control | 1 | 0 | 0 | 0 | 0 | |||
| 20--1133 | 2020/01/23 | 1:32 PM | BILLINGS BRIDGE NB RAMP @ RIVERSIDE DR WB (0002619) | 2619 | 02 - Intersection related | 03 - P.D. only | 02 - Angle | 01 - Clear | 01 - Daylight | 02 - Wet | 10 - No control | 2 | 0 | 0 | 0 | 0 | |||
| 20--1134 | 2020/01/23 | 1:52 PM | MEADOWLANDS DR @ MERIVALE RD (0000625) | 625 | 03 - At intersection | 02 - Non-fatal injury | 05 - Turning movement | 01 - Clear | 01 - Daylight | 01 - Dry | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 02 - Minor | 1 | |
| 20--1135 | 2020/01/23 | 10:00 AM | GARLAND ST btwn SCOTT ST & LOWREY ST (__3ZAAK2) | __3ZAAK2 | 01 - Non intersection | 03 - P.D. only | 06 - SMV unattended vehicle | 01 - Clear | 01 - Daylight | 06 - Ice | 10 - No control | 1 | 0 | 0 | 0 | 0 |