2015 Tabular Transportation Collision Data (English, CSV)
Explore the interactive map. 2015 Tabular Transportation Collision Data: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Ottawa, updated Feb 2022.
- Format
- CSV
- Access
- Table on demand (prepared when opened) and interactive map
- Fields
- 20
- Publisher-reported update
- 2022-02-14
Update frequency: Annually 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. 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…
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Explore table (prepared automatically) · Explore map · Access original file
Available fields (20/20)
Fields from the recorded map schema.
| Field | Recorded type |
|---|---|
| ObjectId | esriFieldTypeOID |
| Anom_ID | esriFieldTypeString |
| Accident_Date | esriFieldTypeString |
| Accident_Time | esriFieldTypeString |
| Location | esriFieldTypeString |
| Geo_ID | esriFieldTypeString |
| Accident_Location | esriFieldTypeString |
| Classification_of_Accident | esriFieldTypeString |
| Initial_Impact_Type | esriFieldTypeString |
| Environment_Condition | esriFieldTypeString |
| Light | esriFieldTypeString |
| Road_Surface_Condition | esriFieldTypeString |
| Traffic_Control | esriFieldTypeString |
| Traffic_Control_Condition | esriFieldTypeString |
| No__of_Vehicles | esriFieldTypeInteger |
| No__of_Bicycles | esriFieldTypeInteger |
| No__of_Motorcycles | esriFieldTypeInteger |
| No__of_Pedestrians | esriFieldTypeInteger |
| Max_Injury | esriFieldTypeString |
| No__of_Injuries | esriFieldTypeInteger |
Sample rows
The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-07. Showing 20 of 28 columns.
| Anom_ID | Accident_Date | Accident_Time | Location | Geo_ID | Accident_Location | Classification_of_Accident | Initial_Impact_Type | Environment_Condition | Light | Road_Surface_Condition | Traffic_Control | Traffic_Control_Condition | No__of_Vehicles | No__of_Bicycles | No__of_Motorcycles | No__of_Pedestrians | Max_Injury | No__of_Injuries | No__of_Minimal |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15--1 | 2015/01/01 | 1:15 PM | KING EDWARD AVE @ RIDEAU ST (0002121) | 2121 | 03 - At intersection | 03 - P.D. only | 03 - Rear end | 03 - Snow | 01 - Daylight | 03 - Loose snow | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 15--2 | 2015/01/01 | 1:54 PM | BEATRICE DR @ STRANDHERD DR (0005447) | 5447 | 03 - At intersection | 02 - Non-fatal injury | 05 - Turning movement | 01 - Clear | 01 - Daylight | 01 - Dry | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 01 - Minimal | 1 | 1 |
| 15--3 | 2015/01/01 | 10:00 PM | HIGHWAY 417 btwn HWY417 IC112 RAMP66 & HWY417 IC112 RAMP56 (__3ZA283) | __3ZA283 | 01 - Non intersection | 03 - P.D. only | 07 - SMV other | 03 - Snow | 07 - Dark | 02 - Wet | 10 - No control | 1 | 0 | 0 | 0 | 0 | |||
| 15--4 | 2015/01/01 | 10:37 AM | MEADOWBROOK RD btwn PROGRESS PL & FOXWELL ST (__3ZA8L1) | __3ZA8L1 | 01 - Non intersection | 03 - P.D. only | 07 - SMV other | 01 - Clear | 01 - Daylight | 01 - Dry | 10 - No control | 1 | 0 | 0 | 0 | 0 | |||
| 15--5 | 2015/01/01 | 11:40 PM | HIGHWAY 417 btwn HWY417 IC122 RAMP15 & HWY417 IC121B RAMP51 (__3ZA2RB) | __3ZA2RB | 01 - Non intersection | 02 - Non-fatal injury | 07 - SMV other | 03 - Snow | 07 - Dark | 03 - Loose snow | 10 - No control | 1 | 0 | 0 | 0 | 02 - Minor | 2 | 1 | |
| 15--6 | 2015/01/01 | 11:45 PM | HIGHWAY 417 btwn HWY417 IC122 RAMP51 & HWY417 IC122 RAMP15 (__3ZA2R0) | __3ZA2R0 | 01 - Non intersection | 02 - Non-fatal injury | 04 - Sideswipe | 03 - Snow | 07 - Dark | 03 - Loose snow | 10 - No control | 2 | 0 | 0 | 0 | 02 - Minor | 2 | ||
| 15--7 | 2015/01/01 | 12:30 AM | LAURIER AVE @ O'CONNOR ST (0002224) | 2224 | 03 - At intersection | 03 - P.D. only | 02 - Angle | 01 - Clear | 07 - Dark | 01 - Dry | 01 - Traffic signal | 01 - Functioning | 2 | 0 | 0 | 0 | 0 | ||
| 15--8 | 2015/01/01 | 2:25 PM | ISLAND PARK DR NB btwn TO BE DETERMINED & ISLAND PARK CRES (__3ZA21U) | __3ZA21U | 01 - Non intersection | 03 - P.D. only | 99 - Other | 01 - Clear | 01 - Daylight | 01 - Dry | 10 - No control | 2 | 0 | 0 | 0 | 0 | |||
| 15--9 | 2015/01/01 | 2:55 AM | EVEREST PRIV btwn RUSSELL RD & ST. LAURENT BLVD (e___1GYG) | e___1GYG | 01 - Non intersection | 03 - P.D. only | 07 - SMV other | 01 - Clear | 07 - Dark | 01 - Dry | 10 - No control | 1 | 0 | 0 | 0 | 0 | |||
| 15--10 | 2015/01/01 | 3:11 AM | DAVID DR btwn HOWDEN AVE & SULLIVAN AVE (__3ZAAS2) | __3ZAAS2 | 01 - Non intersection | 03 - P.D. only | 06 - SMV unattended vehicle | 01 - Clear | 07 - Dark | 06 - Ice | 10 - No control | 1 | 0 | 0 | 0 | 0 |