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