KGS Home > Oil and Natural Gas
Tutorial for Accessing KGS Oil and Gas Well Record System
Contact: Brandon Nuttall
Basic Skills: Several basic computer operating skills are assumed by these instructions. You need to know how to:
- Use your computer's utilities for navigating the local file system on your computer.
- Navigate the World Wide Web.
- Download a file from the Web.
- Start programs and applications including how to install programs.
- Mouse skills: single click, double click, left click, right click, click and drag.
- Use scroll bars to view different parts of documents.
- Use your Web browser's security features especially concerning pop-up windows. Pop-ups need to be enabled to view the results of many KGS data searches.
If you need help with these skills, visit your local library. Most community or adult education programs offer free resources. Books like The Internet for Dummies
, Windows XP for Dummies
, and other references are available. don't forget that the help files supplied with operating systems and Web browsers also has key information.
Accessing oil and gas well records
- Open the criteria-based tabular search page . This service allows the user to select records and returns the records in a table.
- From the main KGS Web site ( www.uky.edu/KGS ) click " Search Databases and Publications "
- Click " Search for Oil & Gas Well Records "
- Other services
- The DjVu web browser plug-in is required to view the digital images of the records, click the "Download DjVu Plug-in" button. DjVu should begin installing automatically. Or, click here to go directly to the DjVu download page . You only have to do this once . The DjVu plug-in AutoInstaller may not work with all operating systems and browsers. If you have any trouble, download and install DjVu using the manual installer.
- Select a search method. Options are often selected by using the pull-down menu selector tool at the right end of a dialog box. The pull-down menu selector is a gray button with a downward pointing "v" or triangle. When instructed to pick a method, county, quadrangle, or others, click this tool to see the choices. This tutorial will illustrate the default well search by topographic quadrangle.
- Search methods:
- Search Kentucky : This method includes all wells in the database for the search. It is usually used to monitor recent activity when combined with the choices to limit the search by completion date or date the permit was issued.
- Search by 1:24,000 Quadrangle (default): Pick USGS 7.5-minute topographic quadrangle name from a list.
- Search by County : Pick the Kentucky county name from a list
- Search by Carter Coordinates : Use the Kentucky land grid to select wells
- ADVANCED: Radius Search (lat/long coordinates) : Find all wells within a specified distance from a location you select using degrees, minutes, and seconds of latitude and longitude.
- ADVANCED: Radius Search (decimal degree coordinates) : Find all wells within a specified distance from a location you select using decimal degrees of latitude and longitude.
- Search by Plat/Permit Number : Find one well if you know the permit number. Permits are issued by the Division of Oil and Gas and may contain letters. Do not include dashes or blanks when entering a permit. Information on Kentucky permits is available in the FAQ .
- Search by KGS Record Number : Find one well if you know the unique serial number assigned to the well by the KGS. This number is used by the Survey to tie all the data (including images) for a well together. Unless you have purchased digital data from the Survey or downloaded KYOG83.zip, the current ArcView shape file , you probably don't have this number.
- Search by Operator and/or Farm Name : Find wells drilled by a particular company or on a specified lease. Both operator and farm name can be specified.
- Choose the quadrangle to search using the pull-down menu tool. Hint: type the first letter and the list of choices will jump to that part of the alphabet.
- If appropriate, filter or limit the number of wells to be found by choosing one or more of the limiting conditions.
- Only wells drilled in the past year of TODAY will select wells with a completion date within the previous 365 days.
- Completion date specify a date or range to get only wells completed during that time period
- Equals : exact date match
- Between : between two dates you specify
- Younger than : completed since the date you specify
- Older than : completed before the date you specify
- Note that this option does not return recently permitted wells for which no completion date is available. This functionality is being implemented.
- ONLY records with samples will select wells with cuttings or cores on file at the Kentucky Well Sample and Core Library . A separate cutting and core data search is also available.
- ONLY records with E-logs will select wells with electrical or geophysical logs on file. For more information see What is an electric log (mud log, geophysical log, or others)?
- ONLY records with Completion data will select wells on which drilling records are available. Expired or cancelled permits, recently issued permits, and tight holes for which no data other than location are available will be dropped from the well list returned by the search.
- ONLY records with Deepest Pay data will select producing wells, secondary recovery wells, gas storage wells, and others with reported completion intervals. Dry holes and the like will be excluded. The pay formation and formation penetrated at the total depth of a well are translated from stratigraphic formation codes used at the Survey. From the tabular search interface, you cannot search for specific pays or formations. Use the query feature of the map viewer interface to perform this type of search.
- These filters can be used in combination to select, for example, only producing wells with electric logs in a specified area.
- Once you have selected your criteria, click the "Search for oil and gas wells" button to display a table of wells that match your requested area. Take note of the total wells and total pages returned by the search; the information is displayed in the upper left of the results screen. To navigate multiple pages, a list of links to the first, previous, next, and last page is provided at both the top and bottom left of the data table.
- Click the "View Records" link to display the disclaimer and thumbnail index of available records. If this doesn't work, you likely have a DjVu problem, return to step 2. If you have any questions, read the disclaimer first. If you are still having problems, a trouble shooting giude is available.
- Click on a thumbnail to view an image.
- Use the mouse to point to each button on the toolbar to learn the function of the button. You can zoom in and out, zoom to a selected area, print, or save the image. Additional help on DjVu and user manuals are available at www.lizardtech.com . If you are having problems viewing or printing records, see the FAQ
- Close the image window to return to the list of wells.
- Click the "Map View" link to display a map centered on the well. The well is the larger red dot in the center of the map window. The map view tool bar is in the upper left. Help and tutorial links for the map interface are also on the left. Using the mouse to point to each of the buttons in the tool bar will display a label giving the function of each button. The map view may also be started by choosing "Search for Oil & Gas Wells by Map (ArcIMS)" link from the Search Oil & Gas Well Records Database page.
- Zoom and pan tools (the magnifying glasses and the hand) are available to magnify and reposition the map. You will have to zoom in to enable display of the oil and gas well layer.
- Use the toggle between legend and layers tool (button in upper left corner) to display a list of layers. Make the oil and gas wells the active layer (click next to the layer name in the "Active" column).
- Use the "identify" tool (the black dot with a white letter "i") to click on a well and display information about it in a list at the bottom of the page.
- Use the "find" tool (the binoculars) to perform a case-sensitive search of the data. For example, type in "DUNCAN, CHOICE" then click the find string button to find the deepest well in the state: total depth 15,200 feet. The well will be highlighted with a yellow spot. If it is not in the field of view, click the 1 in the "Rec" column to center the map on the well. (The highlight may turn red.)
- Use the "select by rectangle" tool (the dashed rectangle with an arrow) to highlight wells in an area. A list of the selected wells will be displayed that can be highlighted, copied, and pasted into a spreadsheet program.
- More sophisticated searching tools are available using the "query" tool (the sheet with a red question mark). To use this tool successfully, you will need to read the documentation and develop a familiarity with the data.
- Data may be downloaded as an ASCII text file with a semicolon to separate data items. At the top of the returned data table, there is a "Download Headers:" box.
- Click the "Download Header Report" button
- Select the datum (NAD27 or NAD83) and coordinate projection for the data you want to download. The default is NAD27, geographic coordinates (decimal degrees of latitude and longitude). You must remember this if you want to import the data into any mapping software.
- Click the "Download Text File" button
- Your browser should open a new dialog box that requests you choose whether to save or open a file called "oildownload.kgs". Note that the file type of kgs was chosen to force most browsers to open the dialog box. If you have associated files of type txt or kgs (and others) with Notepad, the file will open automatically. Simply use the File | Save As menu command in Notepad to save the file.
- To import the downloaded file into a spreadsheet or database program, make sure you specify that the first line of data contains column headings (field names) and that the delimiter separating data columns (fields) is a semicolon.
- Example 1: Importing the downloaded ASCII text file into Excel
- Start Excel
- Choose File | Open
- Navigate to the directory where the file oildownload.kgs was stored (the Desktop is often the default location)
- Set the Files of Type dialog to All Files. Select oildownload.kgs from the list of files. Click the Open button. The first step of the Text Import Wizard should start.
- The file is "Delimited". Click Next.
- In the list of delimiters, select the semicolon. Click Next.
- Scroll right to find the permit_number field. Click in the column heading that says "General" to select the column. Set the column data format for the permit_number field to be "text". Click Finish.
- The Kentucky Geological Survey, Publication Information Center, can create a printout of the information associated with the oil and gas wells for a $10 setup fee, plus $0.05 a well.
- Example 2: Importing the downloaded ASCII text file into National Geographic TOPO! . TOPO! is an example of many programs available to plot downloaded data on a map. This example will only if you have downloaded data with coordinates in decimal degrees of latitude and longitude.
- Start TOPO!
- Choose Handhelds | Import (from GPS or .txt) Wizard
- Select to import data from a text file. Click Next.
- Set the Files of Type dialog to All Files. Navigate to the directory where you stored the file and select oildownload.kgs from the list of files. Click the Open button.
- Select "Other" as the character used to separate the different fields in a line of data and type a semicolon into the box.
- Click on line number 002 to skip the column headers. Click Next.
- You want to import Waypoints.
- Choose the datum you specified when you downloaded the data from the Survey's Web site.
- Click Next. (Ignore statement 3 about specifying the format of local time.)
- Select "Yes", every line of your data file contains a location to import.
- Click on the first column and select Name from the pop-up menu.
- Click on the second column and select Latitude | DD.ddd from the pop-up menus
- Click on the third column and select Longitude | DD.ddd from the pop-up menus
- Click on the fourth column and select Elevation | Elevation (feet) from the pop-up menus
- Select one of the other columns to be the Message. Some choices are column 6 (well completion), column 11 (operator), or column 12 (farm name). All the other columns should be set to "Ignore".
- Click Finish. A message will be displayed showing the number of waypoints (wells) successfully imported.
- Zoom in or pan as necessary to see the well locations.
- Note that TOPO! is not a GIS program. There is currently only one symbol type and the ability to label wells is limited. Don't call KGS and ask for help on how to change these; the answer is buy GIS software.
- The Kentucky Geological Survey, Publication Sales office can create an Oil and Gas Overlay Map on a 1:24,000-scale USGS topographic map using the National Geographic software program TOPO! for $25. Other custom oil and gas maps can be created; please call the Publication Information Center for pricing. Please allow a day or longer to print these maps out.
NB: Not all of the electric logs available in the oil and gas well records file have been scanned. To indicate that electrical logs are available, a standard, "DEMO," image has been added to the record DjVu folder. To schedule a log for scanning, paper copies of logs, or CD-ROMs of well record data, contact KGS Publication Information Center. A link has been provided for requesting logs to be scanned. Please respect the needs of other users of the KGS records system and limit your requests to the fewest, most critical logs needed.
Search for oil and gas well record data