TABLE  vvvxSource

Contains merged sources from detections in vvvDetection.

Prescription for the merging (from RequiredFilters) is: J, J_1, J_2, H, Ks, Ks_1, Ks_2
Bandpass J comes from deepest J tile frame measurements.
Bandpass J_1 comes from first OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass J_2 comes from second OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass H comes from single epoch OB H tile frame measurements.
Bandpass KS comes from deepest Ks tile frame measurements.
Bandpass KS_1 comes from first OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame
Bandpass KS_2 comes from second OB epoch measurements. This epoch contains data from an J.H.Ks OB tile frame

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references vvvxMergeLog(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.id
frameSetID link to glossarybigint8 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
priOrSec link to glossarybigint8 Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).-99999999meta.code
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
hmks_1Pnt link to glossaryreal4magPoint source colour H-Ks_1 (using aperMag3)-0.9999995e9phot.color;em.IR.H;em.IR.K
hmks_1PntErr link to glossaryreal4magError on point source colour H-Ks_1-0.9999995e9stat.error;em.IR.H;em.IR.K
hmks_2Pnt link to glossaryreal4magPoint source colour H-Ks_2 (using aperMag3)-0.9999995e9phot.color;em.IR.H;em.IR.K
hmks_2PntErr link to glossaryreal4magError on point source colour H-Ks_2-0.9999995e9stat.error;em.IR.H;em.IR.K
j_1mhPnt link to glossaryreal4magPoint source colour J_1-H (using aperMag3)-0.9999995e9phot.color;em.IR.J;em.IR.H
j_1mhPntErr link to glossaryreal4magError on point source colour J_1-H-0.9999995e9stat.error;em.IR.J;em.IR.H
j_2mhPnt link to glossaryreal4magPoint source colour J_2-H (using aperMag3)-0.9999995e9phot.color;em.IR.J;em.IR.H
j_2mhPntErr link to glossaryreal4magError on point source colour J_2-H-0.9999995e9stat.error;em.IR.J;em.IR.H
mergedClassStat link to glossaryreal4 Merged N(0,1) stellarness-of-profile 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.probability
pGalaxy link to glossaryreal4 Probability that the source is a galaxy stat.probability
pNoise link to glossaryreal4 Probability that the source is noise stat.probability
pSaturated link to glossaryreal4 Probability that the source is saturated stat.probability
jMjdfloat8daysModified Julian Day in J band-0.9999995e9time.epoch;em.IR.J
jAperMag1real4magPoint source J aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag1Errreal4magError in point source J mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
jAperMag3 tooltipreal4magDefault point source J aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag3Errreal4magError in default point source J mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
jAperMag4real4magPoint source J aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
jAperMag4Errreal4magError in point source J mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;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
jAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) J-0.9999995e9stat.likelihood;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.id;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
j_1Mjdfloat8daysModified Julian Day in J_1 band-0.9999995e9time.epoch;em.IR.J
j_1AperMag1real4magPoint source J_1 aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_1AperMag1Errreal4magError in point source J_1 mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_1AperMag3 tooltipreal4magDefault point source J_1 aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_1AperMag3Errreal4magError in default point source J_1 mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_1AperMag4real4magPoint source J_1 aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_1AperMag4Errreal4magError in point source J_1 mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_1Gausigreal4pixelsRMS of axes of ellipse fit in J_1-0.9999995e9src.morph.param;em.IR.J
j_1Ellreal4 1-b/a, where a/b=semi-major/minor axes in J_1-0.9999995e9src.ellipticity;em.IR.J
j_1PAreal4Degreesellipse fit celestial orientation in J_1-0.9999995e9pos.posAng;em.IR.J
j_1ErrBits link to glossaryint4 processing warning/error bitwise flags in J_1-99999999meta.code;em.IR.J
j_1AverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) J_1-0.9999995e9stat.likelihood;em.IR.J
j_1Classsmallint2 discrete image classification flag in J_1-9999src.class;em.IR.J
j_1ClassStatreal4 S-Extractor classification statistic in J_1-0.9999995e9stat;em.IR.J
j_1ppErrBitsint4 additional WFAU post-processing error bits in J_10meta.code;em.IR.J
j_1SeqNumint4 the running number of the J_1 detection-99999999meta.id;em.IR.J
j_1Xi link to glossaryreal4arcsecOffset of J_1 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.J
j_1Eta link to glossaryreal4arcsecOffset of J_1 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.J
j_2Mjdfloat8daysModified Julian Day in J_2 band-0.9999995e9time.epoch;em.IR.J
j_2AperMag1real4magPoint source J_2 aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_2AperMag1Errreal4magError in point source J_2 mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_2AperMag3 tooltipreal4magDefault point source J_2 aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_2AperMag3Errreal4magError in default point source J_2 mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_2AperMag4real4magPoint source J_2 aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.J
j_2AperMag4Errreal4magError in point source J_2 mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
j_2Gausigreal4pixelsRMS of axes of ellipse fit in J_2-0.9999995e9src.morph.param;em.IR.J
j_2Ellreal4 1-b/a, where a/b=semi-major/minor axes in J_2-0.9999995e9src.ellipticity;em.IR.J
j_2PAreal4Degreesellipse fit celestial orientation in J_2-0.9999995e9pos.posAng;em.IR.J
j_2ErrBits link to glossaryint4 processing warning/error bitwise flags in J_2-99999999meta.code;em.IR.J
j_2AverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) J_2-0.9999995e9stat.likelihood;em.IR.J
j_2Classsmallint2 discrete image classification flag in J_2-9999src.class;em.IR.J
j_2ClassStatreal4 S-Extractor classification statistic in J_2-0.9999995e9stat;em.IR.J
j_2ppErrBitsint4 additional WFAU post-processing error bits in J_20meta.code;em.IR.J
j_2SeqNumint4 the running number of the J_2 detection-99999999meta.id;em.IR.J
j_2Xi link to glossaryreal4arcsecOffset of J_2 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.J
j_2Eta link to glossaryreal4arcsecOffset of J_2 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.J
hMjdfloat8daysModified Julian Day in H band-0.9999995e9time.epoch;em.IR.H
hAperMag1real4magPoint source H aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag1Errreal4magError in point source H mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.H
hAperMag3 tooltipreal4magDefault point source H aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag3Errreal4magError in default point source H mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.H
hAperMag4real4magPoint source H aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.H
hAperMag4Errreal4magError in point source H mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;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
hAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) H-0.9999995e9stat.likelihood;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.id;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
ksMjdfloat8daysModified Julian Day in Ks band-0.9999995e9time.epoch;em.IR.K
ksAperMag1real4magPoint source Ks aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag1Errreal4magError in point source Ks mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ksAperMag3 tooltipreal4magDefault point source Ks aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag3Errreal4magError in default point source Ks mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ksAperMag4real4magPoint source Ks aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ksAperMag4Errreal4magError in point source Ks mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;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
ksAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Ks-0.9999995e9stat.likelihood;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.id;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
ks_1Mjdfloat8daysModified Julian Day in Ks_1 band-0.9999995e9time.epoch;em.IR.K
ks_1AperMag1real4magPoint source Ks_1 aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_1AperMag1Errreal4magError in point source Ks_1 mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_1AperMag3 tooltipreal4magDefault point source Ks_1 aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_1AperMag3Errreal4magError in default point source Ks_1 mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_1AperMag4real4magPoint source Ks_1 aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_1AperMag4Errreal4magError in point source Ks_1 mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_1Gausigreal4pixelsRMS of axes of ellipse fit in Ks_1-0.9999995e9src.morph.param;em.IR.K
ks_1Ellreal4 1-b/a, where a/b=semi-major/minor axes in Ks_1-0.9999995e9src.ellipticity;em.IR.K
ks_1PAreal4Degreesellipse fit celestial orientation in Ks_1-0.9999995e9pos.posAng;em.IR.K
ks_1ErrBits link to glossaryint4 processing warning/error bitwise flags in Ks_1-99999999meta.code;em.IR.K
ks_1AverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Ks_1-0.9999995e9stat.likelihood;em.IR.K
ks_1Classsmallint2 discrete image classification flag in Ks_1-9999src.class;em.IR.K
ks_1ClassStatreal4 S-Extractor classification statistic in Ks_1-0.9999995e9stat;em.IR.K
ks_1ppErrBitsint4 additional WFAU post-processing error bits in Ks_10meta.code;em.IR.K
ks_1SeqNumint4 the running number of the Ks_1 detection-99999999meta.id;em.IR.K
ks_1Xi link to glossaryreal4arcsecOffset of Ks_1 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.K
ks_1Eta link to glossaryreal4arcsecOffset of Ks_1 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.K
ks_2Mjdfloat8daysModified Julian Day in Ks_2 band-0.9999995e9time.epoch;em.IR.K
ks_2AperMag1real4magPoint source Ks_2 aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_2AperMag1Errreal4magError in point source Ks_2 mag (1.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_2AperMag3 tooltipreal4magDefault point source Ks_2 aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_2AperMag3Errreal4magError in default point source Ks_2 mag (2.0 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_2AperMag4real4magPoint source Ks_2 aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag;em.IR.K
ks_2AperMag4Errreal4magError in point source Ks_2 mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
ks_2Gausigreal4pixelsRMS of axes of ellipse fit in Ks_2-0.9999995e9src.morph.param;em.IR.K
ks_2Ellreal4 1-b/a, where a/b=semi-major/minor axes in Ks_2-0.9999995e9src.ellipticity;em.IR.K
ks_2PAreal4Degreesellipse fit celestial orientation in Ks_2-0.9999995e9pos.posAng;em.IR.K
ks_2ErrBits link to glossaryint4 processing warning/error bitwise flags in Ks_2-99999999meta.code;em.IR.K
ks_2AverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Ks_2-0.9999995e9stat.likelihood;em.IR.K
ks_2Classsmallint2 discrete image classification flag in Ks_2-9999src.class;em.IR.K
ks_2ClassStatreal4 S-Extractor classification statistic in Ks_2-0.9999995e9stat;em.IR.K
ks_2ppErrBitsint4 additional WFAU post-processing error bits in Ks_20meta.code;em.IR.K
ks_2SeqNumint4 the running number of the Ks_2 detection-99999999meta.id;em.IR.K
ks_2Xi link to glossaryreal4arcsecOffset of Ks_2 detection from master position (+east/-west)-0.9999995e9pos.eq.ra;arith.diff;em.IR.K
ks_2Eta link to glossaryreal4arcsecOffset of Ks_2 detection from master position (+north/-south)-0.9999995e9pos.eq.dec;arith.diff;em.IR.K
Total length696