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

Column content


There are 40 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 485.2234 Ma (Tremadocian) to 538.8000 Ma (Fortunian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15138Eopatokephalus nyaicus SibTrZyesEopatokephalus nyaicus485.2234486.5500Tremadocian
15137Euloma limitans - Taoyuania (Batyraspis) SibTrZyesEuloma limitans - Taoyuania (Batyraspis)486.5500488.2195Stage 10
15136Lotagnostus hedini SibTrZyesLotagnostus hedini488.2195488.7175Stage 10
15135Lotagnostus americanus SibTrZyesLotagnostus americanus488.7175491.0000Stage 10
15134Parabolinites rectus SibTrZyesParabolinites rectus491.0000491.6400Jiangshanian
15133Plicatolina perlata SibTrZyesPlicatolina perlata491.6400492.6960Jiangshanian
15132Maladioidella abdita SibTrZyesMaladioidella abdita492.6960493.4960Jiangshanian
15131Agnostotes orientalis - Irvingella angustilimbata SibTrZyesAgnostotes orientalis - Irvingella angustilimbata493.4960494.2000Jiangshanian
15130Erixanium sentum SibTrZyesErixanium sentum494.2000495.3424Paibian
15129Stigmatoa destruncta SibTrZyesStigmatoa destruncta495.3424496.2160Paibian
15128Glyptagnostus reticulatus SibTrZyesGlyptagnostus reticulatus496.2160497.0000Paibian
15127Glyptagnostus stolidotus SibTrZyesGlyptagnostus stolidotus497.0000497.4550Guzhangian
15126Clavagnostus spinosus SibTrZyesClavagnostus spinosus497.4550498.4000Guzhangian
15125Proagnostus bulbus SibTrZyesProagnostus bulbus498.4000499.1350Guzhangian
15124Lejopyge laevigata SibTrZyesLejopyge laevigata499.1350500.5000Guzhangian
15123Anomocarioides limbataeformis SibTrZyesAnomocarioides limbataeformis500.5000502.1000Drumian
15122Anopolenus henrici - Corynexochus perforatus SibTrZyesAnopolenus henrici - Corynexochus perforatus502.1000503.7096Drumian
15121Tomagnostus fissus - Acadoparadoxides sacheri SibTrZyesTomagnostus fissus - Acadoparadoxides sacheri503.7096504.5000Drumian
15120Ptychagnostus gibbus SibTrZyesPtychagnostus gibbus504.5000505.3100Wuliuan
15119Kounamkites SibTrZyesKounamkites505.3100509.0000Wuliuan
15118Ovatoryctocara / Schistocephalus SibTrZyesOvatoryctocara / Schistocephalus509.0000510.2650Stage 4
15117Anabaraspis splendens SibTrZyesAnabaraspis splendens510.2650511.0130Stage 4
15116Lermontovia grandis SibTrZyesLermontovia grandis511.0130512.3193Stage 4
15115Bergeroniellus ketemensis SibTrZyesBergeroniellus ketemensis512.3193512.8885Stage 4
15114Bergeroniellus ornata SibTrZyesBergeroniellus ornata512.8885513.6090Stage 4
15113Bergeroniellus asiaticus SibTrZyesBergeroniellus asiaticus513.6090514.3515Stage 4
15112Bergeroniellus gurarii SibTrZyesBergeroniellus gurarii514.3515514.9225Stage 3
15111Bergeroniellus micmacciformis -Eirbiella SibTrZyesBergeroniellus micmacciformis -Eirbiella514.9225515.9950Stage 3
15110Judomia - Uktaspis (Prouktaspis) SibTrZyesJudomia - Uktaspis (Prouktaspis)515.9950517.6947Stage 3
15109Delgadella anabarua SibTrZyesDelgadella anabarua517.6947519.3750Stage 3
15108Repinaella SibTrZyesRepinaella519.3750520.1875Stage 3
15107Profallotaspis jakutensis SibTrZyesProfallotaspis jakutensis520.1875521.0000Stage 3
15106ARCHAEOCYATHAN ZONES label: SibTrZyesARCHAEOCYATHAN ZONES521.0000521.5000Stage 2
15965Dokidocyathus lenaicus-Tumuliolynthus primigenius SibTrZ BELOW LABELyesDokidocyathus lenaicus-Tumuliolynthus primigenius SibTrZ521.5000522.4400Stage 2
15104Dokidocyathus regularis SibTrZyesDokidocyathus regularis522.4400523.8000Stage 2
15103Nochoroicyathus sunnaginicus SibTrZyesNochoroicyathus sunnaginicus523.8000525.4000Stage 2
15102SMALL SHELLY FOSSIL ZONES SibTrZyesSMALL SHELLY FOSSIL ZONES528.5000529.0000Stage 2
15101Purella antiqua SibTrZyesPurella antiqua529.0000531.7440Fortunian
15100Anabarites trisulcatus SibTrZyesAnabarites trisulcatus531.7440536.3500Fortunian
15508basal barren interval of Siberian Cambrianyesbasal barren interval of Siberian536.3500538.8000Fortunian

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 Main Siberia set column from the trilobites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma