View/edit a column - Russian Platform ammonite zones

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:4
dataset: ammonites Russian Boreal (dataset id: 17)
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=17) 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

Jenks, J. F., et al. (2015). Chapter 13. Biostratigraphy of Triassic ammonoids. In, Klug, C. , Korn, D. , De Baets, K. , Kruta, I. , Mapes, R. H. (ed.) Ammonoid Paleobiology: From Macroevolution to Paleogeography. Topics in Geobiology . 44: 329-371. 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=4 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 30 intervals in the Russian Platform ammonite zones column of the ammonites Russian Boreal dataset (id=17)
They range in age from 142.4675 Ma (Berriasian) to 161.5301 Ma (Oxfordian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
1892Craspedites milkovensis RAsZyesCraspedites milkovensis142.4675142.9849Berriasian
1893Craspedites mosquensis RAsZyesCraspedites mosquensis142.9849143.5023Tithonian
1894Craspedites nekrassovi RAsZyesCraspedites nekrassovi143.8986144.0967Tithonian
1895Kachpurites fulgens RAsZyesKachpurites fulgens144.0967144.2948Tithonian
1896Epivirgatites nikitini RAsZyesEpivirgatites nikitini144.2948144.4642Tithonian
1897Epivirgatites bipliciformis RAsZyesEpivirgatites bipliciformis144.4642144.5913Tithonian
1898Epivirgatites lahuseni RAsZyesEpivirgatites lahuseni144.5913144.7183Tithonian
1899?Crasp. ivanovi RAsZyes?Crasp. ivanovi144.7183144.7965Tithonian
1900Virgatites virgatus RAsZyesVirgatites virgatus144.7965144.9139Tithonian
1901Virgatites gerassimovi RAsZyesVirgatites gerassimovi144.9139145.1095Tithonian
1902Zaraiskites zarajskensis RAsZyesZaraiskites zarajskensis145.1095145.9380Tithonian
1903P.tenuicostatum RAsZyesP.tenuicostatum145.9380147.0690Tithonian
1904Ilowaiskya pseudoscythica RAsZyesIlowaiskya pseudoscythica147.0690147.3715Tithonian
1905Amoeboceras modestum RAsZyesAmoeboceras modestum152.0351152.8690Kimmeridgian
1906Amoeboceras subkitchini RAsZyesAmoeboceras subkitchini152.8690153.7029Kimmeridgian
1907Amoeboceras rosenkrantzi RAsZyesAmoeboceras rosenkrantzi154.7780156.4470Oxfordian
1908Amoeboceras marstonense RAsZyesAmoeboceras marstonense156.4470156.6871Oxfordian
1909Amoeboceras serratum RAsZyesAmoeboceras serratum157.4266157.6499Oxfordian
1910Amoeboceras koldewayense RAsZyesAmoeboceras koldewayense157.6499157.7988Oxfordian
1911Amoeboceras glosense RAsZyesAmoeboceras glosense157.7988157.9476Oxfordian
1912Amoeboceras ilovaiskii RAsZyesAmoeboceras ilovaiskii157.9476158.0776Oxfordian
1913Cardioceras blakei RAsZyesCardioceras blakei158.0776158.2076Oxfordian
1914Cardioceras tenuiserratum RAsZyesCardioceras tenuiserratum158.2076158.3376Oxfordian
1915Cardioceras maltonense RAsZyesCardioceras maltonense158.3376158.7126Oxfordian
1916Cardioceras vertebrale RAsZyesCardioceras vertebrale158.7126159.0876Oxfordian
1917Cardioceras cordatum RAsZyesCardioceras cordatum159.0876159.2490Oxfordian
1918Cardioceras costicardia RAsZyesCardioceras costicardia159.2490159.4913Oxfordian
1919Cardioceras bukowski RAsZyesCardioceras bukowski159.4913159.6426Oxfordian
1920Cardioceras praecordatum RAsZyesCardioceras praecordatum159.6426160.7676Oxfordian
1921Cardioceras scarburgense RAsZyesCardioceras scarburgense160.7676161.5301Oxfordian

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 Russian Platform ammonite subzones column from the ammonites Russian Boreal dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma