arkL column viewer

arkL

View/edit a column - Central Paratethys stages

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:		Central Paratethys stages column id:68
dataset:		stages Paratethys (Neogene) (dataset id: 66)
column_type:		pointdata_table:
Column properties:		Width: Colour:
Field for labels/data:		source_col id:
TSC notes:
Compilation notes:		dd
refs to add:
linked refs:
Path:		Regional Stages/European regional units/Paratethyan Stages/Central Paratethys

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=66) 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

Raffi, I., Wade, B. S. & Pälike, H. (2020). Chapter 29 - The Neogene 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: 1141-1217. 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=68 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 8 intervals in the Central Paratethys stages column of the stages Paratethys (Neogene) dataset (id=66)
They range in age from 1.8000 Ma (Piacenzian) to 24.8899 Ma (Chattian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
6163	Paludina beds CentralParatethys	yes	Paludina beds	1.8000	4.7000	Piacenzian
6164	Pannonian (s.l.) CentralParatethys	yes	Pannonian (s.l.)	4.7000	11.6250	Tortonian
6165	Sarmatian (s.str.) CentralParatethys	yes	Sarmatian (s.str.)	11.6250	12.6500	Serravallian
6166	Badenian CentralParatethys	yes	Badenian	12.6500	15.9940	Langhian
6167	Karpatian CentralParatethys	yes	Karpatian	15.9940	17.3046	Burdigalian
6168	Ottnangian CentralParatethys	yes	Ottnangian	17.3046	18.2030	Burdigalian
6169	Eggenburgian CentralParatethys	yes	Eggenburgian	18.2030	21.4800	Burdigalian
6170	Egerian CentralParatethys	yes	Egerian	21.4800	24.8899	Chattian

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 Central Paratethys stages column from the stages Paratethys (Neogene) dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma