FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: SUPER ACT WELLS IN FLORIDA - JULY 2011 

Geodataset Name:       SUPERACT_WELL_JUL11
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         93062
GENERAL DESCRIPTION:
This dataset consists of information and locations relating to all privately and publicly owned potable wells investigated as part of the State Underground Petroleum Environmental Response Act (SUPER Act) program. Environmental Engineering staff identify all private water wells within mile, and all public drinking water wells within mile of potential petroleum contamination sources. The data contains information about the owners, addresses and geographic coordinates of the wells. This is an update to the superact_well_apr11 layer. 
DATA SOURCE(S):                    Florida Department of Health
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
GEODATASET EXTENT:                 State of Florida

PUBLICATION DATE:                  201107
TIME PERIOD OF CONTENT:            201107
DOWNLOAD LINK:                     http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES: 

Datafile Name: SUPERACT_WELL_JUL11.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
FLUWID
10 String
WELL_TYPE
2 String
WELL_STATU
9 String
WELL_CASIN
11 String
LONGITUDE
8 Double
LATITUDE
8 Double
WELL_DEPTH
8 Double
WELL_CAS_1
8 Double
WELL_CAS_2
6 String
WELL_PERMI
20 String
WELL_COMME
234 String
WELL_SANIT
3 String
WELL_BUSIN
50 String
RESIDENT_F
20 String
RESIDENT_L
20 String
WELL_PHONE
20 String
WELL_PHO_1
5 String
DATUM
6 String
HAE
8 Double
GPS_DATE
36 Date
LOCATION_M
13 String
PROJECT_ID
15 String
INSPECTOR_
20 String
INSPECTOR1
20 String
INSPECTO_1
12 String
COUNTY
30 String
ADDRESS
80 String
HOUSE_NUMB
8 String
PREDIRECTI
2 String
PREFIX
4 String
STREET
40 String
SUFFIX
4 String
POSTDIRECT
2 String
ZIPCODE
10 String
CITY
25 String
WSRP_ID
9 String
ACTION
200 String
POTABLE_ST
20 String
PETROLEUM_
20 String
SOLVENT_ST
20 String
NITRATES
20 String
EDB
20 String
METALS
20 String
VOC
20 String
ARSENIC
20 String
PESTICIDES
20 String
HIGH_PETRO
50 String
HIGH_SOLVE
50 String
HIGH_NITRA
50 String
HIGH_EDB
50 String
HIGH_METAL
50 String
HIGH_VOC
50 String
HIGH_ARSEN
50 String
HIGH_PESTI
50 String
SCHEDULE
250 String
MAXIMUM_DA
36 Date
SCREENING_
250 String
CATS
250 String
UNMATCHED4
250 String
L_SAMPLE_D
36 Date
L_SAMPLE_1
36 Date
L_SAMPLE_2
36 Date
L_SAMPLE_3
36 Date
L_SAMPLE_4
36 Date
L_SAMPLE_5
36 Date
L_SAMPLE_6
36 Date
L_SAMPLE_7
36 Date
LAST_JOB_N
200 String
LAST_JOB_1
200 String
LAST_JOB_2
200 String
LAST_JOB_3
200 String
LAST_JOB_4
200 String
LAST_JOB_5
200 String
AUTONUMBER
8 Double
MGRS
50 String
DESCRIPT
52 String
FGDLAQDATE
36 Date
WELL_USE
75 String
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item

Item Description





OBJECTID

Internal feature number.
















Shape

Feature geometry.
















FLUWID

Risk Source Identification Number
















WELL_TYPE

type of wells
















WELL_STATU

well status, active/inactive
















WELL_CASIN

well casing, steel/PVC/Galvanized
















LONGITUDE

Longitude coordinate in Decimal Degrees - Datum WGS84
















LATITUDE

Latitude coordinate in Decimal Degrees - Datum WGS84
















WELL_DEPTH

Depth of Well shaft in feet
















WELL_CAS_1

well casing length in feet
















WELL_CAS_2

well casing diameter in inches
















WELL_PERMI

Permit Number - Public Water System Identification Number issued by DEP.
















WELL_COMME

Field Investigator comments
















WELL_SANIT

Sanitary Seal - Indicates whether or not a sanitary seal is present
















WELL_BUSIN

Business name for the well
















RESIDENT_F

Resident first name
















RESIDENT_L

Resident last name
















WELL_PHONE

Owner's Telephone Number
















WELL_PHO_1

for phone extension number
















DATUM

DATUM -- WS1984
















HAE

HAE (m) - Height Above Ellipsoid in meters
















GPS_DATE

the date of GPS data collection
















LOCATION_M

the method to locate the well, DGPS/MMAP
















PROJECT_ID

Project ID, Petroleum/Dry Cleaner/Toxics
















INSPECTOR_

Inspector first name
















INSPECTOR1

Inspector last name
















INSPECTO_1

county of the inspector
















COUNTY

the name of the county where the well belongs to
















ADDRESS

Physical address of Well
















HOUSE_NUMB

Physical home number  of Well
















PREDIRECTI

Physical Street Predirectional of Well
















PREFIX

Physical Street Prefix of Well
















STREET

Physical Stree Name of Well
















SUFFIX

Physical Street Sufix for of Well
















POSTDIRECT

Physical Stree Post Directional of Well
















ZIPCODE

zipcode
















CITY

city name of the well
















WSRP_ID

FDEP's Water Supply Restoration Program (WSRP)
















ACTION

action to be taken, unfiltered/connected to PWS
















POTABLE_ST

potable status, potable/non-potable
















PETROLEUM_

value of the contamination based on predetermined criteria
















SOLVENT_ST

solvent status in numbers based on predetermined criteria
















NITRATES

nitrates value based on predetermined contamination criteria
















EDB

EDB value based on predetermined contamination criteria
















METALS

Metal value based on predetermined contamination criteria
















VOC

VOC value based on predetermined contamination criteria
















ARSENIC

Arsenic value based on predetermined contamination criteria
















PESTICIDES

Pesticides value based on predetermined contamination criteria
















HIGH_PETRO

for historical data, the highest petroleum contamination value based on predetermined contamination criteria
















HIGH_SOLVE

for historical data, the highest solvent contamination value based on predetermined contamination criteria
















HIGH_NITRA

for historical data, the highest nitrates contamination value based on predetermined contamination criteria
















HIGH_EDB

for historical data, the highest EDB contamination value based on predetermined contamination criteria
















HIGH_METAL

for historical data, the highest metal contamination value based on predetermined contamination criteria
















HIGH_VOC

for historical data, the highest VOC contamination value based on predetermined contamination criteria
















HIGH_ARSEN

for historical data, the highest arsenic contamination value based on predetermined contamination criteria
















HIGH_PESTI

for historical data, the highest pesticides contamination value based on predetermined contamination criteria
















SCHEDULE

scheduling for sampling, future/current/late
















MAXIMUM_DA

last scheduled date to sample the well
















SCREENING_

the chemicals to be tested in the well sample
















CATS

contamination area identification number
















UNMATCHED4

location mismatch between DEP and DOH data for type 40 wells (community water system)
















L_SAMPLE_D

last sample date for petroleum
















L_SAMPLE_1

last sample date for solvent
















L_SAMPLE_2

last sample date for nitrates
















L_SAMPLE_3

last sample date for EDB
















L_SAMPLE_4

last sample date for metals
















L_SAMPLE_5

last sample date for VOC
















L_SAMPLE_6

last sample date for arsenic
















L_SAMPLE_7

last sample date for pesticides
















LAST_JOB_N

job name for the last petroleum sample
















LAST_JOB_1

job name for the last nitrates sample
















LAST_JOB_2

job name for the last EDB (ethylene dibromide) sample
















LAST_JOB_3

job name for the last metals sample
















LAST_JOB_4

job name for the last arsenic sample
















LAST_JOB_5

job name for the last pesticides sample
















AUTONUMBER

system generated number
















MGRS

Military grid system
















DESCRIPT

Based on WELL_BUSIN
















FGDLAQDATE

The date FGDL acquired the data from the source.
















WELL_USE

Added by GeoPlan based on values from WELL_TYPE. Values were obtained from previous version of the layer.
















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.













In 1986, the Florida Legislature created the SUPER Act program in response to groundwater 
contamination resulting from leaking underground petroleum storage tanks. The primary 
authority for the SUPER Act Program was given to the Florida Department of Environmental 
Protection (FDEP), Bureau of Petroleum Storage Systems.  FDEP oversees the clean-up 
activities around petroleum facilities that have had a loss of petroleum product. The Florida 
Department of Health's SUPER Act Program (per Chapter 376.3071(4)(g), Florida Statutes), 
was given authority to provide field and laboratory services, toxicological risk assessments, 
investigations of drinking water contamination complaints and education of the public.   

As part of a cooperative agreement with FDEP, the Bureau of Water, Petroleum Surveillance Program 
(SUPER Act) participates in their FLUWID (Florida Unique Well IDentification) program. The program's 
goal is to simplify water well identification and exchange of information between state agencies 
concerned with well construction data, well location and groundwater quality.

For more information visit: http://www.doh.state.fl.us/environment/water/petroleum/saindex.html















The program's goal is to simplify water well identification and exchange of information 
between state agencies concerned with well construction data, well location and 
groundwater quality.  The program involves tagging wells with a unique alphanumeric 
code called the FLUWID Well ID (Example: ABC1234). The water well identification 
and exchange of information between state agencies concerned with well construction 
data, well location and groundwater quality.

The table consists of data relating to all privately and publicly owned potable wells 
investigated as part of the SUPER Act program. The table contains information about 
the owners, addresses and  geographic coordinates of the wells.















GPS Equipment used/data accuracy - Within the last several years, Real-time 
Differential GPS receivers (RDGPS) have been used to provide a location 
accuracy within five meters. However, some older data was collected using 
non-RDGPS sources including digitized maps and handheld devices used for 
recreational GPS. Refer to the "GPS_Status" field in each table to determine 
if accuracy is RDGPS.















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















Disclaimer: This product is for reference purposes only and is not to 
be construed as a legal document. Any reliance on the information 
contained herein is at the user's own risk. The Florida Department of 
Health and its agents assume no responsibility for any use of the 
information contained herein or any loss resulting there from.














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: 






Drinking Water Quality Testing Programs:
http://www.myfloridaeh.com/water/index.html

The Petroleum Surveillance Program:
http://www.doh.state.fl.us/environment/water/petroleum/saindex.html

EH Water Mapping Program:
http://gis.doh.state.fl.us/EHWATER/default.aspx









DATA LINEAGE SUMMARY: 








GeoPlan downloaded this dataset from the Florida Department of Health in November of 
2011. The data downloaded was in shapefile format from the following webpage:
http://www.doh.state.fl.us/environment/programs/ehgis/EhGisDownload.htm
The data was in the following geographical coordinate system:
WGS 1984 Datum, Units: Degrees. The following QA/QC process steps 
were undertaken:
- Added field WELL_USE and joined values from previous layer based on on 
WELL_TYPE. values that were null, 44, 51, 52, NO didn't join. This accounted for 
only 32 records.
- Reprojected the data to FGDL Albers HPGN
- Removed 299 records due to erroneous/missing spatial information.
- All records were uppercased.
- Removed the  empty PROPERTY_I field. 
- Added a DESCRIPT based on WELL_BUSIN.
- Added a FGDLAQDATE field  based on date GeoPlan acquired the data
  from the source.
- Renamed the dataset from WellPoint to superact_well_jul11
Process Date: 20111201









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 Health, Division of Environmental Health
FDOH
4052 Bald Cypress Way
Tallahassee, Florida
32399
850-245-4250


http://www.doh.state.fl.us/environment/programs/ehgis/EhGisDownload.htm

Calvin Desouza









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