Water Information Storage and Retrieval Database (WIZARD)

Metadata:

Identification_Information:
Citation:
Citation_Information:
Originator: Kansas Geological Survey
Publication_Date: Varies
Title: Water Information Storage and Retrieval Database (WIZARD)
Description:
Abstract:
WIZARD is an acronym for Water Information Storage and Retrieval Database and represents a repository of information on fresh-water wells drilled into aquifers in Kansas. It contains data on the location and consturction of Kansas wells drilled for water and water-related purposes. WIZARD consolidates information fomerly maintained by several local, state, and federal agencies. For wells that are part of the statewide or local water-level observation networks, WIZARD contains an historic record of water levels measured at various times during the year. Most of these data consist of annual measurements of depth-to-water taken in the winter, but some wells are measured on a quartley or monthly basis. Except for location information, data are not complete for all wells. WIZARD is owned and maintained by the Kansas Geological Survey (KGS) for use by the citizens and agencies of the State of Kansas. WIZARD resides physically at the KGS in Lawrence, Kansas as an ORACLE relational database consisting of 19 related tables. Water-level measurements and other information in WIZARD can be accessed via the Internet at <http://magellan.kgs.ku.edu/WaterLevels/index.html>.
Purpose:
The mission of the Kansas Geological Survey, operated by The University of Kansas in connection with its research and service program, is to conduct geological studies and research and to collect, correlate, preserve, and disseminate information leading to a better understanding of the geology of Kansas, with special emphasis on natural resources of economic value, water quality and quantity, and geologic hazards. WIZARD is designed to consolidate data from a variety of sources and to serve as a unified provider of verified information for all potential customers of ground-water data in the state.
Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Calendar_Date: Varies
Currentness_Reference: Varies
Status:
Progress: In Work
Maintenance_and_Update_Frequency: Continually
Spatial_Domain:
Bounding_Coordinates:
West_Bounding_Coordinate: -102.5
East_Bounding_Coordinate: -97.2
North_Bounding_Coordinate: 40.0
South_Bounding_Coordinate: 37.0
Keywords:
Theme:
Theme_Keyword_Thesaurus: None.
Theme_Keyword: Ground Water
Theme_Keyword: Monitoring Wells
Theme_Keyword: Depth to Water
Theme_Keyword: Aquifer
Place:
Place_Keyword_Thesaurus: None
Place_Keyword: Kansas
Place_Keyword: High Plains Aquifer
Place_Keyword: Dakota Aquifer
Place_Keyword: Alluvial Aquifer
Access_Constraints:
The information in WIZARD, with the exception of data on private ownership, is freely available to any interested persons. Local, state, and federal agencies and offices, as well as qualified individuals, can apply for a user account that allow direct access to WIZARD or access the information via the Internet at <http://magellan.kgs.ku.edu/WaterLevels/index.html>.
Use_Constraints:
The Kansas Geological Survey is not responsible for the quality or accuracy of data in the WIZARD database. The database contains unverified, and raw data that are made available solely for the convenience of interested parties with the understanding that not all data are reliable. Some information in the WIZARD database has been retrieved from provisional data maintained by the U.S. Geological Survey in the Ground Water Sire Inventory (GWSI). The data contained in WIZARD may and almost certainly does contain errors both from the GWSI database and as a result of importing in into WIZARD. The Kansas Geological Survey is not liable in any way for the accuracy or completeness of these data, nor for the consequences of any decision based thereon. The Kansas Geological Survey makes no warranty or representation, either express or implied, with respect to the data, documentation, or interpretation or decisions based on the use of these data including the quality, performance, merchantability, or fitness for a particular purpose. In no event will the Kansas Geological Survey, its employees, contractors, or assigns be liable for direct, indirect, special, incidental, punitive, or consequential damages arising out of the use of or inability to use the WIZARD database or documentation whether as a result of contract, negligence, strict liability or otherwise.
Point_of_Contact:
Contact_Information:
Contact_Person_Primary:
Contact_Person: Brownie Wilson
Contact_Organization: Kansas Geological Survey
Contact_Address:
Address_Type: Mailing and Physical Address
Address: 1930 Constant Ave
City: Lawrence
State_or_Province: Kansas
Postal_Code: 66047-3726
Contact_Voice_Telephone: (785) 864-3965
Contact_Facsimile_Telephone: (785) 864-5317
Contact_Electronic_Mail_Address: bwlson1@ku.edu
Data_Set_Credit:
Gunther Hausberger, John Davis, Rick Miller, Kurt Look, Dana Adkins-Heljeson, Gina Ross, Jeff Schloss, Brett Bennett, Geoff Bohling
Native_Data_Set_Environment: ORACLE RDBMS
Data_Quality_Information:
Attribute_Accuracy:
Attribute_Accuracy_Report:
The information in WIZARD has been derived from several preexisting sources. Most of the information on well locations, well ID numbers, elevations, construction, and similar features has been taken from the U.S. Geological Survey's Ground Water Site Inventory (GWSI). With the exception of data for those wells which are included in the Kansas Geological Survey's observation well measurement program, none of this information has been verified. The GWSI database is also the source of historical measurement data of depth to water. Since 1996, the U.S. Geological Survey has obtained these depth-to-water measurements data directly from the State and local agencies that make the measurements. About two-thirds of the annual water-level data are now submitted by local GMDs and the Division of Water Resources; the other third is being updated on an annual bases with information collected by the KGS using WaterWitch. Water level and locational data from WaterWith is subjected to automatic data verification and cross-checking by global positioning systems (GPS). Data received from other source have undergone less extensive checking. The identification of aquifers being tapped by observation wells is taken from the KGS's KIWI database, supplemented by information provided by the Geohydrology Section of the KGS.
Logical_Consistency_Report:
Wells with measurements that deviated from the local trends during the initial visit are revisited and remeasured to confirm the recorded water depths. Wells that were not successfully measured during the primary trip also are revisited. In addition, about 6% of the wells measured by the KGS are randomly selected for remeasurement to make sure they were accurately measured during the initial trip that year. Re-visited wells are determined through careful examination of primary trip measurements, remeasuring any well that met at least one of the following criteria: (1) no measurement was recorded during the primary measurement trip; (2) calculated water level was up by more than 1 ft from previous years' apparent trend; or (3) calculated water level was down by more than 4 ft from previous years' apparent trend.
Completeness_Report:
Not all water wells in Kansas are measured as part of this program. Instead, a representative sampling of wells is made, so that the resulting measurements provide an accurate but cost-effective snapshot of water levels in the aquifer. As part of the statewide cooperative program, about 1,380 wells in 47 central and western Kansas counties are measured annually. Wells included in the annual water-level census are selected based on the following characteristics: (1) what aquifer they penetrate, (2) the presence of substantial amounts of water in the aquifer, (3) where the wells are located, (4) how they were constructed, (5) the amount of historical data available, and (6) how the wells are used. In general, one well in every 16-square-mile area is measured. Each year, for various reasons, about 5% of the previously measured wells cannot be successfully measured and must be replaced by other wells in the same area. Water levels generally are measured during January by staff from the DWR and the KGS. The measured wells are used for livestock, irrigation, households, municipalities, industries, and monitoring (abandoned agricultural or domestic wells). Approximately 90% of these wells are in the High Plains aquifer, which consists of the Ogallala Formation and hydrologically connected units that lie above the Ogallala.
Positional_Accuracy:
Horizontal_Positional_Accuracy:
Horizontal_Positional_Accuracy_Report:
To eliminate or at least minimize errors associated with map-reading, incorrect legal descriptions, and confusion with nearby wells, monitoring wells in the WIZARD database are identified with a computer system called WaterWitch. WaterWitch uses Global Positioning System (GPS) technology and an extensive digital map system to accurately locate wells. Wells not identified with GPS, the Public Land Survey System legal descriptions are used to located the wells to the at least the closest 10 acre tract. Older wells, have been spatialy located by the U.S. Geologic Survey.
Vertical_Positional_Accuracy:
Vertical_Positional_Accuracy_Report:
Techniques for measuring water levels are well established and have remained virtually unchanged for the last 40 years. A lead weight is attached to the end of a steel measuring tape. The weight pulls the end of the tape downward. Blue chalk is rubbed on the end of the measuring tape to help easily distinguish wet from dry. The depth from the surface to the top is calculated by subtracting the length of the wet part of the tape from the amount of tape lowered into the well hole. If a water line cannot be determined or the calculated change in water level is not consistent with the "local" trend, the well must be remeasured. The "local" trend is the average change in water levels from the previous year in nearby wells sampled in the same aquifer. A water-level measurement is considered good when the water line can be determined with confidence
Lineage:
Source_Information:
Source_Citation:
Citation_Information:
Originator: Kansas Geological Survey
Publication_Date: Varies
Title: Water Information Storage and Retrieval Database
Publication_Information:
Publication_Place: Lawrence, Kansas
Publisher: KGS
Type_of_Source_Media: ORACLE RDBMS
Source_Time_Period_of_Content:
Time_Period_Information:
Range_of_Dates/Times:
Beginning_Date: 1902
Ending_Date: Present
Source_Currentness_Reference: Present
Source_Citation_Abbreviation: WIZARD
Source_Contribution:
Monitoring well locations, well construction, and ground water levels
Process_Step:
Process_Description:
Generally, SQL statements are generated to retrieve the WIZARD data sets from the ORACLE RDBMS. The longitude and latitude fields within the database are used to generate GIS point themes.
Process_Date: Varies
Spatial_Data_Organization_Information:
Direct_Spatial_Reference_Method: Point
Spatial_Reference_Information:
Horizontal_Coordinate_System_Definition:
Geographic:
Latitude_Resolution: 0.000001
Longitude_Resolution: 0.000001
Geographic_Coordinate_Units: Decimal Degrees
Geodetic_Model:
Horizontal_Datum_Name: North American Datum of 1983
Ellipsoid_Name: Geodetic Reference System 80
Semi-major_Axis: 6378137
Denominator_of_Flattening_Ratio: 298.257
Entity_and_Attribute_Information:
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.SITES
Entity_Type_Definition:
The primary WIZARD table that lists the location and site information for all wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SITE_TYPE
Attribute_Definition: Type of site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C,D,E,H,I,M,O,P,S,T,W,X
Enumerated_Domain_Value_Definition:
 
C Collector or Ranney type well
D Drain dug to intercept the water table or potentiometric surface to either lower the ground-water level or serve as a water supply
E Excavation
H Sinkhole
I Interconnected wells, also called connector or drainage wells; that is, a well interconnected via an underground lateral
M Multiple wells. Use only for well field consisting of a group of wells that are pumped through a single header and for which little or no data about the individual wells are available
O Outcrop
P Pond dug to intercept the water table or potentiometric surface and serve as a water supply
S Spring (used only on spring schedule
T Tunnel, shaft, or mine from which ground water is obtained
W Well, for single wells other than wells of the collector or Ranney type
X Test hole, not completed as a well
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: RECORD_CLASSIFICATION
Attribute_Definition: Reliability of the data available for the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C,L,M,U
Enumerated_Domain_Value_Definition:
 
C Data have been field checked by the reporting agency
L Location not accurate
M Minimal data
U Data have not been field checked by the reporting agency, but the reporting agency considers the data reliable
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: SOURCE_AGENCY_CODE
Attribute_Definition: Agency that reports the data
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Agency acronym
Attribute:
Attribute_Label: PROJECT_NUMBER
Attribute_Definition:
Key for the which all the data collected for a particular project can be retrieved conveniently
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Various coding methods
Attribute:
Attribute_Label: STATE_CODE
Attribute_Definition:
The FIPS numeric code for the State in which the site is located.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 8,20,29,31,40
Enumerated_Domain_Value_Definition:
 
8 Colorado
20 Kansas
29 Missouri
31 Nebraska
40 Oklahoma
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: COUNTY_CODE
Attribute_Definition:
The FIPS numeric code for the county or county equivalent in which the site is located.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Unique values for each county.
Attribute:
Attribute_Label: LATITUDE
Attribute_Definition:
The best available value for the latitude of the site in decimal degrees.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Numerical values
Attribute:
Attribute_Label: LONGITUDE
Attribute_Definition:
The best available value for the longitude of the site in decimal degrees.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Numerical values
Attribute:
Attribute_Label: LAT_LONG_ACCURACY_CODE
Attribute_Definition:
Code to indicate the accuracy of the latitude and longitude values
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: S,F,T,M
Enumerated_Domain_Value_Definition:
 
S The measurement is accurate to + 1 second
F The measurement is accurate to + 5 seconds
T The measurement is accurate to + 10 seconds
M The measurement is accurate to + 1 minute
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: LAT_LONG_SOURCE
Attribute_Definition: The source of the latitude and longitude values
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: GPS, GPS(within 50 feet), GWSI, LEO
Enumerated_Domain_Value_Definition:
 
GIS Well plotted using a Geographic Information System
GPS Global positioning system
GPS (within 50 feet) Global positioning system within 50 feet of site
GWSI Original values from USGS Ground Water Site Inventory
LEO Calculated from KGS LEO plss description to lat/long conversion program
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: LOCAL_WELL_NUMBER
Attribute_Definition:
Secondary well identification based on township, range, section and other qualifiers
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain:
Example: 22S 13E 20BD 01 indicates the well lies in township 22 south, range 13 east, section 22 in the southest corner of the northwest corner. The trailing 01 indicates this is the first well identified at this location.
Attribute:
Attribute_Label: SPOT
Attribute_Definition:
The legal quarter description qualifiers list as NE, NW, SE, and SW.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain:
Example NESESW would read the NE quarter of the SE quarter of the SW quarter
Attribute:
Attribute_Label: SECTION
Attribute_Definition: The PLSS section the site is located in.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: 1 through 36
Attribute:
Attribute_Label: SUBDIVISION
Attribute_Definition: The legal quarter description qualifiers list as A, B, C and D.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain:
Example CDA would read the NE quarter of the SE quarter of the SW quarter
Attribute:
Attribute_Label: SUBDIVISION_WELL_NUMBER
Attribute_Definition:
A unique ID number for a well when multiple wells are coded within the same subdivision listing..
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Numeric values
Attribute:
Attribute_Label: TOWNSHIP
Attribute_Definition: Public Land Survey System township number.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: 1 to 35 townships numbers in Kansas
Attribute:
Attribute_Label: TOWNSHIP_DIRECTION
Attribute_Definition: Public Land Survey System township direction.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: S or N
Enumerated_Domain_Value_Definition: S = South, N = North
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: RANGE
Attribute_Definition: Public Land Survey System range number.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: 1 to 43 range numbers in Kansas
Attribute:
Attribute_Label: RANGE_DIRECTION
Attribute_Definition: Public Land Survey System range direction.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E or W
Enumerated_Domain_Value_Definition: E = East, W = West
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: MERIDIAN
Attribute_Definition: Pinciple Meriden for PLSS System?
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value
Attribute:
Attribute_Label: LOCATION_MAP_NAME
Attribute_Definition:
The name of the best available map on which the site can be located, generally USGS topographic quadrangle
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Alphanumeric characters
Attribute:
Attribute_Label: LAND_SURFACE_ALTITUDE
Attribute_Definition: The altitude of the land surface at the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Attribute:
Attribute_Label: LAND_SURFACE_ALTITUDE_METHOD
Attribute_Definition: The code for the method used to determine the altitude
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A, L, M
Enumerated_Domain_Value_Definition:
 
A Altimeter
D Digital Elevation Model
L Level or other surveying method
M Interpolated from topographic map
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: LAND_SURFACE_ALTITUDE_ACCURACY
Attribute_Definition:
The accuracy of the altitude in terms of the possible error in feet.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: An accuracy of = or - 0,1 foot would be entered as 0.1
Attribute:
Attribute_Label: HYDROLOGIC_UNIT_CODE
Attribute_Definition:
The hydrologic unit code for the Office of Water Data Coordinateion catalog unit which the site is located in. The eight-digit code consists of four parts: 1) Hydrographic region code; 2) Subregion code designated by the Water Resources Council; 3) Accounting unit within the National Water Data Network; and 4) Cataloging unit of the USGS's "Catalog of Information on Water Data"
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: 8 digit code
Attribute:
Attribute_Label: WELL_CONSTRUCTION_DATE
Attribute_Definition: The date that the site was constructed.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format
Attribute:
Attribute_Label: USE_Of_SITE_PRIMARY
Attribute_Definition:
Code indicating the principal use of the site or the purpose for which the site was constructed.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Anode
C Standby emergency supply
D Drain
E Geothermal
G Seismic
H Heat reservoir
M Mine
O Observation
P Oil or gas well
R Recharge
S Repressurize
T Test
U Unused
W Withdrawal of water
X Waste disposal
Z Destroyed
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: USE_OF_WATER_PRIMARY
Attribute_Definition: Code indicating the prinicpal use of water from the site.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value:A -Z
Enumerated_Domain_Value_Definition:
 
A Air conditioning
B Bottling
C Commercial
D Dewater
E Power
F Fire
H Domestic
I Irrigation
R Recreation
J Industrial (cooling)
K Mining
M Medicinal
N Industrial
P Public supply
Q Aquaculture
S Stock
T Institutional
U Unused
Y Desalination
Z Other (explain in remarks)
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: USE_OF_WATER_SECONDARY
Attribute_Definition: Secondary use of water from the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Same as USE_OF_WATER_PRIMARY
Attribute:
Attribute_Label: USE_OF_WATER_TERTIARY
Attribute_Definition: Third use of water from the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Same as USE_OF_WATER_PRIMARY
Attribute:
Attribute_Label: DEPTH_OF_HOLE
Attribute_Definition:
The total depth to which the hole was drilled, in feet below the land-surface, even though it may have been plugged back in completing the well.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Attribute:
Attribute_Label: DEPTH_OF_WELL
Attribute_Definition:
The depth of the finished well, in feet, below land-surface. The depth of the well is the greatest depth to which the well can be sounded; if measurement is not praticle, the reported depth.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Attribute:
Attribute_Label: DEPTH_DATA_SOURCE
Attribute_Definition:
A code indicating how the information of the depth of the well was obtained
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A,D,G,L,M,O,R,S,Z
Enumerated_Domain_Value_Definition:
 
A Reported by another government agency
D From driller's log or report
G Private geologist-consultant or university associate
L Depth interpreted from geophysical logs by personnel of source agency
M Memory (owner, operator, driller)
O Reported by the owner of the well
R Reported by person other than the owner, driller, or another government agency
S Measured by personnel of reporting agency
Z Other source (explain in remarks)
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: INV_WATER_LEVEL
Attribute_Definition:
The water level at the ground-water site, in feet below land surface when the site was inventoried.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Attribute:
Attribute_Label: INV_WATER_LEVEL_DATE
Attribute_Definition: The date on which the water level was measured for inventory.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format
Attribute:
Attribute_Label: INV_WATER_LEVEL_SOURCE
Attribute_Definition:
Code that best indicates the source of the water level. Codes are the same as DEPTH_DATA_SOURCE
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Refer to DEPTH-DATA_SOURCE
Attribute:
Attribute_Label: INV_WATER_LEVEL_METHOD
Attribute_Definition: Code indicated how the water level was measured
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Airline measurement
B Analog or graphic recorder
C Calibrated airline measurement
E Estimated
G Pressure-gage measurement
H Calibrated pressure-gage measurement
L Interpreted from geophysical logs
M Manometer measurement
N Nonrecording gage
R Reported, method not known
S Steel-tape measurement
T Electric-tape measurement
V Calibrated electric-tape measurement
Z Other
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: INV_WATER_LEVEL_SITE_STATUS
Attribute_Definition:
Code indicating the status of the site at the time the water level was measured. Blank fields indicate a static level.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: D-Z
Enumerated_Domain_Value_Definition:
 
  Blank indicate a static level
D The site was dry (no water level is recorded)
E The site was flowing recently
F The site was flowing, but the head could not be measured (no water level is recorded)
G A nearby site that taps the same aquifer was flowing
H A nearby site that taps the same aquifer had been flowing recently
I Injector site (recharge water being injected into the aquifer
J Injector site monitor (a nearby site that taps the same aquifer is injecting recharge water)
N The measurements at this site were discontinued
O An obstruction was encountered in the well above the water surface (no water level is recorded)
P The site was being pumped
R The site had been pumped recently
S A nearby site that taps the same aquifer was being pumped
T A nearby site that taps the same aquifer had been pumped recently
V A foreign substance was present on the surface of the water
W The well was destroyed
X The water level was affected by stage in nearby surface-water site
Z Other conditions that would affect the measured water level
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: SITE_RECORD_CREATED_DATE
Attribute_Definition:
The date on which the specified site was initially sotred in the WIZARD.SITES database.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Date Format
Attribute:
Attribute_Label: SITE_ESTABLISHED_INVENTORIED
Attribute_Definition: The date that the site was established or inventoried.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Date Format
Attribute:
Attribute_Label: OTHER_DATA_AVAILABILITY
Attribute_Definition: Refelcts the availability of data in other ground-water files.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y or N
Enumerated_Domain_Value_Definition:
 
Y Yes, file exists.
Blank or N No, file does not exist.
 
SGWFLE(20) 20*1 Data in other ground-water files.
SGWFLE(1) Construction (GW.CONS) date for site.
SGWFLE(2) Miscellaneous (GW.MISC) data for site.
SGWFLE(3) Discharge (GW.DISC) data for site.
SGWFLE(4) Geohydrologic (GW.GEOH) data for site.
SGWFLE(5) Hydraulic (GW.HYDR) data for site.
SGWFLE(6) Water-level (GW.LEV) data for site.
SGWFLE(7) Observation-heading (GW.OBS) data for site.
SGWFLE(8) State water-use (GW.STWU) data for site.
SGWFLE(9)-(20) Unassigned
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: AQUIFER_TYPE_CODE
Attribute_Definition: Code describes the type of aquifer(s) encountered by the well
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: U,N,C,M,X
Enumerated_Domain_Value_Definition:
 
U Unconfined single aquifer
N Unconfined multiple aquifers
C Confined single aquifer
M Confined multiple aquifer
X Mixed (confined and unconfined multiple aquifers)
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: AQUIFER_CODE
Attribute_Definition:
The eight-character code identifying the primary aquifer unit from which water is obtained. Codes are given in the USGS "Catalog of Aquifer Namnes and Geologic Unit Codes used by the Water Resource Division".
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Alphanumerical values
Attribute:
Attribute_Label: STATION_TYPE_CODES
Attribute_Definition: Array for the type of location of the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y, N or blank
Enumerated_Domain_Value_Definition:
Y Yes- Feature is represented
N or Blank No- Feature is not represented
For example, a Y in position 1 (STYPE(1)) designates the site type as a "stream". A Y in position 5 designates the site type as a "spring". Only one type can be assigned for a site.
STYPE(1) Stream
STYPE(2) Lake or reservoir
STYPE(3) Estuary
STYPE(4) Unassigned
STYPE(5) Spring
STYPE(6) Ground water other than spring
STYPE(7) Meteorological
STYPE(8)-(20) Unassigned
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: SITE_CODE_AGENCY_USE
Attribute_Definition: A code for the agency use of the site
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A,I,or O.
Enumerated_Domain_Value_Definition:
 
A Active data-collection site
I Inactive or discontinued data-collection site
O Inventory data site only
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: FLAGS_DATA_COLLECTED_TYPE
Attribute_Definition: Array codes for the type of data collected
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A,I, or O.
Enumerated_Domain_Value_Definition:
 
A Active data-collection site
I Inactive or discontinued data-collection site
O Inventory data site only
 
These codes act as flags for the types of data collected.
SDATA(1) Stage or water levels--continuous
SDATA(2) Stage or water levels--intermittent
SDATA(3) Water quality--continuous
SDATA(4) Water quality--intermittent
SDATA(5) Precipitation--continuous
SDATA(6) Precipitation--intermittent
SDATA(7) Evaporation--continuous
SDATA(8) Evaporation--intermittent
SDATA(9) Wind velocity
SDATA(10) Tide--continuous
SDATA(11) Tide--intermittent
SDATA(12) Sediment concentration
SDATA(13) Sediment particle size
SDATA(14) Peak flows
SDATA(15) Low flows
SDATA(16) State water use
SDATA(17)-(30) Unassigned
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: FLAG_INSTRUMENTS_AT_SITE
Attribute_Definition: Array codes for measuring instruments at the site.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y,N, or blank
Enumerated_Domain_Value_Definition:
 
SINST(1) Digital recorder
SINST(2) Graphic recorder
SINST(3) Telemetry--land line
SINST(4) Telemetry--radio
SINST(5) Telemetry--satellite relay
SINST(6) AHDAS
SINST(7) Crest-stage gage
SINST(8) Tide gage
SINST(9) Deflection meter
SINST(10) Bubble gage
SINST(11) Stilling well
SINST(12) CR-type recorder
SINST(13) Weighing rain gage
SINST(14) Tipping-bucket rain gage
SINST(15)-(30) Unassigned
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: REMARKS
Attribute_Definition: Significant remarks about the site.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: General comments
Attribute:
Attribute_Label: RESRICTION_NOTES
Attribute_Definition: General comments about restrictions in measureing the site
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: General comments. Example: 60-180 REPEATED HANGS
Attribute:
Attribute_Label: WELL_ACCESS
Attribute_Definition: General comment about access to the site
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Easy, Hard, Unknown
Enumerated_Domain_Value_Definition: Easy, Hard, Unknown
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: DOWNHOLE_ACCESS
Attribute_Definition: General comment about access within the site casing.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Easy or Hard
Enumerated_Domain_Value_Definition: Easy or Hard
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: GROUNDWATER_MGMT_DITRICT
Attribute_Definition: The number of the Kansas Groundwater Management District (GMD).
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 1-5
Enumerated_Domain_Value_Definition:
 
1 Western Kansas GMD #1
2 Equus Beds GMD #2
3 Southwest Kansas GMD #3
4 Northwest Kansas GMD #4
5 Big Bend GMD #5
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: GEOLOGICAL_UNIT1, GEOLOGICAL_UNIT2, GEOLOGICAL_UNIT3
Attribute_Definition: The geological units the site is exposed to.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: JM,OU,PL,KJ,KD,KN,TO,QU,QA
Enumerated_Domain_Value_Definition:
 
JM Jurassic Morrison Formation
OU Ordovician undifferentiated
PL Pennsylvanian Lawrence and Stranger Formations
KJ Lower Cretaceous/Upper Jurassic undifferentiated
KD Cretaceous Dakota, Kiowa Formations, and Cheyenne Sandstone
KN Cretaceous Niobrara Chalk
TO Tertiary Ogallala Formation
QU Quaternary undifferentiated
QA Quaternary alluvium
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: DEPTH_TO_BEDROCK
Attribute_Definition: Depth to bedrock at the monitoring site.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Numeric values if known.
Attribute:
Attribute_Label: DEPTH_TO_BEDROCK_SOURCE
Attribute_Definition: Where the depth to bedrock information came from.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: USGS and others
Attribute:
Attribute_Label: ANNUAL_WATER_LEVEL_REPORT
Attribute_Definition:
Flag indicating if the site was used in the annual water level report.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Never, no, previously, blank
Enumerated_Domain_Value_Definition:
 
Never or Blank Never included in the report
No Not included in the report
Previously Has been included in past reports
Yes Is currently used in the report
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: WATER_LEVEL_REPORT_REGION
Attribute_Definition: Reporting regions used in the annual water level report.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 1-8
Enumerated_Domain_Value_Definition:
 
1 South, West Kansas
2 Western, Central Kansas
3 North, west Kansas
4 North, Central Kansas
5 South, Central Kansas
6 North, East Kansas
7 East, Central, Kansas
8 South, East Kansas
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the staff who updated the sites record
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: character initials
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date the update to the record took place
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format
Attribute:
Attribute_Label: MAP_SCALE
Attribute_Definition: The scale of the map identified under LOCATION_MAP_NAME.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 24000 is a scale of 1:24000
Attribute:
Attribute_Label: ALTITUDE_DATUM
Attribute_Definition:
The vertical datum used for establishing land surface and water table elevations.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: NGVD29 or NAVD88
Enumerated_Domain_Value_Definition:
 
NGVD29 National Geodetic Vertical Datum of 1929
NAVD88 North American Vertical Datum of 1988
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: LAT_LONG_METHOD
Attribute_Definition:
The method in which the latitude and longitude values where calculated
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: D,G,L,M,S,or U
Enumerated_Domain_Value_Definition:
 
D Differentially corrected Global Positioning System (GPS)
G Global positioning system, uncorrected (Standard Positioning Service (SPS) and Precise Positioning Service (PPS))
L Long-range navigation system
M Interpolated from map
S Transit, theodolite, or other surveying method
U Unknown
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: LAT_LONG_DATUM
Attribute_Definition: The datum the latitude and longitude are stored in.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: NAD27, NAD27 (converted)
Enumerated_Domain_Value_Definition:
 
NAD27 North American Datum of 1927
NAD27 (converted from NAD83) Datum converted from NAD83 to NAD27
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: DRAINAGE_BASIN_CODE
Attribute_Definition:
A two-digit code that further subdivides the hydrologic-unit code.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.WATER_LEVELS
Entity_Type_Definition:
The primary WIZARD table that lists actual water level information for wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SEQUENCE_NUMBER
Attribute_Definition:
A unique sequence number for sites that share a common usgs_id value. Generally caused by multiple measurements.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 01
Attribute:
Attribute_Label: MEASUREMENT_DATE_AND_TIME
Attribute_Definition: The date on which the water level was measured.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format
Attribute:
Attribute_Label: DEPTH_TO_WATER
Attribute_Definition:
The water level at the site, in feet below land surface. If the water level is above land surface, the value will be preveded with a minus sign. If the record is blank, refer to the STATUS code.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values
Attribute:
Attribute_Label: STATUS
Attribute_Definition:
A code indicating the status of the site at the time the water level was measured. If blank, the water level was static.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: D-Z
Enumerated_Domain_Value_Definition:
 
A Measurement was determined to be "anomalous" by KGS statistical and geostatistical analysis
B Only the Year and Month were provided for the measurement date and time- defaults to first day of the month
D The site was dry (no water level recorded)
E The site was flowing recently
F The site was flowing, but the head could not be measured (no water level recorded)
G A nearby site that taps the same aquifer was flowing
H A nearby site that taps the same aquifer had been flowing recently
I Injector site (recharge water being injected into the aquifer)
J Injector site monitor (a nearby site that taps the same aquifer is injecting recharge water)
M The site was plugged
N The measurement was discontinued
O An obstruction was encountered in the well above the water surface (no water level recorded)
P The site was being pumped
R The site had been pumped recently
S A nearby site that taps the same aquifer was being pumped
T A nearby site that taps the same aquifer had been pumped recently
V Foreign substance was present on the surface of the water
W The well was destroyed
X The water level was affected by stage in nearby surface-water site
Z Other conditions that would affect the measured water level (explain in remarks)
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: METHOD
Attribute_Definition: A code indicating how the water level was measured
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Airline measurement
B Analog or graphic recorder
C Calibrated airline measurement
E Estimated
F Transducer
G Pressure-gage measurement
H Calibrated pressure-gage measurement
L Interpreted from geophysical logs
M Manometer measurement
N Nonrecording gage
R Reported, method not known
S Steel-tape measurement
T Electric-tape measurement
V Calibrated electric-tape measurement
Z Other
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: ACCURACY_CODE
Attribute_Definition: A code to qualify the accuracy of the water level data.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 0,1,2
Enumerated_Domain_Value_Definition:
 
0 Water level accurate to nearest foot
1 Water level accurate to nearest tenth of a foot
2 Water level accurate to nearest one-hundredth of a foot

 

Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: ATTEMPTS
Attribute_Definition:
The number of attempts made to obtain the water level measurement.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Numveric value
Attribute:
Attribute_Label: AGENCY
Attribute_Definition: The agency who made the measurement.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain:
agency code. For example DWR=KS Dept.of Ag- Division of Water Resources. WHTA = City of Wichita
Attribute:
Attribute_Label: TAG_NUMBER
Attribute_Definition:
The tag number for the weather-resistant measurement tag that is left at the site.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: numerical value.
Attribute:
Attribute_Label: OIL_ON_WATER
Attribute_Definition:
Idicator is oil was found on the steel tape at time of measurement.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: text values
Enumerated_Domain_Value_Definition:
 
No Oil No oil present on tape
Oil Present Oil found on tape
Unknown Unknown
 
Enumerated_Domain_Value_Definition_Source: KGS
Attribute:
Attribute_Label: LATITUDE_GPS
Attribute_Definition:
The latitude of the GPS receiver at the time of the measurement. May not be next to the site.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: LONGITUDE_GPS
Attribute_Definition:
The longitude of the GPS receiver at the time of the measurement. May not be next to the site.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: TAPE_HOLD
Attribute_Definition: The hold of the steel tape for the water level listed in feet.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: CHALK_CUT
Attribute_Definition: The cut or water mark on the steel tape.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: INITIALS
Attribute_Definition: Initials of the person taking the measurement.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: character values
Attribute:
Attribute_Label: CHALK_CUT_QUALITY
Attribute_Definition: The quality of the cut or water mark on the steel tape
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Excellent, Fair, Good, or Unknown
Attribute:
Attribute_Label: WEIGHTED_TAPE
Attribute_Definition:
Indicator if the tape was weighted, generaly by lead, for the measurement.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Varies
Enumerated_Domain_Value_Definition:
 
No Weight No weight was used
Weighted The tape was weighted during the measurement
Unknown Unknown
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: SOURCE_OF_WATER_LEVEL
Attribute_Definition:
Indicator of the source of the water level measurement. In particular to measurements volunteered by the general public.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Varies
Enumerated_Domain_Value_Definition:
 
U Unverified Volunteer Measurement
V Verified or Reviewed Volunteer Measurement
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the person who is making a change to the database.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date of the update
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.CASINGS
Entity_Type_Definition:
The primary WIZARD table that lists casing information for the wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SEQUENCE_OF_PARENT
Attribute_Definition:
This number is assigned at the time of data entry to keep data by record type in a logical order. This number is part of the primary key.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: SEQUENCE_NUMBER
Attribute_Definition:
A unique sequence number for sites that share a common usgs_id value. Generally caused by multiple measurements.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 01
Attribute:
Attribute_Label: DEPTH_TOP
Attribute_Definition:
The depth to the top of this section of casing, in feet below land surface=2E If the casing extends above land surface, the height of the casing above land surface is preceded by a minus sign (-).
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value.
Attribute:
Attribute_Label: DEPTH_BOTTOM
Attribute_Definition:
The depth to the bottom of this section of casing, in feet below land surface.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value.
Attribute:
Attribute_Label: DIAMETER
Attribute_Definition:
The inside diameter, in inches, of perforated or slotted pipe, the diameter of a screen, or the diameter of the hole, if the well is finished open-hole.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value.
Attribute:
Attribute_Label: MATERIAL
Attribute_Definition:
The code indicating the type of material from which the screen or other open section is made
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: B-Z
Enumerated_Domain_Value_Definition:
 
B Brass or bronze
C Concrete
G Galvanized iron
I Wrought iron
M Other metal
P PVC, fiberglass, or other plastic
R Stainless steel
S Steel
T Tile
Z Other (explain in remarks).
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: WALL_THICKNESS
Attribute_Definition: the thickness of the casing wall, in inches.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the person who is making a change to the database.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date of the update
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.CONSTRUCTION
Entity_Type_Definition:
The primary WIZARD table that lists construction information for the wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SEQUENCE_NUMBER
Attribute_Definition:
A unique sequence number for sites that share a common usgs_id value. Generally caused by multiple measurements.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 01
Attribute:
Attribute_Label: CONSTRUCTION_DATE
Attribute_Definition: The date on which the work was completed.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Date format.
Attribute:
Attribute_Label: CONTRACTOR_NAME
Attribute_Definition: The name of the individual or company that did the work.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values.
Attribute:
Attribute_Label: CONSTRUCTION_DATA_SOURCE
Attribute_Definition:
A code that best indicates the source of construction data; that is, who furnished the data.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Reported by another government agency
D From driller's log or report
G Private geologist-consultant or university associate
L Depth interpreted from geophysical logs by personnel of source agency
M Memory (owner, operator, driller): less reliable than D -- reported by owner
O Reported by the owner of the well
R Reported by person other than the owner, driller, or another government agency
S Measured by personnel of reporting agency
Z Other source (explain in remarks).
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: CONSTRUCTION_METHOD
Attribute_Definition:
A code that best indicates the method by which the site was constructed.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Air-rotary
B Bored or augered
C Cable-tool
D Dug
H Hydraulic rotary
J Jetted
P Air percussion
R Reverse rotary
T Trenching
V Driven
W Drive and wash
Z Other (explain in remarks).
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: TYPE_OF_FINISH
Attribute_Definition:
A code indicating the method of finish or the nature of the openings that allow water to enter the well.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C-Z
Enumerated_Domain_Value_Definition:
 
C Porous concrete
F Gravel pack w/perforations
G Gravel pack w/screen
H Horizontal gallery
O Open end
P Perforated or slotted
S Screen
T Sand point
W Walled
X Open hole
Z Other- explain in remarks.
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: TYPE_OF_SURFACE_SEAL
Attribute_Definition:
A code indicating the type of material used to seal the well againse the entry of surface water.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: B-Z
Enumerated_Domain_Value_Definition:
 
B Bentonite
C Clay or cuttings
G Cement grout
N None
Z Other- explain in remarks.
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: DEPTH_TO_BOTTOM_OF_SEAL
Attribute_Definition:
The depth to the bottom of the seal, in feet below land surface, to the nearest foot.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value.
Attribute:
Attribute_Label: DEVELOPMENT_METHOD
Attribute_Definition: A code indicating the method used to develop the well.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: A-Z
Enumerated_Domain_Value_Definition:
 
A Pumped with air lift
B Bailed
C "Blown" or surged w/compressed air
J Washed or jetted
N None
P Pumped
S Surged with surge block
Z Other- explain in remarks.
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: DEVELOPMENT_HOURS
Attribute_Definition:
The number of hours that the well was bailed, pumped, and so forth, for development.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value.
Attribute:
Attribute_Label: DEVELOPMENT_SPECIAL_TREAT
Attribute_Definition:
A code indicating any special treatment that was applied during development of the wells
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C-Z
Enumerated_Domain_Value_Definition:
 
C Chemical (acid, and so forth)
D Dry ice
E Explosives
F Deflocculent
H Hydrofracturing
M Mechanical abrasion
Z Other- explain in remarks.
 
Enumerated_Domain_Value_Definition_Source: KGS and USGS
Attribute:
Attribute_Label: UPDATED_LAST
Attribute_Definition: The last update
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the person who is making a change to the database.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date of the update
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.MEASURING_POINTS
Entity_Type_Definition:
The primary WIZARD table that lists measuring points information for the wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SEQUENCE_NUMBER
Attribute_Definition:
A unique sequence number for sites that share a common usgs_id value. Generally caused by multiple measurements.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 01
Attribute:
Attribute_Label: BEGIN_DATE
Attribute_Definition: The date on which the measuring point was established.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: END_DATE
Attribute_Definition:
If the measuring point is no longer used, the date on which is was last used as a measuring point.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: HEIGHT
Attribute_Definition:
The height of the measuring point above or below land surface datum.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric values.
Attribute:
Attribute_Label: DESCRIPTION
Attribute_Definition: A description of the measuring point.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values.
Attribute:
Attribute_Label: UPDATED_LAST
Attribute_Definition: The last update
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the person who is making a change to the database.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date of the update
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Detailed_Description:
Entity_Type:
Entity_Type_Label: WIZARD.REMARKS
Entity_Type_Definition:
The primary WIZARD table that lists general comments and remarks about the wells in the database.
Entity_Type_Definition_Source: Kansas Geological Survey
Attribute:
Attribute_Label: USGS_ID
Attribute_Definition:
Unique 15 digit identification number assigned to the site (monitoring well). Initially formed from the latitude and logitude, however, the number is an identifier, not a locator.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Every well has a unique ID number
Attribute:
Attribute_Label: SEQUENCE_NUMBER
Attribute_Definition:
A unique sequence number for sites that share a common usgs_id value. Generally caused by multiple measurements.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: numeric value. Example 01
Attribute:
Attribute_Label: REMARK_DATE
Attribute_Definition: The date that the remark was made.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: REMARKS
Attribute_Definition: General comments and remarks about the site.
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values.
Attribute:
Attribute_Label: UPDATED_LAST
Attribute_Definition: The last update
Attribute_Definition_Source: KGS and USGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Attribute:
Attribute_Label: UPDATE_INITIALS
Attribute_Definition: Initials of the person who is making a change to the database.
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: Character values
Attribute:
Attribute_Label: UPDATE_DATE
Attribute_Definition: The date of the update
Attribute_Definition_Source: KGS
Attribute_Domain_Values:
Unrepresentable_Domain: date format.
Distribution_Information:
Distributor:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Kansas Geological Survey
Contact_Address:
Address_Type: Mailing and Physical Address
Address: 1930 Constant Ave
City: Lawrence
State_or_Province: Kansas
Postal_Code: 66047-3726
Contact_Voice_Telephone: (785) 864-3965
Contact_Facsimile_Telephone: (785) 864-5317
Contact_Electronic_Mail_Address: webadmin@kgs.ku.edu
Distribution_Liability:
The Kansas Geological Survey has made a concientious effort to ensure the accuracy of the information presented. However, the Kansas Geological Survey does not guarantee this information to be completely free from errors or inaccuracies and disclaims any responsibility or liability for interpretations based on data used in the production of this site or decisions based thereon.
Metadata_Reference_Information:
Metadata_Date: 20020102
Metadata_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Kansas Geological Survey
Contact_Address:
Address_Type: Mailing and Physical Address
Address: 1930 Constant Ave
City: Lawrence
State_or_Province: Kansas
Postal_Code: 66047-3726
Contact_Voice_Telephone: (785) 864-2118
Contact_Facsimile_Telephone: (785) 864-5317
Contact_Electronic_Mail_Address: bwilson@kgs.ku.edu
Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata
Metadata_Standard_Version: FGDC-STD-001-1998
Generated by mp version 2.7.3 on Fri Apr 05 15:41:04 2002