Link to USGS Homepage
Energy Resources Program Organic Geochemistry Data Base
   
  Home
  Introduction
  Download Data
  Documentation
  Contact Us
  Links
   

 

Last Data Base Update:

June, 2007

 

Data Base Documentation

In the public release of the OGDB, an attempt to place reasonable accuracy in reporting all site location (latitude and longitude) was undertaken in the generation of pseudo coordinates for sample locations originally derived from proprietary information. In instances where the LOC column in the SAMPLES table is 1, the site location information is derived from cell maps designed by the USGS as a part of the resource assessment effort. In the assessment effort, each cell represents a quarter-mile square of the land surface and the cells are coded to represent whether the wells included within the cell are predominantly oil producing, gas producing, both oil and gas producing, or dry or unknown. Some well information was initially retrieved from the IHS Energy Group, PI/Dwights PLUS Well Data on CD-ROM, which is a proprietary, commercial Data Base containing information for most oil and gas wells in the United States. However, no proprietary data are displayed or included in the cell maps and the latitudes and longitudes of the center-cell points are published with permission (click here for a copy of this letter) and are used in this Data Base. The accuracy of the cells, as created by the Arc Macro Language (AML) program of Laura R.H. Biewick , Susan Weiler, and Christopher Skinner, depends upon the accuracy of the oil and gas well information in the 2001 version of the IHS Energy data. For the National Assessment of Oil and Gas Project, the assumption was made that the data were of sufficient accuracy for a national-scale analysis. The remaining instances where the LOC column in the SAMPLES table is not 1, site location information (latitude and longitude) is either unknown or is supplied by the sample submitter.

The OGDB is available in Microsoft Access 2000 and in tab delimited formats at the download page.

This documentation is divided into two parts. The first part describes the relationships between the tables in the data table hierarchy section. The second section is the table definitions.

Data Table Hierarchy

JOBS table --> SAMPLES table --><RESULTS> tables

A single record in the JOBS table is related to one or more sample in the SAMPLES table. There are several analytical <RESULTS> data tables; and more might be added in future releases.

JOBS are numbered by 2-digit calendar year of submission (1980 through 2079). There can as many as 999 JOBS in a calendar year; for example, Job 96041 is the 41st Job registered in 1996, Job 02003 is the 3rd Job registered in 2002. Note -- 1980 Job numbers are reserved for rescued data and data obtained from the literature.

There can be as many as 999 samples in a job, and a unique sample number is created by concatenating the Job number with a sequential number from 001 to 999; thus, 96041045 is the 45th Sample in the 41st Job of 1996.

Since JOB and SAMPLE numbers can start with zero, they are stored in the Data Base as Text strings. Caution must be exercised when exporting JOB or SAMPLE.

The Data Type shown for each Column Name is defined in Access 2000 as:
Text -- Any combination of text and numbers limited in length in the Data Type column with parentheses.
Integer -- Whole numbers between -32768 and +32767 (2 bytes)
Long Integer -- Whole numbers between -2,147,483,648 and +2,147,483,647 (4 bytes)
Byte -- Whole numbers between 0 and 255 (1 byte)
Single -- Single precision floating point (4 bytes)
Double -- Double precision floating point (8 bytes)
Date/Time -- January 1, 100 to December 31, 9999 (8 bytes)
Boolean -- Yes/No (2 bytes)
Memo -- Long Text

Table Definitions

Table Definitions are provided below. For convenience, you may want to use the following hyperlinks to navigate to a particular table

Provenience Tables

JOBS: Information applicable to batches of samples
SAMPLES: Sample by sample location information

Analytical Results Data Tables

BIOM: GC/MS of Biomarkers (Terpanes, Steranes & Aromatic Steroids)
CHROM: Saturated Hydrocarbon Gas Chromatographic Data
ELEM: Elemental Analyses (C,H,N,O,S,Metals)
FRACS: Liquid Chromatographic Fractions and API Gravities
ISOT: Stable Isotope Data
LIGHTHC: Light Hydrocarbons & Gasoline range Hydrocarbons
MACERALS: Maceral classification and Thermal Alteration Index (TAI)
NATGAS: Natural Gas Quantitative Analyses
RKEVAL: Rock-Eval Analyses
TEA_FID: ChromalyticsThermal Evolution Analyses
VITREF: Vitrinite Reflectance

JOBS table definition
Column Name Data Type Description
JOB Text(5) Unique JOB Number (2-digit Year and 3-digit Sequential Number)
SAMPLES Integer Number of Samples in the JOB (up to 999)
ORIGIN Text(255) General Sampling Locale
INFO Text(255) Additional JOB Information
REGDATE Date/Time Date of JOB Registry
[back to table definitions index]

SAMPLES table definition
Column Name Data Type Description
JOB Text(5) Unique JOB Number (2-digit Year and 3-digit Sequential Number)
SAMPLE Text(8) Unique SAMPLE Number (JOB Number and 3-digit Sequential Number)
LON Double USGS Longitude of Sampling Location
LAT Double USGS Latitude of Sampling Location
API Text(14) American Petroleum Institute (API) Number (US Wells Only)
COUNTRY Text(40) Country of Sampling Location
STATE Text(40) State or Province of Sampling Location
COUNTY Text(40) County of Sampling Location (US Only)
SECTR Text(10) Section, Township and Range of Sampling Location (US Only)
STYPE Text(120) Sample Type
SAMPID1 Text(40) Primary Sample Identification (or Well Name)
WELLN Text(16) Well "Number" (Well Samples Only)
FIELDN Text(20) Oil/Gas Field Name
SAMPID2 Text(150) Secondary Sample Identification
ELEV Single Elevation in METERS of Well or Spot Sampling Location
TOPDEPTH Single Top Depth Sampled in METERS (Wells)
BOTDEPTH Single Bottom Depth Sampled in METERS (Wells)
ELEVF Single Elevation in FEET of Well or Spot Sampling Location
TOPF Single Top Depth Sampled in FEET (Wells)
BOTF Single Bottom Depth Sampled in FEET (Wells)
FORMN Text(40) Formation Name
AGE Text(40) Formation Age (Local Nomenclature or GTS-89)
LITHPCT1 Byte Percent Lithology #1
LITHO1 Text(80) Lithology #1
LITHPCT2 Byte Percent Lithology #2
LITHO2 Text(20) Lithology #2
LITHPCT3 Byte Percent Lithology #3
LITHO3 Text(20) Lithology #3
USGSPROV Text(50) USGS World Assessment 2000 Geologic Province Name
LOC Byte Source of Longitude and Latitude Data [Byte] (1= Center of 1/4 Section Cell)
DATASOURCE Text(150) Source of Data or Laboratory
COMMENTS Memo Comments and Special Instructions
[back to table definitions index]

BIOM table definition *
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
GAMHOP_R Single RATIO Gammacerane / Hopane by Peak Height
G_GAC31R_R Single RATIO [GA/C31R] Gammacerane / C31 22R Hopane by Peak Height
G_OLHOP_R Single RATIO [OL/H] Oleanane / Hopane by Peak Height
G_BISHOP_R Single RATIO [C28/H] Bisnorhopane / Hopane by Peak Height
C27STER_F Single DECIMAL FRACTION C27 aaa 20R Sterane by Peak Height
C28STER_F Single DECIMAL FRACTION C28 aaa 20R Sterane by Peak Height
C29STER_F Single DECIMAL FRACTION C29 aaa 20R Sterane by Peak Height
C26TET_R Single RATIO (C26 S+R Tricyclic Terpanes) / C24 Tetracyclic Terpane by Peak Height
G_TETC23_R Single RATIO [Tet/C23] C24 Tetracyclic Terpane / C23 Tricyclic Terpane by Peak Height
G_C19C23_R Single RATIO [C19/C23] C19 Tricyclic Terpane / C23 Tricyclic Terpane by Peak Height
G_C24C23_R Single RATIO [C24/C23] C24 Tricyclic Terpane / C23 Tricyclic Terpane by Peak Height
G_C22C21_R Single RATIO [C22/C21] C22 Tricyclic Terpane / C21 Tricyclic Terpane by Peak Height
G_C26C25_R Single RATIO [C26/C25] C26 Tricyclic Terpane / C25 Tricyclic Terpane by Peak Area
G_C35C34_R Single RATIO [C35S/C34S] C35 22S Hopane / C34 22S Hopane by Peak Height
C35C34_F Single DECIMAL FRACTION (C35 22S + 22R Hopanes) / (C31-C35 22S + 22R Hopanes) by Peak Height
G_NEONOR_R Single RATIO [C29D/29H] C29 18a Neonorhopane / C29 Norhopane by Peak Height
G_NORHOP_R Single RATIO [C29/H] C29 Norhopane / Hopane by Peak Height
G_C31RH_R Single RATIO [C31R/H] C31 22R Homohopane / Hopane by Peak Height
STERPENT_F Single DECIMAL FRACTION (All Steranes) / (All Steranes + All Pentacyclic Terpanes) by Peak Area
STER_F Single DECIMAL FRACTION (All Steranes) / (All Steranes + All Terpanes) by Peak Area
PENT_F Single DECIMAL FRACTION (All Pentacyclic Terpanes) / (All Steranes + All Terpanes) by Peak Area
TRICY_F Single DECIMAL FRACTION (All Tricyclic Terpanes) / (All Steranes + All Terpanes) by Peak Area
G_XH_R Single RATIO [X/H] C30 Diahopane / Hopane by Peak Height
G_S1S6_R Single RATIO [S1/S6] C27 Ba 20S Diasterane / C27 aaa 20R Sterane by Peak Height
DIAREG_R Single RATIO C27 Ba 20S Diasterane / C29 aaa 20R Sterane by Peak Height
PREGC27_R Single RATIO Pregnane / C27 aaa 20R Sterane by Peak Height
G_TSTM_R Single RATIO [C27 Ts/Tm] C27 18a Trisnorhopane / C27 17a Trisnorhopane by Peak Height
TRIHOP_R Single RATIO C23 Tricyclic Terpane / Hopane by Peak Height
TRIOCR_F Single DECIMAL FRACTION (C20 + C21 Triaromatic) / (C20 + C21 + Identified C26-C28 Triaromatic) Steroids by Peak Area
TRIOCR1_F Single DECIMAL FRACTION (C20 Triaromatic) / (C20 + C28 20S + C28 20R Triaromatic) Steroids by Peak Area
TRIOCR2_R Single RATIO (C20 + C21 Triaromatic) / (Identified C26-C28 Triaromatic) Steroids by Peak Area
TTM_F Single DECIMAL FRACTION MacKenzie (Triaromatic) / (Triaromatic + Monoaromatic) Steroids by Peak Height
TRIMONO_F Single DECIMAL FRACTION (C20-C28 ID'd Tri) / (C20-C28 ID'd Tri + C21-C29 ID'd Mono) Aromatic Steroids by Peak Height
MORHOP_R Single RATIO (Normoretane + Moretane) / (Norhopane + Hopane) by Peak Height
C31HSR_F Single DECIMAL FRACTION (C31 22S Hopane) / (C31 22S + 22R Hopane) by Peak Height
C32HSR_F Single DECIMAL FRACTION (C32 22S Hopane) / (C32 22S + 22R Hopane) by Peak Height
C29SR_F Single DECIMAL FRACTION (C29 aaa 20S Sterane) / (C29 aaa 20S + 20R Sterane) by Peak Height
C29BBAA_F Single DECIMAL FRACTION (C29 aBB 20R Sterane) / (C29 aBB 20R Sterane + aaa 20R Sterane) by Peak Height

Note: All descriptions containing a bracket and column names preceded with a "G_" are defined ratios that are identical to ratios calculated by GeoMark Research, Inc. of Houston, TX
[back to table definitions index]

CHROM table definition
Column Name Data Type Description
SAMPLE Text(8) nique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
PRPH_A Single GC-FID Pristane/Phytane Ratio by Peak AREA
PRPH_H Single GC-FID Pristane/Phytane Ratio by Peak HEIGHT
PR17_A Single GC-FID Pristane/n-C17 Ratio by Peak AREA
PR17_H Single GC-FID Pristane/n-C17 Ratio by Peak HEIGHT
PH18_A Single GC-FID Phytane/n-C18 Ratio by Peak AREA
PH18_H Single GC-FID Phytane/n-C18 Ratio by Peak HEIGHT
CPI01_A Single GC-FID Carbon Preference Index n-C23 to n-C33 by Peak AREA
CPI01_H Single GC-FID Carbon Preference Index n-C23 to n-C33 by Peak HEIGHT
CPI02_A Single GC-FID Carbon Preference Index n-C24 to n-C34 by Peak AREA
CPI02_H Single GC-FID Carbon Preference Index n-C24 to n-C34 by Peak HEIGHT
CPI03_A Single GC-FID Carbon Preference Index n-C24 to n-C32 by Peak AREA
CPI03_H Single GC-FID Carbon Preference Index n-C24 to n-C32 by Peak HEIGHT
CPI04_A Single GC-FID Carbon Preference Index n-C24 to n-C30 by Peak AREA
CPI04_H Single GC-FID Carbon Preference Index n-C24 to n-C30 by Peak HEIGHT
OEP01_A Single GC-FID Odd-Even Predominance at n-C25 by Peak AREA
OEP01_H Single GC-FID Odd-Even Predominance at n-C25 by Peak HEIGHT
OEP02_A Single GC-FID Odd-Even Predominance at n-C27 by Peak AREA
OEP02_H Single GC-FID Odd-Even Predominance at n-C27 by Peak HEIGHT
OEP03_A Single GC-FID Odd-Even Predominance at n-C29 by Peak AREA
OEP03_H Single GC-FID Odd-Even Predominance at n-C29 by Peak HEIGHT
[back to table definitions index]

ELEM table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
WPCT_N Single Weight % Nitrogen
WPCT_C Single Weight % Carbon
WPCT_H Single Weight % Hydrogen
WPCT_S Single Weight % Sulfur
WPCT_O Single Weight % Oxygen
WPCT_ASH Single Weight % Ash
TOT_FE Single Weight % Total Iron
HC Single Atomic Hydrogen/Carbon Ratio
OC Single Atomic Oxygen/Carbon Ratio
TOC Single Weight % Total Organic Carbon
TC Single Weight % Total Carbon
V Single ppm Vanadium (wt/wt of sample)
NI Single ppm Nickel (wt/wt of sample)
[back to table definitions index]

FRACS table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
EOM Single Parts per Million Extractable Organic Matter (EOM)
SARATIO Single Saturate/Aromatic Hydrocarbon Ratio
PCTREC Single Percent Recovery from Column Chromatography
PCTVOL Single Percent Volatiles (Oils only)
CTYPE Text(1) Column Type (A=Alumina/Silica, B=Baker, T=TLC, S=Silica)
EXTECH Text(1) Extraction Technique (S=Soxhlet, U=Ultrasonic, R=Roller, B=Blender, K=Shaker/Soak, M=Soxtherm)
EXSOL Text(1) Extraction Solvent (C=CHCl3, M=CH2Cl2, B=Bz/MeOH, O=Methanol, E=Ethyl Acetate, I=i-C8, etc.)
RKWT Single Rock Weight (Extractor Charge)
MGBIT Single milligrams of Bitumen Extracted
MGCOL Single milligrams of Bitumen used for Chromotography
MGSAT Single milligrams of Saturates Recovered (from MGCOL)
MGAROM Single milligrams of Aromatics Recovered (from MGCOL)
MGNSO Single milligrams of Resins (NSOs) Recovered (from MGCOL)
MGASPH Single milligrams of Asphaltenes Recovered (from MGCOL)
MGOTHER Single milligrams of Unknown Composition Recovered (from MGCOL)
GRAV Single API Gravity (Density)
[back to table definitions index]

ISOT table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
C13 Single d13C Carbon Isotope Ratio
O18 Single d18O Oxygen Isotope Ratio
HD Single H/D Hydrogen/Deuterium Isotope Ratio
S34 Single d34S Sulfur Isotope Ratio
N15 Single d15N Nitrogen Isotope Ratio
[back to table definitions index]

LIGHTHC table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
METHPPM Single ppm (volume/volume of sample) Methane
ETHPPM Single ppm (volume/volume of sample) Ethane
PROPPPM Single ppm (volume/volume of sample) Propane
IBUTPPM Single ppm (volume/volume of sample) i-Butane
NBUTPPM Single ppm (volume/volume of sample) n-Butane
TOTC5_C7 Single ppm (volume/volume of sample) C5 to C7 compounds
AIRSP_ML Single Milliliters of air in the can
AIR_H2O_ML Single Milliliters of water in the can
VOL_CTGS_ML Single Milliliters of cuttings rock in the can
I_C4 Single ppm (volume/volume of sample) i-Butane
N_C4 Single ppm (volume/volume of sample) n-Butane
NEO_C5 Single ppm (volume/volume of sample) neo-Pentane or 2,2-Dimethyl Propane
I_C5 Single ppm (volume/volume of sample) i-Pentane
N_C5 Single ppm (volume/volume of sample) n-Pentane
NEO_C6 Single ppm (volume/volume of sample) neo-hexane or 2,2 Dimethyl Butane
C5_CYC Single ppm (volume/volume of sample) Cyclopentane
C4_23DM Single ppm (volume/volume of sample) 2,3-Dimethyl Butane
C5_2M Single ppm volume/volume of sample) 2-Methyl Pentane
C5_3M Single ppm (volume/volume of sample) 3-Methyl Pentane
N_C6 Single ppm (volume/volume of sample) n-Hexane
C5_MC Single ppm (volume/volume of sample) Methyl Cyclopentane
C5_22DM Single ppm (volume/volume of sample) 2,2-Dimethyl Pentane
BENZENE Single ppm (volume/volume of sample) Benzene
C5_24DM Single ppm (volume/volume of sample) 2,4-Dimethyl Pentane
C4_223TM Single ppm (volume/volume of sample) 2,2,3-Trimethyl Butane
C6_CYC Single ppm (volume/volume of sample) Cyclohexane
C5_33DM Single ppm (volume/volume of sample) 3,3-Dimethyl Pentane
C5_11DMCY Single ppm (volume/volume of sample) 1,1-Dimethyl Cyclopentane
C6_2M Single ppm (volume/volume of sample) 2-Methyl Hexane
C5_23DM Single ppm (volume/volume of sample) 2,3-Dimethyl Pentane
C5_C13DMCYC Single ppm (volume/volume of sample) cis-1,3-Dimethyl Cyclopentane
C6_3M Single ppm (volume/volume of sample) 3-Methyl Hexane
C5_T13DMCYC Single ppm (volume/volume of sample) trans-1,3-Dimethyl Cyclopentane
C5_T12DMCYC Single ppm (volume/volume of sample) trans-1,2-Dimethyl Cyclopentane
C5_CT12DMCYC Single ppm (volume/volume of sample) cis-1,2-Dimethyl Cyclopentane + trans-1,2-Dimethyl Cyclopentane
C5_3E Single ppm (volume/volume of sample) 3-Ethyl Pentane
C5_224TM Single ppm (volume/volume of sample) 2,2,4-Trimethyl Pentane
N_C7 Single ppm (volume/volume of sample) n-Heptane
C5_C12DMCYC Single ppm (volume/volume of sample) cis-1,2-Dimethyl Cyclopentane
C6_MCYC Single ppm (volume/volume of sample) methyl Cyclohexane
C5_113TMCYC Single ppm (volume/volume of sample) 1,1,3-Trimethyl Cyclopentane
C6_22DM Single ppm (volume/volume of sample) 2,2-Dimethyl Hexane
C5_ECYC Single ppm (volume/volume of sample) Ethyl Cyclopentane
TOLUENE Single ppm (volume/volume of sample) Toluene
C4_C8PPM Single ppm (volume/volume of sample) C4 to C8 undifferentiated Hydrocarbons
[back to table definitions index]

MACERALS table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
AMORP Byte Percent Amorphous component
HERBA Byte Percent Herbaceous component
WOODY Byte Percent Woody component
INERT Byte Percent Inert component
TAI Single Thermal Alteration Index
[back to table definitions index]

NATGAS table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
AIR Single mol% Air
N2 Single mol% Nitrogen
O2AR Single mol% Oxygen + Argon (Unresolved)
O2 Single mol% Oxygen
AR Single mol% Argon
CO2 Single mol% Carbon Dioxide
CO Single mol% Carbon Monoxide
H2S Single mol% Hydrogen Sulfide
HYDROGEN Single mol% Hydrogen
HELIUM Single mol% Helium
METHANE Single mol% Methane
ETHANE Single mol% Ethane
C2ENE Single mol% Ethylene
PROPANE Single mol% Propane
C3ENE Single mol% Propene (Propylene)
NBUTANE Single mol% n-Butane
IBUTANE Single mol% iso-Butane
C4ENE Single mol% 1-Butene
T2C4ENE Single mol% trans-2-Butene
C2C4ENE Single mol% cis-2-Butene
IC4ENE Single mol% iso-Butene
NPENTANE Single mol% n-Pentane
IPENTANE Single mol% iso-Pentane
NEOC5 Single mol% neo-Pentane
CYC5 Single mol% Cyclopentane
UDIFC5 Single mol% Undifferentiated Pentanes
NHEXANE Single mol% n-Hexane
CYC6 Single mol% Cyclohexane
UDIFC6 Single mol% Undifferentiated Hexanes
NHEPTANE Single mol% n-Heptane
UDIFC7 Single mol% Undifferentiated Heptanes
BENZENE Single mol% Benzene
[back to table definitions index]

RKEVAL table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
SAMPWT Single Sample mass, milligrams
TMAX Single Tmax of S2 peak (°C)
S1 Single Volatile hydrocarbons (S1, milligrams hydrocarbons/gram rock)
S2 Single Pyrolyzable hydrocarbons (S2, milligrams hydrocarbons/gram rock)
S3 Single released CO2, milligrams hydrocarbons/gram rock
PI Single Production Index (Transformation Ratio S1/S1 + S2)
S2S3 Single Ratio of pyrolyzable hydrocarbons to CO2
PC Single Percent Total Pyrolyzable Carbon in the rock
TOC Single Percent Total Organic Carbon in the rock
HI Single Hydrogen Index (Proportional to atomic H/C Ratio: S2/TOC)
OI Single Oxygen Index (Proportional to atomic O/C Ratio: S3/TOC)
[back to table definitions index]

TEA_FID table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
THC_YIELD Single WT% Total Hydrocarbon Yield
S1 Single ppm (weight/weight of sample) Volatiles S1 peak
TMAX Long Integer Max Temperature of Hydrocarbon Yield
S2 Single ppm (weight/weight of sample) S2 peak
[back to table definitions index]

VITREF table definition
Column Name Data Type Description
SAMPLE Text(8) Unique Internal Sample Number YYJJJSSS [Foreign Key Text(8)] 00001001 to 99999999
ANALYSIS Text(60) Analysis Performed
COMPDATE Date/Time Analysis Completion Date [Date/Time] 1/1/100 to 12/31/9999
REF Text(40) Reference (Link) to Raw Data
COM Text(40) Analyst's Comments
INST Text(40) Instrument or instrumental method or Lab
ABPYR Text(8) Pyrite
RMEAN Single Mean Reflectance Value
RMODE Single Modal Reflectance Value
ROS Memo Tab Delimited Individual Reflectance Values
[back to table definitions index]

 

U.S. Department of the Interior || U.S. Geological Survey
URL: http://energy.cr.usgs.gov /prov/og/doc.htm
Maintained by: Central Energy Team Data Management
Last modified:  14:54:10 Mon 25 Jun 2007
Privacy Statement || Disclaimer || FOIA || Accessibility
Link to FirstGov.gov home page