TABLE  calSynopticSource

Contains CAL merged sources from CAL detections in calDetection.

Prescription for the merging (from RequiredFilters) is: Z, Y, J, H, K, H2, Br, Nbj.

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
synopticIDbigint8 UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm ID_MAIN
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
synFrameSetID link to glossarybigint8 UID of the set of frames that this merged source comes from REFER_CODE
synSeqNum tooltipint4 the running number of this source {catalogue TType keyword: Sequence_number} ID_NUMBER
ra link to glossaryfloat8DegreesCelestial Right Ascension POS_EQ_RA_MAIN
dec link to glossaryfloat8DegreesCelestial Declination POS_EQ_DEC_MAIN
cxfloat8 unit vector of spherical co-ordinates POS_EQ_X
cyfloat8 unit vector of spherical co-ordinates POS_EQ_Y
czfloat8 unit vector of spherical co-ordinates POS_EQ_Z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates POS_GENERAL
lfloat8DegreesGalactic longitude POS_GAL_LON
bfloat8DegreesGalactic latitude POS_GAL_LAT
lambdafloat8DegreesSDSS system spherical co-ordinate 1 POS
etafloat8DegreesSDSS system spherical co-ordinate 2 POS
zmyPnt link to glossaryreal4magPoint source colour Z-Y (using aperMag3)-0.9999995e9PHOT_COLOR
zmyPntErr link to glossaryreal4magError on point source colour Z-Y-0.9999995e9ERROR
ymjPnt link to glossaryreal4magPoint source colour Y-J (using aperMag3)-0.9999995e9PHOT_COLOR
ymjPntErr link to glossaryreal4magError on point source colour Y-J-0.9999995e9ERROR
jmhPnt link to glossaryreal4magPoint source colour J-H (using aperMag3)-0.9999995e9PHOT_COLOR
jmhPntErr link to glossaryreal4magError on point source colour J-H-0.9999995e9ERROR
hmkPnt link to glossaryreal4magPoint source colour H-K (using aperMag3)-0.9999995e9PHOT_COLOR
hmkPntErr link to glossaryreal4magError on point source colour H-K-0.9999995e9ERROR
h2mkPnt link to glossaryreal4magPoint source colour H2-K (using aperMag3)-0.9999995e9PHOT_COLOR
h2mkPntErr link to glossaryreal4magError on point source colour H2-K-0.9999995e9ERROR
brmkPnt link to glossaryreal4magPoint source colour Br-K (using aperMag3)-0.9999995e9PHOT_COLOR
brmkPntErr link to glossaryreal4magError on point source colour Br-K-0.9999995e9ERROR
nbjmjPnt link to glossaryreal4magPoint source colour Nbj-J (using aperMag3)-0.9999995e9PHOT_COLOR
nbjmjPntErr link to glossaryreal4magError on point source colour Nbj-J-0.9999995e9ERROR
mergedClassStat link to glossaryreal4 Merged N(0,1) stellarness-of-profile statistic-0.9999995e9STAT_PROP
mergedClass link to glossarysmallint2 Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) CODE_MISC
pStar link to glossaryreal4 Probability that the source is a star STAT_PROP
pGalaxy link to glossaryreal4 Probability that the source is a galaxy STAT_PROP
pNoise link to glossaryreal4 Probability that the source is noise STAT_PROP
pSaturated link to glossaryreal4 Probability that the source is saturated STAT_PROP
zAperMag1real4magExtended source Z aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag1Errreal4magError in extended source Z mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
zAperMag2real4magExtended source Z aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag2Errreal4magError in extended source Z mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
zAperMag3real4magDefault point/extended 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.9999995e9ERROR
zAperMag4real4magExtended source Z aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag4Errreal4magError in extended source Z mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
zAperMag5real4magExtended source Z aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag5Errreal4magError in extended source Z mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
zGausigreal4pixelsRMS of axes of ellipse fit in Z-0.9999995e9MORPH_PARAM
zEllreal4 1-b/a, where a/b=semi-major/minor axes in Z-0.9999995e9PHYS_ELLIPTICITY
zPAreal4Degreesellipse fit celestial orientation in Z-0.9999995e9POS_POS-ANG
zErrBits link to glossaryint4 processing warning/error bitwise flags in Z-99999999CODE_MISC
zDeblendint4 placeholder flag indicating parent/child relation in Z-99999999CODE_MISC
zClasssmallint2 discrete image classification flag in Z-9999CLASS_MISC
zClassStatreal4 N(0,1) stellarness-of-profile statistic in Z-0.9999995e9STAT_PROP
zppErrBits link to glossaryint4 additional WFAU post-processing error bits in Z0CODE_MISC
zSeqNumint4 the running number of the Z detection-99999999ID_NUMBER
zXi link to glossaryreal4arcsecOffset of Z detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
zEta link to glossaryreal4arcsecOffset of Z detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
yAperMag1real4magExtended source Y aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
yAperMag1Errreal4magError in extended source Y mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
yGausigreal4pixelsRMS of axes of ellipse fit in Y-0.9999995e9MORPH_PARAM
yEllreal4 1-b/a, where a/b=semi-major/minor axes in Y-0.9999995e9PHYS_ELLIPTICITY
yPAreal4Degreesellipse fit celestial orientation in Y-0.9999995e9POS_POS-ANG
yErrBits link to glossaryint4 processing warning/error bitwise flags in Y-99999999CODE_MISC
yDeblendint4 placeholder flag indicating parent/child relation in Y-99999999CODE_MISC
yClasssmallint2 discrete image classification flag in Y-9999CLASS_MISC
yClassStatreal4 N(0,1) stellarness-of-profile statistic in Y-0.9999995e9STAT_PROP
yppErrBits link to glossaryint4 additional WFAU post-processing error bits in Y0CODE_MISC
ySeqNumint4 the running number of the Y detection-99999999ID_NUMBER
yXi link to glossaryreal4arcsecOffset of Y detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
yEta link to glossaryreal4arcsecOffset of Y detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
jAperMag1real4magExtended source J aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag1Errreal4magError in extended source J mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
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.9999995e9ERROR
jGausigreal4pixelsRMS of axes of ellipse fit in J-0.9999995e9MORPH_PARAM
jEllreal4 1-b/a, where a/b=semi-major/minor axes in J-0.9999995e9PHYS_ELLIPTICITY
jPAreal4Degreesellipse fit celestial orientation in J-0.9999995e9POS_POS-ANG
jErrBits link to glossaryint4 processing warning/error bitwise flags in J-99999999CODE_MISC
jDeblendint4 placeholder flag indicating parent/child relation in J-99999999CODE_MISC
jClasssmallint2 discrete image classification flag in J-9999CLASS_MISC
jClassStatreal4 N(0,1) stellarness-of-profile statistic in J-0.9999995e9STAT_PROP
jppErrBits link to glossaryint4 additional WFAU post-processing error bits in J0CODE_MISC
jSeqNumint4 the running number of the J detection-99999999ID_NUMBER
jXi link to glossaryreal4arcsecOffset of J detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
jEta link to glossaryreal4arcsecOffset of J detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
hAperMag1real4magExtended source H aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag1Errreal4magError in extended source H mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
hAperMag2real4magExtended source H aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag2Errreal4magError in extended source H mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
hAperMag3real4magDefault point/extended 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.9999995e9ERROR
hAperMag4real4magExtended source H aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag4Errreal4magError in extended source H mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
hAperMag5real4magExtended source H aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag5Errreal4magError in extended source H mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
hGausigreal4pixelsRMS of axes of ellipse fit in H-0.9999995e9MORPH_PARAM
hEllreal4 1-b/a, where a/b=semi-major/minor axes in H-0.9999995e9PHYS_ELLIPTICITY
hPAreal4Degreesellipse fit celestial orientation in H-0.9999995e9POS_POS-ANG
hErrBits link to glossaryint4 processing warning/error bitwise flags in H-99999999CODE_MISC
hDeblendint4 placeholder flag indicating parent/child relation in H-99999999CODE_MISC
hClasssmallint2 discrete image classification flag in H-9999CLASS_MISC
hClassStatreal4 N(0,1) stellarness-of-profile statistic in H-0.9999995e9STAT_PROP
hppErrBits link to glossaryint4 additional WFAU post-processing error bits in H0CODE_MISC
hSeqNumint4 the running number of the H detection-99999999ID_NUMBER
hXi link to glossaryreal4arcsecOffset of H detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
hEta link to glossaryreal4arcsecOffset of H detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
kAperMag1real4magExtended source K aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag1Errreal4magError in extended source K mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag2real4magExtended source K aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag2Errreal4magError in extended source K mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag3real4magDefault point/extended source K aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag3Errreal4magError in default point/extended source K mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag4real4magExtended source K aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag4Errreal4magError in extended source K mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag5real4magExtended source K aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag5Errreal4magError in extended source K mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
kGausigreal4pixelsRMS of axes of ellipse fit in K-0.9999995e9MORPH_PARAM
kEllreal4 1-b/a, where a/b=semi-major/minor axes in K-0.9999995e9PHYS_ELLIPTICITY
kPAreal4Degreesellipse fit celestial orientation in K-0.9999995e9POS_POS-ANG
kErrBits link to glossaryint4 processing warning/error bitwise flags in K-99999999CODE_MISC
kDeblendint4 placeholder flag indicating parent/child relation in K-99999999CODE_MISC
kClasssmallint2 discrete image classification flag in K-9999CLASS_MISC
kClassStatreal4 N(0,1) stellarness-of-profile statistic in K-0.9999995e9STAT_PROP
kppErrBits link to glossaryint4 additional WFAU post-processing error bits in K0CODE_MISC
kSeqNumint4 the running number of the K detection-99999999ID_NUMBER
kXi link to glossaryreal4arcsecOffset of K detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
kEta link to glossaryreal4arcsecOffset of K detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
h2AperMag1real4magExtended source H2 aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag1Errreal4magError in extended source H2 mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag2real4magExtended source H2 aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag2Errreal4magError in extended source H2 mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag3real4magDefault point/extended source H2 aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag3Errreal4magError in default point/extended source H2 mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag4real4magExtended source H2 aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag4Errreal4magError in extended source H2 mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag5real4magExtended source H2 aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag5Errreal4magError in extended source H2 mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
h2Gausigreal4pixelsRMS of axes of ellipse fit in H2-0.9999995e9MORPH_PARAM
h2Ellreal4 1-b/a, where a/b=semi-major/minor axes in H2-0.9999995e9PHYS_ELLIPTICITY
h2PAreal4Degreesellipse fit celestial orientation in H2-0.9999995e9POS_POS-ANG
h2ErrBits link to glossaryint4 processing warning/error bitwise flags in H2-99999999CODE_MISC
h2Deblendint4 placeholder flag indicating parent/child relation in H2-99999999CODE_MISC
h2Classsmallint2 discrete image classification flag in H2-9999CLASS_MISC
h2ClassStatreal4 N(0,1) stellarness-of-profile statistic in H2-0.9999995e9STAT_PROP
h2ppErrBits link to glossaryint4 additional WFAU post-processing error bits in H20CODE_MISC
h2SeqNumint4 the running number of the H2 detection-99999999ID_NUMBER
h2Xi link to glossaryreal4arcsecOffset of H2 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
h2Eta link to glossaryreal4arcsecOffset of H2 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
brAperMag1real4magExtended source Br aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag1Errreal4magError in extended source Br mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag2real4magExtended source Br aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag2Errreal4magError in extended source Br mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag3real4magDefault point/extended source Br aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag3Errreal4magError in default point/extended source Br mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag4real4magExtended source Br aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag4Errreal4magError in extended source Br mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag5real4magExtended source Br aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag5Errreal4magError in extended source Br mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
brGausigreal4pixelsRMS of axes of ellipse fit in Br-0.9999995e9MORPH_PARAM
brEllreal4 1-b/a, where a/b=semi-major/minor axes in Br-0.9999995e9PHYS_ELLIPTICITY
brPAreal4Degreesellipse fit celestial orientation in Br-0.9999995e9POS_POS-ANG
brErrBits link to glossaryint4 processing warning/error bitwise flags in Br-99999999CODE_MISC
brDeblendint4 placeholder flag indicating parent/child relation in Br-99999999CODE_MISC
brClasssmallint2 discrete image classification flag in Br-9999CLASS_MISC
brClassStatreal4 N(0,1) stellarness-of-profile statistic in Br-0.9999995e9STAT_PROP
brppErrBits link to glossaryint4 additional WFAU post-processing error bits in Br0CODE_MISC
brSeqNumint4 the running number of the Br detection-99999999ID_NUMBER
brXi link to glossaryreal4arcsecOffset of Br detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
brEta link to glossaryreal4arcsecOffset of Br detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
nbjAperMag1real4magExtended source Nbj aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
nbjAperMag1Errreal4magError in extended source Nbj mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
nbjAperMag2real4magExtended source Nbj aperture corrected mag (1.4 arcsec aperture diameter)-0.9999995e9PHOT_MAG
nbjAperMag2Errreal4magError in extended source Nbj mag (1.4 arcsec aperture diameter)-0.9999995e9ERROR
nbjAperMag3real4magDefault point/extended source Nbj aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
nbjAperMag3Errreal4magError in default point/extended source Nbj mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
nbjAperMag4real4magExtended source Nbj aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
nbjAperMag4Errreal4magError in extended source Nbj mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
nbjAperMag5real4magExtended source Nbj aperture corrected mag (4.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
nbjAperMag5Errreal4magError in extended source Nbj mag (4.0 arcsec aperture diameter)-0.9999995e9ERROR
nbjGausigreal4pixelsRMS of axes of ellipse fit in Nbj-0.9999995e9MORPH_PARAM
nbjEllreal4 1-b/a, where a/b=semi-major/minor axes in Nbj-0.9999995e9PHYS_ELLIPTICITY
nbjPAreal4Degreesellipse fit celestial orientation in Nbj-0.9999995e9POS_POS-ANG
nbjErrBits link to glossaryint4 processing warning/error bitwise flags in Nbj-99999999CODE_MISC
nbjDeblendint4 placeholder flag indicating parent/child relation in Nbj-99999999CODE_MISC
nbjClasssmallint2 discrete image classification flag in Nbj-9999CLASS_MISC
nbjClassStatreal4 N(0,1) stellarness-of-profile statistic in Nbj-0.9999995e9STAT_PROP
nbjppErrBits link to glossaryint4 additional WFAU post-processing error bits in Nbj0CODE_MISC
nbjSeqNumint4 the running number of the Nbj detection-99999999ID_NUMBER
nbjXi link to glossaryreal4arcsecOffset of Nbj detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
nbjEta link to glossaryreal4arcsecOffset of Nbj detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
Total length838