15.6 aggregatesampleages

This table stores the links to the ages of samples in an Aggregate Dataset.

Details

The table is necessary because samples may be from Collection Units with multiple chronologies, and this table stores the links to the sample ages desired for the Aggregate Dataset.

  • aggregatedatasetid (primary key, foreign key): Aggregate Dataset identification number. Field links to the aggregatedatasets[#AggregateDatasets] table.
  • aggregatechronid (primary key, foreign key): Aggregate Chronology identification number Field links to the aggregatechronologies[#AggregateChronologies] table.
  • sampleageid (primary key, foreign key): Sample Age ID number. Field links to the sampleages[#SampleAges] table.

15.6.1 SQL Example

The following SQL statement produces a list of Sample ID numbers and ages for the Aggregate Dataset at Sierra Bacha:

SELECT ad.aggregatedatasetname,
       sa.age
FROM ndb.aggregatesamples AS ags
    INNER JOIN ndb.aggregatedatasets AS ad ON ags.aggregatedatasetid = ad.aggregatedatasetid
    INNER JOIN ndb.sampleages AS sa ON sa.sampleid = ags.sampleid
    INNER JOIN ndb.aggregatesampleages AS asa ON asa.sampleageid = sa.sampleageid
WHERE ad.aggregatedatasetname='Sierra Bacha';
Table 15.3: 9 records
aggregatedatasetname age
Sierra Bacha 9970
Sierra Bacha 320
Sierra Bacha 9270
Sierra Bacha 9670
Sierra Bacha 2585
Sierra Bacha 2765
Sierra Bacha 3830
Sierra Bacha 5340
Sierra Bacha -38

15.6.2 SQL Example

The AggregateSampleAges table may have multiple sampleageids’s for Aggregate Dataset samples, for example sampleageidss for radiocarbon and calibrated radiocarbon chronologies. In this case, the chronolgies table must be linked into a query to obtain the ages of aggregatesamples, and either the AgeTypeID must be specified in the Chronolgies table or the agetypes table must also be linked with the AgeType specified. The following SQL statement produces a list of Sample ID numbers and «Radiocarbon years BP» ages for the «» Aggregate Dataset: samples.

SELECT agd.aggregatedatasetname,
       ags.sampleid,
       sa.age,
       aty.agetype
FROM ndb.aggregatedatasets AS agd
INNER JOIN ndb.aggregatesampleages AS agsa ON agsa.aggregatedatasetid = agd.aggregatedatasetid
INNER JOIN ndb.aggregatesamples AS ags ON ags.aggregatedatasetid = agd.aggregatedatasetid
INNER JOIN ndb.sampleages AS sa ON sa.sampleid = ags.sampleid AND sa.sampleageid = agsa.sampleageid
INNER JOIN ndb.chronologies AS ch ON ch.chronologyid = sa.chronologyid
INNER JOIN ndb.agetypes AS aty ON aty.agetypeid = ch.agetypeid
WHERE agd.aggregatedatasetname = 'Roberts Creek';
Table 15.4: Displaying records 1 - 10
aggregatedatasetname sampleid age agetype
Roberts Creek 44627 0 Radiocarbon years BP
Roberts Creek 44628 380 Radiocarbon years BP
Roberts Creek 44629 1220 Radiocarbon years BP
Roberts Creek 44630 1820 Radiocarbon years BP
Roberts Creek 44631 2050 Radiocarbon years BP
Roberts Creek 44632 2330 Radiocarbon years BP
Roberts Creek 44633 2860 Radiocarbon years BP
Roberts Creek 44634 3080 Radiocarbon years BP
Roberts Creek 44635 3530 Radiocarbon years BP
Roberts Creek 44636 4175 Radiocarbon years BP

15.7 geochronology

This table stores geochronologic data.

Details

Geochronologic measurements are from geochronologic samples, which are from Analysis Units, which may have a depth and thickness. Geochronologic measurements may be from the same or different Analysis Units as fossils. In the case of faunal excavations, geochronologic samples are typically from the same Analysis Units as the fossils, and there may be multiple geochronologic samples from a single Analysis Unit. In the case of cores used for microfossil analyses, geochronologic samples are often from separate analysisunits; dated core sections are often thicker than microfossil Analysis Units.

  • geochronid (primary key): An arbitrary Geochronologic identificantion number.
  • sampleid (foreign key): Sample identification number. Field links to samples table.
  • geochrontypeid (foreign key): identification number for the type of geochronologic analysis, e.g. «carbon-14», thermoluminescence. Field links to the geochrontypes table.
  • agetypeid (foreign key): Identification number for the age units, e.g. «Radiocarbon years BP», «Calibrated radiocarbon years BP».
  • age: Reported age value of the geochronologic measurement.
  • errorolder: The older error limit of the age value. For a date reported with ±1 SD or σ, the ErrorOlder and ErrorYounger values are this value.
  • erroryounger: The younger error limit of the age value.
  • infinite**: is **true** for and infinite or "greater than" geochronologic measurement, otherwise is **false.
  • delta13c: The measured or assumed δ13C value for radiocarbon dates, if provided. Radiocarbon dates are assumed to be normalized to δ13C, and if uncorrected and normalized ages are reported, the normalized age should be entered in the database.
  • labnumber: Lab number for the geochronologic measurement.
  • material dated: Material analyzed for a geochronologic measurement.
  • notes: Free form notes or comments about the geochronologic measurement.

15.7.1 SQL Example

This query lists the geochronologic data for Montezuma Well.

SELECT au.depth,
       au.thickness, 
       gct.geochrontype,
       gc.age,
       gc.errorolder,
       gc.erroryounger,
       gc.delta13c,
       gc.labnumber,
       gc.materialdated,
       gc.notes
FROM ndb.sites AS st
INNER JOIN ndb.collectionunits AS cu ON cu.siteid = st.siteid
INNER JOIN ndb.analysisunits AS au ON au.collectionunitid = cu.collectionunitid
INNER JOIN ndb.samples AS smp ON smp.analysisunitid = au.analysisunitid
INNER JOIN ndb.geochronology AS gc on gc.sampleid = smp.sampleid
INNER JOIN ndb.geochrontypes AS gct ON gct.geochrontypeid = gc.geochrontypeid
WHERE st.sitename ='Montezuma Well'
ORDER BY au.depth;
Table 15.5: 8 records
depth thickness geochrontype age errorolder erroryounger delta13c labnumber materialdated notes
225 10 Carbon-14 1526 50 50 NA AA-2450 charcoal, wood NA
330 10 Carbon-14 2885 60 60 NA AA-2451 charcoal, wood NA
395 10 Carbon-14 5540 60 60 NA AA-4693 charcoal, wood NA
465 10 Carbon-14 8003 70 70 NA AA-2452 Scirpus achenes NA
535 10 Carbon-14 14950 350 320 -26.7 A-4732 bark Davis and Shafer (1992) reject as too old.
887 1 Carbon-14 24910 370 370 NA AA-5053 wood Davis and Shafer (1992) reject as too old.
887 1 Carbon-14 9520 200 200 -25.3 A-4733 wood NA
1015 1 Carbon-14 10975 95 95 NA AA-4694 Juniperus twig NA