View In:   ArcGIS Online Map Viewer

Name: All_Collisions_master

Display Field: officer_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Collision data within Napa County pulled from SWITRS in September 2025 for collisions that occurred between January 2022 to March 2025</SPAN></P></DIV></DIV></DIV>

Service Item Id: b7f3feca5bef45d584e6748d245f406a

Copyright Text: Statewide Integrated Traffic Records System (SWITRS)

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

Extent:

XMin: 6382023.017121226
YMin: 1818874.1147598624
XMax: 6531788.672360882
YMax: 2062378.3443643898
Spatial Reference: 102642  (2226)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: collisio_1
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: Fatal
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: Injury (Severe)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 152, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: Injury (Other Visable)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 4
  Label: Injury (Complaint of Pain)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [56, 168, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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:

• fid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: fid, alias: FID )
• case_id ( modelName: case_id, nullable: true, editable: true, defaultValue: null, alias: CASE_ID, type: esriFieldTypeInteger )
• accident_y ( modelName: accident_y, nullable: true, editable: true, defaultValue: null, alias: ACCIDENT_Y, type: esriFieldTypeInteger )
• proc_date ( modelName: proc_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Proc_Date, type: esriFieldTypeDate )
• juris ( modelName: juris, nullable: true, editable: true, defaultValue: null, alias: JURIS, type: esriFieldTypeInteger )
• collision_ ( modelName: collision_, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Collision_, type: esriFieldTypeDate )
• collision1 ( modelName: collision1, nullable: true, editable: true, defaultValue: null, alias: COLLISION1, type: esriFieldTypeInteger )
• officer_id ( modelName: officer_id, nullable: true, editable: true, defaultValue: null, length: 254, alias: OFFICER_ID, type: esriFieldTypeString )
• reporting_ ( modelName: reporting_, nullable: true, editable: true, defaultValue: null, length: 254, alias: REPORTING_, type: esriFieldTypeString )
• day_of_wee ( modelName: day_of_wee, nullable: true, editable: true, defaultValue: null, alias: DAY_OF_WEE, type: esriFieldTypeInteger )
• chp_shift ( modelName: chp_shift, nullable: true, editable: true, defaultValue: null, alias: CHP_SHIFT, type: esriFieldTypeInteger )
• population ( modelName: population, nullable: true, editable: true, defaultValue: null, alias: POPULATION, type: esriFieldTypeInteger )
• cnty_city_ ( modelName: cnty_city_, nullable: true, editable: true, defaultValue: null, alias: CNTY_CITY_, type: esriFieldTypeInteger )
• special_co ( modelName: special_co, nullable: true, editable: true, defaultValue: null, alias: SPECIAL_CO, type: esriFieldTypeInteger )
• beat_type ( modelName: beat_type, nullable: true, editable: true, defaultValue: null, alias: BEAT_TYPE, type: esriFieldTypeInteger )
• chp_beat_t ( modelName: chp_beat_t, nullable: true, editable: true, defaultValue: null, length: 254, alias: CHP_BEAT_T, type: esriFieldTypeString )
• city_divis ( modelName: city_divis, nullable: true, editable: true, defaultValue: null, length: 254, alias: CITY_DIVIS, type: esriFieldTypeString )
• chp_beat_c ( modelName: chp_beat_c, nullable: true, editable: true, defaultValue: null, alias: CHP_BEAT_C, type: esriFieldTypeInteger )
• beat_numbe ( modelName: beat_numbe, nullable: true, editable: true, defaultValue: null, length: 254, alias: BEAT_NUMBE, type: esriFieldTypeString )
• primary_rd ( modelName: primary_rd, nullable: true, editable: true, defaultValue: null, length: 254, alias: PRIMARY_RD, type: esriFieldTypeString )
• secondary_ ( modelName: secondary_, nullable: true, editable: true, defaultValue: null, length: 254, alias: SECONDARY_, type: esriFieldTypeString )
• distance ( modelName: distance, nullable: true, editable: true, defaultValue: null, alias: DISTANCE, type: esriFieldTypeDouble )
• direction ( modelName: direction, nullable: true, editable: true, defaultValue: null, length: 254, alias: DIRECTION, type: esriFieldTypeString )
• intersecti ( modelName: intersecti, nullable: true, editable: true, defaultValue: null, length: 254, alias: INTERSECTI, type: esriFieldTypeString )
• weather_1 ( modelName: weather_1, nullable: true, editable: true, defaultValue: null, length: 254, alias: WEATHER_1, type: esriFieldTypeString )
• weather_2 ( modelName: weather_2, nullable: true, editable: true, defaultValue: null, length: 254, alias: WEATHER_2, type: esriFieldTypeString )
• state_hwy_ ( modelName: state_hwy_, nullable: true, editable: true, defaultValue: null, length: 254, alias: STATE_HWY_, type: esriFieldTypeString )
• caltrans_c ( modelName: caltrans_c, nullable: true, editable: true, defaultValue: null, length: 254, alias: CALTRANS_C, type: esriFieldTypeString )
• caltrans_d ( modelName: caltrans_d, nullable: true, editable: true, defaultValue: null, alias: CALTRANS_D, type: esriFieldTypeInteger )
• state_rout ( modelName: state_rout, nullable: true, editable: true, defaultValue: null, alias: STATE_ROUT, type: esriFieldTypeInteger )
• route_suff ( modelName: route_suff, nullable: true, editable: true, defaultValue: null, length: 254, alias: ROUTE_SUFF, type: esriFieldTypeString )
• postmile_p ( modelName: postmile_p, nullable: true, editable: true, defaultValue: null, length: 254, alias: POSTMILE_P, type: esriFieldTypeString )
• postmile ( modelName: postmile, nullable: true, editable: true, defaultValue: null, alias: POSTMILE, type: esriFieldTypeDouble )
• location_t ( modelName: location_t, nullable: true, editable: true, defaultValue: null, length: 254, alias: LOCATION_T, type: esriFieldTypeString )
• ramp_inter ( modelName: ramp_inter, nullable: true, editable: true, defaultValue: null, length: 254, alias: RAMP_INTER, type: esriFieldTypeString )
• side_of_hw ( modelName: side_of_hw, nullable: true, editable: true, defaultValue: null, length: 254, alias: SIDE_OF_HW, type: esriFieldTypeString )
• tow_away ( modelName: tow_away, nullable: true, editable: true, defaultValue: null, length: 254, alias: TOW_AWAY, type: esriFieldTypeString )
• collisio_1 ( modelName: collisio_1, nullable: true, editable: true, defaultValue: null, alias: COLLISIO_1, type: esriFieldTypeInteger )
• number_kil ( modelName: number_kil, nullable: true, editable: true, defaultValue: null, alias: NUMBER_KIL, type: esriFieldTypeInteger )
• number_inj ( modelName: number_inj, nullable: true, editable: true, defaultValue: null, alias: NUMBER_INJ, type: esriFieldTypeInteger )
• party_coun ( modelName: party_coun, nullable: true, editable: true, defaultValue: null, alias: PARTY_COUN, type: esriFieldTypeInteger )
• primary_co ( modelName: primary_co, nullable: true, editable: true, defaultValue: null, length: 254, alias: PRIMARY_CO, type: esriFieldTypeString )
• pcf_code_o ( modelName: pcf_code_o, nullable: true, editable: true, defaultValue: null, length: 254, alias: PCF_CODE_O, type: esriFieldTypeString )
• pcf_viol_c ( modelName: pcf_viol_c, nullable: true, editable: true, defaultValue: null, length: 254, alias: PCF_VIOL_C, type: esriFieldTypeString )
• pcf_violat ( modelName: pcf_violat, nullable: true, editable: true, defaultValue: null, alias: PCF_VIOLAT, type: esriFieldTypeInteger )
• pcf_viol_s ( modelName: pcf_viol_s, nullable: true, editable: true, defaultValue: null, length: 254, alias: PCF_VIOL_S, type: esriFieldTypeString )
• hit_and_ru ( modelName: hit_and_ru, nullable: true, editable: true, defaultValue: null, length: 254, alias: HIT_AND_RU, type: esriFieldTypeString )
• type_of_co ( modelName: type_of_co, nullable: true, editable: true, defaultValue: null, length: 254, alias: TYPE_OF_CO, type: esriFieldTypeString )
• mviw ( modelName: mviw, nullable: true, editable: true, defaultValue: null, length: 254, alias: MVIW, type: esriFieldTypeString )
• ped_action ( modelName: ped_action, nullable: true, editable: true, defaultValue: null, length: 254, alias: PED_ACTION, type: esriFieldTypeString )
• road_surfa ( modelName: road_surfa, nullable: true, editable: true, defaultValue: null, length: 254, alias: ROAD_SURFA, type: esriFieldTypeString )
• road_cond_ ( modelName: road_cond_, nullable: true, editable: true, defaultValue: null, length: 254, alias: ROAD_COND_, type: esriFieldTypeString )
• road_cond1 ( modelName: road_cond1, nullable: true, editable: true, defaultValue: null, length: 254, alias: ROAD_COND1, type: esriFieldTypeString )
• lighting ( modelName: lighting, nullable: true, editable: true, defaultValue: null, length: 254, alias: LIGHTING, type: esriFieldTypeString )
• control_de ( modelName: control_de, nullable: true, editable: true, defaultValue: null, length: 254, alias: CONTROL_DE, type: esriFieldTypeString )
• chp_road_t ( modelName: chp_road_t, nullable: true, editable: true, defaultValue: null, alias: CHP_ROAD_T, type: esriFieldTypeInteger )
• pedestrian ( modelName: pedestrian, nullable: true, editable: true, defaultValue: null, length: 254, alias: PEDESTRIAN, type: esriFieldTypeString )
• bicycle_ac ( modelName: bicycle_ac, nullable: true, editable: true, defaultValue: null, length: 254, alias: BICYCLE_AC, type: esriFieldTypeString )
• motorcycle ( modelName: motorcycle, nullable: true, editable: true, defaultValue: null, length: 254, alias: MOTORCYCLE, type: esriFieldTypeString )
• truck_acci ( modelName: truck_acci, nullable: true, editable: true, defaultValue: null, length: 254, alias: TRUCK_ACCI, type: esriFieldTypeString )
• not_privat ( modelName: not_privat, nullable: true, editable: true, defaultValue: null, length: 254, alias: NOT_PRIVAT, type: esriFieldTypeString )
• alcohol_in ( modelName: alcohol_in, nullable: true, editable: true, defaultValue: null, length: 254, alias: ALCOHOL_IN, type: esriFieldTypeString )
• stwd_vehty ( modelName: stwd_vehty, nullable: true, editable: true, defaultValue: null, length: 254, alias: STWD_VEHTY, type: esriFieldTypeString )
• chp_vehtyp ( modelName: chp_vehtyp, nullable: true, editable: true, defaultValue: null, length: 254, alias: CHP_VEHTYP, type: esriFieldTypeString )
• count_seve ( modelName: count_seve, nullable: true, editable: true, defaultValue: null, alias: COUNT_SEVE, type: esriFieldTypeInteger )
• count_visi ( modelName: count_visi, nullable: true, editable: true, defaultValue: null, alias: COUNT_VISI, type: esriFieldTypeInteger )
• count_comp ( modelName: count_comp, nullable: true, editable: true, defaultValue: null, alias: COUNT_COMP, type: esriFieldTypeInteger )
• count_ped_ ( modelName: count_ped_, nullable: true, editable: true, defaultValue: null, alias: COUNT_PED_, type: esriFieldTypeInteger )
• count_ped1 ( modelName: count_ped1, nullable: true, editable: true, defaultValue: null, alias: COUNT_PED1, type: esriFieldTypeInteger )
• count_bicy ( modelName: count_bicy, nullable: true, editable: true, defaultValue: null, alias: COUNT_BICY, type: esriFieldTypeInteger )
• count_bi_1 ( modelName: count_bi_1, nullable: true, editable: true, defaultValue: null, alias: COUNT_BI_1, type: esriFieldTypeInteger )
• count_mc_k ( modelName: count_mc_k, nullable: true, editable: true, defaultValue: null, alias: COUNT_MC_K, type: esriFieldTypeInteger )
• count_mc_i ( modelName: count_mc_i, nullable: true, editable: true, defaultValue: null, alias: COUNT_MC_I, type: esriFieldTypeInteger )
• primary_ra ( modelName: primary_ra, nullable: true, editable: true, defaultValue: null, length: 254, alias: PRIMARY_RA, type: esriFieldTypeString )
• secondary1 ( modelName: secondary1, nullable: true, editable: true, defaultValue: null, length: 254, alias: SECONDARY1, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: LATITUDE, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE, type: esriFieldTypeDouble )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 254, alias: COUNTY, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 254, alias: CITY, type: esriFieldTypeString )
• point_x ( modelName: point_x, nullable: true, editable: true, defaultValue: null, alias: POINT_X, type: esriFieldTypeDouble )
• point_y ( modelName: point_y, nullable: true, editable: true, defaultValue: null, alias: POINT_Y, type: esriFieldTypeDouble )

Types:

ID: 1
Name: Fatal
Domains:
Templates:
• Name: 1
  Description:
  Prototype:
  city_divis: null
  collision_: null
  county: null
  beat_type: null
  collisio_1: null
  location_t: null
  primary_rd: null
  primary_ra: null
  motorcycle: null
  proc_date: null
  point_y: null
  road_cond1: null
  point_x: null
  alcohol_in: null
  case_id: null
  weather_1: null
  weather_2: null
  postmile: null
  longitude: null
  chp_beat_t: null
  chp_shift: null
  secondary_: null
  beat_numbe: null
  postmile_p: null
  tow_away: null
  mviw: null
  chp_vehtyp: null
  pcf_viol_s: null
  stwd_vehty: null
  state_hwy_: null
  count_ped_: null
  lighting: null
  count_bi_1: null
  population: null
  chp_beat_c: null
  officer_id: null
  party_coun: null
  count_visi: null
  special_co: null
  pcf_viol_c: null
  ramp_inter: null
  route_suff: null
  day_of_wee: null
  distance: null
  bicycle_ac: null
  city: null
  caltrans_d: null
  caltrans_c: null
  not_privat: null
  latitude: null
  number_inj: null
  primary_co: null
  side_of_hw: null
  ped_action: null
  chp_road_t: null
  reporting_: null
  truck_acci: null
  collision1: null
  intersecti: null
  control_de: null
  direction: null
  state_rout: null
  road_surfa: null
  count_bicy: null
  cnty_city_: null
  type_of_co: null
  pcf_code_o: null
  secondary1: null
  hit_and_ru: null
  pcf_violat: null
  count_ped1: null
  count_mc_i: null
  pedestrian: null
  count_comp: null
  road_cond_: null
  count_mc_k: null
  accident_y: null
  number_kil: null
  juris: null
  count_seve: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Injury (Severe)
