• 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 - N.Amer. inoceramid zones

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:	N.Amer. inoceramid zones Close-spaced N.Amer. inoceramid zones (Lt.Cenom-E.Coniac.) all events	Base stage/age:

Column metadata

Name:		N.Amer. inoceramid zones column id:91
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 inoceramids Western interior (dataset id: 37)
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)/Other Marine and Lacustrine Macrofossils/Bivalves (Inoceramids, Pelecypods, etc.)/Cretaceous Inoceramids

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

Cobban, W. A., et al. (2006). A USGS zonal table for the Upper Cretaceous Middle Cenomanian-Maastrichtian of the Western Interior of the United States based on Ammonites, Inoceramids, and Radiometric Ages. U.S. Geological Survey Open-file Report. 1250 2006,: 1-45. gs

Gale, A. S. (2020). Chapter 3K - Cretaceous microcrinoids. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 1: 122-124. gs

Hardenbol, J., et al. (1998). Mesozoic and Cenozoic Sequence Chronostratigraphic Framework of European Basins. In, de Graciansky, P. -C. , Hardenbol, J. , Jacquin, T. , and Vail, P. R. (ed.) Mesozoic- Cenozoic Sequence Stratigraphy of European Basins. SEPM Special Publication . 60: 3-13 & appendix 763-783. 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=91 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content

There are 38 intervals in the N.Amer. inoceramid zones column of the inoceramids Western interior dataset (id=37)
They range in age from 66.0400 Ma (Maastrichtian) to 100.9050 Ma (Albian)

id	intervalx	has_added_abv	TSC label	top_age	base_age	stage
3401	Tenuipteris argentea WInoZ	yes	Tenuipteris argentea	66.0400	69.9100	Maastrichtian
3402	Inoceramus ianjonaensis WInoZ	yes	Inoceramus ianjonaensis	69.9100	70.4400	Maastrichtian
3403	Trochoceramus radiosus WInoZ	yes	Trochoceramus radiosus	70.4400	71.1300	Maastrichtian
3404	"Inoceramus" incurvus WInoZ	yes	"Inoceramus" incurvus	71.1300	71.5900	Maastrichtian
3405	Endocostea typica WInoZ	yes	Endocostea typica	71.5900	72.0500	Maastrichtian
3406	"Inoceramus" redbirdensis WInoZ	yes	"Inoceramus" redbirdensis	72.0500	72.8990	Campanian
3407	"Inoceramus" inkermaenensis WInoZ	yes	"Inoceramus" inkermaenensis	72.8990	73.6300	Campanian
3408	"Inoceramus" altus WInoZ	yes	"Inoceramus" altus	73.6300	74.6000	Campanian
3409	Sphaeroceramus pertenuiformis WInoZ	yes	Sphaeroceramus pertenuiformis	74.6000	75.6400	Campanian
3410	"Inoceramus" tenuilineatus WInoZ	yes	"Inoceramus" tenuilineatus	75.6400	78.3400	Campanian
3411	Cataceramus subcompressus WInoZ	yes	Cataceramus subcompressus	78.3400	79.8110	Campanian
3412	"Inoceramus" azerbaydjanensis WInoZ	yes	"Inoceramus" azerbaydjanensis	79.8110	80.9700	Campanian
3413	Cataceramus balticus WInoZ	yes	Cataceramus balticus	80.9700	82.9735	Campanian
3414	Sphenoceramus lundbreckensis WInoZ	yes	Sphenoceramus lundbreckensis	82.9735	84.5400	Santonian
3415	Cordiceramus muelleri WInoZ	yes	Cordiceramus muelleri	84.5400	84.8200	Santonian
3416	Cordiceramus cordiformis WInoZ	yes	Cordiceramus cordiformis	84.8200	85.1000	Santonian
3417	Cordiceramus bueltenensis WInoZ	yes	Cordiceramus bueltenensis	85.1000	85.3000	Santonian
3418	Cladoceramus undulatoplicatus WInoZ	yes	Cladoceramus undulatoplicatus	85.3000	85.7000	Santonian
3419	Magadiceramus crenelatus WInoZ	yes	Magadiceramus crenelatus	85.7000	86.5500	Coniacian
3420	Magadiceramus subquadratus WInoZ	yes	Magadiceramus subquadratus	86.5500	87.5000	Coniacian
3421	Volviceramus WInoZ	yes	Volviceramus	87.5000	88.0900	Coniacian
3422	Cremnoceramus crassus WInoZ	yes	Cremnoceramus crassus	88.0900	88.7400	Coniacian
3423	Cremnoceramus deformis erectus WInoZ	yes	Cremnoceramus deformis erectus	88.7400	89.3900	Coniacian
3424	Cremnoceramus waltersdorfensis WInoZ	yes	Cremnoceramus waltersdorfensis	89.3900	89.9420	Turonian
3425	Mytiloides scupini WInoZ	yes	Mytiloides scupini	89.9420	90.7000	Turonian
3426	Inoceramus dimidius WInoZ	yes	Inoceramus dimidius	90.7000	91.0300	Turonian
3427	Inoceramus howelli WInoZ	yes	Inoceramus howelli	91.0300	91.2200	Turonian
3428	Inoceramus n.sp. WInoZ	yes	Inoceramus n.sp.	91.2200	91.7000	Turonian
3429	Mytiloides hercynicus WInoZ	yes	Mytiloides hercynicus	91.7000	92.3000	Turonian
3430	Mytiloides subhercynicus WInoZ	yes	Mytiloides subhercynicus	92.3000	92.9000	Turonian
3431	Mytiloides mytiloides WInoZ	yes	Mytiloides mytiloides	92.9000	93.3500	Turonian
3432	Mytiloides kossmati WInoZ	yes	Mytiloides kossmati	93.3500	93.5500	Turonian
3433	Mytiloides puebloensis WInoZ	yes	Mytiloides puebloensis	93.5500	93.9000	Turonian
3434	Inoceramus pictus WInoZ	yes	Inoceramus pictus	93.9000	95.5700	Cenomanian
3435	Inoceramus schoendorfi WInoZ	yes	Inoceramus schoendorfi	95.5700	96.2400	Cenomanian
3436	Inoceramus virgatus WInoZ	yes	Inoceramus virgatus	96.2400	98.3700	Cenomanian
3437	Inoceramus crippsi WInoZ	yes	Inoceramus crippsi	98.3700	100.2500	Cenomanian
3438	Inoceramus anglicus WInoZ	yes	Inoceramus anglicus	100.2500	100.9050	Albian

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 N.Amer. inoceramid zones column from the inoceramids Western interior dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma