About the Oil & Gas Well Shapefile
Version 15, March 2022 · Contact: Carrie Pulliam
Copyright
Data and images in this distribution are copyrighted (2005–2008) by the Kentucky Geological Survey, University of Kentucky. The user is granted the right to use these data to produce maps, charts, and reports. The user is further granted the right to provide copies of the oil and gas well-data shapefiles provided:
- The data are distributed in their original form, as acquired from the Kentucky Geological Survey or downloaded from its website.
- This documentation, including the notice of copyright and disclaimer, are provided without modification.
If you have acquired these data from a third party, the Kentucky Geological Survey invites you to visit our website.
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
Oil & Gas Data Search (KY Geode)
Search well records using predefined queries. Access well logs, scanned images, stratigraphic tops, and production data.
Interactive Map Service
Explore oil and gas well locations on an interactive map. View, query, and export data from the KGS well database.
KGS Coordinate Conversion Tool
Perform coordinate conversions and datum changes including Kentucky State Plane Single Zone and Carter coordinate grid locations.
KGS Multiple Coordinate Conversion Tool
Convert sets of x,y Kentucky-based coordinates in a submitted text file.
KGS Gathering Line Map Tool
Required by regulation (KAR 1:190): create gathering line maps for submission to the Kentucky Division of Oil and Gas.
Contact
Carrie Pulliam
Kentucky Geological Survey
340 MMRB, University of Kentucky
Lexington, KY 40506-0107
859-323-0543