2018 Tabular Transportation Collision Data


2018 Tabular Transportation Collision Data


Resource Format Link
AllCollisions2018.xlsx XLSX Go to resource
AllCollisions2018.csv CSV Go to resource
AllCollisions2018.kmz KMZ Go to resource

Additional Info

Field Value

Transportation Collisions

Date First Published
Update Frequency

The City of Ottawa provides this information in good faith but provides no warranty, nor accepts any liability arising from any incorrect, incomplete or misleading information or its improper use.

Collision Data Accuracy:

Each reportable collision occurring on public roadways is sent to the City of Ottawa and is validated at least once. Approximately 50% of the records are validated once again by a senior staff. Additionally, many queries are run on the database looking for errors.

X & Y Accuracy:

• Collisions are pinned according to information provided by the officer on the Motor Vehicle Collision Report.

• In some cases, insufficient information was provided, and the collision location is an estimate. In 2018 there were 836 of 14484 (5.8%).


• 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…)

• Latitude and longitude

Author Transportation Data Collection & Analytics
Author Email Transportation Data Collection & Analytics
Maintainer Transportation Services Department, Traffic Services Branch
Maintainer Email Transportation Services Department, Traffic Services Branch


Developer Tools

  • The information on this page (the publication metadata) is also available in JSON format
    Link to JSON format