# DOCUMENTATION TEMPLATE - doc_temp_long.doc
#
# Dataset_Name: GLAC_gwsitedetail.xls
# Dataset_Description:
#    This dataset is a product of the U.S. Geological Survey's
#    National Water-Quality Assessment (NAWQA) program.
#
# Identification_Information:
#
#   Point_of_Contact:
#      Name:               Terri Arnold
#      NAWQA_Study:        Regional Ground-Water Trends: Glacial Aquifer
#      Office_Name:        USGS-WRD, Illinois District
#      IL_Office Address:  221 North Broadway Avenue, Urbana, IL 61801	
#      IL_Telephone_Number:(217) 344-0037
#      IL_FAX_Number:      (217) 344-0082
#      Email_Address:      tlarnold@usgs.gov
#      World_Wide_Web_URL: http://il.water.usgs.gov/nawqa/uirb/gapt/index.html
#
#   Citation:
#      Originator:             Terri Arnold
#      Title:                  Glacial Aquifer additional QW data
#      Edition:                1
#      Publication_Information: 
#        Publication_Date:     07/01/2004        
#      Other_Citation_Details: Data retrieved from NAWQA Internal Data 
#                              Warehouse 06/18/2004
#
#   Data_Format: (give references for all that apply)
#      World_Wide_Web_URL: http://il.water.usgs.gov/nawqa/uirb/gapt/index.html
#      Online_Linkage:     ftp://ftpdilurb.er.usgs.gov/pub/arnold/gwdetail.zip
#
#   Native_Data_Set_Environment:
#     Operating_System: Windows 2000
#     Source_Software: ASCII text and Microsoft Excel 2000
#
# Description_of_dataset:
#
#   Abstract:  This data set contains data for the following: primary 
#             water use,  well depth, open interval top and bottom,
#             casing diameter, lithology, water level, specific capacity, 
#             drawdown, discharge, discharge method, water level produced,
#             depth to top and bottom of lithologic unit, and lithologic 
#             unit ID. This data was retrieved from the NAWQA Internal Data 
#             Warehouse on June 18, 2004.
#             The data will be used in a series of reports to characterize 
#             the Glacial Principal Aquifer as part of the 
#             U.S. Geological Survey, National Water-Quality Assessment 
#             Program.
#   
#   Spatial_Domain_Descriptor:         
#      Bounding_Coordinates: 
#       West_Bounding_Coordinate: -166.27384949
#       East_Bounding_Coordinate: -51.99280167
#       North_Bounding_Coordinate: 83.55232239
#       South_Bounding_Coordinate: 37.61368942
#
#   Time_Period_of_content:   
#      Currentness_Reference: June 18, 2004
#
#   Keywords:
#      NAWQA_Program_Component: Glacial Regional Princial Aquifer 
#                               Ground-Water Trends
#      Theme_Keywords: Ground water
#      Place_Keywords: Northern United States
#
#   Supplemental_Information:
#
#      Procedures_Used:
#      Process_Step:
#        The data was retrieved from the NAWQA Internal Data Warehouse 
#        June 08, 2004. The Conditions used to retrieve the data are as follows:
#
#        Pre-set Data Warehouse conditions used for retrieving data:
#        1) Eliminate 'V' Coded data
#        2) Groundwater Chemical Environmental Data 
#        3) Groundwater Sites Only
#        4) GW POSV Patch Last Value of Day
#        5) Remove 'Set Number' and 'Surrogate' from the search
#
#        Additional Conditions for glacial aquifer wells:
#        Select Staids that are in glacial aquifer.  
#
#      Process_Step:
#        Some wells had more than one line of data. The data was collapsed
#        to one row per well.  The bottom of the open interval was used to 
#        select which lithology record to keep.  All data was concatenated 
#        into the row with the lithology of the open interval.  
#
#      Process_Step:
#        The retrieved Station IDs (STAID) were compared to a complete list of 
#        STAIDs to determine if any wells were missing fromt he data retrieval 
#        (due to no data for the requested parameters). The following STAIDs 
#        were missing: 
#        420757072390101
#        431953088113701
#        433136089235301
#        433215088010001
#        435343089040601
#        435453089184701
#        440157089180501
#        440240088544101
#        442008089135201
#        442556088443501
#        443810088311601
#        444302089144401
#        445220088535601
#        450755088125301
#        451805088363101
#        451854087545501
#        452121088541301
#        453021088055801
#        453149088570801
#        453247088425701
#        454107088011001
#        454258088411601
#        454749088345301
#        455919089003201
#        460000088235501
#        460308088130601
#        461703088043901
#        461739087192201
#        462416088191901
#
#        Lines were added to the data file for these missing wells with a 
#        '-' for all columns of data.
#
#      Process_Step:
#        Some lines in the worksheet are highlighted in yellow.  The 
#        lithologies and open intervals of these wells indicate they 
#        are drawing from bedrock and NOT galcial. These wells need to 
#        be re-verified that they are indeed sampling from the glacial 
#        aquifer.  Lines highlighted in peach color are wells that the 
#        lithologies indicate the well is much deeper than the indicated
#        well depth and/or open interval.  Lines highlighted in blue are 
#        wells for which no data was available when the data were retrieved.
#
#      Revisions:       
#      Reviews_Applied_to_Data: This data has not been reviewed
#      Related_Spatial_and_Tabular_Data_Sets:  
#      Other_References_Cited: 
#      Notes: 
#
#   Status:
#      Progress: Complete
#      Maintenance_and_Update_Frequency: none planned
#
#   Cross_Reference: None
#
#   Data_Quality_Information:
#     Completeness_Report: Complete as of date when data was pulled 
#        from NAWQA data warehouse
#         
#  Basic documentation of dataset elements and history
#
#   Entity_and_Attribute_Overview:
#
#   Attributes:  
#     Column head, description
#     principal_aq, Principal Aquifer abbreviation.  GLAC=glacial aquifer
#     Regions, region designation from Glacial aquifer stratification
#     Suid, NAWQA study unit ID
#     Su Code, NAWQA study unit code indicating with ground-water network 
#       the well is part of.
#     Su Code Alt 1, NAWQA study unit code indicating with ground-water network
#       the well is part of. Will only be filled in if well is in more than one
#       network.
#     Su Code Alt 2, NAWQA study unit code indicating with ground-water network
#       the well is part of. Will only be filled in if well is in more than two
#       networks.
#     Staid, USGS well identification number (station ID)
#     Primary water Use, Primary water use from GWSI. See GWSI documentation 
#             for possible values
#     Well Depth, depth of well below land surface, in feet
#     Depth to top open interval, Depth to top of open interval, in feet
#              below land surface
#     Depth to btm open interval, Depth to bottom of open interval, in feet
#              below land surface
#     Casing Diameter, casing diameter, in inches
#     lithology code, GWSI lithology code of lithology at bottom of the 
#              open interval.  See GWSI documentation for possible values.
#     Water level static, static water level in feet below land usrface
#     Specific Capacity, specific capacity
#     Drawdown, drawdown in feet
#     Discharge from well
#     Discharge method
#     Water level produced, water level produced
#     Depth to Top of geohydrologic Interval, depth to top of lithology 
#              unit, in feet below land surface
#     Depth to Btm of geohydrologic Interval, depth to bottom of lithology 
#              unit, in feet below land surface
#     lithologic Unit ID, GWSI lithologic unit ID, see GWSI documentation 
#              for possible values
#
# Metadata_Reference_Information:
#   Metadata_Date:     07/01/2004
#   Metadata_Contact:  Terri Arnold, tlarnold@usgs.gov
# 
# END_OF_METADATA