Home Data Help

Help on Downloadable Data Sets


Questions...
What is this data?
What columns are in the data?
What can I do with these files?
How do I download this data to my PC?
Help! This doesn't look right!
Do I need a browser to move the data to my hard disk?
What data is on the Internet?
What do "NMT" and "UTM" mean?

Also available is the Main Help Page


What is this data?
Annual water level measurements are taken in about 1,500 wells located in central and western Kansas. The Division of Water Resources (DWR) of the Kansas Department of Agriculture and the Kansas Geological Survey are the primary sponsors. For more information see the start of this report.

What columns are in the data?
Two versions of the data are available on this CD. A small set has only the well locations and the 2000 water levels. The larger set has complete well information and levels for 1991-2000.
Small Set ContentsMeaning
USGS_IDA unique well identifier assigned by the U.S. Geological Survey, based on the latitude and longitude of the well location.
COUNTYCounty name where well is located.
TOWNSHIPTownship value of well. In Kansas, the townships range from 1 in the north to 35 in the south. See T-R Figure for additional information.
TOWNSHIP_DIRECTIONSouth, in Kansas.
RANGERange values are 1 to 42 West or 1 to 25 East, with 1 at the Sixth Principal Meridian. See T-R Figure for additional information.
RANGE_DIRECTIONKansas is split into East and West ranges along the Sixth Principal Meridian, a north-south line that runs along the Washington-Republic county line in the north to slightly east of the center of Sumner County. See T-R Figure for additional information.
SECTIONEach township-range block is split into 36 sections. See Section Numbering Figure for additional information.
SPOTEach section is split into quarters, designated by A, B, C, or D. The section is split a maximum of four times, listed from largest to smallest. See Spot Figure for additional information.
LONGITUDEThe longitude of the well, generated by GPS readings or converted from legal descriptions.
LATITUDEThe latitude of the well, generated by GPS readings or converted from legal descriptions.
WATER_LEVELThe depth to water in feet found in the latest survey. Wells with readings taken are listed. If there are two values (standard and quality control) then two complete records are included.
MEASUREMENT_DATEThe date the measurement was taken. A few wells have two records because of quality checks. The date can be used to separate the values.
MEASUREMENT_TIMEThe time the measurement was taken.
Large Set ContentsMeaning
USGS_IDA unique well identifier assigned by the U.S. Geological Survey, based on the latitude and longitude of the well location.
COUNTYCounty name where well is located.
TOWNSHIPTownship value of well. In Kansas, the townships range from 1 in the north to 35 in the south. See T-R Figure for additional information.
TOWNSHIP_DIRECTIONSouth, in Kansas.
RANGERange values are 1 to 42 West or 1 to 25 East, with 1 at the Sixth Principal Meridian. See T-R Figure for additional information.
RANGE_DIRECTIONKansas is split into East and West ranges along the Sixth Principal Meridian, a north-south line that runs along the Washington-Republic county line in the north to slightly east of the center of Sumner County. See T-R Figure for additional information.
SECTIONEach township-range block is split into 36 sections. See Section Numbering Figure for additional information.
SPOTEach section is split into quarters, designated by A, B, C, or D. The section is split a maximum of four times, listed from largest to smallest. See Spot Figure for additional information.
LONGITUDEThe longitude of the well, generated by GPS readings or converted from legal descriptions.
LATITUDEThe latitude of the well, generated by GPS readings or converted from legal descriptions.
RESTRICTION_NOTESContains information on depths where the measuring tape has gotten caught or hangs up. Based on previous measurement attempts.
WELL_ACCESSAccess to the well can be described as "Easy," "Hard," or "Unknown."
DOWNHOLE_ACCESSThe difficulty in actually getting the tape into the well for measuring can be described as "Easy," "Hard," or "Unknown."
MP_HEIGHT
MP_DESCRIPTION
TAPE_HOLDThe stop depth or tape hold is used to decide how much tape should be let down the well. This value is based on the previous years' values.
CHALK_CUTThe value on the steel tape at which the chalk has been washed away.
CHALK_CUT_QUALITYThe water level in the well is measured by where on the steel tape the chalk has been washed off. The chalk is washed off by the water standing in the well, but may also be washed off by water cascading in the well or by casing moisture encountered as the tape dropped in the well. The quality of the cut is made in the field to help in assessing the measurement's quality. Values of "Excellent", "Fair", "Good", and "Unknown" are allowed.
OIL_ON_WATERIf traces of oil are found on the measuring tape, it is noted in the data.
WATER_LEVELThe depth to water in feet found in the latest survey. Wells with readings taken are listed. If there are two values (standard and quality control) then two complete records are included.
MEASUREMENT_DATEThe date the measurement was taken. A few wells have two records because of quality checks. The date can be used to separate the values.
MEASUREMENT_TIMEThe time the measurement was taken.
INITIALSThe initials of the person responsible for taking the measurement.
AGENCYThe initials of the agency responsible for the measurement. "KGS" is Kansas Geological Survey, "DWR" is Division of Water Resources of the Kansas Department of Agriculture.
2000_LEVELFirst level (in feet) from 2000 in database.
1999_LEVELFirst level (in feet) from 1999 in database.
1998_LEVELFirst level (in feet) from 1998 in database.
1997_LEVELFirst level (in feet) from 1997 in database.
1996_LEVELFirst level (in feet) from 1996 in database.
1995_LEVELFirst level (in feet) from 1995 in database.
1994_LEVELFirst level (in feet) from 1994 in database.
1993_LEVELFirst level (in feet) from 1993 in database.
1992_LEVELFirst level (in feet) from 1992 in database.
1991_LEVELFirst level (in feet) from 1991 in database.

What can I do with these files?
Any spreadsheet (like Excel from Microsoft) can read these files. They are comma delimited text files. The Import Wizard in Excel will lead you through importing the data.

1. Excel will show you the first part of your file. Make sure that the "Delimited" button is checked.
first Excel screen

2. Check the "Comma" box in the "Delimiters" area. It will not matter if the "Tab" box is checked also. Make sure the " (double quotes) mark is selected as the Text Qualifier.
second Excel screen

3. Finally, you may want to change the USGS-ID column to a Text field from a Number field. The ID is a large number, and it may be more convenient to view it as a character value.
third Excel screen

How do I download this data to my PC?
If you click on a link to a web page or text file shown on your browser, that information will be displayed in your browser window. The data on this CD is not formatted to viewed that way. It is meant to be downloaded and read into software such as Microsoft Excel.
If you hold down your right mouse button (or normal mouse button on a Macintosh) a pop-up menu will appear. It will allow you to save the file to your hard disk.
Menu in Netscape
for normal text link
Menu in Netscape
for clicking on a map
pop-up menu pop-up menu

Help! This doesn't look right!
If you see a picture similar to that shown below when you click on a link for data, then you are viewing the data file instead of downloading the data file. See How do I download this data to my PC? for help. However, you can always use the "Save as..." command on your browser to save the data you see to your hard disk. It's just easier to use the pop-up menu.

viewing, not downloading

Do I need a browser to move the data to my hard disk?
No! All the files on this CD are ASCII files. We've designed this web browser interface to help people retrieve the data. If you examine the files on the CD, you will find a directory called "Data" with subdirectories called "Large" and "Small". You can read the files from those directories directly into Excel from the CD or you can copy the files you need from the CD to your hard disk.

What data is on the Internet?
The CD-ROM is a "picture" of the data in the KGS WIZARD database. You can query the data online using this link KGS WIZARD Page if your computer is connected to the internet.

What do "NMT" and "UTM" mean?
If a well is part of the observation well network but we have no water level measurement information in the database, then that value is flagged as "NMT." A NMT flag may mean the well could not be found, was destroyed, or that no one tried to visit that well. If a well was visited but no measurement could be taken, then a flag of "UTM" is used. UTM means there is a measurement record in the database, but that the water level value is missing or NULL.

Kansas Geological Survey, Water Level CD-ROM
Send comments and/or suggestions to webadmin@kgs.ku.edu
Updated April 2, 2001
Available online at URL = http://www.kgs.ku.edu/Magellan/WaterLevels/CD/Data/help.htm