TABLE  videoSource

Contains merged sources from detections in videoDetection.

Prescription for the merging (from RequiredFilters) is: Z, Y, J, H, Ks

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references videoMergeLog(frameSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 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.bib
frameSetID link to glossarybigint8 UID of the set of frames that this merged source comes from meta.bib
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
lfloat8DegreesGalactic longitude pos.galactic.lon
bfloat8DegreesGalactic latitude pos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1 pos
etafloat8DegreesSDSS system spherical co-ordinate 2 pos
priOrSec link to glossarybigint8 Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).-99999999meta.code
zmyPnt link to glossaryreal4magPoint source colour Z-Y (using aperMag3)-0.9999995e9phot.color;em.opt.I;em.IR.NIR
zmyPntErr link to glossaryreal4magError on point source colour Z-Y-0.9999995e9stat.error;em.opt.I;em.IR.NIR
ymjPnt link to glossaryreal4magPoint source colour Y-J (using aperMag3)-0.9999995e9phot.color;em.IR.NIR;em.IR.J
ymjPntErr link to glossaryreal4magError on point source colour Y-J-0.9999995e9stat.error;em.IR.NIR;em.IR.J
jmhPnt link to glossaryreal4magPoint source colour J-H (using aperMag3)-0.9999995e9phot.color;em.IR.J;em.IR.H
jmhPntErr link to glossaryreal4magError on point source colour J-H-0.9999995e9stat.error;em.IR.J;em.IR.H
hmksPnt link to glossaryreal4magPoint source colour H-Ks (using aperMag3)-0.9999995e9phot.color;em.IR.H;em.IR.K
hmksPntErr link to glossaryreal4magError on point source colour H-Ks-0.9999995e9stat.error;em.IR.H;em.IR.K
zmyExt link to glossaryreal4magExtended source colour Z-Y (using aperMagNoAperCorr3)-0.9999995e9phot.color;em.opt.I;em.IR.NIR
zmyExtErr link to glossaryreal4magError on extended source colour Z-Y-0.9999995e9stat.error;em.opt.I;em.IR.NIR
ymjExt link to glossaryreal4magExtended source colour Y-J (using aperMagNoAperCorr3)-0.9999995e9phot.color;em.IR.NIR;em.IR.J
ymjExtErr link to glossaryreal4magError on extended source colour Y-J-0.9999995e9stat.error;em.IR.NIR;em.IR.J
jmhExt link to glossaryreal4magExtended source colour J-H (using aperMagNoAperCorr3)-0.9999995e9phot.color;em.IR.J;em.IR.H
jmhExtErr link to glossaryreal4magError on extended source colour J-H-0.9999995e9stat.error;em.IR.J;em.IR.H
hmksExt link to glossaryreal4magExtended source colour H-Ks (using aperMagNoAperCorr3)-0.9999995e9phot.color;em.IR.H;em.IR.K
hmksExtErr link to glossaryreal4magError on extended source colour H-Ks-0.9999995e9stat.error;em.IR.H;em.IR.K
mergedClassStat link to glossaryreal4 Merged S-Extractor classification statistic-0.9999995e9stat
mergedClass link to glossarysmallint2 Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) meta.code
pStar link to glossaryreal4 Probability that the source is a star stat
pGalaxy link to glossaryreal4 Probability that the source is a galaxy stat
pNoise link to glossaryreal4 Probability that the source is noise stat
pSaturated link to glossaryreal4 Probability that the source is saturated stat
eBVreal4 The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1)-0.9999995e9phys.absorption.gal
aZreal4magThe galactic extinction correction in the Z band for extragalactic objects-0.9999995e9phys.absorption.gal
aYreal4magThe galactic extinction correction in the Y band for extragalactic objects-0.9999995e9phys.absorption.gal
aJreal4magThe galactic extinction correction in the J band for extragalactic objects-0.9999995e9phys.absorption.gal
aHreal4magThe galactic extinction correction in the H band for extragalactic objects-0.9999995e9phys.absorption.gal
aKsreal4magThe galactic extinction correction in the Ks band for extragalactic objects-0.9999995e9phys.absorption.gal
zPetroMagreal4magExtended source Z mag (Petrosian)-0.9999995e9phot.mag;em.opt.I
zPetroMagErrreal4magError in extended source Z mag (Petrosian)-0.9999995e9stat.error;em.opt.I;phot.mag
zKronMagreal4magExtended source Z mag (Kron - SExtractor MAG_AUTO)-0.9999995e9phot.mag;em.opt.I
zKronMagErrreal4magExtended source Z mag error (Kron - SExtractor MAG_AUTO)-0.9999995e9stat.error;em.opt.I;phot.mag
zAperMag3 tooltipreal4magDefault point source Z aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zAperMag3Errreal4magError in default point/extended source Z mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;em.opt.I;phot.mag
zAperMag4real4magPoint source Z aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zAperMag4Errreal4magError in point/extended source Z mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;em.opt.I;phot.mag
zAperMag6real4magPoint source Z aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zAperMag6Errreal4magError in point/extended source Z mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error;em.opt.I;phot.mag
zAperMagNoAperCorr3 tooltipreal4magDefault extended source Z aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zAperMagNoAperCorr4real4magExtended source Z aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zAperMagNoAperCorr6real4magExtended source Z aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.opt.I
zHalfRadreal4pixelsSExtractor half-light radius in Z band-0.9999995e9phys.angSize;em.opt.I
zHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Z band-0.9999995e9phys.angSize;em.opt.I
zGausigreal4pixelsRMS of axes of ellipse fit in Z-0.9999995e9src.morph.param;em.opt.I
zEllreal4 1-b/a, where a/b=semi-major/minor axes in Z-0.9999995e9src.ellipticity;em.opt.I
zPAreal4Degreesellipse fit celestial orientation in Z-0.9999995e9pos.posAng;em.opt.I
zErrBits link to glossaryint4 processing warning/error bitwise flags in Z-99999999meta.code;em.opt.I
zClasssmallint2 discrete image classification flag in Z-9999src.class;em.opt.I
zClassStatreal4 S-Extractor classification statistic in Z-0.9999995e9stat;em.opt.I
zppErrBitsint4 additional WFAU post-processing error bits in Z0meta.code;em.opt.I
zSeqNumint4 the running number of the Z detection-99999999meta.number;em.opt.I
zXi link to glossaryreal4arcsecOffset of Z detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.opt.I
zEta link to glossaryreal4arcsecOffset of Z detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.opt.I
yPetroMagreal4magExtended source Y mag (Petrosian)-0.9999995e9phot.mag;em.IR.NIR
yPetroMagErrreal4magError in extended source Y mag (Petrosian)-0.9999995e9stat.error;em.IR.NIR;phot.mag
yKronMagreal4magExtended source Y mag (Kron - SExtractor MAG_AUTO)-0.9999995e9phot.mag;em.IR.NIR
yKronMagErrreal4magExtended source Y mag error (Kron - SExtractor MAG_AUTO)-0.9999995e9stat.error;em.IR.NIR;phot.mag
yAperMag3 tooltipreal4magDefault point source Y aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yAperMag3Errreal4magError in default point/extended source Y mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.NIR;phot.mag
yAperMag4real4magPoint source Y aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yAperMag4Errreal4magError in point/extended source Y mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.NIR;phot.mag
yAperMag6real4magPoint source Y aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yAperMag6Errreal4magError in point/extended source Y mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.NIR;phot.mag
yAperMagNoAperCorr3 tooltipreal4magDefault extended source Y aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yAperMagNoAperCorr4real4magExtended source Y aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yAperMagNoAperCorr6real4magExtended source Y aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.NIR
yHalfRadreal4pixelsSExtractor half-light radius in Y band-0.9999995e9phys.angSize;em.IR.NIR
yHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Y band-0.9999995e9phys.angSize;em.IR.NIR
yGausigreal4pixelsRMS of axes of ellipse fit in Y-0.9999995e9src.morph.param;em.IR.NIR
yEllreal4 1-b/a, where a/b=semi-major/minor axes in Y-0.9999995e9src.ellipticity;em.IR.NIR
yPAreal4Degreesellipse fit celestial orientation in Y-0.9999995e9pos.posAng;em.IR.NIR
yErrBits link to glossaryint4 processing warning/error bitwise flags in Y-99999999meta.code;em.IR.NIR
yClasssmallint2 discrete image classification flag in Y-9999src.class;em.IR.NIR
yClassStatreal4 S-Extractor classification statistic in Y-0.9999995e9stat;em.IR.NIR
yppErrBitsint4 additional WFAU post-processing error bits in Y0meta.code;em.IR.NIR
ySeqNumint4 the running number of the Y detection-99999999meta.number;em.IR.NIR
yXi link to glossaryreal4arcsecOffset of Y detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.NIR
yEta link to glossaryreal4arcsecOffset of Y detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.NIR
jPetroMagreal4magExtended source J mag (Petrosian)-0.9999995e9phot.mag;em.IR.J
jPetroMagErrreal4magError in extended source J mag (Petrosian)-0.9999995e9stat.error;em.IR.J;phot.mag
jKronMagreal4magExtended source J mag (Kron - SExtractor MAG_AUTO)-0.9999995e9phot.mag;em.IR.J
jKronMagErrreal4magExtended source J mag error (Kron - SExtractor MAG_AUTO)-0.9999995e9stat.error;em.IR.J;phot.mag
jAperMag3 tooltipreal4magDefault point source J aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag3Errreal4magError in default point/extended source J mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.J;phot.mag
jAperMag4real4magPoint source J aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag4Errreal4magError in point/extended source J mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.J;phot.mag
jAperMag6real4magPoint source J aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag6Errreal4magError in point/extended source J mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.J;phot.mag
jAperMagNoAperCorr3 tooltipreal4magDefault extended source J aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMagNoAperCorr4real4magExtended source J aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMagNoAperCorr6real4magExtended source J aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jHalfRadreal4pixelsSExtractor half-light radius in J band-0.9999995e9phys.angSize;em.IR.J
jHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in J band-0.9999995e9phys.angSize;em.IR.J
jGausigreal4pixelsRMS of axes of ellipse fit in J-0.9999995e9src.morph.param;em.IR.J
jEllreal4 1-b/a, where a/b=semi-major/minor axes in J-0.9999995e9src.ellipticity;em.IR.J
jPAreal4Degreesellipse fit celestial orientation in J-0.9999995e9pos.posAng;em.IR.J
jErrBits link to glossaryint4 processing warning/error bitwise flags in J-99999999meta.code;em.IR.J
jClasssmallint2 discrete image classification flag in J-9999src.class;em.IR.J
jClassStatreal4 S-Extractor classification statistic in J-0.9999995e9stat;em.IR.J
jppErrBitsint4 additional WFAU post-processing error bits in J0meta.code;em.IR.J
jSeqNumint4 the running number of the J detection-99999999meta.number;em.IR.J
jXi link to glossaryreal4arcsecOffset of J detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.J
jEta link to glossaryreal4arcsecOffset of J detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.J
hPetroMagreal4magExtended source H mag (Petrosian)-0.9999995e9phot.mag;em.IR.H
hPetroMagErrreal4magError in extended source H mag (Petrosian)-0.9999995e9stat.error;em.IR.H;phot.mag
hKronMagreal4magExtended source H mag (Kron - SExtractor MAG_AUTO)-0.9999995e9phot.mag;em.IR.H
hKronMagErrreal4magExtended source H mag error (Kron - SExtractor MAG_AUTO)-0.9999995e9stat.error;em.IR.H;phot.mag
hAperMag3 tooltipreal4magDefault point source H aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag3Errreal4magError in default point/extended source H mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.H;phot.mag
hAperMag4real4magPoint source H aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag4Errreal4magError in point/extended source H mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.H;phot.mag
hAperMag6real4magPoint source H aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag6Errreal4magError in point/extended source H mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.H;phot.mag
hAperMagNoAperCorr3 tooltipreal4magDefault extended source H aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMagNoAperCorr4real4magExtended source H aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMagNoAperCorr6real4magExtended source H aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hHalfRadreal4pixelsSExtractor half-light radius in H band-0.9999995e9phys.angSize;em.IR.H
hHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in H band-0.9999995e9phys.angSize;em.IR.H
hGausigreal4pixelsRMS of axes of ellipse fit in H-0.9999995e9src.morph.param;em.IR.H
hEllreal4 1-b/a, where a/b=semi-major/minor axes in H-0.9999995e9src.ellipticity;em.IR.H
hPAreal4Degreesellipse fit celestial orientation in H-0.9999995e9pos.posAng;em.IR.H
hErrBits link to glossaryint4 processing warning/error bitwise flags in H-99999999meta.code;em.IR.H
hClasssmallint2 discrete image classification flag in H-9999src.class;em.IR.H
hClassStatreal4 S-Extractor classification statistic in H-0.9999995e9stat;em.IR.H
hppErrBitsint4 additional WFAU post-processing error bits in H0meta.code;em.IR.H
hSeqNumint4 the running number of the H detection-99999999meta.number;em.IR.H
hXi link to glossaryreal4arcsecOffset of H detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.H
hEta link to glossaryreal4arcsecOffset of H detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.H
ksPetroMagreal4magExtended source Ks mag (Petrosian)-0.9999995e9phot.mag;em.IR.K
ksPetroMagErrreal4magError in extended source Ks mag (Petrosian)-0.9999995e9stat.error;em.IR.K;phot.mag
ksKronMagreal4magExtended source Ks mag (Kron - SExtractor MAG_AUTO)-0.9999995e9phot.mag;em.IR.K
ksKronMagErrreal4magExtended source Ks mag error (Kron - SExtractor MAG_AUTO)-0.9999995e9stat.error;em.IR.K;phot.mag
ksAperMag3 tooltipreal4magDefault point source Ks aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag3Errreal4magError in default point/extended source Ks mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.K;phot.mag
ksAperMag4real4magPoint source Ks aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag4Errreal4magError in point/extended source Ks mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.K;phot.mag
ksAperMag6real4magPoint source Ks aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag6Errreal4magError in point/extended source Ks mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error;em.IR.K;phot.mag
ksAperMagNoAperCorr3 tooltipreal4magDefault extended source Ks aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMagNoAperCorr4real4magExtended source Ks aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMagNoAperCorr6real4magExtended source Ks aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksHalfRadreal4pixelsSExtractor half-light radius in Ks band-0.9999995e9phys.angSize;em.IR.K
ksHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Ks band-0.9999995e9phys.angSize;em.IR.K
ksGausigreal4pixelsRMS of axes of ellipse fit in Ks-0.9999995e9src.morph.param;em.IR.K
ksEllreal4 1-b/a, where a/b=semi-major/minor axes in Ks-0.9999995e9src.ellipticity;em.IR.K
ksPAreal4Degreesellipse fit celestial orientation in Ks-0.9999995e9pos.posAng;em.IR.K
ksErrBits link to glossaryint4 processing warning/error bitwise flags in Ks-99999999meta.code;em.IR.K
ksClasssmallint2 discrete image classification flag in Ks-9999src.class;em.IR.K
ksClassStatreal4 S-Extractor classification statistic in Ks-0.9999995e9stat;em.IR.K
ksppErrBitsint4 additional WFAU post-processing error bits in Ks0meta.code;em.IR.K
ksSeqNumint4 the running number of the Ks detection-99999999meta.number;em.IR.K
ksXi link to glossaryreal4arcsecOffset of Ks detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.K
ksEta link to glossaryreal4arcsecOffset of Ks detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.K
Total length708