TABLE  UberAstro

The ubercal corrections and corrected astrometry for PhotoObjAll.

Please see the UberCalibration entry in Algorithms for more information about the uber-calibration corrections. A sample join between PhotoObjAll and UberAstro is as follows:
select top 10 p.modelMag_r,p.modelMag_r, p.ra. p.[dec]
from PhotoObjAll p join UberAstro u on u.objid=p.objid
where u.conv_status_r & dbo.fUberCalibStatus('PHOTOMETRIC') > 0

nametypelengthunitucddescription
objIDbigint8 ID_MAINUnique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
conv_ureal4 CODE_MISCThe ubercal correction to add to the u-band magnitude
conv_greal4 CODE_MISCThe ubercal correction to add to the g-band magnitude
conv_rreal4 CODE_MISCThe ubercal correction to add to the r-band magnitude
conv_ireal4 CODE_MISCThe ubercal correction to add to the i-band magnitude
conv_zreal4 CODE_MISCThe ubercal correction to add to the z-band magnitude
runint4 OBS_RUNRun number
rerunsmallint2 CODE_MISCRerun number
camcoltinyint1 INST_IDCamera column
fieldsmallint2 ID_FIELDField number
objsmallint2 ID_NUMBERThe object id within a field. Usually changes between reruns of the same field.
conv_status_uLink to UberCalibStatusint4 CODE_MISCstatus of calibration
conv_status_gLink to UberCalibStatusint4 CODE_MISCstatus of calibration
conv_status_rLink to UberCalibStatusint4 CODE_MISCstatus of calibration
conv_status_iLink to UberCalibStatusint4 CODE_MISCstatus of calibration
conv_status_zLink to UberCalibStatusint4 CODE_MISCstatus of calibration
rafloat8degPOS_EQ_RA_MAINJ2000 right ascension (r')
decfloat8degPOS_EQ_DEC_MAINJ2000 declination (r')
cxfloat8 POS_EQ_CART_Xunit vector for ra+dec
cyfloat8 POS_EQ_CART_Yunit vector for ra+dec
czfloat8 POS_EQ_CART_Zunit vector for ra+dec
lfloat8degPOS_GAL_LATGalactic longitude
bfloat8degPOS_GAL_LONGalactic latitude
offsetRa_ureal4arcsecPOS_OFFSETfilter position ra minus final ra (* cos(dec))
offsetRa_greal4arcsecPOS_OFFSETfilter position ra minus final ra (* cos(dec))
offsetRa_rreal4arcsecPOS_OFFSETfilter position ra minus final ra (* cos(dec))
offsetRa_ireal4arcsecPOS_OFFSETfilter position ra minus final ra (* cos(dec))
offsetRa_zreal4arcsecPOS_OFFSETfilter position ra minus final ra (* cos(dec))
offsetDec_ureal4arcsecPOS_OFFSETfilter position dec minus final dec
offsetDec_greal4arcsecPOS_OFFSETfilter position dec minus final dec
offsetDec_rreal4arcsecPOS_OFFSETfilter position dec minus final dec
offsetDec_ireal4arcsecPOS_OFFSETfilter position dec minus final dec
offsetDec_zreal4arcsecPOS_OFFSETfilter position dec minus final dec