Domains:
Templates:
• Name: 2
  Description:
  Prototype:
  city_divis: null
  collision_: null
  county: null
  beat_type: null
  collisio_1: null
  location_t: null
  primary_rd: null
  primary_ra: null
  motorcycle: null
  proc_date: null
  point_y: null
  road_cond1: null
  point_x: null
  alcohol_in: null
  case_id: null
  weather_1: null
  weather_2: null
  postmile: null
  longitude: null
  chp_beat_t: null
  chp_shift: null
  secondary_: null
  beat_numbe: null
  postmile_p: null
  tow_away: null
  mviw: null
  chp_vehtyp: null
  pcf_viol_s: null
  stwd_vehty: null
  state_hwy_: null
  count_ped_: null
  lighting: null
  count_bi_1: null
  population: null
  chp_beat_c: null
  officer_id: null
  party_coun: null
  count_visi: null
  special_co: null
  pcf_viol_c: null
  ramp_inter: null
  route_suff: null
  day_of_wee: null
  distance: null
  bicycle_ac: null
  city: null
  caltrans_d: null
  caltrans_c: null
  not_privat: null
  latitude: null
  number_inj: null
  primary_co: null
  side_of_hw: null
  ped_action: null
  chp_road_t: null
  reporting_: null
  truck_acci: null
  collision1: null
  intersecti: null
  control_de: null
  direction: null
  state_rout: null
  road_surfa: null
  count_bicy: null
  cnty_city_: null
  type_of_co: null
  pcf_code_o: null
  secondary1: null
  hit_and_ru: null
  pcf_violat: null
  count_ped1: null
  count_mc_i: null
  pedestrian: null
  count_comp: null
  road_cond_: null
  count_mc_k: null
  accident_y: null
  number_kil: null
  juris: null
  count_seve: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Injury (Other Visable)
Domains:
Templates:
• Name: 3
  Description:
  Prototype:
  city_divis: null
  collision_: null
  county: null
  beat_type: null
  collisio_1: null
  location_t: null
  primary_rd: null
  primary_ra: null
  motorcycle: null
  proc_date: null
  point_y: null
  road_cond1: null
  point_x: null
  alcohol_in: null
  case_id: null
  weather_1: null
  weather_2: null
  postmile: null
  longitude: null
  chp_beat_t: null
  chp_shift: null
  secondary_: null
  beat_numbe: null
  postmile_p: null
  tow_away: null
  mviw: null
  chp_vehtyp: null
  pcf_viol_s: null
  stwd_vehty: null
  state_hwy_: null
  count_ped_: null
  lighting: null
  count_bi_1: null
  population: null
  chp_beat_c: null
  officer_id: null
  party_coun: null
  count_visi: null
  special_co: null
  pcf_viol_c: null
  ramp_inter: null
  route_suff: null
  day_of_wee: null
  distance: null
  bicycle_ac: null
  city: null
  caltrans_d: null
  caltrans_c: null
  not_privat: null
  latitude: null
  number_inj: null
  primary_co: null
  side_of_hw: null
  ped_action: null
  chp_road_t: null
  reporting_: null
  truck_acci: null
  collision1: null
  intersecti: null
  control_de: null
  direction: null
  state_rout: null
  road_surfa: null
  count_bicy: null
  cnty_city_: null
  type_of_co: null
  pcf_code_o: null
  secondary1: null
  hit_and_ru: null
  pcf_violat: null
  count_ped1: null
  count_mc_i: null
  pedestrian: null
  count_comp: null
  road_cond_: null
  count_mc_k: null
  accident_y: null
  number_kil: null
  juris: null
  count_seve: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Injury (Complaint of Pain)
