View/edit a column - all events

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:155
dataset: mammals Asia & China (dataset id: 62)
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=62) 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

Wang, Y., et al. (2019e). Paleogene integrative stratigraphy and timescale of China. Science in China. Series D Earth Sciences 62: 1-23. 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=155 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 16 intervals in the all events column of the mammals Asia dataset (id=)
They range in age from 2.0000 Ma (Piacenzian) to 66.0400 Ma (Danian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
5452YusheanYushean2.00005.0350Piacenzian
5453BaodeanBaodean5.035011.2000Tortonian
5454TunggurianTunggurian11.200013.8000Serravallian
5455ShanwangianShanwangian13.800019.5000Burdigalian
5456XiejianXiejian19.500023.0400Aquitanian
5457TabenbulukianTabenbulukian23.040025.7138Chattian
5458HsandagolianHsandagolian25.713833.2140Rupelian
5459ErgilianErgilian33.214036.5730Priabonian
5460UlangochuanUlangochuan36.573039.6660Bartonian
5461SharamurunianSharamurunian39.666041.6880Bartonian
5462IrdinmanhanIrdinmanhan41.688045.3995Lutetian
5463ArshantanArshantan45.399552.0504Ypresian
5464BumbanianBumbanian52.050456.0010Ypresian
5465GashatanGashatan56.001059.0980Thanetian
5466NongshanianNongshanian59.098062.2780Selandian
5467ShanghuanShanghuan62.278066.0400Danian

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 ALMA column from the mammals Asia dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma