TABLE  vmcSynopticSource

Contains VMC merged sources from VMC detections in vmcDetection.

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

Required constraints:
  • Primary key is (synFrameSetID,synSeqNum)
  • (synFrameSetID) references vmcSynopticMergeLog(synFrameSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
synopticIDbigint8 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
synFrameSetID link to glossarybigint8 UID of the set of frames that this merged source comes from meta.bib
synSeqNum tooltipint4 the running number of this source {catalogue TType keyword: Sequence_number} 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.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
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
jmksPnt link to glossaryreal4magPoint source colour J-Ks (using aperMag3)-0.9999995e9PHOT_COLOR
jmksPntErr link to glossaryreal4magError on point source colour J-Ks-0.9999995e9stat.error
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
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
yMjdfloat8daysModified Julian Day in Y band-0.9999995e9??
yAperMag1real4magExtended source Y aperture corrected mag (0.7 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag1Errreal4magError in extended source Y mag (0.7 arcsec aperture diameter)-0.9999995e9stat.error
yAperMag2real4magExtended source Y aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag2Errreal4magError in extended source Y mag (1.4 arcsec aperture diameter)-0.9999995e9stat.error
yAperMag3real4magDefault point/extended 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
yAperMag4real4magExtended source Y aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag4Errreal4magError in extended source Y mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
yAperMag5real4magExtended source Y aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9phot.mag
yAperMag5Errreal4magError in extended source Y mag (4.0 arcsec aperture diameter)-0.9999995e9stat.error
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
yAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Y-99999999meta.code
yClasssmallint2 discrete image classification flag in Y-9999src.class
yClassStatreal4 N(0,1) stellarness-of-profile statistic in Y-0.9999995e9stat
yppErrBits link to glossaryint4 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
jMjdfloat8daysModified Julian Day in J band-0.9999995e9??
jAperMag1real4magExtended source J aperture corrected mag (0.7 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag1Errreal4magError in extended source J mag (0.7 arcsec aperture diameter)-0.9999995e9stat.error
jAperMag2real4magExtended source J aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag2Errreal4magError in extended source J mag (1.4 arcsec aperture diameter)-0.9999995e9stat.error
jAperMag3real4magDefault point/extended 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
jAperMag4real4magExtended source J aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag4Errreal4magError in extended source J mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
jAperMag5real4magExtended source J aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9phot.mag
jAperMag5Errreal4magError in extended source J mag (4.0 arcsec aperture diameter)-0.9999995e9stat.error
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
jAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) J-99999999meta.code
jClasssmallint2 discrete image classification flag in J-9999src.class
jClassStatreal4 N(0,1) stellarness-of-profile statistic in J-0.9999995e9stat
jppErrBits link to glossaryint4 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
ksMjdfloat8daysModified Julian Day in Ks band-0.9999995e9??
ksAperMag1real4magExtended source Ks aperture corrected mag (0.7 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag1Errreal4magError in extended source Ks mag (0.7 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMag2real4magExtended source Ks aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag2Errreal4magError in extended source Ks mag (1.4 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMag3real4magDefault point/extended 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
ksAperMag4real4magExtended source Ks aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag4Errreal4magError in extended source Ks mag (2.8 arcsec aperture diameter)-0.9999995e9stat.error
ksAperMag5real4magExtended source Ks aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9phot.mag
ksAperMag5Errreal4magError in extended source Ks mag (4.0 arcsec aperture diameter)-0.9999995e9stat.error
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
ksAverageConfreal4 average confidence in 2 arcsec diameter default aperture (aper3) Ks-99999999meta.code
ksClasssmallint2 discrete image classification flag in Ks-9999src.class
ksClassStatreal4 N(0,1) stellarness-of-profile statistic in Ks-0.9999995e9stat
ksppErrBits link to glossaryint4 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 length412