Domains:
Templates:
• Name: 4
  Description:
  Prototype:
  city_divis: null
  collision_: null
  county: null
  beat_type: null
  collisio_1: null
  location_t: null
  primary_rd: null
  primary_ra: null
  motorcycle: null
  proc_date: null
  point_y: null
  road_cond1: null
  point_x: null
  alcohol_in: null
  case_id: null
  weather_1: null
  weather_2: null
  postmile: null
  longitude: null
  chp_beat_t: null
  chp_shift: null
  secondary_: null
  beat_numbe: null
  postmile_p: null
  tow_away: null
  mviw: null
  chp_vehtyp: null
  pcf_viol_s: null
  stwd_vehty: null
  state_hwy_: null
  count_ped_: null
  lighting: null
  count_bi_1: null
  population: null
  chp_beat_c: null
  officer_id: null
  party_coun: null
  count_visi: null
  special_co: null
  pcf_viol_c: null
  ramp_inter: null
  route_suff: null
  day_of_wee: null
  distance: null
  bicycle_ac: null
  city: null
  caltrans_d: null
  caltrans_c: null
  not_privat: null
  latitude: null
  number_inj: null
  primary_co: null
  side_of_hw: null
  ped_action: null
  chp_road_t: null
  reporting_: null
  truck_acci: null
  collision1: null
  intersecti: null
  control_de: null
  direction: null
  state_rout: null
  road_surfa: null
  count_bicy: null
  cnty_city_: null
  type_of_co: null
  pcf_code_o: null
  secondary1: null
  hit_and_ru: null
  pcf_violat: null
  count_ped1: null
  count_mc_i: null
  pedestrian: null
  count_comp: null
  road_cond_: null
  count_mc_k: null
  accident_y: null
  number_kil: null
  juris: null
  count_seve: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata