FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 2006

TITLE: US EPA TOXIC RELEASE INVENTORY - PUBLICLY OWNED TREATMENT WORKS (POTW)

Geodataset Name:       EPATRI_POT
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         2082
GENERAL DESCRIPTION:
This dataset contains information about chemical transfers to Publicly Owned Treatment Works (POTWs). This file contains general facility and chemical identification data. This dataset also contains the total quantity of the chemical that was transferred to all POTWs. It lists the names and locations of the first 2 POTWs that the facility sent the chemical to.
DATA SOURCE(S):                    U.S. Environmental Protection Agency
SCALE OF ORIGINAL SOURCE MAPS:     N/A
DATE OF AUTOMATION OF SOURCE:      20050511
GEODATASET EXTENT:                 STATE OF FLORIDA

FEATURE ATTRIBUTE TABLES:

Datafile Name: EPATRI_POT.DBF
ITEM NAME WIDTH TYPE N. DECIMAL DEGREES
OBJECTID
4 OID ---
TRIFID
21 String ---
DOC_CTRLNU
14 Number ---
CAS_NUMBER
14 String ---
CLASSIFICA
11 String ---
UNIT
7 String ---
DIOX_DIST1
11 String ---
DIOX_DIST2
11 String ---
DIOX_DIST3
11 String ---
DIOX_DIST4
11 String ---
DIOX_DIST5
11 String ---
DIOX_DIST6
11 String ---
DIOX_DIST7
11 String ---
DIOX_DIST8
11 String ---
DIOX_DIST9
11 String ---
DIOXDIST10
11 String ---
DIOXDIST11
11 String ---
DIOXDIST12
11 String ---
DIOXDIST13
11 String ---
DIOXDIST14
11 String ---
DIOXDIST15
11 String ---
DIOXDIST16
11 String ---
DIOXDIST17
11 String ---
REPORT_YR
12 Number ---
TRD_SECIND
12 String ---
FAC_NAME
73 String ---
STREET
55 String ---
CITY
25 String ---
COUNTY
15 String ---
STATE
7 String ---
ZIP
10 Number ---
ENT_FACIND
12 String ---
PAR_FACIND
12 String ---
FEDERAL
9 String ---
GOCO
6 String ---
LATITUDE
17 Number 6
LONGITUDE
17 Number 6
DUNS_A
13 Number ---
DUNS_B
10 String ---
RCRA_NR_A
15 String ---
RCRA_NR_B
13 String ---
NPDES_NR_A
13 String ---
NPDES_NR_B
13 String ---
UIC_NR_A
14 String ---
PARENT_CO
49 String ---
PARENT_DUN
13 String ---
TO_POTWXFR
13 Number ---
BAES_POTWS
14 String ---
POTWA_NAME
70 String ---
POTWA_ADDR
52 String ---
POTWA_CITY
25 String ---
POTWA_ST
11 String ---
POTWA_CO
17 String ---
POTWA_ZIP
11 String ---
DESCRIPT
17 String ---
FGDLAQDATE
8 Date ---
SHAPE
4 Geometry ---
AUTOID
4 Integer ---

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

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


DOC_CTRLNU Document Control Number. Unique identification number assigned to each submission by EPA. Format TTYYMMMNNNNNC.
TT = Document type

YY = Reporting year

MMM = Document type

NNNNN = Sequential number

C = Check digit


CAS_NUMBER Chemical Abstracts Service (CAS) Registry Number for that unique chemical, or category code (for compounds).

CLASSIFICA Classification. Indicates the classification of the chemical. Chemicals can be classified as either a Dioxin or Dioxin-like compound, a PBT (Persistent, Bioaccumulative and Toxic) chemical or a general EPCRA Section 313 chemical.
TRI = General EPCRA Section 313 Chemical

PBT = Bioaccumulative and Toxic

DIOXIN = Dioxin or Dioxin-like compound


UNIT Unit of Measure. Indicates the unit of measure used to quantify the chemical.
Pounds = Pounds

Grams = Grams


DIOX_DIST1 Dioxin Distribution 1. Indicates the percentage of 1,2,3,4,6,7,8 Heptachlorodibenzofuran (CAS # 67562-39-4) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST2 Dioxin Distribution 2. Indicates the percentage of 1,2,3,4,7,8,9 Heptachlorodibenzofuran (CAS # 55673-89-7) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST3 Dioxin Distribution 3. Indicates the percentage of 1,2,3,4,7,8 Hexachlorodibenzofuran (CAS # 70648-26-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST4 Dioxin Distribution 4. Indicates the percentage of 1,2,3,6,7,8 Hexachlorodibenzofuran (CAS # 57117-44-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST5 Dioxin Distribution 5. Indicates the percentage of 1,2,3,7,8,9 Hexachlorodibenzofuran (CAS # 72918-21-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST6 Dioxin Distribution 6. Indicates the percentage of 2,3,4,6,7,8 Hexachlorodibenzofuran (CAS # 60851-34-5) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST7 Dioxin Distribution 7. Indicates the percentage of 1,2,3,4,7,8 Hexachlorodibenzo- p-dioxin (CAS # 39227-28-6) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST8 Dioxin Distribution 8. Indicates the percentage of 1,2,3,6,7,8 Hexachlorodibenzo- p-dioxin (CAS # 5765385-7) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOX_DIST9 Dioxin Distribution 9. Indicates the percentage of 1,2,3,7,8,9 Hexachlorodibenzo- p-dioxin (CAS # 19408-74-3) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST10 Dioxin Distribution 10. Indicates the percentage of 1,2,3,4,6,7,8 Heptachlorodibenzo- p-dioxin (CAS # 35822-46-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01and 100 (inclusive).

DIOXDIST11 Dioxin Distribution 11. Indicates the percentage of 1,2,3,4,6,7,8,9 Octachlorodibenzofuran (CAS # 39001-02-0) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST12 Dioxin Distribution 12. Indicates the percentage of 1,2,3,4,6,7,8,9 Octachlorodibenzo- p-dioxin (CAS# 03268-87-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST13 Dioxin Distribution 13. Indicates the percentage of 1,2,3,7,8 Pentachlorodibenzofuran (CA # 57117-41-6) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST14 Dioxin Distribution 14. Indicates the percentage of 2,3,4,7,8 Pentachlorodibenzofuran (CAS # 57117-31-4) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST15 Dioxin Distribution 15. Indicates the percentage of 1,2,3,7,8 Pentachlorodibenzo- p-dioxin (CAS # 40321-76-4) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST16 Dioxin Distribution 16. Indicates the percentage of 2,3,7,8 Tetrachlorodibenzofuran (CAS # 51207-31-9) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

DIOXDIST17 Indicates the percentage of 2,3,7,8 Tetrachlorodibenzo- p-dioxin (CAS # 01746-01-6) in the reported Dioxin or Dioxin-like compound. Values are either 0 or a number between 0.01 and 100 (inclusive).

REPORT_YR Reporting Year. Calendar year in which the reported activities occur.

TRD_SECIND Trade Secret Indicator. Indicates whether the reporting facility claims the identity of the chemical or chemical category as a trade secret. NOTE: Only Sanitized Trade Secret submissions are stored in the TRIS database.
Yes = Checked (Trade Secret)

No = Not checked


FAC_NAME Facility Name. Name of the reporting facility.

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.
FL = Florida


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

ENT_FACIND Entire Facility Indicator. Indicates whether the information covers an entire facility or part of a facility.

PAR_FACIND Partial Facility Indicator. Indicates whether the information covers an entire facility or part of a facility.
Yes = Partial

No = Entire


FEDERAL Federal Facility Indicator. Code indicating whether a facility is Federal or not.
Yes = Federal

No = non-Federal or GOCO


GOCO GOCO Facility Indicator. Code indicating whether a facility is GOCO (Government-Owned, Contractor-Operated) facility or not.
Yes = GOCO

No = non-GOCO


LATITUDE Reported latitude of the reporting facility converted into decimal degrees (Format: signed 2 digit whole number, 6 digit decimal positions +nn.nnnnnn).

LONGITUDE Reported longitude of the reporting facility converted into decimal degrees. (Format: signed 3 digit whole number, 6 digit decimal positions -nnn.nnnnnn).

DUNS_A D&B NR A. Unique identification number assigned by Dun and Bradstreet to the reporting facility.

DUNS_B D&B NR B. Unique identification number assigned by Dun and Bradstreet to the reporting facility.

RCRA_NR_A RCRA NR A. Twelve-digit alphanumeric identifier assigned by EPA under the Resource Conservation and Recovery Act.

RCRA_NR_B RCRA NR B. Twelve-digit alphanumeric identifier assigned by EPA under the Resource Conservation and Recovery Act.

NPDES_NR_A Nine-digit alphanumeric identifier assigned to a facility under EPA's National Pollutant Discharge Elimination System.

NPDES_NR_B Nine-digit alphanumeric identifier assigned to a facility under EPA's National Pollutant Discharge Elimination System.

UIC_NR_A Underground injection identifier number, assigned by EPA or the state, to facility which injects chemical waste into class 1 wells.

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

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

TO_POTWXFR Total POTW Transfers. Amount reported in pounds of total of transfers offsite to publicly owned treatment works.

BAES_POTWS Basis of Estimate for POTWs. Code indicating the principal method by which the amount of wastewater transferred to all POTWs estimate is calculated.
M = Based on monitoring data

C = Based on mass balance calculations

E = Based on published emission factors

O = Other


POTWA_NAME POTW A - Name. Name of the publicly-owned treatment works facility (POTW) location to which the chemical was sent.

POTWA_ADDR POTW A - Address. Street address of the POTW location to which the chemical was sent.

POTWA_CITY POTW A - City. Name of the city in which the POTW site is located.

POTWA_ST POTW A - State. The two-letter state abbreviation of the POTW site.

POTWA_CO POTW A - County. Name of the county in which the POTW site is located.

POTWA_ZIP POTW A - Zip. Zip code used in the address of a POTW site.

DESCRIPT Based on TRIFID

FGDLAQDATE Date GeoPlan acquired data from source.

SHAPE Feature geometry.

AUTOID Unique ID added by GeoPlan

Additional state data file documention is available in PDF format at 
http://www.epa.gov/tri/tridata/tri03/data/index.htm.
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
reconcilation process.
GeoPlan relied on the integrity of the attribute information within
the original data.

The Toxics Release Inventory (TRI) is a database containing detailed information on nearly 650 chemicals and 
chemical categories that over 23,000 industrial and federal facilities manage through disposal or other releases, 
and waste management for 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. 

For Reporting Year 2003, 23,811 facilities reported to EPA s TRI Program.  These facilities reported 4.44 billion 
pounds of on-site and off-site disposal or other releases of the almost 650 toxic chemicals.  Over 88 percent of 
the total was disposed of or otherwise released on-site; almost 12 percent was sent off-site for disposal or other
releases.

The following facilities plot outside of the the physcial State of Florida, 
which is a known problem.  The following points, according to TRIFID, 
were deleted from this dataset due to this condition.  The EPA TRI Facility 
Siting tool located at http://www.epa.gov/tri/report/siting_tool/index.htm 
will allow you to get accurate latitude and longitude coordinates.  

Deleted TRIFID points: 32206-LLBRT-2204H, 32905-TKQST-251KI, 
33760-SPMNF-6050U, 34691-FLDRP-1729B, 33316-MCLC0-1180S, 
34761-WHTKR-280EN, 32132-BRNSW-42MEG, 32132-DGHRT-211DB, 
32254-PPRSN-155EL, 32904-MSFCN-7703T, 33054-MRCNT-4851N, 
33316-KCHMT-1200S

This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan

THE DATA INCLUDED IN FGDL ARE 'AS IS' AND SHOULD NOT BE CONSTRUED
AS LEGALLY BINDING. 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 (2003 TRI Data Release)
http://www.epa.gov/tri/tridata/tri03/index.htm

Environmental Protection Agency
www.epa.gov

2003 TRI Public Data Release eReport
http://www.epa.gov/tri/tridata/tri03/2003eReport.pdf

DATA LINEAGE SUMMARY:
Data originally released by the U.S. Environmental  
Protection Agency in May 2005.  When 
GeoPlan received the dataset it was in tab delimited 
format. The original data was limited to the state of Florida.
Process Date: 20051223

Data was downloaded from US Environmental Protection Agency website in text format to GeoPlan in October 2005. GeoPlan, during the QA/QC process included the following aspects: (1) Projected data to FGDL Albers. (2) Deleted points which plotted outside the State of Florida (3) Deleted the following fields: PRIMARY SIC CODE, SIC CODE 2, SIC CODE 3, SIC CODE 4, SIC CODE 5, SIC CODE 6, POTW B-NAME. POTW B-ADDRESS, POTW B-CITY, POTW B-STATE, POTW B-COUNTY, POTW B-ZIP (4) Added the FGDLAQDATE field. (5) Added DESCRIPT item based on TRIFID. Process Date: 20060109
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:
US Environmental Protection Agency
EPA
Air Toxics Assessment & Implementation Section
Atlanta, GA
30303


http://www.epa.gov/tri/tridata/tri03/data/index.htm velez.ezequiel@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