We recommend consulting the table below to assess which Ottawa collision dataset may be most appropriate for your requirements. There are further details on each dataset below the table.

Please note that the Ottawa Traffic Service and Ottawa Police Service datasets are limited to Carleton University researchers and are less user-friendly than the Open Data Ottawa options.

Dataset Location Date Pedestrians Cyclists Injuries Criminal charges Road conditions Impact type
Traffic collisions by location 2013-2019 (open data) Y Y Y
Tabular transportation collision data 2013-2020 (open data) Y Y Y Y Y
OttawaTrafficServices_2004-2020 Available only to Carleton University researchers Y Y Y Y Y Y Y
OttawaPoliceService_2010-2015 Available only to Carleton University researchers Y Y Y Y Y Y Y Y
OttawaTrafficServices_2008-2013 Available only to Carleton University researchers Y Y Y

The most long-term dataset with injuries & pedestrian information is OttawaTrafficServices_2004-2020.

The most robust/detailed dataset is OttawaPoliceService_2010-2015/Accidents_Collisions_2014-2015.xlsx. The same information for previous years was requested from the Ottawa Police Service but their digital tracking system does not provide that level of detail prior to 2014. Thorough information about accidents and collisions (date, location, criminal charges, road characteristics, vehicle type, etc.).

The OttawaTrafficServices_2008-2013 folder includes both spreadsheets (no pedestrian or injury data) and shapefiles with point locations of accidents. Point shapefile of Ottawa reportable collisions from 2008-2013 that were recorded at intersections within the city of Ottawa. Attribute information includes: Date, Impact Type, Street 1, Street 2, Street 3, X (longitude), Y (latitude).

The Open Data Ottawa datasets are split into two different types: collision by location (2019) and tabular transportation collision data (2020). Both datasets are available in spreadsheet, KML and shapefile formats. As of April 2022, the differences between the two datasets are:

  • Traffic collisions by location: this dataset summarizes all the collisions at a location (e.g. intersection) in a given year. Each row has the annual collision data for for one location which includes total number of collisions, total collisions involving pedestrians, total collisions involving cyclists, and latitude-longitude coordinates (WGS84) and XY coordinates (MTM Zone 9, NAD83) for that location.
  • Tabular transportation collision data: each row is one collision. The data for each collision includes the location (latitude-longitude and XY coordates), date and time, road and environmental conditions, collision classification (fatal, non-fatal, property damage only), initial impact type, and traffic control (stop, traffic signal, etc.).
Data Producer:

City of Ottawa, Ottawa Police Service

Publication Date:
Data Format:
Excel spreadsheet

Grid Coordinate System: Universal Transverse Mercator
Projection: Modified 3 Degree Transverse Mercator Zone 9
Horizontal Geodetic Datum: NAD83
Units: Metres and Square Metres
Spheroid: GRS80 6378137.0 m 6356752.314 m
Central Meridian: -76.5
Easting/Northing Unit: Metres
False Easting: 304800.0
False Northing: 0
Latitude of Origin: 0
Maximum Latitude: 80 00 00
Maximum Longitude: -75 00 00
Minimum Latitude: 0 0 00
Minimum Longitude: -78 00 00
Scale Factor: 0.9999

Authorized Users:
Carleton University students, faculty and staff

Users are required to sign a Data Use Agreement before files may be acquired. All use of the data shall acknowledge the City of Ottawa as the owner of copyright. Data is provided 'as is' and the City of Ottawa makes no warranties as to the condition, quality, completeness or freedom from error of any dataset, or its fitness for a particular use.

Content last reviewed: