FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: US EPA TOXIC RELEASE INVENTORY (TRI) - BASIC FACILITY INFORMATION IN FLORIDA - 2010

Geodataset Name:       EPATRI_2010
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         1592
GENERAL DESCRIPTION:
This dataset contains the basic facility identification information for all Toxic Release Inventory (TRI) facilities, in Florida, for Reporting Year 2010. The Toxics Release Inventory (TRI) is a database containing detailed information on nearly 650 chemicals and chemical categories that industrial and federal facilities manage through disposal or other releases, and waste management for recycling, energy recovery, or treatment. The file lists the last reporting year the Facility submitted an active and valid data to the TRI program. Everything from Part I of the Form R or the Form A certification statement (except section 2) is listed in this file. This layer is an update to the epatri_2009.shp.
DATA SOURCE(S):                    U.S. Environmental Protection Agency
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20111001 TIME PERIOD OF CONTENT: 2010 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: EPATRI_2010.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
PGMS_ACRNM
10 String
FAC_UIN
12 String
PGMS_ID
20 String
FAC_NAME
100 String
ADDRESS
80 String
ADDRESS2
50 String
CITY
30 String
ZIPCODE
12 String
COUNTY
20 String
FIPS_CODE
5 String
SITETYPE
40 String
CATUNIT
10 String
FEDFAC_CD
5 String
FED_AG_CD
5 String
FED_AG_NM
50 String
CDIST_NUM
5 String
LDIST_NUM
5 String
SRCE_ACRNM
20 String
REG_ID
8 Double
REFPT_NOTE
200 String
FRS_WEB
100 String
LATITUDE
8 Double
LONGITUDE
8 Double
CREATED
10 String
UPDATED
10 String
CAAREGCHEM
5 String
RELEASE
2 SmallInteger
USNG_FL_1K
10 String
DESCRIPT
80 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
AIRS/AFS = Aerometric Information Retrieval System (AIRS) Facility Subsystem.

PCS = Permit Compliance System

TRIS = Toxic Release Inventory System

CERCLIS = Comprehensive Environmental Response, Compensation, and Liability Information System.

BRS = Biennial Reporting System

RCRAINFO = Resource Conservation and Recovery Act Information System.

NPDES = National Pollutant Discharge Elimination System (NPDES) permit program.


FAC_UIN EPA Facility Linkage Application (FLA) Unique Identification Number, original field name FACILITY_UIN.

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.

CATUNIT Hydrologic Unit Code (HUC) for facility location.

FEDFAC_CD Federally Operated.
Y = Is federally operated.

N = Is not federally operated.


FED_AG_CD Federal Agency Code.

FED_AG_NM Federal Agency Name.

CDIST_NUM Congressional District Number.

LDIST_NUM Legislative District Number.

SRCE_ACRNM Source Acronym name for borrowed coordinate.

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.

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.

CAAREGCHEM Facility contains carcinogenic chemical(s) that are regulated by the Clean Air Act (CAA).
YES-1 = TRI On-site and Off-site Reported Disposed of Dioxin and Dioxin-like compounds.

Yes = Chemical is carcinogenic (producing or tending to produce cancer).

NO = Chemical is Not carcinogenic (producing or tending to produce cancer).

N/A = Facility is maintained as a Toxics Release Inventory (TRI) facility in the EPA FRS database, but was not monitored in 2010 for any chemicals listed under TRI.


RELEASE Number of chemical releases documents counted for site.

USNG_FL_1K Facility's 1-kilometer United States National Grid (USNG) address. The USNG is an alpha-numeric reference system based on the UTM coordinate system and is similar to the Military Grid Reference System. Use of the USNG ensures a uniform grid mapping and positional reporting system for search and rescue, emergency planning, response, and recovery. How to Read a United States National Grid (USNG) Spatial Address Website - http://www.fgdc.gov/usng/how-to-read-usng/index_html

DESCRIPT FGDL added item based on FAC_NAME.

FGDLAQDATE The date FGDL received the data (i.e. downloaded, etc.)

AUTOID Unique ID added by GeoPlan


USER NOTES:
This data is provided 'as is'. GeoPlan relied on the integrity of the original 
data layer's topology
The data in this file is a reconciliation of all the data the TRI 
program has collected from a  facility over the course of its 
participation in the TRI program. Most facilities have sent in
several chemical reports (form Rs and As) each year, for a 
number of years When the data is collected at the TRI Data 
Processing Center, differences from form to form and year to 
year are identified, researched and reconciled. The result is 
a database of facility identification information that is consist 
and up to date.

Some of the data that appears in this file is not a result of facility 
reconciliation. The Title of the Certifying Official, Certifying Official s 
Name, Entire Facility Ind, Partial_Facility_Ind, Federal Facility Ind, 
GOCO Facility Ind and the SIC codes are all taken from the last 
active and valid form the facility submitted. All other data is the result 
of the reconciliation process.
GeoPlan relied on the integrity of the attribute information within
the original data.
Superfund is the name given to the environmental program established to address 
abandoned hazardous waste sites. It is also the name of the fund established by 
the Comprehensive Environmental Response, Compensation and Liability Act of 
1980, as amended (CERCLA statute, CERCLA overview). This law was enacted 
in the wake of the discovery of toxic waste dumps such as Love Canal and Times
Beach in the 1970s. It allows the EPA to clean up such sites and to compel 
responsible parties to perform cleanups or reimburse the government for EPA-lead 
cleanups.

This dataset provides locations of and information on sites within EPA's 
Toxics Release Inventory (TRI). TRI contains data on annual estimated 
releases of over 650 toxic chemicals to air, water, and land by the 
manufacturing industry. Industrial facilities provide the information, 
which includes: the location of the facility where chemicals are 
manufactured, processed, or otherwise used; amounts of chemicals 
stored on-site; estimated quantities of chemicals released; on-site source 
reduction and recycling practices; and estimated amounts of chemicals 
transferred to treatment, recycling, or waste facilities. The TRI data for 
chemical releases to land are limited to releases within the boundary of a 
facility. Releases to land include: landfills; land treatment/application farming; 
and surface impoundments, such as topographic depressions, man-made 
excavations, or diked areas. This data is derived from the Envirofacts data 
warehouse. Data are retrieved from EPA source databases and posted to 
Envirofacts at various intervals. For additional information about Envirofacts 
data, please access the Envirofacts website at: 
http://www.epa.gov/enviro/html/ef_overview.html
 
The purpose of this service is to provide users with access 
to the USEPA's Toxics Release Inventory data.  
The United States Toxics release Inventory (TRI) is mandated 
by Section 313 of the Emergency Planning and community 
Right-to-Know Act (EPCRA) of 1986. The law is based on 
the premise that citizens have a right to know about potentially 
harmful chemicals in their communities. It has two main purposes: 
to provide planning for response to chemical accidents; 
and to provide the public and the government with information 
about possible chemical hazards.

 
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://www.epa.gov/frs/index.htm.

The Toxics Release Inventory (TRI) is a database containing detailed information 
on nearly 650 chemicals and chemical categories that approximately 22,000 
industrial and federal facilities manage through disposal or other releases, or 
recycling, energy recovery, or treatment. This inventory was established under the 
Emergency Planning and Community Right-to-Know Act of 1986 (EPCRA) and 
expanded by the Pollution Prevention Act of 1990.

http://www.epa.gov/enviro/facts/tri/search.html

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:
Toxic Release Inventory Program (2010 TRI Data Release)
Toxics Release Inventory Program
http://www.epa.gov/tri/
TRI Current Basic Data
Previous Years' TRI Basic Data Files
http://www.epa.gov/tri/tridata/data/basic/index.html
TRI_2010_FL.csv

EPA FRS Facilities
State Single File CSV Download
http://www.epa.gov/enviro/html/frs_demo/geospatial_data/geo_data_state_single.html
single_state_fl.zip

EPA EZ Query Website:
http://www.epa.gov/enviro/html/fii/ez.html

EPA Geodata:
http://www.epa.gov/geospatial/data.html

DATA LINEAGE SUMMARY:
EPA SPATIAL DATA - Process Steps
On a monthly basis, the FRS_FACILITY_SITE_SDE sde layer 
is created from FRS_FACILITY_SITE table. The layer has 
QA/QC performed for county validation and a 100 km flag.  
After QA/QC is performed, information is made available to 
Envirofacts, where it is extracted and made available as a 
service on geodata.epa.gov.  For more information about the 
data provided within the Envirofacts database, please visit 
http://www.epa.gov/enviro/html/ef_overview.html
Process Date: 2006

GeoPlan Center download TRIS facility and information via FRS EZ query in CSV format. This EF TRIS Subsystem is updated monthly online, the data found in this shapefile represents a snapshot taken on 20110504. -> Envirofacts (http://www.epa.gov/enviro/ ) -> Queries -> FRS >EZ (http://www.epa.gov/enviro/html/fii/ez.html ) Step 1: Started by selecting one view to be the focus of the query. -> click on "EPA Facility Information" 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 = TRIS -> enter State Code = FL -> click on button "Output to CSV File" Saved CSV file and then converted it to .dbf file using Excel. Process Date: 20110504
GeoPlan downloaded the "2009 Toxics Release Inventory (TRI) Data Files" State of Florida Data Files TRI Current Basic Data The Current Basic Data page provides access to the most recent version of the TRI data in the Basic Data File format for all past reporting years in one location, making it easier for users to find and download the desired data. Review the TRI Basic Data File Documentation v09 (29pp, About PDF) for detail description of the TRI Basic Data File 100 data fields, the general types of data include the following: Facility Name, Address, Latitude & Longitude Coordinates, and SIC or NAICS codes Chemical Identification and Classification Information On-site Release Quantities Publicly Owned Treatment Works (POTW) Transfer Quantities Off-site Transfer Quantities for Release/Disposal and Further Waste Management Summary Pollution Prevention Quantities (Section 8 of the Form R) From the following EPA website: http://www.epa.gov/tri/tridata/current_data/index.html http://www.epa.gov/tri/tridata/current_data/basic/TRI_2009_FL_v09.csv When GeoPlan downloaded the table it was in tab delimited format. This attribute data was originally released by the U.S. Environmental Protection Agency in March 2011, and the original data was limited to the state of Florida. GeoPlan then converted to tab delimited file to an excel .xls file and then to .dbf files. Below is further information on the downloaded file's Field Names. Year TRI Facility ID Facility Name Street Address City County ST ZIP Latitude Longitude Primary SIC SIC 2 SIC 3 SIC 4 SIC 5 SIC 6 Primary NAICS NAICS 2 NAICS 3 NAICS 4 NAICS 5 NAICS 6 Doc_Ctrl_Num Chemical CAS #/Compound ID Clean Air Act Chemical Classification Metal Metal Category Carcinogen Form Type Unit of Measure 5.1 Fugitive Air 5.2 Stack Air 5.3 Water 5.4.1 Underground Class I 5.4.2 Underground Class II-V 5.5.1A RCRA C Landfills 5.5.1B Other Landfills 5.5.2 Land Treatment 5.5.3 Surface Impoundment 5.5.3A RCRA C Surface Impoundment 5.5.3B Other Surface Impoundment 5.5.4 Other Disposal On-site Release Total 6.1 POTW - Metals and Metal Compounds 6.1 POTW - Non-Metals 6.1 POTW - Total Transfers 6.2 M10 6.2 M41 6.2 M62 6.2 M71 6.2 M81 6.2 M82 6.2 M72 6.2 M63 6.2 M66 6.2 M67 6.2 M64 6.2 M65 6.2 M73 6.2 M79 6.2 M90 6.2 M94 6.2 M99 Off-Site Release Total 6.2 M20 6.2 M24 6.2 M26 6.2 M28 6.2 M93 Off-Site Recycled Total 6.2 M56 6.2 M92 Off-Site Recovery Total 6.2 M40 6.2 M50 6.2 M54 6.2 M61 6.2 M69 6.2 M95 Off-Site Treated Total Total Releases 8.1 Releases 8.1a On-site Contained Releases 8.1b On-site Other Releases 8.1c Off-site Contained Releases 8.1d Off-site Other Releases 8.2 Energy Recovery On-site 8.3 Energy Recovery Off-site 8.4 Recycling On-Site 8.5 Recycling Off-Site 8.6 Treatment On-site 8.7 Treatment Off-site Production Waste (8.1 thru 8.7) 8.8 One-time Release 8.9 Production Ratio Parent Company Name Parent Company DB Number 02-MAR-11 File Descriptions Toxic Release Inventory - Basic Data File Format - Documentation v09 http://www.epa.gov/tri/tridata/current_data/basic/TRI_Basic_Data_File_Format_v09.pdf Process Date: 20110504
GeoPlan Center downloaded the spatial data (shapefile) from the following EPA Website: http://geodata.epa.gov GIS Server TRI (TRI_FS). Original Spatial Reference Information: Spatial_Reference_Information: Horizontal_Coordinate_System_Definition: Geographic: Latitude_Resolution: 0.000001 Longitude_Resolution: 0.000001 Geographic_Coordinate_Units: Decimal degrees Geodetic_Model: Horizontal_Datum_Name: North American Datum of 1983 Ellipsoid_Name: Geodetic Reference System 80 Semi-major_Axis: 6378137.000000 Denominator_of_Flattening_Ratio: 298.257222 The spatial data was then reprojected to the FGDL Albers projection. Original GIS SERVER Data Field Name and Process: PGM_SYS_ACRNM - Renamed to PGMS_ACRNM LDIP_CODE - Renamed to LDIP_CODE ID - Same name FACILITY_NAME - Renamed to FAC_NAME FACILITY_UIN - Renamed to FAC_UIN LRT_LOC_REF_ID - Renamed to LRTLOC_RID LATITUDE - Same name LONGITUDE - Same name PGM_SYS_LATITUDE - Deleted PGM_SYS_LONGITUDE - Deleted SOURCE_ACRNM - Renamed to SRCE_ACRNM SOURCE_ID - Renamed to SRCE_ID MAP_SYMBOL_CODE - Renamed to MAP_CODE DERIVED_FIPS_CODE - Renamed to FIPS_CODE DERIVED_CATUNIT - Renamed to CATUNIT DERIVED_POSTAL_CODE - Renamed to ZIPCODE PRIMARY_NAME - Deleted MAD_ID - Same name BVFLAG - Same name REG_ID - Same name SE_SDO_ROWID - Deleted AREA - Deleted LEN - Deleted Fields within this layer were renamed to fit table field naming constraints. A TRIFID field was then created and populated with values from the ID field. The TRIFID values where then converted to the standard TRIFID field format found within the downloaded EPA 2009 Toxics Release Inventory (TRI) Data File. A table join was then created between the TRI Current Basic Data database file and the EPA downloaded shapefile. A TRIFID summary table was created from the TRI Current Basic Data ID and this count information was used to populated the RELEASE field. A Clean Air Act Chemical summary table was created from the TRI Current Basic Data and this count information was used to populated the CAAREGCHEM field. USNG_FL_1K was added and populated. DESCRIPT field was added based on FAC_NAME. UPDATEDAY field was added and populated based on the last day the attribute data was updated by the source. FGDLAQDATE field was added and populated based on the date GeoPlan Downloaded the shapefile from the source. Process Date: 20110504
GeoPlan Center downloaded the spatial data (shapefile) from the following EPA Website on 20120612: EPA FRS Facilities State Single File CSV Download http://www.epa.gov/enviro/html/frs_demo/geospatial_data/geo_data_state_single.html STATE_SINGLE_FL.csv New Files Were Posted on 05/19/2012 and represent data extracted from FRS on 05/21/2012. 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. Next a selection was performed on the field PGMS_ACRNM equal to TRIS. Process Date: 20120612
GeoPlan Center download TRIS facility and information via FRS EZ query in CSV format. This EF TRIS Subsystem is updated monthly online, the data found in this shapefile represents a snapshot taken on 20120702. -> Envirofacts (http://www.epa.gov/enviro/ ) -> Queries -> FRS >EZ (http://www.epa.gov/enviro/html/fii/ez.html ) Step 1: Started by selecting one view to be the focus of the query. -> click on "EPA Facility Information" 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 = TRIS -> enter State Code = FL -> click on button "Output to CSV File" Saved CSV file and then converted it to .dbf file using Excel. Next GeoPlan downloaded the 2010 TRI BASIC DATA FILES from the following website. http://www.epa.gov/tri/tridata/data/basic/index.html selection = 2010 and Florida = TRI_2010_FL.csv A table join was then created between the TRI Current Basic Data database file and the EPA spatial data. A TRIFID summary table was created from the TRI Current Basic Data ID and this count information was used to populated the RELEASE field. A Clean Air Act Chemical summary table was created from the TRI Current Basic Data and this count information was used to populated the CAAREGCHEM field. USNG_FL_1K was added and populated. DESCRIPT field was added based on FAC_NAME. FGDLAQDATE field was added and populated based on the date GeoPlan Downloaded the shapefile from the source. Process Date: 20120702
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, 61 Forsyth Street, SW
Research Triangle Park, NC
27711
919-767-7493

http://www.epa.gov/tri/tridata/data/basic/index.html esrisupport@epa.gov

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