View/edit a column - Armored Fish (Placoderm) Zones (Devon)

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:290
dataset: Vert - Placoderms (dataset id: 116)
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=116) 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=290 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 23 intervals in the Armored Fish (Placoderm) Zones (Devon) column of the Vert - Placoderms dataset (id=116)
They range in age from 359.3000 Ma (Famennian) to 419.0011 Ma (Lochkovian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
13971PLACODERM ExtinctionPLACODERM Extinction359.3000361.0700Famennian
13970Bothriolepis ciecereBothriolepis ciecere362.4152362.8282Famennian
13969LAD of PhyllolepisLAD of Phyllolepis362.8282365.0551Famennian
13968Bothriolepis ornataBothriolepis ornata366.0260366.8105Famennian
13967PhyllolepisPhyllolepis366.8105368.4450Famennian
13966Bothriolepis curonicaBothriolepis curonica368.4450371.1000Famennian
13965(Kellwasser taxa)(Kellwasser taxa)371.1000372.4260Frasnian
13964Bothriolepis maximaBothriolepis maxima372.4260373.1670Frasnian
13963Plourdosteus trautscholdiPlourdosteus trautscholdi373.1670376.6390Frasnian
13962Bothriolepis cellulosaBothriolepis cellulosa376.9744377.8080Frasnian
13961Bothriolepis prima - B. obrutschewiBothriolepis prima - B. obrutschewi377.8080379.1560Frasnian
13960Asterolepis ornataAsterolepis ornata379.1560379.7320Givetian
13959WatsonosteusWatsonosteus379.7320380.3080Givetian
13958Asterolepis delleiAsterolepis dellei380.3080382.1000Givetian
13957Schizosteus striatusSchizosteus striatus385.3000388.3600Eifelian
13956Coccosteus cuspidatusCoccosteus cuspidatus388.3600389.2420Eifelian
13955Schizosteus heteroloepisSchizosteus heteroloepis392.5000395.6000Eifelian
13954Skamolepis fragilisSkamolepis fragilis395.6000396.9000Emsian
13953Gomphonchus tauragensisGomphonchus tauragensis404.6356408.9065Emsian
13952Rhinopteraspis dunensisRhinopteraspis dunensis408.9065412.4000Pragian
13951Althaspis leachiAlthaspis leachi412.4000414.5685Lochkovian
13950Rhinopteraspis crouchiRhinopteraspis crouchi414.5685416.7347Lochkovian
13949Phialaspis, Protopteraspis, Pteraspis rostrataPhialaspis, Protopteraspis, Pteraspis rostrata416.7347419.0011Lochkovian

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 Armored Fish (Placoderm) Zones (Devon) column from the Vert - Placoderms dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma