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:248
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;
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

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

Column content


There are 19 intervals in the all events column of the forams - Fusulinids dataset (id=)
They range in age from 323.4000 Ma (Serpukhovian) to 361.0700 Ma (Famennian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
11364Mf18 DavydovlbfZyesMf18323.4000324.6284Serpukhovian
11363Mf17 DavydovlbfZyesMf17324.6284326.9116Serpukhovian
11362Mf16 DavydovlbfZyesMf16326.9116327.9130Serpukhovian
11361Mf15 DavydovlbfZyesMf15327.9130330.3400Serpukhovian
11360Mf14 DavydovlbfZyesMf14330.3400331.8151Visean
11359Mf13 DavydovlbfZyesMf13331.8151333.8372Visean
11358Mf12 DavydovlbfZyesMf12333.8372335.0161Visean
11357Mf11 DavydovlbfZyesMf11335.0161341.5172Visean
11356Mf10 DavydovlbfZyesMf10341.5172342.9095Visean
11355Mf9 DavydovlbfZyesMf9342.9095345.0926Visean
11354Mf8 DavydovlbfZyesMf8345.0926346.7300Visean
11353Mf7 DavydovlbfZyesMf7346.7300348.0970Tournaisian
11352Mf6 DavydovlbfZyesMf6348.0970352.0094Tournaisian
11351Mf5 DavydovlbfZyesMf5352.0094353.2149Tournaisian
11350Mf4 DavydovlbfZyesMf4353.2149355.1519Tournaisian
11349Mf3 DavydovlbfZyesMf3355.1519356.4089Tournaisian
11348Mf2 DavydovlbfZyesMf2356.4089358.3459Tournaisian
11347Mf1 DavydovlbfZyesMf1358.3459360.4806Famennian
11346Df1 DavydovlbfZyesDf1360.4806361.0700Famennian

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 Foram zone abbreviation of Davydov for Mississippian column from the forams - Fusulinids dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma