Name: SEMS_USEPA_Superfund_Mapping

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.

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).

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9204065.1614
YMin: 4864025.4062
XMax: -9176206.3376
YMax: 4883592.2676
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,137,73,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• REGISTRY_ID (type: esriFieldTypeString, alias: REGISTRY_ID, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• PRIMARY_NAME (type: esriFieldTypeString, alias: PRIMARY_NAME, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LOCATION_ADDRESS (type: esriFieldTypeString, alias: LOCATION_ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CITY_NAME (type: esriFieldTypeString, alias: CITY_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: COUNTY_NAME, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• FIPS_CODE (type: esriFieldTypeString, alias: FIPS_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• STATE_CODE (type: esriFieldTypeString, alias: STATE_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POSTAL_CODE (type: esriFieldTypeString, alias: POSTAL_CODE, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• LATITUDE83 (type: esriFieldTypeDouble, alias: LATITUDE83, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE83 (type: esriFieldTypeDouble, alias: LONGITUDE83, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HUC8_CODE (type: esriFieldTypeString, alias: HUC8_CODE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACCURACY_VALUE (type: esriFieldTypeInteger, alias: ACCURACY_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COLLECT_MTH_DESC (type: esriFieldTypeString, alias: COLLECT_MTH_DESC, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• REF_POINT_DESC (type: esriFieldTypeString, alias: REF_POINT_DESC, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CREATE_DATE (type: esriFieldTypeDate, alias: CREATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_REPORTED_DATE (type: esriFieldTypeDate, alias: LAST_REPORTED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FAC_URL (type: esriFieldTypeString, alias: FAC_URL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PGM_SYS_ID (type: esriFieldTypeString, alias: PGM_SYS_ID, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• PGM_SYS_ACRNM (type: esriFieldTypeString, alias: PGM_SYS_ACRNM, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• INTEREST_TYPE (type: esriFieldTypeString, alias: INTEREST_TYPE, SQL Type: sqlTypeOther, length: 60, nullable: false, editable: true)
• PROGRAM_URL (type: esriFieldTypeString, alias: PROGRAM_URL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PGM_REPORT_URL (type: esriFieldTypeString, alias: PGM_REPORT_URL, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• PUBLIC_IND (type: esriFieldTypeString, alias: PUBLIC_IND, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ACTIVE_STATUS (type: esriFieldTypeString, alias: ACTIVE_STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FEDERAL_AGENCY_NAME (type: esriFieldTypeString, alias: FEDERAL_AGENCY_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HUC_12 (type: esriFieldTypeString, alias: HUC_12, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• FEDERAL_LAND_IND (type: esriFieldTypeString, alias: FEDERAL_LAND_IND, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FED_FACILITY_CODE (type: esriFieldTypeString, alias: FED_FACILITY_CODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• EPA_REGION_CODE (type: esriFieldTypeString, alias: EPA_REGION_CODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• KEY_FIELD (type: esriFieldTypeString, alias: KEY_FIELD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: SEMS_USEPA_Superfund_Mapping
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• REGISTRY_ID:
• CREATE_DATE: -2209161600000
• PGM_SYS_ID:
• PGM_SYS_ACRNM:
• INTEREST_TYPE:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/6/2024 9:10:20 PM

Schema Last Edit Date: 5/6/2024 9:10:20 PM

Data Last Edit Date: 5/6/2024 9:10:20 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat