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

Column content


There are 38 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
15369Hysterolenus asiaticus TrZyesHysterolenus asiaticus486.3500487.4725Stage 10
15368Leiostegium constrictum - Shenjiawania brevis TrZyesLeiostegium constrictum - Shenjiawania brevis487.4725488.2195Stage 10
15367Mictosaukia striata - Fatocephalus TrZyesMictosaukia striata - Fatocephalus488.2195488.7175Stage 10
15366Leioagnostus cf. bexelli - Archaeuloma taoyuanense TrZyesLeioagnostus cf. bexelli - Archaeuloma taoyuanense488.7175489.6305Stage 10
15365Micragnostus chiushuensis TrZyesMicragnostus chiushuensis489.6305490.5850Stage 10
15364Lotagnostus americanus TrZyesLotagnostus americanus490.5850491.0000Stage 10
15363Probinacunaspis nasalis - Peichiashania hunanensis TrZyesProbinacunaspis nasalis - Peichiashania hunanensis491.0000491.6400Jiangshanian
15362Eolotagnostus decoratus - Kaolishaniella TrZyesEolotagnostus decoratus - Kaolishaniella491.6400492.6960Jiangshanian
15361Rhaptagnostus ciliensis - Onchonotellus cf. kuruktagensis TrZyesRhaptagnostus ciliensis - Onchonotellus cf. kuruktagensis492.6960493.4960Jiangshanian
15360Agnostotes orientalis TrZyesAgnostotes orientalis493.4960494.2000Jiangshanian
15359Tomagnostus orientalis - Corynexochus plumula TrZyesTomagnostus orientalis - Corynexochus plumula494.2000495.1240Paibian
15358Agnostus inexpectans - Proceratopyge protracta TrZyesAgnostus inexpectans - Proceratopyge protracta495.1240496.2160Paibian
15357Glyptagnostus reticulatus TrZyesGlyptagnostus reticulatus496.2160497.0000Paibian
15356Glyptagnostus stolidotus TrZyesGlyptagnostus stolidotus497.0000497.4550Guzhangian
15355Linguagnostus reconditus TrZyesLinguagnostus reconditus497.4550498.4000Guzhangian
15354Proagnostus bulbus TrZyesProagnostus bulbus498.4000499.1350Guzhangian
15353Lejopyge laevigata TrZyesLejopyge laevigata499.1350500.5000Guzhangian
15352Lejopyge armata TrZyesLejopyge armata500.5000501.2200Drumian
15351Goniagnostus nathorsti TrZyesGoniagnostus nathorsti501.2200502.1000Drumian
15350Ptychagnostus punctuosus TrZyesPtychagnostus punctuosus502.1000502.9800Drumian
15349Ptychagnostus atavus TrZyesPtychagnostus atavus502.9800504.5000Drumian
15348Ptychagnostus gibbus TrZyesPtychagnostus gibbus504.5000505.3100Wuliuan
15347Peronopsis taijiangensis TrZyesPeronopsis taijiangensis505.3100507.5150Wuliuan
15346Oryctocephalus indicus TrZyesOryctocephalus indicus507.5150509.0000Wuliuan
15345Bathynotus guizhouensis - Ovatoryctocara sinensis TrZyesBathynotus guizhouensis - Ovatoryctocara sinensis509.0000510.2650Stage 4
15344Protoryctocephalus arcticus TrZyesProtoryctocephalus arcticus510.2650511.2000Stage 4
15343Arthricocephalus chauveaui TrZyesArthricocephalus chauveaui511.2000513.0150Stage 4
15342Oryctocarella duyunensis TrZyesOryctocarella duyunensis513.0150514.5000Stage 4
15341Szechuanolenus - Paokannia TrZyesSzechuanolenus - Paokannia514.5000515.3450Stage 3
15340Ushbaspis TrZyesUshbaspis515.3450516.3200Stage 3
15339Sinodiscus - Hupeidiscus TrZyesSinodiscus - Hupeidiscus516.3200519.3750Stage 3
15338Tsunyidiscus niutitangensis TrZyesTsunyidiscus niutitangensis519.3750521.0000Stage 3
15337SMALL SHELLY FOSSIL ZONES: TrZyesSMALL SHELLY FOSSIL ZONES:521.0000522.0000Stage 2
15968Sinosachites flabelliformis - Tannuolina zhangwentangi TrZ BWLOW LABELyesSinosachites flabelliformis - Tannuolina zhangwentangi522.0000523.4000Stage 2
15335Poorly fossiliferous Zone TrZyesPoorly fossiliferous Zone523.4000525.0000Stage 2
15334Watsonella crosbyi TrZyesWatsonella crosbyi525.0000529.0000Stage 2
15333Paragloborilus subglobosus - Purella squamulosa TrZyesParagloborilus subglobosus - Purella squamulosa529.0000531.7440Fortunian
15332Anabarites trisulcatus - Protohertzina anabarica TrZyesAnabarites trisulcatus - Protohertzina 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 Merged SSF-trilobite zones column from the trilobites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma