sample

PK. Unique identifier for a sample. Generated by database

International Geo Sample Number, see geosamples.org/igsnabout.

Original reported/published sample number. Note that the original_num is not necessarily unique.

Height or depth in meters in the measured section or core.

FK. ID for the geological context. Links to the geol_context table.

FK. ID for the sample storage location. Links to the storage table.

FK. ID for the collecting event. Links to the collecting_event table.

Whether a sample is used as a standard in geochemical analyses.

Notes about the sample.

Randomly generated unique identifier.

FK. Reference to dic_lithology, a dictionary of lithology types e.g. shale, mudstone etc.

FK. Reference to color table.

FK. ID for the lithology texture. Links to dic_lith_texture.

FK. ID for the lithology composition. Links to the dic_lith_composition table.

Whether the sediment is bioturbated.

Notes whether visible pyrite oxidation was noted in the field.

Records the ichnofabric index - generally a scale from 1-6 (see Droser and Bottjer 1986).

FK. ID for weathering grade. Links to the dic_weathering table.

Notes about the lithology

Minimum depth of sample collection, where a range is specified.

Maximum depth of sample collection, where a range is specified.

IGSN for parent sample - e.g. the IGSN for a core as a whole.

Verbatim lithology description, in particular where specified in a published table.

Composite height/depth in meters, i.e. where multiple sections are put together as one larger section

Code for color from Munsell Rock Color Chart

From USGS database: Job ID; Laboratory batch identifier assigned by the Sample Control Officer of the analytical laboratory that received the samples as a batch.

To accomodate data from USGS database: Date submitted; Date sample was submitted to Sample Control for initial database processing prior to sample prep and analysis.