2018 Tabular Transportation Collision Data
- Author(s):
- City of Ottawa
- Description:
- <div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><b>Update frequency:</b><span style='font-family:inherit; font-size:medium;'> Annually</span><br /></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><br /></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><b>Accuracy:</b></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><br /></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'>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.</font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><br /></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><b><i>Collision Data Accuracy:</i></b></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><span style='font-family:inherit; font-size:medium;'><br /></span></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><span style='font-family:inherit; font-size:medium;'>Each reportable collision occurring on public roadways is sent to the City of Ottawa and is validated at least once. </span><span style='font-family:inherit; font-size:medium;'>Approximately 50% of the records are validated once again by a senior staff. Additionally, many queries are run on the database looking for errors.</span></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><br /></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><font size='3' style='font-family:inherit;'><b><i>X & Y Accuracy:</i></b></font></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><span style='font-family:inherit; font-size:medium;'><br /></span></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><span style='font-family:inherit; font-size:medium;'>Collisions are pinned according to information provided by the officer on the Motor Vehicle Collision Report. </span>In some cases, insufficient information was provided, and the collision location is an estimate. </div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><br /></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><b>Attributes:</b></div><div style='font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;'><ul><li>X and Y coordinate format is projected in MTM Zone 9, NAD83 (CSRS)</li><li>KML and CSV/XLS formats are projected in latitude, longitude (WGS84)</li><li>Date</li><li>Time</li><li>Location description (RD1 @ RD2 or RD from RD 1 to RD 2)</li><li>Classification of collision (non-fatal, fatal, property damage only)</li><li>Collision location (Intersection, non-intersection, at/near private driveway)</li><li>Road surface condition (Ice, wet, dry snow...)</li><li>Environment (Clear, rain, snow…)</li><li>Light (daylight, dawn, dusk…)</li><li>Initial impact type (Angle, turning movement, rear-end…)</li><li>Traffic control (stop, traffic signal, no control…)</li><li>No. of Bicycles</li><li>No. of Motorcycles</li><li><span style='font-family:inherit; color:black;'>Max Injury (Highest injury level in the collisions)</span></li><li><span style='font-family:inherit; color:black;'>No. of Injuries </span></li><li><span style='font-family:inherit; color:black;'>No. of Minimal (Person did not go to hospital when leaving the scene of the collision) </span></li><li><span style='font-family:inherit; color:black;'>No. of Minor (Person went to hospital and was treated in the emergency room, but not admitted) </span></li><li><span style='font-family:inherit; color:black;'>No. of Major (Person admitted to hospital. Includes person admitted for observation. This could be either life threatening or non-life threatening)</span></li><li><span style='font-family:inherit; color:black;'>No. of Fatal (Person killed immediately or within 30 days of the motor vehicle collision)</span></li><li>Latitude and longitude</li></ul><div style='font-family:inherit;'><strong>Contact</strong>: <a href='mailto:zac.brydges@ottawa.ca' style='color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit;' target='_blank' rel='nofollow ugc noopener noreferrer'>Transportation Data Collection & Analytics</a></div></div>
- Source Repository:
- Open Ottawa
- Data Source:
- https://open.ottawa.ca/datasets/ottawa::2018-tabular-transportation-collision-data
Download FRDR Metadata
Downloads
Access Data