TABLE  calSourceRemeasurement

Contains source remeasurements based on the merged source list for the CAL.


Required constraints:
  • Primary key is (sourceID)
  • (sourceID) references calSource(sourceID)n
  • (frameSetID) references calMergeLog(frameSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 UID (unique over entire WSA via programme ID prefix) of this list remeasurement ID_MAIN
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
frameSetIDbigint8 UID of the set of frames that this remeasured 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-0.9999995e9TIME_EPOCH
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) CODE_MISC
zmyreal4magDefault colour Z-Y (using appropriate mags) PHOT_COLOR
zmyErrreal4magError on colour Z-Y ERROR
ymjreal4magDefault colour Y-J (using appropriate mags) PHOT_COLOR
ymjErrreal4magError on colour Y-J ERROR
jmhreal4magDefault colour J-H (using appropriate mags) PHOT_COLOR
jmhErrreal4magError on colour J-H ERROR
hmkreal4magDefault colour H-K (using appropriate mags) PHOT_COLOR
hmkErrreal4magError on colour H-K ERROR
mergedClasssmallint2 Class flag based on list remeasurement prescription CODE_MISC
zMagreal4magZ mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
zMagErrreal4magError in Z mag-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 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
zppErrBitsint4 additional WFAU post-processing error bits in Z0CODE_MISC
zSeqNumint4 the running number of the Z remeasurement-99999999ID_NUMBER
zObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
yMagreal4magY mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
yMagErrreal4magError in Y mag-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 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
yppErrBitsint4 additional WFAU post-processing error bits in Y0CODE_MISC
ySeqNumint4 the running number of the Y remeasurement-99999999ID_NUMBER
yObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
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 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
jppErrBitsint4 additional WFAU post-processing error bits in J0CODE_MISC
jSeqNumint4 the running number of the J remeasurement-99999999ID_NUMBER
jObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
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 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
hppErrBitsint4 additional WFAU post-processing error bits in H0CODE_MISC
hSeqNumint4 the running number of the H remeasurement-99999999ID_NUMBER
hObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
kMagreal4magK mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
kMagErrreal4magError in K mag-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 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
kppErrBitsint4 additional WFAU post-processing error bits in K0CODE_MISC
kSeqNumint4 the running number of the K remeasurement-99999999ID_NUMBER
kObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
h2Magreal4magH2 mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
h2MagErrreal4magError in H2 mag-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 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
h2ppErrBitsint4 additional WFAU post-processing error bits in H20CODE_MISC
h2SeqNumint4 the running number of the H2 remeasurement-99999999ID_NUMBER
h2ObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
brMagreal4magBr mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
brMagErrreal4magError in Br mag-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 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
brppErrBitsint4 additional WFAU post-processing error bits in Br0CODE_MISC
brSeqNumint4 the running number of the Br remeasurement-99999999ID_NUMBER
brObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
nbjMagreal4magNbj mag (as appropriate for this merged source)-0.9999995e9PHOT_MAG
nbjMagErrreal4magError in Nbj mag-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
nbjErrBitsint4 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
nbjppErrBitsint4 additional WFAU post-processing error bits in Nbj0CODE_MISC
nbjSeqNumint4 the running number of the Nbj remeasurement-99999999ID_NUMBER
nbjObjID link to glossarybigint8 DEPRECATED (do not use)-99999999ID_NUMBER
Total length558