Wells with Wireline LogsData Saved to File | ||
Please Note--The file format is designed to make the data easier to manipulate in Excel. For files of wells and tops that are more suited to GIS and mapping use, please use the Master List of Oil and Gas Wells.
Below is a description of the columns saved.
KGS ID | Unique ID for the well assigned by the Survey. Not necessarily permanent. |
API_NUMBER | API number assigned by the Kansas Corp. Commission, or from historical records. |
API_NUM_NODASH | API number, formatted without dashes. |
LEASE_AND_WELL | Lease name and Well number. |
FIELD | Oil and gas field name |
LATITUDE | NAD 1927, generated from the legal location. |
LONGITUDE | Some new wells have GPS longitude and latitude. |
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.. |
FOOTAGES | Distance in feet north-south and east-west from the reference location. |
OPERATOR | Operator of the well at drilling completion. Not usually updated except at workover. |
LOG_OPERATOR | Operator of the well as listed on the log itself. |
ELEVATION | The elevation the well, in feet. |
ELEV_REF | KB is Kelly bushing, DF is derrick floor, GL is ground level, TOPO is estimate based on digital model. |
DEPTH | Total depth of well, not plugged back. |
FORM_AT_DEPTH | Formation at total depth. |
SPUD | Date of drilling start. |
COMPLETION | Date of drilling finish. |
PLUGGING | Date well plugged. |
STATUS | Well status--type of well. Abbreviation list |
LOGGER | Name of the company that created the well log. |
TOOL | Name of the logging tool. |
LOG_TOP | Feet below the surface of the top of the log. Note small zones such as an evaporite layer may be plotted on the log but not shown here. |
LOG_BOTTOM | Feet below the surface of the deepest part of the log. |
LOG_DATE | Date when the log was measured. |
BHT | Temperature at the bottom of the hole. |
LOG_COLOR | Color of the original log. |
SCAN_COLOR | Color of the scan. |
SCAN_URL | URL of the scans made of the log. |
UPDATE_DATE | Date this scan was (probably) created or last updated. |