TABLE PhotoAuxAll

The extra columns that didn't make it into the PhotoObjAll table.

These are added as a separate table because adding columns to the very large PhotoObjAll table is prohibitively expensive unless the table is reloaded from scratch. In a future release, these columns will be added to the PhotoObjAll table. In the meantime, to access these columns, you may join with the PhotoObjAll table on the objid:
SELECT p.objid, p.ra, q.raErr, p.dec, q.decErr
FROM PhotoObjAll p, PhotoAuxAll q
WHERE p.objid = q.objid Similarly you may join the PhotoObj and PhotoAux views.

name type length unit ucd description

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

mode tinyint 1 CLASS_OBJECT 1: primary, 2: secondary, 3: family object.

l float 8 deg POS_GAL_LAT Galactic latitude

b float 8 deg POS_GAL_LON Galactic longitude

raErr float 8 arcsec POS_EQ_RA_ERR Error in RA

decErr float 8 arcsec POS_EQ_DEC_ERR Error in dec

raDecCorr float 8 CODE_MISC RA/dec correlation

name	type	length	unit	ucd	description
objID	bigint	8		ID_MAIN	Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
mode	tinyint	1		CLASS_OBJECT	1: primary, 2: secondary, 3: family object.
l	float	8	deg	POS_GAL_LAT	Galactic latitude
b	float	8	deg	POS_GAL_LON	Galactic longitude
raErr	float	8	arcsec	POS_EQ_RA_ERR	Error in RA
decErr	float	8	arcsec	POS_EQ_DEC_ERR	Error in dec
raDecCorr	float	8		CODE_MISC	RA/dec correlation