TABLE  UberCal

The ubercal corrections and corrected magnitudes for PhotoObjAll.

Please see the UberCalibration entry in Algorithms for more information about the uber-calibration corrections. Note that if the NO_UBERCAL flag is set in the calibStatus, then the coversion factor is 0 and the magnitude is identical to that in PhotoObjAll. See also functions fUberCalMag and fUberCalibStatus. A sample join between PhotoObjAll and UberCal is as follows:
select top 10 u.modelMag_r as urmag,p.modelMag_r as prmag
from PhotoObjAll p, UberCal u
where p.objID=u.objID AND u.calibStatus_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
psfMag_ureal4magPHOT_SDSS_Ucorrected PSF flux
psfMag_greal4magPHOT_SDSS_Gcorrected PSF flux
psfMag_rreal4magPHOT_SDSS_Rcorrected PSF flux
psfMag_ireal4magPHOT_SDSS_Icorrected PSF flux
psfMag_zreal4magPHOT_SDSS_Zcorrected PSF flux
petroMag_ureal4magPHOT_SDSS_Ucorrected Petrosian flux
petroMag_greal4magPHOT_SDSS_Gcorrected Petrosian flux
petroMag_rreal4magPHOT_SDSS_Rcorrected Petrosian flux
petroMag_ireal4magPHOT_SDSS_Icorrected Petrosian flux
petroMag_zreal4magPHOT_SDSS_Zcorrected Petrosian flux
modelMag_ureal4magPHOT_SDSS_U FIT_PARAMcorrected better of DeV/Exp magnitude fit
modelMag_greal4magPHOT_SDSS_G FIT_PARAMcorrected better of DeV/Exp magnitude fit
modelMag_rreal4magPHOT_SDSS_R FIT_PARAMcorrected better of DeV/Exp magnitude fit
modelMag_ireal4magPHOT_SDSS_I FIT_PARAMcorrected better of DeV/Exp magnitude fit
modelMag_zreal4magPHOT_SDSS_Z FIT_PARAMcorrected better of DeV/Exp magnitude fit
calibStatus_uLink to UberCalibStatussmallint2 CODE_MISCstatus of calibration
calibStatus_gLink to UberCalibStatussmallint2 CODE_MISCstatus of calibration
calibStatus_rLink to UberCalibStatussmallint2 CODE_MISCstatus of calibration
calibStatus_iLink to UberCalibStatussmallint2 CODE_MISCstatus of calibration
calibStatus_zLink to UberCalibStatussmallint2 CODE_MISCstatus of calibration