This data set contains locations of EPA-regulated Superfund sites contained in the Superfund Enterprise Management System (SEMS). SEMS integrates multiple legacy systems into a comprehensive tracking and reporting tool. The database contains information for National Priorities List (NPL) sites (i.e., sites proposed to the NPL, currently on the final NPL or deleted from the final NPL), sites with a Superfund Alternative Approach agreement, as well as Non-NPL sites. More information is available at https://www.epa.gov/superfund. This is an update to the FGDL layer EPASUPERFUND_MAR16.
The purpose of this data set is to assist in the location, investigation, and clean-up of the worst hazardous waste sites throughout the United States. https://cumulis.epa.gov/supercpad/CurSites/srchsites.cfm
publication date
Although these data have been processed successfully on a computer system at the Environmental Protection Agency, no warranty expressed or implied is made regarding the accuracy or utility of the data on any other system or for general or scientific purposes, nor shall the act of distribution constitute any such warranty. It is strongly recommended that careful attention be paid to the contents of the metadata file associated with these data to evaluate data set limitations, restrictions or intended use. The U.S. Environmental Protection Agency shall not be held liable for improper or incorrect use of the data described and/or contained herein.
USEPA Mailroom N127-02
U.S. Environmental Protection Agency
GeoPlan relied on the integrity of the attribute information within the original data.
Locations are tested and reported individually
Completeness of the data set varies for individual features.
FRS uses a best-pick algorithm to provide horizontal positional information. This assigns the latitude and longitude with the best accuracy value to each facility. Because information in FRS is collected across numerous states and programs, positional accuracy for the data set varies for each individual feature and is stored on a record-level basis. Overall horizontal positional accuracy for the entire data set fluctuates as new information is received and is not estimated for the entire data set within this record. For more information on accuracy of FRS locations, visit http://iaspub.epa.gov/sor_internet/registry/facilreg/home/overview/home.do
This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan
Spatial and Attribute Information
GeoPlan Center downloaded the spatial data (shapefile) from the following
EPA Website on 20170710:
EPA FRS Facilities
State Single File CSV Download
https://www.epa.gov/enviro/epa-frs-facilities-state-single-file-csv-download
STATE_SINGLE_FL.csv
New Files Were Posted on 06/05/2017 and represent data extracted from FRS on 06/01/2017.
The STATE_SINGLE_FL.csv had Latitude and Longitude fields in the following projection.
The Add XY Data Tool was used to convert the table to a point layer.
Original Projection
Name: GCS_North_American_1983
Details:
Angular Unit: Degree (0.017453292519943295)
Prime Meridian: Greenwich (0.000000000000000000)
Datum: D_North_American_1983
Spheroid: GRS_1980
Semimajor Axis: 6378137.000000000000000000
Semiminor Axis: 6356752.314140356100000000
Inverse Flattening: 298.257222101000020000
Next the data was reprojected to Albers NAD83 Harn.
Next point errors located in the ocean were removed.
Original Field Names:
ITEM NAME
OBJECTID
FRS_FACILITY_DETAIL_REPORT_URL
REGISTRY_ID
PRIMARY_NAME
LOCATION_ADDRESS
SUPPLEMENTAL_LOCATION
CITY_NAME
COUNTY_NAME
FIPS_CODE
STATE_CODE
STATE_NAME
COUNTRY_NAME
POSTAL_CODE
FEDERAL_FACILITY_CODE
FEDERAL_AGENCY_NAME
TRIBAL_LAND_CODE
TRIBAL_LAND_NAME
CONGRESSIONAL_DIST_NUM
CENSUS_BLOCK_CODE
HUC_CODE
EPA_REGION_CODE
SITE_TYPE_NAME
LOCATION_DESCRIPTION
CREATE_DATE
UPDATE_DATE
US_MEXICO_BORDER_IND
PGM_SYS_ACRNMS
INTEREST_TYPES
NAICS_CODES
NAICS_CODE_DESCRIPTIONS
SIC_CODES
SIC_CODE_DESCRIPTIONS
LATITUDE83
LONGITUDE83
CONVEYOR
COLLECT_DESC
ACCURACY_VALUE
REF_POINT_DESC
HDATUM_DESC
SOURCE_DESC
Renamed fields to fit the 10 character field naming convention for shapefiles.
Deleted unused and duplicate fields.
Added DESCRIPT field based on FAC_NAME.
Added FGDLAQDATE field.
Next a selection was performed on the field PGMS_ACRNM equal to SEMS.
This selection set was exported and named: epasuperfund_jun17.shp
GeoPlan Center download SEMS facility and information
via FRS EZ query in CSV format.
-> Envirofacts (http://www.epa.gov/enviro/ )
-> Queries
-> FRS >EZ (https://www.epa.gov/enviro/frs-ez-query)
Step 1: Started by selecting one view to be the focus of the query.
-> click on "EPA FRS Facility Information with Program Identifiers"
on the Facility Information section.
STEP 2: Selected all column(s) for the output by clicking on
the square box next to each of the column names. Then click on
"STEP 3: Enter Search Criteria" button at the bottom of the page.
STEP 3: Enter Search Criteria and Organize the Output
-> enter Program System Acronym = SEMS
-> enter State Code = FL
-> click on button "Output to CSV File"
Saved CSV file and then converted it to .dbf file in ArcMap.
GeoPlan Center then joined the tabular (EPA CSV) data to the spatial
data via the REG_ID field.
Registry ID - The number assigned by the Facility Linkage
Application that is used to associate facility records from multiple
environmental database systems that are known or believed to
represent the same facility, original field name REG_ID.
There were 3 records in the SEMS csv that were not present in the EPA FRS csv file.
These records were added to the final output, epasuperfund_jun17:
REG_ID's:
110009276336
110043687203
110009273124
The NPL Status was added from the following website:
EPA Region 4: Superfund Sites
https://www.epa.gov/superfund/search-superfund-sites-where-you-live
Search Superfund Site Information
http://cumulis.epa.gov/supercpad/cursites/srchsites.cfm
- Search results were downloaded as Excel table which included the following columns:
EPA ID
Site Name
City
County
ST
Non-NPL Status
Non-NPL Status Date
NPL Status
- The STATUS field in epasuperfund_jun17 was calculated based on NPL Status column
- SUPERFUND ALTERNATIVE status value was calculated based on code SA from NON-NPL Status column
Deleted duplicate fields.
Dataset copied.
Internal feature number.
ESRI
Feature geometry.
ESRI
Program System Acronym - An abbreviated name that represents the name of an information management system for an environmental program, original field name PGM_SYS_ACRNM
EPA
Assessment, Cleanup and Redevelopment Exchange System (ACRES)
EPA
Integrated Compliance Information System Air Database (ICIS-AIR)
EPA
Information Retrieval System (AIRS)/Air Facility Subsystem (AFS)
EPA
Aerometric Information Retrieval System (AIRS)/Air Quality System (AQS)
EPA
Biennial Reporters (BR)
EPA
Clean Air Markets Division Business System (CAMDBS)
EPA
Compliance and Emissions Data Reporting Interface (CEDRI)
EPA
Electronic Greenhouse Gas Reporting Tool (E-GGRT)
EPA
Emissions & Generation Resource Database (EGRID)
EPA
Energy Information Administration-860 (EIA-860) Database
EPA
Emission Inventory System (EIS)
EPA
Fiesta Data Maintenance (FDM)
EPA
Federal Facility Hazardous Waste Compliance Docket (FFDOCKET)
EPA
Integrated Compliance Information System (ICIS)
EPA
Methane Outreach Program (LMOP)
EPA
National Compliance Data Base (NCDB)
EPA
National Pollutant Discharge Elimination System (NPDES)
EPA
OIL Database (OIL)
EPA
Office of Transportation and Air Quality Fuels Registration (OTAQREG)
EPA
Radiation Information Database (RADINFO)
EPA
RACT/BACT/LAER Clearinghouse (RBLC)
EPA
Resource Conservation and Recovery Act Information (RCRAInfo)
EPA
Renewable Fuel Standard (RFS)
EPA
Superfund Enterprise Management System (SEMS)
EPA
SDWIS Federal Data Warehouse (SFDW)
EPA
Section Seven Tracking System (SSTS)
EPA
Release Inventory System (TRIS)
EPA
Toxic Substances Control Act (TSCA)
EPA
Registry ID - The number assigned by the Facility Linkage Application that is used to associate facility records from multiple environmental database systems that are known or believed to represent the same facility.
EPA
The identification number, including permit number, assigned by an information management system that represents a facility, waste site, operable unit, or other feature regulated or monitored by that program system, original field name PGM_SYS_ID.
EPA
Name of the facility or site.
EPA
Address of the facility or site.
EPA
Secondary address of the facility or site.
EPA
City of the facility or site.
EPA
Zip Code of the facility or site.
EPA
County of the facility or site.
EPA
State/County FIPS code for facility location.
EPA
Type of Site.
EPA
Hydrologic Unit Code (HUC) for facility location.
EPA
Federally Operated.
EPA
Is federally operated.
EPA
Is not federally operated.
EPA
Federal Agency Name.
EPA
Congressional District Number.
EPA
Census Block of the facility or site.
EPA
Identification of the party that transmitted the associated latitude and longitude coordinates.
EPA
The text that describes the method used to determine the latitude and longitude coordinates for a point on the earth.
EPA
The measure of the accuracy (in meters) of the latitude and longitude coordinates.
EPA
Reference Point Note.
EPA
Facility FRS website link.
EPA
Latitude of facility, site, or operable unit, in Decimal Degrees.
EPA
Longitude of facility, site, or operable unit, in Decimal Degrees.
EPA
Date created in EPA FRS system.
EPA
Date updated in EPA FRS system.
EPA
Code to indicate the site's National Priorities List (NPL) status (proposed for NPL or currently on the final NPL). https://www.epa.gov/superfund/search-superfund-sites-where-you-live
EPA
EPA may delete a final NPL site if it determines that no further response is required to protect human health or the environment.
EPA
Sites are first proposed to the National Priorities List (NPL) in the Federal Register. EPA then accepts public comments on the sites, responds to the comments, and places on the NPL those sites that continue to meet the requirements for listing.
EPA
Sites that have been proposed to the National Priorities List (NPL) in the Federal Register.
EPA
Sites that have been Removed from the Proposed National Priorities List (NPL) in the Federal Register.
EPA
The Superfund alternative (SA) approach uses the same investigation and cleanup process and standards that are used for sites listed on the NPL. The SA approach is an alternative to listing a site on the NPL; it is not an alternative to Superfund or the Superfund process. https://www.epa.gov/enforcement/superfund-alternative-approach
EPA
Sites that are addressed using other clean up options (e.g., other federal or state programs).
EPA
Site is Part of a National Priorities List (NPL) Site.
EPA
GeoPlan added field based on FAC_NAME.
GeoPlan
The date GeoPlan acquired the data from the Source.
GeoPlan
Unique ID added by GeoPlan
GeoPlan
The attributes provided within this data set are derived from the USEPA's Envirofacts Data warehouse. For additional background on the attributes listed within this service, please visit https://www.epa.gov/enviro/about-data.
431 Architecture PO Box 115706
The Florida Geographic Data Library is a collection of Geospatial Data compiled by the University of Florida GeoPlan Center with support from the Florida Department of Transportation. GIS data available in FGDL is collected from various state, federal, and other agencies (data sources) who are data stewards, producers, or publishers. The data available in FGDL may not be the most current version of the data offered by the data source. University of Florida GeoPlan Center makes no guarantees about the currentness of the data and suggests that data users check with the data source to see if more recent versions of the data exist. Furthermore, the GIS data available in the FGDL are provided 'as is'. The University of Florida GeoPlan Center makes no warranties, guaranties or representations as to the truth, accuracy or completeness of the data provided by the data sources. The University of Florida GeoPlan Center makes no representations or warranties about the quality or suitability of the materials, either expressly or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. The University of Florida GeoPlan Center shall not be liable for any damages suffered as a result of using, modifying, contributing or distributing the materials. A note about data scale: Scale is an important factor in data usage. Certain scale datasets are not suitable for some project, analysis, or modeling purposes. Please be sure you are using the best available data. 1:24000 scale datasets are recommended for projects that are at the county level. 1:24000 data should NOT be used for high accuracy base mapping such as property parcel boundaries. 1:100000 scale datasets are recommended for projects that are at the multi-county or regional level. 1:125000 scale datasets are recommended for projects that are at the regional or state level or larger. Vector datasets with no defined scale or accuracy should be considered suspect. Make sure you are familiar with your data before using it for projects or analysis. Every effort has been made to supply the user with data documentation. For additional information, see the References section and the Data Source Contact section of this documentation. For more information regarding scale and accuracy, see our webpage at: http://geoplan.ufl.edu/education.html
USEPA Mailroom N127-02
Additional information about contact information is available at http://intranet.epa.gov/rtpgis.