KGS--Water Wells Query Answer--Midwest Well & Pump

Directions: The link below contains the data you requested in a comma-delimited, ASCII file that should be readable by normal spreadsheet or database software. Files are deleted after 24 hours. Clicking on the link only opens a text file. Instead,

Right Click the link and select "Save Link As" or "Save Link to Disk" from the pop-up menu.
Save the file to your computer, keeping the extension as .txt
Open Excel or your Database
Select "Open File" and navigate to where you saved your file. Note - in Excel, to find your text (.txt) file, look to the right of the File-Name box for File-Type. Change the type from "All Excel Files" to "All" or "Text." Then you can select and open your file.
Using the Text Import Wizard:

choose "Delimited", then click on "Next."
choose by "Comma" - you’ll see the example data adjusted to columns, then click on "Next."
only if your data includes 2 separate columns for "Lease" & "Well,"" navigate to the "Well" column and change the format to Text; otherwise skip step 3.

Click on "Finish", and your file will open

Notes:
Many wells have estimated latitudes and longitudes, calculated from the center of the quarter call description provided by drillers. The source of the point location is provided in the LONG_LAT_TYPE field. The datum for the longitude and latitude is NAD 27.

Below is a description of the columns saved.

WELL_ID	Unique ID assigned by the Survey for each record
COUNTY	Name of the county where well is located
TOWNSHIP	Public Land Survey System township number, 1-35 in Kansas
TWN_DIR	Township direction. S (south) or N (north), Always south in Kansas
RANGE	Public Land Survey System range number, 1-43 in west and 1-25 in east
RANGE_DIR	Range direction. E (east) or W (west)
SECTION	The PLSS section the site is located in: 1-36
SPOT	The legal quarter description qualifiers list as NE, NW, SE, and SW, etc. Ordered from smallest to largest.
LONGITUDE	NAD 1927, generated from the legal location or entered by GPS
LATITUDE	NAD 1927, generated from the legal location or entered by GPS
LONG_LAT_TYPE	Either "GPS" or "From PLSS." If calculated from PLSS, then good to the maximum quarter calls supplied.
OWNER	Name of owner on WWC5 form
WELL_USE	Description of how the well is being used
COMPLE_DATE	Date the well was completed
STATUS	As of the completion date, Constructed, Reconstructed, or plugged
OTHER_ID	Useful ID from WWC5 such as monitoring well number or oil well name
DWR_NUMBER	Water right number if known
DIRECTIONS	Written instructions on how to find the well
WELL_DEPTH	Depth the well is completed, feet
ELEV	Land surface elevation, feet
STATIC_DEPTH	Depth to water at time of completion, feet
EST_YIELD	Yield of well at time of completion, gallons per minute
DRILLER	Name of driller
WELL_KID	Well ID from Master List of Water Wells
SCANNED	Y if the form has been scanned; N if it is not scanned yet
URL	Link to web page for this record
NAD83_LONGITUDE	NAD 1983, generated from the legal location or entered by GPS
NAD83_LATITUDE	NAD 1983, generated from the legal location or entered by GPS
CONTRACTORS_LICENSE_NUMBER	KDHE Licence Number of the well driller

		Midwest Well & Pump Data saved to a file.