arkL column viewer

arkL

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.

Columns which have not yet had data imported into this database are not shown.
Column colour is based on the dataset/subdataset so the options to change colour are given on the dataset page.
Most col names have been copied from TSC, to activate an existing column enter the dataset_id directly in the arkL_columns database
Once columns exist and are assigned to a datset they can be edited from this page
Events and intervals are not directly assigned to a column in the database instead the column metadata defines which events and intervals are selected

Select Column and time interval

select dataset & column		time interval		cm/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:		Radiolarian Zone (southern mid- and high latitude) column id:154
dataset:		radiolaria Southen mid & high lat (dataset id: 60)
column_type:		pointdata_table:
Column properties:		Width: Colour:
Field for labels/data:		source_col id:
TSC notes:		Mainly from Chris Hollis (GTS2020; and pers. commun. to J.Ogg in 2019). Cenozoic radiolarian datums have popups with URL links to Mikrotax for taxonomy and images.
Compilation notes:
refs to add:
linked refs:
Path:		Microfossils/Siliceous Microfossils/Radiolarians/Cenozoic-Jurassic Radiolarians/Southern mid - latitude zRP and Antarctic zRP zones

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

Column content

There are 18 intervals in the all events column of the radiolaria Southen mid dataset (id=)
They range in age from 23.0400 Ma (Chattian) to 66.0400 Ma (Danian)

id	intervalx	TSC label	top_age	base_age	stage
5071	[ un-zoned above aRP17 ]	[ un-zoned above aRP17 ]	23.0400	26.1169	Chattian
5072	aRP17	aRP17	26.1169	28.1958	Chattian
5073	aRP16	aRP16	28.1958	29.5220	Rupelian
5074	aRP15	aRP15	29.5220	33.5314	Rupelian
5075	aRP14	aRP14	33.5314	37.8548	Priabonian
5076	zRP13	zRP13	37.8548	39.5228	Bartonian
5077	zRP12	zRP12	39.5228	42.7666	Lutetian
5078	zRP11	zRP11	42.7666	43.5475	Lutetian
5079	zRP10	zRP10	43.5475	51.5239	Lutetian
5080	zRP9	zRP9	51.5239	54.1881	Ypresian
5081	zRP8	zRP8	54.1881	56.0010	Ypresian
5082	zRP7	zRP7	56.0010	57.5006	Thanetian
5083	zRP6	zRP6	57.5006	60.5233	Thanetian
5084	zRP5	zRP5	60.5233	62.4292	Selandian
5085	zRP4	zRP4	62.4292	64.0134	Danian
5086	zRP3	zRP3	64.0134	64.8186	Danian
5087	zRP2	zRP2	64.8186	65.4821	Danian
5088	zRP1	zRP1	65.4821	66.0400	Danian

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 Radiolarian Zone (southern mid- and high latitude) column from the radiolaria Southen mid dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma