arkL column viewer

arkL

View/edit a column - ELMA

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:		Other European mammal zones column id:168
dataset:		mammals Europe (dataset id: 61)
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:		Vertebrates (Land and Marine)/Mammals/Europe Mammals

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

Hilgen, F. J., Lourens, L. J. & Van Dam, J. A. (2012). The Neogene Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg (Coordinators), G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 409-440. gs

Speijer, R. P., et al. (2020). Chapter 28 - The Paleogene 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: 1087-1140. 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=168 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 16 intervals in the ELMA column of the mammals Europe dataset (id=61)
They range in age from 33.7948 Ma (Rupelian) to 66.0400 Ma (Danian)

id	intervalx	TSC label	top_age	base_age	stage
5435	sue-fro	sue-fro	33.7948	33.9049	Rupelian
5436	medium-curtum	medium-curtum	33.9049	35.1020	Priabonian
5437	pseudo-thaleri	pseudo-thaleri	35.4580	35.9644	Priabonian
5438	vect-nanus	vect-nanus	36.2644	36.8978	Priabonian
5439	ste-dep	ste-dep	36.8978	37.3850	Priabonian
5440	lautricense -siderolithicum CRZ	lautricense -siderolithicum CRZ	37.3850	40.5037	Bartonian
5441	eocaenum - rhinocerodes CRZ	eocaenum - rhinocerodes CRZ	40.5037	44.7868	Lutetian
5442	PE V	PE V	50.5248	51.8056	Ypresian
5443	PE IV	PE IV	52.0912	53.9960	Ypresian
5444	PE III	PE III	54.5402	55.5005	Ypresian
5445	PE II	PE II	55.5005	56.0010	Ypresian
5446	PE I	PE I	56.0010	56.1010	Thanetian
5447	Walbeck LF	Walbeck LF	59.2370	60.1493	Selandian
5448	Menat LF	Menat LF	60.7575	61.8218	Selandian
5449	Hainin LF	Hainin LF	62.3284	63.1846	Danian
5450	Fontllonga 3 LF	Fontllonga 3 LF	65.8360	66.0400	Danian

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 Other European mammal zones column from the mammals Europe dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma