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

Column content


There are 30 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
15901Lias alpha-1 Fm. DeLyesLias alpha-1 Fm.199.4600201.3600Hettangian
7060Exter Fm. DeLyesExter Fm.201.3600209.5130Rhaetian
7061Arnstadt Fm. or Loewenstein Fm. DeLyesArnstadt Fm. or Loewenstein Fm.209.5130226.0212Norian
7062Weser Fm. DeLyesWeser Fm.226.0212233.3638Carnian
7063Stuttgart Fm. (Schilfsandstein) DeLyesStuttgart Fm. (Schilfsandstein)233.3638234.3000Carnian
7064Grabfeld Fm. DeLyesGrabfeld Fm.234.3000238.3779Carnian
7065Erfurt Fm. (Lettenkeuper) DeLyesErfurt Fm. (Lettenkeuper)238.3779239.2800Ladinian
7066Warburg Fm. DeLyesWarburg Fm.239.4800241.4600Ladinian
7067Meissner Fm. DeLyesMeissner Fm.241.4600242.0205Anisian
7068Trochitenkalk Fm. DeLyesTrochitenkalk Fm.242.0205242.5285Anisian
7069Diemel Fm. DeLyesDiemel Fm.242.5285242.6285Anisian
7070Heilbronn Fm. DeLyesHeilbronn Fm.242.6285243.3285Anisian
7071Karlstadt Fm. DeLyesKarlstadt Fm.243.3285243.4285Anisian
7072Jena Fm. DeLyesJena Fm.243.4285245.5900Anisian
7073Röt DeLyesRöt245.5900246.7900Anisian
7074Solling DeLyesSolling246.7900247.1900Olenekian
7075Hardegsen DeLyesHardegsen247.1900248.5900Olenekian
7076Detfurth DeLyesDetfurth248.5900248.9900Olenekian
7077Volpriehausen DeLyesVolpriehausen248.9900250.1900Olenekian
7078Bemburg DeLyesBemburg250.1900250.8300Induan
7079Calvorde DeLyesCalvorde250.8300251.8300Induan
7080Fulda DeLyesFulda251.8300252.0300Changhsingian
7081Friesland DeLyesFriesland252.0300252.1300Changhsingian
7082Ohr DeLyesOhr252.1300252.3300Changhsingian
7083Aller DeLyesAller252.3300252.7000Changhsingian
10830Leine DeLyesLeine252.7000253.9470Changhsingian
10829Strassfurt DeLyesStrassfurt253.9470254.7470Wuchiapingian
10828Werra DeLyesWerra254.7470256.7470Wuchiapingian
10827Elbe DeLyesElbe256.7470262.3470Capitanian
10826Havel DeLyesHavel262.3470263.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 Facies Label [formations] column from the strat - German Triassic dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma