cambridgema-gov/police-department-crash-data-updated-gb5w-yva3
 
Readme
Updated 5 months ago
Indexed 31 minutes ago

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
V1 Driver Contribution 2v1_driver_contribution_2v1_driver_contribution_2Text
Location (city)location_citylocation_cityText
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumber
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumber
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6Number
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumber
Census Blocks 2010:@computed_region_e4yd_rwk4:@computed_region_e4yd_rwk4Number
Traffic Control Device Functionalitytraffic_control_device_functionalitytraffic_control_device_functionalityText
Work Zonework_zonework_zoneText
V1 Mopedv1_mopedv1_mopedText
V2 Underride Overridev2_underride_overridev2_underride_overrideText
P1 Safety Equipmentp1_safety_equipmentp1_safety_equipmentText
P2 Veh Ownerp2_veh_ownerp2_veh_ownerText
P2 Rolep2_rolep2_roleText
V2 Makev2_makev2_makeTextThe distinctive name applied to the Vehicle by the manufacturer. (e.g., “HONDA,” “FORD”)
P1 Veh Ownerp1_veh_ownerp1_veh_ownerText
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
V1 Underride Overridev1_underride_overridev1_underride_overrideText
P1 Trappedp1_trappedp1_trappedText
V2 Bus Usev2_bus_usev2_bus_useText
Traffic Control Device Typetraffic_control_device_typetraffic_control_device_typeTextIndicates whether the traffic control was functioning at the time of Crash
V2 Driver Distractedv2_driver_distractedv2_driver_distractedText
V2 Trailer Lenv2_trailer_lenv2_trailer_lenText
P2 Drivers Lic Class 1p2_drivers_lic_class_1p2_drivers_lic_class_1Text
V2 Interstatev2_interstatev2_interstateText
P2 Injuryp2_injuryp2_injuryText
V1 Hit and Runv1_hit_and_runv1_hit_and_runText
Intersection Direction 1intersection_direction_1intersection_direction_1Text
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”)
V2 Travel Directionv2_travel_directionv2_travel_directionText
V2 Configurationv2_configurationv2_configurationText
V2 Hit and Runv2_hit_and_runv2_hit_and_runText
P2 Safety Equipmentp2_safety_equipmentp2_safety_equipmentText
V1 Action Prior to Crashv1_action_prior_to_crashv1_action_prior_to_crashText
Speed Limitspeed_limitspeed_limitText
V2 Second Eventv2_second_eventv2_second_eventText
Weather Condition 1weather_condition_1weather_condition_1TextThe weather condition (e.g., “Cloudy,” “Rain,” “Snow”) at the time of the Crash.
V2 Mopedv2_mopedv2_mopedText
V2 Tow Usev2_tow_usev2_tow_useText
P2 Safety Systemp2_safety_systemp2_safety_systemText
V2 Cargo Body Typev2_cargo_body_typev2_cargo_body_typeText
Landmark Distancelanmark_distancelanmark_distanceText
Road Surface Conditionroad_surface_conditionroad_surface_conditionTextThe apparent condition of the road. (e.g., “Wet,” “Dry,” “Snow”)
V1 Driver Distractedv1_driver_distractedv1_driver_distractedText
V2 Is Busv2_is_busv2_is_busText
P1 Drivers Lic Restrictp1_drivers_lic_restrictp1_drivers_lic_restrictText
Manner of Collisionmanner_of_collisionmanner_of_collisionText
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”)
V2 Has Trailerv2_has_trailerv2_has_trailerText
V1 Bus Usev1_bus_usev1_bus_useText
P2 Sexp2_sexp2_sexText
P1 Sexp1_sexp1_sexText
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”)
Landmark Directionlandmark_directionlandmark_directionText
P2 Non Motorist Actionp2_non_motorist_actionp2_non_motorist_actionText
Non Public Areanon_public_areanon_public_areaText
V1 Trailer Reg Typev1_trailer_reg_typev1_trailer_reg_typeText
V1 Tow Usev1_tow_usev1_tow_useText
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”)
Ambient Lightambient_lightambient_lightText
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”)
V1 Is Busv1_is_busv1_is_busText
V2 Gross Weightv2_gross_weightv2_gross_weightText
Date Timedate_timedate_timeCalendar dateDate and Time accident occurred (12:00 AM may represent an unknown time)
Day of Weekday_of_weekday_of_weekText
Object 1object_1object_1TextFirst involved object in this accident (type of vehicle).
Object 2object_2object_2TextSecond involved object in this accident (type of vehicle).
Street Namestreet_namestreet_nameText
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.
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.
First Harmful Eventfirst_harmful_eventfirst_harmful_eventText
Intersection Name 1intersection_name_1intersection_name_1Text
Intersection Name 2intersection_name_2intersection_name_2Text
Intersection Direction 3intersection_direction_3intersection_direction_3Text
Street Directionstreet_directionstreet_directionText
Nearest Intersection Distancenearest_intersection_distancenearest_intersection_distanceText
Nearest Intersection Directionnearest_intersection_directionnearest_intersection_directionText
LandmarklandmarklandmarkText
Mile Marker Directionmile_marker_directionmile_marker_directionText
Road Contributingroad_contributingroad_contributingText
Damaged Property Typedamanged_property_typedamanged_property_typeText
Description of Damaged Propertydescription_of_damaged_propertydescription_of_damaged_propertyText
V1 Registration Typev1_registration_typev1_registration_typeText
v1 State Codev1_state_codev1_state_codeText
V1 Configurationv1_configurationv1_configurationText
V1 Makev1_makev1_makeTextThe distinctive name applied to the Vehicle by the manufacturer. (e.g., “HONDA,” “FORD”)
V1 Occupant Countv1_occupant_countv1_occupant_countText
V1 First Eventv1_first_eventv1_first_eventText
V1 Second Eventv1_second_eventv1_second_eventText
V1 Third Eventv1_third_eventv1_third_eventText
V1 Fourth Eventv1_fourth_eventv1_fourth_eventText
V1 Most Damaged Areav1_most_damaged_areav1_most_damaged_areaText
V1 Second Damaged Areav1_second_damaged_areav1_second_damaged_areaText
V1 Third Damaged Areav1_third_damaged_areav1_third_damaged_areaText
V1 Trailer Reg Platev1_trailer_reg_platev1_trailer_reg_plateText
V1 Trailer Reg Yearv1_trailer_reg_yearv1_trailer_reg_yearText
V1 Trailer Lenv1_trailer_lenv1_trailer_lenText
V1 Is Hazmatv1_is_hazmatv1_is_hazmatText
V2 Registration Typev2_registration_typev2_registration_typeText
V2 State Codev2_state_codev2_state_codeText
V2 Action Prior to Crashv2_action_prior_to_crashv2_action_prior_to_crashText
V2 Model Yearv2_model_yearv2_model_yearTextThe year which is assigned to a Vehicle by the manufacturer
V2 Most Harmful Eventv2_most_harmful_eventv2_most_harmful_eventText
V2 Occupant Countv2_occupant_countv2_occupant_countText
V2 First Eventv2_first_eventv2_first_eventText
V2 Fourth Eventv2_fourth_eventv2_fourth_eventText
V2 Most Damaged Areav2_most_damaged_areav2_most_damaged_areaText
V2 Third Damaged Areav2_third_damaged_areav2_third_damaged_areaText
V2 Trailer Reg Typev2_trailer_reg_typev2_trailer_reg_typeText
V2 Driver Contributionv2_driver_contributionv2_driver_contributionText
V2 Driver Contribution 2v2_driver_contribution_2v2_driver_contribution_2Text
P1 Injuryp1_injuryp1_injuryText
P1 Drivers Lic Statep1_drivers_lic_statep1_drivers_lic_stateText
P1 Drivers Lic Class 2p1_drivers_lic_class_2p1_drivers_lic_class_2Text
P1 Non Motorist Descp1_non_motorist_descp1_non_motorist_descTextWhen Role of involved person is NON-MOTORIST (CYCLIST, PEDESTRIAN, etc.)
P1 Non Motorist Actionp1_non_motorist_actionp1_non_motorist_actionText
P1 Non Motorist Locationp1_non_motorist_locationp1_non_motorist_locationText
P1 Seat Positionp1_seat_positionp1_seat_positionText
P1 Safety Systemp1_safety_systemp1_safety_systemText
P2 Drivers Lic Statep2_drivers_lic_statep2_drivers_lic_stateText
P2 Non Motorist Locationp2_non_motorist_locationp2_non_motorist_locationText
P2 Seat Positionp2_seat_positionp2_seat_positionText
Location (state)location_statelocation_stateText
Location (address)location_addresslocation_addressText
Location (zip)location_ziplocation_zipText
V1 Haz Placardv1_haz_placardv1_haz_placardText
V2 Second Damaged Areav2_second_damaged_areav2_second_damaged_areaText
cambridge_zipcodes:@computed_region_rcj3_ccgu:@computed_region_rcj3_ccguNumber
Intersection Direction 2intersection_direction_2intersection_direction_2Text
V1 Emergency Responsev1_emergency_responsev1_emergency_responseText
V1 Model Yearv1_model_yearv1_model_yearNumberThe year which is assigned to a Vehicle by the manufacturer
V1 Towedv1_towedv1_towedText
V1 Travel Directionv1_travel_directionv1_travel_directionText
V1 Interstatev1_interstatev1_interstateText
V1 Gross Weightv1_gross_weightv1_gross_weightText
V1 Haz Releasev1_haz_releasev1_haz_releaseText
V1 Is Truckv1_is_truckv1_is_truckText
V1 Has Trailerv1_has_trailerv1_has_trailerText
V2 Haz Placardv2_haz_placardv2_haz_placardText
V2 Haz Releasev2_haz_releasev2_haz_releaseText
V2 Is Truckv2_is_truckv2_is_truckText
P1 Rolep1_rolep1_roleText
P2 Drivers Lic Class 2p2_drivers_lic_class_2p2_drivers_lic_class_2Text
P2 Agep2_agep2_ageText
P2 Trappedp2_trappedp2_trappedText
Street Numberstreet_numberstreet_numberText
LocationlocationlocationPointCrash location: either an intersection, address, or nearby street. Locations have been geocoded when possible.
V2 Reg Yearv2_reg_yearv2_reg_yearText
P1 Drivers Lic Class 1p1_drivers_lic_class_1p1_drivers_lic_class_1Text
Cross Streetcross_streetcross_streetText
Near Streetnear_streetnear_streetText
Street or Intersectionstreet_or_intersectionstreet_or_intersectionText
Intersection Name 3intersection_name_3intersection_name_3Text
V1 Most Harmful Eventv1_most_harmful_eventv1_most_harmful_eventText
V1 Cargo Body Typev1_cargo_body_typev1_cargo_body_typeText
V1 Trailer Reg Statev1_trailer_reg_statev1_trailer_reg_stateText
V1 Driver Contributionv1_driver_contributionv1_driver_contributionText
V1 Reg Yearv1_reg_yearv1_reg_yearText
V2 Emergency Responsev2_emergency_responsev2_emergency_responseText
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”)
V2 Third Eventv2_third_eventv2_third_eventText
V2 Towedv2_towedv2_towedText
V2 Trailer Reg Platev2_trailer_reg_platev2_trailer_reg_plateText
V2 Trailer Reg Statev2_trailer_reg_statev2_trailer_reg_stateText
V2 Trailer Reg Yearv2_trailer_reg_yearv2_trailer_reg_yearText
V2 Is Hazmatv2_is_hazmatv2_is_hazmatText
P1 Agep1_agep1_ageText
P2 Drivers Lic Restrictp2_drivers_lic_restrictp2_drivers_lic_restrictText
P2 Non Motorist Descp2_non_motorist_descp2_non_motorist_descTextWhen Role of involved person is NON-MOTORIST (CYCLIST, PEDESTRIAN, etc.)
Upstream Metadata