Home Data & Downloads Oil & Gas Well Shapefile Documentation

About the Oil & Gas Well Shapefile

Version 15, March 2022  ·  Contact: Carrie Pulliam

Some links in this document require an active connection to the web. All references to kyog_* apply to the ogwells shapefile.

Disclaimer

Data in this file are presented as-is with no warranty either expressed or implied as to the completeness or accuracy of any location or well status. Data on file at the Kentucky Geological Survey are submitted by well operators under requirements established by Kentucky Revised Statute 353. The producing or abandoned status of any well is dependent on the completion type reported by the operator on the well log and completion report, on the availability of a plugging affidavit, and on other information or maps on file in the Public Information Center of the Kentucky Geological Survey.

Some wells in the database have duplicate locations (sometimes more than one well at a given location). As in the case of workovers and deepenings of existing wells, this is intended. However, in the recent conversion of our database to new software on a new server, some valid locations were inadvertently duplicated to wells that have no location. These wells are being identified and corrected. Suspect invalid duplication if there are significantly more than four or five entries at a given location and the location is in the middle of a 1-minute or 5-minute Carter coordinate section or the middle of a 7.5-minute quadrangle. Your assistance in this matter is requested and appreciated.

Data Vintage

The oil and gas well data are typically updated on a monthly basis. To determine when the data were last updated, check the extract date in the file kyog_info.txt included with each data distribution.

A Note on the Wells Included

The wells in this distribution include only those wells for which a complete Carter coordinate location is available — that is, only wells for which latitude and longitude can be calculated. For most areas in Kentucky there are wells for which we have insufficient location data to determine latitude and longitude. To obtain data for wells for which only the county, 7.5-minute quadrangle, or partial Carter coordinate are known, copies of the electronic data must be obtained directly from KGS.

Production Data

Limited production data by well are available at the Kentucky Division of Oil and Gas website. Oil and gas production data by county are available in the Division's Technical Information Library.

Datum

Both shapefiles are projected using the North American Datum of 1983 (NAD83). Location data in the attributes include latitude and longitude in both NAD27 and NAD83. The shapefile kyog_dd.shp was created using the fields Rec_Lat83 and Rec_Lng83.

The attribute file (*.dbf) can be loaded into ArcView as a table, and the fields Rec_Lat27 and Rec_Lng27 can be used to create a shapefile projected to the NAD27 datum. Latitude and longitude are expressed as decimal degrees. By convention, west longitude is expressed as a negative number.

Base Map Data

These locations are best used posted on a base map. Base maps for displaying these data may be downloaded from the KGS website:

A Note on Samples Available

The Kentucky Geological Survey maintains a collection of oil and gas well samples at the KGS Earth Analysis Research Library (EARL) where samples acquired during drilling or augering are catalogued and stored. These samples are available for inspection and limited analysis. For information, contact staff at the EARL at 859-389-8810.

Components of the KYOG_* Shapefile

Except for their projections, the kyog_dd and kyog_1z shapefiles have the same components. This documentation refers to both as KYOG_*, where the asterisk specifies the projection suffix.

KYOG_* is a zipped archive containing an ArcView shapefile with nearly 150,000 oil and gas well locations in Kentucky. The data may be viewed with ArcGIS, QGIS, or any software that supports shapefiles. The archive contains the following files:

File Description
kyog_*.AVL ArcView legend file (not required for plotting; may not differentiate all well types)
kyog_*.DBF Data attribute file — can be imported into Excel, Access, etc.
kyog_*.LYR ArcGIS layer file (not required for plotting; assigns standard symbols to all well types)
kyog_*.PRJ ESRI projection file for GIS systems that automatically recognize projection data
kyog_*.SBN / .SBX Spatial index files
kyog_*.SHP Main shapefile geometry
kyog_*.SHX Shapefile index
kyog_dd.htm FAQ-style metadata for kyog_dd — open with a web browser
ogwells.htm This documentation file
kyog_info.TXT Extract date and record count — check this file to verify data currency

Data Access & Import

Importing the *.dbf file to Microsoft Access

Microsoft Access 2013 and later dropped support for dBase format files, so the *.dbf attribute file cannot be opened or imported directly. To import the data to Access: open the *.dbf file in Excel first (verify all records were retrieved), save as *.xlsx, then open or import that Excel file into Access.

Custom data requests

Additional details for each well are available in electronic form. Subsets of the data may be specified by county, Carter coordinates, quadrangle, lat/lon bounded areas, depth of penetration, available records, and other parameters. For example, a database of wells in Leslie and Perry Counties that penetrate the Devonian shale or deeper zones and have lithodensity logs may be created.

There is a charge for some custom data requests. For information and cost, contact Carrie Pulliam at 859-323-0543. MasterCard and VISA are accepted.

Field Reference

Data supplied for each well in the KYOG_* shapefile attribute table:

Field Description
API API-style well identification number. Assignment of API numbers is an ongoing project to match data between the KGS and Division of Oil and Gas databases; some numbers may change as wells are matched and location problems resolved.
KGS_Recno Unique serial identifier for each well in the KGS database.
Letter 5-minute Carter coordinate section letter ("A" to "Z" and "AA" to "GG").
Number 5-minute Carter coordinate section number (0 to 92).
Section 1-minute Carter coordinate section in which the well is located (1 to 25).
FNS Measurement in feet from the north or south bounding line of the 1-minute Carter coordinate section.
NS Reference bounding line: north (N) or south (S) of the 1-minute Carter coordinate section.
FEW Measurement in feet from the east or west bounding line of the 1-minute Carter coordinate section.
EW Reference bounding line: east (E) or west (W) of the 1-minute Carter coordinate section.
Surf_Elev Ground-level elevation of the well in feet above sea level.
USGS_Quad Name of the 7.5-minute, 1:24,000-scale quadrangle on which the well is located.
County County in which the well is located.
Org_Farm Original farm or lease name (usually mineral owner in the case of severed minerals) under which the well was drilled. May not match current records in the Division of Oil and Gas database.
Org_Oper Well operator of record when the well was originally drilled. May not match current operator as wells are transferred.
Org_WellNo Well number assigned by the original operator. May change as wells are transferred to new operators.
measured_depth Measured depth of the well in feet.
Tdfm Name of the formation penetrated at total depth. Formation codes are derived from the AAPG stratigraphic code.
Deepst_Pay Name of the deepest or only producing formation (AAPG formation code).
IOF_IP Initial open flow (IOF) for gas wells or initial potential (IP) for oil wells, reported for the deepest or only producing interval. Units: BOPD (barrels oil/day), BOPH (barrels oil/hour), MCFGPD (thousand cubic feet gas/day), MMCF (million cubic feet gas/day). Wells with commingled production may not have IOF or IP in this database.
Org_WClass Original API well classification. Values: DEV (Development), DPT (Deeper pool test), DPTD (Deeper pool test–development), EXT (Extension/outpost), MSC (Miscellaneous), NFW (New field wildcat), NPW (New pool wildcat), SPT (Shallower pool test), SRV (Service/EPA Class II injection), STR (Stratigraphic test, public), UNC (Unclassified), WSW (Water supply well).
Org_Result Original well completion type. Values include: AB (Abandoned, no plug data), AI (Air injection), CBM (Coalbed methane), COI (CO₂ injection), CP (Cathodic protection), D&A (Dry & abandoned), DG (Domestic gas), ERI (Enhanced recovery injection), FF (Fire flood), GAS (Gas producer), GI (Gas injection), GS (Gas storage), IA (Improperly abandoned), LOC (Location/new permit), N2I (Nitrogen injection), O&G (Combined oil & gas), OB (Observation), OIL (Oil producer), SI (Steam injection), SRI (Secondary recovery injection), SWD (Salt water disposal), TA (Temporarily abandoned), TAI (Thermal & air injection), TP (Termination pending), TRI (Tertiary recovery injection), TRM (Terminated), UN (Unknown), WD (Water disposal), WI (Water injection), WS (Water supply), WW (Water well).
Cmpl_Date Date well was completed, if known.
Plug_date Date well was plugged and abandoned, if known.
Plug_Afdvt Availability of documentation on the manner in which the well was plugged and abandoned.
Core Call number of core on file at KGS.
Cuttings Call number of drill cuttings on file at KGS.
Elog Service abbreviation of geophysical log on file. Null = no logs on file.
Plotsymbol Generalized well result field for GIS plotting. See the Plot Symbol Key section below.
KGS_Permit Permit issued by the Kentucky Division of Oil and Gas (KGS-formatted, no dashes, right-justified in a 7-character field).
images URL for the well report and link to scanned well record images available for this well.
bore_type Geometry of the well bore. V = Conventional vertical; D = Deviated (intentionally, but not horizontal); H = Horizontal (potentially including multiple laterals).
Rec_Lat27 North latitude in decimal degrees (NAD27).
Rec_Lng27 West longitude in decimal degrees (NAD27).
Rec_Lat83 North latitude in decimal degrees (NAD83).
Rec_Lng83 West longitude in decimal degrees (NAD83).

Plot Symbol Key

The plot symbol codes in this dataset have been generalized from the results available in the main Oil and Gas Well Record Database.

Code Description
D&A Dry and abandoned wells
GAS Wells completed as gas wells (including abandoned producers)
LOC Newly permitted locations or historic wells for which completion data are not available in the KGS database
MSC Miscellaneous well types, including cathodic protection, observation, water supply wells, and others
O&G Wells completed as combined oil and gas producers (including abandoned producers)
OIL Wells completed as oil producers (including abandoned producers)
SRV Secondary recovery input, water injection, and other miscellaneous well types associated with secondary or enhanced oil recovery (EPA Class II wells)
STR Stratigraphic tests released to the public
TRM Locations for which a permit was issued but later cancelled or allowed to expire — included to enable tracking permit status

By state law, data for wells permitted as stratigraphic tests are held permanently confidential unless released by the operator directly to KGS and designated as publicly available. Wells designated "STR" in this file have been publicly released. There may be a few stratigraphic tests for which a producing interval is reported; these wells are assumed to be abandoned.

Online Tools

Contact

Carrie Pulliam

Kentucky Geological Survey

340 MMRB, University of Kentucky

Lexington, KY 40506-0107

859-323-0543

carrie.p@uky.edu

© Kentucky Geological Survey, University of Kentucky. Documentation created March 2003, last revised March 2022.