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

name type length unit ucd description

objID bigint 8 ID_MAIN Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].

conv_u real 4 CODE_MISC The ubercal correction to add to the u-band magnitude

conv_g real 4 CODE_MISC The ubercal correction to add to the g-band magnitude

conv_r real 4 CODE_MISC The ubercal correction to add to the r-band magnitude

conv_i real 4 CODE_MISC The ubercal correction to add to the i-band magnitude

conv_z real 4 CODE_MISC The ubercal correction to add to the z-band magnitude

psfMag_u real 4 mag PHOT_SDSS_U corrected PSF flux

psfMag_g real 4 mag PHOT_SDSS_G corrected PSF flux

psfMag_r real 4 mag PHOT_SDSS_R corrected PSF flux

psfMag_i real 4 mag PHOT_SDSS_I corrected PSF flux

psfMag_z real 4 mag PHOT_SDSS_Z corrected PSF flux

petroMag_u real 4 mag PHOT_SDSS_U corrected Petrosian flux

petroMag_g real 4 mag PHOT_SDSS_G corrected Petrosian flux

petroMag_r real 4 mag PHOT_SDSS_R corrected Petrosian flux

petroMag_i real 4 mag PHOT_SDSS_I corrected Petrosian flux

petroMag_z real 4 mag PHOT_SDSS_Z corrected Petrosian flux

modelMag_u real 4 mag PHOT_SDSS_U FIT_PARAM corrected better of DeV/Exp magnitude fit

modelMag_g real 4 mag PHOT_SDSS_G FIT_PARAM corrected better of DeV/Exp magnitude fit

modelMag_r real 4 mag PHOT_SDSS_R FIT_PARAM corrected better of DeV/Exp magnitude fit

modelMag_i real 4 mag PHOT_SDSS_I FIT_PARAM corrected better of DeV/Exp magnitude fit

modelMag_z real 4 mag PHOT_SDSS_Z FIT_PARAM corrected better of DeV/Exp magnitude fit

calibStatus_u smallint 2 CODE_MISC status of calibration

calibStatus_g smallint 2 CODE_MISC status of calibration

calibStatus_r smallint 2 CODE_MISC status of calibration

calibStatus_i smallint 2 CODE_MISC status of calibration

calibStatus_z smallint 2 CODE_MISC status of calibration

name	type	length	unit	ucd	description
objID	bigint	8		ID_MAIN	Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
conv_u	real	4		CODE_MISC	The ubercal correction to add to the u-band magnitude
conv_g	real	4		CODE_MISC	The ubercal correction to add to the g-band magnitude
conv_r	real	4		CODE_MISC	The ubercal correction to add to the r-band magnitude
conv_i	real	4		CODE_MISC	The ubercal correction to add to the i-band magnitude
conv_z	real	4		CODE_MISC	The ubercal correction to add to the z-band magnitude
psfMag_u	real	4	mag	PHOT_SDSS_U	corrected PSF flux
psfMag_g	real	4	mag	PHOT_SDSS_G	corrected PSF flux
psfMag_r	real	4	mag	PHOT_SDSS_R	corrected PSF flux
psfMag_i	real	4	mag	PHOT_SDSS_I	corrected PSF flux
psfMag_z	real	4	mag	PHOT_SDSS_Z	corrected PSF flux
petroMag_u	real	4	mag	PHOT_SDSS_U	corrected Petrosian flux
petroMag_g	real	4	mag	PHOT_SDSS_G	corrected Petrosian flux
petroMag_r	real	4	mag	PHOT_SDSS_R	corrected Petrosian flux
petroMag_i	real	4	mag	PHOT_SDSS_I	corrected Petrosian flux
petroMag_z	real	4	mag	PHOT_SDSS_Z	corrected Petrosian flux
modelMag_u	real	4	mag	PHOT_SDSS_U FIT_PARAM	corrected better of DeV/Exp magnitude fit
modelMag_g	real	4	mag	PHOT_SDSS_G FIT_PARAM	corrected better of DeV/Exp magnitude fit
modelMag_r	real	4	mag	PHOT_SDSS_R FIT_PARAM	corrected better of DeV/Exp magnitude fit
modelMag_i	real	4	mag	PHOT_SDSS_I FIT_PARAM	corrected better of DeV/Exp magnitude fit
modelMag_z	real	4	mag	PHOT_SDSS_Z FIT_PARAM	corrected better of DeV/Exp magnitude fit
calibStatus_u	smallint	2		CODE_MISC	status of calibration
calibStatus_g	smallint	2		CODE_MISC	status of calibration
calibStatus_r	smallint	2		CODE_MISC	status of calibration
calibStatus_i	smallint	2		CODE_MISC	status of calibration
calibStatus_z	smallint	2		CODE_MISC	status of calibration