Traffic Collisions by Location 2014 to 2018 (English, CSV)
Explore the interactive map. Traffic Collisions by Location 2014 to 2018: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Ottawa, updated Aug 2019.
- Format
- CSV
- Access
- Table on demand (prepared when opened) and interactive map
- Fields
- 20
- Publisher-reported update
- 2019-08-16
Locational listing of collisions by year with total of pedestrian and cycling collisions listed and geographically represented on the centroid of the line segment or intersection. 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. Update Frequency : Annually Attributes : • X and Y coordinate format is projected in MTM Zone 9, NAD83 (CSRS) • Year • Location Description (RD1 @ RD2 or RD from RD 1 to RD 2) • Count of all collisions • Count of pedestrian collisions (included in count of all collisions) • Count of Bicycle collisions (included in count of all collisions) • Latitude and longitude Contact : Transportation Data Collection & Analytics
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 |
| LOCATION | esriFieldTypeString |
| GEO_ID | esriFieldTypeString |
| TOTAL_COLLISIONS | esriFieldTypeInteger |
| F2014_TOTAL | esriFieldTypeInteger |
| F2015_TOTAL | esriFieldTypeInteger |
| F2016_TOTAL | esriFieldTypeInteger |
| F2017_TOTAL | esriFieldTypeInteger |
| F2018_TOTAL | esriFieldTypeInteger |
| TOTAL_CYCLIST_COLLISIONS | esriFieldTypeInteger |
| F2014_CYCLIST | esriFieldTypeInteger |
| F2015_CYCLIST | esriFieldTypeInteger |
| F2016_CYCLIST | esriFieldTypeInteger |
| F2017_CYCLIST | esriFieldTypeInteger |
| F2018_CYCLIST | esriFieldTypeInteger |
| TOTAL_PEDESTRIAN_COLLISIONS | esriFieldTypeInteger |
| F2014_PEDESTRIAN | esriFieldTypeInteger |
| F2015_PEDESTRIAN | esriFieldTypeInteger |
| F2016_PEDESTRIAN | esriFieldTypeInteger |
| F2017_PEDESTRIAN | esriFieldTypeInteger |
Sample rows
The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-13. Showing 20 of 25 columns.
| LOCATION | GEO_ID | TOTAL_COLLISIONS | F2014_TOTAL | F2015_TOTAL | F2016_TOTAL | F2017_TOTAL | F2018_TOTAL | TOTAL_CYCLIST_COLLISIONS | F2014_CYCLIST | F2015_CYCLIST | F2016_CYCLIST | F2017_CYCLIST | F2018_CYCLIST | TOTAL_PEDESTRIAN_COLLISIONS | F2014_PEDESTRIAN | F2015_PEDESTRIAN | F2016_PEDESTRIAN | F2017_PEDESTRIAN | F2018_PEDESTRIAN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105 S OF COMMISSIONER ST @ ALBERT ST (0016880) | 16880 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 130 W OF PRESTON ST @ CARLING AVE (0016879) | 16879 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 210 W OF MERIVALE RD @ WEST HUNT CLUB RD (0004688) | 4688 | 26 | 5 | 9 | 5 | 6 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 225 E OF RIVERSIDE DR / T & T SC @ HUNT CLUB RD (0013516) | 13516 | 11 | 2 | 2 | 3 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 |
| 240 S OF CHARLEMAGNE BLVD/DES EPINETTES AVE @ TENTH LINE RD (0014362) | 14362 | 7 | 0 | 3 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 250 N OF KLONDIKE RD @ MARCH RD (0013528) | 13528 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 250 W OF STITTSVILLE MAIN ST @ HAZELDEAN RD (0013521) | 13521 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 275 E OF HAWTHORNE RD/OC TRANSPO TURNAROUND @ HUNT CLUB RD (0016285) | 16285 | 4 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 288 N OR SUNNYSIDE AVE @ BRONSON AVE (0016459) | 16459 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2ND LINE RD @ CABIN RD (0005821) | 5821 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |