View In:   ArcGIS Online Map Viewer

Name: Cleanup Program Sites

Display Field: business_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 67f43e586f6d4974a54bdc9c4aa286de

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: 216648.23610000033
YMin: 3850217.0758999996
XMax: 719903.0409000004
YMax: 4640904.706700001
Spatial Reference: 26911  (26911)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Completed - Case Closed
  Label: Completed - Case Closed
  Description: N/A
  Symbol:
  
• Value: Open - Assessment & Interim Remedial Action
  Label: Open - Assessment & Interim Remedial Action
  Description: N/A
  Symbol:
  
• Value: Open - Inactive
  Label: Open - Inactive
  Description: N/A
  Symbol:
  
• Value: Open - Remediation
  Label: Open - Remediation
  Description: N/A
  Symbol:
  
• Value: Open - Site Assessment
  Label: Open - Site Assessment
  Description: N/A
  Symbol:
  
• Value: Open - Verification Monitoring
  Label: Open - Verification Monitoring
  Description: N/A
  Symbol:
  
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: status

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• global_id ( modelName: GLOBAL_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: GLOBAL_ID, type: esriFieldTypeString )
• business_name ( modelName: BUSINESS_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: BUSINESS_NAME, type: esriFieldTypeString )
• street_number ( modelName: STREET_NUMBER, nullable: true, editable: true, defaultValue: null, length: 255, alias: STREET_NUMBER, type: esriFieldTypeString )
• street_name ( modelName: STREET_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: STREET_NAME, type: esriFieldTypeString )
• city ( modelName: CITY, nullable: true, editable: true, defaultValue: null, length: 255, alias: CITY, type: esriFieldTypeString )
• state ( modelName: STATE, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATE, type: esriFieldTypeString )
• zip ( modelName: ZIP, nullable: true, editable: true, defaultValue: null, length: 255, alias: ZIP, type: esriFieldTypeString )
• county ( modelName: COUNTY, nullable: true, editable: true, defaultValue: null, length: 255, alias: COUNTY, type: esriFieldTypeString )
• epa_region ( modelName: EPA_REGION, nullable: true, editable: true, defaultValue: null, alias: EPA_REGION, type: esriFieldTypeInteger )
• 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 )
• coordinate_source ( modelName: COORDINATE_SOURCE, nullable: true, editable: true, defaultValue: null, length: 255, alias: COORDINATE_SOURCE, type: esriFieldTypeString )
• case_type ( modelName: CASE_TYPE, nullable: true, editable: true, defaultValue: null, length: 255, alias: CASE_TYPE, type: esriFieldTypeString )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATUS, type: esriFieldTypeString )
• status_date ( modelName: STATUS_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: STATUS_DATE, type: esriFieldTypeDate )
• cuf_case ( modelName: CUF_CASE, nullable: true, editable: true, defaultValue: null, length: 255, alias: CUF_CASE, type: esriFieldTypeString )
• lead_agency ( modelName: LEAD_AGENCY, nullable: true, editable: true, defaultValue: null, length: 255, alias: LEAD_AGENCY, type: esriFieldTypeString )
• caseworker ( modelName: CASEWORKER, nullable: true, editable: true, defaultValue: null, length: 255, alias: CASEWORKER, type: esriFieldTypeString )
• local_agency ( modelName: LOCAL_AGENCY, nullable: true, editable: true, defaultValue: null, length: 255, alias: LOCAL_AGENCY, type: esriFieldTypeString )
• rb_case_number ( modelName: RB_CASE_NUMBER, nullable: true, editable: true, defaultValue: null, length: 255, alias: RB_CASE_NUMBER, type: esriFieldTypeString )
• loc_case_number ( modelName: LOC_CASE_NUMBER, nullable: true, editable: true, defaultValue: null, length: 255, alias: LOC_CASE_NUMBER, type: esriFieldTypeString )
• file_location ( modelName: FILE_LOCATION, nullable: true, editable: true, defaultValue: null, length: 255, alias: FILE_LOCATION, type: esriFieldTypeString )
• potential_contaminants_of_concern ( modelName: POTENTIAL_CONTAMINANTS_OF_CONCERN, nullable: true, editable: true, defaultValue: null, length: 734, alias: POTENTIAL_CONTAMINANTS_OF_CONCERN, type: esriFieldTypeString )
• quantity_released_gallons ( modelName: QUANTITY_RELEASED_GALLONS, nullable: true, editable: true, defaultValue: null, alias: QUANTITY_RELEASED_GALLONS, type: esriFieldTypeInteger )
• potential_media_of_concern ( modelName: POTENTIAL_MEDIA_OF_CONCERN, nullable: true, editable: true, defaultValue: null, length: 255, alias: POTENTIAL_MEDIA_OF_CONCERN, type: esriFieldTypeString )
• site_history ( modelName: SITE_HISTORY, nullable: true, editable: true, defaultValue: null, length: 16009, alias: SITE_HISTORY, type: esriFieldTypeString )
• begin_date ( modelName: BEGIN_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: BEGIN_DATE, type: esriFieldTypeDate )
• leak_reported_date ( modelName: LEAK_REPORTED_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LEAK_REPORTED_DATE, type: esriFieldTypeDate )
• how_discovered ( modelName: HOW_DISCOVERED, nullable: true, editable: true, defaultValue: null, length: 255, alias: HOW_DISCOVERED, type: esriFieldTypeString )
• how_discovered_description ( modelName: HOW_DISCOVERED_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 294, alias: HOW_DISCOVERED_DESCRIPTION, type: esriFieldTypeString )
• discharge_source ( modelName: DISCHARGE_SOURCE, nullable: true, editable: true, defaultValue: null, length: 255, alias: DISCHARGE_SOURCE, type: esriFieldTypeString )
• discharge_cause ( modelName: DISCHARGE_CAUSE, nullable: true, editable: true, defaultValue: null, length: 255, alias: DISCHARGE_CAUSE, type: esriFieldTypeString )
• stop_method ( modelName: STOP_METHOD, nullable: true, editable: true, defaultValue: null, length: 255, alias: STOP_METHOD, type: esriFieldTypeString )
• stop_description ( modelName: STOP_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 326, alias: STOP_DESCRIPTION, type: esriFieldTypeString )
• no_further_action_date ( modelName: NO_FURTHER_ACTION_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: NO_FURTHER_ACTION_DATE, type: esriFieldTypeDate )
• calwater_watershed_name ( modelName: CALWATER_WATERSHED_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: CALWATER_WATERSHED_NAME, type: esriFieldTypeString )
• dwr_groundwater_subbasin_name ( modelName: DWR_GROUNDWATER_SUBBASIN_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: DWR_GROUNDWATER_SUBBASIN_NAME, type: esriFieldTypeString )
• disadvantaged_community ( modelName: DISADVANTAGED_COMMUNITY, nullable: true, editable: true, defaultValue: null, length: 255, alias: DISADVANTAGED_COMMUNITY, type: esriFieldTypeString )
• calenviroscreen3_score ( modelName: CALENVIROSCREEN3_SCORE, nullable: true, editable: true, defaultValue: null, length: 255, alias: CALENVIROSCREEN3_SCORE, type: esriFieldTypeString )
• calenviroscreen4_score ( modelName: CALENVIROSCREEN4_SCORE, nullable: true, editable: true, defaultValue: null, length: 255, alias: CALENVIROSCREEN4_SCORE, type: esriFieldTypeString )
• military_dod_site ( modelName: MILITARY_DOD_SITE, nullable: true, editable: true, defaultValue: null, length: 255, alias: MILITARY_DOD_SITE, type: esriFieldTypeString )
• facility_project_subtype ( modelName: FACILITY_PROJECT_SUBTYPE, nullable: true, editable: true, defaultValue: null, length: 255, alias: FACILITY_PROJECT_SUBTYPE, type: esriFieldTypeString )
• datadownloaddate ( modelName: datadownloaddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DataDownloadDate, type: esriFieldTypeDate )

Types:

ID: Completed - Case Closed
Name: Completed - Case Closed
Domains:
Templates:
• Name: Completed - Case Closed
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Completed - Case Closed
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open - Assessment & Interim Remedial Action
Name: Open - Assessment & Interim Remedial Action
Domains:
Templates:
• Name: Open - Assessment & Interim Remedial Action
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Open - Assessment & Interim Remedial Action
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open - Inactive
Name: Open - Inactive
Domains:
Templates:
• Name: Open - Inactive
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Open - Inactive
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open - Remediation
Name: Open - Remediation
Domains:
Templates:
• Name: Open - Remediation
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Open - Remediation
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open - Site Assessment
Name: Open - Site Assessment
Domains:
Templates:
• Name: Open - Site Assessment
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Open - Site Assessment
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open - Verification Monitoring
Name: Open - Verification Monitoring
Domains:
Templates:
• Name: Open - Verification Monitoring
  Description:
  Prototype:
  status_date: null
  calwater_watershed_name: null
  datadownloaddate: null
  city: null
  latitude: null
  begin_date: null
  county: null
  epa_region: null
  calenviroscreen4_score: null
  loc_case_number: null
  street_name: null
  military_dod_site: null
  rb_case_number: null
  discharge_source: null
  no_further_action_date: null
  coordinate_source: null
  stop_method: null
  potential_media_of_concern: null
  local_agency: null
  how_discovered_description: null
  state: null
  quantity_released_gallons: null
  caseworker: null
  longitude: null
  cuf_case: null
  zip: null
  business_name: null
  lead_agency: null
  file_location: null
  global_id: null
  case_type: null
  disadvantaged_community: null
  calenviroscreen3_score: null
  site_history: null
  leak_reported_date: null
  dwr_groundwater_subbasin_name: null
  stop_description: null
  how_discovered: null
  discharge_cause: null
  potential_contaminants_of_concern: null
  facility_project_subtype: null
  street_number: null
  status: Open - Verification Monitoring
  
  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