FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 2005

TITLE: WATER SUPPLY RESTORATION WELLS

Geodataset Name:       WSRP
Geodataset Type:       SHAPEFILE
Geodataset Feature:    POINT
GENERAL DESCRIPTION:
This dataset contains private drinking water well contamination records from the Water Supply Restoration Program database.
DATA SOURCE(S):                    Florida Department of Environmental Protection
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
DATE OF AUTOMATION OF SOURCE:      2003
GEODATASET EXTENT:                 STATE OF FLORIDA

FEATURE ATTRIBUTE TABLES:

Datafile Name: WSRP.DBF
ITEM NAME WIDTH TYPE N. DECIMAL DEGREES
SHAPE
4 Geometry ---
FID
4 OID ---
WELL_ID
9 String ---
WELL_CITY
30 String ---
WELL_TYPE
20 String ---
COUNTY
2 String ---
LONG_DD
10 String ---
LONG_MM
6 Number ---
LONG_SS
6 Number ---
LAT_DD
19 Number 9
LAT_MM
6 Number ---
LAT_SS
6 Number ---
LOC_METHOD
19 Number 9
WELL_DEPTH
4 String ---
CASE_DEPTH
6 Number ---
DIAMETER
6 Number ---
FLORIDA_ID
19 Number 9
METHOD
7 String ---
EDB
6 Number ---
NITRATE
19 Number 9
BROMACIL
19 Number 9
BENZENE
19 Number 9
TCE
19 Number 9
PCE
19 Number 9
DBCP
19 Number 9
MTBE
19 Number 9
Shape
19 Number 9
ARSENIC
19 Number 9
WELL_ADDRE
30 String ---
DESCRIPT
30 String ---

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
SHAPE Feature geometry

FID Internal feature number

WELL_ID Unique well identifier

WELL_CITY City name of well location

WELL_TYPE Type of well
40 = Community water system

41 = Non-community water system

42 = Limited use water system

43 = Private well

44 = Public health investigation, child with elevated blood test level. These samples were taken from public water systems.

45 = Nontransient non community

46 = Other

47 = Multi-family well

50 = Irrigation

60 = Sample taken from a tap served by a public water system where permeation into the system is suspected (pipes running through contaminated soil)

70 = Connection to well (multi-house private well connection with actual well listed as 43)

"Blank" = The well type was not indicated when the associated sample was submitted.


COUNTY County name of well location

LONG_DD Longitude in degrees

LONG_MM Longitude in minutes

LONG_SS Longitude in seconds

LAT_DD Latitude in degrees

LAT_MM Latitude in minutes

LAT_SS Latitude in seconds

LOC_METHOD Locational method
Zip = Zip code centroid

DGPS = Differential GPS

MMAP = Manually from quad map

DPHO = Precise digital photography

DMAP = Imprecise digital photography

AGPS = Nondifferential GPS

ADDR = Address matching


WELL_DEPTH Depth of the well

CASE_DEPTH Depth of the casing

DIAMETER Diameter of the well

FLORIDA_ID Florida Identifier

METHOD Restoration method
0 = No contamination, or method of remediation not yet determined, or owner not yet responded

1 = Filter

2 = Connected to public water system

3 = New well drilled

4 = No action required by our program (irrigation well, or contamination due to lead plumbing, etc.)

>4 = Owner being recontacted


EDB Levels of ethylene di-bromide (EDP)

NITRATE Levels of nitrate

BROMACIL Levels of bromacil

BENZENE Levels of benzene

TCE Levels of trichloroethylene (TCE)

PCE Levels of tetrachloroethene (PCE)

DBCP Levels of dibromochloropropane (DBCP)

MTBE Levels of methyl tertiary-butyl ether (MTBE)

Shape Feature geometry.

ARSENIC Feature geometry.

WELL_ADDRE Physical address of the well.

DESCRIPT Based on field "WELL_ADDRE"

USER NOTES:
Relied on the integrity of the attribute information within the original data layer

Non-GPS locations are unreliable. Not every well in the dataset was analysed for
all of the chemicals listed. Much more chemical data is available from the Water
Supply Program.

The information in the data base is for the purpose of tracking contamination in private wells and is IN NO WAY REPRESENTATIVE OF GROUND WATER QUALITY!

In particular, the absence of contamination in an area according to this data may be more indicative of lack of sampling, lack of analysis of chemicals in water sampled, or the presence of a public water supply, than of groundwater quality.

GeoPlan identified several points in the Atlantic Ocean off the coast of Monroe County and Miami that had associated physical addresses. This entire dataset was overlayed with a current street layer to verify the accuracy of other points within this layer. Random points were spatially verified based on this overlay. GeoPlan has noted these inconsistencies and contacted FDEP.

A note concerning data scale:

Scale is an important factor in data usage. Certain scale 
datasetsare not suitable for some project, analysis, or
modelling 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:250000 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 analyses. Every 
effort has been made to supply the user with data 
documentation. For additional information, see the 
References sectionand the Data Source Contact section of 
this documentation. For more information regarding scale 
and accuracy, see our web pages at:

http://www.geoplan.ufl.edu/education.html

REFERENCES:
Florida Department of the Environment
http://www.dep.state.fl.us/gis/datadir.asp

Water Supply Restoration Program Sampling
http://www.dep.state.fl.us/water/wff/wsupply/sampling.htm

DATA LINEAGE SUMMARY:
Water samples are gathered by DoH County Public
Health Unit samplers.  Locational data is provided by these samplers,
historically from quad maps, currently with GPS (post 1996). The field data
is provided to the DOH lab in Jacksonville where the water is analysed and
the analytic data associated with the field information. This data is then
transferred electronically to DEP/WSRP. 2 text files  from the WSRP
database are dumped for generation of a coverage.  One file is a list of
coordinates, while the other is an associate ID file containing well records.      
    
 The aml 'wsrp.aml' generates a point coverage from WSRP database
 dumps, saved as (1) a coordinate table and (2) ID table 
 containing records. Original data is in NAD27 and WGS84 datums.
 The aml projects all points to ALBERS-HPGN.
 
 A coordinate table (wsrp.gen) is used as input text file to generate 
 a point coverage. Records are added from the ID table (wsrp.id)
 into a previously defined INFO table. Records not accepted are written
 to a wsrp.reject file. 
 
 The point coverage .PAT file is then joined with the INFO table to 
 create a composite feature attribute table containing all the fields. 
 WELL_ID is used as the joinitem. The coverage is brought in to ARCEDIT and
 broken up into separate coverages based on datum, using PUT command.  Item
 LOC_METH is used as proxy for datum. Coverages are projected to ALBERS-HPGN
 and combined using GET command. Point topology is rebuilt. 

 It then reselects points which fall outside the clip coverage for its destined
 library and creates a report (wsrp.libclip). New coverage then replaces the
 library layer.

Files and programs used:

well.dbf        -- wsrp database
wsrp.id		-- ID file containing well records
wsrp.gen	-- coordinate file
wsrp.dat	-- INFO table populated by records from ID file
wsrp.aml	-- aml creating ARC/INFO coverage
wsrp.reject   	-- list of points rejected by INFO
wsrp.libclip  	-- list of points outside clip coverage
Process Date: 02/28/98

Reinserted from updated .dbf file provided by Andrew Priest. The .dbf was used to create an event theme, the shapefile of which was used to reinitialize the ArcSDE layer. Process Date: 06/05/02
Reinserted from updated .dbf file provided by Andrew Priest. The .dbf was used to create an event theme, the shapefile of which was used to reinitialize the ArcSDE layer. Process Date: 01/08/03
Reinserted from updated .dbf file provided by Andrew Priest. The .dbf was used to create an event theme, the shapefile of which was used to reinitialize the ArcSDE layer. Process Date: 07/30/03
Appended 5 records which were rejected from the last update. Process Date: 08/06/03
The values for the field "DBCP" in the attribute table were set to 0 at Mark Dietrich's (WRM) request. Process Date: 3/15/2005
Data originally released by the Florida Department of Environmental Protection in 2003. When GeoPlan received the most recent dataset in 2005, it was in the following projection: Albers Conical Equal Area, Units: Decimal Degrees. The original data was limited to territories within the State of Florida. Process Date: 20050804
Data was downloaded from FDEP website in shapefile format to GeoPlan in August 2005. GeoPlan, during the QA/QC process included the following aspects: (1) Reprojected data to FGDL Albers (2) Added DESCRIPT item based on WELL_ADDRE Process Date: 20050804
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 Rd
Twin Towers MS 6520
Tallahassee, FL
32399-2400
850-245-8238

http://www.dep.state.fl.us/gis/datadir.asp

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