TABLE OrigPhotoObjAll

Contains the original photometry and astrometry from the PhotoObjAll table.

This table contains a copy of original selected magnitudes and astrometry from PhotoObjAll to save them before updating with the UberCal photometry and astrom rerun for DR7.

name type length unit ucd description

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

run smallint 2 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.

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

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

dec float 8 deg POS_EQ_DEC_MAIN J2000 declination (r')

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

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

psfmag_u real 4 mag PHOT_SDSS_U PSF flux

psfmag_g real 4 mag PHOT_SDSS_G PSF flux

psfmag_r real 4 mag PHOT_SDSS_R PSF flux

psfmag_i real 4 mag PHOT_SDSS_I PSF flux

psfmag_z real 4 mag PHOT_SDSS_Z PSF flux

psfmagerr_u real 4 mag PHOT_SDSS_U ERROR PSF flux error

psfmagerr_g real 4 mag PHOT_SDSS_G ERROR PSF flux error

psfmagerr_r real 4 mag PHOT_SDSS_R ERROR PSF flux error

psfmagerr_i real 4 mag PHOT_SDSS_I ERROR PSF flux error

psfmagerr_z real 4 mag PHOT_SDSS_Z ERROR PSF flux error

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

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

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

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

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

modelmagerr_u real 4 mag PHOT_SDSS_U ERROR better of DeV/Exp magnitude fit error

modelmagerr_g real 4 mag PHOT_SDSS_G ERROR better of DeV/Exp magnitude fit error

modelmagerr_r real 4 mag PHOT_SDSS_R ERROR better of DeV/Exp magnitude fit error

modelmagerr_i real 4 mag PHOT_SDSS_I ERROR better of DeV/Exp magnitude fit error

modelmagerr_z real 4 mag PHOT_SDSS_Z ERROR better of DeV/Exp magnitude fit error

name	type	length	unit	ucd	description
objid	bigint	8		ID_MAIN	Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
run	smallint	2		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.
mode	tinyint	1		CLASS_OBJECT	1: primary, 2: secondary, 3: family object.
ra	float	8	deg	POS_EQ_RA_MAIN	J2000 right ascension (r')
dec	float	8	deg	POS_EQ_DEC_MAIN	J2000 declination (r')
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
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
psfmag_u	real	4	mag	PHOT_SDSS_U	PSF flux
psfmag_g	real	4	mag	PHOT_SDSS_G	PSF flux
psfmag_r	real	4	mag	PHOT_SDSS_R	PSF flux
psfmag_i	real	4	mag	PHOT_SDSS_I	PSF flux
psfmag_z	real	4	mag	PHOT_SDSS_Z	PSF flux
psfmagerr_u	real	4	mag	PHOT_SDSS_U ERROR	PSF flux error
psfmagerr_g	real	4	mag	PHOT_SDSS_G ERROR	PSF flux error
psfmagerr_r	real	4	mag	PHOT_SDSS_R ERROR	PSF flux error
psfmagerr_i	real	4	mag	PHOT_SDSS_I ERROR	PSF flux error
psfmagerr_z	real	4	mag	PHOT_SDSS_Z ERROR	PSF flux error
modelmag_u	real	4	mag	PHOT_SDSS_U FIT_PARAM	better of DeV/Exp magnitude fit
modelmag_g	real	4	mag	PHOT_SDSS_G FIT_PARAM	better of DeV/Exp magnitude fit
modelmag_r	real	4	mag	PHOT_SDSS_R FIT_PARAM	better of DeV/Exp magnitude fit
modelmag_i	real	4	mag	PHOT_SDSS_I FIT_PARAM	better of DeV/Exp magnitude fit
modelmag_z	real	4	mag	PHOT_SDSS_Z FIT_PARAM	better of DeV/Exp magnitude fit
modelmagerr_u	real	4	mag	PHOT_SDSS_U ERROR	better of DeV/Exp magnitude fit error
modelmagerr_g	real	4	mag	PHOT_SDSS_G ERROR	better of DeV/Exp magnitude fit error
modelmagerr_r	real	4	mag	PHOT_SDSS_R ERROR	better of DeV/Exp magnitude fit error
modelmagerr_i	real	4	mag	PHOT_SDSS_I ERROR	better of DeV/Exp magnitude fit error
modelmagerr_z	real	4	mag	PHOT_SDSS_Z ERROR	better of DeV/Exp magnitude fit error