Introduction to the Oil and Gas Well Shapefile: KYOG

Version 14, October, 2013


Contact: Brandon Nuttall

Some links in this document require an active connection to the Web. This version of the documentation has been prepared for distribution with the oil and gas maps of Kentucky on CD-ROM; all references to "kyog_*" apply to the ogwells shapefile.

Copyright

Data and images in this distribution are copyrighted (2005, 2006, 2007, 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 of these data is further granted the right to provide copies of the oil and gas well-data shapefiles included as described in this document provided:

  1. The data are distributed in their original form, as acquired from the Kentucky Geological Survey or downloaded from its Web site.
  2. 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 Web site.

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.

A note on the wells included in this distribution

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.

What's new

V14: The ESRI software upgrade to ArcGIS 10.1 requires a complete rewrite and new implementation of the data extract and download software, OGExtractor. To continue updating the shape files in a timely manner, the OGExtractor utility has been discarded and well location data are being processed through a direct connection between ArcMap 10.1 and the KGS data servers. All efforts were made to produce identical data distributions that are completely compatible with previous data, but it is possible some minor changes could be noted.

V13: File naming conventions have been changed to be compliant with Microsoft Jet Database engine requirements. The oil and gas well attribute data may now be imported or linked to an Access database without copying or renaming any files.

V12: Due to the upsurge in permitting and drilling of horizontal wells, especially Devonian Ohio and New Albany Shale tests, a new field has been added to the attribute table. Bore_type is now available to indicate whether the well is a conventional vertical, deviated, or horizontal well. The URL of the DjVu folder of images for the scanned records available for a well is now included.

V11: This version represents a major reformat and upgrade of the shape file. With programming support provided by Bryan Bunch of the Office of Information Systems, Kentucky Environmental and Public Protection Cabinet, a method has been implemented to enable updating the shape file on a more timely basis (daily or weekly). The shape file is provided in two versions: kyog_dd is projected in decimal degrees of latitude and longitude, NAD83; kyog_1z is projected in the Kentucky state plane single zone (NAD83 only). Field names, values, and order within the database have changed.

V10: Updated data set with new wells permitted and completed to 10-May-2005. Added data field SAMPLES to indicate avaiability of cuttings and cores at the Kentucky Well Sample and Core Library.

V9: Provisional data set, not for public release.

V8: Updated data with new wells permitted and completed to 8-Apr-2004. Added ArcView/ArcGIS projection file (kyog83v8.prj) and ArcGIS metadata file. Documentation has been converted to an html format compatible with most web browsers.

V7: Updated data with new wells permitted and completed to 6-Feb-2003. Added IOF_IP field. Incorporated location revisions; a calculation error affecting about 1,000 wells was discovered and corrected. The former Geologic Data Center at the Survey is now known as the Public Information Center.

V6: Updated data with new wells permitted and completed to 7-Nov-2002. Added elevation field. Included abandoned well locations (expired or cancelled, i.e., "terminated" permits).

V5: Updated data with new wells permitted and completed to 10-Oct-2001.

V4: Regional location data fields have been added to provide easier extended searching capabilities: the county and topo names and the Carter coordinate section, letter, and number.

V3: This distribution contains more identifying data (operator, well number, and farm name) that will enable users to better access the well records on file in the Public Information Center at the Kentucky Geological Survey. The completion data for wells and their abandoned status are also included.

Production data

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

Datum

Both shape files are projected using the North American Datum of 1983. Location data in the attributes supplied in both shapefiles include latitude and longitude in both North American datums of 1927 and 1983 (NAD27 and NAD83). The shapefile kyog_dd.shp was created using location values from the two fields: Rec_Lat83 and Rec_Lng83. The attribute files (*.dbf) of either shapefile 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 for both datums. 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 Kentucky Geological Survey Web site.

A note on samples available

The Kentucky Geological Survey maintains the Well Sample and Core Library where samples acquired during drilling or augering are catalogued and stored. These samples are available for inspection and limited analysis. For information, check the website or call Patrick Gooding or Ray Daniel at 859-389-8810.

Components of the KYOG_* shapefile

Except for their projections, the kyog_dd and kyog_1z shape files have the same components as distributed. For simplicity, the documentation will refer to the appropriate shape files as KYOG_* where the asterisk refers to the suffix specifying the projection.

KYOG_* is a zipped archive file containing an ArcView shapefile that provides an introduction and overview of the oil and gas well data available in Kentucky. This shapefile was created using services available through ActiveX, SQL, and ArcGIS 9.1. These data may be viewed with ArcView, ArcExplorer, or any software that supports shapefiles. ArcExplorer is a free viewer available for downloading at the site (visited 10-May-2005).

The kyog_* shapefile contains data for nearly 150,000 oil and gas well locations in Kentucky and consists of seven separate files:

Importing the *.dbf file to Microsoft Access

With Microsoft Access 2013, Microsoft dropped support for dBase format files. The *.dbf component in the shape files that contain the oil and gas well attribte data can't be opened or imported directly into an Access database. To import the data to Access, first open the *.dbf file with Excel 2013 (check to make sure all records were retrieved). Save the Excel file (*.xlsx format). The Excel file may be opened or imported into Access.

Data supplied for each well
API The API-style well identification number for the well. Assigning API numbers is part of an ongoing project to match data between the Kentucky Geological Survey and Division of Oil and Gas databases. As the project proceeds, more API numbers will become available. Due to the nature of the matching process, some API numbers might change as wells are matched and location problems resolved.
KGS_Recno Unique serial identifier for each well in the KGS database
Ltr 5-minute Carter coordinate section letter ("A" to "Z" and "AA" to "GG")
Num 5-minute Carter coordinate section number (0 to 92)
Sec 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 in which the well is located.
NS Designation of the reference bounding line, either north (="N") or south (="S"), of the 1-minute Carter coordinate section in which the well is located.
FEW Measurement in feet from the east or west bounding line of the 1-minute Carter coordinate section in which the well is located.
EW Designation of the reference bounding line, either east (="E") or west (="W"), of the 1-minute Carter coordinate section in which the well is located.
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. This name matches the drilling records on file at the Kentucky Geological Survey and may not match the current farm name as recorded for legal purposes in the Division of Oil and Gas database.
Org_Oper Well operator of record when the well was originally drilled. This name matches the drilling records on file at the Kentucky Geological Survey. This name may not match the current operator as recorded for legal purposes in the Division of Oil and Gas database as wells are transfered to new operators.
Org_WellNo Well number assigned by the original operator. This number matches the drilling records on file at the Kentucky Geological Survey. This number may change as wells are transferred to new operators.
TD Total depth of the well in feet
Tdfm Name of the formation penetrated at the total depth of the well. Formation codes are derived from the American Association of Petroleum Geologists stratigraphic code.
Org_WClass Original API well classification.

DEV: Development well
DPT: Deeper pool test
DPTD: Deeper pool test resulting in development of existing producing formation
EXT: Extension (outpost) well
MSC: Miscellaneous well
NFW: New field wildcat
NPW: New pool wildcat
SPT: Shallower pool test
SRV: Service well, EPA Class II injection
STR: Stratigraphic test with records released to the public
UNC: Unclassified

Org_Result An indication of the manner in which the well was originally completed.

AB: Well known to be abandoned but with no plugging information on file
AI: Air injection
CBM: Coalbed methane gas producer
COI: Carbon dioxide injection
CP: Cathodic protection
D&A: Dry & abandoned
DG: Domestic gas
ERI: Enhanced recovery injection (Class II)
FF: Fire flood
GAS: Gas producer
GI: Gas injection
GS: Gas storage
IA: Improperly abandoned
LOC: Location (new permit issued or insufficient data)
N2I: Nitrogen injection
O&G: Combined oil & gas producer
OB: Observation
OIL: Oil producer
SI: Steam injection
SRI: Secondary recovery injection (Class II)
SWD: Salt water disposal
TA: Temporarily abandoned
TAI: Thermal & air injection
TP: Termination pending
TRI: Tertiary recovery injection (Class II)
TRM: Terminated (permit expired or cancelled)
UN: Unknown (as classified by KY DOGC)
WD: Water disposal
WI: Water injection
WS: Water supply
WW: Water well

IOF_IP Initial open flow (IOF) for gas wells or initial potential (IP) for oil wells. These data are reported for the deepest or only producing interval (pay). Wells with commingled production may not have IOF or IP in this database.

BOPD: barrels of oil per day
BOPH: barrels of oil per hour
DISP: the deepest pay reported is a disposal zone
INJECT: the deepest pay reported is an injection zone
MCFGPD: thousand cubic feet of natural gas per day
MMCF: million cubic feet of natural gas per day
SUPPLY: the deepest pay reported is a water-supply zone

DeepestPay Name of the deepest or only producing formation. Formation codes are derived from the American Association of Petroleum Geologists stratigraphic code.
cdate 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 value indicates no logs. Any other value indicates one or more logs are available.
Plotsymbol General well result field for use in plotting the wells in a GIS. See table of values in this document.
Permit Permit issued by the Kentucky Division of Oil and Gas. At this time, this is the KGS formatted version of the permit that eliminates dashes and right justifies the permit in a seven-character field.
images The URL of the DjVu folder of images for the scanned records available for this well.
bore_type A code indicating the geometry of the well bore.

V: Conventional vertical well bore (not intentionally deviated)
D: A deviated well bore (intentionally deviated, but does not reach horizontal)
H: A horizontal well bore potentially including multiple laterals and pinnate deviations from those laterals
Rec_Lat27 North latitude of well in decimal degrees (NAD27)
Rec_Lng27 West longitude of well in decimal degrees (NAD27)
Rec_Lat83 North latitude of well in decimal degrees (NAD83)
Rec_Lng83 West longitude of well in decimal degrees (NAD83)


Note that the plot symbol codes supplied in this data set have been generalized from the results available in the main Oil and Gas Well Record Database. See the FAQ on result codes for more information
Key to values for the plot symbol field
D&A Dry and abandoned wells (Abnd = -1 by default)
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 (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 (Abnd = -1 by default)
TRM Locations for which a permit was issued but the permit was cancelled by the operator or allowed to expire. Wells with this designation are included to enable tracking the status of permits.

By State law, data for wells permitted as stratigraphic tests are held permanently confidential, unless information is released by the operator directly to the Kentucky Geological Survey and designated by the operator to be publicly available. Those wells designated as "STR" in the data file have been publicly released. When electronic data are provided as lists or databases, these publicly released stratigraphic tests are designated "STRP." For a time, an operator was allowed to convert a well drilled as a stratigraphic test to another purpose. This practice led to producing wells for which no information was publicly available. To eliminate this, a policy was adopted that all wells permitted as stratigraphic tests must be plugged, and no conversions are allowed. Thus, there may be a few stratigraphic tests for which a producing interval is reported; these wells are assumed to be abandoned.

Digital well data resources at the Kentucky Geological Survey

The database provided with this distribution is limited in scope. These data were initially used to compile "Distribution of Oil and Gas Wells in Kentucky" (Carey, D.I., and Nuttall, B.C., 1995, Kentucky Geological Survey, ser. 11, Map and Chart 9, scale 1:1,000,000 ) and are designed to accompany various base maps available through the Kentucky Geological Survey Web site.

Additional details for each well are available in electronic form. Subsets of the data may be specified. Well data may be selected based on counties, Carter coordinates, quadrangle, latitude and longitude bounded areas, depth of penetration, available records, and other parameters. For example, a database of the wells in Leslie and Perry Counties that penetrate the Devonian shale or deeper zones and have lithodensity logs may be created. Data are distributed by electronic mail. For larger databases, the information can be written to CD-ROM or posted to an anonymous ftp site for downloading.

There is a charge for some digital well-record data requests that can't be readily accomplished through the Kentucky Geological Survey online oil and gas well services. For information and the cost of these services contact Carrie Pulliam or by phone to 859-323-0543. MasterCard and VISA are accepted.

Online oil and gas well records

The Kentucky Geological Survey has implemented an online oil and gas well-data search facility. Data may be accessed using a selection of predefined queries or through an interactive map service. Scanned images of oil and gas well records, electric and geophysical logs (images and LAS files), production data, and stratigraphic tops are available for viewing, printing, or downloading. More information on these services is available on the KGS Web site. For first-time users, tutorial and help files are available online. The free DjVu browser plug-in is required to view the online records and the online documentation files include instructions on downloading and installing DjVu.

In addition to the interactive query and map server applications, the Kentucky Geological Survey has implemented the following services:

More information

If you have any questions or problems, contact:

Brandon C. Nuttall
Kentucky Geological Survey
228 MMRB
University of Kentucky
Lexington, KY 40506-0107

Phone: 859-323-0544
Email: bnuttall@uky.edu


2003, 2004, 2005, 2006, 2013 Kentucky Geological Survey, University of Kentucky
Created 4-Mar-2003