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:80
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=80 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 16 intervals in the Eon column of the chronostratigraphy dataset (id=1)
They range in age from 0.0118 Ma (Lt. Pleist. ("Tarantian")) to 66.0400 Ma (Danian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
4261Late PleistoceneLt0.01180.1300Lt. Pleist. ("Tarantian")
4262Middle PleistoceneM0.13000.7730Chibanian
4263Early PleistoceneE0.77302.5800Calabrian
4264Late PlioceneLt2.58003.6000Piacenzian
4265Early PlioceneE3.60005.3350Zanclean
4266Late MioceneLt5.335011.6250Tortonian
4267Middle MioceneM11.625015.9940Serravallian
4268Early MioceneE15.994023.0400Burdigalian
4269Late OligoceneLt23.040027.2861Chattian
4270Early OligoceneE27.286133.9049Rupelian
4271Late EoceneLt33.904937.7100Priabonian
4272Middle EoceneM37.710048.0680Lutetian
4273Early EoceneE48.068056.0010Ypresian
4274Late PaleoceneLt56.001059.2370Thanetian
4275Middle PaleoceneM59.237061.6630Selandian
4276Early PaleoceneE61.663066.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 Sub-Epoch column from the chronostratigraphy dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma