arkL column viewer

arkL

View/edit a column - West Tethys bivalve zone

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:		Triassic Bivalve Genera ranges column id:222
dataset:		bivalves Triassic (dataset id: 86)
column_type:		pointdata_table:
Column properties:		Width: Colour:
Field for labels/data:		source_col id:
TSC notes:		Ranges are from Chris Roberts, pers. commun., Aug 2007; for Triassic time scale special publication of 2010
Compilation notes:
refs to add:
linked refs:
Path:		Marine Macrofossils (Mesozoic-Paleozoic)/Other Marine and Lacustrine Macrofossils/Bivalves (Inoceramids, Pelecypods, etc.)/Triassic Bivalves

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

McRoberts, C. A. (2010). Biochronology of Triassic pelagic bivalves. In, Lucas, S. G. (ed.) The Triassic Timescale. Geological Society of London, Special Publications . 334: 201-219. gs

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

Column content

Within the selected interval there are 10 events in the West Tethys bivalve zone column of the bivalves Triassic dataset (id=86)
They range in age from 208.2901 Ma (Norian) to 251.9 Ma (Induan)

id	eventx	has_added_abvE	event_type	TSC label	age	stage
16271	Monotis	-	LAD	Monotis	208.2901	Norian
16270	Eomontis	-	LAD	Eomontis	209.513	Norian
16269	Monotis, Eomontis	-	FAD	Monotis, Eomontis	214.032	Norian
16267	Halobia	-	LAD	Halobia	214.9134	Norian
16268	Eomonotis	-	FAD	Eomonotis	214.9134	Norian
16266	Halobia, Otapiria	-	FAD	Halobia, Otapiria	237	Carnian
16265	Daonella	-	FAD	Daonella	243.7836	Anisian
16264	Enteropleura	-	FAD	Enteropleura	244.4249	Anisian
16263	Bositra	-	FAD	Bositra	249.875	Olenekian
16262	Claraia	-	FAD	Claraia	251.9	Induan

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 Triassic Bivalve Genera ranges column from the bivalves Triassic dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma