FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

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

Geodataset Name:       EPATRI_2016
Geodataset Type:       SDE Feature Class
Geodataset Feature:    Point
Feature Count:         1919
GENERAL DESCRIPTION:
This dataset contains the basic facility identification information for all Toxic Release Inventory (TRI) facilities, in Florida, for Reporting Year 2016. 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. TRI tracks the management of certain toxic chemicals that may pose a threat to human health and the environment. U.S. facilities in different industry sectors must report annually how much of each chemical is released to the environment and/or managed through recycling, energy recovery and treatment. (A "release" of a chemical means that it is emitted to the air or water, or placed in some type of land disposal.) The information submitted by facilities is compiled in the Toxics Release Inventory. TRI helps support informed decision-making by industry, government, non-governmental organizations and the public. This layer is an update to the EPATRI_2015.shp.
DATA SOURCE(S):                    U.S. Environmental Protection Agency
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20180402 TIME PERIOD OF CONTENT: 2016 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: EPATRI_2016.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
PGMS_ACRNM
20 String
FAC_UIN
12 String
PGMS_ID
30 String
FAC_NAME
80 String
ADDRESS
50 String
CITY
60 String
ZIPCODE
14 String
COUNTY
35 String
FIPS_CODE
5 String
CATUNIT
8 String
FEDFAC_CD
5 String
REG_ID
50 String
REFPT_NOTE
250 String
FRS_WEB
66 String
LATITUDE
8 Double
LONGITUDE
8 Double
CREATED
36 Date
UPDATED
36 Date
LRDATE
36 Date
CAAREGCHEM
5 String
RELEASE
8 Double
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
TRIS = Toxic Release Inventory System


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.

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.

CATUNIT Hydrologic Unit Code (HUC) for facility location.

FEDFAC_CD Federally Operated.
Y = Is federally operated.

N = Is not federally operated.


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 A system-generated value that represents the calendar date and time the corresponding information was posted to the database.

UPDATED A system-generated value that represents the most recent calendar date and time the corresponding information was updated in the database.

LRDATE The most recent date the corresponding environmental interest data was reported to the Source of Data.

CAAREGCHEM Facility contains carcinogenic chemical(s) that are regulated by the Clean Air Act (CAA).
YES = Chemical is carcinogenic (producing or tending to produce cancer).

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

YES-1 = Chemical is carcinogenic (producing or tending to produce cancer). TRI On-site and Off-site Reported Disposed of Dioxin and Dioxin-like compounds.

NO-1 = Chemical is Not carcinogenic (producing or tending to produce cancer). TRI On-site and Off-site Reported Disposed of Dioxin and Dioxin-like compounds.

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


RELEASE Number of chemical releases documents counted for site.

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.
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) contains information about releases and transfers of more 
than 650 toxic chemicals and compounds to the environment.
https://www.epa.gov/enviro/tri-search-user-guide

In general, chemicals covered by the TRI Program are those that cause:
 
 - Cancer or other chronic human health effects
 - Significant adverse acute human health effects
 - Significant adverse environmental effects
 
Facilities that manufacture, process or otherwise use these chemicals in amounts above 
established levels must submit annual TRI reports on each chemical. The TRI chemical 
list doesn't include all toxic chemicals used in the U.S.
https://www.epa.gov/toxics-release-inventory-tri-program/learn-about-toxics-release-inventory

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:
Envirofacts Geospatial Data Download Service
http://www.epa.gov/enviro/geo_data.html
File Geodatabase -> EPAFileGdbDownload
[Geospatial information for all publicly available FRS facilities that have latitude/longitude data.]
FRS_INTERESTS.gdb

TRI Basic Data Files: Calendar Years 1987 - 2016
https://www.epa.gov/toxics-release-inventory-tri-program/tri-basic-data-files-calendar-years-1987-2016

2016 TRI National Analysis 
https://www.epa.gov/trinationalanalysis/introduction-2016-tri-national-analysis

DATA LINEAGE SUMMARY:
Title EPA Facility Registry Service (FRS): Facility File Geodatabase Dataset
Publication date: 2018-04-02
Dataset Download Location:
Envirofacts Geospatial Data Download Service
http://www.epa.gov/enviro/geo_data.html

Geospatial information for all publicly available FRS facilities that have latitude/longitude data.
Process Date: 20180402

GeoPlan downloaded the TRI spatial data from the following EPA website, on 20180607. Envirofacts Geospatial Data Download Service http://www.epa.gov/enviro/geo_data.html File Geodatabase -> EPAFileGdbDownload [Geospatial information for all publicly available FRS facilities that have latitude/longitude data.] FRS_INTERESTS.gdb 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 The following steps were taken to subset the dataset to the Florida extent and restructure the table. 1. Definition Query Where: STATECODE <> 'FL' 2. Reclassify STATECODE = 'FL' for points miscoded in Florida. 3. Clear Definition Query. 4. Select STATECODE = 'FL' , then remove points not in Florida and export selection. 5. Project new Florida extent only data layer to FGDL Albers HARN. - Using Transformation NAD83 to HARN FL 6. Select on the field PGM_SYS_ACRNM= 'TRIS' and export selection set. 7. Restructure table, see below. - Fields within this layer were renamed to fit shapefile table field naming constraints. Original GIS SERVER Data Field Name and Process: ITEM NAME REGISTRY_ID - Renamed to FAC_UIN PRIMARY_NAME - Renamed to FAC_NAME LOCATION_ADDRESS - Renamed to ADDRESS CITY_NAME - Renamed to CITY COUNTY_NAME - Renamed to COUNTY FIPS_CODE - Same name STATE_CODE - Deleted POSTAL_CODE - Renamed to ZIPCODE LATITUDE83 - Renamed to LATITUDE LONGITUDE83 - Renamed to LONGITUDE HUC8_CODE - Renamed to CATUNIT AIRSHED_CODE - Deleted ACCURACY_VALUE - Deleted COLLECT_MTH_DESC - Deleted REF_POINT_DESC - Renamed to REFPT_NOTE CREATE_DATE - Renamed to CREATED UPDATE_DATE - Renamed to UPDATED LAST_REPORTED_DATE - Renamed to LRDATE FAC_URL - Renamed to FRS_WEB PGM_SYS_ID - Renamed to PGMS_ID PGM_SYS_ACRNM - Renamed to PGMS_ACRNM INTEREST_TYPE - Deleted PROGRAM_URL - Deleted PGM_REPORT_URL - Deleted PUBLIC_IND - Deleted ACTIVE_CODE - Deleted ------------------------------------------------------------------------------------------------------------ GeoPlan downloaded the TRI tabular data from the following website, using the selection drop-downs of 2016 and Florida (FL) on 20180607. TRI Basic Data Files: Calendar Years 1987 - 2016 https://www.epa.gov/toxics-release-inventory-tri-program/tri-basic-data-files-calendar-years-1987-2016 This EnvirofactsRestAPI excel table was then loaded to a FGDB. 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. The fields used to populate the CAAREGCHEM were CLASSIFICATION and CARCINOGEN. DESCRIPT field was added based on FAC_NAME. FGDLAQDATE field was added and populated based on the date FGDL acquired the data from the Source. Process Date: 20180607
Dataset copied. Process Date: 20180718
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
1200 Pennsylvania Ave NW
Washington, DC
20460
202-566-0797

http://www.epa.gov/enviro/geo_data.html smith.davidg@epa.gov David Smith

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