TABLE  uhsSource

Contains merged sources from detections in uhsDetection.

Prescription for the merging (from RequiredFilters) is: J
Bandpass J comes from single epoch OB J stack frame measurements.

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references uhsMergeLog(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
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
priOrSec link to glossarybigint8 Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).-99999999CODE_MISC
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
eBVreal4 The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1)-0.9999995e9 
aJreal4magThe galactic extinction correction in the J band for extragalactic objects-0.9999995e9 
jHallMagreal4magTotal point source J mag-0.9999995e9PHOT_MAG
jHallMagErrreal4magError in total 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
jAperMag3 tooltipreal4magDefault point source J aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag3Errreal4magError in default point source J mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
jAperMag4real4magPoint source J aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag4Errreal4magError in point source J mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
jAperMag6real4magPoint source J aperture corrected mag (5.7 arcsec aperture diameter)-0.9999995e9PHOT_MAG
jAperMag6Errreal4magError in point 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
jErrBits link to glossaryint4 processing warning/error bitwise flags in J-99999999CODE_MISC
jDeblend link to glossaryint4 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
Total length236