Tables

Is Neotoma-derived lookup table for compilations involving datasets, e.g. IPPD. This table stores dataset publications. NOTE – DATASETID and REFDBID together form a combined primary key.

Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ Radiocarbon collection, EPSG:900913)

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:25 UTC

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/xq40-t003. Table creation date: 2024-08-22 11:02:11 UTC

Is lookup table for Sahul-related compilations. The cabah_datasourceID table stores the way that data / information have been gathered for database integration.

Is across-Sahul Sedimentary Archives (SahulSed) lookup table for geomorphological type of feature sampled (= GEOTYPE)

Is flat GeoServer input table (bbox). Table creation date: 2024-08-12 12:53:07 UTC

Is Neotoma-derived taxa table for compilations dealing with taxa, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa), stores taxa … IMPORTANT NOTE: Primary key (and, with the exception of “TAXAGRPID”, the other IDs too) have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these IDs stay untouched.

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for info whether delta13C was measured or assumed (= C13_VAL)

Is the global master table that stores site-related information for all compilations. In OCTOPUS data model hierarchy global_SiteMaster is situated between the collection-specific sample tables (subordinate) and the global_MetaSite table (superordinate); (= SITEID).

Is CRN denudation spatial features table (polygons, EPSG:3857)

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the reported procedure used to determine sample equivalent dose for OSL and TL methods (= ED_PROC)

Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model entity) for the SahulArch/ Radiocarbon collection and is subordinate to the arch_Sample table.

Is FosSahul sample table. This table stores FosSahul samples and is, therefore, situated between fos_DataCore table (subordinate) and global_SiteMaster table (superordinate).

Is an IPPD-specific Neotoma table where each occurrence of a Variable in a sample comprises a record in the Data table. Data is the primary table in Neotoma’s data model. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#data)

Is lookup table for Sahul-related compilations. The cabah_depositID table stores the type of deposit sampled.

Is Sahul Sedimentary Archives (SahulSed/ Aeolian) lookup table for geomorphic modifier of feature sampled (= GEOMMOD)

Is an IPPD-specific Neotoma table that stores samples. In Neotoma’s data model, Samples belong to Analysis Units, which belong to Collection Units, which belong to Sites. However, Samples also belong to a Dataset, and the Dataset determines the type of sample. Thus, there could be two different samples from the same Analysis Unit, one belonging to a pollen dataset, the other to a plant macrofossil dataset. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#samples)

Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores arbitrary catchment area classes (catchment = area contributing to a certain basin).

Is Sahul Archaeology (SahulArch) sample table. This table stores SahulArch samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the global_SiteMaster table (superordinate).

Is an IPPD-specific Neotoma table that links keywords to samples. (For example, it identifies modern pollen surface samples.)

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/057R-TM53. Table creation date: 2024-08-22 11:01:35 UTC

Is a Neotoma table for compilations dealing with chronologies, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_chron.html#chronologies), stores chronology data. … A Chronology refers to an explicit chronology assigned to a Collection Unit. A Chronology has Chronology Controls, the actual age-depth control points, which are stored in the ChronControls table. A Chronology is also based on an Age Model, which may be a numerical method that fits a curve to a set of age-depth control points or may simply be individually dated Analysis Units. IMPORTANT NOTE: The primary key values have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these ID stays untouched.

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/057R-TM53. Table creation date: 2024-08-22 11:01:32 UTC

Is Expage sample table. This table stores Expage samples and is, therefore, situated between the expage_DataCore table (subordinate) and the global_SiteMaster table (superordinate).

Is Sahul Sedimentary Archives (SahulSed/ Lacustrine) lookup table for sedimentological facies type (= FACIES)

Is FosSahul lookup table for most updated vertebrata species name (= SPECIES)

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the sample collection method (= COL_MTD).

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/Y4E9-R595. Table creation date: 2024-08-22 11:02:19 UTC

Is a Neotoma lookup table of Keywords referenced by the SampleKeywords table. The table provides a means to identify samples sharing a common attribute. For example, the keyword «modern sample» identifies modern surface samples in the database. These samples include individual surface samples, as well as core tops. Although not implemented, a «pre-European settlement» keyword would be a means to identify samples just predating European settlement. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#keywords)

Is an IPPD-specific Neotoma table that stores sample ages. In Neotoma’s data model, Ages are assigned to a Chronology. Because there may be more than one Chronology for a Collection Unit, samples may be assigned different ages for different Chronologies. A simple example is one sample age in radiocarbon years and another in calibrated radiocarbon years. The age units are an attribute of the Chronology. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#sampleages)

