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

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:	NALMA NALMA Subzones N.Amer. Mammal bioevents Other N.Amer. bioevents all events	Base stage/age:

Column metadata

Name:		NALMA Subzones column id:177
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 North America (dataset id: 48)
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/North American 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=48) 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

Woodburne, M. O. (2004). Late Cretaceous and Cenozoic Mammals of North America: Biostratigraphy and Geochronology. New York: Columbia University Press. 1-376. 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=177 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 63 intervals in the NALMA column of the mammals North America dataset (id=48)
They range in age from 0.1933 Ma (Chibanian) to 66.0400 Ma (Danian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
5308	Ir3		Ir3	0.1933	0.3866	Chibanian
5309	Ir2		Ir2	0.3866	0.8924	Chibanian
5310	Ir1		Ir1	0.8924	1.9250	Calabrian
5311	Bl5		Bl5	1.9250	2.6168	Gelasian
5312	Bl4		Bl4	2.6168	3.0992	Piacenzian
5313	Bl3		Bl3	3.0992	4.0983	Piacenzian
5314	Bl2		Bl2	4.0983	4.6103	Zanclean
5315	Bl1		Bl1	4.6103	4.9061	Zanclean
5316	Hh4		Hh4	4.9061	5.7866	Messinian
5317	Hh3		Hh3	5.7866	6.5906	Messinian
5318	Hh2		Hh2	6.5906	7.4990	Messinian
5319	Hh1		Hh1	7.4990	9.0716	Tortonian
5320	Cl3		Cl3	9.0716	10.0376	Tortonian
5321	Cl2		Cl2	10.0376	12.0802	Tortonian
5322	Cl1		Cl1	12.0802	12.5654	Serravallian
5323	Ba2		Ba2	12.5654	15.0400	Serravallian
5324	Ba1		Ba1	15.0400	15.9940	Langhian
5325	He2		He2	15.9940	17.4660	Burdigalian
5326	He1		He1	17.4660	18.4725	Burdigalian
5327	Ar4		Ar4	18.4725	19.2203	Burdigalian
5328	Ar3		Ar3	19.2203	22.3420	Aquitanian
5329	Ar2		Ar2	22.3420	28.0000	Chattian
5330	Ar1		Ar1	28.0000	29.7485	Rupelian
5331	Wh2		Wh2	29.7485	31.5362	Rupelian
5332	Wh1		Wh1	31.5362	32.0955	Rupelian
5333	TOP		TOP	32.0955	33.9049	Rupelian
5334	Ch4		Ch4	33.9049	35.1020	Priabonian
5335	Ch3		Ch3	35.1020	35.7740	Priabonian
5336	Ch2		Ch2	35.7740	36.4620	Priabonian
5337	Ch1		Ch1	36.4620	37.3850	Priabonian
5338	Du2		Du2	37.3850	38.6940	Bartonian
5339	Du1		Du1	38.6940	41.1050	Bartonian
5340	Ui3		Ui3	41.1050	42.8230	Lutetian
5341	Ui2		Ui2	42.8230	45.8173	Lutetian
5342	Ui1		Ui1	45.8173	47.5312	Lutetian
5343	Br3		Br3	47.5312	48.6544	Ypresian
5344	Br2		Br2	48.6544	49.5872	Ypresian
5345	Br1b		Br1b	49.5872	50.3266	Ypresian
5346	Br1a		Br1a	50.3266	51.8096	Ypresian
5347	Br0		Br0	51.8096	52.0096	Ypresian
5348	Wa7		Wa7	52.0096	52.9300	Ypresian
5349	Wa6		Wa6	52.9300	53.2500	Ypresian
5350	Wa5		Wa5	53.2500	53.9640	Ypresian
5351	Wa4		Wa4	53.9640	54.5402	Ypresian
5352	Wa3		Wa3	54.5402	55.0204	Ypresian
5353	Wa2		Wa2	55.0204	55.5005	Ypresian
5354	Wa1		Wa1	55.5005	55.7566	Ypresian
5355	Wa0		Wa0	55.7566	55.9510	Ypresian
5356	Wa-M		Wa-M	55.9510	56.0010	Ypresian
5357	Cf3		Cf3	56.0010	56.5248	Thanetian
5358	Cf2		Cf2	56.5248	57.0370	Thanetian
5359	Cf1		Cf1	57.0370	57.2398	Thanetian
5360	Ti6		Ti6	57.2398	57.6560	Thanetian
5361	Ti5		Ti5	57.6560	58.9590	Thanetian
5362	Ti4		Ti4	58.9590	59.9973	Selandian
5363	Ti3		Ti3	59.9973	60.8301	Selandian
5364	Ti2		Ti2	60.8301	61.6630	Selandian
5365	Ti1		Ti1	61.6630	62.2780	Danian
5366	To3		To3	62.2780	62.5300	Danian
5367	To2		To2	62.5300	63.5370	Danian
5368	To1		To1	63.5370	64.7535	Danian
5369	Pu2/3		Pu2/3	64.7535	65.8360	Danian
5370	Pu1		Pu1	65.8360	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 NALMA Subzones column from the mammals North America dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma