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

Access original file

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.

FieldRecorded type
ObjectIdesriFieldTypeOID
LOCATIONesriFieldTypeString
GEO_IDesriFieldTypeString
TOTAL_COLLISIONSesriFieldTypeInteger
F2014_TOTALesriFieldTypeInteger
F2015_TOTALesriFieldTypeInteger
F2016_TOTALesriFieldTypeInteger
F2017_TOTALesriFieldTypeInteger
F2018_TOTALesriFieldTypeInteger
TOTAL_CYCLIST_COLLISIONSesriFieldTypeInteger
F2014_CYCLISTesriFieldTypeInteger
F2015_CYCLISTesriFieldTypeInteger
F2016_CYCLISTesriFieldTypeInteger
F2017_CYCLISTesriFieldTypeInteger
F2018_CYCLISTesriFieldTypeInteger
TOTAL_PEDESTRIAN_COLLISIONSesriFieldTypeInteger
F2014_PEDESTRIANesriFieldTypeInteger
F2015_PEDESTRIANesriFieldTypeInteger
F2016_PEDESTRIANesriFieldTypeInteger
F2017_PEDESTRIANesriFieldTypeInteger

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.

LOCATIONGEO_IDTOTAL_COLLISIONSF2014_TOTALF2015_TOTALF2016_TOTALF2017_TOTALF2018_TOTALTOTAL_CYCLIST_COLLISIONSF2014_CYCLISTF2015_CYCLISTF2016_CYCLISTF2017_CYCLISTF2018_CYCLISTTOTAL_PEDESTRIAN_COLLISIONSF2014_PEDESTRIANF2015_PEDESTRIANF2016_PEDESTRIANF2017_PEDESTRIANF2018_PEDESTRIAN
105 S OF COMMISSIONER ST @ ALBERT ST (0016880)16880100100000000000000
130 W OF PRESTON ST @ CARLING AVE (0016879)16879200002100001000000
210 W OF MERIVALE RD @ WEST HUNT CLUB RD (0004688)46882659561101000000000
225 E OF RIVERSIDE DR / T & T SC @ HUNT CLUB RD (0013516)135161122313000000100001
240 S OF CHARLEMAGNE BLVD/DES EPINETTES AVE @ TENTH LINE RD (0014362)14362703301000000000000
250 N OF KLONDIKE RD @ MARCH RD (0013528)13528101000000000000000
250 W OF STITTSVILLE MAIN ST @ HAZELDEAN RD (0013521)13521101000000000000000
275 E OF HAWTHORNE RD/OC TRANSPO TURNAROUND @ HUNT CLUB RD (0016285)16285402101000000000000
288 N OR SUNNYSIDE AVE @ BRONSON AVE (0016459)16459100001100001000000
2ND LINE RD @ CABIN RD (0005821)5821100010000000000000

Official sources and licences

Related open data