View In:   ArcGIS Online Map Viewer

Name: Bicyclist and Pedestrian Collisions 2019-2023

Display Field: REPORTING_DISTRICT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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

Service Item Id: 0cbb94babec04c539ca8c1243033ad2e

Copyright Text: 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

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6251658.233328387
YMin: 2044527.8043058962
XMax: 6439358.160421222
YMax: 2284383.578530401
Spatial Reference: 103005  (6420)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Collisio_1
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Fatal
  Label: Fatality
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Injury (Severe)
  Label: Injury (Severe)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 125, 24, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Injury (Other Visible)
  Label: Injury (Other Visible)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 215, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Complaint of Pain
  Label: Complaint of Pain
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 204, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Collisio_1

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CASE_ID ( type: esriFieldTypeInteger, alias: Case ID, editable: true, nullable: true, defaultValue: null, modelName: CASE_ID )
• ACCIDENT_YEAR ( type: esriFieldTypeInteger, alias: Accident Year, editable: true, nullable: true, defaultValue: null, modelName: ACCIDENT_YEAR )
• PROC_DATE ( type: esriFieldTypeDateOnly, alias: Process Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROC_DATE )
• JURIS ( type: esriFieldTypeInteger, alias: Jurisdiction, editable: true, nullable: true, defaultValue: null, modelName: JURIS )
• COLLISION_DATE ( type: esriFieldTypeDateOnly, alias: Collision Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COLLISION_DATE )
• COLLISION_TIME ( type: esriFieldTypeInteger, alias: Collision Time, editable: true, nullable: true, defaultValue: null, modelName: COLLISION_TIME )
• PRIMARY_RD ( type: esriFieldTypeString, alias: Primary Road, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRIMARY_RD )
• SECONDARY_RD ( type: esriFieldTypeString, alias: Secondary Road, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SECONDARY_RD )
• DISTANCE ( type: esriFieldTypeDouble, alias: Distance, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE )
• DIRECTION ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DIRECTION )
• STATE_HWY_IND ( type: esriFieldTypeString, alias: Highway Indicator, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STATE_HWY_IND )
• STATE_ROUTE ( type: esriFieldTypeInteger, alias: State Route, editable: true, nullable: true, defaultValue: null, modelName: STATE_ROUTE )
• PEDESTRIAN_ACCIDENT ( type: esriFieldTypeString, alias: Pedestrian Accident, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PEDESTRIAN_ACCIDENT )
• BICYCLE_ACCIDENT ( type: esriFieldTypeString, alias: Bicycle Accident, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BICYCLE_ACCIDENT )
• COUNT_SEVERE_INJ ( type: esriFieldTypeInteger, alias: Count of Severe Injury, editable: true, nullable: true, defaultValue: null, modelName: COUNT_SEVERE_INJ )
• COUNT_VISIBLE_INJ ( type: esriFieldTypeInteger, alias: County of Visible Injury, editable: true, nullable: true, defaultValue: null, modelName: COUNT_VISIBLE_INJ )
• COUNT_COMPLAINT_PAIN ( type: esriFieldTypeInteger, alias: County of Complaint of Pain, editable: true, nullable: true, defaultValue: null, modelName: COUNT_COMPLAINT_PAIN )
• COUNT_PED_KILLED ( type: esriFieldTypeInteger, alias: Count Pedestrian Fatality, editable: true, nullable: true, defaultValue: null, modelName: COUNT_PED_KILLED )
• COUNT_PED_INJURED ( type: esriFieldTypeInteger, alias: Count of Pedestrian Injured, editable: true, nullable: true, defaultValue: null, modelName: COUNT_PED_INJURED )
• COUNT_BICYCLIST_KILLED ( type: esriFieldTypeInteger, alias: Count of Bicyclist Fatality, editable: true, nullable: true, defaultValue: null, modelName: COUNT_BICYCLIST_KILLED )
• COUNT_BICYCLIST_INJURED ( type: esriFieldTypeInteger, alias: Count of Bicyclist Injury, editable: true, nullable: true, defaultValue: null, modelName: COUNT_BICYCLIST_INJURED )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: COUNTY )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CITY )
• Time_of_Day ( type: esriFieldTypeString, alias: Time of Day, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Time_of_Day )
• Day_of_W_1 ( type: esriFieldTypeString, alias: Day of Week, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Day_of_W_1 )
• Month ( type: esriFieldTypeString, alias: Month, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Month )
• KSI_ ( type: esriFieldTypeString, alias: KSI?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: KSI_ )
• KSI_Victims ( type: esriFieldTypeInteger, alias: KSI Victims, editable: true, nullable: true, defaultValue: null, modelName: KSI_Victims )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Weather )
• Lighting_1 ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lighting_1 )
• Road_Sur_1 ( type: esriFieldTypeString, alias: Road Surface, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Sur_1 )
• Intersection_ ( type: esriFieldTypeString, alias: Intersection?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Intersection_ )
• Collisio_1 ( type: esriFieldTypeString, alias: Collision Severity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Collisio_1 )
• PCF_Violation_Category ( type: esriFieldTypeString, alias: PCF Violation Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PCF_Violation_Category )
• PCF_Violation_Detail ( type: esriFieldTypeString, alias: PCF Violation Detail, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PCF_Violation_Detail )
• Type_of__1 ( type: esriFieldTypeString, alias: Type of Collision, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Type_of__1 )
• Pedestrian_Action ( type: esriFieldTypeString, alias: Pedestrian Action, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pedestrian_Action )
• Hit_and__1 ( type: esriFieldTypeString, alias: Hit and Run, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hit_and__1 )
• Drug_or_Alcohol_Impairment_Invo ( type: esriFieldTypeInteger, alias: Drug or Alcohol Impairment Involved, editable: true, nullable: true, defaultValue: null, modelName: Drug_or_Alcohol_Impairment_Invo )
• Turn_Involved ( type: esriFieldTypeInteger, alias: Turn Involved, editable: true, nullable: true, defaultValue: null, modelName: Turn_Involved )
• Left_Turn ( type: esriFieldTypeInteger, alias: Left Turn, editable: true, nullable: true, defaultValue: null, modelName: Left_Turn )
• Right_Turn ( type: esriFieldTypeInteger, alias: Right Turn, editable: true, nullable: true, defaultValue: null, modelName: Right_Turn )
• Other_Turn ( type: esriFieldTypeInteger, alias: Other Turn, editable: true, nullable: true, defaultValue: null, modelName: Other_Turn )
• Do_Not_Count ( type: esriFieldTypeSmallInteger, alias: Do_Not_Count, editable: true, nullable: true, defaultValue: null, modelName: Do_Not_Count )
• JURISDICTION_NAME ( type: esriFieldTypeString, alias: JURISDICTION_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JURISDICTION_NAME )

Types:

ID: Fatal
Name: Fatality
Domains:
Templates:
• Name: Fatal
  Description:
  Prototype:
  Do_Not_Count: null
  JURISDICTION_NAME: null
  CASE_ID: null
  ACCIDENT_YEAR: null
  PROC_DATE: null
  JURIS: null
  COLLISION_DATE: null
  COLLISION_TIME: null
  PRIMARY_RD: null
  SECONDARY_RD: null
  DISTANCE: null
  DIRECTION: null
  STATE_HWY_IND: null
  STATE_ROUTE: null
  PEDESTRIAN_ACCIDENT: null
  BICYCLE_ACCIDENT: null
  COUNT_SEVERE_INJ: null
  COUNT_VISIBLE_INJ: null
  COUNT_COMPLAINT_PAIN: null
  COUNT_PED_KILLED: null
  COUNT_PED_INJURED: null
  COUNT_BICYCLIST_KILLED: null
  COUNT_BICYCLIST_INJURED: null
  COUNTY: null
  CITY: null
  Time_of_Day: null
  Day_of_W_1: null
  Month: null
  KSI_: null
  KSI_Victims: null
  Year: null
  Weather: null
  Lighting_1: null
  Road_Sur_1: null
  Intersection_: null
  Collisio_1: Fatal
  PCF_Violation_Category: null
  PCF_Violation_Detail: null
  Type_of__1: null
  Pedestrian_Action: null
  Hit_and__1: null
  Drug_or_Alcohol_Impairment_Invo: null
  Turn_Involved: null
  Left_Turn: null
  Right_Turn: null
  Other_Turn: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Injury (Severe)
Name: Injury (Severe)
Domains:
Templates:
• Name: Injury (Severe)
  Description:
  Prototype:
  Do_Not_Count: null
  JURISDICTION_NAME: null
  CASE_ID: null
  ACCIDENT_YEAR: null
  PROC_DATE: null
  JURIS: null
  COLLISION_DATE: null
  COLLISION_TIME: null
  PRIMARY_RD: null
  SECONDARY_RD: null
  DISTANCE: null
  DIRECTION: null
  STATE_HWY_IND: null
  STATE_ROUTE: null
  PEDESTRIAN_ACCIDENT: null
  BICYCLE_ACCIDENT: null
  COUNT_SEVERE_INJ: null
  COUNT_VISIBLE_INJ: null
  COUNT_COMPLAINT_PAIN: null
  COUNT_PED_KILLED: null
  COUNT_PED_INJURED: null
  COUNT_BICYCLIST_KILLED: null
  COUNT_BICYCLIST_INJURED: null
  COUNTY: null
  CITY: null
  Time_of_Day: null
  Day_of_W_1: null
  Month: null
  KSI_: null
  KSI_Victims: null
  Year: null
  Weather: null
  Lighting_1: null
  Road_Sur_1: null
  Intersection_: null
  Collisio_1: Injury (Severe)
  PCF_Violation_Category: null
  PCF_Violation_Detail: null
  Type_of__1: null
  Pedestrian_Action: null
  Hit_and__1: null
  Drug_or_Alcohol_Impairment_Invo: null
  Turn_Involved: null
  Left_Turn: null
  Right_Turn: null
  Other_Turn: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Injury (Other Visible)
Name: Injury (Other Visible)
Domains:
Templates:
• Name: Injury (Other Visible)
  Description:
  Prototype:
  Do_Not_Count: null
  JURISDICTION_NAME: null
  CASE_ID: null
  ACCIDENT_YEAR: null
  PROC_DATE: null
  JURIS: null
  COLLISION_DATE: null
  COLLISION_TIME: null
  PRIMARY_RD: null
  SECONDARY_RD: null
  DISTANCE: null
  DIRECTION: null
  STATE_HWY_IND: null
  STATE_ROUTE: null
  PEDESTRIAN_ACCIDENT: null
  BICYCLE_ACCIDENT: null
  COUNT_SEVERE_INJ: null
  COUNT_VISIBLE_INJ: null
  COUNT_COMPLAINT_PAIN: null
  COUNT_PED_KILLED: null
  COUNT_PED_INJURED: null
  COUNT_BICYCLIST_KILLED: null
  COUNT_BICYCLIST_INJURED: null
  COUNTY: null
  CITY: null
  Time_of_Day: null
  Day_of_W_1: null
  Month: null
  KSI_: null
  KSI_Victims: null
  Year: null
  Weather: null
  Lighting_1: null
  Road_Sur_1: null
  Intersection_: null
  Collisio_1: Injury (Other Visible)
  PCF_Violation_Category: null
  PCF_Violation_Detail: null
  Type_of__1: null
  Pedestrian_Action: null
  Hit_and__1: null
  Drug_or_Alcohol_Impairment_Invo: null
  Turn_Involved: null
  Left_Turn: null
  Right_Turn: null
  Other_Turn: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Complaint of Pain
Name: Complaint of Pain
Domains:
Templates:
• Name: Complaint of Pain
  Description:
  Prototype:
  Do_Not_Count: null
  JURISDICTION_NAME: null
  CASE_ID: null
  ACCIDENT_YEAR: null
  PROC_DATE: null
  JURIS: null
  COLLISION_DATE: null
  COLLISION_TIME: null
  PRIMARY_RD: null
  SECONDARY_RD: null
  DISTANCE: null
  DIRECTION: null
  STATE_HWY_IND: null
  STATE_ROUTE: null
  PEDESTRIAN_ACCIDENT: null
  BICYCLE_ACCIDENT: null
  COUNT_SEVERE_INJ: null
  COUNT_VISIBLE_INJ: null
  COUNT_COMPLAINT_PAIN: null
  COUNT_PED_KILLED: null
  COUNT_PED_INJURED: null
  COUNT_BICYCLIST_KILLED: null
  COUNT_BICYCLIST_INJURED: null
  COUNTY: null
  CITY: null
  Time_of_Day: null
  Day_of_W_1: null
  Month: null
  KSI_: null
  KSI_Victims: null
  Year: null
  Weather: null
  Lighting_1: null
  Road_Sur_1: null
  Intersection_: null
  Collisio_1: Complaint of Pain
  PCF_Violation_Category: null
  PCF_Violation_Detail: null
  Type_of__1: null
  Pedestrian_Action: null
  Hit_and__1: null
  Drug_or_Alcohol_Impairment_Invo: null
  Turn_Involved: null
  Left_Turn: null
  Right_Turn: null
  Other_Turn: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata