Format for files of oil and gas well data
Below is a description of the columns saved. The files are comma-delimited text files.
| KID | Unique ID 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 with no dashes. |
| LEASE | Lease name. |
| WELL | 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. |
| LONG_LAT_SOURCE | May be calculated from footages, quarter calls, or from GPS. |
| 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.. |
| FEET_NORTH | Distance in feet north from the reference location, negative is to south. |
| FEET_EAST | Distance in feet east from the reference location, negative is to west. |
| FOOT_REF | Corner from which the footages is measured. |
| ORIG_OPERATOR | Operator of the well at drilling completion. Not usually updated except at workover. |
| CURR_OPERATOR | Updated operator name; may be newer than original operator but not guaranteed to be the current operator. |
| 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. |
| PRODUCE_FORM | Producing formation typed in from completion form or from lease production data. |
| IP_OIL | Initial production of oil, barrels. |
| IP_GAS | Initial production of gas, MCF. |
| IP_WATER | Initial production of water, barrels. |
| PERMIT | Permit date. |
| SPUD | Date of drilling start. |
| COMPLETION | Date of drilling finish. |
| PLUGGING | Date well plugged. |
| MODIFIED | Date this well record was last altered. |
| OIL_KID | Kansas Geological Survey ID code of the oil production data, in our Lease database. |
| OIL_DOR_ID | Kansas Dept. of Revenue ID code of the oil production data, in our Lease database. |
| GAS_KID | Kansas Geological Survey ID code of the gas production data, in our Lease database. |
| GAS_DOR_ID | Kansas Dept. of Revenue ID code of the gas production data, in our Lease database. |
| KCC_PERMIT | KCC Permit Number associated with this well. |
| STATUS | Well status--type of well. Abbreviation list |
| STATUS2 | Additional status info from KCC. |
| COMMENTS | Information to enhance well data or explain problems. |