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

Column content


There are 90 intervals in the Eon column of the chronostratigraphy dataset (id=1)
They range in age from 66.0400 Ma (Maastrichtian) to 419.0011 Ma (Lochkovian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
2599Late MaastrichtianLt66.040069.9100Maastrichtian
2600Early MaastrichtianE69.910072.1700Maastrichtian
2601Late CampanianLt72.170076.3800Campanian
2602Middle CampanianM76.380080.6400Campanian
2603Early CampanianE80.640083.6500Campanian
2604Late SantonianLt83.650084.5400Santonian
2605Middle SantonianM84.540085.3000Santonian
2606Early SantonianE85.300085.7000Santonian
2607Late ConiacianLt85.700087.5000Coniacian
2608Middle ConiacianM87.500088.0900Coniacian
2609Early ConiacianE88.090089.3900Coniacian
2610Late TuronianLt89.390090.2700Turonian
2611Middle TuronianM90.270092.9000Turonian
2612Early TuronianE92.900093.9000Turonian
2613Late CenomanianLt93.900095.4700Cenomanian
2614Middle CenomanianM95.470096.2400Cenomanian
2615Early CenomanianE96.2400100.5000Cenomanian
2616Late AlbianLt100.5000107.5875Albian
2617Middle AlbianM107.5875110.2200Albian
2618Early AlbianE110.2200113.2000Albian
2619Late AptianLt113.2000118.7623Aptian
2620Early AptianE118.7623121.4000Aptian
2621Late BarremianLt121.4000124.4006Barremian
2622Early BarremianE124.4006126.5006Barremian
2623Late HauterivianLt126.5006129.9391Hauterivian
2624Early HauterivianE129.9391132.6000Hauterivian
2625Late ValanginianLt132.6000135.3985Valanginian
2626Early ValanginianE135.3985137.7000Valanginian
2627Late BerriasianLt137.7000139.9200Berriasian
2628Middle BerriasianM139.9200141.3760Berriasian
2629Early BerriasianE141.3760143.1000Berriasian
4Late TithonianLt143.1000145.0465Tithonian
6Early TithonianE145.0465149.2374Tithonian
7Late KimmeridgianLt149.2374152.0351Kimmeridgian
9Early KimmeridgianE152.0351154.7780Kimmeridgian
10Late OxfordianLt154.7780157.9476Oxfordian
11Middle OxfordianM157.9476159.0876Oxfordian
14Early OxfordianE159.0876161.5301Oxfordian
15Late CallovianLt161.5301162.6309Callovian
16Middle CallovianM162.6309163.4719Callovian
18Early CallovianE163.4719165.2900Callovian
19Late BathonianLt165.2900165.8274Bathonian
20Middle BathonianM165.8274166.9661Bathonian
22Early BathonianE166.9661168.1690Bathonian
23Late BajocianLt168.1690169.7385Bajocian
26Early BajocianE169.7385170.9000Bajocian
27Late AalenianLt170.9000171.5000Aalenian
28Middle AalenianM171.5000172.7000Aalenian
30Early AalenianE172.7000174.7000Aalenian
31Late ToarcianLt174.7000179.8244Toarcian
34Early ToarcianE179.8244184.2001Toarcian
35Late PliensbachianLt184.2001188.0001Pliensbachian
37Early PliensbachianE188.0001192.9001Pliensbachian
38Late SinemurianLt192.9001196.3729Sinemurian
40Early SinemurianE196.3729199.4600Sinemurian
8045Hettangian subSt-199.4600201.3600Hettangian
8044Rhaetian subSt-201.3600205.7402Rhaetian
6386SevatianSevatian205.7402214.0320Norian
6387AlaunianAlaunian214.0320217.4915Norian
6388LacianLacian217.4915227.3000Norian
6389TuvalianTuvalian227.3000233.6000Carnian
8457JulianJulian233.6000237.0000Carnian
6391LongobardianLongobardian237.0000239.4800Ladinian
6390FassanianFassanian239.4800241.4600Ladinian
6392IllyrianIllyrian241.4600243.3285Anisian
6393PelsonianPelsonian243.3285244.2388Anisian
6394BithynianBithynian244.2388244.9834Anisian
6395AegeanAegean244.9834246.7000Anisian
6396SpathianSpathian246.7000248.0958Olenekian
6397SmithianSmithian248.0958249.8750Olenekian
6398DienerianDienerian249.8750250.4955Induan
6399GriesbachianGriesbachian250.4955251.9000Induan
12820Latest FamennianLatest359.3000361.7780Famennian
12819Late FamennianLt361.7780365.0551Famennian
12818Middle FamennianM365.0551367.9140Famennian
12817Early FamennianE367.9140371.1000Famennian
12816Late FrasnianLt371.1000373.4400Frasnian
12815Middle FrasnianM373.4400376.3455Frasnian
12814Early FrasnianE376.3455378.9000Frasnian
12813Late GivetianLt378.9000380.3080Givetian
12812Middle GivetianM380.3080383.0600Givetian
12811Early GivetianE383.0600385.3000Givetian
12810Late EifelianLt385.3000389.6200Eifelian
12809Early EifelianE389.6200394.3000Eifelian
12808Late EmsianLt394.3000400.0840Emsian
12807Early Emsiansee note400.0840410.5130Emsian
12806Early PragianE410.5130412.4000Pragian
12805Late LochkovianLt412.4000413.9420Lochkovian
12804Middle LochkovianM413.9420416.2962Lochkovian
12803Early LochkovianE416.2962419.0011Lochkovian

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