KGS Home Page Well Data base

Data Saved to File

Oil and Gas Index Page

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.
Hold your right mouse button down when you click on the link and select "Save Link to Disk" from the pop-up menu or the data file will be displayed as a web page. On Macintosh computers, hold your mouse button down and a pop-up menu should appear.


File containing tops data (for wells with tops): tops3616.txt

Use the column named KID (a unique ID code) to join the tops table to the wells table.
If there are no tops for these wells, the file will contain only the column headers.

DATA DESCRIPTIONS: Below is a description of the columns saved.

KIDUnique ID assigned by the Survey. Not necessarily permanent.
API_NUMBERAPI number assigned by the Kansas Corp. Commission, or from historical records.
API_NUM_NODASHAPI number, formatted with no dashes.
LEASELease name.
WELLWell number.
FIELDOil and gas field name
LATITUDENAD 1927, generated from the legal location.
LONGITUDESome new wells have GPS longitude and latitude.
LONG_LAT_SOURCEMay be calculated from footages, quarter calls, or from GPS.
TOWNSHIPPublic Land Survey System township number, 1-35 in Kansas.
TWN_DIRTownship direction. S (south) or N (north), Always south in Kansas
RANGEPublic Land Survey System range number, 1-43 in west and 1-25 in east.
RANGE_DIRRange direction. E (east) or W (west).
SECTIONThe PLSS section the site is located in: 1-36
SPOT The legal quarter description qualifiers list as NE, NW, SE, and SW, etc..
FEET_NORTHDistance in feet north from the reference location, negative is to south.
FEET_EASTDistance in feet east from the reference location, negative is to west.
FOOT_REFCorner from which the footages is measured.
ORIG_OPERATOROperator of the well at drilling completion. Not usually updated except at workover.
CURR_OPERATORUpdated operator name; may be newer than original operator but not guaranteed to be the current operator.
ELEVATIONThe elevation the well, in feet.
ELEV_REFKB is Kelly bushing, DF is derrick floor, GL is ground level, TOPO is estimate based on digital model.
DEPTHTotal depth of well, not plugged back.
FORMATION_AT_TOTAL_DEPTHFormation at total rotary depth.
PRODUCE_FORMProducing formation typed in from completion form or from lease production data.
IP_OILInitial production of oil, barrels.
IP_GASInitial production of gas, MCF.
IP_WATERInitial production of water, barrels.
PERMITPermit date.
SPUDDate of drilling start.
COMPLETIONDate of drilling finish.
PLUGGINGDate well plugged.
MODIFIEDDate this well record was last altered.
OIL_KIDKansas Geological Survey ID code of the oil production data, in our Lease database.
OIL_DOR_IDKansas Dept. of Revenue ID code of the oil production data, in our Lease database.
GAS_KIDKansas Geological Survey ID code of the gas production data, in our Lease database.
GAS_DOR_IDKansas Dept. of Revenue ID code of the gas production data, in our Lease database.
KCC_PERMITKCC Permit Number associated with this well.
STATUSWell status--type of well. Abbreviation list
STATUS2Additional status info from KCC.
COMMENTSInformation to enhance well data or explain problems.

Kansas Geological Survey, Oil and Gas Well Database
Comments to
Well Database Programs Updated June 6, 2014. Data added continuously.