arkL column viewer

arkL

View/edit a column - Cenogrid cold MIS

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:		Cenogrid C13 events column id:511
dataset:		Cenogrid - Westerhold2020 (dataset id: 127)
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)/Cenogrid

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

Westerhold, T., et al. (2020). An astronomically dated record of Earth’s climate and its predictability over the last 66 million years. Science. 369: 1383-1387. gs

Data selection query:
select * from arkL_events where column_id=511 AND age > 0 and age < 700 order by age

Column content

Within the selected interval there are 10 events in the Cenogrid cold MIS column of the Cenogrid - Westerhold2020 dataset (id=127)
They range in age from 34.6988 Ma (Priabonian) to 66.146 Ma (Maastrichtian)

id	eventx	has_added_abvE	event_type	TSC label	age	stage
14619	Peak-MECO CIE C13event	yes	-	Peak-MECO CIE	34.6988	Priabonian
14620	LLTM C13event	yes	-	LLTM	35.2601	Priabonian
14621	X-event (ETM-3) C13event	yes	-	X-event (ETM-3)	52.9025	Ypresian
14622	ELMO (ETM-2) C13event	yes	-	ELMO (ETM-2)	53.9114	Ypresian
14623	PETM excursion C13event	yes	-	PETM excursion	55.9954	Ypresian
14624	PCIM peak C13event	yes	-	PCIM peak	57.859	Thanetian
14625	Mid-Paleocene biotic turnover C13event	yes	-	Mid-Paleocene biotic turnover	59.2499	Selandian
14626	Top C27n event C13event	yes	-	Top C27n event	62.2959	Danian
14627	Dan-C2 C13event	yes	-	Dan-C2	65.7429	Danian
14628	K/Pg Event C13event	yes	-	K/Pg Event	66.146	Maastrichtian

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 Cenogrid C13 events column from the Cenogrid - Westerhold2020 dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma