KGS Home Page Oil and Gas Index Page

File Format Tools


These tools may help users to make full use of the files and data we distribute from our web site. Please feel free to let us know of other tools you think should be added to this list. Mention on this page does not imply endorsement by the Kansas Geological Survey.

ZIP archive

We compress TIF and LAS files into ZIP archives. Your browser may be already set up to decompress these files. Commercial software to perform this is available from PKWARE, Inc., the company that invented the format. Other software is available from WinZip. A web page from a group of people creating shareware or public domain software is available at Info-ZIP.

Scanned Wireline Logs

The wireline logs on our website are scanned into TIF files and then compressed into ZIP archives to aid in web distribution. You can read these files in a few ways.

LAS (Log ASCII Standard) files

LAS files are digital versions of wireline logs in a format created by the Canadian Well Logging Society. The files are simple ASCII (text only) files, readable by Microsoft Word, Excel, or Notepad. Software to display or analyze LAS files includes:

PDF files

To read PDF files, you will need the Acrobat PDF Reader, available free from Adobe.

Text files of well header data

Below is a sample of the kind of well data saved. The columns are explained below the sample data.
If you import this data into Excel, you may want to make sure the LEASE and WELL columns are designated as "TEXT" columns; well numbers like "5-1" can be converted into dates like "MAY-1" by Excel.

KID API_NUMBER API_NUM_NODASH LEASE WELL FIELD LATITUDE LONGITUDE> LONG_LAT_SOURCE TOWNSHIP TWN_DIR RANGE RANGE_DIR SECTION SPOT FEET_NORTH FEET_EAST FOOT_REF ORIG_OPERATOR CURR_OPERATOR ELEVATION ELEV_REF DEPTH PRODUCE_FORM PERMIT SPUD COMPLETION PLUGGING MODIFIED OIL_KID GAS_KID KCC_DOCKET STATUS STATUS2 COMMENTS
1025721096 15-067-21246 15067212460000 CP WALTER KUHN C-2   37.3987316 -101.1165706 Calc. from footages 30 S 35 W 35 SE SE NE NW 3963 -2716 SE Mobil Oil Corporation XTO Energy Inc. 2896  GL 139   16-Sep-93 6-Oct-93 7-Oct-93   12-Sep-13       OTHER(CATH) Well Drilled  
1006065031 15-067-20950 15067209500000 CIMARRON 3-35 HICK 37.4005427 -101.1185729 Calc. from footages 30 S 35 W 35 C NE NW 4620 -3300 SE AVALON ENERGY unavailable 2895 KB 5703     20-Oct-89 28-Oct-89 29-Oct-89 17-Dec-04       D&A Plugged and Abandoned PRE-CUT (CUTTINGS WELL_ID=112735)
1006064658 15-067-20754 15067207540000 D. M. AVALON 7-35 HICK 37.3962349 -101.1139827 From GPS 30 S 35 W 35 S2 SW NE 3057 -1961 SE SIMMONS ENERGY 6G Twister, Inc. 2922 KB 5800 CHST SD   27-Feb-88 6-Apr-88   10-Oct-13 1001139414     OIL Producing PRE-CUT (CUTTINGS WELL_ID=112734)
1006064983 15-067-20925 15067209250000 D. M. AVALON 10-35 HICK 37.3932774 -101.1140605 Calc. from footages 30 S 35 W 35 C NW SE 1980 -1980 SE AVALON ENERGY Murfin Drilling Co., Inc. 2913 GL 5750 CHST SD   13-Jun-89 18-Jul-89 28-Dec-95 17-Dec-04 1020036663     OIL-P&A Plugged and Abandoned PRE-CUT (CUTTINGS WELL_ID=112733)
1026529879 15-067-20625-0001 15067206250001 WALTER KUHN UNIT 'C' 3 HUGOTON GAS AREA 37.3933077 -101.1231463 Calc. from footages 30 S 35 W 35 C NW SW 1980 -4620 SE MOBIL OIL XTO Energy Inc. 2880 GL 5760     8-Oct-87 23-Jan-88   23-Oct-13   1001117010   GAS Producing  


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.
PRODUCE_FORMProducing formation typed in from completion form or from lease production data.
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.
GAS_KIDKansas Geological Survey ID code of the gas production data, in our Lease database.
KCC_DOCKETKCC Docket 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.

Production data

The file includes an ID code used by the Kansas Geological Survey called the LEASE_KID. We are saving the Kansas Dept. of Revenue code as column 3. Finally, we have included the "Month" values for saving monthly data. Yearly data is indicated by Month=0; Starting cumulative value indicated by Month=-1. API number is listed if we have tied the production data to our well data.
This is an example of the file layout:

LEASE_KID LEASE DOR_CODE API_NUMBER FIELD PRODUCING_ZONE OPERATOR TOWNSHIP TWN_DIR RANGE RANGE_DIR SECTION SPOT LATITUDE LONGITUDE MONTH-YEAR PRODUCT WELLS PRODUCTION
1001134310 POST 121058 15-011-21887 LOST CREEK   SADLER OIL ENTPR 23 S 24 E 30   38.01561 -94.81416 4-1988 O 1 31
1001134310 POST 121058 15-011-21887 LOST CREEK   SADLER OIL ENTPR 23 S 24 E 30   38.01561 -94.81416 5-1988 O 1 31
1001134310 POST 121058 15-011-21887 LOST CREEK   SADLER OIL ENTPR 23 S 24 E 30   38.01561 -94.81416 11-1988 O 1 56

Pre-1987 cumulative data and monthly volume data is provided under license agreement to the KGS by IHS Energy. As such, it may be reviewed and used for public service and research purposes. It may not be downloaded or used for purposes of re-packaging, reselling or dissemination to third parties.


Kansas Geological Survey
Comments to webadmin@kgs.ku.edu
Updated Dec. 30, 2013
URL = http://www.kgs.ku.edu/Magellan/Elog/tif_zip.html