• arkL
  • notes
  • introduction and login
  • notes on sequence data
  • notes on data table creation
  • view data
  • multicolumn view
  • dataset view
  • column view
  • event view
  • interval view
  • references
  • taxon links
  • data upload & integration
  • upload data
  • populate (integrate and check data)

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.

• Columns which have not yet had data imported into this database are not shown.
• Column colour is based on the dataset/subdataset so the options to change colour are given on the dataset page.
  
• Most col names have been copied from TSC, to activate an existing column enter the dataset_id directly in the arkL_columns database
• Once columns exist and are assigned to a datset they can be edited from this page
• Events and intervals are not directly assigned to a column in the database instead the column metadata defines which events and intervals are selected

Select Column and time interval

select dataset & column		time interval		cm/Ma
Dataset:	chronostratigraphyQuaternary Regional Stagesstages Australian (Cenoz, Sil-Ord)stages Baltoscania (Sil_Ord)stages Boreal (Late J/early K)stages British (Late J/early K)stages California (Cenozoic)stages Donets Basin (Carb)stages Iberian-Morocco (Ord-Camb)stages Japan (Neogene, Cret)stages Kazakhistan (Camb)stages New Zealandstages North American (Cret & Palaeozoic)stages North China (Camb)stages Paratethys (Neogene)stages Russia (Permo-Carb, Camb)stages Siberia (Carb, Camb)stages South China (Jur -> Camb)stages Tethyan - Pamirs (Permian)stages Tethyan - Salt Range (Permian)stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassicstrat - German Triassicstrat - type Mississippianstrat - Yangtse Platform (China, Tr)strat - Yorkshire Oxfordiananoxic episodesLower Paleozoic Time Slicesbiotic eventsmagnetochronologymagnetochronology - Jurassic pre M26 PacDeepTow at depthmagnetochronology - Quaternary eventsmagnetochronology - Triassic outcropmagnetochronology- Jurassic outcropammonites Russian Borealammonites Siberian Borealammonites Sub-Borealammonites Tethyanammonites Western Interiorbelemnites Balto-Scandiabelemnites Borealbelemnites Russian platform belemnites Tethyangraptolitestrilobitesbivalves Siberianbivalves Triassicbrachiopods Borealbrachiopods Tethyaninoceramids Aquitaineinoceramids Russian platforminoceramids Western Europeinoceramids Western interiorrudistsarchaeocyathsdacryoconarids (tentaculitids)conchostracansconodontsconodonts Australiaconodonts NAmostracods Borealostracods Devonianostracods Frenchostracods Tethyancalcareous algaecalpionellidscharophytesdiatoms low-latdiatoms mid-lat NPacdiatoms Soceanforams - Fusulinids & bforams - Eurasiaforams - Fusulinids & bforams - NAmericaforams - LBF letter stagesforams - LBFsforams - LBFs- French 1997 datumsforams - microfossils North Seaforams - plankticforams - SBFs Borealforams - SBFs Frenchforams - SBFs Tethyannannos Borealnannos Tethyanradiolaria low-latradiolaria Permo-Triassicradiolaria Southen mid & high latacritarchschitinozoadflgs Borealdflgs North Seadflgs NW Europedflgs Tethyanmiospores - Australianmiospores - E Europeanmiospores - SEAustralianmiospores - W Europeanpollen & spores - Arctic Triassicpollen & spores - German Triassicmacrofloramammals Asia & Chinamammals Australianmammals Europemammals North Americamammals South AmericaVert - AcanthodiansVert - Australian Early FishVert - Fish and Reptile faunachronsVert - PlacodermsVert - Sharkscyclostrat Martinez cyclessea-level Slilurian Loydell 98sequences - Boreal Jurassicsequences - Devoniansequences - Devonian Johnson85 T-Rsequences - NAm Ordovician of Hollandsequences & sea-level Silurian & Ordoviciansequences Carb Donets Basinsequences Carb Eurasiansequences globalsequences Perm-Carb-Dev NAmAntarctic CO2Antarctic delta-DeuteriumCarbon-13 compositeCarbon-13 eventsCenogrid - Westerhold2020Chinese Loess Mag suscLisiecki&Raymo 2005Marine Isotope StagesMilankovitch parametersOxygen-18 Cramer 2009Oxygen-18 eventsStrontiumMiller et al 2020	Top stage/age:
Column:	Pelagic trilobites (Agnostids) Benthic trilobites (Polymerids) Merged SSF-trilobite zones Main Siberia set Alternate Siberia set Main Australia set Main Baltica set Alternate Baltica set Main Laurentia set Alternate Laurentia set Major Cambrian markers all events	Base stage/age:

Column metadata

Name:		Main Laurentia set column id:202
dataset:		chronostratigraphy Quaternary Regional Stages stages Australian (Cenoz, Sil-Ord) stages Baltoscania (Sil_Ord) stages Boreal (Late J/early K) stages British (Late J/early K) stages California (Cenozoic) stages Donets Basin (Carb) stages Iberian-Morocco (Ord-Camb) stages Japan (Neogene, Cret) stages Kazakhistan (Camb) stages New Zealand stages North American (Cret & Palaeozoic) stages North China (Camb) stages Paratethys (Neogene) stages Russia (Permo-Carb, Camb) stages Siberia (Carb, Camb) stages South China (Jur -> Camb) stages Tethyan - Pamirs (Permian) stages Tethyan - Salt Range (Permian) stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassic strat - German Triassic strat - type Mississippian strat - Yangtse Platform (China, Tr) strat - Yorkshire Oxfordian anoxic episodes Lower Paleozoic Time Slices biotic events magnetochronology magnetochronology - Jurassic pre M26 PacDeepTow at depth magnetochronology - Quaternary events magnetochronology - Triassic outcrop magnetochronology- Jurassic outcrop ammonites Russian Boreal ammonites Siberian Boreal ammonites Sub-Boreal ammonites Tethyan ammonites Western Interior belemnites Balto-Scandia belemnites Boreal belemnites Russian platform belemnites Tethyan graptolites trilobites bivalves Siberian bivalves Triassic brachiopods Boreal brachiopods Tethyan inoceramids Aquitaine inoceramids Russian platform inoceramids Western Europe inoceramids Western interior rudists archaeocyaths dacryoconarids (tentaculitids) conchostracans conodonts conodonts Australia conodonts NAm ostracods Boreal ostracods Devonian ostracods French ostracods Tethyan calcareous algae calpionellids charophytes diatoms low-lat diatoms mid-lat NPac diatoms Socean forams - Fusulinids & bforams - Eurasia forams - Fusulinids & bforams - NAmerica forams - LBF letter stages forams - LBFs forams - LBFs- French 1997 datums forams - microfossils North Sea forams - planktic forams - SBFs Boreal forams - SBFs French forams - SBFs Tethyan nannos Boreal nannos Tethyan radiolaria low-lat radiolaria Permo-Triassic radiolaria Southen mid & high lat acritarchs chitinozoa dflgs Boreal dflgs North Sea dflgs NW Europe dflgs Tethyan miospores - Australian miospores - E European miospores - SEAustralian miospores - W European pollen & spores - Arctic Triassic pollen & spores - German Triassic macroflora mammals Asia & China mammals Australian mammals Europe mammals North America mammals South America Vert - Acanthodians Vert - Australian Early Fish Vert - Fish and Reptile faunachrons Vert - Placoderms Vert - Sharks cyclostrat Martinez cycles sea-level Slilurian Loydell 98 sequences - Boreal Jurassic sequences - Devonian sequences - Devonian Johnson85 T-R sequences - NAm Ordovician of Holland sequences & sea-level Silurian & Ordovician sequences Carb Donets Basin sequences Carb Eurasian sequences global sequences Perm-Carb-Dev NAm Antarctic CO2 Antarctic delta-Deuterium Carbon-13 composite Carbon-13 events Cenogrid - Westerhold2020 Chinese Loess Mag susc Lisiecki&Raymo 2005 Marine Isotope Stages Milankovitch parameters Oxygen-18 Cramer 2009 Oxygen-18 events Strontium Miller et al 2020 trilobites (dataset id: 132)
column_type:		intervals events lithology range chart sequence pointdata bar chart graphic sea-level curve images stacked filled curve pointdata_table:
Column properties:		Width:   Colour:
Field for labels/data:		source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:
Path:		Marine Macrofossils (Mesozoic-Paleozoic)/Trilobites and pre-Trilobite biostratigraphy/Laurentia trilobites

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

Column content

There are 32 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)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
15467	Symphysurina bulbosa LauTrZ	yes	Symphysurina bulbosa	485.2234	487.0575	Tremadocian
15466	Symphysurina brevispicata LauTrZ	yes	Symphysurina brevispicata	487.0575	487.6219	Stage 10
15465	Missisquoia LauTrZ	yes	Missisquoia	487.6219	488.2195	Stage 10
15464	Eurekia apopsis LauTrZ	yes	Eurekia apopsis	488.2195	488.4685	Stage 10
15463	Saukiella serotina LauTrZ	yes	Saukiella serotina	488.4685	488.9001	Stage 10
15462	Saukiella junia / Saukiella pyrene - Rasettia magna LauTrZ	yes	Saukiella junia / Saukiella pyrene - Rasettia magna	488.9001	491.9568	Stage 10
15461	Ellipsocephaloides - Idahoia LauTrZ	yes	Ellipsocephaloides - Idahoia	491.9568	493.0160	Jiangshanian
15460	Taenicephalus LauTrZ	yes	Taenicephalus	493.0160	493.4960	Jiangshanian
15459	Elvinia LauTrZ	yes	Elvinia	493.4960	494.4772	Jiangshanian
15458	Dunderbergia LauTrZ	yes	Dunderbergia	494.4772	495.3424	Paibian
15457	Aphelaspis LauTrZ	yes	Aphelaspis	495.3424	497.0000	Paibian
15456	Crepicephalus LauTrZ	yes	Crepicephalus	497.0000	498.4000	Guzhangian
15455	Proagnostus bulbus LauTrZ	yes	Proagnostus bulbus	498.4000	499.1350	Guzhangian
15454	Lejopyge laevigata LauTrZ	yes	Lejopyge laevigata	499.1350	500.5000	Guzhangian
15453	Ptychagnostus punctuosus LauTrZ	yes	Ptychagnostus punctuosus	500.5000	502.9800	Drumian
15452	Ptychagnostus atavus LauTrZ	yes	Ptychagnostus atavus	502.9800	504.5000	Drumian
15451	Ptychagnostus gibbus LauTrZ	yes	Ptychagnostus gibbus	504.5000	505.3100	Wuliuan
15450	Ptychagnostus praecurrens LauTrZ	yes	Ptychagnostus praecurrens	505.3100	506.5227	Wuliuan
15449	Albertella LauTrZ	yes	Albertella	506.5227	507.2945	Wuliuan
15448	Plagiura - Poliella LauTrZ	yes	Plagiura - Poliella	507.2945	509.0000	Wuliuan
15447	Amecephalus arrojosensis LauTrZ	yes	Amecephalus arrojosensis	509.0000	510.4987	Stage 4
15446	Eokochaspis nodosa LauTrZ	yes	Eokochaspis nodosa	510.4987	511.2000	Stage 4
15445	Olenellus LauTrZ	yes	Olenellus	511.2000	513.0892	Stage 4
15444	Nevadella eucharis LauTrZ	yes	Nevadella eucharis	515.3450	515.8325	Stage 3
15443	Nevadella addyensis LauTrZ	yes	Nevadella addyensis	515.8325	516.3200	Stage 3
15442	Avafallotaspis maria LauTrZ	yes	Avafallotaspis maria	516.3200	517.3892	Stage 3
15441	Grandinasus patulus LauTrZ	yes	Grandinasus patulus	517.3892	517.8475	Stage 3
15440	Esmeraldina rowei LauTrZ	yes	Esmeraldina rowei	517.8475	518.4585	Stage 3
15439	'Fallotaspis' LauTrZ	yes	'Fallotaspis'	518.4585	520.1875	Stage 3
15438	Fritzaspis LauTrZ	yes	Fritzaspis	520.1875	521.0000	Stage 3
15437	SMALL SHELLY FOSSIL ZONES: LauTrZ	yes	SMALL SHELLY FOSSIL ZONES:	521.0000	522.0000	Stage 2
15436	'Wyattia' LauTrZ	yes	'Wyattia'	522.0000	538.8000	Fortunian

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