• 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 - ELMA

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:	ELMA MN-MP Ages Other European mammal zones Europe Mammal bioevents Other Europe events all events	Base stage/age:

Column metadata

Name:		MN-MP Ages column id:165
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 mammals Europe (dataset id: 61)
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:		Vertebrates (Land and Marine)/Mammals/Europe Mammals

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=61) order by abv_ref, disambig

Hilgen, F. J., Lourens, L. J. & Van Dam, J. A. (2012). The Neogene Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg (Coordinators), G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 409-440. gs

Speijer, R. P., et al. (2020). Chapter 28 - The Paleogene Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 2: 1087-1140. gs

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

Column content

There are 45 intervals in the ELMA column of the mammals Europe dataset (id=61)
They range in age from 0.0001 Ma (Chibanian) to 66.0400 Ma (Danian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
11909	MN19 (MQ4)		MN19 (MQ4)	0.0001	0.6000	Chibanian
5391	MQ3		MQ3	0.6000	1.0700	Calabrian
5392	MQ2		MQ2	1.0700	1.7700	Calabrian
5393	MQ1 (MN18)		MQ1 (MN18)	1.7700	2.0000	Gelasian
5394	MN17		MN17	2.0000	2.5000	Gelasian
5395	MN16		MN16	2.5000	3.6000	Piacenzian
5396	MN15		MN15	3.6000	5.0350	Zanclean
5397	MN14		MN14	5.0350	5.3350	Zanclean
5398	MN13		MN13	5.3350	7.0000	Messinian
5399	MN12		MN12	7.0000	7.6000	Tortonian
5400	MN11		MN11	7.6000	8.9000	Tortonian
5401	MN10		MN10	8.9000	9.9000	Tortonian
5402	MN9		MN9	9.9000	11.2000	Tortonian
5403	MN7-8		MN7-8	11.2000	13.4000	Serravallian
5404	MN6		MN6	13.4000	14.2000	Serravallian
5405	MN5		MN5	14.2000	16.4000	Langhian
5406	MN4		MN4	16.4000	17.2000	Burdigalian
5407	MN3		MN3	17.2000	19.5000	Burdigalian
5408	MN2		MN2	19.5000	22.8463	Aquitanian
5409	MN1		MN1	22.8463	23.0400	Aquitanian
5410	MP30		MP30	23.0400	23.2650	Chattian
5411	MP29		MP29	23.2650	23.9189	Chattian
5412	MP28		MP28	23.9189	24.5175	Chattian
5413	MP27		MP27	24.5175	25.4064	Chattian
5414	MP26		MP26	25.4064	27.2352	Chattian
5415	MP25		MP25	27.2352	28.8210	Rupelian
5416	MP24		MP24	28.8210	29.9700	Rupelian
5417	MP23		MP23	29.9700	30.8033	Rupelian
5418	MP22		MP22	30.8033	32.6547	Rupelian
5419	MP21		MP21	32.6547	33.7948	Rupelian
5420	MP20		MP20	33.7948	33.9049	Rupelian
5421	MP19		MP19	33.9049	35.1020	Priabonian
5422	MP18		MP18	35.1020	36.6542	Priabonian
5423	MP17b		MP17b	36.6542	36.8978	Priabonian
5424	MP17a		MP17a	36.8978	37.3850	Priabonian
5425	MP16		MP16	37.3850	40.5037	Bartonian
5426	MP14		MP14	40.5037	43.4500	Lutetian
5427	MP13		MP13	43.4500	45.0653	Lutetian
5428	MP12		MP12	45.0653	46.7383	Lutetian
5429	MP11		MP11	46.7383	48.0000	Lutetian
5430	MP10		MP10	48.0000	50.5248	Ypresian
5431	MP8-9		MP8-9	50.5248	56.0010	Ypresian
5432	MP7		MP7	56.0010	56.1010	Thanetian
5433	MP6		MP6	56.1010	57.7212	Thanetian
5434	MP1-5		MP1-5	57.7212	66.0400	Danian

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 MN-MP Ages column from the mammals Europe dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma