Traffic Collisions by Location 2017-2024 (excluding 2023)

Collisions by location, placed on centroid, with count of pedestrian and bicycle collisions.

Accuracy: 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.

Update Frequency: Annually

Attributes:

  • X and Y Coordinate (MTM Zone 9, NAD83)
  • ID
  • Geo ID
  • Accident year
  • Location (RD1 @ RD2 or RD from RD 1 to RD 2) 
  • Classification of collision (non-fatal, fatal, property damage only)
  • Initial impact type (Angle, turning movement, rear-end…)
  • Road surface condition (Ice, wet, dry snow...)
  • Environment (Clear, rain, snow…)
  • Light (daylight, dawn, dusk…)
  • Traffic control (stop, traffic signal, no control…)
  • Number of Vehicles
  • Number of Pedestrians
  • Number of Bicycles
  • Number of Motorcycles
  • Max Injury (Highest injury level in the collisions)
  • Number of Injuries
  • Number of Minimal Injuries (Person did not go to hospital when leaving the scene of the collision)
  • Number of Minor Injuries (Person went to hospital and was treated in the emergency room, but not admitted)
  • Number of Major Injuries (Person admitted to hospital. Includes person admitted for observation. This could be either life threatening or non-life threatening)
  • Number of Fatal Injuries (Person killed immediately or within 30 days of the motor vehicle collision)
  • Latitude and longitude (WGS1984)

Contact: Transportation Data Collection & Analytics

Datasets available for download

Additional Info

Field Value
Last Updated August 21, 2026, 07:14 (UTC)
Created August 21, 2026, 07:14 (UTC)
Domain / Topic
Domain or topic of the dataset being cataloged.
Title
Title for the Dataset.
Traffic Collisions by Location 2017-2024 (excluding 2023)
Description
A description of the dataset.

Collisions by location, placed on centroid, with count of pedestrian and bicycle collisions.

Accuracy: 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.

Update Frequency: Annually

Attributes:

  • X and Y Coordinate (MTM Zone 9, NAD83)
  • ID
  • Geo ID
  • Accident year
  • Location (RD1 @ RD2 or RD from RD 1 to RD 2) 
  • Classification of collision (non-fatal, fatal, property damage only)
  • Initial impact type (Angle, turning movement, rear-end…)
  • Road surface condition (Ice, wet, dry snow...)
  • Environment (Clear, rain, snow…)
  • Light (daylight, dawn, dusk…)
  • Traffic control (stop, traffic signal, no control…)
  • Number of Vehicles
  • Number of Pedestrians
  • Number of Bicycles
  • Number of Motorcycles
  • Max Injury (Highest injury level in the collisions)
  • Number of Injuries
  • Number of Minimal Injuries (Person did not go to hospital when leaving the scene of the collision)
  • Number of Minor Injuries (Person went to hospital and was treated in the emergency room, but not admitted)
  • Number of Major Injuries (Person admitted to hospital. Includes person admitted for observation. This could be either life threatening or non-life threatening)
  • Number of Fatal Injuries (Person killed immediately or within 30 days of the motor vehicle collision)
  • Latitude and longitude (WGS1984)

Contact: Transportation Data Collection & Analytics

Tags / Keywords
Keywords/tags categorizing the dataset.
Format (CSV, XLS, TXT, PDF, etc)
File format of the dataset.
Dataset Size
Dataset size in megabytes.
50888.0
Metadata Identifier
Metadata identifier – can be used as the unique identifier for catalogue entry
710b179eba564aa58fbb3f34d5d599d9
Published Date
Published date of the dataset.
2026-08-14
Time Period Data Span (start date)
Start date of the data in the dataset.
Time Period Data Span (end date)
End date of time data in the dataset.
GeoSpatial Area Data Span
A spatial region or named place the dataset covers.
Field Value
Access category
Type of access granted for the dataset (open, closed, service, etc).
public
License
License used to access the dataset.
License not specified
Limits on use
Limits on use of data.
Location
Location of the dataset.
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::traffic-collisions-by-location-2017-2024-excluding-2023
Data Service
Data service for accessing a dataset.
Owner
Owner of the dataset.
[email protected]
Contact Point
Who to contact regarding access?
City of Ottawa
Contact Point Email
The email to contact regarding access?
[email protected]
Publisher
Publisher of the dataset.
City of Ottawa
Publisher Email
Email of the publisher.
Author
Author of the dataset.
[email protected]
Author Email
Email of the author.
Accessed At
Date the data and metadata was accessed.
2026-08-17
Field Value
Identifier
Unique identifier for the dataset.
710b179eba564aa58fbb3f34d5d599d9
Language
Language(s) of the dataset
English
Link to dataset description
A URL to an external document describing the dataset.
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::traffic-collisions-by-location-2017-2024-excluding-2023
Persistent Identifier
Data is identified by a persistent identifier.
Globally Unique Identifier
Data is identified by a persistent and globally unique identifier.
Contains data about individuals
Does the data hold data about individuals?
Contains data about identifiable individuals
Does the data hold identifiable data about individual?
Contains Indigenous Data
Does the data hold data about Indigenous communities?
Portal Type
Platform type of the source portal.
Field Value
Version
Version of the datatset
None
Source
Source of the dataset.
None
Version notes
Version notes about the dataset.
Is version of another dataset
Link to dataset that it is a version of.
Other versions
Link to datasets that are versions of it.
Provenance Text
Provenance Text of the data.
City of Ottawa
Provenance URL
Provenance URL of the data.
Temporal resolution
Describes how granular the date/time data in the dataset is.
GeoSpatial resolution in meters
Describes how granular (in meters) geospatial data is in the dataset.
GeoSpatial resolution (in regions)
Describes how granular (in regions) geospatial data is in the dataset.
Field Value
Indigenous Community Permission
Who holds the Indigenous Community Permission. Who to contact regarding access to a dataset that has data about Indigenous communities.
Community Permission
Community permission (who gave permission).
The Indigenous communities the dataset is about
Indigenous communities from which data is derived.
Field Value
Number of data rows
If tabular dataset, total number of rows.
94406
Number of data columns
If tabular dataset, total number of unique columns.
26
Number of data cells
If tabular dataset, total number of cells with data.
2454556
Number of data relations
If RDF dataset, total number of triples.
Number of entities
If RDF dataset, total number of entities.
Number of data properties
If RDF dataset, total number of unique properties used by the triples.
Data quality
Describes the quality of the data in the dataset.
Metric for data quality
A metric used to measure the quality of the data, such as missing values or invalid formats.

0 Comments

Please login or register to comment.