View/edit a column - Eon

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:78
dataset: chronostratigraphy (dataset id: 1)
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=1) order by abv_ref, disambig

Davydov, V. I., Wardlaw, B. R. & Gradstein, F. M. (2004). The Carboniferous Period. In, Gradstein, F. M. , Ogg, J. G. , and Smith, A. G. (ed.) A Geologic Time Scale 2004. Cambridge: Cambridge University Press 222-248. gs

Davydov, V. I., et al. (2012). Chapter 23 the Carboniferous Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 603-651. gs

Gale, A. S., Mutterlose, J. & Batenburg, S. (2020). Chapter 27 - The Cretaceous 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: 1023-1086. gs

Gale, A. S., et al. (2020). Chapter 3E - Ammonoidea. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 1: 61-68. 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=78 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 38 intervals in the Eon column of the chronostratigraphy dataset (id=1)
They range in age from 0.0001 Ma (Holocene) to 538.8000 Ma (Fortunian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
4254Holocene EpochHolocene Epoch0.00010.0118Holocene
4255PleistocenePleistocene0.01182.5800Calabrian
4256PliocenePliocene2.58005.3350Zanclean
4257MioceneMiocene5.335023.0400Langhian
4258OligoceneOligocene23.040033.9049Rupelian
4259EoceneEocene33.904956.0010Lutetian
4260PaleocenePaleocene56.001066.0400Selandian
2595Late CretaceousLate66.0400100.5000Campanian
2596Early CretaceousEarly100.5000143.1000Barremian
12Late JurassicLate143.1000161.5301Kimmeridgian
25Middle JurassicMiddle161.5301174.7000Bathonian
41Early JurassicEarly174.7000201.3600Pliensbachian
6375Late TriassicLate201.3600237.0000Norian
6376Middle TriassicMiddle237.0000246.7000Anisian
6377Early TriassicEarly246.7000251.9000Olenekian
8904LopingianLopingian251.9000259.5470Wuchiapingian
8903GuadalupianGuadalupian259.5470274.3700Wordian
8902CisuralianCisuralian274.3700298.8900Artinskian
8901Late PennsylvanianLate Penn.298.8900307.0200Gzhelian
8900Middle PennsylvanianMiddle Penn.307.0200315.1500Moscovian
8899Early PennsylvanianEarly Penn.315.1500323.4000Bashkirian
8898Late MississippianLate Miss.323.4000330.3400Serpukhovian
8897Middle MississippianMiddle Miss.330.3400346.7300Visean
8896Early MississippianEarly Miss.346.7300359.3000Tournaisian
12793Late DevonianLate359.3000378.9000Famennian
12792Middle DevonianMiddle378.9000394.3000Eifelian
12791Early DevonianEarly394.3000419.0011Emsian
14346PridoliPridoli419.0011422.7337[Pridoli]
14345LudlowLudlow422.7337426.7378Ludfordian
14344WenlockWenlock426.7378432.9326Homerian
14343LlandoveryLlandovery432.9326443.0718Telychian
14342Late OrdovicianLate Ordovician443.0718458.1772Katian
14341Middle OrdovicianMiddle Ordovician458.1772471.2633Darriwilian
14340Early OrdovicianEarly Ordovician471.2633486.8500Tremadocian
15089FurongianFurongian486.8500497.0000Jiangshanian
15088MiaolingianMiaolingian497.0000509.0000Drumian
15087Epoch 2Epoch 2509.0000521.0000Stage 3
15086TerreneuvianTerreneuvian521.0000538.8000Fortunian

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