API_Master.txt, 29-Sep-2006

ASCII text file of correspondences between well identification numbering systems used in Kentucky. This file keys the Kentucky Geological Survey record number to several numbering systems used for identifying wells including API numbers. The file is a comma delimited, ASCII text file. The first row of the file are column headings.

The data file should be imported into a database system like Access or some other. Import into spreadsheet programs like Excel will import only the first 65535 rows.

Contact:

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

	Phone: 859-257-5500 x 174
	Email: bnuttall@uky.edu

Several well numbering systems are in use in Kentucky to identify unique wells.

1) Record number -- A unique serial record number assigned at time of data entry.
                    All entries in the oil and gas well record database have a
                    record number.
                    (Long integer)

2) permit        -- A formatted version of the permit issued by the Kentucky
                    Division of Oil and Gas. Formatting includes removal of 
                    imbedded dashes and spaces and right justification in a field
                    7 characters long (facilitates correct sorting sequence of
                    numeric permits). Not all wells in the data base have permits.
                    (Text, fixed length, 7 characters, blank where missing)

3) DOGpermit     -- The permit as recorded in the Kentucky Division of Oil
                    and Gas database. May contain imbedded dashes or spaces. Any
                    leading or trailing spaces have been removed.
                    (Text, variable length, up to 10 characters, blank where missing)

4) APINumber     -- This is the new API number assigned to wells in the Kentucky
                    Division of Oil and Gas database. Note this version of the 
                    API number contains 4 extra digits, always 0: the 2-digit
                    redrill/sidetrack code and an extra 2-digits required by the
                    RDBMS data system implemented by the Division.
                    (Text, 14 characters, blank where missing)

5) OLDKYAPI      -- This is the pseudo-API number generated as needed for
                    data distribution requirement of several multi-state projects.
                    The code is the 2-digit state code ("16") and the FIPS 
                    (Federal Information Processing System) county code. The last
                    5 digits are the permit, but only if that permit was numeric.
                    The OLDKY_API for most non-numeric permits are set to a value of
                    "N/A". Some older and deeper wells were assigned a serial number
                    (statewide) to comply with API number identification 
                    requirements.
                    (Text, 10 characters, "N/A" where missing)

Not all Kentucky wells have permits; statewide permitting didn't begin until 1960. In some cases, the same permit may have been assigned to multiple wells or multiple entries into the same well; this is most likely to occur in wells drilled between 1950 and 1969. Both the API and OLDKY_API numbers do not uniquely identify a hole in the ground (the rentry/sidetrack code is unused and is always 0). The county code may differ between the API and OLDKY_API numbers; in general, this applies to wells that lack sufficient location data to assign the well to a unique x/y (latitude and longitude) location.

Use these data at your own risk. If you want to be sure your data is correctly tied to the Kentucky Oil and Gas Well Record database, use the Kentucky record number.