TABLE  vmcSource

Contains merged sources from detections in vmcDetection.

Prescription for the merging (from RequiredFilters) is: Ks, J, Y
Bandpass KS comes from deepest Ks tile frame measurements.
Bandpass J comes from deepest J tile frame measurements.
Bandpass Y comes from deepest Y tile frame measurements.

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references vmcMergeLog(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.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
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
jmksPnt link to glossaryreal4magPoint source colour J-Ks (using aperMag3)-0.9999995e9phot.color;em.IR.J;em.IR.K
jmksPntErr link to glossaryreal4magError on point source colour J-Ks-0.9999995e9stat.error;em.IR.J;em.IR.K
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
jmksExt link to glossaryreal4magExtended source colour J-Ks (using aperMagNoAperCorr3)-0.9999995e9phot.color;em.IR.J;em.IR.K
jmksExtErr link to glossaryreal4magError on extended source colour J-Ks-0.9999995e9stat.error;em.IR.J;em.IR.K
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
ksMjdfloat8daysModified Julian Day in Ks band-0.9999995e9time.epoch;em.IR.K
ksPetroMagreal4magExtended source Ks mag (Petrosian)-0.9999995e9phot.mag;em.IR.K
ksPetroMagErrreal4magError in extended source Ks mag (Petrosian)-0.9999995e9stat.error;phot.mag;em.IR.K
ksPsfMagreal4magPoint source profile-fitted Ks mag-0.9999995e9phot.mag;em.IR.K
ksPsfMagErrreal4magError in point source profile-fitted Ks mag-0.9999995e9stat.error;phot.mag;em.IR.K
ksSerMag2Dreal4magExtended source Ks mag (profile-fitted)-0.9999995e9phot.mag;em.IR.K
ksSerMag2DErrreal4magError in extended source Ks mag (profile-fitted)-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/extended 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/extended source Ks mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.K
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;phot.mag;em.IR.K
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
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 N(0,1) stellarness-of-profile statistic in Ks-0.9999995e9stat;em.IR.K
ksppErrBits link to glossaryint4 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
jMjdfloat8daysModified Julian Day in J band-0.9999995e9time.epoch;em.IR.J
jPetroMagreal4magExtended source J mag (Petrosian)-0.9999995e9phot.mag;em.IR.J
jPetroMagErrreal4magError in extended source J mag (Petrosian)-0.9999995e9stat.error;phot.mag;em.IR.J
jPsfMagreal4magPoint source profile-fitted J mag-0.9999995e9phot.mag;em.IR.J
jPsfMagErrreal4magError in point source profile-fitted J mag-0.9999995e9stat.error;phot.mag;em.IR.J
jSerMag2Dreal4magExtended source J mag (profile-fitted)-0.9999995e9phot.mag;em.IR.J
jSerMag2DErrreal4magError in extended source J mag (profile-fitted)-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/extended 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/extended source J mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error;phot.mag;em.IR.J
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;phot.mag;em.IR.J
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
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 N(0,1) stellarness-of-profile statistic in J-0.9999995e9stat;em.IR.J
jppErrBits link to glossaryint4 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
yMjdfloat8daysModified Julian Day in Y band-0.9999995e9time.epoch;em.IR.NIR
yPetroMagreal4magExtended source Y mag (Petrosian)-0.9999995e9phot.mag;em.IR.NIR
yPetroMagErrreal4magError in extended source Y mag (Petrosian)-0.9999995e9stat.error;phot.mag;em.IR.NIR
yPsfMagreal4magPoint source profile-fitted Y mag-0.9999995e9phot.mag;em.IR.NIR
yPsfMagErrreal4magError in point source profile-fitted Y mag-0.9999995e9stat.error;phot.mag;em.IR.NIR
ySerMag2Dreal4magExtended source Y mag (profile-fitted)-0.9999995e9phot.mag;em.IR.NIR
ySerMag2DErrreal4magError in extended source Y mag (profile-fitted)-0.9999995e9stat.error;phot.mag;em.IR.NIR
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;phot.mag;em.IR.NIR
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;phot.mag;em.IR.NIR
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;phot.mag;em.IR.NIR
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
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
yAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Y-0.9999995e9stat.likelihood;em.IR.NIR
yClasssmallint2 discrete image classification flag in Y-9999src.class;em.IR.NIR
yClassStatreal4 N(0,1) stellarness-of-profile statistic in Y-0.9999995e9stat;em.IR.NIR
yppErrBits link to glossaryint4 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
Total length492