Is flat GeoServer input table. Refer to https://doi.org/10.25900/5jcw-tn50. Table creation date: 2024-08-22 11:02:23 UTC

Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table stores the method of charcoal quantification.

Is Expage spatial features table (points, EPSG:900913)

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:41 UTC

Is IPPD pollen (IPPD/datasets/pollen) spatial features table (points, EPSG:900913)

Is the global master table that stores collection-unit related information for all compilations. Collection units are defined in the cabah_unittypeID table. In OCTOPUS data model hierarchy global_UnitMaster is situated between the collection-specific sample tables (subordinate) and the global_SiteMaster table (superordinate); (= SITEID). global_UnitMaster table is exclusively used for collections with a corresponding demand, i.e., will be bypassed for any collection that does not deal with multiple samples / observations from one and the same location / site / unit (e.g. a core).

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores information about the lab of origin for a certain observation. Labs have been identified automatically by their distinct labcode prefixes.

Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ TL collection , EPSG:900913)

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:51 UTC

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/5WBX-N779. Table creation date: 2024-08-22 11:01:11 UTC

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_Author stores information about first authors and is part of OCTOPUS reference system (= OAID).

Is CRN denudation spatial features table (polygons, EPSG:3857). Bounding boxes delimit study extents

Is Sahul Sedimentary Archives (SahulSed) spatial features table (points of the OSL collection , EPSG:900913)

Is a Neotoma lookup lookup table of Element symmetries. This table is referenced by the neo_variableelements table.

Is CRN denudation spatial features table (points, EPSG:3857)

Is FosSahul lookup table for the type of dated material (= FOSMAT2)

Is Sahul Sedimentary Archives (SahulSed) data table. This table stores observations (= smallest data model entity) for the SahulSed/ TL collections and is subordinate to the arch_Sample table. Note - This table is further split into Aeolian, Fluvial, and Lacustrine sub-collections.

Is a Neotoma lookup table of Variable Units. This table is referenced by the ippd_variables table. (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#variableunits)

Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model intity) for the SahulArch/ TL collection and is subordinate to the arch_Sample table.

Is lookup table for radiocarbon-related compilations. The cabah_agetypeID table stores the type of time unit used for sample age specification.

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:48 UTC

Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ OSL collection , EPSG:900913)

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/32de-mj32. Table creation date: 2024-08-22 11:03:12 UTC

Is Expage data table. This table stores observations (= smallest datamodel intity) for the Expage compilation and is subordinate to the expage_Sample table.

Is Sahul Charcoal / Black Carbon (SahulChar) sample table. This table stores SahulChar samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the global_UnitMaster table (superordinate).

Is parent table for global_SiteMaster table. The latter stores site related information for collection-dependent sample tables. global_rivID stores information about the Geofabric AHGF river region membership of a certain site (= AHGFL1, AHGFL2, RIVDIV).

Is CRN denudation lookup table. This table stores study-specific projection information (EPSG and human readable), i.e., the particular UTM projected coordinate system used for calculations.

Is flat GeoServer input table. Refer to https://doi.org/10.25900/a2k9-kj43. Table creation date: 2024-08-22 11:02:26 UTC

Is Sahul Sedimentary Archives (SahulSed/ Aeolian) lookup table for deposition context of feature sampled (=DEPCON)

Is CRN denudation data table. This table stores 10Be observations (= smallest data model entity) for CRN denudation and is subordinate to the crn_Sample table.

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_PubType stores publication types and is part of OCTOPUS reference system (= PUBTYPEID).

Is a Neotoma lookup lookup table of Element maturities. This table is referenced by the neo_variableelements table.

Is a Neotoma lookup lookup table of Variable Elements. This table is referenced by the ippd_variables table. (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#variableelements)

Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores information about Acceleration Mass Spectrometer (AMS) facilities.

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the model used to combine individual equivalent dose estimates for age determination (= AGEMODEL)

Is OSL table lookup (SahulSed/ OSL collections, SahulArch/ OSL collection) for the published OSL type used to determine equivalent dose (= OSL_TYPE)

Is a Neotoma lookup lookup table of Variable Contexts (i.e., depositional contexts). This table is referenced by the ippd_variables table. (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#variablecontexts)

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:22 UTC

Is Sahul Sedimentary Archives (SahulSed) sample table. This table stores SahulSed samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the global_SiteMaster table (superordinate).

Is Sahul Sedimentary Archives (SahulSed/ Lacustrine) lookup table for type of origin of the lake formation (= LAKETYPE)

Is FosSahul lookup table for the method specification, if applicable (= FOS_MTDSUB)

Is FosSahul lookup table for most updated vertebrata infraclass name (= INFRACLASS)

Is Sahul Sedimentary Archives (SahulSed/ Aeolian) lookup table for morphology of the sampled feature (= MORPH)

Is an IPPD-specific Neotoma table that lists Variables, which always consist of a Taxon and Units of measurement. Variables can also have Elements, Contexts, and Modifications. Thus, the same taxon with different measurement units (e.g. present/absent, NISP, MNI) are different Variables. (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#variables)

Is FosSahul data table. This table stores observations (= smallest datamodel intity) for the FosSahul compilation and is subordinate to the fos_Sample table.

Is Neotoma-derived table for compilations dealing with chronologies, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_chron.html#chroncontroltypes), stores chronology control types.

Is flat GeoServer input table. Refer to https://doi.org/10.25900/6hmv-zz61. Table creation date: 2024-08-22 11:03:09 UTC

Is FosSahul lookup table for most updated vertebrata class name (= CLASS)

Is a Neotoma lookup lookup table of Element proportions. This table is referenced by the neo_variableelements table.

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/5WBX-N779. Tble creation date: 2024-08-22 11:01:14 UTC

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for specific contaminants that may have remained after sample pretreatment (= CONTAM)

Is Sahul Archaeology (SahulArch) lookup table for specific features dated, where applicable (= FEATDATED)

Is flat GeoServer input table. Table creation date: 2024-08-22 11:01:44 UTC

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_Journal store information about journals and is part of OCTOPUS reference system (= JOURNALID).

Is a Neotoma lookup table for compilations involving Neotoma contacts, e.g. IPPD. This table stores contacts of both individuals and legal entities. To preserve table usability down the database pipeline, primary key values have NOT been altered and MUST BE always identical with those from the Neotoma original.

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the method used to determine a certain element concentration of the sample (= U_MTD, U_TH_MTD, TH_MTD, K_MTD) resp. the method used to determine an external dose rate (= ALPH_MTD, BETA_MTD, GAMMA_MTD)

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for method used to determine element abundance/ ratio (= C_MTD, = PCT_C_MTD, = PCT_N_MTD, = CN_MTD, = C13_MTD, = O18_MTD, = N15_MTD, = S34_MTD)

Is Sahul Charcoal / Black Carbon (SahulChar) data table. This table stores observations (= smallest data model entity) for the SahulChar collection and is subordinate to the char_Sample table.

Is CRN denudation sample table. This table stores CRN denudation samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the global_SiteMaster table (superordinate).

Is a Neotoma lookup lookup table of Element types. This table is refrences by the neo_variableelements table.

Is Sahul Sedimentary Archives (SahulSed) data table. This table stores observations (= smallest data model entity) for the SahulSed/ OSL collections and is subordinate to the arch_Sample table. Note - This table is further split into Aeolian, Fluvial, and Lacustrine sub-collections.

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for solvent used (= SOLVENT2)

Is Neotoma-derived lookup table for compilations dealing with taxa, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa), stores taxa groups … The TaxaGroupID facilitates rapid extraction of taxa groups that are typically grouped together for analysis. Some of these groups contain taxa in different classes or phyla.

Is FosSahul lookup table for type of dated remain (= FOSMAT1)

Is parent table for global_SiteMaster table. The latter stores site related information for collection-dependent sample tables. global_ibraID stores information about the location of the site within the relevant bioregion as defined by the Interim Bio-Regionalisation of Australia (IBRA7) framework (= IBRACODE, IBRAREGION).

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/p5ye-rn35. Table creation date: 2024-08-22 11:02:29 UTC

Is Neotoma-derived lookup table for compilations dealing with taxa, e.g. IPPD. This table, according Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#ecolgroups), stores ecological groups that facilitate subsequent data handling … Taxa are assigned to Sets of Ecological Groups. A taxon may be assigned to more than one Set of Ecological Groups, representing different schemes for organizing taxa …

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for sub-type of sample material used for 14C dating (= MATERIAL2)

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/ypr0-j711. Table creation date: 2024-08-22 11:02:08 UTC

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of chemical pretreatment given to an observation. Methods capture the majority of methods applied in Australia (= CHEMPREP).

Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores Be standards, correction factors, ratios and related information.

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_RefAbstract stores publication abstracts and is part of OCTOPUS reference system (= REFDBID; one to one).

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/57DR-YQ75. Table creation date: 2024-08-22 11:01:58 UTC

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the type of sample material used for OSL and TL dating (= LUM_MAT)

The global_datasettypeID table stores dataset types, e.g., pollen. To facilitate data migration where necessary, table structure, primary keys and content resemble Neotoma’s datasettypes table.

Is Sahul Sedimentary Charcoal (SahulChar) spatial features table (points, EPSG:900913)

Is CRN denudation data table. This table stores 26Al observations (= smallest data model entity) for CRN denudation and is subordinate to the crn_Sample table.

The global_varunitID table stores variable units for those compilations whose values involve different units of measurement.

Is FosSahul lookup table for the type of chemical pretreatment given to the sample as described in original publication (= CHEMTYPE)

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for indications of human modification (= HUM_MOD)

Is spatial features system table. spatial_ref_sys stores projection definitions and is created automatically

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of method used in age determination (= METHOD, = FOS_MTD).

Is lookup table for compilations that involve collection units, i.e., SahulCHAR. This table, according to Neotoma’s IPPD template, stores collection unit types.

Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model intity) for the SahulArch/ OSL collection and is subordinate to the arch_Sample table.

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/J13C-KT93. Table creation date: 2024-08-22 11:02:01 UTC

Is Neotoma-derived table for compilations dealing with analysis units, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#analysisunits), stores analysis units, i.e., depth increments / bins that are considered analytical entities. Prior to db intake, this table has been filtered so it stores OCTOPUS relevant analysis units only. IMPORTANT NOTE: The primary key values have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these ID stays untouched.

Is lookup table for global_SiteMaster table. global_SiteCode stores information about the site type characterising the dominant attribute of the sites, an information category that is related to SahulArch compilations only (= SITECODE).

Is IPPD datasets (IPPD/datasets) spatial features table (points, EPSG:900913)

The c14_calprogram table stores computer programmes – incl. their versions – that may be used for radiocarbon calibration.

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/KKDX-XH23. Table creation date: 2024-08-22 11:02:16 UTC

Is OCTOPUS DB reference core table, i.e., global lookup table for references. global_RefCore stores all relevant reference information, which are linked via “REFDBID” field to compilation DataCore tables (= REFDBID).

Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores flow type descriptors for water bodies.

The c14_calcurve table stores calibration curves used for radiocarbon age calibration.

The global_biomeID table stores iconic biome types that allow for a coarse characterisation/classifications of sampled sites amongst Earth’s major biogeographic units.

Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores arbitrary water body area classes (basin = water body itself).

Is FosSahul lookup table for most updated vertebrata family name (= FAMILY)

Is global master table that stores metasite-related information for all compilations. In OCTOPUS data model hierarchy global_MetaSite is superordinate to global_SiteMaster, <collection name>_Sample, and <sub-collection name>_DataCore tables (in this decreasing order). However, whilst the latter three levels can’t be ‘NULL’, “METASITE” is quasi nullable (= METASITE).

Is global parent table for sample tables of compilations dealing with sedimentary grain sizes (sed_Sample, expage_Sample, crn_Sample). global_GrainSize stores the type of material sampled (= MATERIAL (CRN denudation, ExpAge), = SED_MAT (SahulSed)).

Is Sahul Sedimentary Archives (SahulSed) lookup table for type of the site from which samples were extracted (= SITETYPE)

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the type of mineral used for equivalent dose determination (= MINERAL)

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_RefKeyword is thoroughly boolean, stores compilation membership keywords for observations and is part of OCTOPUS reference system (= REFDBID; one to one).

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for type of sample material used for 14C dating (= MATERIAL1)

Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores Al standards, correction factors, ratios and related information.

Is Sahul Sedimentary Archives (SahulSed) spatial features table (points of the TL collection , EPSG:900913)

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/2mb4-rr36. Table creation date: 2024-08-22 11:02:05 UTC

Is FosSahul lookup table for most updated vertebrata order name (= ORDR)

Is Neotoma-derived lookup table for compilations involving Neotoma contacts, e.g. IPPD. This table stores contact statuses.

Is FosSahul spatial features table (polygons, EPSG:900913)

Is the global master table that stores dataset related information for all relevant compilations. A Dataset is the set of samples for a particular data type, e.g. pollen, from a certain collection unit (according to Neotoma db). Dataset types are defined in the cabah_datasettypeID table. In OCTOPUS data model hierarchy global_DataSetID is situated between the collection-specific sample tables (subordinate) and the global_UnitMaster table (superordinate); (= UNITID). global_DataSetID table is exclusively used for collections with a corresponding demand, i.e., will be bypassed for any collection that does not deal with multiple samples / observations from one and the same location / site / unit (e.g. a core).

Is FosSahul lookup table for most updated vertebrata genus name (= GENUS)

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/2a76-vw55. Table creation date: 2024-08-22 11:03:05 UTC