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:322
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:Ogg et al. 2016b;
Path:

Column References ↑

Ogg, J. G., Ogg, G. M. & Gradstein, F. M. (2016b). A Concise Geologic Time Scale 2016. Elsevier, Amsterdam. 1-234. gs

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

Column content


There are 18 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 488.7175 Ma (Stage 10) to 505.3100 Ma (Wuliuan)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15299Leioagnostus cf. bexelli PelTrZyesLeioagnostus cf. bexelli488.7175489.6305Stage 10
15298Micragnostus chiushuensis PelTrZyesMicragnostus chiushuensis489.6305490.5850Stage 10
15297Lotagnostus americanus PelTrZyesLotagnostus americanus490.5850491.0000Stage 10
15296Eolotagnostus decoratus PelTrZyesEolotagnostus decoratus491.6400492.6960Jiangshanian
15295Rhaptagnostus ciliensis PelTrZyesRhaptagnostus ciliensis492.6960493.4960Jiangshanian
15294Agnostotes orientalis PelTrZyesAgnostotes orientalis493.4960494.2000Jiangshanian
15293Tomagnostus orientalis PelTrZyesTomagnostus orientalis494.2000495.1240Paibian
15292Agnostus inexpectans PelTrZyesAgnostus inexpectans495.1240496.2160Paibian
15291Glyptagnostus reticulatus PelTrZyesGlyptagnostus reticulatus496.2160497.0000Paibian
15290Glyptagnostus stolidotus PelTrZyesGlyptagnostus stolidotus497.0000497.4550Guzhangian
15289Linguagnostus reconditus PelTrZyesLinguagnostus reconditus497.4550498.4000Guzhangian
15288Proagnostus bulbus PelTrZyesProagnostus bulbus498.4000499.1350Guzhangian
15287Lejopyge laevigata PelTrZyesLejopyge laevigata499.1350500.5000Guzhangian
15286Lejopyge armata PelTrZyesLejopyge armata500.5000501.2200Drumian
15285Goniagnostus nathorsti PelTrZyesGoniagnostus nathorsti501.2200502.1000Drumian
15284Ptychagnostus punctuosus PelTrZyesPtychagnostus punctuosus502.1000502.9800Drumian
15283Ptychagnostus atavus PelTrZyesPtychagnostus atavus502.9800504.5000Drumian
15282Ptychagnostus gibbus PelTrZyesPtychagnostus gibbus504.5000505.3100Wuliuan

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