arkL populate - integrate and check data

This page is used to recalculate the ages of events and intervals and to compare the calculated ages with the ages given in the last version of TimeScaleCreator. After a set of data has been uploaded, or edited, this page is used to check it for problems. Links from this page allow editing of indivdual events and intervals to resolve problems. To upload new data use: arkL_upload_data.php

Anyone can use this page, but its main value is to allow editors to identify problems

HOUSEKEEPING:
Fill in missing event & interval ids, update event and interval terms based on their id and update min and max ages of datasets
Missing links - list events and intervals with essential data missing
INTEGRATE DATA:
Reset age data and Run queries
DISPLAY RESULTS:
all events & intervalsUndefined events & intervalsevents & intervals with preset ages or durations

Filters

Top stage/age: Dataset:sub-dataset:
Base stage/age: Sort by:

Events


select a.*,g.sort from arkL_events as a left join arkL_datasets as g on a.dataset=g.dataset where a.id is not null and event_display not like 'omit' and a.age2020 >201.3600 and a.age2020 <251.9000 and a.dataset='chronostratigraphy' order by g.sort,a.age2020,id
idEventstagepresetpupwithin intervaloffsetoffset_fromdatasetageage2020δ
8870base RhaetianNorian0.00000.0000FAD Misikella posthernsteini (sensu stricto)chronostratigraphy205.740200205.7402Y
8871base SevatianNorian0.0000Sagenites quinquepunctatus TAZchronostratigraphy214.032000214.0320Y
8873base AlaunianNorian0.0000Cyrtopleurites bicrenatus TAZchronostratigraphy217.491500217.4915Y
8874base NorianNorian0.0000Guembelites jandianus TAZchronostratigraphy227.300000227.3000Y
8875base TuvalianCarnian0.0000-3.4000base Carnianchronostratigraphy233.600000233.6000Y
8876base CarnianCarnian237.00000.0000chronostratigraphy237.000000237.0000Y
8877base LongobardianLadinian239.48000.0000chronostratigraphy239.480000239.4800Y
8878base LadinianLadinian241.46000.0000chronostratigraphy241.460000241.4600Y
8879base IllyrianAnisian0.1000MT5rchronostratigraphy243.328500243.3304Y
8880base PelsonianAnisian0.2000MT4n.2nchronostratigraphy244.238800244.2407Y
8881base BithynianAnisian0.0000MT3r.3rchronostratigraphy244.983400244.9854Y
8882base AnisianAnisian0.0000Chiosella timorensis TKCdontZchronostratigraphy246.700000246.7000Y
8883base SpathianOlenekian0.0000Novispathodus pingdingshanensis TKCdontZchronostratigraphy248.095800248.0978Y
8884base OlenekianOlenekian0.0000e5.2 ChLchronostratigraphy249.875000249.8770Y
8885base DienerianInduan0.2500CG5nchronostratigraphy250.495500250.4975Y

Intervals

select a.*, g.sort from arkL_intervals as a left join arkL_datasets as g on a.dataset=g.dataset where a.id is not null and a.base_age2020 >201.3600 and a.top_age2020 <251.9000 and a.dataset='chronostratigraphy' order by a.base_age2020
idDatasetsubdatasetIntervaltypestageParent Intervaltop_eventtop_age2020base_eventbase_age2020duration
8044chronostratigraphyRhaetian substagesubstageRhaetianTriassicbase Hettangian201.3600201.3600base Rhaetian205.7402205.74004.3802
1890chronostratigraphyRhaetianstageRhaetianTriassicbase Hettangian201.3600201.3600base Rhaetian205.7402205.74004.3802
8043chronostratigraphylong RhaetianRhaetianTriassicbase Hettangian201.3600201.3600base Sagenites reticulatus / Paracochloceras suessi TAZ209.5130209.51008.1530
8589chronostratigraphyshort SevatianNorianTriassicbase Sagenites reticulatus / Paracochloceras suessi TAZ209.5130209.5130base Sevatian214.0320214.03204.5190
6386chronostratigraphySevatiansubstageNorianbase Rhaetian205.7402205.7402base Sevatian214.0320214.03208.2918
6387chronostratigraphyAlauniansubstageNorianbase Sevatian214.0320214.0320base Alaunian217.4915217.49153.4595
6378chronostratigraphyNorianstageNorianbase Rhaetian205.7402205.7402base Norian227.3000227.300021.5598
6388chronostratigraphyLaciansubstageNorianbase Alaunian217.4915217.4915base Norian227.3000227.30009.8085
6389chronostratigraphyTuvaliansubstageCarnianbase Norian227.3000227.3000base Tuvalian233.6000233.60006.3000
6375chronostratigraphyLate TriassicepochNorianbase Hettangian201.3600201.3600base Carnian237.0000237.000035.6400
6379chronostratigraphyCarnianstageCarnianbase Norian227.3000227.3000base Carnian237.0000237.00009.7000
8457chronostratigraphyJuliansubstageCarnianbase Tuvalian233.6000233.6000base Carnian237.0000237.00003.4000
6391chronostratigraphyLongobardiansubstageLadinianbase Carnian237.0000237.0000base Longobardian239.4800239.48002.4800
6380chronostratigraphyLadinianstageLadinianbase Carnian237.0000237.0000base Ladinian241.4600241.46004.4600
6390chronostratigraphyFassaniansubstageLadinianbase Longobardian239.4800239.4800base Ladinian241.4600241.46001.9800
6392chronostratigraphyIllyriansubstageAnisianbase Ladinian241.4600241.4600base Illyrian243.3285243.33041.8685
6393chronostratigraphyPelsoniansubstageAnisianbase Illyrian243.3285243.3304base Pelsonian244.2388244.24070.9103
6394chronostratigraphyBithyniansubstageAnisianbase Pelsonian244.2388244.2407base Bithynian244.9834244.98540.7446
6376chronostratigraphyMiddle TriassicepochAnisianbase Carnian237.0000237.0000base Anisian246.7000246.70009.7000
6395chronostratigraphyAegeansubstageAnisianbase Bithynian244.9834244.9854base Anisian246.7000246.70001.7166
6381chronostratigraphyAnisianstageAnisianbase Ladinian241.4600241.4600base Anisian246.7000246.70005.2400
6396chronostratigraphySpathiansubstageOlenekianbase Anisian246.7000246.7000base Spathian248.0958248.09781.3958
6397chronostratigraphySmithiansubstageOlenekianbase Spathian248.0958248.0978base Olenekian249.8750249.87701.7792
6382chronostratigraphyOlenekianstageOlenekianbase Anisian246.7000246.7000base Olenekian249.8750249.87703.1750
6398chronostratigraphyDieneriansubstageInduanbase Olenekian249.8750249.8770base Dienerian250.4955250.49750.6205
6374chronostratigraphyTriassicPeriodNorianMesozoicbase Hettangian201.3600201.3600base Induan251.9000251.900050.5400
6399chronostratigraphyGriesbachiansubstageInduanbase Dienerian250.4955250.4975base Induan251.9000251.90201.4045
6377chronostratigraphyEarly TriassicepochOlenekianbase Anisian246.7000246.7000base Induan251.9000251.90205.2000
6383chronostratigraphyInduanstageInduanbase Olenekian249.8750249.8770base Induan251.9000251.90202.0250