View content of a column in the arkL Database

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 & columnfilter by time interval (optional)
Dataset:Top stage/age:
Column: Base stage/age:

Mode: View is selected - change to edit mode if you want to edit the metadata
age window: 0-->700

Column metadata

Name: column id:89
dataset: chronostratigraphy (dataset id: 1)
column_type:
interval_type:
sub_columnE:
Column width:
Column for labels:
Compilation notes:
Subdataset:
Colshare
Subdatasets:		 colshare:
Path:
Data selection query:
select i.*,e.event_display from arkL_intervals as i left join arkL_events as e on i.base_id=e.id left join arkL_lithology as l on i.lithology_id=l.id where i.dataset_id=1 AND interval_type like 'stage' and subdataset='' and base_age> 0 and top_age < 700 order by base_age, top_age

Column content


There are 52 intervals in the Age/Stage column of the chronostratigraphy dataset (id=1)
They range in age from 0.0002 Ma (Holocene) to 251.9000 Ma (Induan)
COLTYPEintervals - coloured

idintervalxhas_added_abvTSC labeltop_agebase_agestagecolour
4003HoloceneHolocene0.00020.0118Holocene254/242/224
4004Lt. Pleist. ("Tarantian")Lt. Pleist. ("Tarantian")0.01180.1300Lt. Pleist. ("Tarantian")255/242/211
4005ChibanianChibanian0.13000.7730Chibanian255/242/199
4006CalabrianCalabrian0.77301.8000Calabrian255/242/186
4007GelasianGelasian1.80002.5800Gelasian255/237/179
4008PiacenzianPiacenzian2.58003.6000Piacenzian255/255/191
4009ZancleanZanclean3.60005.3350Zanclean255/255/179
4010MessinianMessinian5.33507.2460Messinian255/255/115
4011TortonianTortonian7.246011.6250Tortonian255/255/102
4012SerravallianSerravallian11.625013.8200Serravallian255/255/89
4013LanghianLanghian13.820015.9940Langhian255/255/77
4014BurdigalianBurdigalian15.994020.4480Burdigalian255/255/65
4015AquitanianAquitanian20.448023.0400Aquitanian255/255/51
4016ChattianChattian23.040027.2862Chattian254/230/170
4017RupelianRupelian27.286233.9049Rupelian254/217/154
4018PriabonianPriabonian33.904937.7100Priabonian253/205/161
4019BartonianBartonian37.710041.0300Bartonian253/192/145
4020LutetianLutetian41.030048.0680Lutetian252/180/130
4021YpresianYpresian48.068056.0010Ypresian252/167/115
4022ThanetianThanetian56.001059.2370Thanetian253/191/111
4023SelandianSelandian59.237061.6630Selandian254/191/101
2583DanianDanian61.663066.0400Danian253/180/98
2584MaastrichtianMaastrichtian66.040072.1700Maastrichtian242/250/140
2585CampanianCampanian72.170083.6500Campanian230/244/127
2586SantonianSantonian83.650085.7000Santonian217/239/116
2587ConiacianConiacian85.700089.3900Coniacian204/233/104
2588TuronianTuronian89.390093.9000Turonian191/227/93
2589CenomanianCenomanian93.9000100.5000Cenomanian179/222/83
2590AlbianAlbian100.5000113.2000Albian204/234/151
2591AptianAptian113.2000121.4000Aptian191/228/138
2592BarremianBarremian121.4000126.5007Barremian179/223/127
2593HauterivianHauterivian126.5007132.6000Hauterivian166/217/117
2594ValanginianValanginian132.6000137.7000Valanginian153/211/106
2BerriasianBerriasian137.7000143.1000Berriasian140/205/96
3TithonianTithonian143.1000149.2374Tithonian217/241/247
5KimmeridgianKimmeridgian149.2374154.7780Kimmeridgian204/236/244
8OxfordianOxfordian154.7780161.5301Oxfordian191/231/241
13CallovianCallovian161.5301165.2900Callovian191/231/229
17BathonianBathonian165.2900168.1690Bathonian179/226/227
21BajocianBajocian168.1690170.9000Bajocian166/221/224
24AalenianAalenian170.9000174.7000Aalenian154/217/221
29ToarcianToarcian174.7000184.2001Toarcian153/206/227
33PliensbachianPliensbachian184.2001192.9001Pliensbachian128/197/221
36SinemurianSinemurian192.9001199.4600Sinemurian103/188/216
39HettangianHettangian199.4600201.3600Hettangian78/179/211
1890RhaetianRhaetian201.3600205.7402Rhaetian227/185/219
6378NorianNorian205.7402227.3000Norian214/170/211
6379CarnianCarnian227.3000237.0000Carnian201/155/203
6380LadinianLadinian237.0000241.4600Ladinian201/131/191
6381AnisianAnisian241.4600246.7000Anisian188/117/183
6382OlenekianOlenekian246.7000249.8750Olenekian176/81/165
6383InduanInduan249.8750251.9000Induan164/70/159

Subdataset References ↑

Dataset References ↑

Gale, A. S. (2016). Roveacrinida (Crinoidea, Articulata) from the Santonian-Maastrichtian (Upper Cretaceous) of England, the US Gulf Coast (Texas, Mississippi) and southern Sweden. Papers in Palaeontology. 2(20130127): -. 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

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

The data plotted here is the Age/Stage column from the chronostratigraphy dataset for the interval 0.0002 - 251.9000 Ma