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.

Select Column and time interval

select dataset & columntime intervalcm/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: column id:218
dataset: bivalves Triassic (dataset id: 86)
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:

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

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=218 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 17 intervals in the West Tethys bivalve zone column of the bivalves Triassic dataset (id=86)
They range in age from 209.5130 Ma (Norian) to 250.8455 Ma (Induan)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
8629Monotis subcircularis NAmbivZyesMonotis subcircularis209.5130212.9023Norian
8628Emonotis pinensis NAmbivZyesEmonotis pinensis212.9023216.2355Norian
8627Halobia halorica NAmbivZyesHalobia halorica216.2355217.6778Norian
8626Halobia cordillerana NAmbivZyesHalobia cordillerana217.6778224.6205Norian
8625Halobia beyrichi NAmbivZyesHalobia beyrichi224.6205227.3000Norian
8624Halobia radiata NAmbivZyesHalobia radiata227.3000228.5285Carnian
8623Halobia superba NAmbivZyesHalobia superba228.5285232.2770Carnian
8622Halobia rugosa NAmbivZyesHalobia rugosa232.2770234.4000Carnian
8621Halobia NAmbivZyesHalobia234.4000237.0000Carnian
8620Daonella elegans NAmbivZyesDaonella elegans237.0000238.2896Ladinian
8619Daonella reiberi NAmbivZyesDaonella reiberi238.2896241.7700Ladinian
8618Daonella dubia NAmbivZyesDaonella dubia241.7700242.1739Anisian
8617Daonella cf. D. sturi NAmbivZyesDaonella cf. D. sturi242.1739242.3085Anisian
8616Daonella americana NAmbivZyesDaonella americana242.3085243.7836Anisian
8615Enteropleura jenksi NAmbivZyesEnteropleura jenksi243.7836244.2388Anisian
8614'Pseudomonotis' occidentalis NAmbivZyes'Pseudomonotis' occidentalis248.0958248.4325Olenekian
8613Claraia stachei NAmbivZyesClaraia stachei250.4955250.8455Induan

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 North America bivalve zone column from the bivalves Triassic dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma