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

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

run int 4 OBS_RUN Run number

rerun smallint 2 CODE_MISC Rerun number

camcol tinyint 1 INST_ID Camera column

field smallint 2 ID_FIELD Field number

obj smallint 2 ID_NUMBER The object id within a field. Usually changes between reruns of the same field.

conv_status_u int 4 CODE_MISC status of calibration

conv_status_g int 4 CODE_MISC status of calibration

conv_status_r int 4 CODE_MISC status of calibration

conv_status_i int 4 CODE_MISC status of calibration

conv_status_z int 4 CODE_MISC status of calibration

ra float 8 deg POS_EQ_RA_MAIN J2000 right ascension (r')

dec float 8 deg POS_EQ_DEC_MAIN J2000 declination (r')

cx float 8 POS_EQ_CART_X unit vector for ra+dec

cy float 8 POS_EQ_CART_Y unit vector for ra+dec

cz float 8 POS_EQ_CART_Z unit vector for ra+dec

l float 8 deg POS_GAL_LAT Galactic longitude

b float 8 deg POS_GAL_LON Galactic latitude

offsetRa_u real 4 arcsec POS_OFFSET filter position ra minus final ra (* cos(dec))

offsetRa_g real 4 arcsec POS_OFFSET filter position ra minus final ra (* cos(dec))

offsetRa_r real 4 arcsec POS_OFFSET filter position ra minus final ra (* cos(dec))

offsetRa_i real 4 arcsec POS_OFFSET filter position ra minus final ra (* cos(dec))

offsetRa_z real 4 arcsec POS_OFFSET filter position ra minus final ra (* cos(dec))

offsetDec_u real 4 arcsec POS_OFFSET filter position dec minus final dec

offsetDec_g real 4 arcsec POS_OFFSET filter position dec minus final dec

offsetDec_r real 4 arcsec POS_OFFSET filter position dec minus final dec

offsetDec_i real 4 arcsec POS_OFFSET filter position dec minus final dec

offsetDec_z real 4 arcsec POS_OFFSET filter position dec minus final dec

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
run	int	4		OBS_RUN	Run number
rerun	smallint	2		CODE_MISC	Rerun number
camcol	tinyint	1		INST_ID	Camera column
field	smallint	2		ID_FIELD	Field number
obj	smallint	2		ID_NUMBER	The object id within a field. Usually changes between reruns of the same field.
conv_status_u	int	4		CODE_MISC	status of calibration
conv_status_g	int	4		CODE_MISC	status of calibration
conv_status_r	int	4		CODE_MISC	status of calibration
conv_status_i	int	4		CODE_MISC	status of calibration
conv_status_z	int	4		CODE_MISC	status of calibration
ra	float	8	deg	POS_EQ_RA_MAIN	J2000 right ascension (r')
dec	float	8	deg	POS_EQ_DEC_MAIN	J2000 declination (r')
cx	float	8		POS_EQ_CART_X	unit vector for ra+dec
cy	float	8		POS_EQ_CART_Y	unit vector for ra+dec
cz	float	8		POS_EQ_CART_Z	unit vector for ra+dec
l	float	8	deg	POS_GAL_LAT	Galactic longitude
b	float	8	deg	POS_GAL_LON	Galactic latitude
offsetRa_u	real	4	arcsec	POS_OFFSET	filter position ra minus final ra (* cos(dec))
offsetRa_g	real	4	arcsec	POS_OFFSET	filter position ra minus final ra (* cos(dec))
offsetRa_r	real	4	arcsec	POS_OFFSET	filter position ra minus final ra (* cos(dec))
offsetRa_i	real	4	arcsec	POS_OFFSET	filter position ra minus final ra (* cos(dec))
offsetRa_z	real	4	arcsec	POS_OFFSET	filter position ra minus final ra (* cos(dec))
offsetDec_u	real	4	arcsec	POS_OFFSET	filter position dec minus final dec
offsetDec_g	real	4	arcsec	POS_OFFSET	filter position dec minus final dec
offsetDec_r	real	4	arcsec	POS_OFFSET	filter position dec minus final dec
offsetDec_i	real	4	arcsec	POS_OFFSET	filter position dec minus final dec
offsetDec_z	real	4	arcsec	POS_OFFSET	filter position dec minus final dec