View/edit a column - Eon

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:89
dataset: chronostratigraphy (dataset id: 1)
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=1) order by abv_ref, disambig

Davydov, V. I., Wardlaw, B. R. & Gradstein, F. M. (2004). The Carboniferous Period. In, Gradstein, F. M. , Ogg, J. G. , and Smith, A. G. (ed.) A Geologic Time Scale 2004. Cambridge: Cambridge University Press 222-248. gs

Davydov, V. I., et al. (2012). Chapter 23 the Carboniferous Period. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2012. Amsterdam: Elsevier Press 603-651. gs

Gale, A. S., Mutterlose, J. & Batenburg, S. (2020). Chapter 27 - The Cretaceous 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: 1023-1086. gs

Gale, A. S., et al. (2020). Chapter 3E - Ammonoidea. In, Gradstein, F. M. , Ogg, J. G. , Schmitz, M. D. , and Ogg, G. M. (ed.) The Geologic Time Scale 2020. Elsevier, Boston, MA 1: 61-68. 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=89 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 100 intervals in the Eon column of the chronostratigraphy dataset (id=1)
They range in age from 0.0001 Ma (Holocene) to 538.8000 Ma (Fortunian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
4003HoloceneHolocene0.00010.0118Holocene
4004Lt. Pleist. ("Tarantian")Lt. Pleist. ("Tarantian")0.01180.1300Lt. Pleist. ("Tarantian")
4005ChibanianChibanian0.13000.7730Chibanian
4006CalabrianCalabrian0.77301.8000Calabrian
4007GelasianGelasian1.80002.5800Gelasian
4008PiacenzianPiacenzian2.58003.6000Piacenzian
4009ZancleanZanclean3.60005.3350Zanclean
4010MessinianMessinian5.33507.2460Messinian
4011TortonianTortonian7.246011.6250Tortonian
4012SerravallianSerravallian11.625013.8200Serravallian
4013LanghianLanghian13.820015.9940Langhian
4014BurdigalianBurdigalian15.994020.4480Burdigalian
4015AquitanianAquitanian20.448023.0400Aquitanian
4016ChattianChattian23.040027.2861Chattian
4017RupelianRupelian27.286133.9049Rupelian
4018PriabonianPriabonian33.904937.7100Priabonian
4019BartonianBartonian37.710041.0300Bartonian
4020LutetianLutetian41.030048.0680Lutetian
4021YpresianYpresian48.068056.0010Ypresian
4022ThanetianThanetian56.001059.2370Thanetian
4023SelandianSelandian59.237061.6630Selandian
2583DanianDanian61.663066.0400Danian
2584MaastrichtianMaastrichtian66.040072.1700Maastrichtian
2585CampanianCampanian72.170083.6500Campanian
2586SantonianSantonian83.650085.7000Santonian
2587ConiacianConiacian85.700089.3900Coniacian
2588TuronianTuronian89.390093.9000Turonian
2589CenomanianCenomanian93.9000100.5000Cenomanian
2590AlbianAlbian100.5000113.2000Albian
2591AptianAptian113.2000121.4000Aptian
2592BarremianBarremian121.4000126.5006Barremian
2593HauterivianHauterivian126.5006132.6000Hauterivian
2594ValanginianValanginian132.6000137.7000Valanginian
2BerriasianBerriasian137.7000143.1000Berriasian
3TithonianTithonian143.1000149.2374Tithonian
5KimmeridgianKimmeridgian149.2374154.7780Kimmeridgian
8OxfordianOxfordian154.7780161.5301Oxfordian
13CallovianCallovian161.5301165.2900Callovian
17BathonianBathonian165.2900168.1690Bathonian
21BajocianBajocian168.1690170.9000Bajocian
24AalenianAalenian170.9000174.7000Aalenian
29ToarcianToarcian174.7000184.2001Toarcian
33PliensbachianPliensbachian184.2001192.9001Pliensbachian
36SinemurianSinemurian192.9001199.4600Sinemurian
39HettangianHettangian199.4600201.3600Hettangian
1890RhaetianRhaetian201.3600205.7402Rhaetian
6378NorianNorian205.7402227.3000Norian
6379CarnianCarnian227.3000237.0000Carnian
6380LadinianLadinian237.0000241.4600Ladinian
6381AnisianAnisian241.4600246.7000Anisian
6382OlenekianOlenekian246.7000249.8750Olenekian
6383InduanInduan249.8750251.9000Induan
8921ChanghsingianChanghsingian251.9000254.2426Changhsingian
8920WuchiapingianWuchiapingian254.2426259.5470Wuchiapingian
8919CapitanianCapitanian259.5470264.3410Capitanian
8918WordianWordian264.3410269.2100Wordian
8917RoadianRoadian269.2100274.3700Roadian
8916KungurianKungurian274.3700283.3000Kungurian
8915ArtinskianArtinskian283.3000290.5100Artinskian
8914SakmarianSakmarian290.5100293.5200Sakmarian
8913AsselianAsselian293.5200298.8900Asselian
8912GzhelianGzhelian298.8900303.6778Gzhelian
8911KasimovianKasimovian303.6778307.0200Kasimovian
8910MoscovianMoscovian307.0200315.1500Moscovian
8909BashkirianBashkirian315.1500323.4000Bashkirian
8907SerpukhovianSerpukhovian323.4000330.3400Serpukhovian
8906ViseanVisean330.3400346.7300Visean
8905TournaisianTournaisian346.7300359.3000Tournaisian
12800FamennianFamennian359.3000371.1000Famennian
12799FrasnianFrasnian371.1000378.9000Frasnian
12798GivetianGivetian378.9000385.3000Givetian
12797EifelianEifelian385.3000394.3000Eifelian
12796EmsianEmsian394.3000410.5130Emsian
12795PragianPragian410.5130412.4000Pragian
12794LochkovianLochkovian412.4000419.0011Lochkovian
15963[Pridoli][Pridoli]419.0011422.7337[Pridoli]
14360LudfordianLudfordian422.7337425.0101Ludfordian
14359GorstianGorstian425.0101426.7378Gorstian
14358HomerianHomerian426.7378430.6217Homerian
14357SheinwoodianSheinwoodian430.6217432.9326Sheinwoodian
14356TelychianTelychian432.9326438.5908Telychian
14355AeronianAeronian438.5908440.4900Aeronian
14354RhuddanianRhuddanian440.4900443.0718Rhuddanian
14353HirnantianHirnantian443.0718445.2100Hirnantian
14352KatianKatian445.2100452.7500Katian
14351SandbianSandbian452.7500458.1772Sandbian
14350DarriwilianDarriwilian458.1772469.4200Darriwilian
14349DapingianDapingian469.4200471.2633Dapingian
14348FloianFloian471.2633477.0791Floian
14347TremadocianTremadocian477.0791486.8500Tremadocian
15099Stage 10Stage 10486.8500491.0000Stage 10
15098JiangshanianJiangshanian491.0000494.2000Jiangshanian
15097PaibianPaibian494.2000497.0000Paibian
15096GuzhangianGuzhangian497.0000500.5000Guzhangian
15095DrumianDrumian500.5000504.5000Drumian
15094WuliuanWuliuan504.5000509.0000Wuliuan
15093Stage 4Stage 4509.0000514.5000Stage 4
15092Stage 3Stage 3514.5000521.0000Stage 3
15091Stage 2Stage 2521.0000529.0000Stage 2
15090FortunianFortunian529.0000538.8000Fortunian

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 Age/Stage column from the chronostratigraphy dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma