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 Europe events column id:173
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

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

Column content

Within the selected interval there are 9 events in the ELMA column of the mammals Europe dataset (id=61)
They range in age from 29.97 Ma (Rupelian) to 39.2562 Ma (Bartonian)

id	eventx	has_added_abvE	event_type	TSC label	age	stage
8066	FADeu Soricidae	-	FAD	FADeu Soricidae	29.97	Rupelian
8072	LADeu Bothriodon	-	LAD	LADeu Bothriodon	32.7666	Rupelian
8074	FADeu Bothriodon	-	FAD	FADeu Bothriodon	33.4188	Rupelian
8084	LADeu Lophiotherium, Quercygale	-	LAD	LADeu Lophiotherium, Quercygale	36.8978	Priabonian
8085	FADeu Talpidae, Anthracotheriidae	-	FAD	FADeu Talpidae, Anthracotheriidae	37.385	Priabonian
8088	LADeu Pseudoltinomys cosetanus	-	LAD	LADeu Pseudoltinomys cosetanus	38.3206	Bartonian
8089	FADeu Palaeotherium castrense robiacense	-	FAD	FADeu Palaeotherium castrense robiacense	38.6325	Bartonian
8090	FADeu Cainotheriidae	-	FAD	FADeu Cainotheriidae	38.6325	Bartonian
8091	FADeu Leptolophus stehlini	-	FAD	FADeu Leptolophus stehlini	39.2562	Bartonian

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