**Organic Geochemistry Data of Alaska**

**Data Base Structure Documentation**

**11/1/99**

By Charles N. Threlkeld and J. David King

U. S. Geological Survey

Office of Energy and Marine Geology

Branch of Petroleum Geology

Box 25046 MS 977 DFC

Denver, Colorado 80225

Any use of trade, product or firm names in this publication is for
descriptive purposes only and does not imply endorsement by the U. S.
Government.

**CONTENTS**

Abstract **3**

Introduction **4**

Relational Data Base Tables, Structures and Definitions **6**

Data Table Structures and Definitions **8**

Encoding Schemes **31**

Appendix A - Definitions of Some Commonly Used Terms **40**

Appendix B - Manufacturers of Products and Services Mentioned **41**

**Abstract**

The U. S. Geological Survey Energy Resources Team's Organic Geochemistry
Laboratory is a research laboratory devoted to the inves­tigation of the
origin and occurrence of organic fossil fuels. Al­though it is not a
service laboratory, many of the analytical results from the laboratory
could prove useful in future petroleum geological and geochemical
studies. In order to archive these results, the USGS developed an
Alaskan Organic Geochemical Data Base (AOGDB) in 1978 to house the data
from not only the USGS' involvement in the project, but also the data
accumulated from a host of sub-contracting laboratories. The accumulated
data resided in a flat text file entitled "***PGS"*** and was maintained
by Petroleum Information Corporation. The information herein is a
breakout of tables from the master flat file to form the AOGDB in a
relational data base format. Additional information can be obtained in
*Geology and Exploration of the National Petroleum Reserve in Alaska,
1974-1982*, USGS Professional Paper 1399, pgs 478-481 and 545-549.

**Introduction**

The data base management software used throughout this circular is
MicroRim Corporation\'s RBase for DOS, a data base package designed for
use on IBM XT or AT or equivalent computers with MS-DOS or equivalent
disk operating systems. The AOGDB consists of RBase [TABLES]{.underline}
which have subsequently been converted to Microsoft Access tables. Each
[TABLE]{.underline} is organized into vertical columns and horizontal
rows of information. Each row repre­sents one sample; the columns within
each row represents specific information about the sample. There is only
one driving [TABLE]{.underline}:

[HEADER**\_**PGS]{.underline} Contains generic sample information

There can be any number of [DATA]{.underline} tables, one for each
analytical tech­nique that produces data in some numeric format. The USGS
AOGDB has 19 [DATA]{.underline} tables + one legend table that attempts
to correlate tabular information back to the original PGS notations.
Additionally, 5 other tables exist from which a number of attributes
were transferred to form portions of the [Header**\_**PGS]{.underline}
table. The tables below are the break-out product of the PGS flat file.

[HDSP**\_**13c**\_**40**\_**PGS]{.underline} Stable Carbon, Hydrogen,&
Sulfur Isotopes of Headspace gas

[WHLOIL**\_**13C**\_**65**\_**PGS]{.underline} Stable Carbon Isotopes of
Whole Oils

# SAT_ARO**\_**13C**\_**39**\_**PGS Stable Carbon Isotopes of Saturate and Aromatic Fractions

[COMMENTS**\_**PGS]{.underline} Sample/Analytical Comments

[ELEM**\_**36**\_**PGS]{.underline} Weight %Carbon, Nitrogen, Hydrogen
and Ash

[ELEM**\_**37**\_**PGS]{.underline} Weight % Oxygen, Sulfur, and Ash

[FRAC**\_**2930**\_**PGS]{.underline} % Saturates, Aromatics, and
Non-Hydrocarbon Fractions

[CANGAS**\_**8081**\_**PGS]{.underline} Standard Chemical Analyses of
Gas

[GASRNG**\_**23**\_**PGS]{.underline} C5--C8 Gasoline Range Components
by Gas Chromatography

[GC**\_**3162**\_**PGS]{.underline} C7--C35 Paraffin Range Components by
Gas Chromatography

[HEADER**\_**PGS]{.underline} Location, Lithology, Age, and Rock Unit
information

[ISOT**\_**38**\_**PGS]{.underline} 34S and 15N Stable isotopes of
Saturates and Ashpaltines

[Legend**\_**PGS]{.underline} Correlation to PGS analytical tables
(Contained Herein)

[MASTER**\_**PGS]{.underline} Every code in the datafile + the
[Comments**\_**pgs]{.underline} comments field

[RKEV**\_**41**\_**PGS]{.underline} Standard Rock-Eval data

[SPGR**\_**60**\_**PGS]{.underline} Specific Gravity of Oils

[TAI**\_**35**\_**PGS]{.underline} Thermal Alteration Index of Macerals

[TC**\_**TOC**\_**2728**\_**PGS]{.underline} Total Carbon and Total
Organic Carbon Values

[TEAFID**\_**26**\_**PGS]{.underline} %Volatiles, TMAX, and Hydrocarbon
Yield

[VISKER**\_**34**\_**PGS]{.underline} Standard Visual Kerogen Analysis

[VITREF**\_**33**\_**PGS]{.underline} Standard Vitrinite Analysis

Note that throughout this circular [UNDERLINED]{.underline} words are
actual table names and **BOLD** words are table elements (column
titles).

The [DATA]{.underline} tables are structured such that any number of
tables may be combined to form a large data base. The first 4 columns of
each [DATA]{.underline} table are identical in structure and provide a
\"key\" to the [HEADER]{.underline} and subsequent data tables. Please
note that the column entitled **RC\_\*** is not present in the
[Header**\_**PGS]{.underline} table but exists in all the Data tables.
The internal \"key\" for the AOGDB is the WMO number.

The WMO number is a concatenation of four basic fields: WSC UNIQ HCST
and SEQ. The following explains the formation of the WMO number:

**1 WSC** A text field formed by the World State County combined codes
of the WMO number. Samples collected within the USA (including Alaska,
Hawaii, and its Exclusive Economic Zones (EEZ)) are identified by the
world quadrant number of "9" then a two digit state code followed by a
three digit county code. In instances of samples received outside the
USA or the EEZ, the state and county codes become pseudo state and
county codes by substituting 2 digits of latitude for the state code and
three digits of longitude for the county code. The 6 digits in the WSC
are the first 6 digits in the WMO number

**2 UNIQ** The unique portion of an API well number. In the case of
outcrops, the Uniq value becomes a serial 5 digit number greater than
94999. The UNIQ portion of the WMO number is 5 digits beginning at the
7^th^ position of the WMO number.

**3 HCST** Side Track and Hole Change. The HCST field consists of 4
digits and begins at the 12^th^ position of the WMO number. It is
normally "0000".

**4 Seq** The last 4 digits of the WMO number. Provides for multiple
(9999) samples from one location. This portion begins at the 16^th^
position of the WMO number.

The WMO *global* \"key\" (in table [Header**\_**PGS]{.underline}) is
provided for use by other data bases via a unique American Petroleum
Institute (API) or World Meterological Organization (WMO) number which
is merely a modified form of the API number.

No provision has been made for archiving digitized *raw data*
(chro­matograms, pyrograms, etc.)and hence, this file contains no raw
data.

**Relational Data base tables, structures and definitions**

(Refer to *Encoding Schemes* for detailed element encoding)

Table [HEADER**\_**PGS]{.underline} contains information from sample
log-in. Sample location (in three dimensions: longitude, latitude,
elevation and depth); other location information; sample identification;
sample type(s); lithologies (4 ea); formation names and ages; well and
outcrop (surface) samples and any additional information, are all
addressed in the [HEADER**\_**PGS]{.underline} table as well as other
information that may be of use in data retreival for specialized
reports, charts and maps.

Table [HEADER**\_**PGS]{.underline} Column definitions

# HEADER**\_**PGS

Record Count: 30175

1 WMO Text 20

2 API Text 14

3 LABNO Text 8

4 DI_B001 Text 6

5 M1 Text 1

6 TOP Number (Double) 8

7 BOT Number (Double) 8

8 STY Text 2

9 OTHR Text 6

10 ADDNL Text 17

11 SAMPID Text 40

12 ELEV Text 10

13 TLD Text 7

14 WELCLAS Text 2

15 SRT Text 10

16 LAT Number (Double) 8

17 LONG Number (Double) 8

18 FAGE Text 4

19 FUNIT Text 4

20 LC_R020 Text 4

21 LITHO1 Text 20

22 P1 Text 4

23 LITHO2 Text 20

24 P2 Text 4

25 LITHO3 Text 20

26 P3 Text 4

27 LITHO4 Text 20

28 P4 Text 4

29 CONTAM1 Text 20

30 CP1 Text 4

31 CONTAM2 Text 20

32 CP2 Text 4

33 POR Text 1

34 SHO Text 1

35 SWT Text 4

Description of elements:

## 1 WMO Modified form of the api number. 

## 2 API Unique Well identifier. 

**3 LABNO** Prime Contractor's (USGS) Lab number.

**4 DI_B001** Date of Sample entered into system. A login date.

**5 M1** \"M\" for metric or \"F\" for english units (depths, etc.)

**6 TOP** Top depth of sampled interval (if from a well)

**7 BOT** Bottom depth of sampled interval (or blank if spot sample)

**8 STY** Sample source or type

**9 OTHR** Other sample information

**10 ADDNL** Additional comments, fieldnames, special ID's

**11 SAMPID** Sample identification: either a well number and name (if
from a well data base), or the submitter\'s field sample name (if an
outcrop \[surface\] sample.)

**12 ELEV** Elevation of well or outcrop (units as in **M1**)

**13 TLD** Total depth (if from a well)

**14 WELCLAS** Well Class

**15 SRT** For samples within the U.S., the Township direction (D),
Township number (NNN etc.), Range direction, Range number and section
number in the following format: DNNNDNNNNN

**16 LAT** Latitude, 5 decimals

**17 LONG** Longitude, 5 decimals

**18 FAGE** Formation age code

**19 FUNIT** Formation name code

**20 LC_R020** Lab Code Notation in PGS

**21 LITHO1** Gross lithology #1 (CODED)

**22 P1** percent of lithology #1

**23 LITHO2** Gross lithology #2 (CODED)

**24 P2** percent of lithology #2

**25 LITHO3** Gross lithology #3 (CODED)

**26 P3** percent of lithology #3

**27 LITHO4** Gross lithology #4 (CODED)

**28 P4** percent of lithology #4

**29 CONTAM1** Contaminant #1 (CODED)

**30 CP1** percent of contaminant #1

**31 CONTAM2** Contaminant #2 (CODED)

**32 CP2** percent of contaminant #2

**33 POR** Gross porosity code

**34 SHO** Gross SHOW code

**35 SWT** Sample Weight

The [HEADER**\_**PGS]{.underline} table contains one row per sample,
each row comprised of all 34 columns as defined above.

###### Data Table Structures and Definitions

The table [HDSP**\_**13C**\_**40_PGS]{.underline} contains data on the
Stable Carbon Isotopic signature of Headspace gas. The Number "40" in
the table links to the old PGS code of 040 for this analysis. The
leading 7 characters of the [HDSP**\_**13C**\_**40_PGS]{.underline}table
attempt to convey that this table consists of Stable Carbon isotopic
values on headspace (HDSP) gas.

The table exists with the following fields of information:

Table: [HDSP**\_**13C**\_**40_PGS]{.underline} No lock(s)

Read Password: No

Modify Password: No

Column definitions

\# Name Type Length Key Expression

1 WMO TEXT 20 characters

2 rc_r040 TEXT 7 characters

3 lc_r040 TEXT 4 characters

4 do_r040 TEXT 6 characters

5 c13_hdsp TEXT 8 characters

####### Current number of rows: 548

Description of the Attributes:

##  1 WMO Modified form of the api number. 

**2 RC_r040** The old PGS record code for this analysis. Note that the
lower casr "r" implies the original sample fraction received into the
lab was a rock sample. In this instance, even though a gas sample was
analyzed, it originated from the desorption of a canned core
(rock)sample.

**3 LC_r040** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_r040** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

**5 C13_HDSP** Parts per thousand delta from the international standard
PDB. *Note: Several isotope values were reported with out the*

*negative ("-") notation. These values were, in all likelyhood,
imporperly keypunched into the system. This observer feels that in fact,
no positive values exist in this data set. No attempt has been made here
to remedy this oversight.*

The Table [WHLOIL**\_**13C**\_**65**\_**PGS]{.underline} contains
information on the Stable Carbon Isotopes of Whole Oils. The last six
digits of the table name relate to the old PGS analytical code of 065
for this analysis.

The table exists with the following fields of information:

Table: [WHLOIL**\_**13C**\_**65**\_**PGS]{.underline} No lock(s)

Read Password: No

Column definitions

\# Name Type Length Key Expression

#######  1 WMO TEXT 20 characters 

2 rc_o065 TEXT 7 characters

3 lc_o065 TEXT 4 characters

4 do_o065 TEXT 6 characters

5 13cwhoil TEXT 8 characters

Current number of rows: 112

Description of the Attributes:

## 

1.  **WMO** Modified form of the api number.

2.  **RC_o065** The old PGS record code for this analysis. Note that the
    lower case "o" implies the original sample fraction received into
    the lab was an oil sample.

**3 LC_o065** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_o065** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

**5 13CWHLOIL** The delta stable Carbon isotopic value in parts per
thousand variance from that of the international standard: PDB.

The table [SAT**\_**ARO**\_**13C**\_**39**\_**PGS]{.underline} contains
information on the Stable Carbon Isotopes of the C15+ saturate and C15+
aromatic hydrocarbon fractions of oils and rock extracts. This table is
a combination or the old PGS r039 and o039 data tables.

The table exists with the following fields of information:

Table: [SAT**\_**ARO**\_**13C**\_**39**\_**PGS]{.underline} No lock(s)

Column definitions

\# Name Type Length Key Expression

#######  1 WMO TEXT 20 characters 

2 RC_039 TEXT 7 characters

3 LC_039 TEXT 4 characters

4 DO_039 TEXT 6 characters

5 c13_s15 TEXT 8 characters

6 c13_a15 TEXT 8 characters

Current number of rows: 805

Description of the Attributes:

> **1 WMO** Modified form of the api number.
>
> **2 RC_039** The old PGS record code for this analysis. Note that
> there exists no lower case designation for (r)ock samples or (o)il
> samples as in other tables.
>
> **3 LC_039** A code depicting the subcontracting laboratory in which
> the sample was analyzed.

**4 DO_039** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

**5 C13_s15** The delta stable Carbon isotopic value in parts per
thousand variance from that of the international standard: PDB of the
C15+ saturate fraction.

**6 C13_a15** The delta stable Carbon isotopic value in parts per
thousand variance from that of the international standard: PDB of the
C15+ saromatic fraction.

The table [COMMENTS**\_**PGS]{.underline} is a forum for the contracting
lab to make statements regarding the sample condition, analytical
technique, or to list problems encountered with the sample. Preserved in
the table are the original API values before they were modified to WMO
numbers. *NOTE: The comment field of this table has been transferred to
the [MASTER**\_**PGS]{.underline} table to facilitate the creation of
views encompassing comments re the sample integrity.*

Table: [COMMENTS**\_**PGS]{.underline} No lock(s)

Read Password: No

Modify Password: No

Column definitions

\# Name Type Length

1 WMO TEXT 20

2 API TEXT 19

3 SQ TEXT 4

4 RECNO TEXT 7

5 COMMENT TEXT 40

6 FILDTE TEXT 6

Current number of rows: 2698

Description of the Attributes:

> **1 WMO** Modified form of the api number.

**2 API** The original API designation of the sample in PGS

**3 SQ** The Original sequence number in PGS

**4 RECNO** The original record number in PGS

##  5 COMMENT Any Comment regarding the sample

**6 FILDTE** Filing date of the comment

The table [ELEM**\_**36**\_**PGS]{.underline} contains information on
the elemental composition of a sample.

[ELEM**\_**36**\_**PGS]{.underline}

Record Count: 1813

1 WMO Text 20

2 RC_R036 Text 7

3 LC_R036 Text 4

4 DO_R036 Text 6

##### 5 WPCT_C Number (Double) 8

6 WPCT_H Number (Double) 8

7 WPCT_N Number (Double) 8

8 WPCT_ASH Number (Double) 8

Description of the Attributes:

> **1 WMO** Modified form of the api number.
>
> **2 RC_r036** The old PGS record code for this analysis.
>
> **3 LC_r036** A code depicting the subcontracting laboratory in which
> the sample was analyzed.

**4 DO_r036** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

> **5 WPCT_C** Weight Percent Carbon
>
> **6 WPCT_H** Weight Percent Hydrogen
>
> **7 WPCT_N** Weight Percent Nitrogen

**8 WPCT_Ash** Weight Percent Ash

The table: [ELEM**\_**37**\_**PGS]{.underline} contains information on
the elemental composition of the sample.

[ELEM**\_**37**\_**PGS]{.underline}

RecordCount: 910

1 WMO Text 20

2 RC_R037 Text 7

3 LC_R037 Text 4

4 DO_R037 Text 6

5 WPCT_O Number (Double) 8

6 WPCT_S Number (Double) 8

7 ASH_WPCT Number (Double) 8

Description of the Attributes:

> **1 WMO** Modified form of the api number.
>
> **2 RC_r036** The old PGS record code for this analysis.
>
> **3 LC_r036** A code depicting the subcontracting laboratory in which
> the sample was analyzed.

**4 DO_r036** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

**5 WPCT_O** Weight Percent Oxygen

**6 WPCT_S** Weight Percent Sulfur

**7 Ash_WPCT** Weight Percent Ash

The table [FRAC**\_**2930**\_**PGS]{.underline} is a combination of two
PGS tables and includes data on the fractional composition of rock
extracts or oils.

# 

# 

# 

# 

# FRAC**\_**2930**\_**PGS

Record Count: 1536

1 WMO Text 20

##### 2 RC_R029 Text 7

3 LC_R029 Text 4

4 DO_R029 Text 6

5 GM_RK_WT Number (Double) 8

6 PPM_BIT Number (Double) 8

7 RC_030 Text 7

8 LC_R030 Text 4

9 DO_R030 Text 6

10 PCT_SATS Number (Double) 8

11 PCT_AROM Number (Double) 8

12 PCT_N_HC Number (Double) 8

13 PCT_RECV Number (Double) 8

Description of the Attributes:

> **1 WMO** Modified form of the api number.

#### 2 RC_029 The old PGS record code for this analysis {#rc_029-the-old-pgs-record-code-for-this-analysis .unnumbered}

> **3 LC_r029** A code depicting the subcontracting laboratory in which
> the sample was analyzed.
>
> **4 DO_r029** Assumed to be the date of completion of the analysis
> *or* the date the data was encoded into the file.
>
> **5 GM_RK_WT** Weight in Grams of rock.
>
> **6 PPM_BIT** Parts per Million of bitumen

#### 7 RC_030 The old PGS record code for this analysis {#rc_030-the-old-pgs-record-code-for-this-analysis .unnumbered}

> **8 LC_R030** A code depicting the subcontracting laboratory in which
> the sample was analyzed.

#### 9 DO_R030 Assumed to be the date of completion of the analysis *or* the date the data was encoded into the file. {#do_r030-assumed-to-be-the-date-of-completion-of-the-analysis-or-the-date-the-data-was-encoded-into-the-file. .unnumbered}

#### 10 PCT_SATS Percentage of Saturated components in the sample {#pct_sats-percentage-of-saturated-components-in-the-sample .unnumbered}

**11 PCT_AROM** Percentage of Aromatic components in the sample

#### 12 PCT_N_HC Percentage of non-hydrocarbon components in the sample. {#pct_n_hc-percentage-of-non-hydrocarbon-components-in-the-sample. .unnumbered}

**13 PCT_RECV** Percent of sample recovered

The [CANGAS_8081_PGS]{.underline} table is again a combination of two
PGS tables. This table contains chemical composition data as well as
stable carbon isotopic data for the methane and CO2 compounds in the
headspace portion of canned samples.

# CANGAS**\_**8081**\_**PGS

#####  Record Count: 75 

1 WMO Text 20

2 RC_G080 Text 7

3 LC_G080 Text 4

4 DO_G080 Text 6

5 AIR Number (Double) 8

6 METHANE Number (Double) 8

7 CO2 Number (Double) 8

8 ETHANE Number (Double) 8

9 H2S Number (Double) 8

10 PROPANE Number (Double) 8

11 IBUTANE Number (Double) 8

12 NBUTANE Number (Double) 8

13 IPENTANE Number (Double) 8

14 NPENTANE Number (Double) 8

15 HEXANES Number (Double) 8

16 RC_G081 Text 7

17 LC_G081 Text 4

18 DO_R081 Text 6

19 13C_C1 Text 8

20 13C_CO2 Text 8

21 COMMENT Text 40

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_g080** The old PGS record code for this analysis.

**3 LC_g080** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_g080** Assumed to be the date of completion of the analysis *or*
the date the data was encoded into the file.

**5 AIR** Mole percentage of both Air and Nitrogen in the sample

**6 METHANE** Mole percentage of Methane in the sample

##  7 CO2 Mole Percentage of Carbon Dioxide in the sample

##  8 ETHANE Mole Percentage of Ethane in the sample

**9 H2S** Mole Percentage of Hydrogen Sulfide in the sample

##  10 PROPANE Mole Percentage of Propane in the sample

**11 IBUTANE** Mole Percentage of Iso-butane in the sample

**12 NBUTANE** Mole Percentage of Normal Butane in the sample

**13 IPENTANE** Mole Percentage of Iso-pentane in the sample

##  14 NPENTANE Mole Percentage of Normal Pentane in the sample

**15 HEXANES** Estimated mole percentage of Hexanes+ in the sample

**16 RC_G081** The old record code from PGS for this analysis

**17 LC_G081** A code depicting the subcontracting laboratory in which
the sample was analyzed

**18 DO_R081** Assumed to be the date of completion of analysis or the
date the data was encoded into the file

**19 13C_C1** Stable carbon (13) isotope of the Methane homolog as
compared to the international standard, PDB

**20 13C_CO2** Stable carbon (13) isotope of the Carbon Dioxide peak as
compared to the international standard, PDB

**21 COMMENT** Analytical comments regarding the sample. *NOTE: this
comment field is not the same as the comment field in the
[COMMENTS**\_**PGS]{.underline} or [MASTER**\_**PGS]{.underline} tables*

The [GASRNG**\_**23**\_**PGS]{.underline} table summarizes the content
of most of the more commonly found peaks in the C5-C8 chromatogram.

# 

# 

# GASRNG**\_**23**\_**PGS

Record Count: 1296

1 WMO Text 20

2 RC_023 Text 7

3 LC_RO23 Text 4

4 DO_R023 Text 6

5 IC4 Number (Double) 8

6 NC4 Number (Double) 8

7 NEO_C5 Number (Double) 8

8 IC5 Number (Double) 8

9 NC5 Number (Double) 8

10 22DM_C4 Number (Double) 8

11 CYC_C5 Number (Double) 8

12 23DM_C4 Number (Double) 8

13 2M_C5 Number (Double) 8

14 3M_C5 Number (Double) 8

15 N_HEX Number (Double) 8

16 M_CYC_C5 Number (Double) 8

17 22_DM_C5 Number (Double) 8

18 BENZENE Number (Double) 8

19 24_DM_C5 Number (Double) 8

20 223_TMC4 Number (Double) 8

21 CYC_HEX Number (Double) 8

22 33_DM_C5 Number (Double) 8

23 11DMCYC5 Number (Double) 8

24 2_M_HEX Number (Double) 8

25 23_DM_C5 Number (Double) 8

26 1C3DMCC5 Number (Double) 8

27 3_M_HEX Number (Double) 8

28 1T3DMCC5 Number (Double) 8

29 1T2DMCC5 Number (Double) 8

30 3_ETH_C5 Number (Double) 8

31 224TM_C5 Number (Double) 8

32 N_HEP Number (Double) 8

33 1C2DMCC5 Number (Double) 8

34 M_CYC_C6 Number (Double) 8

35 113TMCC5 Number (Double) 8

36 22DM_C6 Number (Double) 8

37 E_CYC_C5 Number (Double) 8

38 TOLUENE Number (Double) 8

39 C4_C8PPM Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_023** The old PGS record code for this analysis.

**3 LC_RO23** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R023** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 IC4** Weight Pct Iso-Butane

**6 NC4** Weight Pct Normal Butane

**7 NEO_C5** Weight Pct Neo-pentane

**8 IC5** Weight Pct Iso-Pentane

**9 NC5** Weight Pct Normal Pentane

**10 22DM_C4** Weight Pct 2,2,Dimethyl Butane

**11 CYC_C5** Weight Pct Cyclo Pentane

**12 23DM_C4** Weight Pct 2,3, Dimethyl butane

**13 2M_C5** Weight Pct 2 Methyl pentane

**14 3M_C5** Weight Pct 3 Methyl Pentane

**15 N_HEX** Weight Pct Normal Hexane

**16 M_CYC_C5** Weight Pct Methyl Cyclo Pentane

**17 22_DM_C5** Weight Pct 2,2,Dimethyl Pentane

**18 BENZENE** Weight Pct Benzene

**19 24_DM_C5** Weight Pct 2,4, Dimethyl Pentane

**20 223_TMC4** Weight Pct 2,2,3 Tri Methyl Butane

**21 CYC_HEX** Weight Pct Cyclo Hexane

**22 33_DM_C5** Weight Pct 3,3 Dimethyl Pentane

**23 11DMCYC5** Weight Pct 1,1 Dimethyl Cyclo Pentane

**24 2_M_HEX** Weight Pct 2 Methyl Hexane

**25 23_DM_C5** Weight Pct 2,3 Dimethyl Pentane

**26 1C3DMCC5** Weight Pct 1-cis-3 Dimethyl Cyclo Pentane

**27 3_M_HEX** Weight Pct 3 Methyl Hexane

**28 1T3DMCC5** Weight Pct 1-trans-3 Dimethyl Cyclo Pentane

**29 1T2DMCC5** Weight Pct 1-trans-2 Dimethyl Cyclo Pentane

**30 3_ETH_C5** Weight Pct 3 Ethyl Pentane

**31 224TM_C5** Weight Pct 2,2,4 Trimethyl Pentane

**32 N_HEP** Weight Pct Normal Heptane

**33 1C2DMCC5** Weight Pct 1-cis-2 Dimethyl Cyclo Pentane

**34 M_CYC_C6** Weight Pct Methyl Cyclo Hexane

**35 113TMCC5** Weight Pct 1,1,3 Trimethyl Cyclo Pentane

**36 22DM_C6** Weight Pct 2,2, Dimethyl Hexane

**37 E_CYC_C5** Weight Pct Ethyl Cyclo Pentane

**38 TOLUENE** Weight Pct Toluene

**39 C4_C8PPM** Parts Per Million all c4 - c8 compounds

The [GC31**\_**62**\_**PGS]{.underline} table contains information on
the C7-C35 normal alkanes within the saturate fraction of the sample.

[GC31**\_**62**\_**PGS]{.underline}

Record Count: 1061

1 WMO Text 20

2 RC_031 Text 7

3 LC_031 Text 4

4 DO_031 Text 6

5 N_C7 Number (Double) 8

6 N_C8 Number (Double) 8

7 N_C9 Number (Double) 8

8 N_C10 Number (Double) 8

9 N_C11 Number (Double) 8

10 N_C12 Number (Double) 8

11 N_C13 Number (Double) 8

12 N_C14 Number (Double) 8

13 N_C15 Number (Double) 8

14 N_C16 Number (Double) 8

15 N_C17 Number (Double) 8

16 PRIST Number (Double) 8

17 N_C18 Number (Double) 8

18 PHYT Number (Double) 8

19 N_C19 Number (Double) 8

20 N_C20 Number (Double) 8

21 N_C21 Number (Double) 8

22 N_C22 Number (Double) 8

23 N_C23 Number (Double) 8

24 N_C24 Number (Double) 8

25 N_C25 Number (Double) 8

26 N_C26 Number (Double) 8

27 N_C27 Number (Double) 8

28 N_C28 Number (Double) 8

29 N_C29 Number (Double) 8

30 N_C30 Number (Double) 8

31 N_C31 Number (Double) 8

32 N_C32 Number (Double) 8

33 N_C33 Number (Double) 8

34 N_C34 Number (Double) 8

35 N_C35 Number (Double) 8

36 PCT_RESL Number (Double) 8

37 CPI Number (Double) 8

38 PR_PH Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_031** The old PGS record code for this analysis.

**3 LC_031** A code depicting the subcontracting laboratory in which the
sample was analyzed.

**4 DO_031** Assumed to be the date of completion of the analysis or the
date the data was encoded into the file.

**5 N_C7** Weight Pct Normal C7

**6 N_C8** Weight Pct Normal C8

**7 N_C9** Weight Pct Normal C9

**8 N_C10** Weight Pct Normal C10

**9 N_C11** Weight Pct Normal C11

**10 N_C12** Weight Pct Normal C12

**11 N_C13** Weight Pct Normal C13

**12 N_C14** Weight Pct Normal C14

##### **13 N_C15** Weight Pct Normal C15

**14 N_C16** Weight Pct Normal C16

**15 N_C17** Weight Pct Normal C17

**16 PRIST** Weight Pct Pristane

**17 N_C18** Weight Pct Normal C18

**18 PHYT** Weight Pct Phytane

**19 N_C19** Weight Pct Normal C19

**20 N_C20** Weight Pct Normal C20

**21 N_C21** Weight Pct Normal C21

**22 N_C22** Weight Pct Normal C22

**23 N_C23** Weight Pct Normal C23

**24 N_C24** Weight Pct Normal C24

**25 N_C25** Weight Pct Normal C25

**26 N_C26** Weight Pct Normal C26

**27 N_C27** Weight Pct Normal C27

**28 N_C28** Weight Pct Normal C28

**29 N_C29** Weight Pct Normal C29

**30 N_C30** Weight Pct Normal C30

**31 N_C31** Weight Pct Normal C31

**32 N_C32** Weight Pct Normal C32

**33 N_C33** Weight Pct Normal C33

##### **34 N_C34** Weight Pct Normal C34

**35 N_C35** Weight Pct Normal C35

**36 PCT_RESL** Percent Resolved Peaks

**37 CPI** Carbon Preference Index

**38 PR_PH** Ratio Pristane/Phytane

The [ISOT**\_**38**\_**PGS]{.underline} table contains information on
the asphaltene fraction of the sample.

[ISOT**\_**38**\_**PGS]{.underline}

#####  Record Count: 103

1 WMO Text 20

2 RC_O038 Text 7

3 LC_O038 Text 4

4 DO_O038 Text 6

5 WPCT_S Number (Double) 8

6 34S_ASPH Text 8

7 WPCT_N Number (Double) 8

8 15N_ASPH Text 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_O038** The old PGS record code for this analysis.

**3 LC_O038** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_O038** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 WPCT_S** Weight % Sulfur

**6 34S_ASPH** del 34S of Asphaltenes

**7 WPCT_N** Weight % Nitrogen

**8 15N_ASPH** del 15N of Asphaltenes

The [Legend**\_**PGS]{.underline} table is a tool to try and explain the
makeup and combination of the old PGS tables into the present day
scheme.

# Legend**\_**PGS

Record Count: 25

1 TABN Text 8

2 NUMCOLS Number (Double) 8

3 NUMROWS Number (Double) 8

4 ORIGPGS1 Text 8

5 ORIGPGS2 Text 8

##### 6 ORIGPGS3 Text 8

7 ORIGPGS4 Text 8

8 COMMENT Text 40

Description of the Attributes:

**1 TABN** Table ID

**2 NUMCOLS** Number of colums

**3 NUMROWS** Number of rows

**4 ORIGPGS1** Original PGS table ID of 1st table

**5 ORIGPGS2** Original PGS ID of 2nd table

**6 ORIGPGS3** Original PGS ID of 3rd Table

**7 ORIGPGS4** Original PGS ID of 4th Table

**8 COMMENT** Comments on naming conventions

The [RKEV**\_**41**\_**PGS]{.underline} table contains information on
Rock-Eval samples.

# RKEV**\_**41**\_**PGS

Record Count: 15384

1 WMO Text 20

2 RC_R041 Text 8

3 LC_R041 Text 8

4 DO_R041 Text 8

5 TMAX Number (Double) 8

6 S1 Number (Double) 8

7 S2 Number (Double) 8

8 S3 Number (Double) 8

9 PI Number (Double) 8

10 S2S3 Number (Double) 8

11 PC Number (Double) 8

12 OC Number (Double) 8

13 HI Number (Double) 8

14 OI Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_R041** The old PGS record code for this analysis.

**3 LC_R041** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R041** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 TMAX** Tmax of S2 peak (°C)

**6 S1** Amount of volatile hydrocarbons (S1 , milligrams)

**7 S2** Amount of pyrolyzable hydrocarbons (S2 , milligrams)

**8 S3** Amount of released CO2 , milligrams

**9 PI** Rock-Eval Production Index (Transformation Ratio)

**10 S2S3** S2/S3 Ratio of pyrolyzable hydrocarbons to CO2

**11 PC** Total pyrolyzable Carbon (as percent of whole sample)

**12 TOC** Total organic Carbon (as percent of whole sample)

**13 HI** Rock-Eval Hydrogen Index

**14 OI** Rock-Eval Oxygen Index

The [SPGR**\_**60**\_**PGS]{.underline} table contains information on
the Specific Gravity of crude oils.

# SPGR**\_**60**\_**PGS

Record Count: 84

1 WMO Text 20

2 RC_O060 Text 7

3 LC_O060 Text 4

4 DO_O060 Text 6

5 SPGR Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_O060** The old PGS record code for this analysis.

**3 LC_O060** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_O060** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 SPGR** API gravity (crude oils only)

The [TAI**\_**35**\_**PGS]{.underline} table contains information on the
Thermal Alteration Index of the sample

[TAI**\_**35**\_**PGS]{.underline}

Record Count: 3849

1 WMO Text 20

2 RC_R035 Text 7

3 LC_R035 Text 4

4 DO_R035 Text 6

5 TAI Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_R035** The old PGS record code for this analysis.

**3 LC_R035** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R035** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 TAI** Thermal Alteration Index

The [TC**\_**TOC**\_**2728]{.underline} combined table contains
information on the Total Carbon and Total Organic Carbon concentrations
of rock samples.

# TC**\_**TOC**\_**2728 

Record Count: 18499

1 WMO Text 20

2 LC_R027 Text 4

3 DO_R027 Text 6

4 TOC_WTPC Number (Double) 8

5 LC_R028 Text 4

6 DO_R028 Text 6

7 TC_WTPCT Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 LC_R027** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**3 DO_R027** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**4 TOC_WTPC** Weight PCT Total Organic Carbon

**5 LC_R028** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**6 DO_R028** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**7 TC_WTPCT** Weight PCT Total Carbon

The [TEAFID**\_**26_PGS]{.underline} table contains information on the
pyrolysis of rock samples.

# 

# 

# TEAFID**\_**26_PGS

Record Count: 6344

1 WMO Text 20

2 RC_R026 Text 7

3 LC_R026 Text 4

4 DO_R026 Text 6

5 HC_YIELD Number (Double) 8

6 VOLATILE Number (Double) 8

7 TEA_MAX Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_R026** The old PGS record code for this analysis.

**3 LC_R026** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R026** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 HC_YIELD** Weight PCT Hydrocarbon Yield

**6 VOLATILE** Parts per million volatile Hydrocarbons \<300 C

**7 TEA_MAX** Maximum temp of Hydrocarbon yield

The [VISKER**\_**34**\_**PGS]{.underline} table contains information on
the visual kerogen types.

# 

# VISKER**\_**34**\_**PGS

Record Count: 4541

1 WMO Text 20

2 RC_R034 Text 7

3 LC_R034 Text 4

4 DO_R034 Text 6

5 AMORP Number (Double) 8

6 HERBA Number (Double) 8

7 WOODY Number (Double) 8

8 INERT Number (Double) 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_R034** The old PGS record code for this analysis.

**3 LC_R034** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R034** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 AMORP** PCT Amorphous

**6 HERBA** Pct Herbaceous

**7 WOODY** PCT Woody

**8 INERT** PCT Inert

The [VITREF**\_**33**\_**PGS]{.underline} table contains information on
the Vitrinite Reflectance of samples.

# VITREF**\_**33**\_**PGS

#####  Record Count: 4833 

1 WMO Text 20

2 RC_R033 Text 7

3 LC_R033 Text 4

4 DO_R033 Text 6

5 P_QUAL Text 8

6 EASE_CY1 Text 8

7 RO_MEAN Number (Double) 8

8 MODAL Number (Double) 8

9 PYRITE Text 8

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 RC_R033** The old PGS record code for this analysis.

**3 LC_R033** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**4 DO_R033** Assumed to be the date of completion of the analysis or
the date the data was encoded into the file.

**5 P_QUAL** Quality of the Polish

**6 EASE_CY1** Ease of selecting the first cycle

**7 RO_MEAN** Mean value of all reflectance measurements

**8 MODAL** Median Reflectance Value

**9 PYRITE** Abundance of Pyrite

**10 ROS** Individual reflectance measurements

Other (original PGS) Tables in the Alaskan data base that were used to
generate some of the previous tables are included here but are not
intended to be used as stand-alone data tables (see
[Legend**\_**PGS]{.underline} table for explanations) are as follows:

The [R**\_**Unit**\_**PGS]{.underline} table contains data that is
included in the [Header]{.underline} table.

[R**\_**Unit**\_**PGS]{.underline}

Record Count: 742

1 FAGE Text 4

2 FUNIT Text 4

3 FM Text 43

4 Era Text 40

Description of the Attributes:

**1 FAGE** Formation Age Code

**2 FUNIT** Formation Unit Code

**3 FM** English Formation Name

**4 Era** Major Geologic Era

The [Points**\_**PGS]{.underline} table contains information included in
the [Header]{.underline} table.

# 

# POINTS**\_**PGS

Record Count: 2968

1 WMO Text 19

2 ID Text 20

3 UNKN1 Text 20

4 LATTIT Number (Double) 8

5 LO Number (Double) 8

6 ELE Text 10

7 FAGE Text 4

8 FUNIT Text 4

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 ID** Sample Identification

**3 UNKN1** unknown field

**4 LATTIT** Latitude

**5 LO** Longitude

**6 ELE** Elevation

**7 FAGE** Formation Age Code

**8 FUNIT** Formation Unit Code

The [MASTER **\_**PGS]{.underline} table contains information on the
correlation between WMO numbers and their associated records. It also
includes the comment field from [COMMENTS**\_**PGS]{.underline}

# MASTER **\_**PGS

Record Count: 147213

##### 1 WMO Text 20

2 CODES Text 7

3 COMMENT TEXT 40

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 CODES** Record Codes

**3 COMMENT** Analytical comments re the analysis from the contracting
lab

The [A001**\_**Wells**\_**PGS]{.underline} table contains information on
the wells sampled. This information is contained in the
[Header]{.underline} table.

# A001**\_**WELLS**\_**PGS

Record Count: 26926

1 WMO Text 20

2 API Text 19

3 X Text 4

4 RC_A001 Text 7

5 WELLN Text 40

6 ELEV Text 10

7 TLD Text 7

8 WELCLAS Text 2

9 SRT Text 10

10 FD_A001 Text 6

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 API** API number

**3 X** Unknown Field

**4 RC_A001** The old PGS record code for this analysis.

**5 WELLN** Well Name

**6 ELEV** Elevation

**7 TLD** Total Depth

**8 WELCLAS** Well Class

**9 SRT** Location of Well Tns-Rng-Sec

**10 FD_A001** File Date

The [B001**\_**Outcrops**\_**PGS]{.underline} table contains data on the
outcrops sampled in the study. This information resides in the
[Header**\_**PGS]{.underline} table.

# B001**\_**Outcrops**\_**PGS

#####  Record Count: 29798

1 WMO Text 20

2 API Text 19

3 SQ Text 4

4 RC_B001 Text 7

5 LC_B001 Text 4

6 LABNO Text 8

7 DI_B001 Text 6

8 M1 Text 1

9 TOP Number (Double) 8

10 BOT Number (Double) 8

11 STY Text 2

12 OTHR Text 6

13 ADDNL Text 17

14 FD_B001 Text 6

Description of the Attributes:

**1 WMO** Modified form of the api number.

**2 API** API number

**3 SQ** Sequence number

**4 RC_B001** The old PGS record code for this analysis.

**5 LC_B001** A code depicting the subcontracting laboratory in which
the sample was analyzed.

**6 LABNO** Laboratory ID number

**7 DI_B001** Date sample entered into Laboratory

**8 M1** Measurement in (F)eet or (M)eters

**9 TOP** Top Depth

**10 BOT** Bottom Depth

**11 STY** Sample Type

**12 OTHR** Coded Info Unknown

**13 ADDNL** Additional comments

**14 FD_B001** File Date

**Encoding Schemes**

**AD** Included for compatibility with PI PGS, but used by USGS

to exclude certain types of samples from user data base.

a two byte sample type code:

CL Control sample

CO Coal

CS Composite

DT Drill stem test

OS Oil-stained rock

##### UK Unknown

RS Research sample (not applicable directly to mapping, etc.)

**ADDNL** Submitter\'s Additional Description (free format ASCII)

**API** Modified American Petroleum Institute number (assigned for

all samples from within the United States and the U.S. Exclusive
Economic Zone \[USA/EEZ\]), [or]{.underline} (see WMO)

**BD** Bottom Depth sampled in units specified by **M1**

(8 bytes, integer or floating point number)

**CONTAM** (Possible or probable) Contaminant codes, usually provided

by submitter or sample prep lab technician. Modeled after PI PGS
\"Catalog of contaminants\"

6 byte code, first 3 bytes = contaminant code

last 3 bytes = % abundance

Code: Contaminant:

-0- (null) = no observable contaminants (default)

B01 Unknown contaminant

B02 Varied organic contaminants

B03 Varied inorganic contaminants

B04 Carvings (from borehole)

B05 Casing cement

B06 Drilling mud

B07 Mud additives

B08 Walnut shells

B09 Straw

B10 Mica

B11 Rubber

B12 Oil base drilling mud

B13 Pipe dope

B14 Gilsonite

B15 Asphalt

B19 No contaminants

B21 Diesel oil

B22 Crude oil

B23 Lignosulfonate

B25 Sample package contaminant (i.e., core box wax)

\% Abundance = 000 through 100 % ; 001 implies 1% or less estimated

abundance of suspect contaminant; default 000 implies no

contaminants or not applicable.

**CT** Container code (3 bytes maximum):

Code: Container type:

B Pressure cylinder (bomb)

C Can

E Paper or plastic envelope or bag

G Glass bottle

P Plastic bottle

U None (or unknown)

**CTY** API county code (3 decimal digits)

**EC** Container external condition code (3 bytes maximum):

Code: External condition:

AT Tightly sealed, no holes or tears

NT Not tightly sealed, damaged

UK Unknown

**ELEV** Elevation of well or surface sample in units

specified by **M1**

(8 bytes, integer or floating point number)

**FAGE** Formation age code (3 decimal digits):

> first 2 digits for encoding the geologic time table SYSTEM, last digit
> for encoding the geologic time table EPOCH:

Code, SYSTEM: Code, EPOCH:

00 Unknown 0 Unknown

70 Quaternary 9 Undifferentiated

2 Recent

1 Pleistocene

66 Quaternary 9 -Tertiary (boundary)

65 Tertiary 9 Undifferentiated

5 Pliocene

4 Miocene

3 Oligocene

2 Eocene

1 Paleocene

61 Tertiary 9 Cretaceous (boundary)

60 Cretaceous 9 Undifferentiated

5 Gulfian

4 Montanan

3 Coloradoan

2 Comanchean

1 Coahuilan

56 Jurassic 9 -Cretaceous (boundary)

55 Jurassic 9 Undifferentiated

3 Upper

2 Middle

1 Lower

51 Triassic 9 -Jurassic (boundary)

50 Triassic 9 Undifferentiated

3 Upper

2 Middle

1 Lower

46 Permo 9 -Triassic (boundary)

45 Permian 9 Undifferentiated

4 Ochoan

3 Guadalupian

2 Leonardian

1 Wolfcampian

41 Permo 9 -Pennsylvanian (boundary)

40 Pennsylvanian 9 Undifferentiated

6 Virgilian or Cisco or Monogahelan

5 Missourian or Canyon or Conemaughan

4 Desmoinesian or Strawn or Alleghenian

3 Atokan or Bend or Pottsvillian

2 Morrowan

1 Springeran

36 Mississippian 9 -Pennsylvanian (boundary)

35 Mississippian 9 Undifferentiated

4 Chesterian

3 Meramecian

2 Osagian

1 Kinderhookian

31 Mississippian 9 -Devonian (boundary)

30 Devonian 9 Undifferentiated

6 Upper

5 Bradfordian

4 Chatauquan

3 Senecan

2 Erian or Middle

1 Ulsterian or Lower

26 Silurian 9 -Devonian (boundary)

25 Silurian 9 Undifferentiated

3 Cayugan

2 Niagaran

1 Albion or Alexandrian

21 Silurian 9 -Ordovician (boundary)

20 Ordovician 9 Undifferentiated

3 Cincinnatian

2 Champlainian

1 Canadian

16 Cambro 9 -Ordivician (boundary)

15 Cambrian 9 Undifferentiated

3 Croixian

2 Albertian

1 Waucoban

11 Precambrian 9 -Cambrian (boundary)

10 Precambrian 9 Undifferentiated

**FUNIT** Formation name code (up to 5 bytes, alphabetic)

These codes are assigned by Petroleum Information Corpora­tion (PI) and
are proprietary to PI; they are identical to the forma­tion codes used in
PI\'s Well History Control System (WHCS). Formation name codes for
formations outside US/EEZ are assigned by the USGS on a sample by sample
basis and are public domain. An example:

PNDQ = the Pindiquan formation (Junggar Basin, China)

**HCST** Side track / hole change portion of **API** number

(4 numeric digits)

**IC** Container internal condition code (3 bytes maximum)

Code: Internal condition:

-0- (null) not applicable

A Sample absent

D Dry

M Wet

U Unwashed

Q Unknown

**LAT** Sampling location latitude (7 decimal digits, 5 implied

decimals). The actual latitude for mapping purposes may be calculated
from **LAT** and the first digit of **WSC** (or **API**):

Latitude = (**LAT**)X10-5 if first digit of **WSC** = 1, 7 or 9

Latitude = - (**LAT**)X10-5 if first digit of **WSC** = 3 or 5

**LC\_\*** A code depicting the subcontracting laboratory in which the
sample was analyzed. The first 2 alpha characters of the 4 character
code is the contractor code (CC):

AK Alaska Div of Oil & Gas

CL Core Labs, Inc.

CS Canadian Geological Survey

GC Geochem Research

GS USGS Organic Geochem Lab, Denver, CO

MO Mobil Oil Co.

NA Not Available/unknown

SH Shell Oil Co.

TE Tenneco Oil Co.

UN Unical Oil Co.

WH Woods Hole

The next two characters in the LC\_\* code are the laboratory codes for
the analytical lab performing the analyses (LC):

BR Brown & Ruth Labs

CL Core Labs, Inc.

CS Canadian Geological Survey

##### GC Geochem Research

GG Global Geochemistry Corp.

GS USGS Organic Geochem Lab, Denver, CO

NA Not Available/unknown

SH Shell Oil Co.

TE Tenneco Oil Co.

UN Union Oil Co.

WH Woods Hole

**LITHO** Lithology codes Up to 4 alphabetic characters for the

actual lithology, then 3 decimal digits expressing the approximate
percentage of the lithology, as determined by the submit­ter or
laboratory technician. (The sum of all **LITHO** and **CONTAM**
per­centages should be 100.)

Code: Lithology:

XXXX Not available or not determined

ANHY Anhydrite

CCRN Concretion

CHRT Chert

COAL Coal

DOLL Limey dolomite

DOLO Dolomite

FLMD Mudstone

FLSH Shale

FMCY Claystone

LSAR Argillaceous limestone

LSCH Cherty limestone

LSDL Limey dolomite

LSFL Laminated limestone

LSND Limestone

MICR Micrite

SALT Salt

SHBT Bituminous Shale

SILT Siltstone

SSBT Tar or solid bitumens

SSLS Limey sandstone

SSND Sandstone

TUFF Volcanic tuff

**LONG** Sampling location longitude (8 decimal digits, 5 implied

decimals). The actual longitude for mapping purposes may be calculated
from **LONG** and the first digit of **WSC** (or **API**):

Longitude = (**LONG**)X10-5 if first digit of **WSC** = 1 or 3

Longitude = - (**LONG**)X10-5 if first digit of **WSC** = 5, 7, or 9

**M1** English or Metric units indicator (one character - either

F for depths and elevations in *feet*, or

M for depths and elevations in *meters*).

**POR** (defunct) Included for compatibility with PI PGS

Porosity code (one numeric digit), supplied by the submit­ter, estimated
(not measured).

Code: Porosity:

0 Unknown (default)

1 Tight

2 Very poor

3 Poor

4 Fair

5 Good

6 Excellent

**SQ** (up to 4 ASCII characters, but usually integer numbers)

**SHO** (defunct) Included for compatibility with PI PGS

(Oil) \"SHOW\" code supplied by the submitter.

Code: Quality of oil show:

0 Unknown (default)

1 No show

2 Very poor

3 Poor

4 Fair

5 Good

6 Excellent

**SRT** For samples within US/EEZ, Township, Range and Section:

10 alphanumeric characters

Character

Position: Definition:

1 Township direction (**N** or **S**)

2- 4 Township number (right justified, leading blanks)

5 Range direction (**E** or **W**)

6- 8 Range number (right justified, leading blanks)

9-10 Section number (right justified, leading blanks)

**ST** For samples within US/EEZ, State postal code

(two alphabetic characters)

**STY** Sample source code, 2 alphanumeric characters:

Code: Sample source:

CO Core

CT Cuttings

EN Emulsion

GC Suspected contaminant

GS Natural gas

IG Inorganic

LO Generic liquid

MD Drilling mud

OL Crude oil or natural gas condensates

OT Outcrop

SO Generic solid

SW Side wall core

UK Unknown

WT Water

**SW** (defunct) Included for compatibility with PI PGS

Sample weight in grams (0 to 9999, right justified)

**TD** Top Depth sampled in units specified by **M1**

(8 bytes, integer or floating point number)

**TLD** Total depth of well in units specified by **M1**

(8 bytes, integer or floating point number)

**UNIQ** Unique well code portion of **API** (digits 7-11 of the API

number) cf. **API** encoding scheme.

**WMO** a modified World Meteorological Organization number (assigned
for all samples outside the USA/EEZ. The total number of digits in the
modified **API** (or WMO) number is 19, defined thus:

Digit

Position: Definition:

1 World code based on 4 quadrants relative to the

Equator and the Greenwich Meridian:

1 = northeast quadrant

3 = southeast quadrant

5 = southwest quadrant

7 = northwest quadrant

9 = USA/EEZ

2- 3 two digit state or latitude code:

\(a\) state code as defined by API for USA/EEZ (World = 9)

\(b\) latitude of location truncated to the nearest degree

(World = 1, 3, 5 or 7)

4- 6 three digit county or longitude code:

\(a\) county code as defined by API for USA/EEZ (World = 9)

\(b\) longitude of location truncated to the nearest degree

(World = 1, 3, 5 or 7)

7-11 five digit unique well code:

\(a\) 0000 - 64999 assigned by API for USA/EEZ (World = 9)

\(b\) 10000 - 94999 assigned by USGS [WAPI]{.underline} for wells
outside

the USA/EEZ (World = 1, 3, 5, or 7)

\(c\) 65000 - 94999 used for wells for which API has

not assigned a number (World = 9) assigned by USGS [WAPI]{.underline}

\(d\) 95000 - 99999 assigned by USGS [WAPI]{.underline} for non-

well samples (surface, outcrops, speleological,

mines, seeps, etc.)(World = 1, 3, 5, 7 or 9)

12-13 two digit side track code assigned by API (World = 9)

14-15 two digit hole change code assigned by API (World = 9)

16-19 four digit sample sequence number assigned by USGS
[WAPI]{.underline}

Note: digits 2-15 of the USGS **API** number are *identically* the
fourteen digit unique API number for all wells within USA/EEZ (World =
9). The expanded API/WMO number was developed to assign unique numbers
to specific samples collected worldwide.

**WSC** World/State/County or World/Lat/Long portion of **API** (digits

1-6 of the API number) cf. **API** encoding scheme.

**Appendix A**

Definitions of Some Commonly Used Terms

ASCII **A**merican **S**tandard **C**ode for **I**nformation
**I**nterchange; usually

> refers to the characters, numbers and punctuation marks found on a
> typewriter or computer keyboard.

BIOMARKERS Organic compounds found in crude oils and sedimentary rocks
that are derived from living organisms.

CHROMATOGRAPHY A method of separating complex mixtures into

individual chemical compounds or classes of

> chemical compounds by differences in their chemical behavior.

EXTRACTION The process of dissolution of particular chemical

> compounds from a solid matrix (i.e., rock) into a liquid solution
> (i.e., bitumen or rock extract).

FRACTION A group of chemical compounds with similar chemical and

> physical properties (i.e., saturated hydrocarbons, aromatic
> hydrocarbons, resins, asphaltenes, kerogen)

GLOBAL Applicable to all users.

KINETICS The relationship between time, temperature and the rate of a
chemical reaction (or group of parallel, serial or compet­ing chemical
reactions); expressed mathematically by the Arrhenius constant
(frequency factor), energy of activation and reaction order.

LOCAL Applicable to a small group of users (not global)

PYROLYSIS The heating of a sample in the absence of air;

> followed by subsequent analysis of the products ob­tained in order to
> determine quantities of products and/or reaction kinetic factors.
> Hydrous pyrolysis is done in the presence of an overabundance of
> water, anhydrous pyrolysis is done on the dry sample.

ROCK-EVAL A rapid anhydrous pyrolysis technique used to semi-

> quantitatively determine amounts of petroleum-like products obtained
> from a suspected oil or gas source rock. A less rapid Rock-Eval
> technique can also determine kinetic factors.

VITRINITE A maceral derived from wood or coaly material that

> exhibits higher optical reflectivity with increasing exposure to
> higher temperatures; a thermal maturity indicator.

**Appendix B**

Manufacturers of Products and Services Mentioned

American Petroleum Institute

Production Department

211 N. Ervay, suite 1700

Dallas, TX 75201 USA

MicroRim

3925 159th Ave NE

PO Box 97022

Redmond, WA 98073-9722 USA

MicroSoft Corporation

16011 NE 36th Way

PO Box 97017

Redmond, WA 98073-9717 USA

Perkin-Elmer / Nelson Chromatography

10061 Bubb Road

Cupertino, CA 95014 USA

Petroleum Information Corporation

4100 E. Dry Creek Road

Littleton, CO 80122 USA

Rock-Eval pyrolysis instrument

Contact:

Delsi Inc.

600 Kenrick, Suite D-7

Houston, TX 77060 USA

World Meterological Organization numbering system

Contact:

National Oceanographic Data Center

National Oceanographic and Atmospheric Administration

Washington, DC USA