FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

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

Geodataset Name:       EPATRI_2009
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         1611
GENERAL DESCRIPTION:
This dataset contains the basic facility identification information for all Toxic Release Inventory (TRI) facilities, in Florida, for Reporting Year 2009. 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_2008.shp.
DATA SOURCE(S):                    U.S. Environmental Protection Agency
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20101216 TIME PERIOD OF CONTENT: 2009 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: EPATRI_2009.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
PGMS_ACRNM
20 String
LDIP_CODE
2 String
ID
30 String
FAC_NAME
200 String
FAC_UIN
12 String
LRTLOC_RID
8 Double
LATITUDE
8 Double
LONGITUDE
8 Double
SRCE_ACRNM
15 String
SRCE_ID
30 String
MAP_CODE
2 String
FIPS_CODE
5 String
CATUNIT
8 String
ZIPCODE
9 String
MAD_ID
4 Integer
BVFLAG
1 String
REG_ID
12 String
REPORT_YR
8 Double
TRIFID
25 String
NAME
200 String
STREET
65 String
CITY
30 String
COUNTY
20 String
STATE
8 String
ZIP
8 Double
FEDERAL
9 String
PRINAICSCD
8 Double
PARENT_CO
60 String
PARENT_DUN
16 String
CAAREGCHEM
5 String
RELEASE
2 SmallInteger
USNG_FL_1K
10 String
DESCRIPT
200 String
UPDATEDAY
36 Date
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.

RCRIS = Resource Conservation and Recovery Information System.

BRS = Biennial Reporting System.

RCRAINFO = Resource Conservation and Recovery Act Information System.


LDIP_CODE A code that represents an information management system for an environmental program, original field name LDIP_CODE.

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.

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

LRTLOC_RID A sequential reference number assigned to a latitude and longitude coordinate pair, original field name LRT_LOC_REF_ID.

LATITUDE Latitude of facility, site, or operable unit.

LONGITUDE Longitude of facility, site, or operable unit.

SRCE_ACRNM Source Acronym name for borrowed coordinate, original field name SOURCE_ACRNM.

SRCE_ID Source Identification number for borrowed coordinate, original field name SOURCE_ID.

MAP_CODE Code to symbolize Envirofacts facility points by environmental activity in mapping applications, original field name MAP_SYMBOL_CODE.

FIPS_CODE State/County FIPS code for facility location, original field name DERIVED_FIPS_CODE.

CATUNIT Hydrologic Unit Code (HUC) for facility location, original field name DERIVED_CATUNIT.

ZIPCODE Zip code for facility location, original field name DERIVED_POSTAL_CODE.

MAD_ID Assigned sequential reference number.

BVFLAG Indicator of most accurate ("Best Value") location for an EPA facility as defined by FLA.

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, original field name REG_ID.

REPORT_YR Reporting Year. Calendar year in which the facility submitted its last report.

TRIFID Facility identification in the format zzzzz-nnnnn-sssss. NOTE: The contents of this field is not changed to match facility ownership, or zip code changes. Rather, the TRI Facility ID identifies a specific geographical location which is also identified by the latitude and longitude of that location.
zzzzz = Facility zip code

nnnnn = First five consonants of the name

sssss = First five non-special characters in the street address


NAME Facility Name.

STREET Facility Street. Street address of the reporting facility.

CITY Facility City. City in which the reporting facility is located.

COUNTY Facility County. County in which the reporting facility is located.

STATE Facility State. Two-letter state code of the reporting facility.

ZIP Facility Zip Code. Zip code of the reporting facility.

FEDERAL Code indicating whether a facility is Federal or not.
YES = Federal

NO = Non-Federal


PRINAICSCD Primary North American Industry Classification System (NAICS) Code. See the following website for 2007 NAICS Code list, 6-digit codes: http://www.census.gov/naics/2007/NAICO607.HTM

PARENT_CO Parent Company Name. Name of the corporation or other business entity that owns or controls the reporting facility.

PARENT_DUN Parent Compant D&B NR. Unique identification number assigned by Dun and Bradstreet to the parent company of the reporting facility.

CAAREGCHEM Facility contains chemical(s) that are regulated by the Clean Air Act (CAA).

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.

UPDATEDAY The last date the Source updated the attributed information.

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

AUTOID Unique ID added by GeoPlan

2007 NAICS United States Structure
Code list, generalized hierarchy, 2- through 3- digits.
PLEASE NOTE: This is a general break down of the NAICS, 
             the Code list, full hierarchy is, 2- through 6- digits.
-----------------------------------------------------------------------------------------
EXAMPLE:
11 	Agriculture, Forestry, Fishing and Hunting
111 	 	Crop Production
1111 	 	 	Oilseed and Grain Farming
11111 	 	 	 	Soybean Farming
111110 	 	 	 	 	Soybean Farming
-----------------------------------------------------------------------------------------

NAICS	TITLE
11	Agriculture, Forestry, Fishing and Hunting
111	Crop Production
112	Animal Production
113	Forestry and Logging
114	Fishing, Hunting and Trapping
115	Support Activities for Agriculture and Forestry
21	Mining, Quarrying, and Oil and Gas Extraction
211	Oil and Gas Extraction
212	Mining (except Oil and Gas)
213	Support Activities for Mining
22	Utilities
221	Utilities
23	Construction
236	Construction of Buildings
237	Heavy and Civil Engineering Construction
238	Specialty Trade Contractors
31-33	Manufacturing
311	Food Manufacturing
312	Beverage and Tobacco Product Manufacturing
313	Textile Mills
314	Textile Product Mills
315	Apparel Manufacturing
316	Leather and Allied Product Manufacturing
321	Wood Product Manufacturing
322	Paper Manufacturing
323	Printing and Related Support Activities
324	Petroleum and Coal Products Manufacturing
325	Chemical Manufacturing
326	Plastics and Rubber Products Manufacturing
327	Nonmetallic Mineral Product Manufacturing
331	Primary Metal Manufacturing
332	Fabricated Metal Product Manufacturing
333	Machinery Manufacturing
334	Computer and Electronic Product Manufacturing
335	Electrical Equipment, Appliance, and Component Manufacturing
336	Transportation Equipment Manufacturing
337	Furniture and Related Product Manufacturing
339	Miscellaneous Manufacturing
42	Wholesale Trade
423	Merchant Wholesalers, Durable Goods
424	Merchant Wholesalers, Nondurable Goods
425	Wholesale Electronic Markets and Agents and Brokers
44-45	Retail Trade
441	Motor Vehicle and Parts Dealers
442	Furniture and Home Furnishings Stores
443	Electronics and Appliance Stores
444	Building Material and Garden Equipment and Supplies Dealers
445	Food and Beverage Stores
446	Health and Personal Care Stores
447	Gasoline Stations
448	Clothing and Clothing Accessories Stores
451	Sporting Goods, Hobby, Book, and Music Stores
452	General Merchandise Stores
453	Miscellaneous Store Retailers
454	Nonstore Retailers
48-49	Transportation and Warehousing
481	Air Transportation
482	Rail Transportation
483	Water Transportation
484	Truck Transportation
485	Transit and Ground Passenger Transportation
486	Pipeline Transportation
487	Scenic and Sightseeing Transportation
488	Support Activities for Transportation
491	Postal Service
492	Couriers and Messengers
493	Warehousing and Storage
51	Information
511	Publishing Industries (except Internet)
512	Motion Picture and Sound Recording Industries
515	Broadcasting (except Internet)
517	Telecommunications
518	Data Processing, Hosting and Related Services
519	Other Information Services
52	Finance and Insurance
521	Monetary Authorities-Central Bank
522	Credit Intermediation and Related Activities
523	Securities, Commodity Contracts, and Other Financial Investments and Related
524	Insurance Carriers and Related Activities
525	Funds, Trusts, and Other Financial Vehicles
53	Real Estate and Rental and Leasing
531	Real Estate
532	Rental and Leasing Services
533	Lessors of Nonfinancial Intangible Assets (except Copyrighted Works)
54	Professional, Scientific, and Technical Services
541	Professional, Scientific, and Technical Services
55	Management of Companies and Enterprises
551	Management of Companies and Enterprises
56	Administrative and Support and Waste Management and Remediation Services
561	Administrative and Support Services
562	Waste Management and Remediation Services
61	Educational Services
611	Educational Services
62	Health Care and Social Assistance
621	Ambulatory Health Care Services
622	Hospitals
623	Nursing and Residential Care Facilities
624	Social Assistance
71	Arts, Entertainment, and Recreation
711	Performing Arts, Spectator Sports, and Related Industries
712	Museums, Historical Sites, and Similar Institutions
713	Amusement, Gambling, and Recreation Industries
72	Accommodation and Food Services
721	Accommodation
722	Food Services and Drinking Places
81	Other Services (except Public Administration)
811	Repair and Maintenance
812	Personal and Laundry Services
813	Religious, Grantmaking, Civic, Professional, and Similar Organizations
814	Private Households
92	Public Administration
921	Executive, Legislative, and Other General Government Support
922	Justice, Public Order, and Safety Activities
923	Administration of Human Resource Programs
924	Administration of Environmental Quality Programs
925	Administration of Housing Programs, Urban Planning, and Community Development
926	Administration of Economic Programs
927	Space Research and Technology
928	National Security and International Affairs
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


This is an EPA-Produced Data Set. This data set is one in 
a series of ArcIMS Image and Feature Services published 
by the USEPA.  Additional services can be found at the 
http://geodata.epa.gov or http://geogateway.epa.gov/Portal websites.

 
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.

--------------------------------------------------------------------------------------

2.0 Noted Changes to this Year s (RY 2006) State Data Files

2.1 NAICS Code Data Added
Beginning in RY 2006, TRI required Facilities to use North American Industry 
Classification System (NAICS) Codes to identify their primary business activities. As
a result, all the TRI State Data Files have been modified to include seven new 
fields which contain the NAICS code data. A primary NAICS field along with 5 
secondary NAICS code fields have been added to each State Data File. In 
addition, a  NAICS Code Origin  field has been added, indicating whether the 
NAICS codes were assigned or reported. See section 2.3 for more information on 
this field.

The TRI program will no longer collect SIC code data from Facilities. Facilities will 
submit their NAICS code data in Part I, section 4.5 of the Form R and Form A 
replacing the SIC code data. For more information on TRI s switch from SIC codes
to NAICS codes in RY 2006 see http://www.epa.gov/tri/tridata/naics/ .

2.2 SIC Code Data No longer collected but will be maintained for Historic 
Purposes

Prior to RY 2006, TRI facilities used Standard Industrial Classification (SIC) codes 
for identifying their business activities. In lieu of the new NAICS codes, TRI will no 
longer require facilities to submit SIC codes but will maintain the historical SIC 
code data in their TRI databases.

Historical SIC codes will continue to be displayed in the State data files where 
appropriate such as File Type 4,  Facility Identification Information  or in data files 
containing data prior to RY 2006. Files representing specific forms submitted in RY 
2006 and after will no longer contain SIC code data. However, the fields for SIC 
code data will remain in the record layouts for backward compatibility (but will be 
empty in form specific data files for RY 2006 and after).

2.3 Assigned SIC codes for Data Prior to RY 2006

In order to facilitate comparisons and develop trends using RY 2006 and prior year
data, TRI assigned primary NAICS codes to all prior year forms. To do this, TRI 
predominantly used two methods that accounted for 80 percent of all 
assignments. The first method was to propagate primary NAICS codes reported in 
RY 2006 back to prior years per facility and chemical. In other words, if a facility 
reported a primary NAICS code of 311211 (Flour Milling) on a Toluene submission 
in RY 2006, all prior Toluene submissions from that facility were assigned a primary 
NAICS code of 311211. This method accounted for 50% of all assignments.

The second method was to use the SIC to NAICS xwalk provided by the US 
Census Bureau (see http://www.census.gov/epcd/www/naics.html for a copy of 
the xwalk) to look up NAICS codes based on reported SIC codes on prior year s 
forms. This method accounted for 30% of all assignments. Internal EPA databases
(11 percent), commercial databases (7 percent) and statistical methods (2 percent) 
were used to assign primary NAICS codes to the remaining prior year forms.

2.4 2002 NAICS code List Utilized for RY 2006

For RY 2006, TRI facilities used the 2002 NAICS codes. Beginning with RY 2007,
facilities will use the slightly revised 2007 NAICS codes. For more information on 
the 2002 and 2007 NAICS code lists and their differences see 
http://www.census.gov/epcd/www/naics.html

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 (2009 TRI Data Release)
Toxics Release Inventory Program
http://www.epa.gov/tri/
TRI Current Basic Data
http://www.epa.gov/tri/tridata/current_data/index.html
http://www.epa.gov/tri/tridata/current_data/basic/TRI_2009_FL_v09.csv

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

Data XML:
http://geodata.epa.gov/wfsconnector/com.esri.wfs.Esrimap/TRI_FS?request=getcapabilities&service=wfs

Toxics Release Inventory (TRI)
State File Documentation for RY 2009
http://www.epa.gov/tri/tridata/current_data/basic/TRI_Basic_Data_File_Format_v09.pdf

Environmental Protection Agency
www.epa.gov

EPA Geographic Image and Feature Services
http://geodata.epa.gov/

Toxic Release Inventory (TRI) Services
http://www.epa.gov/tri/
TRI: ArcIMS Image Service
TRI_FS: ArcIMS Feature Service

EPA Geographic Image and Feature Services Help Page
http://geodata.epa.gov/help.htm

U.S. Environmental Protection Agency
US EPA
USEPA Mailroom N127-02
Research Triangle Park, NC
27711
919-767-7493

http://geodata.epa.gov/
esrisupport@epa.gov
EPA GIS Agency Central Support

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
Data imported to ArcSDE and exported as a shapefile. Process Date: 20110512
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/current_data/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