Directions: 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. Clicking on the link only opens a text file. Instead,
- Right Click the link and select "Save Link As" or "Save Link to Disk" from the pop-up menu.
- Save the file to your computer, keeping the extension as .txt
- Open Excel or your Database
- Select "Open File" and navigate to where you saved your file. Note - in Excel, to find your text (.txt) file, look to the right of the File-Name box for File-Type. Change the type from "All Excel Files" to "All" or "Text." Then you can select and open your file.
- Using the Text Import Wizard:
- choose "Delimited", then click on "Next."
- choose by "Comma" - you’ll see the example data adjusted to columns, then click on "Next."
- only if your data includes 2 separate columns for "Lease" & "Well,"" navigate to the "Well" column and change the format to Text; otherwise skip step 3.
- Click on "Finish", and your file will open
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, not intended to represent the data you requested:
| LEASE KID | Unique ID assigned by the Survey. Not necessarily permanent. |
| LEASE | Lease name. |
| DOR_CODE | ID code assigned by the Kansas Department of Revenue. |
| API_NUMBER | If the Kansas Geological Survey has made a link between one or more wells and the production data shown, then the API number(s) will be listed here. |
| FIELD | Oil and gas field name that this production is assigned to. |
| PRODUCING_ZONE | Producing formation. May be assigned from the field name or information that is associated with the well. |
| OPERATOR | Operator of the lease. Updated by the Dept. of Revenue. |
| COUNTY | County where lease is located. |
| 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. May be pulled from well data or DOR information; of limited quality |
| LATITUDE | NAD 1927, generated from the legal location. |
| LONGITUDE | The latitude and longitude for production data is generally not as well defined as the location created for well data. |
| YEAR | Year for the production information. |
| MONTH | Month for the production information. Yearly data is indicated by Month=0; starting cumulative value indicated by Month=-1. |
| OIL_PRODUCTION | Production of oil in barrels for the time interval shown; . |
| OIL_WELLS | Number of wells contributing to the lease. Of limited quality. |
| OIL_CUMULATIVE | Cumulative production of oil in barrels. |
| GAS_PRODUCTION | Production of gas for the time interval shown; in MCF (1000 cubic feet). |
| GAS_WELLS | Number of wells contributing to the lease. Of limited quality. |
| GAS_CUMULATIVE | Cumulative production of gas in MCF (1000 cubic feet). |
| URL | Some versions of the file include a URL to the main Lease Production web page. |
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.
