About the Data Sets

This page gives the reader detailed information about the data sets loaded in the NGDRS system. They were prepared to help the user understand what the columns (schema) for each of the tables represent. The schemas for each table will show the column heading as it appears in the table, and a longer description of the content of each column, possible values or examples, and any general remarks.

The following are the current data providers for the NGDRS and the data types contained in their data sets.

Organization or Company	Data Set	Status
Alabama Geological Survey	Well Information	Loaded
Bureau of Economic Geology	Well log headers	Loaded
Bureau of Economic Geology	Cores and Cuttings	Loaded
Kansas Geological Survey	To be defined	To be loaded
Mineral Management Service, GOM	Well/wellbore and Company information	Loaded
Mineral Management Service, GOM	Cultural data: areas and blocks	Loaded
Oklahoma Geological Survey	Cores	Loaded
US Geological Survey	Cores and Cuttings	Loaded
Unocal Onshore	Cores and Cuttings	Loaded

Oklahoma Geological Survey (OGS), Cores

Type of data: Cores
Coverage: Oklahoma
Size in rows (or records): ~ 4,600 core samples.
Refreshed: Quarterly
Data model: Proprietary
Remarks: Well lat/long coordinates were derived from legal description (Township/Range/Section). The conversion from T/R/S to Lat/Long was obtained from a service provided in the web by the University of Oklahoma - GEO Information Systems Spatial Calculator.
No. of implementation tables: One.

Element Name	Description/Remarks
operator	Well operator (company)
section	Sections. Part of the U.S. Rectangular survey system. There are 36 sections in one Township. One township is approximately six square miles.
twp	Township: degrees. Townships are numbered with baselines and principal meridians.
twpa	Township: orientation = North or South
rng	Range: degrees. Ranges are the distances and directions from baselines and meridians expressed in numbers of townships.
rnga	Range: orientation = East or West
wellno	Well number. Exs: 1, 1-34
wellname	Well name: Ex: Kudlac..
qqq	Sections are divided in quarter sections. Quarter sections are divided into 40-acre, quarter-quarter sections. Quarter-quarter sections are sometimes divided into 10-acre areas.
county	Oklahoma county
filelet	Ex: A, B, C, D….
condition	Sample type: C = Core chips, S = Core is slabed, SWC = Sidewall cores, W = whole core
represent	Representation of the core: P = poorly represented, more than 50% missing
diameter	Diameter of the core (inches)
top	Depth interval for core: top
bottom	Depth interval for core: bottom
corenum	Core number
numberbox	Number of boxes
formation	Stratigraphic unit
feetcore	Total feet cored
feetbox	Average feet per box
date	Date donated = YYMM
donor	Donor company
remarks	General remarks about type and condition of core
filenumb	Oklahoma Geological Survey file number

Bureau of Economic Geology, Well Log Headers

Type of data: Well logs.
Coverage: Texas.
Size in rows (or records): ~75,000 well log headers
Refreshed: Quarterly
Data model: Proprietary
Remarks: All the well logs for one county are projected at the center of the county. For the moment, the original data set does not have the correct latitude/longitude coordinates. The BEG is looking into options to add the necessary lat/long information. Well log types available are displayed in traditional codes. A table with most of the codes is provided at this site.
No. of implementation tables: Two

Well Archive Table
Well Log Archive Table.

Well Archive Table:

Element Name	Description/Remarks
seq_num	BEG system sequential number
county	Texas county
operator	Operator
lease	Lease
fldname	Field Name
apinum	API Number
longitude	longitude
latitude	Latitude
tractl	Tract
tract2
tract3
drill_angle	Drill Angle and Elevation
drill_date	Drilled date
log_tot
rrc_district	Texas Railroad Commission District code

Well Log Archive:

Element Name	Description/Remarks
log_types	List (code) of available well logs: ca= caliper son=sonic iel=induction electric, etc. Refer to table of codes in this website.
log_no	Ex: 61, 62
top_log	Top depth (feet)
bot_log	Bottom depth (feet)
no_runs	Number of runs
log_date	Log date
batch_date	Batch date
top_avail
bot_avail
no_fiche	Number of fiche cards
log_scale	Log scale in inches
log_category	Ex: NFD-L
de	Data entry person - code
comml	Ex: This is a DUP-L
comm2
comm3
log_source	Examples: Texas Railroad Commission
log_donor	Examples: Texas Railroad Commission
ckout	Ex: checked-out flag (Y/N)
borrower
location
seq_num	BEG system sequential number. Ex: M05424
log_rcvd	Date logs were received
entry_date	Date logs were cataloged

Bureau of Economic Geology, Core/Cuttings

Type of data: Cores and cuttings.
Coverage: Texas.
Size in rows (or records): ~70,000 samples
Refreshed: Quarterly
Data model: Proprietary
Remarks: All the core/cutting for one county are projected at the center of the county. At the moment the original data set does not have the correct latitude/longitude coordinates. The BEG is looking into options to add the lat/long information to this data set.
No. of implementation tables: Two.

Well Information Table
Box Information Table.

Well Information Table:

Element Name	Description/Remarks
cnum	BEG system sequential number
county	Texas county name
operator	Ex: Murphy Oil Co., Exxon,…
lease	Lease name/number: Miller1, Goetz7,…
donor_company	Company donating the core: Sinclair, Mobil, Shell Oil Co.,
top_depth	Top depth (feet)
bot_depth	Bottom depth in feet
total_arch_boxes
box_type_code
sample_type	Descriptive name. Ex: cuttings, vials, whole core, chips, slab section,…
project	Flag
administrator	BEG principal investigator for project below
formation	Ex: Buda, Edwards, Austin Chalk, …
temp_well_locaticn	Temporary physical location of well in CRC warehouse.
perm_well_location	Permanent physical location of archive half of well in CRC warehouse.
sample_half_location	Permanent physical location of sample half of well in CRC warehouse.
well_process_commentl	Internal comments for warehouse & support personnel about wells.
well_process_comment2	Same as above
pi_number	PI/Dwight company number
latitude	Latitude = center of county
longitude	Longitude = center of county
api_number	API Number
field_number
formation_age	Ex: Upper Cretaceous, Recent, …
lithology	Descriptive name lithology Ex: chalk, tuff, claystone, sandy clay,…
tract_locl	List elevations (?). Example = 474.5’
tract_loc2
drill_angle_elev	Examples: Vertical, 45 degrees
total_samp_boxes
date_well_recvd	Date well entered into CRC database; For wells received prior to 1989, the date is shown as 01/01/1901
temp_loc_date	Date of temporary physical location of well in CRC warehouse.
date_samp_sorted	Date sample half of well was processed.
slab_date	Date well was slabbed.
rebox_date	Date well was reboxed.
date_well_labelled	Date barcode labels were placed on boxes.
perm_loc_date	Date archive half of well is placed in permanent position on shelf
sample_half_loc_date	Date sample half of well is placed in permanent position on shelf.
date_well_drilled
well_status	Internal tracking device showing activity of well.
old_cnum	When a well is renumbered, this shows the old accession number.
last_temp	(possibly) a temporary location marker.

Box Information:

Element Name	Description/Remarks
cnum	BEG system sequential number
box_num	Sequential number for the boxes in a ‘cnum’.
box_half
box _top_depth
box _bot_depth
box_status
reserved
borrow_id
box_location
box_loc_date
box_comment
core_comment

Mineral Management Service, MMS GOM, Well, Wellbore and Company Data

This MMS data set was obtained by downloading the existing data sets from the MMS web site.
Type of data: Well, wellbore and company information.
Coverage: Gulf of Mexico
Approximate Size in rows (or records): ~35,000 wellbores, ~ 2,500 companies.
Refreshed: Monthly
Data model: Proprietary
Remarks: None.
No. of implementation tables: Two.

Wellbore Information
List of All Companies

Wellbore Information:

