cambridgema-gov/police-department-crash-data-updated-gb5w-yva3

 
External

Police Department Crash Data - Updated

  • accident
  • crash
  • motor vehicles
  • vision zero

Police Department Crash Data - Updated

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumber
P2 Non Motorist Descp2_non_motorist_descp2_non_motorist_descTextWhen Role of involved person is NON-MOTORIST (CYCLIST, PEDESTRIAN, etc.)
P2 Drivers Lic Restrictp2_drivers_lic_restrictp2_drivers_lic_restrictText
P1 Drivers Lic Class 1p1_drivers_lic_class_1p1_drivers_lic_class_1Text
V2 Reg Yearv2_reg_yearv2_reg_yearText
V2 Trailer Reg Yearv2_trailer_reg_yearv2_trailer_reg_yearText
V2 Trailer Reg Statev2_trailer_reg_statev2_trailer_reg_stateText
V2 Towedv2_towedv2_towedText
V2 Modelv2_modelv2_modelTextThe manufacturer assigned name denoting a family of Vehicles (within a make) which has a degree of similarity in construction, such as body, chassis, etc. (e.g., “CIVIC,” “TAURUS”)
Intersection Name 3intersection_name_3intersection_name_3Text
Street or Intersectionstreet_or_intersectionstreet_or_intersectionText
LocationlocationlocationPointCrash location: either an intersection, address, or nearby street. Locations have been geocoded when possible.
Near Streetnear_streetnear_streetText
Cross Streetcross_streetcross_streetText
Street Numberstreet_numberstreet_numberText
P2 Trappedp2_trappedp2_trappedText
P2 Agep2_agep2_ageText
P2 Drivers Lic Class 2p2_drivers_lic_class_2p2_drivers_lic_class_2Text
P1 Rolep1_rolep1_roleText
V2 Is Truckv2_is_truckv2_is_truckText
V2 Haz Releasev2_haz_releasev2_haz_releaseText
V2 Haz Placardv2_haz_placardv2_haz_placardText
V2 Emergency Responsev2_emergency_responsev2_emergency_responseText
V1 Has Trailerv1_has_trailerv1_has_trailerText
V1 Is Truckv1_is_truckv1_is_truckText
V1 Haz Releasev1_haz_releasev1_haz_releaseText
V1 Gross Weightv1_gross_weightv1_gross_weightText
V1 Interstatev1_interstatev1_interstateText
V1 Travel Directionv1_travel_directionv1_travel_directionText
V1 Towedv1_towedv1_towedText
V1 Model Yearv1_model_yearv1_model_yearNumberThe year which is assigned to a Vehicle by the manufacturer
V1 Emergency Responsev1_emergency_responsev1_emergency_responseText
Intersection Direction 2intersection_direction_2intersection_direction_2Text
cambridge_zipcodes:@computed_region_rcj3_ccgu:@computed_region_rcj3_ccguNumber
V2 Second Damaged Areav2_second_damaged_areav2_second_damaged_areaText
V1 Haz Placardv1_haz_placardv1_haz_placardText
Location (zip)location_ziplocation_zipText
Location (address)location_addresslocation_addressText
Location (state)location_statelocation_stateText
P2 Seat Positionp2_seat_positionp2_seat_positionText
P2 Non Motorist Locationp2_non_motorist_locationp2_non_motorist_locationText
P2 Drivers Lic Statep2_drivers_lic_statep2_drivers_lic_stateText
P1 Safety Systemp1_safety_systemp1_safety_systemText
P1 Seat Positionp1_seat_positionp1_seat_positionText
P1 Agep1_agep1_ageText
P1 Non Motorist Locationp1_non_motorist_locationp1_non_motorist_locationText
P1 Non Motorist Actionp1_non_motorist_actionp1_non_motorist_actionText
P1 Non Motorist Descp1_non_motorist_descp1_non_motorist_descTextWhen Role of involved person is NON-MOTORIST (CYCLIST, PEDESTRIAN, etc.)
P1 Drivers Lic Class 2p1_drivers_lic_class_2p1_drivers_lic_class_2Text
P1 Drivers Lic Statep1_drivers_lic_statep1_drivers_lic_stateText
P1 Injuryp1_injuryp1_injuryText
V2 Driver Contribution 2v2_driver_contribution_2v2_driver_contribution_2Text
V2 Driver Contributionv2_driver_contributionv2_driver_contributionText
V2 Trailer Reg Platev2_trailer_reg_platev2_trailer_reg_plateText
V2 Trailer Reg Typev2_trailer_reg_typev2_trailer_reg_typeText
V2 Third Damaged Areav2_third_damaged_areav2_third_damaged_areaText
V2 Most Damaged Areav2_most_damaged_areav2_most_damaged_areaText
V2 Fourth Eventv2_fourth_eventv2_fourth_eventText
V2 Third Eventv2_third_eventv2_third_eventText
V2 First Eventv2_first_eventv2_first_eventText
V2 Occupant Countv2_occupant_countv2_occupant_countText
V2 Most Harmful Eventv2_most_harmful_eventv2_most_harmful_eventText
V2 Model Yearv2_model_yearv2_model_yearTextThe year which is assigned to a Vehicle by the manufacturer
V2 Action Prior to Crashv2_action_prior_to_crashv2_action_prior_to_crashText
V2 State Codev2_state_codev2_state_codeText
V2 Registration Typev2_registration_typev2_registration_typeText
V1 Is Hazmatv1_is_hazmatv1_is_hazmatText
V1 Driver Contribution 2v1_driver_contribution_2v1_driver_contribution_2Text
V1 Driver Contributionv1_driver_contributionv1_driver_contributionText
V1 Trailer Lenv1_trailer_lenv1_trailer_lenText
V1 Trailer Reg Yearv1_trailer_reg_yearv1_trailer_reg_yearText
V1 Trailer Reg Statev1_trailer_reg_statev1_trailer_reg_stateText
V1 Trailer Reg Platev1_trailer_reg_platev1_trailer_reg_plateText
V1 Cargo Body Typev1_cargo_body_typev1_cargo_body_typeText
V1 Third Damaged Areav1_third_damaged_areav1_third_damaged_areaText
V1 Second Damaged Areav1_second_damaged_areav1_second_damaged_areaText
V1 Most Damaged Areav1_most_damaged_areav1_most_damaged_areaText
V1 Fourth Eventv1_fourth_eventv1_fourth_eventText
V1 Third Eventv1_third_eventv1_third_eventText
V1 Second Eventv1_second_eventv1_second_eventText
V1 First Eventv1_first_eventv1_first_eventText
V1 Occupant Countv1_occupant_countv1_occupant_countText
V1 Makev1_makev1_makeTextThe distinctive name applied to the Vehicle by the manufacturer. (e.g., “HONDA,” “FORD”)
V1 Configurationv1_configurationv1_configurationText
v1 State Codev1_state_codev1_state_codeText
V1 Registration Typev1_registration_typev1_registration_typeText
Description of Damaged Propertydescription_of_damaged_propertydescription_of_damaged_propertyText
Damaged Property Typedamanged_property_typedamanged_property_typeText
Road Contributingroad_contributingroad_contributingText
Mile Marker Directionmile_marker_directionmile_marker_directionText
LandmarklandmarklandmarkText
Nearest Intersection Directionnearest_intersection_directionnearest_intersection_directionText
Nearest Intersection Distancenearest_intersection_distancenearest_intersection_distanceText
Street Directionstreet_directionstreet_directionText
Intersection Direction 3intersection_direction_3intersection_direction_3Text
Intersection Name 2intersection_name_2intersection_name_2Text
Intersection Name 1intersection_name_1intersection_name_1Text
First Harmful Eventfirst_harmful_eventfirst_harmful_eventText
May Involve Pedestrianmay_involve_pedestrianmay_involve_pedestrianTextThis calculated field indicates whether each crash might involve cyclist. The field is calculated by searching for the text string "pedestrian" within each column for a given row. The keyword "walk" was not used so as to avoid the risk of false positives from the phrase "walk signal." This new column has been included to expedite analysis of the City's crash data for bicycle safety. We are confident that it has caught the vast majority of pedestrian related incidents in this dataset, but please be advised that no text search algorithm is perfect, and this one may not account for 100 percent of pedestrian-related incidents.
May involve cyclistmay_involve_cyclistmay_involve_cyclistTextThis calculated field indicates whether each crash might involve cyclist. The field is calculated by searching for the text strings "bicycle," "pedalcycle," or "cycli" within each column for a given row. The keyword "cycle" was not used so as to avoid the risk of false positives from the word "motorcycle." This new column has been included to expedite analysis of the City's crash data for bicycle safety. We are confident that it has caught the vast majority of bicycle related incidents in this dataset, but please be advised that no text search algorithm is perfect, and this one may not account for 100 percent of bicycle-related incidents.
Street Namestreet_namestreet_nameText
Object 2object_2object_2TextSecond involved object in this accident (type of vehicle).
Object 1object_1object_1TextFirst involved object in this accident (type of vehicle).
Day of Weekday_of_weekday_of_weekText
Date Timedate_timedate_timeCalendar dateDate and Time accident occurred (12:00 AM may represent an unknown time)
V2 Gross Weightv2_gross_weightv2_gross_weightText
V1 Is Busv1_is_busv1_is_busText
Roadway Junction Typeroadway_junction_typeroadway_junction_typeTextA code which uniquely identifies a roadway junction type. A junction is either an intersection or the connection between a driveway access and a roadway other than a driveway access. (e.g., “T-intersection,” “Four-way intersection”)
Ambient Lightambient_lightambient_lightText
Trafficway Descriptiontrafficway_descriptiontrafficway_descriptionTextIndicates whether or not a trafficway is divided and whether it serves one-way or two-way traffic. (e.g., “One-way, not divided,” “Two-way, divided”)
V1 Tow Usev1_tow_usev1_tow_useText
V1 Trailer Reg Typev1_trailer_reg_typev1_trailer_reg_typeText
Non Public Areanon_public_areanon_public_areaText
P2 Non Motorist Actionp2_non_motorist_actionp2_non_motorist_actionText
Landmark Directionlandmark_directionlandmark_directionText
V1 Modelv1_modelv1_modelTextThe manufacturer assigned name denoting a family of Vehicles (within a make) which has a degree of similarity in construction, such as body, chassis, etc. (e.g., “CIVIC,” “TAURUS”)
P1 Sexp1_sexp1_sexText
P2 Sexp2_sexp2_sexText
V2 Is Hazmatv2_is_hazmatv2_is_hazmatText
V1 Bus Usev1_bus_usev1_bus_useText
V2 Has Trailerv2_has_trailerv2_has_trailerText
Weather Condition 2weather_condition_2weather_condition_2TextThis data attribute is captured only if there is more than one weather condition type needed to be captured. (e.g., Weather Condition 1 = “Cloudy”; Weather Condition 2 = “Rain”)
Manner of Collisionmanner_of_collisionmanner_of_collisionText
P1 Drivers Lic Restrictp1_drivers_lic_restrictp1_drivers_lic_restrictText
V2 Is Busv2_is_busv2_is_busText
V1 Driver Distractedv1_driver_distractedv1_driver_distractedText
Road Surface Conditionroad_surface_conditionroad_surface_conditionTextThe apparent condition of the road. (e.g., “Wet,” “Dry,” “Snow”)
Landmark Distancelanmark_distancelanmark_distanceText
V2 Cargo Body Typev2_cargo_body_typev2_cargo_body_typeText
P2 Safety Systemp2_safety_systemp2_safety_systemText
V2 Tow Usev2_tow_usev2_tow_useText
V2 Mopedv2_mopedv2_mopedText
V1 Reg Yearv1_reg_yearv1_reg_yearText
Weather Condition 1weather_condition_1weather_condition_1TextThe weather condition (e.g., “Cloudy,” “Rain,” “Snow”) at the time of the Crash.
V2 Second Eventv2_second_eventv2_second_eventText
Speed Limitspeed_limitspeed_limitText
V1 Action Prior to Crashv1_action_prior_to_crashv1_action_prior_to_crashText
P2 Safety Equipmentp2_safety_equipmentp2_safety_equipmentText
V2 Hit and Runv2_hit_and_runv2_hit_and_runText
V2 Configurationv2_configurationv2_configurationText
V1 Most Harmful Eventv1_most_harmful_eventv1_most_harmful_eventText
V2 Travel Directionv2_travel_directionv2_travel_directionText
First Harmful Event Locationfirst_harmful_event_locationfirst_harmful_event_locationTextThe injury or damage producing event which characterizes the Crash type and identifies the nature of the first harmful event. (e.g., “Collision with motor vehicle,” “Collision with guardrail”)
Intersection Direction 1intersection_direction_1intersection_direction_1Text
V1 Hit and Runv1_hit_and_runv1_hit_and_runText
P2 Injuryp2_injuryp2_injuryText
V2 Interstatev2_interstatev2_interstateText
P2 Drivers Lic Class 1p2_drivers_lic_class_1p2_drivers_lic_class_1Text
V2 Trailer Lenv2_trailer_lenv2_trailer_lenText
V2 Driver Distractedv2_driver_distractedv2_driver_distractedText
Traffic Control Device Typetraffic_control_device_typetraffic_control_device_typeTextIndicates whether the traffic control was functioning at the time of Crash
V2 Bus Usev2_bus_usev2_bus_useText
P1 Trappedp1_trappedp1_trappedText
V1 Underride Overridev1_underride_overridev1_underride_overrideText
School Bus Relatedschool_bus_relatedschool_bus_relatedTextIndicates whether a school bus is related to the Crash. The school bus must be directly involved as a contact vehicle or indirectly involved as a non-contact vehicle
P1 Veh Ownerp1_veh_ownerp1_veh_ownerText
V2 Makev2_makev2_makeTextThe distinctive name applied to the Vehicle by the manufacturer. (e.g., “HONDA,” “FORD”)
P2 Rolep2_rolep2_roleText
P2 Veh Ownerp2_veh_ownerp2_veh_ownerText
P1 Safety Equipmentp1_safety_equipmentp1_safety_equipmentText
V2 Underride Overridev2_underride_overridev2_underride_overrideText
V1 Mopedv1_mopedv1_mopedText
Work Zonework_zonework_zoneText
Traffic Control Device Functionalitytraffic_control_device_functionalitytraffic_control_device_functionalityText
Census Blocks 2010:@computed_region_e4yd_rwk4:@computed_region_e4yd_rwk4Number
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6Number
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumber
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumber
Location (city)location_citylocation_cityText

Upstream Metadata