Description

more
For more information about the contents of each table, download the codebook.This layer/table is part of the Transportation-Health Database, developed in a joint partnership between the Los Angeles County Public Health Department and the City of Los Angeles Department of Transportation. For related tables/features, look below in "Related Datasets." All of the data tables are designed to be viewed by joining them to the intersection layer, "GeomIntersections." Join the "boeint_fkey" field in the table with the "boeint_pkey" field in the GeomIntersections feature layer. This project is in part supported by funding from the Centers for Disease Control and Prevention, Cooperative Agreement No. 1U58DP005509-01, through the Los Angeles County Department of Public Health.

Dataset Attributes

  • OBJECTID
    Number
  • Join_Count
    Number
    0 to 1
  • TARGET_FID
    Number
    1 to 173714
  • CASE_ID
    Text
    {"value"=>"5739130", "count"=>1} (), {"value"=>"5342411", "count"=>1} (), {"value"=>"5321434", "count"=>1} (), {"value"=>"4858698", "count"=>1} (), {"value"=>"4847074", "count"=>1} (), {"value"=>"4844054", "count"=>1} (), {"value"=>"6073562", "count"=>1} (), {"value"=>"5975118", "count"=>1} (), {"value"=>"5740778", "count"=>1} (), {"value"=>"5529581", "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"=>"32565", "count"=>906} (), {"value"=>"33779", "count"=>829} (), {"value"=>"38033", "count"=>776} (), {"value"=>"36752", "count"=>762} (), {"value"=>"R2138", "count"=>724} (), {"value"=>"31573", "count"=>709} (), {"value"=>"37146", "count"=>679} (), {"value"=>"34674", "count"=>667} (), {"value"=>"36607", "count"=>665} (), {"value"=>"38850", "count"=>647} ()
  • REPORTING_DISTRICT
    Text
    {"value"=>"0645", "count"=>659} (), {"value"=>"1309", "count"=>632} (), {"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"=>"1591", "count"=>394} (), {"value"=>"0192", "count"=>385} ()
  • 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"=>"3TL5", "count"=>1887} (), {"value"=>"1TL11", "count"=>1861} (), {"value"=>"11TL32", "count"=>1447} (), {"value"=>"901", "count"=>1369} (), {"value"=>"13T53", "count"=>1303} (), {"value"=>"9T53", "count"=>1202} (), {"value"=>"13TL22", "count"=>1088} (), {"value"=>"19T73", "count"=>974} (), {"value"=>"10T35", "count"=>883} (), {"value"=>"9T57", "count"=>879} ()
  • PRIMARY_RD
    Text
    {"value"=>"PICO BL", "count"=>1615} (), {"value"=>"WILSHIRE BL", "count"=>1598} (), {"value"=>"VANOWEN ST", "count"=>1581} (), {"value"=>"CRENSHAW BL", "count"=>1248} (), {"value"=>"MAIN ST", "count"=>1161} (), {"value"=>"SATICOY ST", "count"=>1142} (), {"value"=>"CENTRAL AV", "count"=>1133} (), {"value"=>"RT 101", "count"=>863} (), {"value"=>"MELROSE AV", "count"=>856} (), {"value"=>"HIGHLAND AV", "count"=>798} ()
  • SECONDARY_RD
    Text
    {"value"=>"PICO BL", "count"=>1088} (), {"value"=>"MAIN ST", "count"=>1069} (), {"value"=>"VANOWEN ST", "count"=>977} (), {"value"=>"SATICOY ST", "count"=>875} (), {"value"=>"WILSHIRE BL", "count"=>871} (), {"value"=>"CENTRAL AV", "count"=>712} (), {"value"=>"MELROSE AV", "count"=>522} (), {"value"=>"GRAND AV", "count"=>500} (), {"value"=>"RIVERSIDE DR", "count"=>469} (), {"value"=>"FOUNTAIN AV", "count"=>385} ()
  • 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
  • ROUTE_SUFFIX
    Text
  • 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
  • OID_1
    Number
  • Accident_Number
    Number
  • Report_Number
    Text
  • Collision_date_1
    Date
  • Collision_Time_1
    Date
  • Collision_Day_of
    Text
  • Number_of_Partie
    Number
  • Party_at_Fault
    Number
  • PCF_Type
    Text
  • Code_of_Violatio
    Text
  • Primary_Collisio
    Text
  • Hit_and_Run_1
    Text
  • Collision_Type
    Text
  • Involved_With
    Text
  • Pedestrian_Actio
    Text
  • Private_Property
    Number
  • Officer_ID_1
    Text
  • Officer_Name
    Text
  • Jurisdiction
    Text
  • Jurisdiction_Typ
    Text
  • Reporting_Distri
    Text
  • City_ID
    Text
  • Violation
    Text
  • Violation_Subsec
    Text
  • IntID
    Number
  • ASSETID
    Number

About

  • By on October 5, 2016
  • Updated 12 months ago

Related Datasets