arkL column viewer

arkL

View/edit a column - Graptolite Zones (general)

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 Ordovician graptolite subzone abbreviations column id:516
dataset:		graptolites (dataset id: 104)
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)/Graptolites/Regional Graptolite zones/Australian Ordovician graptolites

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

Column content

There are 11 intervals in the Graptolite Zones (general) column of the graptolites dataset (id=104)
They range in age from 458.1772 Ma (Carnian) to 484.3413 Ma (Tremadocian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
14337	Da4b AusGrZ	yes	b	458.1772	459.8037	Carnian
14336	Da4a AusGrZ	yes	a	459.8037	461.4302	Darriwilian
14335	Be4 AusGrZ	yes	Be4	473.1382	473.5789	Carnian
14334	Be3 AusGrZ	yes	Be3	473.5789	474.0195	Holocene
14333	Be2 AusGrZ	yes	Be2	474.0195	474.4602	Holocene
14332	Be1 AusGrZ	yes	Be1	474.4602	474.9009	Floian
14331	La2b AusGrZ	yes	La2b	474.9009	481.1242	Tremadocian
14330	La2a AusGrZ	yes	La2a	481.1242	481.7838	Tremadocian
14329	La1b AusGrZ	yes	b	481.7838	482.6884	Tremadocian
14328	la1? AusGrZ	yes	?	482.6884	484.0748	Tremadocian
14327	La1a AusGrZ	yes	a	484.0748	484.3413	Tremadocian

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 Ordovician graptolite subzone abbreviations column from the graptolites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma