TABLE  gpsSource

Contains GPS merged sources from GPS detections in gpsDetection.

Prescription for the merging (from RequiredFilters) is: J,H,Kx2,H2.

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references gpsMergeLog(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
sigRareal4DegreesUncertainty in RA-0.9999995e9ERROR
sigDecreal4DegreesUncertainty in Dec-0.9999995e9ERROR
epochfloat8YearsEpoch of position measurement TIME_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-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
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
hmk_1Pnt link to glossaryreal4magPoint source colour H-K (using aperMag3)-0.9999995e9PHOT_COLOR
hmk_1PntErr link to glossaryreal4magError on point source colour H-K-0.9999995e9ERROR
h2mk_1Pnt link to glossaryreal4magPoint source colour H2-K (using aperMag3)-0.9999995e9PHOT_COLOR
h2mk_1PntErr link to glossaryreal4magError on point source colour H2-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
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
jAperMag3 tooltipreal4magDefault 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
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 S-Extractor classification statistic in J-0.9999995e9STAT_PROP
jppErrBitsint4 additional WFAU post-processing error bits in J0CODE_MISC
jSeqNumint4 the running number of the J detection-99999999ID_NUMBER
jObjID link to glossarybigint8 DEPRECATED (do not use)-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
hAperMag3 tooltipreal4magDefault 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
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 S-Extractor classification statistic in H-0.9999995e9STAT_PROP
hppErrBitsint4 additional WFAU post-processing error bits in H0CODE_MISC
hSeqNumint4 the running number of the H detection-99999999ID_NUMBER
hObjID link to glossarybigint8 DEPRECATED (do not use)-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
k_1AperMag1real4magExtended source 1st epoch K aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_1AperMag1Errreal4magError in extended source 1st epoch K mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
k_1AperMag3 tooltipreal4magDefault point/extended source 1st epoch K aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_1AperMag3Errreal4magError in default point/extended source 1st epoch K mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
k_1AperMag4real4magExtended source 1st epoch K aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_1AperMag4Errreal4magError in extended source 1st epoch K mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
k_1Gausigreal4pixelsRMS of axes of ellipse fit in 1st epoch K-0.9999995e9MORPH_PARAM
k_1Ellreal4 1-b/a, where a/b=semi-major/minor axes in 1st epoch K-0.9999995e9PHYS_ELLIPTICITY
k_1PAreal4Degreesellipse fit celestial orientation in 1st epoch K-0.9999995e9POS_POS-ANG
k_1ErrBits link to glossaryint4 processing warning/error bitwise flags in 1st epoch K-99999999CODE_MISC
k_1Deblendint4 placeholder flag indicating parent/child relation in 1st epoch K-99999999CODE_MISC
k_1Classsmallint2 discrete image classification flag in 1st epoch K-9999CLASS_MISC
k_1ClassStatreal4 S-Extractor classification statistic in 1st epoch K-0.9999995e9STAT_PROP
k_1ppErrBitsint4 additional WFAU post-processing error bits in 1st epoch K0CODE_MISC
k_1SeqNumint4 the running number of the 1st epoch K detection-99999999ID_NUMBER
k_1ObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
k_1Xi link to glossaryreal4arcsecOffset of 1st epoch K detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
k_1Eta link to glossaryreal4arcsecOffset of 1st epoch K detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
k_2AperMag1real4magExtended source 2nd epoch K aperture corrected mag (1.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_2AperMag1Errreal4magError in extended source 2nd epoch K mag (1.0 arcsec aperture diameter)-0.9999995e9ERROR
k_2AperMag3 tooltipreal4magDefault point/extended source 2nd epoch K aperture corrected mag (2.0 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_2AperMag3Errreal4magError in default point/extended source 2nd epoch K mag (2.0 arcsec aperture diameter)-0.9999995e9ERROR
k_2AperMag4real4magExtended source 2nd epoch K aperture corrected mag (2.8 arcsec aperture diameter)-0.9999995e9PHOT_MAG
k_2AperMag4Errreal4magError in extended source 2nd epoch K mag (2.8 arcsec aperture diameter)-0.9999995e9ERROR
k_2Gausigreal4pixelsRMS of axes of ellipse fit in 2nd epoch K-0.9999995e9MORPH_PARAM
k_2Ellreal4 1-b/a, where a/b=semi-major/minor axes in 2nd epoch K-0.9999995e9PHYS_ELLIPTICITY
k_2PAreal4Degreesellipse fit celestial orientation in 2nd epoch K-0.9999995e9POS_POS-ANG
k_2ErrBits link to glossaryint4 processing warning/error bitwise flags in 2nd epoch K-99999999CODE_MISC
k_2Deblendint4 placeholder flag indicating parent/child relation in 2nd epoch K-99999999CODE_MISC
k_2Classsmallint2 discrete image classification flag in 2nd epoch K-9999CLASS_MISC
k_2ClassStatreal4 S-Extractor classification statistic in 2nd epoch K-0.9999995e9STAT_PROP
k_2ppErrBitsint4 additional WFAU post-processing error bits in 2nd epoch K0CODE_MISC
k_2SeqNumint4 the running number of the 2nd epoch K detection-99999999ID_NUMBER
k_2ObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
k_2Xi link to glossaryreal4arcsecOffset of 2nd epoch K detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
k_2Eta link to glossaryreal4arcsecOffset of 2nd epoch 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
h2AperMag3 tooltipreal4magDefault 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
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 S-Extractor classification statistic in H2-0.9999995e9STAT_PROP
h2ppErrBitsint4 additional WFAU post-processing error bits in H20CODE_MISC
h2SeqNumint4 the running number of the H2 detection-99999999ID_NUMBER
h2ObjID link to glossarybigint8 DEPRECATED (do not use)-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
Total length561