Element Name	Description/Remarks
Api_Well_Number	A unique well identification number consisting of (left to right) a two digit state code (or pseudo for offshore), a three digit county code (or pseudo for offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A.
Spud_Date_Approval	The date the Application for permit (YYMMDD) to Drill is approved by the MMS Field Operations.
Field_Name	Name of field in which the well is located.
Kelly_Bushing_Elevation	The distance, in feet, from the rig's kelly bushing to the mean sea level.
Total_Measured_Depth	The actual distance measured along the axis of the borehole from the rig kelly bushing to the maximum depth of penetration of the well.
True_Vertical_Depth	The vertical distance, in feet, from the rig kelly bushing to the maximum depth of the well.
Total_Depth_Date	The date drilling on a well reached (YYMMDD) the total depth.
Status	Indicates the conditions relating to a borehole. Values are: APD = Application For Permit To Drill, COM = Borehole Completed, CT = Core Test Well, DRL = Drilling Active, DSI = Drilling Suspended, PA = Permanently Abandoned, ST = Borehole Side Tracked, TA = Temporarily Abandoned, VCW = Volume Chamber Well
Water_Depth	The depth of water at a well/platform location from the water level to the mud line.
Surface_Longitude	The surface longitude value of a location in the borehole. A positive denotes east.
Surface_Latitude	The surface latitude value of a location in the borehole. A positive value denotes north.
Bottom_Longitude	The longitude value of a location in the bottom of the borehole. A positive denotes east.
Bottom_Latitude	The latitude value of a location in the bottom of the borehole. A positive value denotes north.

Company Information:

Element Name	Description/Remarks
Operator	The name of the operating company.
Steet_Address	The street address.
Suite_or_Box	The suite or box address.
City	The name of the city for the mailing address.
State	Name of state
Zip_Code	The Postal Service designator which delineates the state, county or parish, community, and possibly neighborhood for a residence or business entity.

Alabama Geological Survey, Well Information

The Alabama Geological Survey, well information data set was obtained from the following site: http://egrpttc.geo.ua.edu/pttc/reports/smacko1. The set is part of a report aimed at providing the information obtained from a geological study of the Mississippi Interior Salt Basin. The work focused on inventorying the data files and records of the major information repositories in the Northeastern Gulf of Mexico and making these inventories easily accessible in an electronic format. The study is part of the Advanced Geologic Basin Analysis Program promoted by the DOE..

Type of data: Well logs.
Coverage: Alabama, Mississippi Interior Salt Geological Basin.
Size in rows (or records):
Refreshed: Not defined
Data model: Proprietary
Remarks: Well log types available are displayed in traditional mnemonics.
No. of implementation tables: One.

Element Name	Description/Remarks
Permit No	Well permit number of the Alabama State Oil and Gas Board (ASOGB)
API_Number	API assigned code number
Well Name	Well Name
Field	Name of the oil or gas field
County	County Name
Section	component of local coordinate scheme
Township	component of local coordinate scheme
Range	component of local coordinate scheme
Dist1	distance 1 (N-S)
Dist2	distance 2 (E-W)
Latitude	Coordinate location of well.
Longitude	Coordinate location of well.
Derived Lat/Long	Approximate coordinate; value were derived from either: Nearby wells. Field shows the Permit No. of the well used for approximation or Interpolated value from closest Township or Range.
Well Logs	List (code) of available well logs: ca= caliper, son=sonic, iel=induction electric, etc. Refer to table of codes in this website.
Mudlog	TRUE if mudlog analysis/cuttings for well on file with ASOGB.
Cores	TRUE if core samples from well filed with ASOGB.
Cuttings	TRUE if washed cuttings from well filed with ASOGB.
Core_analysys	TRUE if core analysis for well on file with ASOGB.
Production_data	TRUE if production data for well on file with ASOGB.
Well Status	Coded status of the well (for example, plugged and abandoned = P&A)
Core_Fnumb	ASOGB core collection number
Core Type	Values are: ch=chips, pl=plugs, pt=parts of whole core, sl=slabs, sw=sidewalls, wh=whole, fwc=filed with cuttings
Core Analysis	CA = Core analysis performed ?
Core Quantity	In number of boxes
Cores1	Cored Intervals (and diameter ?)
Cores2	Other core information
Sample_Fnumb	???
Sample_Type	???
Sample_Analysis	???
Pool	Name of the formation or oil reservoir

Unocal Onshore Cores and Cuttings

The Unocal Onshore Cores and Cuttings data represents the well locations and cores and cuttings holdings that are publically accessible from Unocal collection. The cores and cuttings in this collection are stored at C&M Storage in Shulenberg, TX. Access to those cores is arranged through C&M Storage.

Type of data: Cores and Cuttings
Coverage: Alabama, Arizona, Colorado, Idaho, Illinois, Kansas, Louisiana, Michigan, Mississippi, Montana, Nebraska, New Mexico, North Dakota, Oklahoma, Texas, Utah, Washington, Wyoming
Size in rows (or records): 1201
Refreshed: Not defined
Data model: Proprietary
No. of implementation tables: One.

Element Name	Description/Remarks
id	Unique record ID
api	API assigned code number
County	County Name.
well_name	Well Name
Operator	Well Operator
Field	Name of the oil or gas field
Section	component of local coordinate scheme
Township	component of local coordinate scheme
Range	component of local coordinate scheme
Top	Top in feet of the core section
Bottom	Bottom in feet of the core section
Latitude	Coordinate location of well.
Longitude	Coordinate location of well.
Core Type	Values are: ch=chips, pl=plugs, pt=parts of whole core, sl=slabs, sw=sidewalls, wh=whole, fwc=filed with cuttings
Formation	Stratigraphic Formation
Ref_No	Reference Number
Box_ID	Box ID Number
Whse_Loc	Box location at C&M
Storage_Facility	Location of sample - should be C&M Storage
Comments	Data comments


			NGDRS Overview
			Technical Facts
		Access the NGDRS
		AGI Home