View/edit a column - all events

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:242
dataset: forams - Fusulinids & bforams - Eurasia (dataset id: 90)
column_type:pointdata_table:
Column properties:Width:   Colour:
Field for labels/data:source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:Davydov et al. 2004;Poty et al. 2006;
Path:

Column References ↑

Davydov, V. I., Wardlaw, B. R. & Gradstein, F. M. (2004). The Carboniferous Period. In, Gradstein, F. M. , Ogg, J. G. , and Smith, A. G. (ed.) A Geologic Time Scale 2004. Cambridge: Cambridge University Press 222-248. gs

Poty, E., Devuyst, F. -X. & Hance, L. (2006). Upper Devonian and Mississippian foraminiferal and rugose coral zonation of Belgium and Northern France: a tool for Eurasian correlations. Geological Magazine. 143: 829-857. gs

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

Column content


There are 62 intervals in the all events column of the forams - Fusulinids dataset (id=)
They range in age from 251.9000 Ma (Changhsingian) to 359.8841 Ma (Tournaisian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
11279Lf4 EulbfZyesLf4251.9000252.6000Changhsingian
11278Lf3 EulbfZyesLf3252.6000254.2400Changhsingian
11277Lf2 EulbfZyesLf2254.2400258.1000Wuchiapingian
11276Lf1 EulbfZyesLf1258.1000259.5470Wuchiapingian
11275Gf6 EulbfZyesGf6259.5470263.4050Capitanian
11274Gf5 EulbfZyesGf5263.4050264.8279Capitanian
11273Gf4 EulbfZyesGf4264.8279266.2886Wordian
11272Gf3 EulbfZyesGf3266.2886269.2100Wordian
11271Gf2 EulbfZyesGf2269.2100276.6000Roadian
11270Gf1 EulbfZyesGf1276.6000278.3875Kungurian
11269Cf13 EulbfZyesCf13278.3875281.9575Kungurian
11268Cf12 EulbfZyesCf12281.9575283.3000Kungurian
11267Cf11 EulbfZyesCf11283.3000285.9900Artinskian
11266Cf10 EulbfZyesCf10285.9900288.5525Artinskian
11265Cf9 EulbfZyesCf9288.5525290.5100Artinskian
11264Cf8 EulbfZyesCf8290.5100291.5033Sakmarian
11263Cf7 EulbfZyesCf7291.5033292.5267Sakmarian
11262Cf6 EulbfZyesCf6292.5267293.5200Sakmarian
11261Cf5 EulbfZyesCf5293.5200294.7050Asselian
11260Cf4 EulbfZyesCf4294.7050297.0000Asselian
11259Cf3 EulbfZyesCf3297.0000297.4500Asselian
11258Cf2 EulbfZyesCf2297.4500298.4400Asselian
11257Cf1 EulbfZyesCf1298.4400298.8900Asselian
11256Pf23 EulbfZyesPf23298.8900299.6850Gzhelian
11255Pf22 EulbfZyesPf22299.6850299.9500Gzhelian
11254Pf21 EulbfZyesPf21299.9500300.5200Gzhelian
11253Pf20 EulbfZyesPf20300.5200301.1415Gzhelian
11252Pf19 EulbfZyesPf19301.1415302.1200Gzhelian
11251Pf18 EulbfZyesPf18302.1200303.6778Gzhelian
11250Pf17 EulbfZyesPf17303.6778304.1500Kasimovian
11249Pf16 EulbfZyesPf16304.1500304.5500Kasimovian
11248Pf15 EulbfZyesPf15304.5500305.1900Kasimovian
11247Pf14 EulbfZyesPf14305.1900305.7700Kasimovian
11246Pf13 EulbfZyesPf13305.7700307.0200Kasimovian
11245Pf12 EulbfZyesPf12307.0200308.0300Moscovian
11244Pf11 EulbfZyesPf11308.0300309.0400Moscovian
11243Pf10 EulbfZyesPf10309.0400310.8800Moscovian
11242Pf9 EulbfZyesPf9310.8800311.0530Moscovian
11241Pf8 EulbfZyesPf8311.0530313.5500Moscovian
11240Pf7 EulbfZyesPf7313.5500314.8860Moscovian
11239Pf6 EulbfZyesPf6314.8860317.0500Bashkirian
11238Pf5 EulbfZyesPf5317.0500318.6600Bashkirian
11237Pf4 EulbfZyesPf4318.6600320.0500Bashkirian
11236Pf3 EulbfZyesPf3320.0500321.3875Bashkirian
11235Pf2 EulbfZyesPf2321.3875322.1225Bashkirian
11234Pf1 EulbfZyesPf1322.1225323.4000Bashkirian
11233MFZ15 EulbfZyesMFZ15323.4000332.1593Serpukhovian
11232MFZ14 EulbfZyesMFZ14332.1593334.3965Visean
11231MFZ13 EulbfZyesMFZ13334.3965336.0683Visean
11230MFZ12 EulbfZyesMFZ12336.0683340.1248Visean
11229MFZ11 EulbfZyesMFZ11340.1248342.9095Visean
11228MFZ10 EulbfZyesMFZ10342.9095345.0926Visean
11227MFZ9 EulbfZyesMFZ9345.0926346.7300Visean
11226MFZ8 EulbfZyesMFZ8346.7300347.0945Tournaisian
11225MFZ7 EulbfZyesMFZ7347.0945347.8236Tournaisian
11224MFZ6 EulbfZyesMFZ6347.8236348.9172Tournaisian
11223MFZ5 EulbfZyesMFZ5348.9172350.9198Tournaisian
11222MFZ4 EulbfZyesMFZ4350.9198352.0094Tournaisian
11221MFZ3 EulbfZyesMFZ3352.0094353.2149Tournaisian
11220MFZ2 EulbfZyesMFZ2353.2149356.4089Tournaisian
11219MFZ1 EulbfZyesMFZ1356.4089358.3459Tournaisian
11218DFZ8 EulbfZyesDFZ8358.3459359.8841Tournaisian

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 Benthic foraminifer zone abbreviation (Perm-Carb) column from the forams - Fusulinids dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma