|
Last Data Base Update:
June, 2007
|
|
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 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
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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]
| 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] |
