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

Column content


There are 45 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
11460Palaeofusulina sinensis - Parananlingellia TlbfZyesPalaeofusulina sinensis - Parananlingellia251.9000252.6000Changhsingian
11459Palaeofusulina minima TlbfZyesPalaeofusulina minima252.6000254.2400Changhsingian
11458Galowainella meintiensis - Shindella pamirica - Paradunbarulla TlbfZyesGalowainella meintiensis - Shindella pamirica - Paradunbarulla254.2400258.1000Wuchiapingian
11457Codonofusiella kwangsiana - Pseudunbarula arpaensis - Lepidolina kurmaensis TlbfZyesCodonofusiella kwangsiana - Pseudunbarula arpaensis - Lepidolina kurmaensis258.1000259.5470Wuchiapingian
11456Yabeina globosa - first Nanlingella - Lepidolina multisepatata - Dunbarula mathieui TlbfZyesYabeina globosa - first Nanlingella - Lepidolina multisepatata - Dunbarula mathieui259.5470261.4760Capitanian
11455Yabeina archaica - Colania - Neoschwagerina margaritae - first Dunbarula. Kahlerina, Rauserella, Abadehella TlbfZyesYabeina archaica - Colania - Neoschwagerina margaritae - first Dunbarula. Kahlerina, Rauserella, Abadehella261.4760263.4050Capitanian
11454Neoschwagerina deprati - Afganella schenki TlbfZyesNeoschwagerina deprati - Afganella schenki263.4050264.8279Capitanian
11453Neoschwagerina confragaspira - Afganella tereshkovae TlbfZyesNeoschwagerina confragaspira - Afganella tereshkovae264.8279266.2886Wordian
11452Neoschwagerina simplex - Praesumatrina schellwieni TlbfZyesNeoschwagerina simplex - Praesumatrina schellwieni266.2886267.7493Wordian
11451Neoschwagerina tenuis - Praesumatrina neoschwagerinoides TlbfZyesNeoschwagerina tenuis - Praesumatrina neoschwagerinoides267.7493269.2100Wordian
11449Pseudodoliolina TlbfZyesPseudodoliolina269.2100275.4850Roadian
11450Cancellina cutalensis - Skinnerella yabei - first Eopolydiexodina TlbfZyesCancellina cutalensis - Skinnerella yabei - first Eopolydiexodina269.2100276.6000Roadian
11448Armenina pamirensis - first Skinnerella TlbfZyesArmenina pamirensis - first Skinnerella275.4850278.3875Kungurian
11447Misellina parvicostata - Praeskinnerella pavlovi TlbfZyesMisellina parvicostata - Praeskinnerella pavlovi278.3875281.9575Kungurian
11446Misellina minor - Brevaxina dyhrenfurthi - Praeskinnerella parviflucta TlbfZyesMisellina minor - Brevaxina dyhrenfurthi - Praeskinnerella parviflucta281.9575283.3000Kungurian
11445Chalaroschwagerina vulgaris - Ch. inflata - Darvasites contractus TlbfZyesChalaroschwagerina vulgaris - Ch. inflata - Darvasites contractus283.3000285.9900Artinskian
11444Chalaroschwagerina solita - Ch. gallowayi - Pamirina TlbfZyesChalaroschwagerina solita - Ch. gallowayi - Pamirina285.9900290.5100Artinskian
11443Robustoschwagerina schellwieni - Paraschwagerina mira - Sakmarella moelleri - Darvasites eocontractus - Zigarella postcallosa TlbfZyesRobustoschwagerina schellwieni - Paraschwagerina mira - Sakmarella moelleri - Darvasites eocontractus - Zigarella postcallosa290.5100293.5200Sakmarian
11442Schwagerina firma - Sphaeroschwagerina sphaerica TlbfZyesSchwagerina firma - Sphaeroschwagerina sphaerica293.5200294.7050Asselian
11441Schwagerina fecunda - Pseudoschwagerina robusta TlbfZyesSchwagerina fecunda - Pseudoschwagerina robusta294.7050297.0000Asselian
11440Pseudoschwagerina saibulakensis TlbfZyesPseudoschwagerina saibulakensis297.0000297.4500Asselian
11439Sphaeroschwagerina fusiformis TlbfZyesSphaeroschwagerina fusiformis297.4500298.4400Asselian
11438Sphaeroschwagerina vulgaris aktjubensis TlbfZyesSphaeroschwagerina vulgaris aktjubensis298.4400298.8900Asselian
11437Ultradaixina bosbytauensis - Schwagerina robusta TlbfZyesUltradaixina bosbytauensis - Schwagerina robusta298.8900299.9500Gzhelian
11436Daixina sokensis - Daixiana vasylkovskyi - Schellwienia modesta - Schellwienia malkovskyi - Dutkevitchia dastarensis TlbfZyesDaixina sokensis - Daixiana vasylkovskyi - Schellwienia modesta - Schellwienia malkovskyi - Dutkevitchia dastarensis299.9500301.1415Gzhelian
11435Daixina ruzhenzevi - Schagonella implexa TlbfZyesDaixina ruzhenzevi - Schagonella implexa301.1415302.1200Gzhelian
11434Daixina crispa - Schagonella proimplexa TlbfZyesDaixina crispa - Schagonella proimplexa302.1200302.8800Gzhelian
11433Schagoriella primitiva - Rauserites rossicus TlbfZyesSchagoriella primitiva - Rauserites rossicus302.8800303.6778Gzhelian
11432Raus. variabilis - Rauserites quasiarcticus TlbfZyesRaus. variabilis - Rauserites quasiarcticus303.6778304.5500Kasimovian
11431Montiparus subcrassulus TlbfZyesMontiparus subcrassulus304.5500305.1900Kasimovian
11430Montiparus paramontiparus TlbfZyesMontiparus paramontiparus305.1900305.7700Kasimovian
11429Protriticites pseudomontiparus - Obsoletes obsoletus TlbfZyesProtriticites pseudomontiparus - Obsoletes obsoletus305.7700307.0200Kasimovian
11428Protriticites ovoides - Praeobsoletes burkemensis - Quasifusulinoides fusiformis TlbfZyesProtriticites ovoides - Praeobsoletes burkemensis - Quasifusulinoides fusiformis307.0200308.0300Moscovian
11427Fusulinella bocki - Puchrella eopulchra TlbfZyesFusulinella bocki - Puchrella eopulchra308.0300309.0400Moscovian
11426Fusulinella colaniae - Beedeina kamensis TlbfZyesFusulinella colaniae - Beedeina kamensis309.0400310.8800Moscovian
11425Moellerites lopasnensis - Fusulinella subpulchra TlbfZyesMoellerites lopasnensis - Fusulinella subpulchra310.8800311.0530Moscovian
11424first Beedeina - Aljutovella priscoidea TlbfZyesfirst Beedeina - Aljutovella priscoidea311.0530313.5500Moscovian
11423Aljutovella aljutovica - Schubertella pauciseptata TlbfZyesAljutovella aljutovica - Schubertella pauciseptata313.5500314.8860Moscovian
11422Biseriella parva - Neoarchaediscus postrugosus TlbfZyesBiseriella parva - Neoarchaediscus postrugosus314.8860324.6284Bashkirian
11421Endothyranopsis crassus - Cribrospira mira TlbfZyesEndothyranopsis crassus - Cribrospira mira324.6284335.0161Serpukhovian
11420Eodiscus eospirillinoides - Lituotubella glomospiroides - ? - Dainella chomatica - Plectogyra gibbera TlbfZyesEodiscus eospirillinoides - Lituotubella glomospiroides - ? - Dainella chomatica - Plectogyra gibbera335.0161348.0970Visean
11419Tuberendothyra tuberculata - Tournayella gigantea TlbfZyesTuberendothyra tuberculata - Tournayella gigantea348.0970353.2149Tournaisian
11418Septabrunsiina krainica - Septatournayella segmentata TlbfZyesSeptabrunsiina krainica - Septatournayella segmentata353.2149355.1519Tournaisian
11417Bisphaera malevkensis TlbfZyesBisphaera malevkensis355.1519358.3459Tournaisian
11416Vicinesphaera angulata TlbfZyesVicinesphaera angulata358.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 Tethyan Benthic Foram Zone column from the forams - Fusulinids dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma