SWITRS Collision
Raw Data Export Layout
2/1/2013
Item Name |
Datatype(Length) |
Description |
Possible Values |
Case Id |
Varchar2(19) |
the unique identifier of the collision report
(barcode beginning 2002; 19 digit code prior to 2002) |
|
Collision Year |
Number(4) |
the year when the collision occurred |
|
Process Date |
Number(8) |
(YYYYMMDD) |
|
Jurisdiction |
Number(4) |
Four numerics assigned by
DOJ |
|
Collision Date |
Number(8) |
the date when the collision occurred (YYYYMMDD) |
|
Collision Time |
Number(4) |
the time when the collision occurred (24 hour time) |
Data may appear with no leading zero(s). |
Officer Id |
Varchar2(8) |
|
|
Reporting District |
Varchar2(5) |
|
|
Day of Week |
Char(1) |
the code for the day of the week when the collision
occurred |
1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday 7 - Sunday |
CHP Shift |
Char(1) |
|
1 - 0600 thru 1359 2 - 1400 thru 2159 3 - 2200 thru 0559 4 - CHP Not Stated 5 - Not CHP |
Population |
Char(1) |
|
1 - Incorporated (less than
2500) 2 - Incorporated (2500 -
10000) 3 - Incorporated (10000 -
25000) 4 - Incorporated (25000 -
50000) 5 - Incorporated (50000 -
100000) 6 - Incorporated (100000 -
250000) 7 - Incorporated (over
250000) 9 - Unincorporated (Rural) 0 - University (Private
Property) - - Not Stated |
|
Varchar2(4) |
the location code of where the collision occurred |
Data may appear with no leading zero. |
Special Condition |
Char(1) |
|
1 - Schoolbus
on Public Roadway (CHP Beat or CHP Adm Beat 901) 2 - 3 - Schoolbus
Not on Public Roadway (CHP Adm Beat 903) 4 - Offroad
(Unimproved) (CHP Adm Beat 906, 907) 5 - Vista Point or Rest
Area (CHP Adm Beat 903) or Scales or Inspection
Facility (CHP Com Beat 860-898) 6 - Other Public Access
(Improved) (CHP Adm Beat 903) 0 - Not Above - - Not Stated |
Beat Type |
Char(1) |
|
1 - 4 - Schoolbus
on City Roadway (CHP Adm Beat 901) 5 - Schoolbus
not on Public Roadway (CHP Adm Beat 903) 6 - Offroad
(Unimproved) (CHP Adm Beat 906, 907) 7 - Vista Point or Rest
Area (CHP Adm Beat 903) or Scales or Inspection
Facility (CHP Com Beat 860-898) 8 - Other Public Access
(Improved) (CHP Adm Beat 903) 0 - Not CHP |
CHP Beat Type |
Char(1) |
|
1 - Interstate A - Safety Services Program
Beats S - Administrative Beats
(900s) 0 - Not CHP |
City Division LAPD |
Char(1) |
|
Includes blanks and dashes as not stated. |
CHP Beat Class |
Char(1) |
|
1 - CHP Primary 2 - CHP Other 0 - Not CHP |
Beat Number |
Varchar2(6) |
|
|
Primary Rd |
Varchar2(50) |
|
|
Secondary Rd |
Varchar2(50) |
|
|
Distance |
Number(9,2) |
|
distance converted to feet |
Direction |
Char(1) |
|
N - North E - East S - South W - West - or blank - Not Stated, in Intersection |
Intersection |
Char(1) |
|
Y - Intersection N - Not Intersection Blank - Not stated |
Weather 1 |
Char(1) |
the weather condition at the time of the collision |
A - Clear B - Cloudy C - Raining D - Snowing E - Fog F - Other G - Wind - -
Not Stated |
Weather 2 |
Char(1) |
the weather condition at the time of the collision,
if a second description is necessary |
same as weather 1 above |
State Highway Indicator |
Char(1) |
|
Y - State Highway N - Blank - Not stated |
|
Char(3) |
|
Includes blanks and nulls |
Caltrans District |
Number(2) |
|
|
State Route |
Number(3) |
|
0 = |
Route Suffix |
Char(1) |
|
|
Postmile
Prefix |
Char(1) |
|
|
Postmile |
Number(6,3) |
|
|
Location Type |
Char(1) |
|
H - Highway I - Intersection R - Ramp (or Collector) - or blank - |
Ramp Intersection |
Char(1) |
|
1 - Ramp Exit, Last 50 Feet 2 - Mid-Ramp 3 - Ramp Entry, First 50
Feet 4 - 5 - Intersection 6 - 7 - Highway 8 - - - Not Stated |
Side Of Highway |
Char(1) |
Code provided by Caltrans Coders; applies to divided
highway, based on nominal direction of route; for single vehicle is same as
nominal direction of travel, overruled by impact with second vehicle after
crossing median |
N - Northbound S - Southbound E - Eastbound W - Westbound Blank - Not stated/not
state highway |
Tow Away |
Char(1) |
|
Y - Yes N - No |
Collision Severity |
Char(1) |
the injury level severity of the collision (highest level of injury in collision) |
1 - Fatal 2 - Injury (Severe) 3 - Injury (Other Visible) 4 - Injury (Complaint of
Pain) 0 - PDO |
Killed victims |
Number(3) |
counts victims in the collision with degree of
injury of 1 |
0 to N for each collision |
Injured victims |
Number(3) |
counts victims in the collision with degree of
injury of 2, 3, or 4 |
0 to N for each collision |
Party Count |
Number(3) |
counts total parties in the collision |
1 to N for each collision |
Primary Collision Factor |
Char(1) |
|
A - (Vehicle) Code
Violation B - Other Improper Driving C - Other Than Driver D - Unknown E - Fell Asleep - - Not Stated |
PCF Violation Code |
Char(1) |
|
B - Business and
Professions C - Vehicle H - City Health and Safety I - City Ordinance O - P - Penal S - Streets and Highways W - Welfare and
Institutions - - Not Stated |
PCF Violation Category |
Char(2) |
|
01 - Driving or Bicycling
Under the Influence of Alcohol or Drug 02 - Impeding Traffic 03 - Unsafe Speed 04 - Following Too Closely 05 - Wrong Side of Road 06 - Improper Passing 07 - Unsafe Lane Change 08 - Improper Turning 09 - Automobile Right of
Way 10 - Pedestrian Right of
Way 11 - Pedestrian Violation 12 - Traffic Signals and
Signs 13 - Hazardous Parking 14 - Lights 15 - Brakes 16 - Other Equipment 17 - Other Hazardous
Violation 18 - Other Than Driver (or
Pedestrian) 19 - 20 - 21 - Unsafe Starting or
Backing 22 - Other Improper Driving 23 - Pedestrian or
"Other" Under the Influence of Alcohol or Drug 24 - Fell Asleep 00 - Unknown - - Not Stated |
PCF Violation |
Number (5) |
|
|
PCF Violation Subsection |
Char(1) |
|
Blank if no subsection. |
Hit And Run |
Char(1) |
|
F - Felony M - Misdemeanor N - Not Hit and Run |
Type of Collision |
Char(1) |
|
A - Head-On B - Sideswipe C - Rear End D - Broadside E - Hit Object F - Overturned G - Vehicle/Pedestrian H - Other - - Not Stated |
Motor Vehicle Involved With |
Char(1) |
|
A - Non-Collision B - Pedestrian C - Other Motor Vehicle D - Motor Vehicle on Other
Roadway E - Parked Motor Vehicle F - Train G - Bicycle H - Animal I - Fixed Object J - Other Object - - Not Stated |
Ped
Action |
Char(1) |
|
A - No Pedestrian Involved B - Crossing in Crosswalk
at Intersection C - Crossing in Crosswalk
Not at Intersection D - Crossing Not in
Crosswalk E - In Road, Including
Shoulder F - Not in Road G - Approaching/Leaving
School Bus - - Not Stated |
Road Surface |
Char(1) |
|
A - Dry B - Wet C - Snowy or Icy D - Slippery (Muddy, Oily,
etc.) - - Not Stated |
Road Condition 1 |
Char(1) |
|
A - Holes, Deep Ruts B - Loose Material on
Roadway C - Obstruction on Roadway D - Construction or Repair
Zone E - Reduced Roadway Width F - Flooded G - Other H - No Unusual Condition - - Not Stated |
Road Condition 2 |
Char(1) |
|
same as road condition 1 above |
Lighting |
Char(1) |
|
A - Daylight B - Dusk - Dawn C - Dark - Street Lights D - Dark - E - Dark - Street Lights
Not Functioning - - Not Stated |
Control Device |
Char(1) |
|
A - Functioning B - Not Functioning C - Obscured D - None - - Not Stated |
|
Char(1) |
|
May be blank |
Pedestrian Collision |
Char(1) |
indicates whether the collision involved a
pedestrian |
Y or blank |
Bicycle Collision |
Char(1) |
indicates whether the collision involved a bicycle |
Y or blank |
Motorcycle Collision |
Char(1) |
indicates whether the collision involved a
motorcycle |
Y or blank |
Truck Collision |
Char(1) |
indicates whether the collision involved a big truck |
Y or blank |
Not Private Property |
Char(1) |
indicates whether the collision occurred on private
property |
Y or blank |
Alcohol Involved |
Char(1) |
indicates whether the collision involved a party
that had been drinking |
Y or blank |
Statewide Vehicle Type At Fault |
Char(1) |
indicates the Statewide Vehicle Type of the party
who is at fault |
see Party folder Statewide Vehicle Type item |
CHP Vehicle Type At Fault |
Char(2) |
indicates the CHP Vehicle Type of the party who is
at fault |
see Party folder CHP Vehicle Type Towing item |
Severe Injury count |
Number(3) |
counts victims in the collision with degree of
injury of 2 |
0 to N for each collision |
Other Visible Injury count |
Number(3) |
counts victims in the collision with degree of
injury of 3 |
0 to N for each collision |
Complaint of Pain Injury count |
Number(3) |
counts victims in the collision with degree of
injury of 4 |
0 to N for each collision |
Pedestrian Killed count |
Number(3) |
Counts the victims in the collision with party type
of 2 and degree of injury is 1 |
0 or 1 for each collision |
Pedestrian Injured count |
Number(3) |
Counts the victims in the collision with party type
of 2 and degree of injury is 2, 3, or 4 |
0 or 1 for each collision |
Bicyclist Killed count |
Number(3) |
Counts the victims in the collision with party type
of 4 and degree of injury is 1 |
0 to N for each collision |
Bicyclist Injured count |
Number(3) |
Counts the victims in the collision with party type
of 4 and degree of injury is 2, 3, or 4 |
0 to N for each collision |
Motorcyclist Killed count |
Number(3) |
counts victims in the collision with statewide
vehicle type of C or O and degree of injury of 1 |
0 to N for each collision |
Motorcyclist Injured count |
Number(3) |
counts victims in the collision with statewide
vehicle type of C or O and degree of injury of 2, 3, or 4 |
0 to N for each collision |
Primary Ramp |
Varchar2(2) |
|
NO-NB On Ramp, NF-NB Off Ramp, SO-SB On Ramp, SF-SB
Off Ramp, EO-EB On Ramp, EF-EB Off Ramp, WO-WB On Ramp, WF-WB Off Ramp, To,
From, Transition, Collector, Connector & blank |
Secondary Ramp |
Varchar2(2) |
|
Same as above |
Latitude |
|
|
|
Longitude |
|
|
|