View/edit a column - Graptolite Zones (general)

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:307
dataset: graptolites (dataset id: 104)
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=104) order by abv_ref, disambig
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=307 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 74 intervals in the Graptolite Zones (general) column of the graptolites dataset (id=104)
They range in age from 407.3000 Ma (Emsian) to 486.4532 Ma (Tremadocian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
12876Uncinatograptus pacificus GrapZyesUncinatograptus pacificus407.3000410.5130Emsian
12875Uncinatograptus yukonensis GrapZyesUncinatograptus yukonensis410.5130411.2780Pragian
12874Uncinatograptus craigensis GrapZyesUncinatograptus craigensis411.2780411.8390Pragian
12873Neomonograptus fanicus GrapZyesNeomonograptus fanicus411.8390412.4000Pragian
12872Neomonograptus falcarius GrapZyesNeomonograptus falcarius412.4000413.2997Lochkovian
12871Uncinatograptus hercynicus GrapZyesUncinatograptus hercynicus413.2997414.5685Lochkovian
12870Uncinatograptus praehercynicus GrapZyesUncinatograptus praehercynicus414.5685416.2962Lochkovian
14272Uncinatograptus praehercynicus GrZyesUncinatograptus praehercynicus415.9100417.1200Lochkovian
12869Uncinatograptus uniformis GrapZyesUncinatograptus uniformis416.2962419.0011Lochkovian
14271Uncinatograptus uniformis GrZyesUncinatograptus uniformis417.1200419.0011Lochkovian
14270Istrograptus transgrediens / M. perneri GrZyesIstrograptus transgrediens / M. perneri419.0011420.9458[Pridoli]
14269Monograptus bouceki GrZyesMonograptus bouceki420.9458421.4804[Pridoli]
14268Neocolonogr. lochkovensis / N. branikensis GrZyesNeocolonogr. lochkovensis / N. branikensis421.4804422.2515[Pridoli]
14267Neocolo. ultimus / N. parultimus GrZyesNeocolo. ultimus / N. parultimus422.2515422.7337[Pridoli]
14266Formosograptus formosus GrZyesFormosograptus formosus422.7337423.1391Ludfordian
14265Neocucullogr. kozlowskii / Polonogr. podoliensis Zone GrZyesNeocucullogr. kozlowskii / Polonogr. podoliensis Zone423.1391423.6375Ludfordian
14264Bohemograptus GrZyesBohemograptus423.6375424.2500Ludfordian
14263Saetograptus leintwardinensis GrZyesSaetograptus leintwardinensis424.2500425.0101Ludfordian
14262Lobograptus scanicus GrZyesLobograptus scanicus425.0101426.5374Gorstian
14261Neodiversograptus nilssoni GrZyesNeodiversograptus nilssoni426.5374426.7378Gorstian
14260Colonograptus ludensis GrZyesColonograptus ludensis426.7378427.8605Homerian
14259Colonograptus? deubeli / C? praedeubeli GrZyesColonograptus? deubeli / C? praedeubeli427.8605428.3369Homerian
14258Gothograptus nassa / Pristiograptus parvus GrZyesGothograptus nassa / Pristiograptus parvus428.3369429.0426Homerian
14257Cyrtograptus lundgreni GrZyesCyrtograptus lundgreni429.0426430.6217Homerian
14256Cyrtogr. rigidus / Monogr. antennularius / M. belophorus GrZyesCyrtogr. rigidus / Monogr. antennularius / M. belophorus430.6217431.9110Sheinwoodian
14255Monograptus riccartonensis / M. firmus GrZyesMonograptus riccartonensis / M. firmus431.9110432.1011Sheinwoodian
14254Cyrtograptus murchisoni GrZyesCyrtograptus murchisoni432.1011433.0581Sheinwoodian
14253Cyrtograptus centrifugus GrZyesCyrtograptus centrifugus433.0581433.5648Telychian
14252Cyrtograptus insectus GrZyesCyrtograptus insectus433.5648433.7009Telychian
14251Cyrtograptus lapworthi GrZyesCyrtograptus lapworthi433.7009434.8875Telychian
14250Oktavites spiralis GrZyesOktavites spiralis434.8875435.6289Telychian
14249Monoclimacis crenulata GrZyesMonoclimacis crenulata435.6289436.3620Telychian
14248Monoclimacis griestoniensis GrZyesMonoclimacis griestoniensis436.3620436.4434Telychian
14247Streptograptus crispus GrZyesStreptograptus crispus436.4434437.0442Telychian
14246Spirograptus turriculatus GrZyesSpirograptus turriculatus437.0442438.1868Telychian
14245Spirograptus guerichi GrZyesSpirograptus guerichi438.1868438.5908Telychian
14244Stimulograptus halli / S. sedgwicki GrZyesStimulograptus halli / S. sedgwicki438.5908438.8521Aeronian
14243Lituigraptus convolutus GrZyesLituigraptus convolutus438.8521439.4311Aeronian
14242Pribylogr. leptotheca / Pernerogr. argenteus GrZyesPribylogr. leptotheca / Pernerogr. argenteus439.4311439.5995Aeronian
14241Demirastrites pectinatus / Demi. triangulatus GrZyesDemirastrites pectinatus / Demi. triangulatus439.5995440.4900Aeronian
14240Coronograptus cyphus GrZyesCoronograptus cyphus440.4900440.8167Rhuddanian
14239Cystograptus vesiculosus GrZyesCystograptus vesiculosus440.8167441.5363Rhuddanian
14238Parakidograptus acuminatus GrZyesParakidograptus acuminatus441.5363442.3919Rhuddanian
14237Akidograptus ascensus GrZyesAkidograptus ascensus442.3919443.0718Rhuddanian
14236Metabolograptus persculptus GrZyesMetabolograptus persculptus443.0718443.9524Hirnantian
14235Metabolograptus extraordinarius GrZyesMetabolograptus extraordinarius443.9524445.2100Hirnantian
14234Paraorthograptus pacificus GrZyesParaorthograptus pacificus445.2100448.5895Katian
14233Dicellograptus complexus GrZyesDicellograptus complexus448.5895449.1297Katian
14232Dicellograptus complanatus GrZyesDicellograptus complanatus449.1297449.4033Katian
14231Dicellograptus gravis GrZyesDicellograptus gravis449.4033450.0088Katian
14230Styracograptus tubuliferus GrZyesStyracograptus tubuliferus450.0088450.3856Katian
14229Diplacanthogr. spiniferus GrZyesDiplacanthogr. spiniferus450.3856451.3314Katian
14228Diplacanthograptus caudatus GrZyesDiplacanthograptus caudatus451.3314452.7500Katian
14227Climacograptus bicornis GrZyesClimacograptus bicornis452.7500456.8008Sandbian
14226Nemagraptus gracilis GrZyesNemagraptus gracilis456.8008458.1772Sandbian
14225Pseudamplexograptus distichus GrZyesPseudamplexograptus distichus458.1772461.4302Darriwilian
14224Archiclimacograptus decoratus GrZyesArchiclimacograptus decoratus461.4302466.3319Darriwilian
14223Levisograptus dentatus GrZyesLevisograptus dentatus466.3319469.2290Darriwilian
14222Levisograptus austrodentatus GrZyesLevisograptus austrodentatus469.2290469.4200Darriwilian
14221Oncograptus upsilon GrZyesOncograptus upsilon469.4200470.3946Dapingian
14220Iso. victoriae maximodivergens GrZyesIso. victoriae maximodivergens470.3946470.5149Carnian
14219Isograptus victoriae maximus GrZyesIsograptus victoriae maximus470.3946470.6352Dapingian
14218Isograptus victoriae victoriae GrZyesIsograptus victoriae victoriae470.6352471.1508Dapingian
14217Isograptus victoriae lunatus GrZyesIsograptus victoriae lunatus471.1508471.2633Dapingian
14216Didymograptellus bifidus GrZyesDidymograptellus bifidus471.2633473.1382Floian
14215Tshallograptus fruticosus 1-4 GrZyesTshallograptus fruticosus 1-4473.1382474.9009Floian
14214Tetragraptus approximatus GrZyesTetragraptus approximatus474.9009477.0791Floian
14213Araneograptus murrayi GrZyesAraneograptus murrayi477.0791481.1242Tremadocian
14212Aorograptus victoriae GrZyesAorograptus victoriae481.1242481.7838Tremadocian
14211Adelograptus tenellus gp. GrZyesAdelograptus tenellus gp.481.7838482.6884Tremadocian
14210Rhabdinopora anglica GrZyesRhabdinopora anglica482.6884484.0748Tremadocian
14209Anisograptus matanensis GrZyesAnisograptus matanensis484.0748484.3413Tremadocian
14208Rhabdinopora flabelliformis parabola GrZyesRhabdinopora flabelliformis parabola484.3413485.2234Tremadocian
14207Rhabdinopora praeparabola GrZyesRhabdinopora praeparabola485.2234486.4532Tremadocian

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 Graptolite Zones (general) column from the graptolites dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma