2019 Tabular Transportation Collision Data
2019 transportation collision data. Refer to the description for detailed information.
Update frequency: AnnuallyAccuracy:
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.
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
Datasets available for download
-
2019_Tabular_Transportation_Collision_DataFeature Layer
Layer 0 via ArcGIS REST API
-
2019_Tabular_Transportation_Collision_Data (Explore)HTML
Explore 2019_Tabular_Transportation_Collision_Data on ArcGIS Hub
Additional Info
| Field | Value |
|---|---|
| Last Updated | March 24, 2026, 20:40 (UTC) |
| Created | March 24, 2026, 20:40 (UTC) |
|
Domain / Topic
Domain or topic of the dataset being cataloged.
|
|
|
Title
Title for the Dataset.
|
2019 Tabular Transportation Collision Data |
|
Description
A description of the dataset.
|
2019 transportation collision data. Refer to the description for detailed information. Update frequency: AnnuallyAccuracy: 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. Attributes:
|
|
Tags / Keywords
Keywords/tags categorizing the dataset.
|
|
|
Format (CSV, XLS, TXT, PDF, etc)
File format of the dataset.
|
|
|
Dataset Size
Dataset size in megabytes.
|
11296.0 |
|
Metadata Identifier
Metadata identifier – can be used as the unique identifier for catalogue entry
|
|
|
Published Date
Published date of the dataset.
|
2022-01-26 |
|
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.
|
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0 |
|
Limits on use
Limits on use of data.
|
|
|
Location
Location of the dataset.
|
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::2019-tabular-transportation-collision-data |
|
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.
|
2024-07-08 |
| Field | Value |
|---|---|
|
Identifier
Unique identifier for the dataset.
|
9a91a607e0854bb68371980d29835574 |
|
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::2019-tabular-transportation-collision-data |
|
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.
|
16399 |
|
Number of data columns
If tabular dataset, total number of unique columns.
|
48 |
|
Number of data cells
If tabular dataset, total number of cells with data.
|
787152 |
|
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