arkL column viewer

arkL

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.

Columns which have not yet had data imported into this database are not shown.
Column colour is based on the dataset/subdataset so the options to change colour are given on the dataset page.
Most col names have been copied from TSC, to activate an existing column enter the dataset_id directly in the arkL_columns database
Once columns exist and are assigned to a datset they can be edited from this page
Events and intervals are not directly assigned to a column in the database instead the column metadata defines which events and intervals are selected

Select Column and time interval

select dataset & column		time interval		cm/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:		Series label (OAEs) column id:424
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:
Path:		Sequences, Sea-Level and Stable Isotopes/Stable Isotopes (0-18. C-13. Sr)/Carbon-13 curves and events/Anoxic Episodes (Jur-Cret; Silur-Devon)

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

Column content

There are 4 intervals in the Devonian crisis episodes column of the anoxic episodes dataset (id=108)
They range in age from 93.4767 Ma (Albian) to 444.0683 Ma (Sheinwoodian)

id	intervalx	TSC label	top_age	base_age	stage
16134	Cretaceous anoxic events	Cretaceous anoxic events	93.4767	127.1932	Albian
16133	Jurassic anoxic events	Jurassic anoxic events	182.6728	201.8681	Pliensbachian
16162	Devonian anoxic episodes	Devonian anoxic episodes	359.3000	407.0635	Givetian
16132	Biotic events (Silurian)	Biotic events (Silurian)	418.7223	444.0683	Sheinwoodian

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 Series label (OAEs) column from the anoxic episodes dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma