FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 2006

TITLE: PETROLEUM TANKS

Geodataset Name:       GC_PETROLEUMTANKS_JAN07
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         51320
GENERAL DESCRIPTION:
This dataset contains Petroleum Tank Information for the State of Florida. This dataset contains fields denoting the physical location, type and contact information for petroleum tanks taken from the Florida Department of Environmental Protection.
DATA SOURCE(S):                    University of Florida GeoPlan Center
SCALE OF ORIGINAL SOURCE MAPS:     N/A
DATE OF AUTOMATION OF SOURCE:      20070108
GEODATASET EXTENT:                 State of Florida

FEATURE ATTRIBUTE TABLES:

Datafile Name: GC_PETROLEUMTANKS_JAN07.DBF
ITEM NAME WIDTH TYPE N. DECIMAL DEGREES
STATUS
19 Float 11
OBJECTID
4 OID ---
SCORE
9 Number ---
SIDE
8 Number ---
X
62 String ---
Y
51 String ---
COUNTY
29 String ---
FAC_ID
8 String ---
FAC_NAME
20 String ---
FAC_ADDR
13 String ---
FAC_CITY
10 String ---
FAC_ZIP
32 String ---
FPHONE
8 String ---
FAC_STAT
7 String ---
FAC_TYPE
7 String ---
TYPEDESC
8 String ---
DEP_CO
9 String ---
LATDD
9 String ---
LATMM
9 String ---
LATSS
9 String ---
LONGDD
19 Number 8
LONGMM
19 Number 8
LONGSS
65 String ---
LL_METH
8 Date ---
LATITUDE
19 Number 8
LONGITUDE
19 Number 8
DESCRIPT
65 String ---
FGDLAQDATE
8 Date ---
SHAPE
4 Geometry ---
AUTOID
4 Integer ---

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
STATUS ESRI item which denotes the status of the geocoded address (whether it was matched or not).

OBJECTID Internal feature number.

SCORE ESRI item which denotes the score with which the address was matched to a feature in the reference data.

SIDE ESRI item which denotes the side of the street to which the address was matched (for geocoding service styles that can match an address to a particular side of a street).

X ESRI item which denotes the X coordinate of the geocoded feature.

Y ESRI item which denotes the Y coordinate of the geocoded feature.

COUNTY County Code to County Name Conversion, Number to Name.
1 = ALACHUA

2 = BAKER

3 = BAY

4 = BRADFORD

5 = BREVARD

6 = BROWARD

7 = CALHOUN

8 = CHARLOTTE

9 = CITRUS

10 = CLAY

11 = COLLIER

12 = COLUMBIA

13 = DADE

14 = DESOTO

15 = DIXIE

16 = DUVAL

17 = ESCAMBIA

18 = FLAGLER

19 = FRANKLIN

20 = GADSDEN

21 = GILCHRIST

22 = GLADES

23 = GULF

24 = HAMILTON

25 = HARDEE

26 = HENDRY

27 = HERNANDO

28 = HIGHLANDS

29 = HILLSBOROUGH

30 = HOLMES

31 = INDIAN RIVER

32 = JACKSON

33 = JEFFERSON

34 = LAFAYETTE

35 = LAKE

36 = LEE

37 = LEON

38 = LEVY

39 = LIBERTY

40 = MADISON

41 = MANATEE

42 = MARION

43 = MARTIN

44 = MONROE

45 = NASSAU

46 = OKALOOSA

47 = OKEECHOBEE

48 = ORANGE

49 = OSCEOLA

50 = PALM BEACH

51 = PASCO

52 = PINELLAS

53 = POLK

54 = PUTNAM

55 = ST. JOHNS

56 = ST. LUCIE

57 = SANTA ROSA

58 = SARASOTA

59 = SEMINOLE

60 = SUMTER

61 = SUWANNEE

62 = TAYLOR

63 = UNION

64 = VOLUSIA

65 = WAKULLA

66 = WALTON

67 = WASHINGTON


FAC_ID Facility Identification Code

FAC_NAME Facility Name

FAC_ADDR Facility Address

FAC_CITY Facility City

FAC_ZIP Facility Zip Code

FPHONE Phone number

FAC_STAT Facility status codes
= ABANDONED

 = CLOSED

 = CLOSED-NSH

 = CLOSED-SH

 = DELETED

 = DUPLICATE

 = OPEN

 = OPEN-NSH

 = OPEN-SH

 = UNDETERMINED


FAC_TYPE Facility type codes
1 = Drycleaner

2 = Wholesale supplier

3 = Dry drop-off

4 = Uniform-Linen service

5 = Coin Laundry

6 = Dryclean-related other

A = Retail Station

B = Residential (no UST >1100 gallons)

C = Fuel user/Non-retail

D = Bulk Product Facility/Inland

E = Industrial plant

F = Federal Government

G = State Government

H = Local Government

I = County Government

J = Collection station

K = Bulk Chemical Storage/Inland

L = Chemical user

M = Agricultural

N = Indian Land

O = not used

P = UST Residential (UST>1100)

Q = Bureau Emergency Response/Spill Site

R = Terminal (DPRC)/Non-Regulated Tanks

S = Bulk Product Facility/Waterfront

T = Bulk Product Facility/Coastal

V = Marine Fueling Facility/Coastal

W = Waterfront Fueling Facility

X = Contamination Site/Prior TK Location

Z = Other Regulated Facility


TYPEDESC The Description of the type of facility that has the tank.
= AGRICULTURAL

 = BULK CHEMICAL STORAGE/INLAND

 = BULK PRODUCT FACILITY/COASTAL

 = BULK PRODUCT FACILITY/INLAND

 = BULK PRODUCT FACILITY/WATERFRONT

 = BUREAU EMERGENCY RESPONSE/SPILL SIT

 = CHEMICAL USER

 = COIN LAUNDRY

 = COLLECTION STATION

 = CONTAMINATION SITE/PRIOR TK LOCATIO

 = COUNTY GOVERNMENT

 = DRY DROP-OFF

 = DRYCLEANER

 = DRYCLEAN-RELATED OTHER

 = FEDERAL GOVERNMENT

 = FUEL USER/NON-RETAIL

 = INDIAN LAND

 = INDUSTRIAL PLANT

 = LOCAL GOVERNMENT

 = MARINE FUELING FACILITY/COASTAL

 = NOT USED

 = OTHER REGULATED FACILITY

 = RESIDENTIAL (NO UST >1100 GALLONS)

 = RETAIL STATION

 = STATE GOVERNMENT

 = TERMINAL (DPRC)/NON-REGULATED TANKS


DEP_CO This is a specific DEP CODE (see DEP for more info).
= M

 = N

 = N,

 = P

 = Q

 = Y


LATDD Latitude Decimal Degrees

LATMM Latitude Minutes

LATSS Latitude Seconds

LONGDD Longitude Decimal Degrees

LONGMM Longitude Minutes

LONGSS Longitude Seconds

LL_METH This attribute contains information on how the tank locations where obtained.
= ADDM

 = AGPS

 = DGPS

 = DMAP

 = DPHO

 = GGPS

 = LORN

 = MMAP

 = UNLV

 = UNVR


LATITUDE Latitude

LONGITUDE Longitude

DESCRIPT FGDL added field based on the field FAC_NAME.

FGDLAQDATE FGDL added field based on date downloaded from source

SHAPE Feature geometry.

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
This data is provided 'as is' by GeoPlan and is complete to our 
knowledge.
GeoPlan relied on the integrity of the attribute information within
the original data.
This dataset is a combination of petroleum tanks oriented addresses from
the Florida Department of Environmental Protection online.

Tank Facility - All Locations & Lat/Long Information (by County)
[January 8, 2007]

Excel spreadsheet of the facilities registered with the Department and
tracked for active storage tanks, storage tank history, or petroleum cleanup
activity. Information includes facility identification number, site location
information with latitude/longitude, and facility type and status. Data is taken
from the Storage Tank & Contamination Monitoring database.

FLORIDA DEPARTMENT OF ENVIRONMENTAL PROTECTION
STORAGE TANK AND CONTAMINATION MONITORING DATABASE CODES LIST
ftp://ftp.dep.state.fl.us/pub/reports/codes/fs_codes.pdf

What is Geocoding?
Geocoding is term used to describe the act of address matching.  Geocoding
is the process of finding a geographic location (x, y point) for an address
(such as street number and name, city, state, and ZIP Code) on a map.
Geocoding is based off the typical address scheme for the US, in which one
side of the street contains even house numbers while the other side of the
street contains odd house numbers.
The geocoding process uses an algorithm to find the geographic location
of addresses. First, a street segment is identified using the zip code and
street name. Next, the geographic location of the address is matched using
the building number to determine how far down the street and on which side
of the street the building is located.

Geocoding Accuracy
The locational accuracy of geocoded addresses may vary from urban to rural
areas due to the algorithm used to generate the geographic locations of
addresses. The algorithm assumes that the size of parcels are equivalent
along a road route. This assumption tends to be more consistent in urban
areas, where the size of parcels vary less than in rural areas.
Consequently, the results of geocoded addresses in urban areas are usually
more reliable than those in rural areas.

For example, the locational accuracy of rural addresses can be slightly
off because some parcels along a rural route may be 15 acres while others
may be 2.5 acres, but the geocoding algorithm assumes that the addresses
are distributed evenly along the route.

The data was created to serve as base information for use in GIS 
systems for a variety of planning and analytical purposes.

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

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:
Florida Department of Environmental Protection website:
http://www.dep.state.fl.us/waste/quick_topics
/database_reports/pages/stcm/storagetank/stcm_allll.htm
http://www.dep.state.fl.us/waste/quick_topic
/database_reports/pages/stcm/petro_reports.htm
http://www.dep.state.fl.us/waste/quick_topics
/database_reports/pages/stcm/storagetank_reports.htm
http://www.dep.state.fl.us/waste/quick_topics
/database_reports/pages/stcm/stcm_reports.htm
http://www.dep.state.fl.us/waste/quick_topics
/database_reports/default.htm

DATA LINEAGE SUMMARY:
Petroleum Tanks locations were obtained online from the
Florida Department of Environmental Protection in January of 2007.
GeoPlan downloaded this data in excel file format and converted
it to a dbf.  The dbf was then either mapped based on the tanks
latitude and longitude coordinates if available, or if this information was
incomplete then the data was geocoded against ARC Logistics Route
GDT Roads and converted into a shapefile with the FGDL Albers
HPGN map projection.

Process Steps for Florida Department of Environmental Protection

-Petroleum Tanks Locations:
-Searched for petroleum tanks locations at
 http://www.dep.state.fl.us/waste/quick_topics/database_reports/
pages/stcm/storagetank/stcm_allll.htm
-Merged all county spreadsheets in to one excel spreadsheet file.
 the .xls file was then formatted so that it could be converted to
 a database file format.

-For records containing Full Latitude and Longitude coordinates these
 records were mapped spatially based on there x and y location in ArcMap.
-Remaining records were joined to the PCT shapefile on FAC_ID so as to
 import their latitude and longitude.
 All other locations where mapped through geocoding.
-The addresses were geocoded against ARC Logistics Route GDT Roads

Number of points with Lat/Long: 45444 (565 points were deleted as they fell 
outside of Florida or in a body of water).
Number of points with Lat/Long from the PCT shapefile: 1848 (107 points were 
deleted that were located in the Gulf of Mexico.
Geocoded points: 7389. Approximately 3000 of these points could not be geocoded 
due to missing address information.
Process Date: 20070207

Metadata imported. Process Date:
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:
Florida Department of Environmental Protection
FDEP
2600 Blair Stone Road
Tallahassee, FL
32399-2400
850-245-8705

http://www.dep.state.fl.us/waste/quick_topics/database_reports/pages/stcm/storagetank/stcm_allll.htm

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