Description

more
For more information on the attributes associated with collisions, please download the codebook.Collected SWITRS (Statewide Integrated Traffic Records System) Data from 2009 - 2013. Geocoded and prepared by RoadSafe GIS  All collisions on non-state highways marked in SWITRS as occurring in LA City jurisdictionCollisions on state highways where all or a portion of the highway is a surface street:State highways 42, 213, 1, 27 (and the intersection of Ferry@Seaside and Navy@Seaside on SR 47)State highway 110 – All between postmile values 0 and .745State highway 170 – All between postmile values 9 and 10.61State highway 2– All postmile values below 14.08 (Glendale Fwy begins)Collisions at ramp intersections with local roads. In some cases it can be difficult to distinguish an intersection with a local road or another ramp segment. However, all the collisions with these ramp values are included: 1 – Ramp Exit, Last 50 Feet3 – Ramp Entry, First 50 Feet4 – Not State Highway, Ramp-related, Within 100 Feet5 – Intersection6 – Not State Highway, Intersection-related, Within 250 FeetAdditional fields in the collision data table for a standardized matching address (match_addr), primary road name (m_primaryr), secondary road name (m_secondrd). These are very useful fields for ranking by intersections. RoadSafe GIS utilizes these fields for generating rankings by various safety performance functions.Party and victim data tables that correspond to the SWITRS collision file.Note that the field names have been updated to reflect the original headers provided by CHP in addition to our several added fields. You can access their raw data template here.

Dataset Attributes

  • OBJECTID
    Number
  • CASE_ID
    Text
    {"value"=>"4799949", "count"=>1} (), {"value"=>"4758437", "count"=>1} (), {"value"=>"4349756", "count"=>1} (), {"value"=>"4335330", "count"=>1} (), {"value"=>"5984959", "count"=>1} (), {"value"=>"5482868", "count"=>1} (), {"value"=>"5415071", "count"=>1} (), {"value"=>"5321784", "count"=>1} (), {"value"=>"4914265", "count"=>1} (), {"value"=>"4455003", "count"=>1} ()
  • ACCIDENT_YEAR
    Number
    2009 to 2013
  • PROCDATE
    Date
    1231977600000 to 1437350400000
  • JURIS
    Number
    1942 to 9590
  • COLLISION_DATE
    Date
    1230768000000 to 1388448000000
  • COLLISION_TIME
    Number
    0 to 2500
  • OFFICER_ID
    Text
    {"value"=>"R2138", "count"=>724} (), {"value"=>"37146", "count"=>679} (), {"value"=>"38383", "count"=>497} (), {"value"=>"38365", "count"=>453} (), {"value"=>"36256", "count"=>449} (), {"value"=>"35836", "count"=>417} (), {"value"=>"39028", "count"=>416} (), {"value"=>"39565", "count"=>395} (), {"value"=>"37800", "count"=>393} (), {"value"=>"39291", "count"=>335} ()
  • REPORTING_DISTRICT
    Text
    {"value"=>"0646", "count"=>541} (), {"value"=>"0666", "count"=>453} (), {"value"=>"1265", "count"=>427} (), {"value"=>"1269", "count"=>425} (), {"value"=>"2029", "count"=>410} (), {"value"=>"1555", "count"=>403} (), {"value"=>"0192", "count"=>385} (), {"value"=>"1243", "count"=>369} (), {"value"=>"0941", "count"=>353} (), {"value"=>"1162", "count"=>337} ()
  • DAY_OF_WEEK
    Text
    {"value"=>"5", "count"=>27685} (), {"value"=>"6", "count"=>25298} (), {"value"=>"4", "count"=>24759} (), {"value"=>"2", "count"=>24690} (), {"value"=>"3", "count"=>24329} (), {"value"=>"1", "count"=>24088} (), {"value"=>"7", "count"=>22865} ()
  • SHIFT
    Text
    {"value"=>"5", "count"=>168106} (), {"value"=>"2", "count"=>2544} (), {"value"=>"1", "count"=>2421} (), {"value"=>"3", "count"=>631} (), {"value"=>"4", "count"=>12} ()
  • POPULATION
    Text
    {"value"=>"7", "count"=>173714} ()
  • CNTY_CITY_LOC
    Text
    {"value"=>"1942", "count"=>173714} ()
  • SPECIAL_COND
    Text
    {"value"=>"0", "count"=>172462} (), {"value"=>"1", "count"=>1252} ()
  • BEAT_TYPE
    Text
    {"value"=>"0", "count"=>168106} (), {"value"=>"1", "count"=>3837} (), {"value"=>"4", "count"=>1167} (), {"value"=>"3", "count"=>349} (), {"value"=>"2", "count"=>255} ()
  • CHP_BEAT_TYPE
    Text
    {"value"=>"0", "count"=>168106} (), {"value"=>"1", "count"=>2298} (), {"value"=>"S", "count"=>1299} (), {"value"=>"2", "count"=>868} (), {"value"=>"3", "count"=>626} (), {"value"=>"5", "count"=>349} (), {"value"=>"4", "count"=>132} (), {"value"=>"A", "count"=>36} ()
  • CITY_DIVISION_LAPD
    Text
    {"value"=>"L", "count"=>10172} (), {"value"=>"O", "count"=>8737} (), {"value"=>"C", "count"=>8130} (), {"value"=>"M", "count"=>8129} (), {"value"=>"J", "count"=>8105} (), {"value"=>"K", "count"=>7995} (), {"value"=>"Q", "count"=>7959} (), {"value"=>"N", "count"=>7815} (), {"value"=>"G", "count"=>7653} (), {"value"=>"H", "count"=>7478} ()
  • CHP_BEAT_CLASS
    Text
    {"value"=>"0", "count"=>168106} (), {"value"=>"2", "count"=>5415} (), {"value"=>"1", "count"=>193} ()
  • BEATNUMB
    Text
    {"value"=>"1TL11", "count"=>1861} (), {"value"=>"11TL32", "count"=>1447} (), {"value"=>"9T53", "count"=>1202} (), {"value"=>"19T73", "count"=>974} (), {"value"=>"9T57", "count"=>879} (), {"value"=>"15T43", "count"=>816} (), {"value"=>"21TL65", "count"=>552} (), {"value"=>"17TL15", "count"=>533} (), {"value"=>"16TL23", "count"=>514} (), {"value"=>"21T65", "count"=>436} ()
  • PRIMARY_RD
    Text
    {"value"=>"PICO BL", "count"=>1615} (), {"value"=>"VANOWEN ST", "count"=>1581} (), {"value"=>"MAIN ST", "count"=>1161} (), {"value"=>"CENTRAL AV", "count"=>1133} (), {"value"=>"DEVONSHIRE ST", "count"=>615} (), {"value"=>"RIVERSIDE DR", "count"=>613} (), {"value"=>"PACIFIC AV", "count"=>481} (), {"value"=>"RT 5", "count"=>417} (), {"value"=>"GRAND AV", "count"=>417} (), {"value"=>"HILL ST", "count"=>409} ()
  • SECONDARY_RD
    Text
    {"value"=>"PICO BL", "count"=>1088} (), {"value"=>"VANOWEN ST", "count"=>977} (), {"value"=>"GRAND AV", "count"=>500} (), {"value"=>"HILL ST", "count"=>306} (), {"value"=>"BUDLONG AV", "count"=>280} (), {"value"=>"PACIFIC AV", "count"=>229} (), {"value"=>"LANARK ST", "count"=>210} (), {"value"=>"29TH ST", "count"=>195} (), {"value"=>"76TH ST", "count"=>187} (), {"value"=>"20TH ST", "count"=>179} ()
  • DISTANCE
    Number
    0 to 1980000
  • DIRECTION
    Text
    {"value"=>"S", "count"=>29922} (), {"value"=>"N", "count"=>29516} (), {"value"=>"E", "count"=>28196} (), {"value"=>"W", "count"=>27413} ()
  • INTERSECTION
    Text
    {"value"=>"N", "count"=>118188} (), {"value"=>"Y", "count"=>54195} (), {"value"=>"-", "count"=>1331} ()
  • WEATHER_1
    Text
    {"value"=>"A", "count"=>152155} (), {"value"=>"B", "count"=>14360} (), {"value"=>"C", "count"=>6041} (), {"value"=>"-", "count"=>698} (), {"value"=>"E", "count"=>247} (), {"value"=>"F", "count"=>106} (), {"value"=>"G", "count"=>95} (), {"value"=>"D", "count"=>12} ()
  • WEATHER_2
    Text
    {"value"=>"-", "count"=>171825} (), {"value"=>"C", "count"=>1362} (), {"value"=>"G", "count"=>303} (), {"value"=>"B", "count"=>161} (), {"value"=>"F", "count"=>41} (), {"value"=>"E", "count"=>21} (), {"value"=>"D", "count"=>1} ()
  • STATE_HWY_IND
    Text
    {"value"=>"N", "count"=>166428} (), {"value"=>"Y", "count"=>7233} ()
  • CALTRANS_COUNTY
    Text
    {"value"=>"LA", "count"=>7120} (), {"value"=>"ORA", "count"=>1} ()
  • CALTRANS_DISTRICT
    Number
    0 to 12
  • STATE_ROUTE
    Number
    0 to 710
  • ROUTE_SUFFIX
    Text
    {"value"=>"-", "count"=>7098} (), {"value"=>"U", "count"=>16} (), {"value"=>"S", "count"=>7} ()
  • POSTMILE_PREFIX
    Text
  • POSTMILE
    Number
  • LOCATION_TYPE
    Text
  • RAMP_INTERSECTION
    Text
  • SIDE_OF_HWY
    Text
  • TOW_AWAY
    Text
  • COLLISION_SEVERITY
    Text
  • NUMBER_KILLED
    Number
  • NUMBER_INJURED
    Number
  • PARTY_COUNT
    Number
  • PRIMARY_COLL_FACTOR
    Text
  • PCF_CODE_VIOL
    Text
  • PCF_VIOL_CATEGORY
    Text
  • PCF_VIOLATION
    Number
  • PCF_VIOL_SUBSECTION
    Text
  • HIT_AND_RUN
    Text
  • TYPE_OF_COLLISION
    Text
  • MVIW
    Text
  • PED_ACTION
    Text
  • ROAD_SURFACE
    Text
  • ROAD_COND_1
    Text
  • ROAD_COND_2
    Text
  • LIGHTING
    Text
  • CONTROL_DEVICE
    Text
  • CHP_ROAD_TYPE
    Text
  • PEDESTRIAN_ACCIDENT
    Text
  • BICYCLE_ACCIDENT
    Text
  • MOTORCYCLE_ACCIDENT
    Text
  • TRUCK_ACCIDENT
    Text
  • NOT_PRIVATE_PROPERTY
    Text
  • ALCOHOL_INVOLVED
    Text
  • STWD_VEHTYPE_AT_FAULT
    Text
  • CHP_VEHTYPE_AT_FAULT
    Text
  • COUNT_SEVERE_INJ
    Number
  • COUNT_VISIBLE_INJ
    Number
  • COUNT_COMPLAIN_PAIN
    Number
  • COUNT_PED_KILLED
    Number
  • COUNT_PED_INJURED
    Number
  • COUNT_BICYCLIST_KILLED
    Number
  • COUNT_BICYCLIST_INJURED
    Number
  • COUNT_MC_KILLED
    Number
  • COUNT_MC_INJURED
    Number
  • PRIMARY_RAMP
    Text
  • SECONDARY_RAMP
    Text
  • LATITUDE
    Number
  • LONGITUDE
    Number
  • TIMECAT
    Number
  • MONTH_
    Number
  • CITY
    Text
  • COUNTY
    Text
  • STATE
    Text
  • POINT_X
    Number
  • POINT_Y
    Number
  • Match_addr
    Text
  • m_primaryrd
    Text
  • m_secondrd
    Text

Related Datasets