arkL column viewer

arkL

View/edit a column - Eon

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:		column id:
dataset:		(dataset id: )
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=) order by abv_ref, disambig