TABLE  SpecDR7

This is a unique match between a DR8 SpecObjAll and a DR7 photoprimary within 1 arcsec. DR7 PhotoTag columns and relevant DR7 ProperMotions are also included for convenience.

name	type	length	unit	ucd	description
specObjID	bigint	8		ID_CATALOG	Unique DR8 ID based on PLATE, MJD, FIBERID, RUN2D
dr7ObjID	bigint	8		ID_MAIN	Unique DR7 PhotoPrimary ID composed from [skyVersion,rerun,run,camcol,field,obj].
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
skyVersion	tinyint	1		CODE_MISC	0 = OPDB target, 1 = OPDB best
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.
nChild	smallint	2		NUMBER	Number of children if this is a composite object that has been deblended. BRIGHT (in a flags sense) objects also have nchild == 1, the non-BRIGHT sibling.
type	smallint	2		CLASS_OBJECT	Morphological type classification of the object.
probPSF	real	4		STAT_PROBABILITY	Probability that the object is a star. Currently 0 if type == 3 (galaxy), 1 if type == 6 (star).
insideMask	tinyint	1		CODE_MISC	Flag to indicate whether object is inside a mask and why
flags	bigint	8		CODE_MISC	Photo Object Attribute Flags
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
petroMag_u	real	4	mag	PHOT_SDSS_U	Petrosian flux
petroMag_g	real	4	mag	PHOT_SDSS_G	Petrosian flux
petroMag_r	real	4	mag	PHOT_SDSS_R	Petrosian flux
petroMag_i	real	4	mag	PHOT_SDSS_I	Petrosian flux
petroMag_z	real	4	mag	PHOT_SDSS_Z	Petrosian flux
petroMagErr_u	real	4	mag	PHOT_SDSS_U ERROR	Petrosian flux error
petroMagErr_g	real	4	mag	PHOT_SDSS_G ERROR	Petrosian flux error
petroMagErr_r	real	4	mag	PHOT_SDSS_R ERROR	Petrosian flux error
petroMagErr_i	real	4	mag	PHOT_SDSS_I ERROR	Petrosian flux error
petroMagErr_z	real	4	mag	PHOT_SDSS_Z ERROR	Petrosian flux error
petroR50_r	real	4	arcsec	EXTENSION_RAD	Radius containing 50% of Petrosian flux
petroR90_r	real	4	arcsec	EXTENSION_RAD	Radius containing 90% of Petrosian flux
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
mRrCc_r	real	4		FIT_PARAM	Adaptive ( + )
mRrCcErr_r	real	4		FIT_PARAM ERROR	Error in adaptive ( + )
lnLStar_r	real	4		FIT_GOODNESS	Star ln(likelihood)
lnLExp_r	real	4		FIT_GOODNESS	Exponential disk fit ln(likelihood)
lnLDeV_r	real	4		FIT_GOODNESS	DeVaucouleurs fit ln(likelihood)
status	int	4		CODE_MISC	Status of the object in the survey
primTarget	int	4		CODE_MISC	Bit mask of primary target categories the object was selected in.
secTarget	int	4		CODE_MISC	Bit mask of secondary target categories the object was selected in.
extinction_u	real	4	mag	PHOT_EXTINCTION_GAL	Extinction in each filter
extinction_g	real	4	mag	PHOT_EXTINCTION_GAL	Extinction in each filter
extinction_r	real	4	mag	PHOT_EXTINCTION_GAL	Extinction in each filter
extinction_i	real	4	mag	PHOT_EXTINCTION_GAL	Extinction in each filter
extinction_z	real	4	mag	PHOT_EXTINCTION_GAL	Extinction in each filter
htmID	bigint	8		CODE_HTM	20-deep hierarchical trangular mesh ID of this object
fieldID	bigint	8		ID_FIELD	Link to the field this object is in
size	real	4			computed: =SQRT(mRrCc_r/2.0)
pmRa	real	4	mas/year	POS_PM_RA	Proper motion in right ascension.
pmDec	real	4	mas/year	POS_PM_DEC	Proper motion in declination.
pmL	real	4	mas/year	POS_PM	Proper motion in galactic longitude.
pmB	real	4	mas/year	POS_PM	Proper motion in galactic latitude.
pmRaErr	real	4	mas/year	POS_PM_RA_ERR	Error in proper motion in right ascension.
pmDecErr	real	4	mas/year	POS_PM_DEC_ERR	Error in proper motion in declination.
delta	real	4	arcsec	POS_ANG_DIST_GENERAL	Distance between this object and the nearest matching USNO-B object.
match	int	4		CODE_MISC	Number of objects in USNO-B which matched this object within a 1 arcsec radius. If negative, then the nearest matching USNO-B object itself matched more than 1 SDSS object.