View/edit a column - NW Europe Belemnite 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:26
dataset: belemnites Boreal (dataset id: 20)
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=20) order by abv_ref, disambig

Groupe Francais dEtude du Jurassique, (1997). Biostratigraphie du Jurassique ouest-européen et méditerranéen: zonations parallèles et distribution des invertébrés et microfossiles. Bulletin des Centres de Recherches Exploration- Production Elf-Aquitaine,. Mémoire 17: 1-422. gs

Hardenbol, J., et al. (1998). Mesozoic and Cenozoic Sequence Chronostratigraphic Framework of European Basins. In, de Graciansky, P. -C. , Hardenbol, J. , Jacquin, T. , and Vail, P. R. (ed.) Mesozoic- Cenozoic Sequence Stratigraphy of European Basins. SEPM Special Publication . 60: 3-13 & appendix 763-783. 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=26 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 14 intervals in the NW Europe Belemnite Zone column of the belemnites Boreal dataset (id=20)
They range in age from 143.2615 Ma (Tithonian) to 199.4600 Ma (Sinemurian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
2179Pachyteuthis lateralis BBelsZyesPachyteuthis lateralis143.2615146.7665Tithonian
2180Rhopaloteuthis gillieroni and Hibolites semihastatus BBelsZyesRhopaloteuthis gillieroni and Hibolites semihastatus161.5301162.6309Callovian
2181Dicoelites meyrati BBelsZyesDicoelites meyrati163.4719165.2900Callovian
2182Duvalia disputabilis and Belemnopsis fusiformis BBelsZyesDuvalia disputabilis and Belemnopsis fusiformis166.2036168.1690Bathonian
2183Belemnopsis apiciconus BBelsZyesBelemnopsis apiciconus168.1690170.0870Bajocian
2184Eocylindroteuthis trauscholdi BBelsZyesEocylindroteuthis trauscholdi170.2032170.9000Bajocian
2185Belemnopsis brevicanalis BBelsZyesBelemnopsis brevicanalis171.9000172.7000Aalenian
2186Acrocoelites bobeti BBelsZyesAcrocoelites bobeti172.7000177.2888Toarcian
2187Acrocoelites striolatus BBelsZyesAcrocoelites striolatus179.8244181.1677Toarcian
2188Acrocoelites trisulculosus BBelsZyesAcrocoelites trisulculosus181.1677183.1589Toarcian
2189Passaloteuthis apicicurvatus BBelsZyesPassaloteuthis apicicurvatus188.0001190.2001Pliensbachian
2190Coeloteuthis dens and Coeloteuthis excavatus BBelsZyesCoeloteuthis dens and Coeloteuthis excavatus190.2001192.9001Pliensbachian
2191Nannobelus oppeli BBelsZyesNannobelus oppeli192.9001196.3150Sinemurian
2192Nannobelus acutus BBelsZyesNannobelus acutus196.3150199.4600Sinemurian

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 NW Europe Belemnite subzone (Jur.) column from the belemnites Boreal dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma