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.

Select Column and time interval

select dataset & columntime intervalcm/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:318
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:

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

Column content


There are 19 intervals in the Graptolite Zones (general) column of the graptolites dataset (id=104)
They range in age from 443.9524 Ma (Hirnantian) to 485.2234 Ma (Tremadocian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
14472Metabolograptus extraordinarius BrGrZyesMetabolograptus extraordinarius443.9524445.2100Hirnantian
14471Dicellograptus anceps BrGrZyesDicellograptus anceps445.2100449.1297Katian
14470Dicellograptus complanatus BrGrZyesDicellograptus complanatus449.1297449.4033Katian
14469Pleurograptus linearis BrGrZyesPleurograptus linearis449.4033450.3856Katian
14468Dicranograptus clingani BrGrZyesDicranograptus clingani450.3856452.7500Katian
14467Mesograptus foliaceus BrGrZyesMesograptus foliaceus452.7500456.8008Sandbian
14466Nemagraptus gracilis BrGrZyesNemagraptus gracilis456.8008458.1772Sandbian
14465Hustedograptus teretiusculus BrGrZyesHustedograptus teretiusculus458.1772459.8037Darriwilian
14464Didymograptus murchisoni BrGrZyesDidymograptus murchisoni459.8037461.4302Darriwilian
14463Didymograptus artus BrGrZyesDidymograptus artus461.4302468.0702Darriwilian
14462Aulograptus cucullus BrGrZyesAulograptus cucullus468.0702469.4200Darriwilian
14461Isograptus gibberulus BrGrZyesIsograptus gibberulus469.4200470.6352Dapingian
14460Isograptus victoriae victoriae BrGrZyesIsograptus victoriae victoriae470.6352471.1508Dapingian
14459Expansograptus simulans BrGrZyesExpansograptus simulans471.1508473.1382Floian
14458Baltograptus varicosus BrGrZyesBaltograptus varicosus473.1382474.9009Floian
14457Tetragraptus phyllograptoides BrGrZyesTetragraptus phyllograptoides474.9009477.0791Floian
14456Araneograptus murrayi BrGrZyesAraneograptus murrayi477.0791481.1242Tremadocian
14454Adelograptus 'tenellus' BrGrZyesAdelograptus 'tenellus'481.5529482.6884Tremadocian
14453Rhabdinopora flabelliformis BrGrZyesRhabdinopora flabelliformis482.6884485.2234Tremadocian

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