View In:   ArcGIS Online Map Viewer

Name: 3.4.2_Superfund-Enterprise-Management-System_USAEPA

Display Field: primary_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This data provides location and attribute information on Facilities regulated under the Superfund Enterprise Management System (SEMS). The Superfund Enterprise Management System (SEMS) integrates multiple legacy systems (e.g., CERCLIS, ICTS, SDMS) into a comprehensive tracking and reporting tool, providing data on the inventory of active and archived hazardous waste sites evaluated by the Superfund program. It contains sites that are either proposed to be, or are on, the National Priorities List (NPL) as well as sites that are in the screening and assessment phase for possible inclusion on the NPL. The data provided in this service are obtained from EPA's Facility Registry Service (FRS). The FRS is an integrated source of comprehensive (air, water, and waste) environmental information about facilities, sites or places. This service connects directly to the FRS database to provide this data as a feature service. FRS creates high-quality, accurate, and authoritative facility identification records through rigorous verification and management procedures that incorporate information from program national systems, state master facility records, data collected from EPA's Central Data Exchange registrations and data management personnel. Additional Information on FRS is available at the EPA website https://www.epa.gov/enviro/facility-registry-service-frs.

Service Item Id: a9426a6ffed94ca79cf8e4a9008b6a77

Copyright Text: This EPA Geospatial data set is generated by the U.S. EPA FRS Support team from the following national environmental programs: Superfund National Priorities List (NPL) from the Superfund Enterprise Management System (SEMS).

Default Visibility: false

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: -1.38427038991E7
YMin: 3834406.5710999966
XMax: -1.27069355824E7
YMax: 5160397.711599998
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• registry_id ( modelName: registry_id, nullable: false, editable: true, defaultValue: null, length: 12, alias: REGISTRY_ID, type: esriFieldTypeString )
• primary_name ( modelName: primary_name, nullable: true, editable: true, defaultValue: null, length: 150, alias: PRIMARY_NAME, type: esriFieldTypeString )
• location_address ( modelName: location_address, nullable: true, editable: true, defaultValue: null, length: 100, alias: LOCATION_ADDRESS, type: esriFieldTypeString )
• city_name ( modelName: city_name, nullable: true, editable: true, defaultValue: null, length: 60, alias: CITY_NAME, type: esriFieldTypeString )
• county_name ( modelName: county_name, nullable: true, editable: true, defaultValue: null, length: 35, alias: COUNTY_NAME, type: esriFieldTypeString )
• fips_code ( modelName: fips_code, nullable: true, editable: true, defaultValue: null, length: 5, alias: FIPS_CODE, type: esriFieldTypeString )
• state_code ( modelName: state_code, nullable: true, editable: true, defaultValue: null, length: 5, alias: STATE_CODE, type: esriFieldTypeString )
• postal_code ( modelName: postal_code, nullable: true, editable: true, defaultValue: null, length: 14, alias: POSTAL_CODE, type: esriFieldTypeString )
• latitude83 ( modelName: latitude83, nullable: true, editable: true, defaultValue: null, alias: LATITUDE83, type: esriFieldTypeDouble )
• longitude83 ( modelName: longitude83, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE83, type: esriFieldTypeDouble )
• huc8_code ( modelName: huc8_code, nullable: true, editable: true, defaultValue: null, length: 8, alias: HUC8_CODE, type: esriFieldTypeString )
• accuracy_value ( modelName: accuracy_value, nullable: true, editable: true, defaultValue: null, alias: ACCURACY_VALUE, type: esriFieldTypeInteger )
• collect_mth_desc ( modelName: collect_mth_desc, nullable: true, editable: true, defaultValue: null, length: 250, alias: COLLECT_MTH_DESC, type: esriFieldTypeString )
• ref_point_desc ( modelName: ref_point_desc, nullable: true, editable: true, defaultValue: null, length: 250, alias: REF_POINT_DESC, type: esriFieldTypeString )
• create_date ( modelName: create_date, nullable: false, editable: true, defaultValue: null, precision: 1, length: 29, alias: CREATE_DATE, type: esriFieldTypeDate )
• update_date ( modelName: update_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: UPDATE_DATE, type: esriFieldTypeDate )
• last_reported_date ( modelName: last_reported_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LAST_REPORTED_DATE, type: esriFieldTypeDate )
• fac_url ( modelName: fac_url, nullable: true, editable: true, defaultValue: null, length: 100, alias: FAC_URL, type: esriFieldTypeString )
• pgm_sys_id ( modelName: pgm_sys_id, nullable: false, editable: true, defaultValue: null, length: 30, alias: PGM_SYS_ID, type: esriFieldTypeString )
• pgm_sys_acrnm ( modelName: pgm_sys_acrnm, nullable: false, editable: true, defaultValue: null, length: 20, alias: PGM_SYS_ACRNM, type: esriFieldTypeString )
• interest_type ( modelName: interest_type, nullable: false, editable: true, defaultValue: null, length: 60, alias: INTEREST_TYPE, type: esriFieldTypeString )
• program_url ( modelName: program_url, nullable: true, editable: true, defaultValue: null, length: 100, alias: PROGRAM_URL, type: esriFieldTypeString )
• pgm_report_url ( modelName: pgm_report_url, nullable: true, editable: true, defaultValue: null, length: 11, alias: PGM_REPORT_URL, type: esriFieldTypeString )
• public_ind ( modelName: public_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: PUBLIC_IND, type: esriFieldTypeString )
• active_status ( modelName: active_status, nullable: true, editable: true, defaultValue: null, length: 50, alias: ACTIVE_STATUS, type: esriFieldTypeString )
• federal_agency_name ( modelName: federal_agency_name, nullable: true, editable: true, defaultValue: null, length: 100, alias: FEDERAL_AGENCY_NAME, type: esriFieldTypeString )
• huc_12 ( modelName: huc_12, nullable: true, editable: true, defaultValue: null, length: 12, alias: HUC_12, type: esriFieldTypeString )
• federal_land_ind ( modelName: federal_land_ind, nullable: true, editable: true, defaultValue: null, length: 1, alias: FEDERAL_LAND_IND, type: esriFieldTypeString )
• fed_facility_code ( modelName: fed_facility_code, nullable: true, editable: true, defaultValue: null, length: 1, alias: FED_FACILITY_CODE, type: esriFieldTypeString )
• epa_region_code ( modelName: epa_region_code, nullable: true, editable: true, defaultValue: null, length: 2, alias: EPA_REGION_CODE, type: esriFieldTypeString )
• key_field ( modelName: key_field, nullable: true, editable: true, defaultValue: null, length: 50, alias: KEY_FIELD, type: esriFieldTypeString )

Templates:

• Name: 3.4.2_Superfund-Enterprise-Management-System_USAEPA
  Description:
  Prototype:
  pgm_sys_id:
  public_ind: null
  ref_point_desc: null
  fips_code: null
  collect_mth_desc: null
  pgm_report_url: null
  fed_facility_code: null
  registry_id:
  city_name: null
  last_reported_date: null
  federal_agency_name: null
  accuracy_value: null
  latitude83: null
  fac_url: null
  create_date: -2209161600000
  pgm_sys_acrnm:
  huc_12: null
  location_address: null
  interest_type:
  federal_land_ind: null
  county_name: null
  update_date: null
  huc8_code: null
  active_status: null
  key_field: null
  program_url: null
  primary_name: null
  state_code: null
  postal_code: null
  epa_region_code: null
  longitude83: 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