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

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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata