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:498
dataset: forams - Fusulinids & bforams - NAmerica (dataset id: 89)
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=89) order by abv_ref, disambig

Lane, H. R. & Brenckle, P. L. (2005). Type Mississippian subdivisions and biostratigraphic succession. In, Heckel, P. H. (ed.) Stratigraphy and Biostratigraphy of the Mississippian Subsystem (Carboniferous System) in Its Type Region, the Mississippi River Valley of Illinois, Missouri, and Iowa International Union of Geological Sciences Subcommission on Carboniferous Stratigraphy Guidebook for Field Conference, St. Louis, Missouri, September 8-13, 2001. Illinois State Geological Survey, Handbook . 34: 76-98. gs

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

Column content


There are 11 intervals in the all events column of the forams - Fusulinids dataset (id=)
They range in age from 314.8860 Ma (Bashkirian) to 358.3459 Ma (Tournaisian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
10748Millerella marblensis - Globivalvulina moderata NAmCordlbfZyesMillerella marblensis - Globivalvulina moderata314.8860322.3780Bashkirian
10747Brenckleina rugosa - Eosigmoilina robertsoni NAmCordlbfZyesBrenckleina rugosa - Eosigmoilina robertsoni322.3780326.9116Serpukhovian
10746Archaediscus - Asteroarchaediscus - Neoarchaediscus NAmCordlbfZyesArchaediscus - Asteroarchaediscus - Neoarchaediscus326.9116334.0523Visean
10745Koktjubina - Septabrunsiina mackeei - Endostaffella discoidea NAmCordlbfZyesKoktjubina - Septabrunsiina mackeei - Endostaffella discoidea334.0523335.2570Visean
10744Endothyranopsis compressa - Eoendothyranopsis scitula NAmCordlbfZyesEndothyranopsis compressa - Eoendothyranopsis scitula335.2570342.0097Visean
10743Globoendothyra - Paraarchaediscus NAmCordlbfZyesGloboendothyra - Paraarchaediscus342.0097344.8197Visean
10742Eoendothyranopsis spiroides NAmCordlbfZyesEoendothyranopsis spiroides344.8197346.7300Visean
10741Spinoendothyra NAmCordlbfZyesSpinoendothyra346.7300352.0094Tournaisian
10740Spinotournayella tumula - Tuberendothyra tuberculata - Granuliferelloides NAmCordlbfZyesSpinotournayella tumula - Tuberendothyra tuberculata - Granuliferelloides352.0094353.2149Tournaisian
10739Granuliferella rjausakensis - Palaeospiroplectammina tchernyshinensis NAmCordlbfZyesGranuliferella rjausakensis - Palaeospiroplectammina tchernyshinensis353.2149355.1519Tournaisian
10738Bisphaera - Parathurammina NAmCordlbfZyesBisphaera - Parathurammina355.1519358.3459Tournaisian

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 North American Cordilleran zones column from the forams - Fusulinids dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma