FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 2005
TITLE: 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