View/edit a column - German Triassic Series [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.

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:489
dataset: strat - German Triassic (dataset id: 79)
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=79) order by abv_ref, disambig

Feist-Burkhardt, S., et al. (2008). Triassic. In, McCann, T. (ed.) The Geology of Central Europe. Vol. 2: Mesozoic and Cenozoic. London: The Geological Society 749-821. gs

Kozur, H. W. & Weems, R. E. (2010). The biostratigraphic importance of conchostracans in the continental Triassic of the northern hemisphere. In, Lucas, S. G. (ed.) The Triassic Timescale. Geological Society of London, Special Publications . 334: 315-417. gs

Menning, M., et al. (2005). Zeitskala für Perm und Trias in der Stratigraphischen Tabelle von Deutschland 2002. Zyklostratigraphische Kalibrierung von höherer Dyas und Germanischer Trias und das Alter der Stufen Roadium bis Rhaetium 2005. In, Menning M. , Hendrich, A. (ed.) Erläuterungen zur Stratigraphischen Tabelle von Deutschland. Newsletters of Stratigraphy . 41(1-3): 173-210. 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=489 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 12 intervals in the German Triassic Series [stages] column of the strat - German Triassic dataset (id=79)
They range in age from 199.4600 Ma (Hettangian) to 263.3410 Ma (Capitanian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
7048LiasLias199.4600201.3600Hettangian
7049Upper KeuperUpper Keuper201.3600209.5130Rhaetian
7050Middle Keuper (Gipskeuper)Middle Keuper (Gipskeuper)209.5130238.3779Norian
7051Lower KeuperLower Keuper238.3779239.4800Ladinian
7053Upper MuschelkalkUpper Muschelkalk239.4800242.5285Ladinian
7054Middle MuschelkalkMiddle Muschelkalk242.5285243.4285Anisian
7055Lower MuschelkalkLower Muschelkalk243.4285245.5900Anisian
7056Upper BuntsandsteinUpper Buntsandstein245.5900246.7900Anisian
7058Middle BuntsandsteinMiddle Buntsandstein246.7900250.1900Olenekian
7059Lower BuntsandsteinLower Buntsandstein250.1900251.8300Induan
10825Zechstein DeLZechstein DeL251.8300256.7470Wuchiapingian
10824RotliegendRotliegend256.7470263.3410Capitanian

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 German Triassic Series [stages] column from the strat - German Triassic dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma