• arkL
  • notes
  • introduction and login
  • notes on sequence data
  • notes on data table creation
  • view data
  • multicolumn view
  • dataset view
  • column view
  • event view
  • interval view
  • references
  • taxon links
  • data upload & integration
  • upload data
  • populate (integrate and check data)

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:	chronostratigraphyQuaternary Regional Stagesstages Australian (Cenoz, Sil-Ord)stages Baltoscania (Sil_Ord)stages Boreal (Late J/early K)stages British (Late J/early K)stages California (Cenozoic)stages Donets Basin (Carb)stages Iberian-Morocco (Ord-Camb)stages Japan (Neogene, Cret)stages Kazakhistan (Camb)stages New Zealandstages North American (Cret & Palaeozoic)stages North China (Camb)stages Paratethys (Neogene)stages Russia (Permo-Carb, Camb)stages Siberia (Carb, Camb)stages South China (Jur -> Camb)stages Tethyan - Pamirs (Permian)stages Tethyan - Salt Range (Permian)stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassicstrat - German Triassicstrat - type Mississippianstrat - Yangtse Platform (China, Tr)strat - Yorkshire Oxfordiananoxic episodesLower Paleozoic Time Slicesbiotic eventsmagnetochronologymagnetochronology - Jurassic pre M26 PacDeepTow at depthmagnetochronology - Quaternary eventsmagnetochronology - Triassic outcropmagnetochronology- Jurassic outcropammonites Russian Borealammonites Siberian Borealammonites Sub-Borealammonites Tethyanammonites Western Interiorbelemnites Balto-Scandiabelemnites Borealbelemnites Russian platform belemnites Tethyangraptolitestrilobitesbivalves Siberianbivalves Triassicbrachiopods Borealbrachiopods Tethyaninoceramids Aquitaineinoceramids Russian platforminoceramids Western Europeinoceramids Western interiorrudistsarchaeocyathsdacryoconarids (tentaculitids)conchostracansconodontsconodonts Australiaconodonts NAmostracods Borealostracods Devonianostracods Frenchostracods Tethyancalcareous algaecalpionellidscharophytesdiatoms low-latdiatoms mid-lat NPacdiatoms Soceanforams - Fusulinids & bforams - Eurasiaforams - Fusulinids & bforams - NAmericaforams - LBF letter stagesforams - LBFsforams - LBFs- French 1997 datumsforams - microfossils North Seaforams - plankticforams - SBFs Borealforams - SBFs Frenchforams - SBFs Tethyannannos Borealnannos Tethyanradiolaria low-latradiolaria Permo-Triassicradiolaria Southen mid & high latacritarchschitinozoadflgs Borealdflgs North Seadflgs NW Europedflgs Tethyanmiospores - Australianmiospores - E Europeanmiospores - SEAustralianmiospores - W Europeanpollen & spores - Arctic Triassicpollen & spores - German Triassicmacrofloramammals Asia & Chinamammals Australianmammals Europemammals North Americamammals South AmericaVert - AcanthodiansVert - Australian Early FishVert - Fish and Reptile faunachronsVert - PlacodermsVert - Sharkscyclostrat Martinez cyclessea-level Slilurian Loydell 98sequences - Boreal Jurassicsequences - Devoniansequences - Devonian Johnson85 T-Rsequences - NAm Ordovician of Hollandsequences & sea-level Silurian & Ordoviciansequences Carb Donets Basinsequences Carb Eurasiansequences globalsequences Perm-Carb-Dev NAmAntarctic CO2Antarctic delta-DeuteriumCarbon-13 compositeCarbon-13 eventsCenogrid - Westerhold2020Chinese Loess Mag suscLisiecki&Raymo 2005Marine Isotope StagesMilankovitch parametersOxygen-18 Cramer 2009Oxygen-18 eventsStrontiumMiller et al 2020	Top stage/age:
Column:	Graptolite Zones (general) Graptolite markers Australian Ordovician graptolite zones Australian Ordovician graptolite zone abbreviations Australian Ordovician graptolite subzone abbreviations Australian Ordovician graptolite other events North American graptolite zones N. American graptolite zones within S. turb superzone South China graptolite zones British graptolite zones British graptolite subzones (or other divisions) Baltoscandia graptolite zones Baltoscandia graptolite subzones (or other divisions) all events	Base stage/age:

Column metadata

Name:		North American graptolite zones column id:313
dataset:		chronostratigraphy Quaternary Regional Stages stages Australian (Cenoz, Sil-Ord) stages Baltoscania (Sil_Ord) stages Boreal (Late J/early K) stages British (Late J/early K) stages California (Cenozoic) stages Donets Basin (Carb) stages Iberian-Morocco (Ord-Camb) stages Japan (Neogene, Cret) stages Kazakhistan (Camb) stages New Zealand stages North American (Cret & Palaeozoic) stages North China (Camb) stages Paratethys (Neogene) stages Russia (Permo-Carb, Camb) stages Siberia (Carb, Camb) stages South China (Jur -> Camb) stages Tethyan - Pamirs (Permian) stages Tethyan - Salt Range (Permian) stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassic strat - German Triassic strat - type Mississippian strat - Yangtse Platform (China, Tr) strat - Yorkshire Oxfordian anoxic episodes Lower Paleozoic Time Slices biotic events magnetochronology magnetochronology - Jurassic pre M26 PacDeepTow at depth magnetochronology - Quaternary events magnetochronology - Triassic outcrop magnetochronology- Jurassic outcrop ammonites Russian Boreal ammonites Siberian Boreal ammonites Sub-Boreal ammonites Tethyan ammonites Western Interior belemnites Balto-Scandia belemnites Boreal belemnites Russian platform belemnites Tethyan graptolites trilobites bivalves Siberian bivalves Triassic brachiopods Boreal brachiopods Tethyan inoceramids Aquitaine inoceramids Russian platform inoceramids Western Europe inoceramids Western interior rudists archaeocyaths dacryoconarids (tentaculitids) conchostracans conodonts conodonts Australia conodonts NAm ostracods Boreal ostracods Devonian ostracods French ostracods Tethyan calcareous algae calpionellids charophytes diatoms low-lat diatoms mid-lat NPac diatoms Socean forams - Fusulinids & bforams - Eurasia forams - Fusulinids & bforams - NAmerica forams - LBF letter stages forams - LBFs forams - LBFs- French 1997 datums forams - microfossils North Sea forams - planktic forams - SBFs Boreal forams - SBFs French forams - SBFs Tethyan nannos Boreal nannos Tethyan radiolaria low-lat radiolaria Permo-Triassic radiolaria Southen mid & high lat acritarchs chitinozoa dflgs Boreal dflgs North Sea dflgs NW Europe dflgs Tethyan miospores - Australian miospores - E European miospores - SEAustralian miospores - W European pollen & spores - Arctic Triassic pollen & spores - German Triassic macroflora mammals Asia & China mammals Australian mammals Europe mammals North America mammals South America Vert - Acanthodians Vert - Australian Early Fish Vert - Fish and Reptile faunachrons Vert - Placoderms Vert - Sharks cyclostrat Martinez cycles sea-level Slilurian Loydell 98 sequences - Boreal Jurassic sequences - Devonian sequences - Devonian Johnson85 T-R sequences - NAm Ordovician of Holland sequences & sea-level Silurian & Ordovician sequences Carb Donets Basin sequences Carb Eurasian sequences global sequences Perm-Carb-Dev NAm Antarctic CO2 Antarctic delta-Deuterium Carbon-13 composite Carbon-13 events Cenogrid - Westerhold2020 Chinese Loess Mag susc Lisiecki&Raymo 2005 Marine Isotope Stages Milankovitch parameters Oxygen-18 Cramer 2009 Oxygen-18 events Strontium Miller et al 2020 graptolites (dataset id: 104)
column_type:		intervals events lithology range chart sequence pointdata bar chart graphic sea-level curve images stacked filled curve 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/North American 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=313 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

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

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
14423	Metabolograptus extraordinarius NAmGrZ	yes	Metabolograptus extraordinarius	443.9524	445.2100	Hirnantian
14422	Paraorthograptus pacificus NAmGrZ	yes	Paraorthograptus pacificus	445.2100	448.5895	Katian
14421	Dicellograptus ornatus NAmGrZ	yes	Dicellograptus ornatus	448.5895	449.1297	Katian
14420	Dicellograptus complanatus NAmGrZ	yes	Dicellograptus complanatus	449.1297	449.4033	Katian
15964	Styracograptus tubuliferus NAmGrZ	yes	Styracograptus tubuliferus	449.4033	450.3856	Katian
14417	Diplacanthograptus spiniferus NAmGrZ	yes	Diplacanthograptus spiniferus	450.3856	451.3314	Katian
14416	Diplacanthograptus caudatus NAmGrZ	yes	Diplacanthograptus caudatus	451.3314	452.7500	Katian
14415	Climacograptus bicornis NAmGrZ	yes	Climacograptus bicornis	452.7500	456.8008	Sandbian
14414	Nemagraptus gracilis NAmGrZ	yes	Nemagraptus gracilis	456.8008	458.1772	Sandbian
14413	Hustedograptus teretiusculus NAmGrZ	yes	Hustedograptus teretiusculus	458.1772	459.8037	Darriwilian
14412	Pterograptus elegans NAmGrZ	yes	Pterograptus elegans	461.4302	464.3712	Darriwilian
14411	Nicholsonograptus fasciculatus NAmGrZ	yes	Nicholsonograptus fasciculatus	464.3712	466.3319	Darriwilian
14410	Holmograptus lentus NAmGrZ	yes	Holmograptus lentus	466.3319	468.0702	Darriwilian
14409	Levisograptus dentatus NAmGrZ	yes	Levisograptus dentatus	468.0702	469.2290	Darriwilian
14408	Levisograptus austrodentatus NAmGrZ	yes	Levisograptus austrodentatus	469.2290	469.4200	Darriwilian
14407	Oncograptus NAmGrZ	yes	Oncograptus	469.4200	470.3946	Dapingian
14406	Isograptus victoriae maximus NAmGrZ	yes	Isograptus victoriae maximus	470.3946	470.6352	Dapingian
14405	Isograptus victoriae victoriae NAmGrZ	yes	Isograptus victoriae victoriae	470.6352	471.1508	Dapingian
14404	Isograptus victoriae lunatus NAmGrZ	yes	Isograptus victoriae lunatus	471.1508	471.2633	Dapingian
14403	Didymograptellus bifidus NAmGrZ	yes	Didymograptellus bifidus	471.2633	473.1382	Floian
14402	Tshallograptus fruticosus NAmGrZ	yes	Tshallograptus fruticosus	473.1382	473.8433	Floian
14401	Tetragraptus akzharensis NAmGrZ	yes	Tetragraptus akzharensis	473.8433	474.7246	Floian
14400	Tetragraptus approximatus NAmGrZ	yes	Tetragraptus approximatus	474.7246	477.0791	Floian
14399	Paradelograptus pritchardi NAmGrZ	yes	Paradelograptus pritchardi	477.0791	481.2561	Tremadocian
14398	Paradelograptus antiquus NAmGrZ	yes	Paradelograptus antiquus	481.2561	481.5529	Tremadocian
14397	Adelograptus tenellus gr. NAmGrZ	yes	Adelograptus tenellus gr.	481.7838	482.6884	Tremadocian
14396	Rhabdinopora anglica NAmGrZ	yes	Rhabdinopora anglica	482.6884	484.0748	Tremadocian
14395	Anisograptus matanensis NAmGrZ	yes	Anisograptus matanensis	484.0748	484.3413	Tremadocian
14394	Rhabdinopora parabola NAmGrZ	yes	Rhabdinopora parabola	484.3413	485.2234	Tremadocian
14393	Rhabdinopora praeparabola NAmGrZ	yes	Rhabdinopora praeparabola	485.2234	486.4532	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 North American graptolite zones column from the graptolites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma