arkL column viewer

arkL

View/edit a column - Australian Conodont Zone

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:		Australian Conodont Zone column id:304
dataset:		conodonts Australia (dataset id: 133)
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:		Marine Macrofossils (Mesozoic-Paleozoic)/Conodonts/Conodont zones (regional and alternate)/Ordovician other conodont zonations/Cambrian Australia conodont 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=133) 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=304 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 9 intervals in the Australian Conodont Zone column of the conodonts Australia dataset (id=133)
They range in age from 482.4622 Ma (Tremadocian) to 491.9600 Ma (Jiangshanian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
15490	Cordylodus angulatus AusCdont	yes	Cordylodus angulatus	482.4622	485.2234	Tremadocian
15489	Cordylodus lindstromi AusCdont	yes	Cordylodus lindstromi	485.2234	487.0575	Tremadocian
15488	Cordylodus prolindstromi AusCdont	yes	Cordylodus prolindstromi	487.0575	487.3480	Stage 10
15487	Hirsutodontus simplex AusCdont	yes	Hirsutodontus simplex	487.3480	487.6966	Stage 10
15486	Cordylodus proavus AusCdont	yes	Cordylodus proavus	487.6966	488.2195	Stage 10
15485	Hispidodontus discretus AusCdont	yes	Hispidodontus discretus	488.2195	488.7756	Stage 10
15484	Hispidodontus appressus AusCdont	yes	Hispidodontus appressus	488.7756	489.3317	Stage 10
15483	Hispidodontus resimus AusCdont	yes	Hispidodontus resimus	489.3317	491.0000	Stage 10
15482	Teridontus nakamurai AusCdont	yes	Teridontus nakamurai	491.0000	491.9600	Jiangshanian

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 Australian Conodont Zone column from the conodonts Australia dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma