TABLE  vhsTilePawPrints

Contains tile<->paw-print paired detections from vhsDetection.

Each tile multiframe is linked to 6 pawprints, each with a
different offsetID (1,2,3,4,5,6). The detections are paired within
0.8".
Prescription for the merging is: tile, O1, O2, O3, O4, O5, O6

Required constraints:
  • Primary key is (tileSetID,tileSetSeqNum)
  • (tileSetID) references vhsTileSet(tileSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
detectIDbigint8 UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm meta.id;meta.main
cuEventIDint4 UID of curation event giving rise to this record meta.id
tileSetIDbigint8 UID of the set of frames that this merged source comes from meta.id
ra link to glossaryfloat8DegreesCelestial Right Ascension pos.eq.ra;meta.main
dec link to glossaryfloat8DegreesCelestial Declination pos.eq.dec;meta.main
cxfloat8 unit vector of spherical co-ordinates pos.cartesian.x;pos.eq
cyfloat8 unit vector of spherical co-ordinates pos.cartesian.y;pos.eq
czfloat8 unit vector of spherical co-ordinates pos.cartesian.z;pos.eq
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.HTM
lfloat8DegreesGalactic longitude pos.galactic.lon
bfloat8DegreesGalactic latitude pos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1 pos
etafloat8DegreesSDSS system spherical co-ordinate 2 pos
tlExtNumtinyint1 the extension number of the tile detection (should always be 2)2meta.id
tlSeqNumint4 the running number of the tile detection-99999999meta.id
tlXi link to glossaryreal4arcsecOffset of &As& detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
tlEta link to glossaryreal4arcsecOffset 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
o1Xi link to glossaryreal4arcsecOffset of O1 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o1Eta link to glossaryreal4arcsecOffset 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
o2Xi link to glossaryreal4arcsecOffset of O2 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o2Eta link to glossaryreal4arcsecOffset 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
o3Xi link to glossaryreal4arcsecOffset of O3 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o3Eta link to glossaryreal4arcsecOffset 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
o4Xi link to glossaryreal4arcsecOffset of O4 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o4Eta link to glossaryreal4arcsecOffset 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
o5Xi link to glossaryreal4arcsecOffset of O5 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o5Eta link to glossaryreal4arcsecOffset 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
o6Xi link to glossaryreal4arcsecOffset of O6 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
o6Eta link to glossaryreal4arcsecOffset of O6 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
tileSetSeqNum tooltipint4 Running number of the match in this tile set-99999999meta.id
Total length195