View/edit a column - Devonian crisis episodes

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:206
dataset: anoxic episodes (dataset id: 108)
column_type:pointdata_table:
Column properties:Width:   Colour:
Field for labels/data:source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:Becker et al. 2012;Becker et al. 2020;
Path:

Column References ↑

Becker, R. T., Gradstein, F. M. & Hammer, O. (2012). The Devonian Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 2: 559-601. gs

Becker, R. T, Marshall, J. E. & Da Silva, A. -C. (2020). Chapter 22 The Devonian 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: 733-810. gs

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=108) order by abv_ref, disambig

Gale, A. S. (2020). Chapter 3K - Cretaceous microcrinoids. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 1: 122-124. gs

Jenkyns, H. C., et al. (2002). Chemostratigraphy of the Jurassic System: applications, limitations and implications for palaeoceanography. Journal of the Geological Society of London. 159: 351-378. 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=206 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 7 intervals in the Devonian crisis episodes column of the anoxic episodes dataset (id=108)
They range in age from 359.1114 Ma (Famennian) to 412.5000 Ma (Lochkovian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
13683Hangenberg CrisisHangenberg Crisis359.1114360.8930Famennian
13682Dasberg crisisDasberg crisis362.6920362.8282Famennian
13681Condroz eventsCondroz events367.9671368.4450Famennian
13680Kellwasser CrisisKellwasser Crisis371.1000372.4260Frasnian
13679Frasnes CrisisFrasnes Crisis378.0420379.1560Frasnian
13678Taghanic CrisisTaghanic Crisis380.1800381.2488Givetian
13677Lochkovian-Pragian boundary EventLochkovian-Pragian boundary Event412.3000412.5000Lochkovian

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