List of crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge from January 2010 through June 2016. Please refer to the dataset "Police Department Crash Data - Updated" for more recent and comprehensive crash data. Please Note: addresses are approximate. Rows for years 2010-2013 were geocoded as part of the MIT Public Safety Data Challenge. Any Latitude/Longitude with a value of 0 indicates that the location was not found though their geocoding efforts. Please see attachment for more details.

A demonstration map of open data crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge from January 2015 through December 2016.

PLEASE NOTE: Geocoding imperfections in this dataset could result in illusory crash "hotspots" appearing on the map. This map is simply meant to be a demonstration of how the open data portal can be used to visualize geospatial trends.

Any data or text that may identify specific persons or companies has been omitted. Please see attached MassTRAC documentation for additional explanation about crash reporting data elements.

Note: crashes involving pedestrians are indicated in the “P1 Non Motorist Desc” and “P2 Mon Motorist Desc” columns. When using Socrata's built in visualization tools to map crashes, please use the geocoded "Location" column. The column "May involve cyclist" specifies whether a given incident may involve a bicycle operator.

List of crashes involving motor vehicles, bicycles and/or pedestrians reported in the City of Cambridge since 2015.

Any data or text that may identify specific persons or companies has been omitted. Please see attached MassTRAC documentation for additional explanation about crash reporting data elements.

Note: crashes involving pedestrians are indicated in the “P1 Non Motorist Desc” and “P2 Mon Motorist Desc” columns. When using Socrata's built in visualization tools to map crashes, please use the geocoded "Location" column. The column "May involve cyclist" specifies whether a given incident may involve a bicycle operator.

List of crashes involving a motorist(s) reported to the City of Cambridge. The log also lists crashes involving a motorist(s) and a bicyclist(s) and/or a pedestrian(s). Any data or text that may identify specific persons or companies has been omitted. Data are updated most days. A more detailed dataset, updated quarterly, can be found here: https://data.cambridgema.gov/Public-Safety/Police-Department-Crash-Data-Updated/gb5w-yva3

Entries involving no motorists, bicyclists or pedestrians are most commonly hit and run crashes involving unoccupied vehicle(s).

The Traffic, Parking &Transportation department has conducted over 600 speed studies since 1987. Some locations have been studied more than once. The speed of each passing vehicle is recorded by radar for an hour each in the morning rush hour, evening rush hour, and midday. From these results, we find the 85th percentile speed for each one-hour period. The 85th percentile speed describes a speed that 85% of drivers are traveling slower than (and 15% of people are driving faster than). Traffic engineers use 85th percentile speed for most traffic safety analyses and design standards. In this dataset, the speed reported is the highest 85th percentile speed for all three one-hour periods studied.