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.distance;pos.cartesian.x
cyfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.y
czfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.eq
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
zmyPntErr link to glossaryreal4magError on point source colour Z-Y-0.9999995e9stat.error
ymjPnt link to glossaryreal4magPoint source colour Y-J (using aperMag3)-0.9999995e9PHOT_COLOR
ymjPntErr link to glossaryreal4magError on point source colour Y-J-0.9999995e9stat.error
jmhPnt link to glossaryreal4magPoint source colour J-H (using aperMag3)-0.9999995e9PHOT_COLOR
jmhPntErr link to glossaryreal4magError on point source colour J-H-0.9999995e9stat.error
hmksPnt link to glossaryreal4magPoint source colour H-Ks (using aperMag3)-0.9999995e9PHOT_COLOR
hmksPntErr link to glossaryreal4magError on point source colour H-Ks-0.9999995e9stat.error
zmyExt link to glossaryreal4magExtended source colour Z-Y (using aperMagNoAperCorr3)-0.9999995e9PHOT_COLOR
zmyExtErr link to glossaryreal4magError on extended source colour Z-Y-0.9999995e9stat.error
ymjExt link to glossaryreal4magExtended source colour Y-J (using aperMagNoAperCorr3)-0.9999995e9PHOT_COLOR
ymjExtErr link to glossaryreal4magError on extended source colour Y-J-0.9999995e9stat.error
jmhExt link to glossaryreal4magExtended source colour J-H (using aperMagNoAperCorr3)-0.9999995e9PHOT_COLOR
jmhExtErr link to glossaryreal4magError on extended source colour J-H-0.9999995e9stat.error
hmksExt link to glossaryreal4magExtended source colour H-Ks (using aperMagNoAperCorr3)-0.9999995e9PHOT_COLOR
hmksExtErr link to glossaryreal4magError on extended source colour H-Ks-0.9999995e9stat.error
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.9999995e9 
aZreal4magThe galactic extinction correction in the Z band for extragalactic objects-0.9999995e9 
aYreal4magThe galactic extinction correction in the Y band for extragalactic objects-0.9999995e9 
aJreal4magThe galactic extinction correction in the J band for extragalactic objects-0.9999995e9 
aHreal4magThe galactic extinction correction in the H band for extragalactic objects-0.9999995e9 
aKsreal4magThe galactic extinction correction in the Ks band for extragalactic objects-0.9999995e9 
zPetroMagreal4magExtended source Z mag (Petrosian)-0.9999995e9phot.mag
zPetroMagErrreal4magError in extended source Z mag (Petrosian)-0.9999995e9stat.error
zAperMag3 tooltipreal4magDefault point source Z aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
zAperMag3Errreal4magError in default point/extended source Z mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error
zAperMag4real4magPoint source Z aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
zAperMag4Errreal4magError in point/extended source Z mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
zAperMag6real4magPoint source Z aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
zAperMag6Errreal4magError in point/extended source Z mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error
zAperMagNoAperCorr3 tooltipreal4magDefault extended source Z aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
zAperMagNoAperCorr4real4magExtended source Z aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
zAperMagNoAperCorr6real4magExtended source Z aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
zHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Z band-0.9999995e9phys.angSize;src
zGausigreal4pixelsRMS of axes of ellipse fit in Z-0.9999995e9src.morph.param
zEllreal4 1-b/a, where a/b=semi-major/minor axes in Z-0.9999995e9src.ellipticity
zPAreal4Degreesellipse fit celestial orientation in Z-0.9999995e9pos.posAng
zErrBits link to glossaryint4 processing warning/error bitwise flags in Z-99999999meta.code
zClasssmallint2 discrete image classification flag in Z-9999src.class
zClassStatreal4 S-Extractor classification statistic in Z-0.9999995e9stat
zppErrBitsint4 additional WFAU post-processing error bits in Z0meta.code
zSeqNumint4 the running number of the Z detection-99999999meta.id
zXi link to glossaryreal4arcsecOffset of Z detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
zEta link to glossaryreal4arcsecOffset of Z detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
yPetroMagreal4magExtended source Y mag (Petrosian)-0.9999995e9phot.mag
yPetroMagErrreal4magError in extended source Y mag (Petrosian)-0.9999995e9stat.error
yAperMag3 tooltipreal4magDefault point source Y aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag3Errreal4magError in default point/extended source Y mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error
yAperMag4real4magPoint source Y aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag4Errreal4magError in point/extended source Y mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
yAperMag6real4magPoint source Y aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag6Errreal4magError in point/extended source Y mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error
yAperMagNoAperCorr3 tooltipreal4magDefault extended source Y aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMagNoAperCorr4real4magExtended source Y aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMagNoAperCorr6real4magExtended source Y aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
yHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Y band-0.9999995e9phys.angSize;src
yGausigreal4pixelsRMS of axes of ellipse fit in Y-0.9999995e9src.morph.param
yEllreal4 1-b/a, where a/b=semi-major/minor axes in Y-0.9999995e9src.ellipticity
yPAreal4Degreesellipse fit celestial orientation in Y-0.9999995e9pos.posAng
yErrBits link to glossaryint4 processing warning/error bitwise flags in Y-99999999meta.code
yClasssmallint2 discrete image classification flag in Y-9999src.class
yClassStatreal4 S-Extractor classification statistic in Y-0.9999995e9stat
yppErrBitsint4 additional WFAU post-processing error bits in Y0meta.code
ySeqNumint4 the running number of the Y detection-99999999meta.id
yXi link to glossaryreal4arcsecOffset of Y detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
yEta link to glossaryreal4arcsecOffset of Y detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
jPetroMagreal4magExtended source J mag (Petrosian)-0.9999995e9phot.mag
jPetroMagErrreal4magError in extended source J mag (Petrosian)-0.9999995e9stat.error
jAperMag3 tooltipreal4magDefault point source J aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag3Errreal4magError in default point/extended source J mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error
jAperMag4real4magPoint source J aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag4Errreal4magError in point/extended source J mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
jAperMag6real4magPoint source J aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag6Errreal4magError in point/extended source J mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error
jAperMagNoAperCorr3 tooltipreal4magDefault extended source J aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMagNoAperCorr4real4magExtended source J aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMagNoAperCorr6real4magExtended source J aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
jHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in J band-0.9999995e9phys.angSize;src
jGausigreal4pixelsRMS of axes of ellipse fit in J-0.9999995e9src.morph.param
jEllreal4 1-b/a, where a/b=semi-major/minor axes in J-0.9999995e9src.ellipticity
jPAreal4Degreesellipse fit celestial orientation in J-0.9999995e9pos.posAng
jErrBits link to glossaryint4 processing warning/error bitwise flags in J-99999999meta.code
jClasssmallint2 discrete image classification flag in J-9999src.class
jClassStatreal4 S-Extractor classification statistic in J-0.9999995e9stat
jppErrBitsint4 additional WFAU post-processing error bits in J0meta.code
jSeqNumint4 the running number of the J detection-99999999meta.id
jXi link to glossaryreal4arcsecOffset of J detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
jEta link to glossaryreal4arcsecOffset of J detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
hPetroMagreal4magExtended source H mag (Petrosian)-0.9999995e9phot.mag
hPetroMagErrreal4magError in extended source H mag (Petrosian)-0.9999995e9stat.error
hAperMag3 tooltipreal4magDefault point source H aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
hAperMag3Errreal4magError in default point/extended source H mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error
hAperMag4real4magPoint source H aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
hAperMag4Errreal4magError in point/extended source H mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
hAperMag6real4magPoint source H aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
hAperMag6Errreal4magError in point/extended source H mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error
hAperMagNoAperCorr3 tooltipreal4magDefault extended source H aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
hAperMagNoAperCorr4real4magExtended source H aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
hAperMagNoAperCorr6real4magExtended source H aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
hHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in H band-0.9999995e9phys.angSize;src
hGausigreal4pixelsRMS of axes of ellipse fit in H-0.9999995e9src.morph.param
hEllreal4 1-b/a, where a/b=semi-major/minor axes in H-0.9999995e9src.ellipticity
hPAreal4Degreesellipse fit celestial orientation in H-0.9999995e9pos.posAng
hErrBits link to glossaryint4 processing warning/error bitwise flags in H-99999999meta.code
hClasssmallint2 discrete image classification flag in H-9999src.class
hClassStatreal4 S-Extractor classification statistic in H-0.9999995e9stat
hppErrBitsint4 additional WFAU post-processing error bits in H0meta.code
hSeqNumint4 the running number of the H detection-99999999meta.id
hXi link to glossaryreal4arcsecOffset of H detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
hEta link to glossaryreal4arcsecOffset of H detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
ksPetroMagreal4magExtended source Ks mag (Petrosian)-0.9999995e9phot.mag
ksPetroMagErrreal4magError in extended source Ks mag (Petrosian)-0.9999995e9stat.error
ksAperMag3 tooltipreal4magDefault point source Ks aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag3Errreal4magError in default point/extended source Ks mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMag4real4magPoint source Ks aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag4Errreal4magError in point/extended source Ks mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMag6real4magPoint source Ks aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag6Errreal4magError in point/extended source Ks mag (5.7 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMagNoAperCorr3 tooltipreal4magDefault extended source Ks aperture mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMagNoAperCorr4real4magExtended source Ks aperture mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMagNoAperCorr6real4magExtended source Ks aperture mag (5.7 arcsec aperture diameter)-0.9999995e9phot.mag
ksHlCorSMjRadAsreal4arcsecSeeing corrected half-light, semi-major axis in Ks band-0.9999995e9phys.angSize;src
ksGausigreal4pixelsRMS of axes of ellipse fit in Ks-0.9999995e9src.morph.param
ksEllreal4 1-b/a, where a/b=semi-major/minor axes in Ks-0.9999995e9src.ellipticity
ksPAreal4Degreesellipse fit celestial orientation in Ks-0.9999995e9pos.posAng
ksErrBits link to glossaryint4 processing warning/error bitwise flags in Ks-99999999meta.code
ksClasssmallint2 discrete image classification flag in Ks-9999src.class
ksClassStatreal4 S-Extractor classification statistic in Ks-0.9999995e9stat
ksppErrBitsint4 additional WFAU post-processing error bits in Ks0meta.code
ksSeqNumint4 the running number of the Ks detection-99999999meta.id
ksXi link to glossaryreal4arcsecOffset of Ks detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff
ksEta link to glossaryreal4arcsecOffset of Ks detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff
Total length648