20250922
15311900
1.0
FALSE
Collisions_2019_2023_No_Freeway
002
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_StatePlane_California_III_FIPS_0403_Ft_US
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><WKT>PROJCS["NAD_1983_2011_StatePlane_California_III_FIPS_0403_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",37.06666666666667],PARAMETER["Standard_Parallel_2",38.43333333333333],PARAMETER["Latitude_Of_Origin",36.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6420]]</WKT><XOrigin>-115860600</XOrigin><YOrigin>-93269500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103005</WKID><LatestWKID>6420</LatestWKID></ProjectedCoordinateSystem>
20250923
07115200
20250923
13302500
150000000
5000
ItemDescription
Esri ArcGIS 13.4.0.55405
Bicyclist and Pedestrian Collisions 2019-2023
This dataset contains COLLISION information for all CRASHES in San Joaquin County from 1/01/2019 through 12/31/2023, filtered to collisions involving bicyclists and pedestrians. Collisions coded as being on SR-99, I-5, I-580, and I-205 have bee filtered out as freeway facilities are not being analyzed in this project. The exception is that the freeway sections of SR-4 and SR-120 are included since both SR-4 and SR-120 are primarily non-freeway facilities.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This table was downloaded from the TIMS (Transportation Injury Mapping System) website September 2025, derived from the Statewide Integrated Traffic Records System (SWITRS) which consists of data collected and maintained by the California Highway Patrol (CHP). SWITRS contains all crashes that were reported by CHP and local and governmental agencies. The CRASH table contains information on each crash, one line per crash. This table contains CRASH information for all CRASHES that resulted in injuries in San Joaquin County from 1/01/2019 through 12/31/2023. This dataset does not contain information for Property Damage Only (PDO) collisions. For more information regarding TIMS data, visit their website: https://tims.berkeley.edu/help/SWITRS.php#Intro_to_SWITRS</SPAN></P></DIV></DIV></DIV>
TIMS, SWITRS
Data Processed and Published by Marty Delgado - Senior GIS Analyst
Contact Information:
William Edmonson, GISP, t GIS Manager Fehr & Peers
w.edmonson@fehrandpeers.com - 916-262-7394
Marty Delgado, Senior GIS Analyst
m.delgado@fehrandpeers.com - 916-262-7429
San Joaquin County County
ATP
Safety
TIMS
SWITRS
Collisions
Crashes
Bicyclist
Pedestrian
2019-2023
Enterprise Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
Collisions_2019_2023_No_Freeway
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
CASE_ID
CASE_ID
Integer
4
10
0
ACCIDENT_YEAR
ACCIDENT_YEAR
Integer
4
10
0
PROC_DATE
PROC_DATE
DateOnly
8
0
0
JURIS
JURIS
Integer
4
10
0
COLLISION_DATE
COLLISION_DATE
DateOnly
8
0
0
COLLISION_TIME
COLLISION_TIME
Integer
4
10
0
OFFICER_ID
OFFICER_ID
Integer
4
10
0
REPORTING_DISTRICT
REPORTING_DISTRICT
String
1073741822
0
0
DAY_OF_WEEK
DAY_OF_WEEK
Integer
4
10
0
CHP_SHIFT
CHP_SHIFT
Integer
4
10
0
POPULATION
POPULATION
Integer
4
10
0
CNTY_CITY_LOC
CNTY_CITY_LOC
Integer
4
10
0
SPECIAL_COND
SPECIAL_COND
Integer
4
10
0
BEAT_TYPE
BEAT_TYPE
Integer
4
10
0
CHP_BEAT_TYPE
CHP_BEAT_TYPE
String
1073741822
0
0
CITY_DIVISION_LAPD
CITY_DIVISION_LAPD
String
1073741822
0
0
CHP_BEAT_CLASS
CHP_BEAT_CLASS
Integer
4
10
0
BEAT_NUMBER
BEAT_NUMBER
String
1073741822
0
0
PRIMARY_RD
PRIMARY_RD
String
1073741822
0
0
SECONDARY_RD
SECONDARY_RD
String
1073741822
0
0
DISTANCE
DISTANCE
Double
8
38
8
DIRECTION
DIRECTION
String
1073741822
0
0
INTERSECTION
INTERSECTION
String
1073741822
0
0
WEATHER_1
WEATHER_1
String
1073741822
0
0
WEATHER_2
WEATHER_2
String
1073741822
0
0
STATE_HWY_IND
STATE_HWY_IND
String
1073741822
0
0
CALTRANS_COUNTY
CALTRANS_COUNTY
String
1073741822
0
0
CALTRANS_DISTRICT
CALTRANS_DISTRICT
String
1073741822
0
0
STATE_ROUTE
STATE_ROUTE
Integer
4
10
0
ROUTE_SUFFIX
ROUTE_SUFFIX
String
1073741822
0
0
POSTMILE_PREFIX
POSTMILE_PREFIX
String
1073741822
0
0
POSTMILE
POSTMILE
Double
8
38
8
LOCATION_TYPE
LOCATION_TYPE
String
1073741822
0
0
RAMP_INTERSECTION
RAMP_INTERSECTION
String
1073741822
0
0
SIDE_OF_HWY
SIDE_OF_HWY
String
1073741822
0
0
TOW_AWAY
TOW_AWAY
String
1073741822
0
0
COLLISION_SEVERITY
COLLISION_SEVERITY
Integer
4
10
0
NUMBER_KILLED
NUMBER_KILLED
Integer
4
10
0
NUMBER_INJURED
NUMBER_INJURED
Integer
4
10
0
PARTY_COUNT
PARTY_COUNT
Integer
4
10
0
PRIMARY_COLL_FACTOR
PRIMARY_COLL_FACTOR
String
1073741822
0
0
PCF_CODE_OF_VIOL
PCF_CODE_OF_VIOL
String
1073741822
0
0
PCF_VIOL_CATEGORY
PCF_VIOL_CATEGORY
String
1073741822
0
0
PCF_VIOLATION
PCF_VIOLATION
Integer
4
10
0
PCF_VIOL_SUBSECTION
PCF_VIOL_SUBSECTION
String
1073741822
0
0
HIT_AND_RUN
HIT_AND_RUN
String
1073741822
0
0
TYPE_OF_COLLISION
TYPE_OF_COLLISION
String
1073741822
0
0
MVIW
MVIW
String
1073741822
0
0
PED_ACTION
PED_ACTION
String
1073741822
0
0
ROAD_SURFACE
ROAD_SURFACE
String
1073741822
0
0
ROAD_COND_1
ROAD_COND_1
String
1073741822
0
0
ROAD_COND_2
ROAD_COND_2
String
1073741822
0
0
LIGHTING
LIGHTING
String
1073741822
0
0
CONTROL_DEVICE
CONTROL_DEVICE
String
1073741822
0
0
CHP_ROAD_TYPE
CHP_ROAD_TYPE
Integer
4
10
0
PEDESTRIAN_ACCIDENT
PEDESTRIAN_ACCIDENT
String
1073741822
0
0
BICYCLE_ACCIDENT
BICYCLE_ACCIDENT
String
1073741822
0
0
MOTORCYCLE_ACCIDENT
MOTORCYCLE_ACCIDENT
String
1073741822
0
0
TRUCK_ACCIDENT
TRUCK_ACCIDENT
String
1073741822
0
0
NOT_PRIVATE_PROPERTY
NOT_PRIVATE_PROPERTY
String
1073741822
0
0
ALCOHOL_INVOLVED
ALCOHOL_INVOLVED
String
1073741822
0
0
STWD_VEHTYPE_AT_FAULT
STWD_VEHTYPE_AT_FAULT
String
1073741822
0
0
CHP_VEHTYPE_AT_FAULT
CHP_VEHTYPE_AT_FAULT
String
1073741822
0
0
COUNT_SEVERE_INJ
COUNT_SEVERE_INJ
Integer
4
10
0
COUNT_VISIBLE_INJ
COUNT_VISIBLE_INJ
Integer
4
10
0
COUNT_COMPLAINT_PAIN
COUNT_COMPLAINT_PAIN
Integer
4
10
0
COUNT_PED_KILLED
COUNT_PED_KILLED
Integer
4
10
0
COUNT_PED_INJURED
COUNT_PED_INJURED
Integer
4
10
0
COUNT_BICYCLIST_KILLED
COUNT_BICYCLIST_KILLED
Integer
4
10
0
COUNT_BICYCLIST_INJURED
COUNT_BICYCLIST_INJURED
Integer
4
10
0
COUNT_MC_KILLED
COUNT_MC_KILLED
Integer
4
10
0
COUNT_MC_INJURED
COUNT_MC_INJURED
Integer
4
10
0
PRIMARY_RAMP
PRIMARY_RAMP
String
1073741822
0
0
SECONDARY_RAMP
SECONDARY_RAMP
String
1073741822
0
0
LATITUDE
LATITUDE
Double
8
38
8
LONGITUDE
LONGITUDE
Double
8
38
8
COUNTY
COUNTY
String
1073741822
0
0
CITY
CITY
String
1073741822
0
0
POINT_X
POINT_X
Double
8
38
8
POINT_Y
POINT_Y
Double
8
38
8
AvgVAGE
AvgVAGE
Double
8
38
8
VAGE_Minor
VAGE_Minor
Double
8
38
8
VAGE_Senior
VAGE_Senior
Double
8
38
8
MobilLimAge
MobilLimAge
Double
8
38
8
F_F_VICTIM_SEX
F_F_VICTIM_SEX
Double
8
38
8
F_M_VICTIM_SEX
F_M_VICTIM_SEX
Double
8
38
8
F_X_VICTIM_SEX
F_X_VICTIM_SEX
Double
8
38
8
F_H_RACE
F_H_RACE
Double
8
38
8
F_W_RACE
F_W_RACE
Double
8
38
8
F_B_RACE
F_B_RACE
Double
8
38
8
F_O_RACE
F_O_RACE
Double
8
38
8
F_A_RACE
F_A_RACE
Double
8
38
8
F_E_MOVE_PRE_ACC
F_E_MOVE_PRE_ACC
Double
8
38
8
F_R_MOVE_PRE_ACC
F_R_MOVE_PRE_ACC
Double
8
38
8
F_B_MOVE_PRE_ACC
F_B_MOVE_PRE_ACC
Double
8
38
8
F_H_MOVE_PRE_ACC
F_H_MOVE_PRE_ACC
Double
8
38
8
F_A_MOVE_PRE_ACC
F_A_MOVE_PRE_ACC
Double
8
38
8
F_J_MOVE_PRE_ACC
F_J_MOVE_PRE_ACC
Double
8
38
8
F_G_MOVE_PRE_ACC
F_G_MOVE_PRE_ACC
Double
8
38
8
F_C_MOVE_PRE_ACC
F_C_MOVE_PRE_ACC
Double
8
38
8
F_O_MOVE_PRE_ACC
F_O_MOVE_PRE_ACC
Double
8
38
8
F_D_MOVE_PRE_ACC
F_D_MOVE_PRE_ACC
Double
8
38
8
F_I_MOVE_PRE_ACC
F_I_MOVE_PRE_ACC
Double
8
38
8
F_M_MOVE_PRE_ACC
F_M_MOVE_PRE_ACC
Double
8
38
8
F_F_MOVE_PRE_ACC
F_F_MOVE_PRE_ACC
Double
8
38
8
F_N_MOVE_PRE_ACC
F_N_MOVE_PRE_ACC
Double
8
38
8
F_L_MOVE_PRE_ACC
F_L_MOVE_PRE_ACC
Double
8
38
8
F_Q_MOVE_PRE_ACC
F_Q_MOVE_PRE_ACC
Double
8
38
8
F_P_MOVE_PRE_ACC
F_P_MOVE_PRE_ACC
Double
8
38
8
F_S_MOVE_PRE_ACC
F_S_MOVE_PRE_ACC
Double
8
38
8
F_K_MOVE_PRE_ACC
F_K_MOVE_PRE_ACC
Double
8
38
8
F_A_STWD_VEHICLE_TYPE
F_A_STWD_VEHICLE_TYPE
Double
8
38
8
F_N_STWD_VEHICLE_TYPE
F_N_STWD_VEHICLE_TYPE
Double
8
38
8
F_M_STWD_VEHICLE_TYPE
F_M_STWD_VEHICLE_TYPE
Double
8
38
8
F_D_STWD_VEHICLE_TYPE
F_D_STWD_VEHICLE_TYPE
Double
8
38
8
F_C_STWD_VEHICLE_TYPE
F_C_STWD_VEHICLE_TYPE
Double
8
38
8
F_G_STWD_VEHICLE_TYPE
F_G_STWD_VEHICLE_TYPE
Double
8
38
8
F_L_STWD_VEHICLE_TYPE
F_L_STWD_VEHICLE_TYPE
Double
8
38
8
F_I_STWD_VEHICLE_TYPE
F_I_STWD_VEHICLE_TYPE
Double
8
38
8
F_F_STWD_VEHICLE_TYPE
F_F_STWD_VEHICLE_TYPE
Double
8
38
8
F_J_STWD_VEHICLE_TYPE
F_J_STWD_VEHICLE_TYPE
Double
8
38
8
F_B_STWD_VEHICLE_TYPE
F_B_STWD_VEHICLE_TYPE
Double
8
38
8
F_E_STWD_VEHICLE_TYPE
F_E_STWD_VEHICLE_TYPE
Double
8
38
8
F_O_STWD_VEHICLE_TYPE
F_O_STWD_VEHICLE_TYPE
Double
8
38
8
F_H_STWD_VEHICLE_TYPE
F_H_STWD_VEHICLE_TYPE
Double
8
38
8
F_K_STWD_VEHICLE_TYPE
F_K_STWD_VEHICLE_TYPE
Double
8
38
8
Movement_Notes
Movement_Notes
String
500
0
0
Time_of_Day
Time of Day
String
255
0
0
Day_of_W_1
Day of Week
String
255
0
0
Month
Month
String
255
0
0
KSI_
KSI?
String
255
0
0
KSI_Victims
KSI Victims
Integer
4
10
0
Year
Year
Integer
4
10
0
Weather
Weather
String
255
0
0
Lighting_1
Lighting
String
255
0
0
Road_Sur_1
Road Surface
String
255
0
0
Intersection_
Intersection?
String
255
0
0
Collisio_1
Collision Severity
String
255
0
0
PCF_Violation_Category
PCF Violation Category
String
255
0
0
PCF_Violation_Detail
PCF Violation Detail
String
255
0
0
Type_of__1
Type of Collision
String
255
0
0
Pedestrian_Action
Pedestrian Action
String
255
0
0
Hit_and__1
Hit and Run
String
255
0
0
Drug_or_Alcohol_Impairment_Invo
Drug or Alcohol Impairment Involved
Integer
4
10
0
Turn_Involved
Turn Involved
Integer
4
10
0
Left_Turn
Left Turn
Integer
4
10
0
Right_Turn
Right Turn
Integer
4
10
0
Other_Turn
Other Turn
Integer
4
10
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20250923