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:…

Access original file

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.

FieldRecorded type
ObjectIdesriFieldTypeOID
Anom_IDesriFieldTypeString
Accident_DateesriFieldTypeString
Accident_TimeesriFieldTypeString
LocationesriFieldTypeString
Geo_IDesriFieldTypeString
Accident_LocationesriFieldTypeString
Classification_of_AccidentesriFieldTypeString
Initial_Impact_TypeesriFieldTypeString
Environment_ConditionesriFieldTypeString
LightesriFieldTypeString
Road_Surface_ConditionesriFieldTypeString
Traffic_ControlesriFieldTypeString
Traffic_Control_ConditionesriFieldTypeString
No__of_VehiclesesriFieldTypeInteger
No__of_BicyclesesriFieldTypeInteger
No__of_MotorcyclesesriFieldTypeInteger
No__of_PedestriansesriFieldTypeInteger
Max_InjuryesriFieldTypeString
No__of_InjuriesesriFieldTypeInteger

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_IDAccident_DateAccident_TimeLocationGeo_IDAccident_LocationClassification_of_AccidentInitial_Impact_TypeEnvironment_ConditionLightRoad_Surface_ConditionTraffic_ControlTraffic_Control_ConditionNo__of_VehiclesNo__of_BicyclesNo__of_MotorcyclesNo__of_PedestriansMax_InjuryNo__of_InjuriesNo__of_Minimal
20--11272020/01/229:10 AMGREENBANK RD @ WEST HUNT CLUB RD (0005167)516702 - Intersection related03 - P.D. only04 - Sideswipe01 - Clear01 - Daylight01 - Dry01 - Traffic signal01 - Functioning20000
20--11282020/01/229:10 AMHIGHWAY 417 btwn HWY417 IC110 RAMP64 & HWY417 IC104 RAMP16 (__3ZA2W9)__3ZA2W901 - Non intersection03 - P.D. only03 - Rear end01 - Clear01 - Daylight02 - Wet10 - No control30000
20--11292020/01/229:16 AMLEMIEUX ST @ ST. LAURENT BLVD (0002021)202103 - At intersection03 - P.D. only02 - Angle01 - Clear01 - Daylight02 - Wet01 - Traffic signal01 - Functioning20000
20--1132020/01/0412:45 PMCEDARVIEW RD @ KENNEVALE DR (0010465)1046503 - At intersection03 - P.D. only02 - Angle03 - Snow01 - Daylight02 - Wet02 - Stop sign01 - Functioning20000
20--11302020/01/229:21 PMTWIST WAY btwn EGO TERR & TRIANGLE ST (e___2HXL)e___2HXL04 - At/near private drive03 - P.D. only06 - SMV unattended vehicle03 - Snow07 - Dark04 - Slush10 - No control10000
20--11312020/01/231:09 PMMEADOWLANDS DR @ MERIVALE RD (0000625)62502 - Intersection related03 - P.D. only03 - Rear end01 - Clear01 - Daylight02 - Wet01 - Traffic signal01 - Functioning20000
20--11322020/01/231:28 PMSTIRLING AVE btwn SCOTT ST & LADOUCEUR ST (__3ZAAI6)__3ZAAI601 - Non intersection03 - P.D. only06 - SMV unattended vehicle01 - Clear01 - Daylight04 - Slush10 - No control10000
20--11332020/01/231:32 PMBILLINGS BRIDGE NB RAMP @ RIVERSIDE DR WB (0002619)261902 - Intersection related03 - P.D. only02 - Angle01 - Clear01 - Daylight02 - Wet10 - No control20000
20--11342020/01/231:52 PMMEADOWLANDS DR @ MERIVALE RD (0000625)62503 - At intersection02 - Non-fatal injury05 - Turning movement01 - Clear01 - Daylight01 - Dry01 - Traffic signal01 - Functioning200002 - Minor1
20--11352020/01/2310:00 AMGARLAND ST btwn SCOTT ST & LOWREY ST (__3ZAAK2)__3ZAAK201 - Non intersection03 - P.D. only06 - SMV unattended vehicle01 - Clear01 - Daylight06 - Ice10 - No control10000

Official sources and licences

Related open data