View/edit a column - Charophyte 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:63
dataset: charophytes (dataset id: 16)
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=16) 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

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

Column content


There are 49 intervals in the Charophyte Zone column of the charophytes dataset (id=16)
They range in age from 0.0001 Ma (Messinian) to 251.9000 Ma (Induan)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
5048Nitellopsis (Tectochara) etrusca zoneyesNitellopsis (Tectochara) etrusca0.000113.6479Messinian
5049Nitellopsis (Tectochara) ginisburgi zoneyesNitellopsis (Tectochara) ginisburgi13.647921.1200Burdigalian
5050Stephanochara berdotensis zoneyesStephanochara berdotensis21.120021.9480Aquitanian
5051Rantzieniella nitida zoneyesRantzieniella nitida21.948023.5301Aquitanian
5052Chara notata zoneyesChara notata23.530126.1136Chattian
5053Stephanochara ungeri zoneyesStephanochara ungeri26.113627.9436Chattian
5054Chara microcera zoneyesChara microcera27.943629.0703Rupelian
5055Rhabdochara major zoneyesRhabdochara major29.070332.3917Rupelian
5056Stephanochara pinguis zoneyesStephanochara pinguis32.391733.9713Rupelian
5057Stephanochara vectensis zoneyesStephanochara vectensis33.971335.2025Priabonian
5058Harrisichara vasiformis tuberculata zoneyesHarrisichara vasiformis tuberculata35.202536.2845Priabonian
5059Gyrogona tuberosa zoneyesGyrogona tuberosa36.284536.8481Priabonian
5060Psilochara repanda zoneyesPsilochara repanda36.848137.2708Priabonian
5061Raskyella vadaszi zoneyesRaskyella vadaszi37.270838.1162Priabonian
5062Chara friteli zoneyesChara friteli38.116239.5779Bartonian
5063Raskyella pecki zoneyesRaskyella pecki39.577941.8302Bartonian
5064Maedleriella embergeri zoneyesMaedleriella embergeri41.830244.6782Lutetian
5065Nitellopsis (Tectochara) thaleri zoneyesNitellopsis (Tectochara) thaleri44.678252.3761Ypresian
5066Peckichara piveteaui zoneyesPeckichara piveteaui52.376152.9964Ypresian
5067Peckichara disermas zoneyesPeckichara disermas52.996457.1010Ypresian
5068Sphaerochara edda zoneyesSphaerochara edda57.101057.4667Thanetian
5069Dughiella bacillaris zoneyesDughiella bacillaris57.466764.8181Selandian
5070Peckichara llobregatensis zoneyesPeckichara llobregatensis64.818165.5814Danian
3985Peckichara sertulata CphyteZyesPeckichara sertulata65.581466.5400Maastrichtian
3986Peckichara sp. 1 CphyteZyesPeckichara sp. 166.540067.9010Maastrichtian
3987Microchara cristata CphyteZyesMicrochara cristata67.901069.0490Maastrichtian
3988Septorella ultima CphyteZyesSeptorella ultima69.049073.9050Maastrichtian
3989Peckichara cancellata CphyteZyesPeckichara cancellata73.905074.4245Campanian
3990Peckichara pectinata CphyteZyesPeckichara pectinata74.424579.5661Campanian
3991Peckichara baylensis CphyteZyesPeckichara baylensis79.566183.9000Campanian
3992Amblyochara media CphyteZyesAmblyochara media83.900084.1600Santonian
3993Microchara olmesensis CphyteZyesMicrochara olmesensis84.160086.2726Santonian
3994Atopochara trivolvis multivoltis CphyteZyesAtopochara trivolvis multivoltis86.272696.2400Turonian
3995Atopochara trivolvis restricta CphyteZyesAtopochara trivolvis restricta96.2400107.5875Albian
3996Clypeator grovesii lusitanicus CphyteZyesClypeator grovesii lusitanicus107.5875118.7623Albian
3997Axcidiella cruciata CphyteZyesAxcidiella cruciata118.7623122.0106Aptian
3998Atopochara trivolvis triquetra CphyteZyesAtopochara trivolvis triquetra122.0106126.5391Barremian
3999Globator maillardii steinhauseri CphyteZyesGlobator maillardii steinhauseri126.5391138.4840Hauterivian
4000Globator maillardii nurrensis CphyteZyesGlobator maillardii nurrensis138.4840139.9200Berriasian
4001Globator maillardii incrassatus CphyteZyesGlobator maillardii incrassatus139.9200140.6200Berriasian
1006Globator maillardii maillardii zoneGlobator maillardii maillardii zone140.6200144.0189Berriasian
1007Dictyoclavator fieri ramalhoi zoneDictyoclavator fieri ramalhoi zone144.0189153.4215Oxfordian
1008Echinochara peckii zoneEchinochara peckii zone153.4215158.1166Oxfordian
8518Auerbachichara rhaetica CphyteZyesAuerbachichara rhaetica202.2230227.3000Norian
8517Stellatochara thuringia CphyteZyesStellatochara thuringia227.3000238.8600Carnian
8516Stellatochara hoellvicensis CphyteZyesStellatochara hoellvicensis238.8600242.3085Ladinian
8515Stellatochara dnjeproviformis CphyteZyesStellatochara dnjeproviformis242.3085246.7000Anisian
8514Porochara triassica CphyteZyesPorochara triassica246.7000248.4325Olenekian
8513Porochara / Vladimiriella globosa ? CphyteZyesPorochara / Vladimiriella globosa ?248.4325251.9000Induan

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