View/edit a column - S. Ocean Diatom Zones

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:77
dataset: diatoms Socean (dataset id: 59)
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=59) order by abv_ref, disambig

Barron, J. A., Stickley, C. E. & Bukry, D. (2015). Paleoceanographic, and paleoclimatic constraints on the global Eocene diatom and silicoflagellate record. Palaeogeography Palaeoclimatology Palaeoecology. 422: 85-100. gs

Berggren, W. A., et al. (1995). A revised Cenozoic geochronology and chronostratigraphy. In, Berggren, W. A. , Kent, D. V. , Aubry, M. -P. , and Hardenbol, J. (ed.) Geochronology, Time Scales and Global Stratigraphic Correlations: A Unified Temporal Framework for a Historical Geology. SEPM Special Publication . 54: 129-212. gs

Scherer, R. P., Gladenkov, A. Y. & Barron, J. A. (2007). Methods and applications of Cenozoic marine diatom biostratigraphy. In, Starratt, S. (ed.) Pond Scum to Carbon Sink: Geological and Environmental Applications of the Diatoms. Paleontological Society Papers . 13: 61-83. 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=77 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 11 intervals in the S. Ocean Diatom Zones column of the diatoms Socean dataset (id=59)
They range in age from 17.5201 Ma (Burdigalian) to 34.2000 Ma (Rupelian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
6014Thalassiosira praefraga c hlDiatSZyesc17.520118.0070Burdigalian
6013Thalassiosira praefraga b hlDiatSZyesb18.007018.9956Burdigalian
6006Thalassiosira praefraga a hlDiatSZyesa18.995620.1820Burdigalian
6008Thalassiosira spumellaroides b hlDiatSZyesb20.182020.4480Burdigalian
6007Thalassiosira spumellaroides a hlDiatSZyesa20.448021.8000Aquitanian
6010Rocella gelida c hlDiatSZyesc21.800023.4863Aquitanian
6012Rocella gelida b hlDiatSZyesb23.486324.5565Chattian
6005Rocella gelida a hlDiatSZyesa24.556525.0990Chattian
6011Rhizosolenia oligocaenica c hlDiatSZyesc30.687530.9770Rupelian
6009Rhizosolenia oligocaenica b hlDiatSZyesb30.977031.8718Rupelian
6004Rhizosolenia oligocaenica a hlDiatSZyesa31.871834.2000Rupelian

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 S. Ocean Diatom SubZones column from the diatoms Socean dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma