arkL column viewer

arkL

View/edit a column - Carbon - 13 excursions (GTS2020)

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:		C-segments (Italy) column id:431
dataset:		Carbon-13 events (dataset id: 68)
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/Other 13C episodes - Cambrian, Silurian-Devonian; Aptian/Aptian 13C stage intervals

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

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

Column content

There are 9 intervals in the Carbon - 13 excursions (GTS2020) column of the Carbon-13 events dataset (id=68)
They range in age from 111.3560 Ma (Albian) to 120.8523 Ma (Aptian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
16192	C11 MidCretC13intv	yes	C11	111.3560	113.6517	Albian
16191	C10 MidCretC13intv	yes	C10	113.6517	116.6004	Aptian
16190	C9 MidCretC13intv	yes	C9	116.6004	116.7752	Aptian
16189	C8 MidCretC13intv	yes	C8	116.7752	118.3928	Aptian
16188	C7 MidCretC13intv	yes	C7	118.3928	119.3623	Aptian
16187	C6 MidCretC13intv	yes	C6	119.3623	119.9680	Aptian
16186	C5 MidCretC13intv	yes	C5	119.9680	120.5156	Aptian
16185	C3-C4 MidCretC13intv	yes	C3-C4	120.5156	120.6490	Aptian
16184	C2 MidCretC13intv	yes	C2	120.6490	120.8523	Aptian

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 C-segments (Italy) column from the Carbon-13 events dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma