View/edit a column - Calpionellid 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:58
dataset: calpionellids (dataset id: 5)
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=5) order by abv_ref, disambig

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

Remane, J. (1998). Calpionellids. Columns for Jurassic chart of Mesozoic and Cenozoic sequence chronostratigraphic framework of European basins, by Hardenbol, J., Thierry, J., Farley, M.B., Jacquin, T., de Graciansky, P.-C., and Vail, P.R. (coordinators). 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: 763-781. gs

Wimbledon, W. A. P. (2017). Developments with fixing a Tithonian/ Berriasian (J/K) boundary. Volumina Jurassica. 15: 181-186. 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=58 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 10 intervals in the Calpionellid Zone column of the calpionellids dataset (id=5)
They range in age from 135.5504 Ma (Valanginian) to 146.5797 Ma (Berriasian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
3828E calpionellidZoneyesE135.5504137.7000Valanginian
3829D3 calpionellidZoneyesD3137.7000138.4840Berriasian
3830D2 calpionellidZoneyesD2138.4840138.7712Berriasian
3831D1 calpionellidZoneyesD1138.7712139.9200Berriasian
3832C calpionellidZoneyesC139.9200140.6200Berriasian
15970B calpionellidZoneyesB140.6200143.1000Berriasian
3841A3 calpionellidZoneyesA3143.1000143.9230Tithonian
3834A2 calpionellidZoneyesA2143.9230144.1314Tithonian
3833A1 calpionellidZoneyesA1144.1314144.5596Tithonian
15971Chit. calpionellidZoneyesChit.144.5596146.5797Berriasian

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 Calpionellid Zone Abbrev. column from the calpionellids dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma