arkL column viewer

arkL

View/edit a column - Period

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:		Period column id:74
dataset:		chronostratigraphy (dataset id: 1)
column_type:
interval_type:
sub_columnE:
Column properties:		Width: Colour:
Column for labels:
Compilation notes:
Subdataset:
Colshare Subdatasets:		colshare:
Path:		Standard Chronostratigraphy

Interval Data selection query:
select i.*,e.event_display from arkL_intervals as i left join arkL_events as e on i.base_id=e.id where i.column_id=74 and base_age<= 700 and top_age >= 0 order by base_age, top_age

Column content

There are 9 intervals in the Period column of the chronostratigraphy dataset (id=1)
They range in age from 0.0002 Ma (Calabrian) to 419.0000 Ma (Eifelian)
COLTYPEintervals - coloured

249,249,127255,230,25253,154,82127,198,7852,178,201129,43,146240,64,40103,165,153215,136,35

id	intervalx	TSC label	top_age	base_age	stage	colour
4251	Quaternary	Quaternary	0.0002	2.5800	Calabrian	249/249/127
4252	Neogene	Neogene	2.5800	23.0400	Serravallian	255/230/25
4253	Paleogene	Paleogene	23.0400	66.0400	Lutetian	253/154/82
1	Cretaceous	Cretaceous	66.0400	143.1000	Albian	127/198/78
42	Jurassic	Jurassic	143.1000	201.3600	Aalenian	52/178/201
6374	Triassic	Triassic	201.3600	251.9000	Norian	129/43/146
8893	Permian	Permian	251.9000	298.8900	Kungurian	240/64/40
8892	Carboniferous	Carboniferous	298.8900	359.3000	Serpukhovian	103/165/153
12790	Devonian	Devonian	359.3000	419.0000	Eifelian	215/136/35

Subdataset References ↑

Dataset References ↑

Gale, A. S. (2016). Roveacrinida (Crinoidea, Articulata) from the Santonian-Maastrichtian (Upper Cretaceous) of England, the US Gulf Coast (Texas, Mississippi) and southern Sweden. Papers in Palaeontology. 2(20130127): -. 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

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

The data plotted here is the Period column from the chronostratigraphy dataset for the interval 0 - 700 Ma