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.
The most long-term dataset with injuries & pedestrian information is in the folder OttawaTrafficServices_2004-2018.
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 (2019). Both datasets are available in spreadsheet, KML and shapefile formats. As of January 18, 2021, 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.).