TABLE  gpsSource

Contains GPS merged sources from GPS detections in gpsDetection.

Prescription for the merging (from RequiredFilters) is: J,H,Kx3,H2x3.

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
frameSetIDbigint8 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
priOrSecbigint8 Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).-99999999CODE_MISC
jmhreal4magDefault colour J-H (using appropriate mags)-0.9999995e9PHOT_COLOR
jmhErrreal4magError on colour J-H-0.9999995e9ERROR
hmk_1real4magDefault colour H-K (using appropriate mags)-0.9999995e9PHOT_COLOR
hmk_1Errreal4magError on colour H-K-0.9999995e9ERROR
h2_1mk_1real4magDefault colour H2-K (using appropriate mags)-0.9999995e9PHOT_COLOR
h2_1mk_1Errreal4magError on colour H2-K-0.9999995e9ERROR
mergedClasssmallint2 Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) CODE_MISC
pStarreal4 Probability that the source is a star STAT_PROP
pGalaxyreal4 Probability that the source is a galaxy STAT_PROP
pNoisereal4 Probability that the source is noise STAT_PROP
pSaturatedreal4 Probability that the source is saturated STAT_PROP
jMagreal4magJ mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
jMagErrreal4magError in J mag-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
jXireal4arcsecOffset of J detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
jEtareal4arcsecOffset of J detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
hMagreal4magH mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
hMagErrreal4magError in H mag-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
hXireal4arcsecOffset of H detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
hEtareal4arcsecOffset of H detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
k_1Magreal4mag1st epoch K mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
k_1MagErrreal4magError in 1st epoch K mag-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_1ErrBitsint4 processing warning/error bitwise flags in 1st epoch K-99999999CODE_MISC
k_1Deblendint4 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 N(0,1) stellarness-of-profile statistic in 1st epoch K-0.9999995e9STAT_PROP
k_1ppErrBitsint4 additional WFAU post-processing error bits in 1st epoch K-99999999CODE_MISC
k_1SeqNumint4 the running number of the K1 detection-99999999ID_NUMBER
k_1ObjIDbigint8 the UID of the K1 detection-99999999ID_NUMBER
k_1Xireal4arcsecOffset of K1 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
k_1Etareal4arcsecOffset of K1 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
k_2Magreal4mag2nd epoch K mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
k_2MagErrreal4magError in 2nd epoch K mag-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_2ErrBitsint4 processing warning/error bitwise flags in 2nd epoch K-99999999CODE_MISC
k_2Deblendint4 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 N(0,1) stellarness-of-profile statistic in 2nd epoch K-0.9999995e9STAT_PROP
k_2ppErrBitsint4 additional WFAU post-processing error bits in 2nd epoch K-99999999CODE_MISC
k_2SeqNumint4 the running number of the K2 detection-99999999ID_NUMBER
k_2ObjIDbigint8 the UID of the K2 detection-99999999ID_NUMBER
k_2Xireal4arcsecOffset of K2 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
k_2Etareal4arcsecOffset of K2 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
k_3Magreal4mag3rd epoch K mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
k_3MagErrreal4magError in 3rd epoch K mag-0.9999995e9ERROR
k_3Gausigreal4pixelsRMS of axes of ellipse fit in 3rd epoch K-0.9999995e9MORPH_PARAM
k_3Ellreal4 1-b/a, where a/b=semi-major/minor axes in 3rd epoch K-0.9999995e9PHYS_ELLIPTICITY
k_3PAreal4Degreesellipse fit celestial orientation in 3rd epoch K-0.9999995e9POS_POS-ANG
k_3ErrBitsint4 processing warning/error bitwise flags in 3rd epoch K-99999999CODE_MISC
k_3Deblendint4 flag indicating parent/child relation in 3rd epoch K-99999999CODE_MISC
k_3Classsmallint2 discrete image classification flag in 3rd epoch K-9999CLASS_MISC
k_3ClassStatreal4 N(0,1) stellarness-of-profile statistic in 3rd epoch K-0.9999995e9STAT_PROP
k_3ppErrBitsint4 additional WFAU post-processing error bits in 3rd epoch K-99999999CODE_MISC
k_3SeqNumint4 the running number of the K3 detection-99999999ID_NUMBER
k_3ObjIDbigint8 the UID of the K3 detection-99999999ID_NUMBER
k_3Xireal4arcsecOffset of K3 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
k_3Etareal4arcsecOffset of K3 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
h2_1Magreal4mag1st epoch H2 mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
h2_1MagErrreal4magError in 1st epoch H2 mag-0.9999995e9ERROR
h2_1Gausigreal4pixelsRMS of axes of ellipse fit in 1st epoch H2-0.9999995e9MORPH_PARAM
h2_1Ellreal4 1-b/a, where a/b=semi-major/minor axes in 1st epoch H2-0.9999995e9PHYS_ELLIPTICITY
h2_1PAreal4Degreesellipse fit celestial orientation in 1st epoch H2-0.9999995e9POS_POS-ANG
h2_1ErrBitsint4 processing warning/error bitwise flags in 1st epoch H2-99999999CODE_MISC
h2_1Deblendint4 flag indicating parent/child relation in 1st epoch H2-99999999CODE_MISC
h2_1Classsmallint2 discrete image classification flag in 1st epoch H2-9999CLASS_MISC
h2_1ClassStatreal4 N(0,1) stellarness-of-profile statistic in 1st epoch H2-0.9999995e9STAT_PROP
h2_1ppErrBitsint4 additional WFAU post-processing error bits in 1st epoch H2-99999999CODE_MISC
h2_1SeqNumint4 the running number of the 1st H2 detection-99999999ID_NUMBER
h2_1ObjIDbigint8 the UID of the 1st H2 detection-99999999ID_NUMBER
h2_1Xireal4arcsecOffset of H2 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
h2_1Etareal4arcsecOffset of H2 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
h2_2Magreal4mag2nd epoch H2 mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
h2_2MagErrreal4magError in 2nd epoch H2 mag-0.9999995e9ERROR
h2_2Gausigreal4pixelsRMS of axes of ellipse fit in 2nd epoch H2-0.9999995e9MORPH_PARAM
h2_2Ellreal4 1-b/a, where a/b=semi-major/minor axes in 2nd epoch H2-0.9999995e9PHYS_ELLIPTICITY
h2_2PAreal4Degreesellipse fit celestial orientation in 2nd epoch H2-0.9999995e9POS_POS-ANG
h2_2ErrBitsint4 processing warning/error bitwise flags in 2nd epoch H2-99999999CODE_MISC
h2_2Deblendint4 flag indicating parent/child relation in 2nd epoch H2-99999999CODE_MISC
h2_2Classsmallint2 discrete image classification flag in 2nd epoch H2-9999CLASS_MISC
h2_2ClassStatreal4 N(0,1) stellarness-of-profile statistic in 2nd epoch H2-0.9999995e9STAT_PROP
h2_2ppErrBitsint4 additional WFAU post-processing error bits in 2nd epoch H2-99999999CODE_MISC
h2_2SeqNumint4 the running number of the 2nd H2 detection-99999999ID_NUMBER
h2_2ObjIDbigint8 the UID of the 2nd H2 detection-99999999ID_NUMBER
h2_2Xireal4arcsecOffset of H2 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
h2_2Etareal4arcsecOffset of H2 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
h2_3Magreal4mag3rd epoch H2 mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
h2_3MagErrreal4magError in 3rd epoch H2 mag-0.9999995e9ERROR
h2_3Gausigreal4pixelsRMS of axes of ellipse fit in 3rd epoch H2-0.9999995e9MORPH_PARAM
h2_3Ellreal4 1-b/a, where a/b=semi-major/minor axes in 3rd epoch H2-0.9999995e9PHYS_ELLIPTICITY
h2_3PAreal4Degreesellipse fit celestial orientation in 3rd epoch H2-0.9999995e9POS_POS-ANG
h2_3ErrBitsint4 processing warning/error bitwise flags in 3rd epoch H2-99999999CODE_MISC
h2_3Deblendint4 flag indicating parent/child relation in 3rd epoch H2-99999999CODE_MISC
h2_3Classsmallint2 discrete image classification flag in 3rd epoch H2-9999CLASS_MISC
h2_3ClassStatreal4 N(0,1) stellarness-of-profile statistic in 3rd epoch H2-0.9999995e9STAT_PROP
h2_3ppErrBitsint4 additional WFAU post-processing error bits in 3rd epoch H2-99999999CODE_MISC
h2_3SeqNumint4 the running number of the 3rd H2 detection-99999999ID_NUMBER
h2_3ObjIDbigint8 the UID of the 3rd H2 detection-99999999ID_NUMBER
h2_3Xireal4arcsecOffset of H2 detection from master position (+east/-west)-0.9999995e9POS_EQ_RA_OFF
h2_3Etareal4arcsecOffset of H2 detection from master position (+north/-south)-0.9999995e9POS_EQ_DEC_OFF
Total length647