Precambrian Wells Archive Data Format
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. |
| 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. |
| PERMIT | Permit date. |
| SPUD | Date of drilling start. |
| COMPLETION | Date of drilling finish. |
| PLUGGING | Date well plugged. |
| OIL_KID | Kansas Geological Survey 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. |
| STATUS | Well status--type of well. Abbreviation list |
| STATUS2 | Additional status info from KCC. |
| ELEVATION_SURFACE | Surface elevation as listed in Precambrian database |
| ELEVATION_PRECAMBRIAN | Relative to sea level |
| DEPTH_TO_PRECAMBRIAN | Depth from surface |
| PENETRATION_INTO_PRECAMBRIAN | |
| FORMATION_ABOVE_PRECAMBRIAN | |
| PRECAMBRIAN_ROCK_CODE_STR | |
| VERIFIED_BY_MICROSCOPE | |
| ISOTOPIC_AGE | |
| ISOTOPIC_AGE_MARGIN_OF_ERROR |