Tables

Links analytical batches to data source e.g. SGP, USGS_NGDB, USGS_CMIBS

Dictionary of sample preparation methods

Raw results of geochemical analyses. Reported in the original units.

Dictionary of terms to describe the lithological texture of samples e.g. silty, muddy, clayey, sandy. Based on table from Potter et al. 2005 Mud and Mudstones

Linking table to record which samples were batched together

Linking table between geological context and person - more than one person can contribute to the geological context

Dictionary of lithostratigraphic names, populated from Macrostrat (in Nov 2015, up to lithostrat_id 80624), with subsequent additions in the same format. Columns were adopted directly from Macrostrat, and therefore some may not be directly relevent to SGP - for example concept_id. They are nevertheless retained in case they prove useful for cross-referencing. Table also includes identifiers from national stratigraphic databases i.e. BGS, GSC, and ASUD

Name and type of either craton (e.g. Laurentia) or terrane (e.g. Avalonia).

Dictionary of countries and seas

Dictionary of biozones. Not often used - verbatim biostrat is stored in biostrat.

Biostratigraphical details

Where the samples are stored

Published “proxy” results - results that are calculated using original measured data.

Alternate original sample numbers. The same samples are frequently numbered/named in different ways in different publications and institutional collections. A sample may be associated with more than one alternate number.

Project is a way to link samples together. Each reference work is one project, other kinds of project include e.g. student summer projects, dissertations, field seasons, groups of related reference works etc.

A list of people - can be contributors, authors, collectors etc.

Links projects with samples.

Dictionary of institution types, from ODM2 (http://odm2.github.io/ODM2/schemas/ODM2_Current/index.html) with additions

Reference work, may be published or unpublished.

Dictionary table of lithological terms, based in part on Macrostrat

Dictionary of colors, with and without Munsell codes, separated into name, qualifier, shade

Dictionary of terms to describe the composition of samples e.g. calcareous, siliceous, carbonaceous. Based on table from Potter et al. 2005 Mud and Mudstones

Linking table recording the people who were involved in the collecting event

Detection limits (lower and upper) and analytes for each analysis. Units are the same as reported analytical result.

Dictionary of basin types

Table linking samples to fossils, and recording the verbatim fossil name

Fossil names and Paleobiology Database code. Note verbatim fossil information from context sheets is reported on the fossil_sample table, and may not be linked to formal fossil name until later date.

Depositional environment details - primarily concerned with water depth, also records whether or not sediments are turbidites

Data sources - large scale separation between, for example, external databases and SGP data (e.g. USGS, CMIBS, SGP)

Analysis details for a batch i.e. preparation, experimental and analytical methods, who ran the analysis and/or provided the data

Links reference_work to person (authors)

Linking table between sample and person - more than one person can contribute to the description of the sample

Linking table between interpreted_age and person - more than one person can contribute to the interpreted_age

Linking table for samples and sedimentary structures

Information about the basin, prefereably including a basin name (e.g. Taconic Foreland Basin), and a basin type (from dic_basin).

Dictionary of analytical methods

A batch of samples analysed at the same laboratory at roughly the same time. One batch of samples may go through multiple analyses, and samples may be associated with mutiple batches (see batch_sample table)

Dictionary of International Commission on Stratigraphy, International Chronostratigraphic timescale. See http://www.stratigraphy.org

Dictionary of project types.

Dictionary of chemical analytes

Dictionary of sedimentary structures

Sites of sample collection

Dictionary of geochemical proxies (e.g. FeHR/FeT)

The interpreted age of the sample in millions of years, with justification.

Insitutions/organizations.

Dictionary of publications - mostly scientific journals.

Affiliations of people to institutions. A person may be associated with more than one institution.

Dictionary of low-temperature metamorphic bins, based roughly on metapelite zones

Dictionary of contintents and oceans

Geological age - verbatim and International Commission on Stratigraphy (ICS) age

Samples collected for analysis.

Details of sample collection from a particular site, in particular the date of collection. A site can be revisted multiple times.

Reported geological unit (e.g. group, formation or member) - verbatim and with reference to dic_lithostrat

Linking table for projects and reference works

Links lithostratigraphy, biostratigraphy, depositional environment and age data. Multiple samples from related site/project/paper often have the same combination of these four factors, and may use one geol_context_id.

Dictionary of weathering terms from the International Society for Rock Mechanics (and others)

Dictionary of experimental methods