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:		ELMA column id:162
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=162 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 19 intervals in the ELMA column of the mammals Europe dataset (id=61)
They range in age from 0.0001 Ma (Chibanian) to 57.7212 Ma (Thanetian)

id	intervalx	TSC label	top_age	base_age	stage
5371	Aurelian	Aurelian	0.0001	0.6000	Chibanian
5372	Galerian	Galerian	0.6000	1.0700	Calabrian
5373	Biharian	Biharian	1.0700	2.0000	Calabrian
5374	Villafranchian	Villafranchian	2.0000	3.6000	Piacenzian
5375	Ruscinian	Ruscinian	3.6000	5.3350	Zanclean
5376	Turolian	Turolian	5.3350	8.9000	Messinian
5377	Vallesian	Vallesian	8.9000	11.2000	Tortonian
5378	Astaracian	Astaracian	11.2000	14.2000	Serravallian
5379	Orleanian	Orleanian	14.2000	17.2000	Langhian
5380	Ramblian	Ramblian	17.2000	19.5000	Burdigalian
5381	Agenian	Agenian	19.5000	23.0400	Aquitanian
5382	Arvernian	Arvernian	23.0400	28.8210	Chattian
5383	Suevian	Suevian	28.8210	33.7948	Rupelian
5384	Headonian	Headonian	33.7948	37.3850	Priabonian
5385	Robiacian	Robiacian	37.3850	43.4500	Bartonian
5386	Geiseltalian	Geiseltalian	43.4500	48.0000	Lutetian
5387	Grauvian	Grauvian	48.0000	50.5248	Ypresian
5388	Neustrian	Neustrian	50.5248	56.1010	Ypresian
5389	Cernaysian	Cernaysian	56.1010	57.7212	Thanetian

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