View/edit a column - Pelagic trilobites (Agnostids)

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:323
dataset: trilobites (dataset id: 132)
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=132) order by abv_ref, disambig
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=323 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 33 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 486.3500 Ma (Stage 10) to 536.3500 Ma (Fortunian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15331Hysterolenus asiaticus BenthTrZyesHysterolenus asiaticus486.3500487.4725Stage 10
15330Leiostegium constrictum - Shenjiawania brevis BenthTrZyesLeiostegium constrictum - Shenjiawania brevis487.4725488.2195Stage 10
15329Mictosaukia striata - Fatocephalus BenthTrZyesMictosaukia striata - Fatocephalus488.2195488.7175Stage 10
15328Archaeuloma taoyuanense BenthTrZyesArchaeuloma taoyuanense488.7175489.6305Stage 10
15327Hedinaspis regalis BenthTrZyesHedinaspis regalis489.6305491.0000Stage 10
15326Probinacunaspis nasalis - Peichiashania hunanensis BenthTrZyesProbinacunaspis nasalis - Peichiashania hunanensis491.0000491.6400Jiangshanian
15325Kaolishaniella BenthTrZyesKaolishaniella491.6400492.6960Jiangshanian
15324Onchonotellus cf. kuruktagensis BenthTrZyesOnchonotellus cf. kuruktagensis492.6960493.4960Jiangshanian
15323Irvingella angustilimbata BenthTrZyesIrvingella angustilimbata493.4960494.2000Jiangshanian
15322Corynexochus plumula BenthTrZyesCorynexochus plumula494.2000495.1240Paibian
15321Proceratopyge protracta BenthTrZyesProceratopyge protracta495.1240496.2160Paibian
15320Liostracina bella BenthTrZyesLiostracina bella496.2160497.7668Paibian
15319Wanshania wanshanensis BenthTrZyesWanshania wanshanensis497.7668499.5854Guzhangian
15318Pianaspis sinensis BenthTrZyesPianaspis sinensis499.5854502.3904Drumian
15317Dorypyge richthofeni BenthTrZyesDorypyge richthofeni502.3904504.4240Drumian
15316Peronopsis taijiangensis BenthTrZyesPeronopsis taijiangensis505.3100507.5150Wuliuan
15315Oryctocephalus indicus BenthTrZyesOryctocephalus indicus507.5150509.0000Wuliuan
15314Ovatoryctocara granulata -Bathynotus holopygus BenthTrZyesOvatoryctocara granulata -Bathynotus holopygus509.0000510.6500Stage 4
15313Protoryctocephalus wuxuensis BenthTrZyesProtoryctocephalus wuxuensis510.6500511.7500Stage 4
15312Arthricocephalus chauveaui BenthTrZyesArthricocephalus chauveaui511.7500513.0150Stage 4
15311Oryctocarella duyunensis BenthTrZyesOryctocarella duyunensis513.0150514.5000Stage 4
15310Arthricocephalus jiangkouensis BenthTrZyesArthricocephalus jiangkouensis514.5000514.9550Stage 3
15309Szechuanolenus - Paokannia BenthTrZyesSzechuanolenus - Paokannia514.9550515.3450Stage 3
15308Ushbaspis BenthTrZyesUshbaspis515.3450516.3200Stage 3
15307Sinodiscus - Hupeidiscus BenthTrZyesSinodiscus - Hupeidiscus516.3200519.3750Stage 3
15306Tsunyidiscus niutitangensis BenthTrZyesTsunyidiscus niutitangensis519.3750521.0000Stage 3
15305SMALL SHELLY FOSSIL ZONES: BenthTrZyesSMALL SHELLY FOSSIL ZONES:521.0000522.0000Stage 2
15967Sinosachites flabelliformis - Tannuolina zhangwentangi BenthTrZ BELOW THE LABELyesSinosachites flabelliformis - Tannuolina zhangwentangi522.0000523.4000Stage 2
15304Sinosachites flabelliformis - Tannuolina zhangwentangi BenthTrZyesSinosachites flabelliformis - Tannuolina zhangwentangi522.0000523.4000Stage 2
15303Poorly fossiliferous Zone BenthTrZyesPoorly fossiliferous Zone523.4000525.0000Stage 2
15302Watsonella crosbyi BenthTrZyesWatsonella crosbyi525.0000529.0000Stage 2
15301Paragloborilus subglobosus - Purella squamulosa BenthTrZyesParagloborilus subglobosus - Purella squamulosa529.0000531.7440Fortunian
15300Anabarites trisulcatus - Protohertzium anabarica BenthTrZyesAnabarites trisulcatus - Protohertzium anabarica531.7440536.3500Fortunian

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 Benthic trilobites (Polymerids) column from the trilobites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma