View In:   ArcGIS Online Map Viewer

Name: sde_switrs_safety_collisions_ODP_webview

Display Field: case_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7806511a310c468792b7777eee9ea735

Copyright Text:

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: 6151378.485833719
YMin: 1775795.1396674812
XMax: 6641948.512237638
YMax: 2124619.8199694753
Spatial Reference: 102646  (2230)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [135, 128, 67, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 8, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• case_id ( modelName: case_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CASE_ID, type: esriFieldTypeString )
• accident_year ( modelName: accident_year, nullable: true, editable: true, defaultValue: null, alias: ACCIDENT_YEAR, type: esriFieldTypeInteger )
• juris ( modelName: juris, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: JURIS, type: esriFieldTypeString )
• officer_id ( modelName: officer_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: OFFICER_ID, type: esriFieldTypeString )
• reporting_district ( modelName: reporting_district, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: REPORTING_DISTRICT, type: esriFieldTypeString )
• day_of_week ( modelName: day_of_week, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: DAY_OF_WEEK, type: esriFieldTypeString )
• chp_shift ( modelName: chp_shift, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CHP_SHIFT, type: esriFieldTypeString )
• population ( modelName: population, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: POPULATION, type: esriFieldTypeString )
• cnty_city_loc ( modelName: cnty_city_loc, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CNTY_CITY_LOC, type: esriFieldTypeString )
• special_cond ( modelName: special_cond, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SPECIAL_COND, type: esriFieldTypeString )
• beat_type ( modelName: beat_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: BEAT_TYPE, type: esriFieldTypeString )
• chp_beat_type ( modelName: chp_beat_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CHP_BEAT_TYPE, type: esriFieldTypeString )
• city_division_lapd ( modelName: city_division_lapd, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CITY_DIVISION_LAPD, type: esriFieldTypeString )
• chp_beat_class ( modelName: chp_beat_class, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CHP_BEAT_CLASS, type: esriFieldTypeString )
• beat_number ( modelName: beat_number, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: BEAT_NUMBER, type: esriFieldTypeString )
• primary_rd ( modelName: primary_rd, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_RD, type: esriFieldTypeString )
• secondary_rd ( modelName: secondary_rd, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SECONDARY_RD, 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: 2147483647, alias: DIRECTION, type: esriFieldTypeString )
• intersection ( modelName: intersection, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: INTERSECTION, type: esriFieldTypeString )
• weather_1 ( modelName: weather_1, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: WEATHER_1, type: esriFieldTypeString )
• weather_2 ( modelName: weather_2, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: WEATHER_2, type: esriFieldTypeString )
• state_hwy_ind ( modelName: state_hwy_ind, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: STATE_HWY_IND, type: esriFieldTypeString )
• caltrans_county ( modelName: caltrans_county, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CALTRANS_COUNTY, type: esriFieldTypeString )
• caltrans_district ( modelName: caltrans_district, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CALTRANS_DISTRICT, type: esriFieldTypeString )
• state_route ( modelName: state_route, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: STATE_ROUTE, type: esriFieldTypeString )
• route_suffix ( modelName: route_suffix, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ROUTE_SUFFIX, type: esriFieldTypeString )
• postmile_prefix ( modelName: postmile_prefix, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: POSTMILE_PREFIX, type: esriFieldTypeString )
• postmile ( modelName: postmile, nullable: true, editable: true, defaultValue: null, alias: POSTMILE, type: esriFieldTypeDouble )
• location_type ( modelName: location_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: LOCATION_TYPE, type: esriFieldTypeString )
• ramp_intersection ( modelName: ramp_intersection, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: RAMP_INTERSECTION, type: esriFieldTypeString )
• side_of_highway ( modelName: side_of_highway, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SIDE_OF_HIGHWAY, type: esriFieldTypeString )
• tow_away ( modelName: tow_away, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: TOW_AWAY, type: esriFieldTypeString )
• collision_severity ( modelName: collision_severity, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: COLLISION_SEVERITY, type: esriFieldTypeString )
• number_killed ( modelName: number_killed, nullable: true, editable: true, defaultValue: null, alias: NUMBER_KILLED, type: esriFieldTypeInteger )
• number_injured ( modelName: number_injured, nullable: true, editable: true, defaultValue: null, alias: NUMBER_INJURED, type: esriFieldTypeInteger )
• party_count ( modelName: party_count, nullable: true, editable: true, defaultValue: null, alias: PARTY_COUNT, type: esriFieldTypeInteger )
• primary_coll_factor ( modelName: primary_coll_factor, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_COLL_FACTOR, type: esriFieldTypeString )
• pcf_code_of_viol ( modelName: pcf_code_of_viol, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PCF_CODE_OF_VIOL, type: esriFieldTypeString )
• pcf_viol_category ( modelName: pcf_viol_category, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PCF_VIOL_CATEGORY, type: esriFieldTypeString )
• pcf_violation ( modelName: pcf_violation, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PCF_VIOLATION, type: esriFieldTypeString )
• pcf_viol_subsection ( modelName: pcf_viol_subsection, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PCF_VIOL_SUBSECTION, type: esriFieldTypeString )
• hit_and_run ( modelName: hit_and_run, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: HIT_AND_RUN, type: esriFieldTypeString )
• type_of_collision ( modelName: type_of_collision, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: TYPE_OF_COLLISION, type: esriFieldTypeString )
• mviw ( modelName: mviw, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: MVIW, type: esriFieldTypeString )
• ped_action ( modelName: ped_action, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PED_ACTION, type: esriFieldTypeString )
• road_surface ( modelName: road_surface, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ROAD_SURFACE, type: esriFieldTypeString )
• road_cond_1 ( modelName: road_cond_1, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ROAD_COND_1, type: esriFieldTypeString )
• road_cond_2 ( modelName: road_cond_2, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ROAD_COND_2, type: esriFieldTypeString )
• lighting ( modelName: lighting, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: LIGHTING, type: esriFieldTypeString )
• control_device ( modelName: control_device, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CONTROL_DEVICE, type: esriFieldTypeString )
• chp_road_type ( modelName: chp_road_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CHP_ROAD_TYPE, type: esriFieldTypeString )
• pedestrian_accident ( modelName: pedestrian_accident, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PEDESTRIAN_ACCIDENT, type: esriFieldTypeString )
• bicycle_accident ( modelName: bicycle_accident, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: BICYCLE_ACCIDENT, type: esriFieldTypeString )
• motorcycle_accident ( modelName: motorcycle_accident, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: MOTORCYCLE_ACCIDENT, type: esriFieldTypeString )
• truck_accident ( modelName: truck_accident, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: TRUCK_ACCIDENT, type: esriFieldTypeString )
• not_private_property ( modelName: not_private_property, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NOT_PRIVATE_PROPERTY, type: esriFieldTypeString )
• alcohol_involved ( modelName: alcohol_involved, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: ALCOHOL_INVOLVED, type: esriFieldTypeString )
• stwd_vehtype_at_fault ( modelName: stwd_vehtype_at_fault, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: STWD_VEHTYPE_AT_FAULT, type: esriFieldTypeString )
• chp_vehtype_at_fault ( modelName: chp_vehtype_at_fault, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CHP_VEHTYPE_AT_FAULT, type: esriFieldTypeString )
• count_severe_inj ( modelName: count_severe_inj, nullable: true, editable: true, defaultValue: null, alias: COUNT_SEVERE_INJ, type: esriFieldTypeInteger )
• count_visible_inj ( modelName: count_visible_inj, nullable: true, editable: true, defaultValue: null, alias: COUNT_VISIBLE_INJ, type: esriFieldTypeInteger )
• count_complaint_pain ( modelName: count_complaint_pain, nullable: true, editable: true, defaultValue: null, alias: COUNT_COMPLAINT_PAIN, type: esriFieldTypeInteger )
• count_ped_killed ( modelName: count_ped_killed, nullable: true, editable: true, defaultValue: null, alias: COUNT_PED_KILLED, type: esriFieldTypeInteger )
• count_ped_injured ( modelName: count_ped_injured, nullable: true, editable: true, defaultValue: null, alias: COUNT_PED_INJURED, type: esriFieldTypeInteger )
• count_bicyclist_killed ( modelName: count_bicyclist_killed, nullable: true, editable: true, defaultValue: null, alias: COUNT_BICYCLIST_KILLED, type: esriFieldTypeInteger )
• count_bicyclist_injured ( modelName: count_bicyclist_injured, nullable: true, editable: true, defaultValue: null, alias: COUNT_BICYCLIST_INJURED, type: esriFieldTypeInteger )
• count_mc_killed ( modelName: count_mc_killed, nullable: true, editable: true, defaultValue: null, alias: COUNT_MC_KILLED, type: esriFieldTypeInteger )
• count_mc_injured ( modelName: count_mc_injured, nullable: true, editable: true, defaultValue: null, alias: COUNT_MC_INJURED, type: esriFieldTypeInteger )
• primary_ramp ( modelName: primary_ramp, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_RAMP, type: esriFieldTypeString )
• secondary_ramp ( modelName: secondary_ramp, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SECONDARY_RAMP, 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 )
• sandag_region ( modelName: sandag_region, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: sandag_region, type: esriFieldTypeString )
• sandag_case_id ( modelName: sandag_case_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: SANDAG_CASE_ID, type: esriFieldTypeString )
• geocode_method ( modelName: geocode_method, nullable: true, editable: true, defaultValue: null, length: 19, alias: GEOCODE_METHOD, type: esriFieldTypeString )
• offsettype ( modelName: offsettype, nullable: true, editable: true, defaultValue: null, length: 255, alias: OffsetType, type: esriFieldTypeString )
• latitude_sandag ( modelName: latitude_sandag, nullable: true, editable: true, defaultValue: null, alias: LATITUDE_sandag, type: esriFieldTypeDouble )
• longitude_sandag ( modelName: longitude_sandag, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE_sandag, type: esriFieldTypeDouble )
• x ( modelName: x, nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( modelName: y, nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• loc_approx ( modelName: loc_approx, nullable: true, editable: true, defaultValue: null, alias: LOC_APPROX, type: esriFieldTypeInteger )
• location_sandag ( modelName: location_sandag, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Location_sandag, type: esriFieldTypeString )
• reservation_sandag ( modelName: reservation_sandag, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Reservation_sandag, type: esriFieldTypeString )
• collision_date ( modelName: collision_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: COLLISION_DATE, type: esriFieldTypeDate )
• proc_date ( modelName: proc_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: PROC_DATE, type: esriFieldTypeDate )
• collision_time ( modelName: collision_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: COLLISION_TIME, type: esriFieldTypeDate )

Templates:

• Name: sde_switrs_safety_collisions_ODP_webview
  Description:
  Prototype:
  sandag_case_id: null
  geocode_method: null
  beat_type: null
  latitude_sandag: null
  primary_rd: null
  secondary_rd: null
  ramp_intersection: null
  reservation_sandag: null
  collision_time: null
  party_count: null
  road_cond_1: null
  proc_date: null
  road_cond_2: null
  intersection: null
  case_id: null
  weather_1: null
  bicycle_accident: null
  weather_2: null
  caltrans_county: null
  cnty_city_loc: null
  caltrans_district: null
  postmile: null
  longitude: null
  accident_year: null
  reporting_district: null
  chp_shift: null
  tow_away: null
  mviw: null
  lighting: null
  population: null
  pedestrian_accident: null
  count_bicyclist_injured: null
  officer_id: null
  longitude_sandag: null
  collision_date: null
  beat_number: null
  primary_ramp: null
  control_device: null
  truck_accident: null
  count_severe_inj: null
  count_mc_killed: null
  chp_beat_type: null
  pcf_violation: null
  secondary_ramp: null
  distance: null
  motorcycle_accident: null
  latitude: null
  stwd_vehtype_at_fault: null
  pcf_code_of_viol: null
  alcohol_involved: null
  hit_and_run: null
  ped_action: null
  count_ped_injured: null
  chp_beat_class: null
  type_of_collision: null
  day_of_week: null
  direction: null
  count_bicyclist_killed: null
  postmile_prefix: null
  pcf_viol_category: null
  road_surface: null
  side_of_highway: null
  count_complaint_pain: null
  count_mc_injured: null
  loc_approx: null
  location_type: null
  pcf_viol_subsection: null
  location_sandag: null
  special_cond: null
  primary_coll_factor: null
  city_division_lapd: null
  chp_road_type: null
  number_killed: null
  not_private_property: null
  count_visible_inj: null
  chp_vehtype_at_fault: null
  sandag_region: null
  count_ped_killed: null
  x: null
  y: null
  number_injured: null
  state_hwy_ind: null
  route_suffix: null
  collision_severity: null
  juris: null
  state_route: null
  offsettype: 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