View/edit a column - NZ Epoch

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:316
dataset: stages New Zealand (dataset id: 25)
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=25) order by abv_ref, disambig

Cooper, R. A. (ed. ) (2004). The New Zealand geological time scale. Institute of Geological & Nuclear Sciences, Monograph. 22: 1-284. gs

Raffi, I., Wade, B. S. & Pälike, H. (2020). Chapter 29 - The Neogene 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: 1141-1217. gs

Raine, J. I., et al. (2015a). New Zealand geological timescale NZGT 2015/1. New Zealand Journal of Geology and Geophysics. 58: 398-403. gs

Raine, J. I., et al. (2015b). Revised calibration of the New Zealand Geological time scale: NZGT2015/1. GNS Science Report. 2012/39: 1-53. 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=316 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 18 intervals in the NZ Epoch column of the stages New Zealand dataset (id=25)
They range in age from 0.0001 Ma (Gelasian) to 289.4285 Ma (Kungurian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
6254Wanganui NZseriesyesWanganui0.00015.1500Gelasian
6255Taranaki NZseriesyesTaranaki5.150011.0400Tortonian
6256Southland NZseriesyesSouthland11.040015.9700Serravallian
6257Pareora NZseriesyesPareora15.970021.7000Burdigalian
6258Landon NZseriesyesLandon21.700034.6892Rupelian
6259Arnold NZseriesyesArnold34.689242.5722Bartonian
6260Dannevirke NZseriesyesDannevirke42.572266.0400Ypresian
12181Mata NZSeryesMata66.040086.6000Campanian
12180Raukumara NZSeryesRaukumara86.600095.8550Turonian
12179Clarence NZSeryesClarence95.8550110.2200Albian
12178Taitai NZSeryesTaitai110.2200143.1000Barremian
2441Oteke NZseriesyesOteke143.1000146.3038Tithonian
2442Kawhia NZseriesyesKawhia146.3038174.7000Oxfordian
2443Herangi NZseriesyesHerangi174.7000201.3600Sinemurian
8055Balfour NZseriesyesBalfour201.3600229.3160Norian
8054Gore NZseriesyesGore229.3160251.1978Ladinian
12111D'Urville NZSeryesD'Urville251.1978259.5470Wuchiapingian
12110Aparima NZSeryesAparima259.5470289.4285Kungurian

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 NZ Epoch column from the stages New Zealand dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma