FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: US EPA REGULATED SUPERFUND SITES IN FLORIDA - JUNE 2017

Geodataset Name:       EPASUPERFUND_JUN17
Geodataset Type:       SDE Feature Class
Geodataset Feature:    Point
Feature Count:         491
GENERAL DESCRIPTION:
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.
DATA SOURCE(S):                    U.S. Environmental Protection Agency
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20170605 TIME PERIOD OF CONTENT: 20170601 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: EPASUPERFUND_JUN17.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
PGMS_ACRNM
125 String
REG_ID
15 String
PGMS_ID
20 String
FAC_NAME
100 String
ADDRESS
65 String
ADDRESS2
65 String
CITY
50 String
ZIPCODE
12 String
COUNTY
20 String
FIPS_CODE
5 String
SITETYPE
30 String
HUCCODE
10 String
FEDFAC_CD
5 String
FED_AG_NM
50 String
CDIST_NUM
5 String
CENBLOCK
20 String
CONVEYOR
20 String
COLL_DESC
75 String
ACCVALUE
5 String
REFPT_NOTE
254 String
FRS_WEB
100 String
LATITUDE
8 Double
LONGITUDE
8 Double
CREATED
11 String
UPDATED
11 String
STATUS
30 String
DESCRIPT
100 String
FGDLAQDATE
36 Date
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

PGMS_ACRNM 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
ACRES = Assessment, Cleanup and Redevelopment Exchange System (ACRES)

AIR = Integrated Compliance Information System Air Database (ICIS-AIR)

AIRS/AFS = Information Retrieval System (AIRS)/Air Facility Subsystem (AFS)

AIRS/AQS = Aerometric Information Retrieval System (AIRS)/Air Quality System (AQS)

BR = Biennial Reporters (BR)

CAMDBS = Clean Air Markets Division Business System (CAMDBS)

CEDRI = Compliance and Emissions Data Reporting Interface (CEDRI)

E-GGRT = Electronic Greenhouse Gas Reporting Tool (E-GGRT)

EGRID = Emissions & Generation Resource Database (EGRID)

EIA-860 = Energy Information Administration-860 (EIA-860) Database

EIS = Emission Inventory System (EIS)

FDM = Fiesta Data Maintenance (FDM)

FFDOCKET = Federal Facility Hazardous Waste Compliance Docket (FFDOCKET)

ICIS = Integrated Compliance Information System (ICIS)

LMOP = Methane Outreach Program (LMOP)

NCDB = National Compliance Data Base (NCDB)

NPDES = National Pollutant Discharge Elimination System (NPDES)

OIL = OIL Database (OIL)

OTAQREG = Office of Transportation and Air Quality Fuels Registration (OTAQREG)

RADINFO = Radiation Information Database (RADINFO)

RBLC = RACT/BACT/LAER Clearinghouse (RBLC)

RCRAINFO = Resource Conservation and Recovery Act Information (RCRAInfo)

RFS = Renewable Fuel Standard (RFS)

SEMS = Superfund Enterprise Management System (SEMS)

SFDW = SDWIS Federal Data Warehouse (SFDW)

SSTS = Section Seven Tracking System (SSTS)

TRIS = Release Inventory System (TRIS)

TSCA = Toxic Substances Control Act (TSCA)


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

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

FAC_NAME Name of the facility or site.

ADDRESS Address of the facility or site.

ADDRESS2 Secondary address of the facility or site.

CITY City of the facility or site.

ZIPCODE Zip Code of the facility or site.

COUNTY County of the facility or site.

FIPS_CODE State/County FIPS code for facility location.

SITETYPE Type of Site.

HUCCODE Hydrologic Unit Code (HUC) for facility location.

FEDFAC_CD Federally Operated.
YES = Is federally operated.

NO = Is not federally operated.


FED_AG_NM Federal Agency Name.

CDIST_NUM Congressional District Number.

CENBLOCK Census Block of the facility or site.

CONVEYOR Identification of the party that transmitted the associated latitude and longitude coordinates.

COLL_DESC The text that describes the method used to determine the latitude and longitude coordinates for a point on the earth.

ACCVALUE The measure of the accuracy (in meters) of the latitude and longitude coordinates.

REFPT_NOTE Reference Point Note.

FRS_WEB Facility FRS website link.

LATITUDE Latitude of facility, site, or operable unit, in Decimal Degrees.

LONGITUDE Longitude of facility, site, or operable unit, in Decimal Degrees.

CREATED Date created in EPA FRS system.

UPDATED Date updated in EPA FRS system.

STATUS 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
NPL DELETED = EPA may delete a final NPL site if it determines that no further response is required to protect human health or the environment.

NPL FINAL = 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.

NPL PROPOSED = Sites that have been proposed to the National Priorities List (NPL) in the Federal Register.

NPL REMOVED = Sites that have been Removed from the Proposed National Priorities List (NPL) in the Federal Register.

SUPERFUND ALTERNATIVE = 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

NON-NPL = Sites that are addressed using other clean up options (e.g., other federal or state programs).

PART OF NPL SITE = Site is Part of a National Priorities List (NPL) Site.


DESCRIPT GeoPlan added field based on FAC_NAME.

FGDLAQDATE The date GeoPlan acquired the data from the Source.

AUTOID Unique ID added by 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.
USER NOTES:
Locations are tested and reported individually
Completeness of the data set varies for individual features.
GeoPlan relied on the integrity of the attribute information within
the original data.

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

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

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.

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

REFERENCES:
EPA FRS Facilities
State Single File CSV Download
https://www.epa.gov/enviro/epa-frs-facilities-state-single-file-csv-download/state_single_fl.zip

For additional background on the attributes
listed within this service, please visit:
https://www.epa.gov/enviro/about-data

Final National Priorities List (NPL) Sites by Region:
https://www.epa.gov/superfund/search-superfund-sites-where-you-live

Search Superfund Site Information:
http://cumulis.epa.gov/supercpad/cursites/srchsites.cfm

Superfund National Priorities List (NPL) Information: 
https://www.epa.gov/superfund/superfund-national-priorities-list-npl

DATA LINEAGE SUMMARY:
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
Process Date: 20170714

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. Process Date: 20170714
Dataset copied. Process Date: 20171102
MAP PROJECTION PARAMETERS:

Projection                          ALBERS
Datum                               HPGN
Units                               METERS
Spheroid                            GRS1980
1st Standard Parallel               24  0  0.000
2nd Standard Parallel               31 30  0.000
Central Meridian                   -84 00  0.000
Latitude of Projection's Origin     24  0  0.000
False Easting (meters)              400000.00000
False Northing (meters)             0.00000

DATA SOURCE CONTACT (S):

Name:
Abbr. Name:
Address:


Phone:

Web site:
E-mail:
Contact Person:
         Phone:
        E-mail:
U.S. Environmental Protection Agency
EPA
USEPA Mailroom N127-02
Research Triangle Park, NC
27711
919-767-7493

https://www.epa.gov/enviro/epa-frs-facilities-state-single-file-csv-download esrisupport@epa.gov EPA GIS Agency Central Support

FGDL CONTACT:
Name:                   FLORIDA GEOGRAPHIC DATA LIBRARY
Abbr. Name:             FGDL
Address:                Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Web site:               http://www.fgdl.org

Contact FGDL: 

      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html