VIEW StarTag

DERIVED FROM PhotoTag

The objects classified as stars from primary PhotoTag objects.

The StarTag view essentially contains the abbreviated photometric parameters from the PhotoTag table (no redshifts or spectroscopic parameters) for all primary point-like objects, including quasars.

name type length unit ucd description

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

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.

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

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

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

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

SpecObjID bigint 8 ID_CATALOG Pointer to the spectrum of object, if exists, else 0

size real 4 computed: =SQRT(mRrCc_r/2.0)

name	type	length	unit	ucd	description
objID	bigint	8		ID_MAIN	Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].
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.
mode	tinyint	1		CLASS_OBJECT	1: primary, 2: secondary, 3: family object.
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
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
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
SpecObjID	bigint	8		ID_CATALOG	Pointer to the spectrum of object, if exists, else 0
size	real	4			computed: =SQRT(mRrCc_r/2.0)