TABLE VIEW  videoTilePawTDOnly

videoTilePawPrints table with only good tile detections only and defaults

This view removes matches where there are pawprint detections but
not a tile detection
The details and SQL SELECT corresponding to this view are available here.

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
detectIDbigint8 UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithmmeta.id;meta.main
cuEventIDint4 UID of curation event giving rise to this recordmeta.bib
tileSetIDbigint8 UID of the set of frames that this merged source comes frommeta.bib
rafloat8DegreesCelestial Right Ascensionpos.eq.ra;meta.main
decfloat8DegreesCelestial Declinationpos.eq.dec;meta.main
cxfloat8 unit vector of spherical co-ordinatespos.distance;pos.cartesian.x
cyfloat8 unit vector of spherical co-ordinatespos.distance;pos.cartesian.y
czfloat8 unit vector of spherical co-ordinatespos.distance;pos.cartesian.z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinatespos.eq
lfloat8DegreesGalactic longitudepos.galactic.lon
bfloat8DegreesGalactic latitudepos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1pos
etafloat8DegreesSDSS system spherical co-ordinate 2pos
tlExtNumtinyint1 the extension number of the tile detection (should always be 2)2meta.id
tlSeqNumint4 the running number of the tile detection-99999999meta.id
tlXireal4arcsecOffset of &As& detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
tlEtareal4arcsecOffset of &As& detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o1ExtNumtinyint1 the extension number of the O1 detection2meta.id
o1SeqNumint4 the running number of the O1 detection-99999999meta.id
o1Xireal4arcsecOffset of O1 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o1Etareal4arcsecOffset of O1 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o2ExtNumtinyint1 the extension number of the O2 detection2meta.id
o2SeqNumint4 the running number of the O2 detection-99999999meta.id
o2Xireal4arcsecOffset of O2 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o2Etareal4arcsecOffset of O2 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o3ExtNumtinyint1 the extension number of the O3 detection2meta.id
o3SeqNumint4 the running number of the O3 detection-99999999meta.id
o3Xireal4arcsecOffset of O3 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o3Etareal4arcsecOffset of O3 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o4ExtNumtinyint1 the extension number of the O4 detection2meta.id
o4SeqNumint4 the running number of the O4 detection-99999999meta.id
o4Xireal4arcsecOffset of O4 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o4Etareal4arcsecOffset of O4 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o5ExtNumtinyint1 the extension number of the O5 detection2meta.id
o5SeqNumint4 the running number of the O5 detection-99999999meta.id
o5Xireal4arcsecOffset of O5 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o5Etareal4arcsecOffset of O5 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
o6ExtNumtinyint1 the extension number of the O6 detection2meta.id
o6SeqNumint4 the running number of the O6 detection-99999999meta.id
o6Xireal4arcsecOffset of O6 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o6Etareal4arcsecOffset of O6 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
tileSetSeqNumint4 Running number of the match in this tile set-99999999meta.bib
Total length195