Tables

Linking table to record which batches of data belong to which data_source

Territories from Native Land Digital for SGP sites, from API by position. See https://api-docs.native-land.ca/ Now handled live on SGP search website.

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 for analysis. Informal groups created for published data where exact location and dates of analyses are not available.

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. Includes BGS, GSC, and ASUD identifiers.

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

Dictionary of countries and seas based on ISO-3166, some minor modifications

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

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

Analytes, detection limits (lower and upper) and reference standards for each analysis.

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

Dictionary of basin types

Dictionary of sample types

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.

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

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

Data sources - large scale separation between, SGP data and data from external sources (e.g. USGS-NGDB, USGS-CMIBS)

Linking SGP sites to dic_native_land. Last updated Aug 2024. Link to Native Land Digital now handled through SGP search website.

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

Dictionary of analytical instruments

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).

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). Informal batches created for published data where exact location and dates of analyses are not available.

Dictionary of analytical methods

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

International Generic Sample Number metadata. Table built to store IGSN metadata exactly as received/submitted. IGSN is also stored on the sample table. This table is only occasionally used - in most cases, refer to IGSN URL to find the details and https://www.geosamples.org/ for column descriptions.

Dictionary of detailed depositional environments. Added in 2021

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, book and report names are stored directly in the reference_work table.

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

Linking instruments to analyses

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 dates of collection. A site can be revisited 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 geological age bin 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). Rarely used, legacy table from the early stages of SGP project.

Dictionary of experimental methods