TABLE sppTargets

Derived quantities calculated by the SEGUE-2 target selection pipeline.

There are one of these files per plate. The file has one HDU. That HDU has one row for every object in photoObjAll that is classified as a star inside a 94.4 arcmin radius of the center of the plate. The data for each object are elements of the photoObjAll, specObjAll, sppPrams and propermotions tables taken unaltered from the CAS and derived quantities calculated by the segue-2 target selection code. Appended to the end are the two target selection bitmasks, segue2_target1 and segue2_target2, as set by the target selection code.

Columns from OBJID through PSFMAGERR_:
These are taken directly from photoObjAll

Columns from PLATEID through SEGUE2_TARGET2:
These are taken from the specObjAll and sppParams tables for any objects in this file that have matches in that specObjAll. For objects without matches in specObjAll, values are set to -9999. The names from SpecObjAll are unchanged.

Columns from MATCH through DIST20:
These are taken from the propermotions table, the USNOB proper motions as recalibrated with the SDSS by Jeff Munn. For objects without matches in the ProperMotions table, values are set to -9999. The names are unchanged from the propermotions table.

Columns from uMAG0 through VTOT_GALRADREST:
These are the derived quanitites calculated by the procedure calderivedquantities in derivedquant.pro in the segue-2 target selection code. With the addition of these, this file contains all the quanitites that the selection code operates on when choosing targets.

Columns MG_TOHV through V1SIGMAERR_TOHV:
These were added for the November 2008 drilling run and after. The earlier files will be retrofit (eventually).

name type length unit ucd description

OBJID bigint 8 Object ID matching DR8

RUN bigint 8 Run number

RERUN bigint 8 Rerun number

CAMCOL bigint 8 Camera column number

FIELD bigint 8 Field number

OBJ bigint 8 Object

RA float 8 degree RA

DEC float 8 degree Dec

L float 8 degree Galactic longitude

B float 8 degree Galactic latitude

FIBERMAG_u real 4 mag u band fiber magnitudue

FIBERMAG_g real 4 mag g band fiber magnitudue

FIBERMAG_r real 4 mag r band fiber magnitudue

FIBERMAG_i real 4 mag i band fiber magnitudue

FIBERMAG_z real 4 mag z band fiber magnitudue

PSFMAG_u real 4 mag u band PSF magnitude

PSFMAG_g real 4 mag g band PSF magnitude

PSFMAG_r real 4 mag r band PSF magnitude

PSFMAG_i real 4 mag i band PSF magnitude

PSFMAG_z real 4 mag z band PSF magnitude

EXTINCTION_u real 4 mag u band extinction

EXTINCTION_g real 4 mag g band extinction

EXTINCTION_r real 4 mag r band extinction

EXTINCTION_i real 4 mag i band extinction

EXTINCTION_z real 4 mag z band extinction

ROWC int 4 pix row centroid

COLC int 4 pix column centroid

TYPE int 4 object type from photometric reductions

FLAGS bigint 8 combined flags from all bands

FLAGS_u bigint 8 u band flag

FLAGS_g bigint 8 g band flag

FLAGS_r bigint 8 r band flag

FLAGS_i bigint 8 i band flag

FLAGS_z bigint 8 z band flag

PSFMAGERR_u real 4 mag Error in u band PSF magnitude

PSFMAGERR_g real 4 mag Error in u band PSF magnitude

PSFMAGERR_r real 4 mag Error in u band PSF magnitude

PSFMAGERR_i real 4 mag Error in u band PSF magnitude

PSFMAGERR_z real 4 mag Error in u band PSF magnitude

PLATEID bigint 8 Hash of plate and MJD

SPECOBJID bigint 8 Spectroscopic object ID

PLATE bigint 8 Plate number

MJD bigint 8 Modified Julian Date

FIBERID bigint 8 Fiber number

ORIGINALPLATEID bigint 8 Original plate ID hash (if targeted based on previous spectrum)

ORIGINALSPECOBJID bigint 8 Original spectroscopic object ID (if targeted based on previous spectrum)

