TABLE  commSource

Contains merged sources from commissioning detections in commDetection.

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

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references commMergeLog(frameSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 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
frameSetID link to glossarybigint8 UID of the set of frames that this merged source comes from REFER_CODE
rafloat8DegreesCelestial Right Ascension POS_EQ_RA_MAIN
decfloat8DegreesCelestial Declination POS_EQ_DEC_MAIN
sigRareal4DegreesUncertainty in RA-0.9999995e9ERROR
sigDecreal4DegreesUncertainty in Dec-0.9999995e9ERROR
epochreal4YearsEpoch of position measurement-0.9999995e9TIME_EPOCH
muRareal4mas/yrProper motion in RA direction-0.9999995e9POS_EQ_PMRA
muDecreal4mas/yrProper motion in Dec direction-0.9999995e9POS_EQ_PMDEC
sigMuRareal4mas/yrError on proper motion in RA direction-0.9999995e9ERROR
sigMuDecreal4mas/yrError on proper motion in Dec direction-0.9999995e9ERROR
chi2real4 Chi-squared value of proper motion solution-0.9999995e9FIT_CHI2
nFramestinyint1 No. of frames used for this proper motion measurement0NUMBER
cxfloat8 unit vector of spherical co-ordinate POS_EQ_X
cyfloat8 unit vector of spherical co-ordinate POS_EQ_Y
czfloat8 unit vector of spherical co-ordinate POS_EQ_Z
htmIDbigint8 HTM index, 20 digits, for co-ordinate 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
priOrSec link to glossarybigint8 Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).-99999999CODE_MISC
zmyPnt link to glossaryreal4magPoint source colour Z-Y (using appropriate mags)-0.9999995e9PHOT_COLOR
zmyPntErr link to glossaryreal4magError on colour Z-Y-0.9999995e9ERROR
ymjPnt link to glossaryreal4magPoint source colour Y-J (using appropriate mags)-0.9999995e9PHOT_COLOR
ymjPntErr link to glossaryreal4magError on colour Y-J-0.9999995e9ERROR
jmhPnt link to glossaryreal4magPoint source colour J-H (using appropriate mags)-0.9999995e9PHOT_COLOR
jmhPntErr link to glossaryreal4magError on colour J-H-0.9999995e9ERROR
hmkPnt link to glossaryreal4magPoint source colour H-K (using appropriate mags)-0.9999995e9PHOT_COLOR
hmkPntErr link to glossaryreal4magError on colour H-K-0.9999995e9ERROR
zmyExt link to glossaryreal4magExtended source colour Z-Y (using appropriate mags)-0.9999995e9PHOT_COLOR
zmyExtErr link to glossaryreal4magError on colour Z-Y-0.9999995e9ERROR
ymjExt link to glossaryreal4magExtended source colour Y-J (using appropriate mags)-0.9999995e9PHOT_COLOR
ymjExtErr link to glossaryreal4magError on colour Y-J-0.9999995e9ERROR
jmhExt link to glossaryreal4magExtended source colour J-H (using appropriate mags)-0.9999995e9PHOT_COLOR
jmhExtErr link to glossaryreal4magError on colour J-H-0.9999995e9ERROR
hmkExt link to glossaryreal4magExtended source colour H-K (using appropriate mags)-0.9999995e9PHOT_COLOR
hmkExtErr link to glossaryreal4magError on colour H-K-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
zHallMagreal4magPoint source Z mag-0.9999995e9PHOT_MAG
zHallMagErrreal4magError in point source Z mag-0.9999995e9ERROR
zPetroMagreal4magExtended source Z mag (Petrosian)-0.9999995e9PHOT_MAG
zPetroMagErrreal4magError in extended source Z mag (Petrosian)-0.9999995e9ERROR
zPsfMagreal4magPoint source profile-fitted Z mag-0.9999995e9PHOT_MAG
zPsfMagErrreal4magError in point source profile-fitted Z mag-0.9999995e9ERROR
zSerMag2Dreal4magExtended source Z mag (profile-fitted)-0.9999995e9PHOT_MAG
zSerMag2DErrreal4magError in extended source Z mag (profile-fitted)-0.9999995e9ERROR
zAperMag3real4magExtended source Z mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag3Errreal4magError in extended source Z mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
zAperMag4real4magExtended source Z mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag4Errreal4magError in extended source Z mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
zAperMag6real4magExtended source Z mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
zAperMag6Errreal4magError in extended source Z mag (5.7 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
zErrBitsint4 processing warning/error bitwise flags in Z-99999999CODE_MISC
zDeblendint4 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
zppErrBitsint4 additional WFAU post-processing error bits in Z-99999999CODE_MISC
zSeqNumint4 the running number of the Z detection-99999999ID_NUMBER
zObjIDbigint8 the UID 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
yHallMagreal4magPoint source Y mag-0.9999995e9PHOT_MAG
yHallMagErrreal4magError in point source Y mag-0.9999995e9ERROR
yPetroMagreal4magExtended source Y mag (Petrosian)-0.9999995e9PHOT_MAG
yPetroMagErrreal4magError in extended source Y mag (Petrosian)-0.9999995e9ERROR
yPsfMagreal4magPoint source profile-fitted Y mag-0.9999995e9PHOT_MAG
yPsfMagErrreal4magError in point source profile-fitted Y mag-0.9999995e9ERROR
ySerMag2Dreal4magExtended source Y mag (profile-fitted)-0.9999995e9PHOT_MAG
ySerMag2DErrreal4magError in extended source Y mag (profile-fitted)-0.9999995e9ERROR
yAperMag3real4magExtended source Y mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
yAperMag3Errreal4magError in extended source Y mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
yAperMag4real4magExtended source Y mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
yAperMag4Errreal4magError in extended source Y mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
yAperMag6real4magExtended source Y mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
yAperMag6Errreal4magError in extended source Y mag (5.7 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
yErrBitsint4 processing warning/error bitwise flags in Y-99999999CODE_MISC
yDeblendint4 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
yppErrBitsint4 additional WFAU post-processing error bits in Y-99999999CODE_MISC
ySeqNumint4 the running number of the Y detection-99999999ID_NUMBER
yObjIDbigint8 the UID 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
jHallMagreal4magPoint source J mag-0.9999995e9PHOT_MAG
jHallMagErrreal4magError in point source J mag-0.9999995e9ERROR
jPetroMagreal4magExtended source J mag (Petrosian)-0.9999995e9PHOT_MAG
jPetroMagErrreal4magError in extended source J mag (Petrosian)-0.9999995e9ERROR
jPsfMagreal4magPoint source profile-fitted J mag-0.9999995e9PHOT_MAG
jPsfMagErrreal4magError in point source profile-fitted J mag-0.9999995e9ERROR
jSerMag2Dreal4magExtended source J mag (profile-fitted)-0.9999995e9PHOT_MAG
jSerMag2DErrreal4magError in extended source J mag (profile-fitted)-0.9999995e9ERROR
jAperMag3real4magExtended source J mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag3Errreal4magError in extended source J mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
jAperMag4real4magExtended source J mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag4Errreal4magError in extended source J mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
jAperMag6real4magExtended source J mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag6Errreal4magError in extended source J mag (5.7 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
jErrBitsint4 processing warning/error bitwise flags in J-99999999CODE_MISC
jDeblendint4 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
jppErrBitsint4 additional WFAU post-processing error bits in J-99999999CODE_MISC
jSeqNumint4 the running number of the J detection-99999999ID_NUMBER
jObjIDbigint8 the UID 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
hHallMagreal4magPoint source H mag-0.9999995e9PHOT_MAG
hHallMagErrreal4magError in point source H mag-0.9999995e9ERROR
hPetroMagreal4magExtended source H mag (Petrosian)-0.9999995e9PHOT_MAG
hPetroMagErrreal4magError in extended source H mag (Petrosian)-0.9999995e9ERROR
hPsfMagreal4magPoint source profile-fitted H mag-0.9999995e9PHOT_MAG
hPsfMagErrreal4magError in point source profile-fitted H mag-0.9999995e9ERROR
hSerMag2Dreal4magExtended source H mag (profile-fitted)-0.9999995e9PHOT_MAG
hSerMag2DErrreal4magError in extended source H mag (profile-fitted)-0.9999995e9ERROR
hAperMag3real4magExtended source H mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag3Errreal4magError in extended source H mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
hAperMag4real4magExtended source H mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag4Errreal4magError in extended source H mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
hAperMag6real4magExtended source H mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
hAperMag6Errreal4magError in extended source H mag (5.7 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
hErrBitsint4 processing warning/error bitwise flags in H-99999999CODE_MISC
hDeblendint4 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
hppErrBitsint4 additional WFAU post-processing error bits in H-99999999CODE_MISC
hSeqNumint4 the running number of the H detection-99999999ID_NUMBER
hObjIDbigint8 the UID 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
kHallMagreal4magPoint source K mag-0.9999995e9PHOT_MAG
kHallMagErrreal4magError in point source K mag-0.9999995e9ERROR
kPetroMagreal4magExtended source K mag (Petrosian)-0.9999995e9PHOT_MAG
kPetroMagErrreal4magError in extended source K mag (Petrosian)-0.9999995e9ERROR
kPsfMagreal4magPoint source profile-fitted K mag-0.9999995e9PHOT_MAG
kPsfMagErrreal4magError in point source profile-fitted K mag-0.9999995e9ERROR
kSerMag2Dreal4magExtended source K mag (profile-fitted)-0.9999995e9PHOT_MAG
kSerMag2DErrreal4magError in extended source K mag (profile-fitted)-0.9999995e9ERROR
kAperMag3real4magExtended source K mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag3Errreal4magError in extended source K mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag4real4magExtended source K mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag4Errreal4magError in extended source K mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
kAperMag6real4magExtended source K mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
kAperMag6Errreal4magError in extended source K mag (5.7 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
kErrBitsint4 processing warning/error bitwise flags in K-99999999CODE_MISC
kDeblendint4 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
kppErrBitsint4 additional WFAU post-processing error bits in K-99999999CODE_MISC
kSeqNumint4 the running number of the K detection-99999999ID_NUMBER
kObjIDbigint8 the UID 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
h2HallMagreal4magPoint source H2 mag-0.9999995e9PHOT_MAG
h2HallMagErrreal4magError in point source H2 mag-0.9999995e9ERROR
h2PetroMagreal4magExtended source H2 mag (Petrosian)-0.9999995e9PHOT_MAG
h2PetroMagErrreal4magError in extended source H2 mag (Petrosian)-0.9999995e9ERROR
h2PsfMagreal4magPoint source profile-fitted H2 mag-0.9999995e9PHOT_MAG
h2PsfMagErrreal4magError in point source profile-fitted H2 mag-0.9999995e9ERROR
h2SerMag2Dreal4magExtended source H2 mag (profile-fitted)-0.9999995e9PHOT_MAG
h2SerMag2DErrreal4magError in extended source H2 mag (profile-fitted)-0.9999995e9ERROR
h2AperMag3real4magExtended source H2 mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag3Errreal4magError in extended source H2 mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag4real4magExtended source H2 mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag4Errreal4magError in extended source H2 mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
h2AperMag6real4magExtended source H2 mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
h2AperMag6Errreal4magError in extended source H2 mag (5.7 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
h2ErrBitsint4 processing warning/error bitwise flags in H2-99999999CODE_MISC
h2Deblendint4 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
h2ppErrBitsint4 additional WFAU post-processing error bits in H2-99999999CODE_MISC
h2SeqNumint4 the running number of the H2 detection-99999999ID_NUMBER
h2ObjIDbigint8 the UID 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
brHallMagreal4magPoint source Br mag-0.9999995e9PHOT_MAG
brHallMagErrreal4magError in point source Br mag-0.9999995e9ERROR
brPetroMagreal4magExtended source Br mag (Petrosian)-0.9999995e9PHOT_MAG
brPetroMagErrreal4magError in extended source Br mag (Petrosian)-0.9999995e9ERROR
brPsfMagreal4magPoint source profile-fitted Br mag-0.9999995e9PHOT_MAG
brPsfMagErrreal4magError in point source profile-fitted Br mag-0.9999995e9ERROR
brSerMag2Dreal4magExtended source Br mag (profile-fitted)-0.9999995e9PHOT_MAG
brSerMag2DErrreal4magError in extended source Br mag (profile-fitted)-0.9999995e9ERROR
brAperMag3real4magExtended source Br mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag3Errreal4magError in extended source Br mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag4real4magExtended source Br mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag4Errreal4magError in extended source Br mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
brAperMag6real4magExtended source Br mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
brAperMag6Errreal4magError in extended source Br mag (5.7 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
brErrBitsint4 processing warning/error bitwise flags in Br-99999999CODE_MISC
brDeblendint4 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
brppErrBitsint4 additional WFAU post-processing error bits in Br-99999999CODE_MISC
brSeqNumint4 the running number of the Br detection-99999999ID_NUMBER
brObjIDbigint8 the UID 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
Total length969