USEPA Geospatial Metadata

Description: Abstract: The Superfund Enterprise Management System (SEMS) is EPA's "official record" for tracking hazardous waste sites, potentially hazardous waste sites, and remedial activities performed in support of the Superfund Program across the nation. This includes sites that are on the National Priorities List (NPL) or are being considered for the NPL. SEMS represents a joint development and ongoing collaboration between Superfund's Remedial, Removal, Federal Facilities, Enforcement, and Emergency Response programs. It provides its wide audience base with a means of ongoing analysis of Superfund Program activities and informational needs at the site, regional management, and national management levels. The customers of SEMS or SEMS data are five EPA Headquarters offices and regional staff, citizens, the regulated community, other Federal agencies, States, Tribes, local agencies, and industry. SEMS stakeholders are States, Congress, other Federal agencies, industry groups, and citizens. The informal partnerships established with Federal, State, local government, and industry groups are key to the reliability and tracking of environmental cleanup data and ultimate protection of human health and the environment. SEMS is an adaptive and tailored technical solution that is transforming the Superfund program by improving operational effectiveness, reducing costs, streamlining business processes, and enhancing information management capabilities. The solution serves as a model for how the Federal Government serves the public, the regulated community and partner agencies alike. The SEMS NPL [R2] GIS layer and SEMS NON NPL [R2] GIS layer are generated as the ArcGIS 10.5 [EPA_FACILITIES_PROJECTED_R2_SEMS_NPL_P] and [EPA_FACILITIES_PROJECTED_R2_SEMS_NON_NPL_P] POINT Feature Classes hosted in the R2 SQLServer 2016 geodatabase. The SEMS NPL [R2] layer contains only SEMS site records FOR R2 NPL sites. This GIS layer only has R2 SEMS records with the following NPL_STATUS designations: 'CURRENTLY ON FINAL NPL', 'DELETED FROM FINAL NPL', 'PROPOSED FOR NPL'. The SEMS NON NPL [R2] GIS layer only has unique R2 SEMS records with best available coordinates that are not included in the NPL layer as well as those records that do not have the Non_NPL_Status values of "Not a valid site or incident". There are 4310 records in this layer and 90 do not have coordinates. All data for EPA Region 2 SEMS layers are extracted from the SEMS database via the Oracle BI Ad Hoc Query function. Tables queried are the SUPERFUND UNIVERSE. Geographic Coordinate table and SUPERFUND. Site table on a quarterly basis. This data as a tab delimited text file is then brought into our SQLServer 2012 database via a bulk insert operation. The locational data in this SEMS SQL Server table then undergoes two stages of automated data prep due to reversed coordinates, unsigned longitude, incorrectly located decimal points and datums that don't correspond to collection_methods where both exist. Users should keep in mind that much of the locational data for the NON NPL sites was acquired years ago without verification and should be used with caution. Both our Region 2 NPL and NON NPL GIS layers include an ArcGIS relationship class (many to one on SITE_ID) with the look-up table R2_SEMS_SCAP_SITE_OU. This table provides information on any associated OPERARABLE UNITS at the Site of concern, usually an NPL Site. During cleanup, a site can be divided into a number of distinct areas depending on its complexity. These areas, called operable units (OUs), may address geographic areas, specific problems, or areas where a specific action is required. Examples of typical operable units include construction of a groundwater pump and treatment system or construction of a cap over a landfill.