ORIGINALPLATE bigint 8 Original plate number (if targeted based on previous spectrum)

ORIGINALMJD bigint 8 Original Modified Julian Date (if targeted based on previous spectrum)

ORIGINALFIBERID bigint 8 Original fiber number (if targeted based on previous spectrum)(if targeted based on previous spectrum)

BESTOBJID bigint 8 Best object ID

TARGETOBJID bigint 8 Target object ID

PRIMTARGET int 4 Primary target

SECTARGET int 4 Secondary target

SEGUE1_TARGET1 bigint 8 SEGUE-1 target selection information at plate design, primary science selection

SEGUE1_TARGET2 bigint 8 SEGUE-1 target selection information at plate design, secondary/qa/calib selection

SEGUE2_TARGET1 int 4 bitmask that records the category or categories for which this object passed the selection criteria

SEGUE2_TARGET2 int 4 bitmask that records the category or categories of "standards" for the pipeline, special calibration targets like Stetson standards or globular cluster stars, for which this object passed the selection criteria

MATCH bigint 8 ??

DELTA float 8 ??

PML float 8 mas/year? Proper motion in Galactic longitude?

PMB float 8 mas/year? Proper motion in Galactic latitude?

PMRA float 8 mas/year? Proper motion in RA

PMDEC float 8 mas/year? Proper motion in DEC

PMRAERR float 8 mas/year? Proper motion error in RA

PMDECERR float 8 mas/year? Proper motion error in DEC

PMSIGRA float 8 mas/year?

PMSIGDEC float 8 mas/year?

NFIT int 4

DIST22 float 8

DIST20 float 8

uMAG0 real 4 mag u extinction-corrected (SFD 98) psf magnitude

gMAG0 real 4 mag g extinction-corrected (SFD 98) psf magnitude

rMAG0 real 4 mag r extinction-corrected (SFD 98) psf magnitude

iMAG0 real 4 mag i extinction-corrected (SFD 98) psf magnitude

zMAG0 real 4 mag z extinction-corrected (SFD 98) psf magnitude

umg0 real 4 mag u-g, extinction corrected magnitudes

gmr0 real 4 mag g-r, extinction corrected magnitudes

rmi0 real 4 mag r-i, extinction corrected magnitudes

imz0 real 4 mag i-z, extinction corrected magnitudes

gmi0 real 4 mag g-i, extinction corrected magnitudes

umgERR real 4 mag PSFMAGERR_u and PSFMAGERR_g added in quadrature

gmrERR real 4 mag PSFMAGERR_g and PSFMAGERR_r added in quadrature

rmiERR real 4 mag PSFMAGERR_r and PSFMAGERR_i added in quadrature

imzERR real 4 mag PSFMAGERR_i and PSFMAGERR_z added in quadrature

PSFMAG_umg real 4 mag psfmag_u-psfmag_g, no extinction correction

PSFMAG_gmr real 4 mag psfmag_g-psfmag_r, no extinction correction

PSFMAG_rmi real 4 mag psfmag_r-psfmag_i, no extinction correction

PSFMAG_imz real 4 mag psfmag_i-psfmag_z, no extinction correction

PSFMAG_gmi real 4 mag psfmag_g-psfmag_i, no extinction correction

lcolor real 4 mag -0.436*uMag+1.129*gMag-0.119*rMag-0.574*iMag+0.1984 (Lenz et al.1998)

scolor real 4 mag -0.249*uMag+0.794*gMag-0.555*rMag+0.234+0.011*p1s-0.010 (Helmi et al. 2003) used in SEGUE-1 target selection, unused in SEGUE-2

p1s real 4 mag 0.91*umg+0.415*umg-1.280 (Helmi et al. 2003) used in SEGUE-1 target selection, unused in SEGUE-2

TOTALPM real 4 mas/year sqrt(PMRA*PMRA+PMDEC*PMDEC), in mas/year

Hg real 4 mag reduced proper motion, gMag+5*log10(TOTALPM/1000)+5

Mi real 4 mag 4.471+7.907*imz-0.837*imz*imz used in SEGUE-1 target selection, unused in SEGUE-2

DISTi real 4 mag 10^((iMag-Mi+5)/5.0) used in SEGUE-1 target selection, unused in SEGUE-2

Hr real 4 mag reduced pm (uncorr r): PSFMAG_r+5*log10(TOTALPM/1000)+5

VMI_TRANS1 real 4 mag V-I from VMAG_TRANS-(iMag-0.337*rmi-0.37)

VMI_TRANS2 real 4 mag V-I from 0.877*gmr+0.358

VMAG_TRANS real 4 mag V mag from gMag - 0.587*gmr -0.011

MV_TRANS real 4 mag not stuffed

DISTV_KPC real 4 kpc 10^(dmV/5.-2.) where VMAG_TRANS-(3.37*VMI_TRANS1+2.89)

VTRANS_GALREST real 4 km/s transvere velocity, km/s, derived from TOTALPM and DISTV_KPC, in a frame at rest w.r.t the Galaxy

MUTRANS_GALRADREST real 4 mas/year derived PM (mas/year) perpendicular to the Galactocentric radial vector, assuming all motion is along a Galactocentric radial vector, in a frame at rest w.r.t the Galaxy

MURAD_GALRADREST real 4 mas/year derived PM (mas/year) along the Galactocentric radial vector, assuming all motion is along a Galactocentric radial vector, in a frame at rest w.r.t the Galaxy

VTOT_GALRADREST real 4 km/s total velocioty, km/s, derived from TOTALPM and DISTV_KPC, in a frame at rest w.r.t the Galaxy

MG_TOHV real 4 mag 5.7 + 10.0*(GMR - 0.375)

VTRANS_TOHV real 4 km/s transverse velocity in Galactocentric coords, using the distance estimate from MG_TOHV which is appropriate for old stars near the MSTO and corrected for peculiar solar motion 16.6 km/s toward RA,Dec 267.5,28.1

PM1SIGMA_TOHV real 4 mas/year Estimate of the 1-sigma error in total proper motion at this r magnitude. Formula is sqrt(4.56*4.56 + frate*2.30*2.30), where frate is 10^(0.4*(rMag-19.5)). The constants come from the Munn et al. 2004 (AJ, 127, 3034) paper describing the recalibration of USNOB with SDSS.

V1SIGMAERR_TOHV real 4 km/s The corresponding 1-sigma error in the transverse velocity based on PM1SIGMA_TOHV and the the distance estimate using MG_TOHV

TARGET_VERSION varchar 100 version of target used

name	type	length	unit	ucd	description
OBJID	bigint	8			Object ID matching DR8
RUN	bigint	8			Run number
RERUN	bigint	8			Rerun number
CAMCOL	bigint	8			Camera column number
FIELD	bigint	8			Field number
OBJ	bigint	8			Object
RA	float	8	degree		RA
DEC	float	8	degree		Dec
L	float	8	degree		Galactic longitude
B	float	8	degree		Galactic latitude
FIBERMAG_u	real	4	mag		u band fiber magnitudue
FIBERMAG_g	real	4	mag		g band fiber magnitudue
FIBERMAG_r	real	4	mag		r band fiber magnitudue
FIBERMAG_i	real	4	mag		i band fiber magnitudue
FIBERMAG_z	real	4	mag		z band fiber magnitudue
PSFMAG_u	real	4	mag		u band PSF magnitude
PSFMAG_g	real	4	mag		g band PSF magnitude
PSFMAG_r	real	4	mag		r band PSF magnitude
PSFMAG_i	real	4	mag		i band PSF magnitude
PSFMAG_z	real	4	mag		z band PSF magnitude
EXTINCTION_u	real	4	mag		u band extinction
EXTINCTION_g	real	4	mag		g band extinction
EXTINCTION_r	real	4	mag		r band extinction
EXTINCTION_i	real	4	mag		i band extinction
EXTINCTION_z	real	4	mag		z band extinction
ROWC	int	4	pix		row centroid
COLC	int	4	pix		column centroid
TYPE	int	4			object type from photometric reductions
FLAGS	bigint	8			combined flags from all bands
FLAGS_u	bigint	8			u band flag
FLAGS_g	bigint	8			g band flag
FLAGS_r	bigint	8			r band flag
FLAGS_i	bigint	8			i band flag
FLAGS_z	bigint	8			z band flag
PSFMAGERR_u	real	4	mag		Error in u band PSF magnitude
PSFMAGERR_g	real	4	mag		Error in u band PSF magnitude
PSFMAGERR_r	real	4	mag		Error in u band PSF magnitude
PSFMAGERR_i	real	4	mag		Error in u band PSF magnitude
PSFMAGERR_z	real	4	mag		Error in u band PSF magnitude
PLATEID	bigint	8			Hash of plate and MJD
SPECOBJID	bigint	8			Spectroscopic object ID
PLATE	bigint	8			Plate number
MJD	bigint	8			Modified Julian Date
FIBERID	bigint	8			Fiber number
ORIGINALPLATEID	bigint	8			Original plate ID hash (if targeted based on previous spectrum)
ORIGINALSPECOBJID	bigint	8			Original spectroscopic object ID (if targeted based on previous spectrum)
ORIGINALPLATE	bigint	8			Original plate number (if targeted based on previous spectrum)
ORIGINALMJD	bigint	8			Original Modified Julian Date (if targeted based on previous spectrum)
ORIGINALFIBERID	bigint	8			Original fiber number (if targeted based on previous spectrum)(if targeted based on previous spectrum)
BESTOBJID	bigint	8			Best object ID
TARGETOBJID	bigint	8			Target object ID
PRIMTARGET	int	4			Primary target
SECTARGET	int	4			Secondary target
SEGUE1_TARGET1	bigint	8			SEGUE-1 target selection information at plate design, primary science selection
SEGUE1_TARGET2	bigint	8			SEGUE-1 target selection information at plate design, secondary/qa/calib selection
SEGUE2_TARGET1	int	4			bitmask that records the category or categories for which this object passed the selection criteria
SEGUE2_TARGET2	int	4			bitmask that records the category or categories of "standards" for the pipeline, special calibration targets like Stetson standards or globular cluster stars, for which this object passed the selection criteria
MATCH	bigint	8			??
DELTA	float	8			??
PML	float	8	mas/year?		Proper motion in Galactic longitude?
PMB	float	8	mas/year?		Proper motion in Galactic latitude?
PMRA	float	8	mas/year?		Proper motion in RA
PMDEC	float	8	mas/year?		Proper motion in DEC
PMRAERR	float	8	mas/year?		Proper motion error in RA
PMDECERR	float	8	mas/year?		Proper motion error in DEC
PMSIGRA	float	8	mas/year?
PMSIGDEC	float	8	mas/year?
NFIT	int	4
DIST22	float	8
DIST20	float	8
uMAG0	real	4	mag		u extinction-corrected (SFD 98) psf magnitude
gMAG0	real	4	mag		g extinction-corrected (SFD 98) psf magnitude
rMAG0	real	4	mag		r extinction-corrected (SFD 98) psf magnitude
iMAG0	real	4	mag		i extinction-corrected (SFD 98) psf magnitude
zMAG0	real	4	mag		z extinction-corrected (SFD 98) psf magnitude
umg0	real	4	mag		u-g, extinction corrected magnitudes
gmr0	real	4	mag		g-r, extinction corrected magnitudes
rmi0	real	4	mag		r-i, extinction corrected magnitudes
imz0	real	4	mag		i-z, extinction corrected magnitudes
gmi0	real	4	mag		g-i, extinction corrected magnitudes
umgERR	real	4	mag		PSFMAGERR_u and PSFMAGERR_g added in quadrature
gmrERR	real	4	mag		PSFMAGERR_g and PSFMAGERR_r added in quadrature
rmiERR	real	4	mag		PSFMAGERR_r and PSFMAGERR_i added in quadrature
imzERR	real	4	mag		PSFMAGERR_i and PSFMAGERR_z added in quadrature
PSFMAG_umg	real	4	mag		psfmag_u-psfmag_g, no extinction correction
PSFMAG_gmr	real	4	mag		psfmag_g-psfmag_r, no extinction correction
PSFMAG_rmi	real	4	mag		psfmag_r-psfmag_i, no extinction correction
PSFMAG_imz	real	4	mag		psfmag_i-psfmag_z, no extinction correction
PSFMAG_gmi	real	4	mag		psfmag_g-psfmag_i, no extinction correction
lcolor	real	4	mag		-0.436uMag+1.129gMag-0.119rMag-0.574iMag+0.1984 (Lenz et al.1998)
scolor	real	4	mag		-0.249uMag+0.794gMag-0.555rMag+0.234+0.011p1s-0.010 (Helmi et al. 2003) used in SEGUE-1 target selection, unused in SEGUE-2
p1s	real	4	mag		0.91umg+0.415umg-1.280 (Helmi et al. 2003) used in SEGUE-1 target selection, unused in SEGUE-2
TOTALPM	real	4	mas/year		sqrt(PMRAPMRA+PMDECPMDEC), in mas/year
Hg	real	4	mag		reduced proper motion, gMag+5*log10(TOTALPM/1000)+5
Mi	real	4	mag		4.471+7.907imz-0.837imz*imz used in SEGUE-1 target selection, unused in SEGUE-2
DISTi	real	4	mag		10^((iMag-Mi+5)/5.0) used in SEGUE-1 target selection, unused in SEGUE-2
Hr	real	4	mag		reduced pm (uncorr r): PSFMAG_r+5*log10(TOTALPM/1000)+5
VMI_TRANS1	real	4	mag		V-I from VMAG_TRANS-(iMag-0.337*rmi-0.37)
VMI_TRANS2	real	4	mag		V-I from 0.877*gmr+0.358
VMAG_TRANS	real	4	mag		V mag from gMag - 0.587*gmr -0.011
MV_TRANS	real	4	mag		not stuffed
DISTV_KPC	real	4	kpc		10^(dmV/5.-2.) where VMAG_TRANS-(3.37*VMI_TRANS1+2.89)
VTRANS_GALREST	real	4	km/s		transvere velocity, km/s, derived from TOTALPM and DISTV_KPC, in a frame at rest w.r.t the Galaxy
MUTRANS_GALRADREST	real	4	mas/year		derived PM (mas/year) perpendicular to the Galactocentric radial vector, assuming all motion is along a Galactocentric radial vector, in a frame at rest w.r.t the Galaxy
MURAD_GALRADREST	real	4	mas/year		derived PM (mas/year) along the Galactocentric radial vector, assuming all motion is along a Galactocentric radial vector, in a frame at rest w.r.t the Galaxy
VTOT_GALRADREST	real	4	km/s		total velocioty, km/s, derived from TOTALPM and DISTV_KPC, in a frame at rest w.r.t the Galaxy
MG_TOHV	real	4	mag		5.7 + 10.0*(GMR - 0.375)
VTRANS_TOHV	real	4	km/s		transverse velocity in Galactocentric coords, using the distance estimate from MG_TOHV which is appropriate for old stars near the MSTO and corrected for peculiar solar motion 16.6 km/s toward RA,Dec 267.5,28.1
PM1SIGMA_TOHV	real	4	mas/year		Estimate of the 1-sigma error in total proper motion at this r magnitude. Formula is sqrt(4.564.56 + frate2.302.30), where frate is 10^(0.4(rMag-19.5)). The constants come from the Munn et al. 2004 (AJ, 127, 3034) paper describing the recalibration of USNOB with SDSS.
V1SIGMAERR_TOHV	real	4	km/s		The corresponding 1-sigma error in the transverse velocity based on PM1SIGMA_TOHV and the the distance estimate using MG_TOHV
TARGET_VERSION	varchar	100			version of target used