cityoftacoma/tacoma-traffic-collision-data-2010-bie8-awgp
Icon for Socrata external plugin
 
Readme
Updated over 1 year ago
Indexed 2 hours ago

Tacoma Traffic Collision Data 2010-

All collisions within the City boundaries from 2010-Q22019. Data is from WSDOT.

Federal highway safety laws require the state to create this crash database for use in obtaining federal safety improvement funds. Under Section 409 of Title 23 of the United States Code, crash data is prohibited from use in any litigation against state, tribal or local government that involves the location(s) mentioned in the crash data.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
TOTAL PEDESTRIANS INVOLVEDtotal_pedestrians_involvedtotal_pedestrians_involvedNumber
Report Numberreport_numberreport_numberTextUnique identifier for all collisions
TOTAL BICYCLISTS INVOLVEDtotal_bicyclists_involvedtotal_bicyclists_involvedNumber
Bicyclist 2 actionbicyclist2_actionbicyclist2_actionTextAction of bicyclist 2
Bicyclist 1 actionbicyclist1_actionbicyclist1_actionTextAction of bicyclist 1
New Georeferenced Columngeocoded_columngeocoded_columnPoint
Hit and Runhit_and_runhit_and_runCheckbox
DATEdatedateCalendar date
24 Hr Time_24_hr_time_24_hr_timeText
Total Evident Injuriestotal_evident_injuriestotal_evident_injuriesNumber
TOTAL PEDESTRIANS AND BICYCLISTS INVOLVEDtotal_pedestrians_and_bicyclists_involvedtotal_pedestrians_and_bicyclists_involvedNumber
Hour of Dayhour_of_dayhour_of_dayNumberShows time just as the hour.
Total Serious Injuriestotal_serious_injuriestotal_serious_injuriesNumber
Collision Involving School-Aged Pedestrian or Bicyclistcollision_involving_school_aged_pedestrian_or_bicycalistcollision_involving_school_aged_pedestrian_or_bicycalistText
ROAD SURFACE CONDITIONSroad_surface_conditionsroad_surface_conditionsText
LIGHTING CONDITIONSlighting_conditionslighting_conditionsText
Day of Weekday_of_weekday_of_weekPointDay of the week displayed as number Monday=1, Sunday= 7
School Hoursschool_hoursschool_hoursCheckboxSchool hours are interpreted as occurring between 7am and 5pm.
Most Severe sobriety typemost_severe_sobriety_typemost_severe_sobriety_typeTextIndicates the state of sobriety for the driver.
Bicyclist 3 actionbicyclist3_actionbicyclist3_actionTextAction of bicyclist 3
Zip Codes:@computed_region_29ft_c7g5:@computed_region_29ft_c7g5Number
New Georeferenced Column_1geocoded_column_1geocoded_column_1Point
TOTAL FATALITIEStotal_fatalitiestotal_fatalitiesNumber
Collision Involving Pedestrian or Bicyclistcollision_involving_pedestrian_or_bicyclistcollision_involving_pedestrian_or_bicyclistCheckbox
Pedestrian 2 actionpedestrian2_actionpedestrian2_actionTextAction of pedestrian 2
Pedestrian 1 actionpedestrian1_actionpedestrian1_actionTextaction of pedestrian 1
vehicle 3 actionvehicle_3_actionvehicle_3_actionTextaction of vehicle 3
vehicle 2 actionvehicle2_actionvehicle2_actionTextAction of vehicle 2
vehicle 1 actionvehicle_1_actionvehicle_1_actionTextaction of vehicle 1
Junction Relationshipjunction_relationshipjunction_relationshipTextCollision relationship to junction.
MOST SEVERE INJURY TYPEmost_severe_injury_typemost_severe_injury_typeText
Incidentincident_incident_NumberEach row represents 1 incident.
WEATHERweatherweatherText
Age Between 5 and 18age_between_5_and_18age_between_5_and_18CheckboxIndicates if the pedestrian or bicyclist involved was between the ages of 5 and 18.
YearyearyearTextYear of collision
Total Possible Injuriestotal_possible_injuriestotal_possible_injuriesNumber
 
Preview
  • tacoma_traffic_collision_data_2010
     
Upstream Metadata