View/edit a column - NALMA

TimeScaleCreator displays data in columns, as selected in the Choose Columns pane of TSC settings. This page allows selection of a column and review of metadata on it. It also displays the content of the column.

Select Column and time interval

select dataset & columntime intervalcm/Ma
Dataset:Top stage/age:
Column: Base stage/age:

Mode: View is selected - change to edit mode if you want to edit the metadata

Column metadata

Name: column id:175
dataset: mammals North America (dataset id: 48)
column_type:pointdata_table:
Column properties:Width:   Colour:
Field for labels/data:source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:
Path:

Column References ↑

Dataset References ↑

select * from arkL_refs as r left join arkL_reflinks as l on r.refno=l.refno where (l.dbase='arkL_datasets' and l.dbase_id=48) order by abv_ref, disambig

Hilgen, F. J., Lourens, L. J. & Van Dam, J. A. (2012). The Neogene Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg (Coordinators), G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 409-440. gs

Speijer, R. P., et al. (2020). Chapter 28 - The Paleogene Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 2: 1087-1140. gs

Woodburne, M. O. (2004). Late Cretaceous and Cenozoic Mammals of North America: Biostratigraphy and Geochronology. New York: Columbia University Press. 1-376. gs

Interval Data selection query
select i.id,i.intervalx,i.has_added_abv,i.block_label,i.base_age,i.top_age,i.colour,i.polarity,i.stage,e.event_display,e.age from arkL_intervals as i left join arkL_events as e on i.base_id=e.id where i.column_id=175 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 23 intervals in the NALMA column of the mammals North America dataset (id=48)
They range in age from 0.0001 Ma (Lt. Pleist. ("Tarantian")) to 84.9007 Ma (Campanian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
5289RancholabreanRancholabrean0.00010.1933Lt. Pleist. ("Tarantian")
5290IrvingtonianIrvingtonian0.19331.9250Calabrian
5291BlancanBlancan1.92504.9061Piacenzian
5292HemphilianHemphilian4.90619.0716Messinian
5293ClarendonianClarendonian9.071612.5654Tortonian
5294BarstovianBarstovian12.565415.9940Langhian
5295HemingfordianHemingfordian15.994018.4725Burdigalian
5296ArikareeanArikareean18.472529.7485Chattian
5297WhitneyanWhitneyan29.748532.0955Rupelian
5298OrellanOrellan32.095533.9049Rupelian
5299ChadronianChadronian33.904937.3850Priabonian
5300DuchesneanDuchesnean37.385041.1050Bartonian
5301UintanUintan41.105047.5312Lutetian
5302BridgerianBridgerian47.531252.0096Ypresian
5303WasatchianWasatchian52.009656.0010Ypresian
5304ClarkforkianClarkforkian56.001057.2398Thanetian
5305TiffanianTiffanian57.239862.2780Selandian
5306TorrejonianTorrejonian62.278064.7535Danian
5307PuercanPuercan64.753566.0400Danian
3440Lancian NALMAzoneLancian NALMAzone66.040071.2330Maastrichtian
3441"Edmontonian" NALMAzone"Edmontonian" NALMAzone71.233080.9412Campanian
3442Judithian NALMAzoneJudithian NALMAzone80.941281.9825Campanian
3443Aquilan NALMAzoneAquilan NALMAzone81.982584.9007Campanian

Column mock-up

This column mock-up plot is a simple plot of the data to allow visual comparaison with the output from TimeScale Creator. For interval tables the defining events are also shown

The data plotted here is the NALMA column from the mammals North America dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma