arkL column viewer

arkL

View/edit a column - Pelagic trilobites (Agnostids)

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:		Alternate Laurentia set column id:204
dataset:		trilobites (dataset id: 132)
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)/Trilobites and pre-Trilobite biostratigraphy/Laurentia trilobites

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

Column content

There are 9 intervals in the Pelagic trilobites (Agnostids) column of the trilobites dataset (id=132)
They range in age from 498.4000 Ma (Guzhangian) to 513.0892 Ma (Stage 4)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
15476	Cedaria AltLauTrZ	yes	Cedaria	498.4000	499.1350	Guzhangian
15475	Bolaspidella AltLauTrZ	yes	Bolaspidella	499.1350	504.5000	Drumian
15474	Oryctocephalus indicus AltLauTrZ	yes	Oryctocephalus indicus	504.5000	509.0000	Wuliuan
15473	Nephrolenellus multinodus AltLauTrZ	yes	Nephrolenellus multinodus	511.2000	511.5149	Stage 4
15472	Bolbolenellus euryparia AltLauTrZ	yes	Bolbolenellus euryparia	511.5149	511.8297	Stage 4
15471	Peachella iddingsi AltLauTrZ	yes	Peachella iddingsi	511.8297	512.1446	Stage 4
15470	Bristolia insolens AltLauTrZ	yes	Bristolia insolens	512.1446	512.4595	Stage 4
15469	Bristolia mohavensis AltLauTrZ	yes	Bristolia mohavensis	512.4595	512.7743	Stage 4
15468	Arcuolenellus arcuatus AltLauTrZ	yes	Arcuolenellus arcuatus	512.7743	513.0892	Stage 4

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 Alternate Laurentia set column from the trilobites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma