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

Column content


There are 19 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 487.0575 Ma (Stage 10) to 543.8000 Ma (Fortunian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
15435Trilobagnostus holmi BaTrZyesTrilobagnostus holmi487.0575489.8214Stage 10
15434Lotagnostus americanus BaTrZyesLotagnostus americanus489.8214491.0000Stage 10
15433Pseudagnostus cyclopyge BaTrZyesPseudagnostus cyclopyge491.0000494.2000Jiangshanian
15432Agnostus (Homagnostus) obesus - Glyptagnostus reticulatus BaTrZyesAgnostus (Homagnostus) obesus - Glyptagnostus reticulatus494.2000497.0000Paibian
15431Agnostus pisiformis BaTrZyesAgnostus pisiformis497.0000498.4000Guzhangian
15430Lejopyge laevigata BaTrZyesLejopyge laevigata498.4000500.5000Guzhangian
15429Goniagnostus nathorsti BaTrZyesGoniagnostus nathorsti500.5000502.1000Drumian
15428Ptychagnostus punctuosus BaTrZyesPtychagnostus punctuosus502.1000502.9800Drumian
15427Ptychagnostus atavus BaTrZyesPtychagnostus atavus502.9800504.5000Drumian
15426Ptychagnostus gibbus BaTrZyesPtychagnostus gibbus504.5000505.3100Wuliuan
15425Ptychagnostus praecurrens BaTrZyesPtychagnostus praecurrens505.3100506.4125Wuliuan
15424Ecaparadoxides insularis BaTrZyesEcaparadoxides insularis506.4125507.6150Wuliuan
15423Chelediscus acifer BaTrZyesChelediscus acifer510.4987513.3120Stage 4
15422Ellipsostrenua spinosa BaTrZyesEllipsostrenua spinosa513.3120514.5000Stage 4
15421Holmia kjerulfi BaTrZyesHolmia kjerulfi514.5000516.6255Stage 3
15420Schmidtiellus mickwitzi BaTrZyesSchmidtiellus mickwitzi516.6255518.6113Stage 3
15419SMALL SHELLY FOSSIL ZONES: BaTrZyesSMALL SHELLY FOSSIL ZONES:521.0000522.0000Stage 2
15418Platysolenites antiquissimus (= a tubular agglutinated foraminifer) BaTrZyesPlatysolenites antiquissimus (= a tubular agglutinated foraminifer)522.0000528.2000Stage 2
15417Sabellidites cambriensis BaTrZyesSabellidites cambriensis528.2000543.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 Baltica set column from the trilobites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma