FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 3.0, RELEASED JULY, 2000.

FDEP GENERALIZED WELL INFORMATION SYSTEM

 
Geodataset Name: DEPGWI
Geodataset Type: SHAPE
Geodataset Feature: POINTS

GENERAL DESCRIPTION:

This dataset contains FDEP generalized well information system for the state of Florida.

 
DATA SOURCE(S): Florida Department of Environmental
 Protection (FDEP)
 
SCALE OF ORIGINAL SOURCE MAPS: 1 : 24,000
 
DATE OF AUTOMATION OR SOURCE: July 1997
 
GEODATASET EXTENT: State of Florida

FEATURE ATTRIBUTE TABLES
Datafile Name: DEPGWI.DBF

 
NAME WIDTH TYPE PRECISION
AREA 18 DECIMAL 5 
PERIMETER 18 DECIMAL 5 
DEPGWI_ 5 DECIMAL 
DEPGWI_ID 5 DECIMAL 
GIS_SEQ 5 DECIMAL 
PK_WELL 16 CHARACTER 
AG_WELL_ID 25 CHARACTER 
LAT_DD 2 DECIMAL 
LAT_MM 2 DECIMAL 
LAT_SS 7 DECIMAL 4 
LONG_DD 2 DECIMAL 
LONG_MM 2 DECIMAL 
LONG_SS 7 DECIMAL 4 
AK_WELL_ST 1 CHARACTER  
WELL_ST 40 CHARACTER 
AK_WELL_TY 2 CHARACTER 
WELL_TYPE 40 CHARACTER 
AK_DATUM 2 DECIMAL  
LAND_SURF 7 DECIMAL 2 
MEAS_POINT 7 DECIMAL 2 
AK_WMD_COD 4 CHARACTER 
WMD_CODE 50 CHARACTER 
AK_ORG 4 DECIMAL 
AK_LOC_MTD 4 CHARACTER 
LOC_METHOD 50 CHARACTER 
USGSSITEID 15 CHARACTER 
DRILL_DATE 8 CHARACTER 
TOT_DEPTH 5 DECIMAL 
CASE_DEPTH 5 DECIMAL 
AK_CONT_MD 1 CHARACTER 
CONST_METH 50 CHARACTER 
AK_LIFT_TY 1 CHARACTER 
LIFT_TYPE 30 CHARACTER 
AK_FINISH 1 CHARACTER 
FINISH 30 CHARACTER 
SCREEN_BEG 5 DECIMAL 
SCREEN_END 5 DECIMAL 
AK_SCR_MAT 1 CHARACTER 
SCREEN_MAT 35 CHARACTER 
SCREEN_DIA 5 DECIMAL 2 
AK_CASE_MT 1 CHARACTER 
CASE_MAT 50 CHARACTER 
AK_GENCSMT 1 CHARACTER 
GENCASEMAT 50 CHARACTER 
CASE_DIA 5 DECIMAL 2 
AK_AQ_CODE 2 CHARACTER 
AQ_CODE 40 CHARACTER  
AK_SUBAQFR 8 CHARACTER 
SUBAQUIFER 60 CHARACTER 
AQU_TOP 5 DECIMAL 
AQU_BOTTOM 5 DECIMAL  
AK_HYD_UNT 8 DECIMAL 
HYDRO_UNIT 30 CHARACTER 
GEO_LOG 1 CHARACTER 
LITH_LOG 1 CHARACTER  
DRILL_LOG 1 CHARACTER 
HYDRO_DATA 1 CHARACTER 
SAMP_BN 1 CHARACTER 
SAMP_VISA 1 CHARACTER  
SAMPHRSPWS 1 CHARACTER 
BN_TV_MON 1 CHARACTER 
BN_TV_Q 1 CHARACTER 
VS_TV_MON 1 CHARACTER  
VS_TV_Q 1 CHARACTER 
VS_TV_CONT 1 CHARACTER 
USGS_SPEC 1 CHARACTER 
LEON_PILOT 1 CHARACTER  
WL_REC 1 CHARACTER 
DESCRIPT 40 CHARACTER 

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

 
ITEM NAME DESCRIPTION
 
GIS_SEQ Common uniqueidentifier
 
PK_WELL Well ID
 
AG_WEL_ID Code used by reporting agency to identify the well from
 which the sample was taken.
 
LAT_DD Represents the degrees of latitude ranging from 00 to
 90.
 
LAT_MM Represents the minutes of latitude ranging from 00
 through 59. 
 
LAT_SS Represents the seconds of latitude with a format
 allowing up to tenthousandths of a second of 
 specificity.
 
LONG_DD Represents degrees of longitude ranging from 000 to 180.
 
LONG_MM Represents the minutes of longitude ranging from 00 
 through 59.
 
LONG_SS Represents seconds of longitude with a format allowing
 up to tenthousandths of a second of specificity.
  
AK_WELL_ST A code indicating the current operational status of the
 well and is as follows:
 
 D Flowing and abandoned, not free flowing
 E Flowing and abandoned, free flowing
 F Flowing and active, not free flowing
 G Flowing and active, free flowing
 H Nonflowing and abandonded
 K Nonflowing and actively pumped
 N Nonflowing and no pump
 P Plugged
 U Unknown
 X Destroyed
 
WELL_ST An explanatory text description of AK_WELL_ST
  
AK_WELL_TY A code identifying the current, primary use of the well
 and is as follows:
 
 AS Agricultural Supply Well
 BW Public Drinking Water Well
 IS Industrial Supply Well
 IW Irrigation Well
 MW Ground Water Quality Monitoring Well
 OW Ground Water Observation Well
 SP Spring
 VW Private Drinking Water Well
 XW Other Well
 
WELL_TYPE An explanatory text description of AK_WELL_TY
 
AK_DATUM Agency Datum
 27 HPGN
 
LAND_SURF  Elevation of land surface around casing relative to
 National Geodetic Vertical Datum1929 ("mean sea
 level").
 
MEAS_POINT Elevation of water level measuring point relative to the
 National Geodetic Vertical Datum1929 ("mean sea
 level").
 
AK_WMD_COD A code identifying the Water Management District in
 which the well is located and is as follows:
 
 8023 Southwest Water Management District
 8024 South Water Management District
 8025 Northwest Water Management District
  8026 St. Johns Water Management District
 8027 Suwannee Water Management District
 
WMD_CODE An explanatory text description of AK_WMD_COD 
 
AK__ORG Agency Caode and is used as proxy for datum
 
AK_LOC_MTD Code identifier that represents the method of collection
 for a given set of geographic coordinates and is as 
 follows:
 
  AGPS Autonomous GPS
 DGPS Differentially Corrected GPS
 MMAP Manual Map Interpolation
 UNKN Unknown
 
LOC_METHOD An explanatory text description of AK_LOC_MTD
 
USGSSITEID Site identifier issued to the well by the US Geological
 Survey. 
 
DRILL_DATE Year,month and day the well drilling was completed.
 
TOT_DEPTH Total depth (in feet) to current bottom of well from
 land surface rounded to the nearest foot.
 
CASE_DEPTH Total depth (in feet) to current bottom of well casing
 from land surface rounded to nearest foot.
 
AK_CONT_MD A code describing how the well was constructed and is as 
 follows:
 
 A Air rotary
 B Bored or augered
  C Cable tool
 D Hand dug
 H Hydraulic rotary
 J Jetted
 P Air percussion
 R Reverse rotary
 U Unknown
  V Driven
 Z Other/combination
 
CONST_METH An explanatory text description of AK_CONT_MD
 
AK_LIFT_TY A code identifying the type of lift permanently
  installed in the well and is as follows:
 
 A Airlift
 B Bucket/bailer
 C Centrifugal pump
 H Hand or pitcher pump
  J Jet pump
 L Peristaltic pump
 N None
 P Piston pump
 R Rotary pump 
 S Submersible pump
 T Turbine pump
 U Unknown
 Z Other
 
LIFT_TYPE An explanatory text description of AK_LIFT_TY
 
AK_FINISH Code identifying the method of well finish and is as
  follows:
 
 F Gravelpackperforated casing
 G Gravelpackwith screen
 P Perforated or slotted casing
 S Screen
  T Sand point
 W Walled
 X Open hole
 U Unknown
 Z Any other method
 
FINISH An explanatory text description of AK_FINISH
 
SCREEN_BEG Depth to top of screened or open hole interval measured
 in feet from land surface, rounded to nearest foot.
 
SCREEN_END Depth to bottom of screened or open hole interval
 measured in feet from land surface, rounded to nearest
 foot.
 
AK_SCR_MAT A code identifying the material in which the screen is
 made and is as follows:
 
 G Galvanized iron or galvanized steel
 I Wrought iron
 L Black iron or black steel
  O Other plastics
 P PVC
 R Stainless steel
 S Steel
 X Threaded PVC no glue
 Z Other materials
 
SCREEN_MAT An explanatory text description of AK_SCR_MAT
 
SCREEN_DIA Diameter of screen in inches measured to the hundredth
 of an inch.
 
AK_CASE_MT A code describing the material of which the casing is
 made and is as follows: 
 
 A ABS plastic
 B Brick
 C Concrete
 G Galvanized iron/galvanized steel
 I Wrought iron
 L Black iron or black steel
 M Other metals 
 N Stainless steel
 P PVC
  S Steel
 U Unknown
 V PVC with glued coupling
 X Threaded pvcno glue
 Z Other metals
 
CASE_MAT An explanatory text description of AK_CASE_MT 
 
AK_GENCSMT A code describing the generic material of which the
 casing is made and is as follows:
 
 M Other metals
  O Other plastics
 P PVC
 U Unknown
 
GENCASEMAT An explanatory text description of AK_GENCSMT
 
CASE_DIA Diameter of casing in inches measured to the hundredth
 of an inch. 
 
AK_AQ_CODE Code identifying the aquifer from which water is being
 taken and is as follows:
 
 BF Any aquifer below Floridan aquifer
 FA Floridan aquifer system
 FL Lower Floridan aquifer system
 FU Upper Floridan aquifer system
 IA Intermediate aquifer system
 SB Surficial Biscayne aquifer system
 SF Surficial aquifer system
 SS Surficial NWFL sand/gravel aquifer system
 
AQ_CODE An explanatory text description of AK_AQ_CODE
 
AK_SUBAQFR Code for stratigraphic unit from which water
 is being taken.
 
SUBAQUIFER An explanatory text description of AK_SUBAQFR
 
AQU_TOP  Elevation of top of aquifer tapped relative to National
 Geodetic Vertical Datum1929 ("mean sea level").
 
AQU_BOTTOM Elevation of bottom of aquifer tapped relative to
 National Geodetic Vertical Datum1929 ("mean sea 
 level").
 
AK_HYD_UNT Code for the designator determined by the USGS for the
 surface water basin in which the well is located.  
 
HYDRO_UNIT An explanatory text description of AK_HYD_UNT 
 
GEO_LOG A yes or no flag telling whether a geophysical log is
 available for this well.
 
LITH_LOG A yes or no flag telling whether a lithologic log is
 available on this well.
 
DRILL_LOG A yes or no flag telling whether a well driller's log is
 available on this well.
 
HYDRO_DATA A yes or no flag telling whether hydrologic data are
 available for this well.
 
SAMP_BN A yes or no flag indicating whether this well was
 sampled as a background well at least once.
 
SAMP_VISA A yes or no flag indicating whether this well was
 sampled as a VISA well at least once.
 
SAMPHRSPWS A yes or no flag indicating whether this well was
 sampled as an HRS private well survey well at least
 once.
 
BN_TV_MON A yes or no flag indicating whether the well was sampled
 as a monthly TV background well at least once.
 
BN_TV_Q  A yes or no flag indicating whether the well was sampled
 as a quarterly TV background well at least once.
 
VS_TV_MON A yes or no flag indicating whether the well was sampled
  as a monthly TV VISA well at least once. 
 
VS_TV_Q A yes or no flag indicating whether the well was sampled
 as a quarterly TV VISA well at least once.
  
VS_TV_CONT A yes or no flag indicating whether the well was sampled
 as a continuous TV VISA well at least once.
 
USGS_SPEC A yes or no flag indicating whether the well was sampled
 as a USGS special project well at least once.
 
LEON_PILOT A yes or no flag indicating whether the well was sampled
 as a Leon County pilot project well at least once.
 
WL_REC A yes or no flag indicating whether the well was sampled
 as a water level recording station with a water level
 recorder which might have used a lead weighted float. 
 
DESCRIPT Based on item WELL_STATUS

USER NOTES:

Program Summary

In 1983, The Florida Legislature passed the Water Quality Assurance Act, A portion which required the Department of Environmental Protection to "establish a ground water quality monitoring network designed to detect or predict contamination of the state's ground water resources" (Florida Statutes, Chapter 403.063). To facilitate this effort, the act requires that the Department work cooperatively with other federal and state agencies, including the five Water Management Districts and other government agencies in the establishment of the network.

The Department of Environmental Protection is the lead agency in the network, determining goals and strategies, setting priorities and coordinating the effort. Contracts were developed with the five Water Management Districts and other government agencies to carry out most of the necessary field work.

The network consists of three elements each having unique monitoring priorities and goals. The three elements are:

Background Network

The purpose of the background Network is to help define background water quality through a network of approximately 1700 wells that tap all major potable aquifers within the state;

VISA (Very Intense Study Area) Network

This network monitors specific areas of the state that are believed to be highly susceptible to ground water contamination, based on predominant land use and hydrogeology. These data may or may not represent background conditions within the areas monitored, and thus, should not be used to define regional background ground water quality;

Private Well Survey

This survey is a joint effort between the Florida Department of Health and Rehabilitative Services and the Department of Environmental Protection. The survey was originally designed to analyze the ground water quality from 50 wells in each of Florida's 67 counties. Unfortunately, due to changing priorities and lack of funding, this program has been discontinued. Before curtailment, approximately 28 counties were sampled. This data will supplement the background Network by providing additional sampling points, while indicating the general quality of water consumed by private well owners.

Information on well location (latitude and longitude) was often collected by estimating location from a USGS 7.5" quadrangle. This method has not been consistently accurate, so the water management districts collecting the information have been supplied with GPS units for well location. Updates are estimated to be complete in 1997. Currently datum information is being updated. Information on well location (latitude and longitude) may be wrong for some points.

This coverage is made with July 1997 data. DEP has July. 1997 data in dBase format.

The information in this coverage is intended to provide a baseline of water quality, not necessarily identify contaminated areas.

There are numerous errors in item DRILL_DATE.
Some points are not located within WMD_CODE boundaries. Some points are not located within HYDRO_UNIT boundaries. Records missing in item SUBAQUIFER.
Records missing in item HYDRO_UNIT.

FGDL QUALITY ASSURANCE STATUS:

-Changed projection from datum HPGN to HPGN and from spheroid GRS1980 to Clark 1866.

-Tolerances were changed to FGDL standards.

-DESCRIPT item was added based on WELL_STATUS.

-Errors in items are recorded in user notes.

-Numerous item names greater than ten characters were assigned names with ten characters or less.

REFERENCES:

DATA LINEAGE SUMMARY:

DESCRIPTION OF SOURCE MATERIAL(S)

 
 SOURCE TITLE : GWIS project databases.
 SCALE : 1 : 24,000
 DATUM : HPGN
 MAP PROJECTION :  Albers Equal Area Conic
 MEDIA OF SOURCE : Borland database
 CONDITION OF MEDIA : Digital
 DATE OF SOURCE MATERIAL : 7/97
 UPDATE SCHEDULE : Quarterly
 
 CREATOR OF SOURCE OR DATA LAYER
 
 AGENCY/ORGANIZATION : Florida Department of Environmental Protection
 UNIT/SECTION : Ground Water Quality Monitoring Section
 CONTACT PERSON : James Silvanima / Paul Hansard
 TITLE : Environmental Specialists
 PHONE NUMBER : 8509219427
 
 DERIVATION METHOD(S) FOR DATA
 
 PREAUTOMATION COMPILATION : Field information entered in dBase
 COMPUTER HARDWARE USED : PCs / VAX / DEC/ALPHA
 OPERATING SYSTEM : DOS / VMS / UNIX
 DATABASE SOFTWARE AND VERSION USED : Borland dBase 4.2/Oracle/ARC/INFO
 GIS/MAPPING SOFTWARE AND VERSION USED : ARC/INFO v.7.11
 METHOD OF AUTOMATION : generate command
 RESOLUTION OF AUTOMATION : 
 TOLERANCE OF DIGITIZER, SCANNER, ETC. : 
 INITIAL DATE OF AUTOMATION : Oct. 97
 UPDATE SCHEDULE : Quarterly
 
 NAME OF COORDINATE SYSTEM USED : Lat. and long / Albers Conf. Area
 
 NOTES ON DERIVATION : Data is collected by each of the 5 Florida water
 management districts. The data is processed and compiled by the Ground 
 Water Quality Monitoring Section into .dbf files. Flat files generated 
 from the .dbf files are used as input for the Oracle loader. From Oracle,
 two files 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. Due to table length limit of 200 characters for adding records in
 ARC/INFO, the data was downloaded in to 5 separate ID files. Field GIS_SEQ
 is the common uniqueidentifier in all 5 id files. 
 
 EXPLANATION OF PROCEDURES USED TO TRANSFORM THE DATA
 (verbal description, algorithms, projection, commands, etc., as needed)
 
 The aml 'genpoints.aml' generates a point coverage from Oracle database
 (GWIS) dumps, saved as (1) a coordinate table and (2) ID table containing records.
 
 Original data is in HPGN, NAD83 and WGS84 datums. The AML projects all points to ALBERSHPGN.
 A coordinate table ("pointcov".gen) is used as input text file
 to generate a point coverage. Records are added from the 5 ID tables
 ("pointcov".id) into previously defined INFO tables. Due to a table length
 limit of 200 characters for adding records in INFO, the table is defined in 5
 blocks with item GIS_SEQ as the common uniqueidentifier. Individual blocks 
 are populated using the corresponding ID file. Records not accepted are
 written to a "pointcov" reject file.
 
 The point coverage PAT file is then joined with the INFO tables to create a
 composite feature attribute table containing all the fields. GIS_SEQ 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 AK_ORG (agency code) is used
 as proxy for datum. Coverages are projected to ALBERSHPGN 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
 ("pointcov".libclip). Genpoints then replaces the library layer.
 
 The files and programs used to build this coverage are :
 
 ogwis.sql1 dumps ogwis_bn.id and ogwis_bn.gen (5 id and gen files
 ogwis.sql2 are generated by the five queries).
 ogwis.sql3  *
 ogwis.sql4  *
 ogwis.sql5   * 
 ogwis_bn.id ID file containing well records
 ogwis_bn.gen coordinate file
 ogwis.dat INFO table populated by records from ID file
 genpoints.aml aml creating ARC/INFO coverage
 ogwis_bn.reject list of points rejected by INFO
 ogwis_bn.libclip list of points outside clip coverage
 
 The oracle work was performed in a VAX environment. The id files and 
 coordinate files were transferred to a UNIX environment where the remaining 
 work was performed. ARC/INFO v. 7.11 for UNIX was used.

MAP PROJECTION PARAMETERS:

 
Projection ALBERS
Units METERS
Datum HPGN
Spheroid  GRS1980
1st standard parallel 24 0 0.000
2nd standard parallel 31 30 0.000
central meridian -84 0 0.000
latitude of projection's origin 24 0 0.000 
false easting (meters)  400000.00000
false northing (meters) 0.00000

DATA SOURCES CONTACT(S):

 
Name: Florida Department of Environmental Protection
Abbr.name: FDEP
Web site: www.dep.state.fl.us 
Contact Person: Ground Water Quality Monitoring Section
 Phone: 850 921-9427

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