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

Column content


There are 39 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 488.2195 Ma (Stage 10) to 527.8000 Ma (Stage 2)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15969Mictosaukia perplexa AusTrZyesMictosaukia perplexa488.2195488.7175Stage 10
15407Neoagnostus quasibilobus - Shergoldia nomas AusTrZyesNeoagnostus quasibilobus - Shergoldia nomas488.7175490.1783Stage 10
15406Sinosaukia impages AusTrZyesSinosaukia impages490.1783491.0000Stage 10
15405Rhaptagn. clarki maximus - Rh. papilio AusTrZyesRhaptagn. clarki maximus - Rh. papilio491.0000491.3200Jiangshanian
15404Rhhaptagnostus bifax - Neoagnostus denticulatus AusTrZyesRhhaptagnostus bifax - Neoagnostus denticulatus491.3200491.6400Jiangshanian
15403Rh. clarki prolatus - Caz. sectatrix AusTrZyesRh. clarki prolatus - Caz. sectatrix491.6400491.9568Jiangshanian
15402Rh.cl. patulus - C. squamosa - H. lilyensis AusTrZyesRh.cl. patulus - C. squamosa - H. lilyensis491.9568492.4320Jiangshanian
15401Peichiashania tertia - P. quarta AusTrZyesPeichiashania tertia - P. quarta492.4320492.6960Jiangshanian
15400Peichiash. secunda - Prochuangia glabella AusTrZyesPeichiash. secunda - Prochuangia glabella492.6960493.0160Jiangshanian
15399Wentsuia iota - Rhaptagnostus apsis AusTrZyesWentsuia iota - Rhaptagnostus apsis493.0160493.4960Jiangshanian
15398Irvingella tropica AusTrZyesIrvingella tropica493.4960494.2000Jiangshanian
15397Stigmatoa diloma AusTrZyesStigmatoa diloma494.2000494.7082Paibian
15396Erixanium sentum AusTrZyesErixanium sentum494.7082495.3424Paibian
15395Proceratopyge cryptica AusTrZyesProceratopyge cryptica495.3424496.2160Paibian
15394Glyptagnostus reticulatus AusTrZyesGlyptagnostus reticulatus496.2160497.0000Paibian
15393Glyptagnostus stolidotus AusTrZyesGlyptagnostus stolidotus497.0000497.4550Guzhangian
15392Achmarhachis quasivespa AusTrZyesAchmarhachis quasivespa497.4550498.4000Guzhangian
15391Erediaspis eretes AusTrZyesErediaspis eretes498.4000499.1350Guzhangian
15390Damesella torosa - Ferenepea janitrix AusTrZyesDamesella torosa - Ferenepea janitrix499.1350499.5445Guzhangian
15389Lejopyge laevigata AusTrZyesLejopyge laevigata499.5445500.5000Guzhangian
15388Goniagnostus nathorsti AusTrZyesGoniagnostus nathorsti500.5000502.1000Drumian
15387Doryagnostus deltoides AusTrZyesDoryagnostus deltoides502.1000502.5400Drumian
15386Ptychagnostus punctuosus AusTrZyesPtychagnostus punctuosus502.5400502.9800Drumian
15385Euagnostus opimus AusTrZyesEuagnostus opimus502.9800503.7400Drumian
15384Ptychagnostus atavus AusTrZyesPtychagnostus atavus503.7400504.5000Drumian
15383Ptychagnostus gibbus AusTrZyesPtychagnostus gibbus504.5000505.3100Wuliuan
15382Ptychagnostus shergoldi AusTrZyesPtychagnostus shergoldi505.3100505.7510Wuliuan
15381Ptychagnostus praecurrens AusTrZyesPtychagnostus praecurrens505.7510506.4125Wuliuan
15380Ptychagnostus anabarensis AusTrZyesPtychagnostus anabarensis506.4125507.9605Wuliuan
15379Xystridura negrina / Redlichia forresti [ ? ] AusTrZyesXystridura negrina / Redlichia forresti [ ? ]507.9605512.8885Stage 4
15378Pararaia janeae AusTrZyesPararaia janeae512.8885514.9225Stage 4
15377Pararaia bunyerooensis AusTrZyesPararaia bunyerooensis514.9225516.3200Stage 3
15376Pararaia tatei AusTrZyesPararaia tatei516.3200518.3577Stage 3
15375Abadiella huoi AusTrZyesAbadiella huoi518.3577519.3750Stage 3
15374SMALL SHELLY FOSSIL ZONES: AusTrZyesSMALL SHELLY FOSSIL ZONES:528.5000522.0000Stage 2
15373Micrina etherigei AusTrZyesMicrina etherigei522.0000523.2800Stage 2
15372Kulparina rostrata AusTrZyesKulparina rostrata523.2800524.0400Stage 2
15371Sunnaginia imbricata AusTrZyesSunnaginia imbricata524.0400524.8400Stage 2
15370Watsonella crosbyi AusTrZyesWatsonella crosbyi524.8400527.8000Stage 2

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