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

Column content


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

idintervalxhas_added_abvTSC labeltop_agebase_agestage
3221Unzoned RAZyesUnzoned134.5896137.5896Valanginian
3223Surites tzikwinianus RAZyesSurites tzikwinianus137.5896138.2530Berriasian
3225Riasanites rjasanensis RAZyesRiasanites rjasanensis138.2530141.7817Berriasian
3227Volgidiscus singularis beds RAZyesVolgidiscus singularis beds141.7817142.4675Berriasian
1922Craspedites nodiger RAZyesCraspedites nodiger142.4675143.5023Berriasian
1923Craspedites subditus RAZyesCraspedites subditus143.5023143.8986Tithonian
1924Kachpurites fulgens RAZyesKachpurites fulgens143.8986144.2948Tithonian
1925Epivirgatites nikitini RAZyesEpivirgatites nikitini144.2948144.7183Tithonian
1926Virgatites virgatus RAZyesVirgatites virgatus144.7183145.1095Tithonian
1927Dorsoplanites panderi RAZyesDorsoplanites panderi145.1095146.7665Tithonian
1928Ilowaiskya pseudoscythica RAZyesIlowaiskya pseudoscythica146.7665147.3715Tithonian
1929Ilowaiskya sokolovi RAZyesIlowaiskya sokolovi147.3715148.4458Tithonian
1930Ilowaiskya klimovi RAZyesIlowaiskya klimovi148.4458149.2374Tithonian
1931Aulacostephanus autissiodorensis RAZyesAulacostephanus autissiodorensis149.2374149.6293Kimmeridgian
1932Aulacostephanus eudoxus RAZyesAulacostephanus eudoxus149.6293150.9854Kimmeridgian
1933Aulocostephanus sosvaensis RAZyesAulocostephanus sosvaensis150.9854152.0351Kimmeridgian
1934Amoeboceras kitchini RAZyesAmoeboceras kitchini152.0351153.7029Kimmeridgian
1935Amoeboceras bauhini RAZyesAmoeboceras bauhini153.7029154.7780Kimmeridgian
1936Amoeboceras rosenkranzi RAZyesAmoeboceras rosenkranzi154.7780156.6871Oxfordian
1937Amoeboceras regulare RAZyesAmoeboceras regulare156.6871157.4266Oxfordian
1938Amoeboceras serratum RAZyesAmoeboceras serratum157.4266157.7988Oxfordian
1939Amoeboceras glosense RAZyesAmoeboceras glosense157.7988158.0776Oxfordian
1940Cardioceras tenuiserratum RAZyesCardioceras tenuiserratum158.0776158.3376Oxfordian
1941Cardioceras densiplicatum RAZyesCardioceras densiplicatum158.3376159.0876Oxfordian
1942Cardioceras cordatum RAZyesCardioceras cordatum159.0876159.6426Oxfordian
1943Quenstedtoceras mariae RAZyesQuenstedtoceras mariae159.6426161.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 zones column from the ammonites Russian Boreal dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma