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

Column content


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

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15229Harpidoides - Platypeltoides AltSibTrZyesHarpidoides - Platypeltoides488.7175489.6305Stage 10
15228Lophosaukia AltSibTrZyesLophosaukia489.6305490.4896Stage 10
15227Trisulcagnostus trisulcus AltSibTrZyesTrisulcagnostus trisulcus490.4896491.3200Stage 10
15226Eolotagnostus scrobicularis AltSibTrZyesEolotagnostus scrobicularis491.3200491.9040Jiangshanian
15225Neoagnostus quadratiformis AltSibTrZyesNeoagnostus quadratiformis491.9040492.3792Jiangshanian
15224Eurudagnostus ovaliformis AltSibTrZyesEurudagnostus ovaliformis492.3792492.6960Jiangshanian
15223Eur. kazachstanus AltSibTrZyesEur. kazachstanus492.6960493.0160Jiangshanian
15222Pseudagnostus pseudangustilobis AltSibTrZyesPseudagnostus pseudangustilobis493.0160493.4960Jiangshanian
15221Ivshinaspis ivshini AltSibTrZyesIvshinaspis ivshini493.4960494.2000Jiangshanian
15220Pseudagnostus curtare AltSibTrZyesPseudagnostus curtare494.2000495.3424Paibian
15219Homagnostus longiformis AltSibTrZyesHomagnostus longiformis495.3424496.2160Paibian
15218Kormagnostus simplex AltSibTrZyesKormagnostus simplex497.4550498.5470Guzhangian
15217Lejopyge laevigata - Aldanaspis trancata AltSibTrZyesLejopyge laevigata - Aldanaspis trancata498.5470500.5000Guzhangian

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