10-Jul-1998 KENTUCKY OIL AND GAS WELL LOCATION DATA Access is a registered trademark of the Microsoft Corporation, Redmond, Washington ESRI and ArcView are registered trademarks of Environmental Systems Research Institute, Inc., Redlands, California COPYRIGHT Data in this distribution are copyrighted (1998) by the University of Kentucky, Kentucky Geological Survey. The user of the data is granted the right to use these data to produce maps, charts, and reports. Further, the user may distribute the information in this data set under the following conditions: 1) The complete data set, including this "read me" file, must be distributed together. 2) No fee may be charged for the data. DISCLAIMER Data in this file are presented as is with no warranty either expressed or implied as to the completeness or accuracy of the location or well status. Data on file at the Kentucky Geological Survey is submitted by well operators under requirements established by KRS353. Production data by well is not publicly available. 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 Geologic Data Center of the Kentucky Geological Survey. Multiple entries into a single well bore may alter the status of a given well. In addition, well location data supplied by different operators at various times may result in disparate, multiple symbols for the same well location. DIGITAL WELL DATA RESOURCES AT THE KENTUCKY GEOLOGICAL SURVEY The database provided with this distribution is limited in its scope. These data were used to compile Map and Chart Series 9, Distribution of Oil and Gas Wells in Kentucky and are designed to accompany various base map resources available through the Kentucky Geological Survey world wide web site at: http:\\www.uky.edu\KGS\home.htm Additional details for each well are available in electronic form. The files WELLDATA.TXT and TOPS.TXT included in this distribution describe the content and format of the standard electronic data files. Further, subsets of the data may be specified. Well data may be selected based on counties, Carter coordinates, topographic quadrangle names, latitude and longitude bounded areas, depth of penetration, available records, and others. For example, a database of the wells in Leslie and Perry Counties that penetrate the Devonian Shale or deeper zones with litho-density logs may be created. Data can be written to diskette or sent by electronic mail. For larger databases, the information can be written to CD-ROM or posted to an anonymous ftp site for downloading. The cost for digital well record data that includes latitude and longitude and stratigraphic tops (on request) is $20 plus a per well charge of $0.15. Kentucky sales tax, postage, and handling will be charged as appropriate. MasterCard and VISA are accepted. SPACE REQUIREMENTS The data have been compressed and the distribution consists of two files: 1) AAREADME.1ST -- this file (approximately 5K) 2) KYOGWELL.EXE -- a compressed, self-extracting archive file of well data (approximately 1.2Mb) When decompressed, three additional files are created: 3) KYOGWELL.TXT -- Kentucky well database (approximately 3.8Mb). 4) WELLDATA.TXT -- Documentation for standard digital well record data distribution (approximately 52K). 5) TOPS.TXT -- Documentation for standard digital well stratigraphic ("tops") data distribution (approximately 8K). COMPUTER REQUIREMENTS The data are supplied in a comma delimited ASCII text file formatted to be compatible with personal computers running Microsoft DOS, Windows 3.x, Windows 95, or Windows NT. The data must be decompressed on a Windows based system. Contact Brandon Nuttall at the Kentucky Geological Survey for assistance if you need to decompress the data on an MS-DOS based system. Once decompressed, the data should be usable on Macintosh systems, but equipment and software are not available to verify this. SOFTWARE REQUIREMENTS This database is supplied as is with no software for display or manipulation of the data. To use the data, it must be imported into a database or GIS software package. Most software of these types have the ability to import comma and quote delimited ASCII text files (sometimes called CSV format). The Kentucky Geological Survey does not recommend or endorse any software. DATA FORMAT This distribution contains identification, location, and completion data for 109,214 wells in the Kentucky Oil and Gas Well Records database. The data is supplied as a comma delimited data file. The value fields for each record are delimited by commas. Text items are qualified by double quotes. To assist with data import, the first record of the data file contains data field names. Each record in the data base represents one well and contains four data fields: 1) RECORD_NUMBER - A unique well identification number supplied as a long integer data type. 2) LATITUDE - North latitude in decimal degrees calculated for NAD 1927 datum. 3) LONGITUDE - West longitude (negative) in decimal degrees calculated for NAD 1927 datum. 4) RESULT - The status of the well. See table for key to RESULT field values. To access the data file, copy the executable file (*.EXE) to your hard drive. On Windows-based systems, find it and double- click on the file name with the File Manager or Explorer. The KYOGWELL.TXT file and others as described will be extracted. KEY TO WELL RESULTS Data supplied in the RESULT field allows well types to be differentiated. The well types are: OIL - Oil producing wells OILAB - Wells originally completed as oil producers but have been abandoned GAS - Gas producing wells (including domestic gas wells) GASAB - Wells originally completed as gas producers but have been abandoned O&G - Combined oil and gas producing wells O&GAB - Wells originally completed with combined oil and gas production but have been abandoned D&A - Dry and abandoned wells (including temporary abandonments and illegally or improperly abandoned wells) SRI - Secondary (and tertiary or enhanced) recovery wells including water, steam, CO2 or other injection wells SRIAB - Wells originally completed as secondary recovery injection wells but have been abandoned GS - Gas storage (injection and extraction) wells (including cathodic protection) LOC - Well locations (includes locations for which a permit has been issued but for which no completion data is available and wells on computer with incomplete or missing completion data) STRP - Well locations permitted as stratigraphic tests for which information has been released to the public IMPORT EXAMPLE: MICROSOFT ACCESS DATABASE 1. Copy the data to your hard drive and decompress it. 2. Start Access 3. Create a new blank database 4. Begin the import dialog by clicking on File, Get External Data, Import 5. Set the file type to "Text Files (*.txt,*.csv,*.tab,*.asc)" 6. Navigate your directories to find the KYOGWELL.TXT file and double-click on the name to start the text import wizard 7. Set the file format to Delimited and click the Next button 8. Set the delimiter that separates the fields to a comma. Make sure the text qualifier is set to a the standard double quote (the default). Click (check) the box to indicate the first row of the data contains field names. Click the Next button. 9. Click to choose storing the data into a new table (the default). Click the Next button. 10. Change the options used to define the field RECORD_NUMBER by changing the value of Indexed from "No" to "Yes (No Duplicates)". The default values will be used for everything else. Click the Next button. 11. Click to choose your own primary key and choose RECORD_NUMBER. Click the Next button. 12. Click Finish to begin the import and create a database table called KYOGWELL. IMPORT EXAMPLE: ESRI ArcView GIS In ArcView, large data tables imported as text are not particularly efficient. To speed processing the information, it is suggested you access the database either directly using ODBC drivers or use database software to create a "DBase IV" format data file. 1. Copy the data to your hard drive and decompress it. 2. Start ArcView with a new, "Untitled" project. 3. In the project window, click Tables then Add. 4. Set the file type to "Delimited Text (*.txt)". 5. Navigate to the directory where KYOGWELL.TXT is stored and double-click the file name. 6. Create a view to display the data: in the project window, click on Views then New (or choose an existing view). 7. On the menu bar of the graphic user interface, click on View. 8. In the drop down menu, click on Add Event Theme. 9. Choose the KYOGWELL.TXT table. Set the X field to Longitude and the Y field to Latitude (the defaults). Click OK. If you have installed the ODBC drivers for your system, it may be more convenient for to use the SQL Connect feature of ArcView. If you have used SQL, you will realize the opportunities to change this procedure to customize the data returned by the query. Also, this feature may be used to gain access to other data that can be joined to tables available to ArcView. 1. Import the data to Access as previously described. 2. With the project window active, click on Project on the main menu bar. 3. Click on SQL Connect (if this option is "greyed out", you have not installed the ODBC drivers) 4. In the Connection dialog box, click on the drop down list arrow and select the "MS Access 7.0 Database" choice. 5. Click the "Connect" button and select the database you created when you imported the data to Access. 6. From the list of tables, choose the table you created that contains the XY location data by double-clicking on its name. The table name should appear in the "From" dialog box and a list of fields should appear in the "Columns" dialog box. 7. Double-click on the "" entry in the "Columns" dialog box. An asterisk ("*") should appear in the "Select" dialog box. 8. [Optional] Change the output table name from "Table1". 9. Click the "Query" button to make the table available to ArcView. The table and its contents should open in a standard ArcView-type window. You may close both the table and the SQL connect dialog box. MORE INFORMATION To place an order for more detailed well data, or for additional information on this distribution or data format, contact Brandon C. Nuttall (BNUTTALL@KGS.MM.UKY.EDU) Kentucky Geological Survey 228 Mining and Mineral Resources Building University of Kentucky Lexington, Kentucky 40506-0107 Phone: (606) 257-5500 Fax: (606) 257-1147 WWW: http://www.uky.edu/KGS/home.htm