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

Column content


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

idintervalx