Sloan Digital Sky Survey
SkyServer DR13  
Not logged in Login Help
 

DR13 Help
 Start Here
 FAQ
 Glossary
 Cooking with Sloan
 Tool User Guides
 Contact Help Desk
 
 Searching SDSS-III
 SQL Tutorial
 SQL in SkyServer
 About the Database
 Table Descriptions
 Sample SQL Queries
 Schema Browser
 Searching Advice
 Query Limits
 
 Details of the Data
 Algorithms
 Data Publications
 API
Use the IQS (SQS) to make intermediate-level queries on the dr13 CAS database for objects in the dr13 imaging (spectroscopic) sample.

Table of contents:


Parameters to Return

Which spectroscopic and/or imaging parameters do you want returned from your query?


Spectroscopy Parameters

Which spectroscopic parameters do you want returned from your query?
Useful spectroscopy parameter combinations:

none (IQS: none, SQS: plateid, mjd, fiberid)
minimal (plateid, mjd, fiberid)
typical (plateid, mjd, fiberid, z, z_err, z_conf, z_status, spec_cln, z_warnin, raObj, decObj)
radec (ra, dec)

Individual spectroscopy parameters (see also the spSpec Data Model):

nametypelengthunitucddescriptioncolumnID
specObjIDbigint8   1
bestObjIDbigint8   2
fluxObjIDbigint8   3
targetObjIDbigint8   4
plateIDbigint8   5
sciencePrimarysmallint2   6
legacyPrimarysmallint2   7
seguePrimarysmallint2   8
segue1Primarysmallint2   9
segue2Primarysmallint2   10
bossPrimarysmallint2   11
sdssPrimarysmallint2   12
bossSpecObjIDint4   13
firstReleasevarchar32   14
surveyvarchar32   15
instrumentvarchar32   16
programnamevarchar32   17
chunkvarchar32   18
platerunvarchar32   19
mjdint4   20
platesmallint2   21
fiberIDsmallint2   22
run1dvarchar32   23
run2dvarchar32   24
tileint4   25
designIDint4   26
legacy_target1bigint8   27
legacy_target2bigint8   28
special_target1bigint8   29
special_target2bigint8   30
segue1_target1bigint8   31
segue1_target2bigint8   32
segue2_target1bigint8   33
segue2_target2bigint8   34
boss_target1bigint8   35
eboss_target0bigint8   36
ancillary_target1bigint8   37
ancillary_target2bigint8   38
primTargetbigint8   39
secTargetbigint8   40
spectrographIDsmallint2   41
sourceTypevarchar128   42
targetTypevarchar128   43
rafloat8   44
decfloat8   45
cxfloat8   46
cyfloat8   47
czfloat8   48
xFocalreal4   49
yFocalreal4   50
lambdaEffreal4   51
blueFiberint4   52
zOffsetreal4   53
zreal4   54
zErrreal4   55
zWarningint4   56
classvarchar32   57
subClassvarchar32   58
rChi2real4   59
DOFreal4   60
rChi2Diffreal4   61
z_noqsoreal4   62
zErr_noqsoreal4   63
zWarning_noqsoreal4   64
class_noqsovarchar32   65
subClass_noqsovarchar32   66
rChi2Diff_noqsoreal4   67
z_personreal4   68
class_personvarchar32   69
comments_personvarchar200   70
tFilevarchar32   71
tColumn_0smallint2   72
tColumn_1smallint2   73
tColumn_2smallint2   74
tColumn_3smallint2   75
tColumn_4smallint2   76
tColumn_5smallint2   77
tColumn_6smallint2   78
tColumn_7smallint2   79
tColumn_8smallint2   80
tColumn_9smallint2   81
nPolyreal4   82
theta_0real4   83
theta_1real4   84
theta_2real4   85
theta_3real4   86
theta_4real4   87
theta_5real4   88
theta_6real4   89
theta_7real4   90
theta_8real4   91
theta_9real4   92
velDispreal4   93
velDispErrreal4   94
velDispZreal4   95
velDispZErrreal4   96
velDispChi2real4   97
velDispNPixint4   98
velDispDOFint4   99
waveMinreal4   100
waveMaxreal4   101
wCoveragereal4   102
snMedian_ureal4   103
snMedian_greal4   104
snMedian_rreal4   105
snMedian_ireal4   106
snMedian_zreal4   107
snMedianreal4   108
chi68preal4   109
fracNSigma_1real4   110
fracNSigma_2real4   111
fracNSigma_3real4   112
fracNSigma_4real4   113
fracNSigma_5real4   114
fracNSigma_6real4   115
fracNSigma_7real4   116
fracNSigma_8real4   117
fracNSigma_9real4   118
fracNSigma_10real4   119
fracNSigHi_1real4   120
fracNSigHi_2real4   121
fracNSigHi_3real4   122
fracNSigHi_4real4   123
fracNSigHi_5real4   124
fracNSigHi_6real4   125
fracNSigHi_7real4   126
fracNSigHi_8real4   127
fracNSigHi_9real4   128
fracNSigHi_10real4   129
fracNSigLo_1real4   130
fracNSigLo_2real4   131
fracNSigLo_3real4   132
fracNSigLo_4real4   133
fracNSigLo_5real4   134
fracNSigLo_6real4   135
fracNSigLo_7real4   136
fracNSigLo_8real4   137
fracNSigLo_9real4   138
fracNSigLo_10real4   139
spectroFlux_ureal4   140
spectroFlux_greal4   141
spectroFlux_rreal4   142
spectroFlux_ireal4   143
spectroFlux_zreal4   144
spectroSynFlux_ureal4   145
spectroSynFlux_greal4   146
spectroSynFlux_rreal4   147
spectroSynFlux_ireal4   148
spectroSynFlux_zreal4   149
spectroFluxIvar_ureal4   150
spectroFluxIvar_greal4   151
spectroFluxIvar_rreal4   152
spectroFluxIvar_ireal4   153
spectroFluxIvar_zreal4   154
spectroSynFluxIvar_ureal4   155
spectroSynFluxIvar_greal4   156
spectroSynFluxIvar_rreal4   157
spectroSynFluxIvar_ireal4   158
spectroSynFluxIvar_zreal4   159
spectroSkyFlux_ureal4   160
spectroSkyFlux_greal4   161
spectroSkyFlux_rreal4   162
spectroSkyFlux_ireal4   163
spectroSkyFlux_zreal4   164
anyAndMaskint4   165
anyOrMaskint4   166
plateSN2real4   167
deredSN2real4   168
snTurnoffreal4   169
sn1_greal4   170
sn1_rreal4   171
sn1_ireal4   172
sn2_greal4   173
sn2_rreal4   174
sn2_ireal4   175
elodieFileNamevarchar32   176
elodieObjectvarchar32   177
elodieSpTypevarchar32   178
elodieBVreal4   179
elodieTEffreal4   180
elodieLogGreal4   181
elodieFeHreal4   182
elodieZreal4   183
elodieZErrreal4   184
elodieZModelErrreal4   185
elodieRChi2real4   186
elodieDOFreal4   187
htmIDbigint8   188
loadVersionint4   189
imgvarbinary-1   190


Imaging Parameters

Which imaging parameters do you want returned from your query?

Note: "Target Imaging" refers to the imaging data (run) and/or processing (rerun) combination used in selecting targets for spectroscopic followup; "Best Imaging" refers to the "latest and greatest" run/rerun combination and therefore generally supersedes the run/rerun combination of "Target Imaging".

Caveat: In rare instances the "Best Imaging" object matched to a spectrum may NOT correspond to the original "Target Imaging" object. For example, this may occur when there were deblending problems in the "Target Imaging", such as when a bright off-center HII region was targeted instead of the parent galaxy, and where that HII region is then properly treated in the "Best Imaging" and is no longer a cataloged object. When in doubt, please compare the magnitudes and coordinates of the "Target Imaging" and "Best Imaging" objects.

Useful imaging parameter combinations:

none (SQS: none, IQS: run, rerun, camcol, field, id)
minimal (run, rerun, camcol, field, id)
typical (run, rerun, camcol, field, id, objc_type, ra, decl, mag_model_r)
radec (ra, dec)
model_mags (mag_model_u, mag_model_g, mag_model_r, mag_model_i, mag_model_z)
model_magerrs (mag_modelerr_u, mag_modelerr_g, mag_modelerr_r, mag_modelerr_i, mag_modelerr_z)
psf_mags (psfmag_u, psfmag_g, psfmag_r, psfmag_i, psfmag_z)
psf_magerrs (psfmagerr_u, psfmagerr_g, psfmagerr_r, psfmagerr_i, psfmagerr_z)
petro_mags (petromag_u, petromag_g, petromag_r, petromag_i, petromag_z)
petro_magerrs (petromagerr_u, petromagerr_g, petromagerr_r, petromagerr_i, petromagerr_z)
model_colors (ugModelColor, grModelColor, riModelColor, izModelColor)
ugModelColor (mag_model_u-mag_model_g)
grModelColor (mag_model_g-mag_model_r)
riModelColor (mag_model_r-mag_model_i)
izModelColor (mag_model_i-mag_model_z)

The SDSSname parameter returns the official IAU SDSS designation for the object, in the format:

SDSS JHHMMSS.ss+DDMMSS.s.
The SDSS name is generated with a call to the function fIAUFromEq.

Individual imaging parameters (see also the tsObj Data Model):

nametypelengthunitucddescriptioncolumnID
objIDbigint8  Unique SDSS identifier composed from [skyVersion,rerun,run,camcol,field,obj].1
skyVersiontinyint1  Layer of catalog (currently only one layer, 0; 0-15 available)2
runsmallint2  Run number3
rerunsmallint2  Rerun number4
camcoltinyint1  Camera column5
fieldsmallint2  Field number6
objsmallint2  The object id within a field. Usually changes between reruns of the same field7
modeLink to tinyint1  1: primary, 2: secondary, 3: other8
nChildsmallint2  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.9
typeLink to smallint2  Type classification of the object (star, galaxy, cosmic ray, etc.)10
cleanint4  Clean photometry flag (1=clean, 0=unclean).11
probPSFreal4  Probability that the object is a star. Currently 0 if type == 3 (galaxy), 1 if type == 6 (star).12
insideMaskLink to tinyint1  Flag to indicate whether object is inside a mask and why13
flagsLink to bigint8  Photo Object Attribute Flags14
rowcreal4pix Row center position (r-band coordinates)15
rowcErrreal4pix Row center position error (r-band coordinates)16
colcreal4pix Column center position (r-band coordinates)17
colcErrreal4pix Column center position error (r-band coordinates)18
rowvreal4deg/day Row-component of object's velocity19
rowvErrreal4deg/day Row-component of object's velocity error20
colvreal4deg/day Column-component of object's velocity21
colvErrreal4deg/day Column-component of object's velocity error22
rowc_ureal4pix Row center, u-band23
rowc_greal4pix Row center, g-band24
rowc_rreal4pix Row center, r-band25
rowc_ireal4pix Row center, i-band26
rowc_zreal4pix Row center, z-band27
rowcErr_ureal4pix ERROR Row center error, u-band28
rowcErr_greal4pix ERROR Row center error, g-band29
rowcErr_rreal4pix ERROR Row center error, r-band30
rowcErr_ireal4pix ERROR Row center error, i-band31
rowcErr_zreal4pix ERROR Row center error, z-band32
colc_ureal4pix Column center, u-band33
colc_greal4pix Column center, g-band34
colc_rreal4pix Column center, r-band35
colc_ireal4pix Column center, i-band36
colc_zreal4pix Column center, z-band37
colcErr_ureal4pix Column center error, u-band38
colcErr_greal4pix Column center error, g-band39
colcErr_rreal4pix Column center error, r-band40
colcErr_ireal4pix Column center error, i-band41
colcErr_zreal4pix Column center error, z-band42
sky_ureal4nanomaggies/arcsec^2 Sky flux at the center of object (allowing for siblings if blended).43
sky_greal4nanomaggies/arcsec^2 Sky flux at the center of object (allowing for siblings if blended).44
sky_rreal4nanomaggies/arcsec^2 Sky flux at the center of object (allowing for siblings if blended).45
sky_ireal4nanomaggies/arcsec^2 Sky flux at the center of object (allowing for siblings if blended).46
sky_zreal4nanomaggies/arcsec^2 Sky flux at the center of object (allowing for siblings if blended).47
skyIvar_ureal4nanomaggies/arcsec^2 Sky flux inverse variance48
skyIvar_greal4nanomaggies/arcsec^2 Sky flux inverse variance49
skyIvar_rreal4nanomaggies/arcsec^2 Sky flux inverse variance50
skyIvar_ireal4nanomaggies/arcsec^2 Sky flux inverse variance51
skyIvar_zreal4nanomaggies/arcsec^2 Sky flux inverse variance52
psfMag_ureal4mag PSF magnitude53
psfMag_greal4mag PSF magnitude54
psfMag_rreal4mag PSF magnitude55
psfMag_ireal4mag PSF magnitude56
psfMag_zreal4mag PSF magnitude57
psfMagErr_ureal4mag PSF magnitude error58
psfMagErr_greal4mag PSF magnitude error59
psfMagErr_rreal4mag PSF magnitude error60
psfMagErr_ireal4mag PSF magnitude error61
psfMagErr_zreal4mag PSF magnitude error62
fiberMag_ureal4mag Magnitude in 3 arcsec diameter fiber radius63
fiberMag_greal4mag Magnitude in 3 arcsec diameter fiber radius64
fiberMag_rreal4mag Magnitude in 3 arcsec diameter fiber radius65
fiberMag_ireal4mag Magnitude in 3 arcsec diameter fiber radius66
fiberMag_zreal4mag Magnitude in 3 arcsec diameter fiber radius67
fiberMagErr_ureal4mag Error in magnitude in 3 arcsec diameter fiber radius68
fiberMagErr_greal4mag Error in magnitude in 3 arcsec diameter fiber radius69
fiberMagErr_rreal4mag Error in magnitude in 3 arcsec diameter fiber radius70
fiberMagErr_ireal4mag Error in magnitude in 3 arcsec diameter fiber radius71
fiberMagErr_zreal4mag Error in magnitude in 3 arcsec diameter fiber radius72
fiber2Mag_ureal4mag Magnitude in 2 arcsec diameter fiber radius73
fiber2Mag_greal4mag Magnitude in 2 arcsec diameter fiber radius74
fiber2Mag_rreal4mag Magnitude in 2 arcsec diameter fiber radius75
fiber2Mag_ireal4mag Magnitude in 2 arcsec diameter fiber radius76
fiber2Mag_zreal4mag Magnitude in 2 arcsec diameter fiber radius77
fiber2MagErr_ureal4mag Error in magnitude in 2 arcsec diameter fiber radius78
fiber2MagErr_greal4mag Error in magnitude in 2 arcsec diameter fiber radius79
fiber2MagErr_rreal4mag Error in magnitude in 2 arcsec diameter fiber radius80
fiber2MagErr_ireal4mag Error in magnitude in 2 arcsec diameter fiber radius81
fiber2MagErr_zreal4mag Error in magnitude in 2 arcsec diameter fiber radius82
petroMag_ureal4mag Petrosian magnitude83
petroMag_greal4mag Petrosian magnitude84
petroMag_rreal4mag Petrosian magnitude85
petroMag_ireal4mag Petrosian magnitude86
petroMag_zreal4mag Petrosian magnitude87
petroMagErr_ureal4mag Petrosian magnitude error88
petroMagErr_greal4mag Petrosian magnitude error89
petroMagErr_rreal4mag Petrosian magnitude error90
petroMagErr_ireal4mag Petrosian magnitude error91
petroMagErr_zreal4mag Petrosian magnitude error92
psfFlux_ureal4nanomaggies PSF flux93
psfFlux_greal4nanomaggies PSF flux94
psfFlux_rreal4nanomaggies PSF flux95
psfFlux_ireal4nanomaggies PSF flux96
psfFlux_zreal4nanomaggies PSF flux97
psfFluxIvar_ureal4nanomaggies^{-2} PSF flux inverse variance98
psfFluxIvar_greal4nanomaggies^{-2} PSF flux inverse variance99
psfFluxIvar_rreal4nanomaggies^{-2} PSF flux inverse variance100
psfFluxIvar_ireal4nanomaggies^{-2} PSF flux inverse variance101
psfFluxIvar_zreal4nanomaggies^{-2} PSF flux inverse variance102
fiberFlux_ureal4nanomaggies Flux in 3 arcsec diameter fiber radius103
fiberFlux_greal4nanomaggies Flux in 3 arcsec diameter fiber radius104
fiberFlux_rreal4nanomaggies Flux in 3 arcsec diameter fiber radius105
fiberFlux_ireal4nanomaggies Flux in 3 arcsec diameter fiber radius106
fiberFlux_zreal4nanomaggies Flux in 3 arcsec diameter fiber radius107
fiberFluxIvar_ureal4nanomaggies^{-2} Inverse variance in flux in 3 arcsec diameter fiber radius108
fiberFluxIvar_greal4nanomaggies^{-2} Inverse variance in flux in 3 arcsec diameter fiber radius109
fiberFluxIvar_rreal4nanomaggies^{-2} Inverse variance in flux in 3 arcsec diameter fiber radius110
fiberFluxIvar_ireal4nanomaggies^{-2} Inverse variance in flux in 3 arcsec diameter fiber radius111
fiberFluxIvar_zreal4nanomaggies^{-2} Inverse variance in flux in 3 arcsec diameter fiber radius112
fiber2Flux_ureal4nanomaggies Flux in 2 arcsec diameter fiber radius113
fiber2Flux_greal4nanomaggies Flux in 2 arcsec diameter fiber radius114
fiber2Flux_rreal4nanomaggies Flux in 2 arcsec diameter fiber radius115
fiber2Flux_ireal4nanomaggies Flux in 2 arcsec diameter fiber radius116
fiber2Flux_zreal4nanomaggies Flux in 2 arcsec diameter fiber radius117
fiber2FluxIvar_ureal4nanomaggies^{-2} Inverse variance in flux in 2 arcsec diameter fiber radius118
fiber2FluxIvar_greal4nanomaggies^{-2} Inverse variance in flux in 2 arcsec diameter fiber radius119
fiber2FluxIvar_rreal4nanomaggies^{-2} Inverse variance in flux in 2 arcsec diameter fiber radius120
fiber2FluxIvar_ireal4nanomaggies^{-2} Inverse variance in flux in 2 arcsec diameter fiber radius121
fiber2FluxIvar_zreal4nanomaggies^{-2} Inverse variance in flux in 2 arcsec diameter fiber radius122
petroFlux_ureal4nanomaggies Petrosian flux123
petroFlux_greal4nanomaggies Petrosian flux124
petroFlux_rreal4nanomaggies Petrosian flux125
petroFlux_ireal4nanomaggies Petrosian flux126
petroFlux_zreal4nanomaggies Petrosian flux127
petroFluxIvar_ureal4nanomaggies^{-2} Petrosian flux inverse variance128
petroFluxIvar_greal4nanomaggies^{-2} Petrosian flux inverse variance129
petroFluxIvar_rreal4nanomaggies^{-2} Petrosian flux inverse variance130
petroFluxIvar_ireal4nanomaggies^{-2} Petrosian flux inverse variance131
petroFluxIvar_zreal4nanomaggies^{-2} Petrosian flux inverse variance132
petroRad_ureal4arcsec Petrosian radius133
petroRad_greal4arcsec Petrosian radius134
petroRad_rreal4arcsec Petrosian radius135
petroRad_ireal4arcsec Petrosian radius136
petroRad_zreal4arcsec Petrosian radius137
petroRadErr_ureal4arcsec Petrosian radius error138
petroRadErr_greal4arcsec Petrosian radius error139
petroRadErr_rreal4arcsec Petrosian radius error140
petroRadErr_ireal4arcsec Petrosian radius error141
petroRadErr_zreal4arcsec Petrosian radius error142
petroR50_ureal4arcsec Radius containing 50% of Petrosian flux143
petroR50_greal4arcsec Radius containing 50% of Petrosian flux144
petroR50_rreal4arcsec Radius containing 50% of Petrosian flux145
petroR50_ireal4arcsec Radius containing 50% of Petrosian flux146
petroR50_zreal4arcsec Radius containing 50% of Petrosian flux147
petroR50Err_ureal4arcsec Error in radius with 50% of Petrosian flux error148
petroR50Err_greal4arcsec Error in radius with 50% of Petrosian flux error149
petroR50Err_rreal4arcsec Error in radius with 50% of Petrosian flux error150
petroR50Err_ireal4arcsec Error in radius with 50% of Petrosian flux error151
petroR50Err_zreal4arcsec Error in radius with 50% of Petrosian flux error152
petroR90_ureal4arcsec Radius containing 90% of Petrosian flux153
petroR90_greal4arcsec Radius containing 90% of Petrosian flux154
petroR90_rreal4arcsec Radius containing 90% of Petrosian flux155
petroR90_ireal4arcsec Radius containing 90% of Petrosian flux156
petroR90_zreal4arcsec Radius containing 90% of Petrosian flux157
petroR90Err_ureal4arcsec Error in radius with 90% of Petrosian flux error158
petroR90Err_greal4arcsec Error in radius with 90% of Petrosian flux error159
petroR90Err_rreal4arcsec Error in radius with 90% of Petrosian flux error160
petroR90Err_ireal4arcsec Error in radius with 90% of Petrosian flux error161
petroR90Err_zreal4arcsec Error in radius with 90% of Petrosian flux error162
q_ureal4  Stokes Q parameter163
q_greal4  Stokes Q parameter164
q_rreal4  Stokes Q parameter165
q_ireal4  Stokes Q parameter166
q_zreal4  Stokes Q parameter167
qErr_ureal4  Stokes Q parameter error168
qErr_greal4  Stokes Q parameter error169
qErr_rreal4  Stokes Q parameter error170
qErr_ireal4  Stokes Q parameter error171
qErr_zreal4  Stokes Q parameter error172
u_ureal4  Stokes U parameter173
u_greal4  Stokes U parameter174
u_rreal4  Stokes U parameter175
u_ireal4  Stokes U parameter176
u_zreal4  Stokes U parameter177
uErr_ureal4  Stokes U parameter error178
uErr_greal4  Stokes U parameter error179
uErr_rreal4  Stokes U parameter error180
uErr_ireal4  Stokes U parameter error181
uErr_zreal4  Stokes U parameter error182
mE1_ureal4  Adaptive E1 shape measure (pixel coordinates)183
mE1_greal4  Adaptive E1 shape measure (pixel coordinates)184
mE1_rreal4  Adaptive E1 shape measure (pixel coordinates)185
mE1_ireal4  Adaptive E1 shape measure (pixel coordinates)186
mE1_zreal4  Adaptive E1 shape measure (pixel coordinates)187
mE2_ureal4  Adaptive E2 shape measure (pixel coordinates)188
mE2_greal4  Adaptive E2 shape measure (pixel coordinates)189
mE2_rreal4  Adaptive E2 shape measure (pixel coordinates)190
mE2_ireal4  Adaptive E2 shape measure (pixel coordinates)191
mE2_zreal4  Adaptive E2 shape measure (pixel coordinates)192
mE1E1Err_ureal4  Covariance in E1/E1 shape measure (pixel coordinates)193
mE1E1Err_greal4  Covariance in E1/E1 shape measure (pixel coordinates)194
mE1E1Err_rreal4  Covariance in E1/E1 shape measure (pixel coordinates)195
mE1E1Err_ireal4  Covariance in E1/E1 shape measure (pixel coordinates)196
mE1E1Err_zreal4  Covariance in E1/E1 shape measure (pixel coordinates)197
mE1E2Err_ureal4  Covariance in E1/E2 shape measure (pixel coordinates)198
mE1E2Err_greal4  Covariance in E1/E2 shape measure (pixel coordinates)199
mE1E2Err_rreal4  Covariance in E1/E2 shape measure (pixel coordinates)200
mE1E2Err_ireal4  Covariance in E1/E2 shape measure (pixel coordinates)201
mE1E2Err_zreal4  Covariance in E1/E2 shape measure (pixel coordinates)202
mE2E2Err_ureal4  Covariance in E2/E2 shape measure (pixel coordinates)203
mE2E2Err_greal4  Covariance in E2/E2 shape measure (pixel coordinates)204
mE2E2Err_rreal4  Covariance in E2/E2 shape measure (pixel coordinates)205
mE2E2Err_ireal4  Covariance in E2/E2 shape measure (pixel coordinates)206
mE2E2Err_zreal4  Covariance in E2/E2 shape measure (pixel coordinates)207
mRrCc_ureal4  Adaptive ( + ) (pixel coordinates)208
mRrCc_greal4  Adaptive ( + ) (pixel coordinates)209
mRrCc_rreal4  Adaptive ( + ) (pixel coordinates)210
mRrCc_ireal4  Adaptive ( + ) (pixel coordinates)211
mRrCc_zreal4  Adaptive ( + ) (pixel coordinates)212
mRrCcErr_ureal4  Error in adaptive ( + ) (pixel coordinates)213
mRrCcErr_greal4  Error in adaptive ( + ) (pixel coordinates)214
mRrCcErr_rreal4  Error in adaptive ( + ) (pixel coordinates)215
mRrCcErr_ireal4  Error in adaptive ( + ) (pixel coordinates)216
mRrCcErr_zreal4  Error in adaptive ( + ) (pixel coordinates)217
mCr4_ureal4  Adaptive fourth moment of object (pixel coordinates)218
mCr4_greal4  Adaptive fourth moment of object (pixel coordinates)219
mCr4_rreal4  Adaptive fourth moment of object (pixel coordinates)220
mCr4_ireal4  Adaptive fourth moment of object (pixel coordinates)221
mCr4_zreal4  Adaptive fourth moment of object (pixel coordinates)222
mE1PSF_ureal4  Adaptive E1 for PSF (pixel coordinates)223
mE1PSF_greal4  Adaptive E1 for PSF (pixel coordinates)224
mE1PSF_rreal4  Adaptive E1 for PSF (pixel coordinates)225
mE1PSF_ireal4  Adaptive E1 for PSF (pixel coordinates)226
mE1PSF_zreal4  Adaptive E1 for PSF (pixel coordinates)227
mE2PSF_ureal4  Adaptive E2 for PSF (pixel coordinates)228
mE2PSF_greal4  Adaptive E2 for PSF (pixel coordinates)229
mE2PSF_rreal4  Adaptive E2 for PSF (pixel coordinates)230
mE2PSF_ireal4  Adaptive E2 for PSF (pixel coordinates)231
mE2PSF_zreal4  Adaptive E2 for PSF (pixel coordinates)232
mRrCcPSF_ureal4  Adaptive ( + ) for PSF (pixel coordinates)233
mRrCcPSF_greal4  Adaptive ( + ) for PSF (pixel coordinates)234
mRrCcPSF_rreal4  Adaptive ( + ) for PSF (pixel coordinates)235
mRrCcPSF_ireal4  Adaptive ( + ) for PSF (pixel coordinates)236
mRrCcPSF_zreal4  Adaptive ( + ) for PSF (pixel coordinates)237
mCr4PSF_ureal4  Adaptive fourth moment for PSF (pixel coordinates)238
mCr4PSF_greal4  Adaptive fourth moment for PSF (pixel coordinates)239
mCr4PSF_rreal4  Adaptive fourth moment for PSF (pixel coordinates)240
mCr4PSF_ireal4  Adaptive fourth moment for PSF (pixel coordinates)241
mCr4PSF_zreal4  Adaptive fourth moment for PSF (pixel coordinates)242
deVRad_ureal4arcsec de Vaucouleurs fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.243
deVRad_greal4arcsec de Vaucouleurs fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.244
deVRad_rreal4arcsec de Vaucouleurs fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.245
deVRad_ireal4arcsec de Vaucouleurs fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.246
deVRad_zreal4arcsec de Vaucouleurs fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.247
deVRadErr_ureal4arcsec Error in de Vaucouleurs fit scale radius error248
deVRadErr_greal4arcsec Error in de Vaucouleurs fit scale radius error249
deVRadErr_rreal4arcsec Error in de Vaucouleurs fit scale radius error250
deVRadErr_ireal4arcsec Error in de Vaucouleurs fit scale radius error251
deVRadErr_zreal4arcsec Error in de Vaucouleurs fit scale radius error252
deVAB_ureal4  de Vaucouleurs fit b/a253
deVAB_greal4  de Vaucouleurs fit b/a254
deVAB_rreal4  de Vaucouleurs fit b/a255
deVAB_ireal4  de Vaucouleurs fit b/a256
deVAB_zreal4  de Vaucouleurs fit b/a257
deVABErr_ureal4  de Vaucouleurs fit b/a error258
deVABErr_greal4  de Vaucouleurs fit b/a error259
deVABErr_rreal4  de Vaucouleurs fit b/a error260
deVABErr_ireal4  de Vaucouleurs fit b/a error261
deVABErr_zreal4  de Vaucouleurs fit b/a error262
deVPhi_ureal4deg de Vaucouleurs fit position angle (+N thru E)263
deVPhi_greal4deg de Vaucouleurs fit position angle (+N thru E)264
deVPhi_rreal4deg de Vaucouleurs fit position angle (+N thru E)265
deVPhi_ireal4deg de Vaucouleurs fit position angle (+N thru E)266
deVPhi_zreal4deg de Vaucouleurs fit position angle (+N thru E)267
deVMag_ureal4mag de Vaucouleurs magnitude fit268
deVMag_greal4mag de Vaucouleurs magnitude fit269
deVMag_rreal4mag de Vaucouleurs magnitude fit270
deVMag_ireal4mag de Vaucouleurs magnitude fit271
deVMag_zreal4mag de Vaucouleurs magnitude fit272
deVMagErr_ureal4mag de Vaucouleurs magnitude fit error273
deVMagErr_greal4mag de Vaucouleurs magnitude fit error274
deVMagErr_rreal4mag de Vaucouleurs magnitude fit error275
deVMagErr_ireal4mag de Vaucouleurs magnitude fit error276
deVMagErr_zreal4mag de Vaucouleurs magnitude fit error277
deVFlux_ureal4nanomaggies de Vaucouleurs magnitude fit278
deVFlux_greal4nanomaggies de Vaucouleurs magnitude fit279
deVFlux_rreal4nanomaggies de Vaucouleurs magnitude fit280
deVFlux_ireal4nanomaggies de Vaucouleurs magnitude fit281
deVFlux_zreal4nanomaggies de Vaucouleurs magnitude fit282
deVFluxIvar_ureal4nanomaggies^{-2} de Vaucouleurs magnitude fit inverse variance283
deVFluxIvar_greal4nanomaggies^{-2} de Vaucouleurs magnitude fit inverse variance284
deVFluxIvar_rreal4nanomaggies^{-2} de Vaucouleurs magnitude fit inverse variance285
deVFluxIvar_ireal4nanomaggies^{-2} de Vaucouleurs magnitude fit inverse variance286
deVFluxIvar_zreal4nanomaggies^{-2} de Vaucouleurs magnitude fit inverse variance287
expRad_ureal4arcsec Exponential fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.288
expRad_greal4arcsec Exponential fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.289
expRad_rreal4arcsec Exponential fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.290
expRad_ireal4arcsec Exponential fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.291
expRad_zreal4arcsec Exponential fit scale radius, here defined to be the same as the half-light radius, also called the effective radius.292
expRadErr_ureal4arcsec Exponential fit scale radius error293
expRadErr_greal4arcsec Exponential fit scale radius error294
expRadErr_rreal4arcsec Exponential fit scale radius error295
expRadErr_ireal4arcsec Exponential fit scale radius error296
expRadErr_zreal4arcsec Exponential fit scale radius error297
expAB_ureal4  Exponential fit b/a298
expAB_greal4  Exponential fit b/a299
expAB_rreal4  Exponential fit b/a300
expAB_ireal4  Exponential fit b/a301
expAB_zreal4  Exponential fit b/a302
expABErr_ureal4  Exponential fit b/a303
expABErr_greal4  Exponential fit b/a304
expABErr_rreal4  Exponential fit b/a305
expABErr_ireal4  Exponential fit b/a306
expABErr_zreal4  Exponential fit b/a307
expPhi_ureal4deg Exponential fit position angle (+N thru E)308
expPhi_greal4deg Exponential fit position angle (+N thru E)309
expPhi_rreal4deg Exponential fit position angle (+N thru E)310
expPhi_ireal4deg Exponential fit position angle (+N thru E)311
expPhi_zreal4deg Exponential fit position angle (+N thru E)312
expMag_ureal4mag Exponential fit magnitude313
expMag_greal4mag Exponential fit magnitude314
expMag_rreal4mag Exponential fit magnitude315
expMag_ireal4mag Exponential fit magnitude316
expMag_zreal4mag Exponential fit magnitude317
expMagErr_ureal4mag Exponential fit magnitude error318
expMagErr_greal4mag Exponential fit magnitude error319
expMagErr_rreal4mag Exponential fit magnitude error320
expMagErr_ireal4mag Exponential fit magnitude error321
expMagErr_zreal4mag Exponential fit magnitude error322
modelMag_ureal4mag better of DeV/Exp magnitude fit323
modelMag_greal4mag better of DeV/Exp magnitude fit324
modelMag_rreal4mag better of DeV/Exp magnitude fit325
modelMag_ireal4mag better of DeV/Exp magnitude fit326
modelMag_zreal4mag better of DeV/Exp magnitude fit327
modelMagErr_ureal4mag Error in better of DeV/Exp magnitude fit328
modelMagErr_greal4mag Error in better of DeV/Exp magnitude fit329
modelMagErr_rreal4mag Error in better of DeV/Exp magnitude fit330
modelMagErr_ireal4mag Error in better of DeV/Exp magnitude fit331
modelMagErr_zreal4mag Error in better of DeV/Exp magnitude fit332
cModelMag_ureal4mag DeV+Exp magnitude333
cModelMag_greal4mag DeV+Exp magnitude334
cModelMag_rreal4mag DeV+Exp magnitude335
cModelMag_ireal4mag DeV+Exp magnitude336
cModelMag_zreal4mag DeV+Exp magnitude337
cModelMagErr_ureal4mag DeV+Exp magnitude error338
cModelMagErr_greal4mag DeV+Exp magnitude error339
cModelMagErr_rreal4mag DeV+Exp magnitude error340
cModelMagErr_ireal4mag DeV+Exp magnitude error341
cModelMagErr_zreal4mag DeV+Exp magnitude error342
expFlux_ureal4nanomaggies Exponential fit flux343
expFlux_greal4nanomaggies Exponential fit flux344
expFlux_rreal4nanomaggies Exponential fit flux345
expFlux_ireal4nanomaggies Exponential fit flux346
expFlux_zreal4nanomaggies Exponential fit flux347
expFluxIvar_ureal4nanomaggies^{-2} Exponential fit flux inverse variance348
expFluxIvar_greal4nanomaggies^{-2} Exponential fit flux inverse variance349
expFluxIvar_rreal4nanomaggies^{-2} Exponential fit flux inverse variance350
expFluxIvar_ireal4nanomaggies^{-2} Exponential fit flux inverse variance351
expFluxIvar_zreal4nanomaggies^{-2} Exponential fit flux inverse variance352
modelFlux_ureal4nanomaggies better of DeV/Exp flux fit353
modelFlux_greal4nanomaggies better of DeV/Exp flux fit354
modelFlux_rreal4nanomaggies better of DeV/Exp flux fit355
modelFlux_ireal4nanomaggies better of DeV/Exp flux fit356
modelFlux_zreal4nanomaggies better of DeV/Exp flux fit357
modelFluxIvar_ureal4nanomaggies^{-2} Inverse variance in better of DeV/Exp flux fit358
modelFluxIvar_greal4nanomaggies^{-2} Inverse variance in better of DeV/Exp flux fit359
modelFluxIvar_rreal4nanomaggies^{-2} Inverse variance in better of DeV/Exp flux fit360
modelFluxIvar_ireal4nanomaggies^{-2} Inverse variance in better of DeV/Exp flux fit361
modelFluxIvar_zreal4nanomaggies^{-2} Inverse variance in better of DeV/Exp flux fit362
cModelFlux_ureal4nanomaggies better of DeV+Exp flux363
cModelFlux_greal4nanomaggies better of DeV+Exp flux364
cModelFlux_rreal4nanomaggies better of DeV+Exp flux365
cModelFlux_ireal4nanomaggies better of DeV+Exp flux366
cModelFlux_zreal4nanomaggies better of DeV+Exp flux367
cModelFluxIvar_ureal4nanomaggies^{-2} Inverse variance in DeV+Exp flux fit368
cModelFluxIvar_greal4nanomaggies^{-2} Inverse variance in DeV+Exp flux fit369
cModelFluxIvar_rreal4nanomaggies^{-2} Inverse variance in DeV+Exp flux fit370
cModelFluxIvar_ireal4nanomaggies^{-2} Inverse variance in DeV+Exp flux fit371
cModelFluxIvar_zreal4nanomaggies^{-2} Inverse variance in DeV+Exp flux fit372
aperFlux7_ureal4nanomaggies Aperture flux within 7.3 arcsec373
aperFlux7_greal4nanomaggies Aperture flux within 7.3 arcsec374
aperFlux7_rreal4nanomaggies Aperture flux within 7.3 arcsec375
aperFlux7_ireal4nanomaggies Aperture flux within 7.3 arcsec376
aperFlux7_zreal4nanomaggies Aperture flux within 7.3 arcsec377
aperFlux7Ivar_ureal4nanomaggies^{-2} Inverse variance of aperture flux within 7.3 arcsec378
aperFlux7Ivar_greal4nanomaggies^{-2} Inverse variance of aperture flux within 7.3 arcsec379
aperFlux7Ivar_rreal4nanomaggies^{-2} Inverse variance of aperture flux within 7.3 arcsec380
aperFlux7Ivar_ireal4nanomaggies^{-2} Inverse variance of aperture flux within 7.3 arcsec381
aperFlux7Ivar_zreal4nanomaggies^{-2} Inverse variance of aperture flux within 7.3 arcsec382
lnLStar_ureal4  Star ln(likelihood)383
lnLStar_greal4  Star ln(likelihood)384
lnLStar_rreal4  Star ln(likelihood)385
lnLStar_ireal4  Star ln(likelihood)386
lnLStar_zreal4  Star ln(likelihood)387
lnLExp_ureal4  Exponential disk fit ln(likelihood)388
lnLExp_greal4  Exponential disk fit ln(likelihood)389
lnLExp_rreal4  Exponential disk fit ln(likelihood)390
lnLExp_ireal4  Exponential disk fit ln(likelihood)391
lnLExp_zreal4  Exponential disk fit ln(likelihood)392
lnLDeV_ureal4  de Vaucouleurs fit ln(likelihood)393
lnLDeV_greal4  de Vaucouleurs fit ln(likelihood)394
lnLDeV_rreal4  de Vaucouleurs fit ln(likelihood)395
lnLDeV_ireal4  de Vaucouleurs fit ln(likelihood)396
lnLDeV_zreal4  de Vaucouleurs fit ln(likelihood)397
fracDeV_ureal4  Weight of deV component in deV+Exp model398
fracDeV_greal4  Weight of deV component in deV+Exp model399
fracDeV_rreal4  Weight of deV component in deV+Exp model400
fracDeV_ireal4  Weight of deV component in deV+Exp model401
fracDeV_zreal4  Weight of deV component in deV+Exp model402
flags_ubigint8  Object detection flags per band403
flags_gbigint8  Object detection flags per band404
flags_rbigint8  Object detection flags per band405
flags_ibigint8  Object detection flags per band406
flags_zbigint8  Object detection flags per band407
type_uint4  Object type classification per band408
type_gint4  Object type classification per band409
type_rint4  Object type classification per band410
type_iint4  Object type classification per band411
type_zint4  Object type classification per band412
probPSF_ureal4  Probablity object is a star in each filter.413
probPSF_greal4  Probablity object is a star in each filter.414
probPSF_rreal4  Probablity object is a star in each filter.415
probPSF_ireal4  Probablity object is a star in each filter.416
probPSF_zreal4  Probablity object is a star in each filter.417
rafloat8deg J2000 Right Ascension (r-band)418
decfloat8deg J2000 Declination (r-band)419
cxfloat8  unit vector for ra+dec420
cyfloat8  unit vector for ra+dec421
czfloat8  unit vector for ra+dec422
raErrfloat8arcsec Error in RA (* cos(Dec), that is, proper units)423
decErrfloat8arcsec Error in Dec424
bfloat8deg Galactic latitude425
lfloat8deg Galactic longitude426
offsetRa_ureal4arcsec filter position RA minus final RA (* cos(Dec), that is, proper units)427
offsetRa_greal4arcsec filter position RA minus final RA (* cos(Dec), that is, proper units)428
offsetRa_rreal4arcsec filter position RA minus final RA (* cos(Dec), that is, proper units)429
offsetRa_ireal4arcsec filter position RA minus final RA (* cos(Dec), that is, proper units)430
offsetRa_zreal4arcsec filter position RA minus final RA (* cos(Dec), that is, proper units)431
offsetDec_ureal4arcsec filter position Dec minus final Dec432
offsetDec_greal4arcsec filter position Dec minus final Dec433
offsetDec_rreal4arcsec filter position Dec minus final Dec434
offsetDec_ireal4arcsec filter position Dec minus final Dec435
offsetDec_zreal4arcsec filter position Dec minus final Dec436
extinction_ureal4mag Extinction in u-band437
extinction_greal4mag Extinction in g-band438
extinction_rreal4mag Extinction in r-band439
extinction_ireal4mag Extinction in i-band440
extinction_zreal4mag Extinction in z-band441
psffwhm_ureal4arcsec FWHM in u-band442
psffwhm_greal4arcsec FWHM in g-band443
psffwhm_rreal4arcsec FWHM in r-band444
psffwhm_ireal4arcsec FWHM in i-band445
psffwhm_zreal4arcsec FWHM in z-band446
mjdint4days Date of observation447
airmass_ureal4  Airmass at time of observation in u-band448
airmass_greal4  Airmass at time of observation in g-band449
airmass_rreal4  Airmass at time of observation in r-band450
airmass_ireal4  Airmass at time of observation in i-band451
airmass_zreal4  Airmass at time of observation in z-band452
phioffset_ureal4deg Degrees to add to CCD-aligned angle to convert to E of N453
phioffset_greal4deg Degrees to add to CCD-aligned angle to convert to E of N454
phioffset_rreal4deg Degrees to add to CCD-aligned angle to convert to E of N455
phioffset_ireal4deg Degrees to add to CCD-aligned angle to convert to E of N456
phioffset_zreal4deg Degrees to add to CCD-aligned angle to convert to E of N457
nProf_uint4  Number of Profile Bins458
nProf_gint4  Number of Profile Bins459
nProf_rint4  Number of Profile Bins460
nProf_iint4  Number of Profile Bins461
nProf_zint4  Number of Profile Bins462
loadVersionint4  Load Version463
htmIDbigint8  20-deep hierarchical trangular mesh ID of this object464
fieldIDbigint8  Link to the field this object is in465
parentIDbigint8  Pointer to parent (if object deblended) or BRIGHT detection (if object has one), else 0466
specObjIDbigint8  Pointer to the spectrum of object, if exists, else 0467
ureal4mag Shorthand alias for modelMag468
greal4mag Shorthand alias for modelMag469
rreal4mag Shorthand alias for modelMag470
ireal4mag Shorthand alias for modelMag471
zreal4mag Shorthand alias for modelMag472
err_ureal4mag Error in modelMag alias473
err_greal4mag Error in modelMag alias474
err_rreal4mag Error in modelMag alias475
err_ireal4mag Error in modelMag alias476
err_zreal4mag Error in modelMag alias477
dered_ureal4mag Simplified mag, corrected for extinction: modelMag-extinction478
dered_greal4mag Simplified mag, corrected for extinction: modelMag-extinction479
dered_rreal4mag Simplified mag, corrected for extinction: modelMag-extinction480
dered_ireal4mag Simplified mag, corrected for extinction: modelMag-extinction481
dered_zreal4mag Simplified mag, corrected for extinction: modelMag-extinction482
cloudCam_uint4  Cloud camera status for observation in u-band483
cloudCam_gint4  Cloud camera status for observation in g-band484
cloudCam_rint4  Cloud camera status for observation in r-band485
cloudCam_iint4  Cloud camera status for observation in i-band486
cloudCam_zint4  Cloud camera status for observation in z-band487
resolveStatusLink to int4  Resolve status of object488
thingIdint4  Unique identifier from global resolve489
balkanIdint4  What balkan object is in from window490
nObserveint4  Number of observations of this object491
nDetectint4  Number of detections of this object492
nEdgeint4  Number of observations of this object near an edge493
scorereal4  Quality of field (0-1)494
calibStatus_uLink to int4  Calibration status in u-band495
calibStatus_gLink to int4  Calibration status in g-band496
calibStatus_rLink to int4  Calibration status in r-band497
calibStatus_iLink to int4  Calibration status in i-band498
calibStatus_zLink to int4  Calibration status in z-band499
nMgyPerCount_ureal4nmgy/count nanomaggies per count in u-band500
nMgyPerCount_greal4nmgy/count nanomaggies per count in g-band501
nMgyPerCount_rreal4nmgy/count nanomaggies per count in r-band502
nMgyPerCount_ireal4nmgy/count nanomaggies per count in i-band503
nMgyPerCount_zreal4nmgy/count nanomaggies per count in z-band504
TAI_ufloat8sec time of observation (TAI) in each filter505
TAI_gfloat8sec time of observation (TAI) in each filter506
TAI_rfloat8sec time of observation (TAI) in each filter507
TAI_ifloat8sec time of observation (TAI) in each filter508
TAI_zfloat8sec time of observation (TAI) in each filter509

Getting FITS files from the SAS (Science Archive Server)

After you press Submit, the page that displays the results of the query will include the appropriate button(s) to upload the results of the query to the SAS to retrieve the corresponding raw FITS file data. If you only request imaging data and include the columns run, rerun, camcol, and field (these are included in the minimal and typical column lists), then the Upload list of fields to SAS button will be displayed on the results page (below the query results table). If you request spectroscopic data, and include the columns plate, mjd and fiberid in the output (included in the minimal and typical column lists), then the Upload list of spectra to SAS button will be displayed on the results page so you can retrieve FITS files for the spectra.


Position Constraints

Which positional constraints (if any) do you want applied to your query?


Rectangular Search

Do you wish to search a rectangular box in ra and dec?

Valid formats (J2000):

  • raMin/raMax in decimal degrees (D.ddddd) or in sexagesimal hours, minutes, seconds (HH:MM:SS.ss or HH MM SS.ss)
  • decMin/decMax in decimal degrees (+/-DD.ddddd) or in sexagesimal degrees, arcminutes, arcseconds (+/-DD:MM:SS.s or +/-DD MM SS.s)

Cone Search

Do you wish to search a circle on the sky centered on a single ra and dec?

For a given RA and DEC, the cone search returns all objects within the search radius that meet your search constraints.

Valid formats (J2000):

  • raCenter in decimal degrees (D.ddddd) or in sexagesimal hours, minutes, seconds (HH:MM:SS.ss or HH MM SS.ss)
  • decCenter in decimal degrees (+/-DD.ddddd) or in sexagesimal degrees, arcminutes, arcseconds (+/-DD:MM:SS.s or +/-DD MM SS.s)
  • radius in decimal arcminutes (M.mmm)

Proximity Search

Do you want to search the proximities for a list of ra's and dec's?

Proximity Search allows you to enter a list of RA/Dec positions and find objects near those positions. For each RA and Dec you enter, the proximity search returns objects within the specified search radius that meet your search constraints.

The list can be either entered directly into the box or uploaded as a file. In either case, the positions must be of the form:

ra dec [sep]

with each item separated by a comma or space. The first two numbers, "ra" and "dec," are requried - these are the sky positions (J2000) around which to search. The third, "sep," is optional - it is the separation distance or seach radius, in arcminutes, around which to search. If you do not enter a value for "sep," the default is 1 arcminute.

Valid formats for positions are:

  • ra in decimal degrees (D.ddddd); or in sexagesimal hours, minutes, seconds (HH:MM:SS.ss or HH MM SS.ss)
  • dec in decimal degrees (+/-DD.ddddd); or in sexagesimal degrees, arcminutes, arcseconds (+/-DD:MM:SS.s or +/-DD MM SS.s)
  • sep in decimal arcminutes (S.ssss...)

"Nearest Only" returns only one match for each position you enter - the sky object meeting your search criteria that is nearest to the position you entered.

"All Nearby" returns all objects meeting your criteria within your search radius.

That means that "Nearest Only" only will return at most one match for each position you entered; "All Nearby" could return many matches for each position.


No Position Constraint

Do you want to apply no positional constraints in your query?
CAVEAT EMPTOR: This will result in a search over the entire database, which will probably take a very long time to finish (and slow other users down). Please be sure that this is what you want to do, or at least select a limited number of objects to return.


Spectroscopy Constraints

Which spectroscopic constraints (if any) do you want applied to your query?


Redshift

Do you want to search over a given range in redshift?

Redshifts less than zero are possible (e.g., for stars), as are redshifts greater than 5 (some QSOs, but also objects with poorly measured redshifts). The "Redshift warning flags" toggle allows you to remove the constraint that there should be no redshift warnings (default). Uncheck this if you want to allow spectra that have redshifts with warnings associated with them. The warning flags are encoded as bits in the zWarning column in the SpecObjAll table.


Spectral Classification

What type of objects (as automatically classified by their spectra) do you want returned from your query?

The options are:

No parameters

Primtarget

Which type of objects do you want returned from your query? (Here, the object type is from the spectroscopic target selection algorithms, where the objects have been classified photometrically or by matchup with other catalogs.) (primary target categories)

The primTarget field is a bit mask specifying which primary target categories the object was selected in. If you select one or more bits in the At least one of these bits ON menu, then the bit-wise OR of each of those bits is computed and it must be greater than 0. If you select one or more of the bits in the All of these bits OFF menu, then the bit-wise AND of all those bits is computed and it must be equal to 0.

The bits are defined as:

namevaluedescription
QSO_CAP0x00000002ugri-selected quasar at high Galactic latitude
QSO_SKIRT0x00000004ugri-selected quasar at low Galactic latitude
QSO_FIRST_CAP0x00000008FIRST source with stellar colors at high Galactic latitude
QSO_FIRST_SKIRT0x00000010FIRST source with stellar colors at low Galactic latitude
GALAXY_RED0x00000020Luminous Red Galaxy target (any criteria)
GALAXY0x00000040Main sample galaxy
GALAXY_BIG0x00000080Low-surface brightness main sample galaxy (mu50>23 in r-band)
GALAXY_BRIGHT_CORE0x00000100Galaxy targets who fail all the surface brightness selection limits but have r-band fiber magnitudes brighter than 19
ROSAT_A0x00000200ROSAT All-Sky Survey match, also a radio source
ROSAT_B0x00000400ROSAT All-Sky Survey match, have SDSS colors of AGNs or quasars
ROSAT_C0x00000800ROSAT All-Sky Survey match, fall in a broad intermediate category that includes stars that are bright, moderately blue, or both
ROSAT_D0x00001000ROSAT All-Sky Survey match, are otherwise bright enough for SDSS spectroscopy
STAR_BHB0x00002000blue horizontal-branch stars
STAR_CARBON0x00004000dwarf and giant carbon stars
STAR_BROWN_DWARF0x00008000brown dwarfs (note this sample is tiled)
STAR_SUB_DWARF0x00010000low-luminosity subdwarfs
STAR_CATY_VAR0x00020000cataclysmic variables
STAR_RED_DWARF0x00040000red dwarfs
STAR_WHITE_DWARF0x00080000hot white dwarfs
SERENDIP_BLUE0x00100000lying outside the stellar locus in color space
SERENDIP_FIRST0x00200000coincident with FIRST sources but fainter than the equivalent in quasar target selection (also includes non-PSF sources
SERENDIP_RED0x00400000lying outside the stellar locus in color space
SERENDIP_DISTANT0x00800000lying outside the stellar locus in color space
SERENDIP_MANUAL0x01000000manual serendipity flag
QSO_FAINT0x02000000Stellar outlier; too faint or too bright to be targeted
GALAXY_RED_II0x04000000Luminous Red Galaxy target (Cut II criteria)
ROSAT_E0x08000000ROSAT All-Sky Survey match, but too faint or too bright for SDSS spectroscopy
STAR_PN0x10000000central stars of planetary nebulae
QSO_REJECT0x20000000Object in explicitly excluded region of color space, therefore not targeted at QSO
SOUTHERN_SURVEY0x80000000Set in primtarget if this is a special program target

Sectarget

Which type of objects do you want returned from your query? (Here, the object type is from the spectroscopic target selection algorithms, where the objects have been classified photometrically or by matchup with other catalogs.) (secondary target categories)

The secTarget field is a bit mask specifying which primary target categories the object was selected in. If you select one or more bits in the At least one of these bits ON menu, then the bit-wise OR of each of those bits is computed and it must be greater than 0. If you select one or more of the bits in the All of these bits OFF menu, then the bit-wise AND of all those bits is computed and it must be equal to 0.

The bits are defined as:

namevaluedescription
REDDEN_STD0x00000002reddening standard star
TEST_TARGET0x00000004a test target
QA0x00000008quality assurance target
SKY0x00000010sky target
SPECTROPHOTO_STD0x00000020spectrophotometry standard (typically an F-star)
GUIDE_STAR0x00000040guide star hole
BUNDLE_HOLE0x00000080fiber bundle hole
QUALITY_HOLE0x00000100hole drilled for plate shop quality measurements
HOT_STD0x00000200hot standard star
SEGUE2_CLUSTER0x00000400SEGUE-2 stellar cluster target
SEGUE2_STETSON0x00000800SEGUE-2 Stetson standard target
SOUTHERN_SURVEY0x80000000SEGUE-2 checked object or a SEGUE-1/southern survey target

BossTarget

The boss_target1 field is a bit mask specifying which BOSS target categories the object was selected in. If you select one or more bits in the At least one of these bits ON menu, then the bit-wise OR of each of those bits is computed and it must be greater than 0. If you select one or more of the bits in the All of these bits OFF menu, then the bit-wise AND of all those bits is computed and it must be equal to 0.

The bits are defined as:

namevaluedescription
GAL_CMASS0x0000000000000002dperp > 0.55, color-mag cut
GAL_CMASS_COMM0x0000000000000004dperp > 0.55, commissioning color-mag cut
GAL_CMASS_SPARSE0x0000000000000008GAL_CMASS_COMM & (!GAL_CMASS) & (i < 19.9) sparsely sampled
SDSS_KNOWN0x0000000000000040Matches a known SDSS spectra
GAL_CMASS_ALL0x0000000000000080GAL_CMASS and the entire sparsely sampled region
GAL_IFIBER2_FAINT0x0000000000000100ifiber2 > 21.5, extinction corrected. Used after Nov 2010
QSO_CORE0x0000000000000400restrictive qso selection: commissioning only
QSO_BONUS0x0000000000000800permissive qso selection: commissioning only
QSO_KNOWN_MIDZ0x0000000000001000known qso between [2.2,9.99]
QSO_KNOWN_LOHIZ0x0000000000002000known qso outside of miz range. never target
QSO_NN0x0000000000004000Neural Net that match to sweeps/pass cuts
QSO_UKIDSS0x0000000000008000UKIDSS stars that match sweeps/pass flag cuts
QSO_KDE_COADD0x0000000000010000kde targets from the stripe82 coadd
QSO_LIKE0x0000000000020000likelihood method
QSO_FIRST_BOSS0x0000000000040000FIRST radio match
QSO_KDE0x0000000000080000selected by kde+chi2
STD_FSTAR0x0000000000100000standard f-stars
STD_WD0x0000000000200000white dwarfs
STD_QSO0x0000000000400000qso
TEMPLATE_GAL_PHOTO0x0000000100000000galaxy templates
TEMPLATE_QSO_SDSS10x0000000200000000QSO templates
TEMPLATE_STAR_PHOTO0x0000000400000000stellar templates
TEMPLATE_STAR_SPECTRO0x0000000800000000stellar templates (spectroscopically known)
QSO_CORE_MAIN0x0000010000000000Main survey core sample
QSO_BONUS_MAIN0x0000020000000000Main survey bonus sample
QSO_CORE_ED0x0000040000000000Extreme Deconvolution in Core
QSO_CORE_LIKE0x0000080000000000Likelihood that make it into core
QSO_KNOWN_SUPPZ0x0000100000000000known qso between [1.8,2.15]

EbossTarget

The eboss_target0 field is a bit mask specifying which EBOSS target categories the object was selected in. If you select one or more bits in the At least one of these bits ON menu, then the bit-wise OR of each of those bits is computed and it must be greater than 0. If you select one or more of the bits in the All of these bits OFF menu, then the bit-wise AND of all those bits is computed and it must be equal to 0.

The bits are defined as:

namevaluedescription
LRG_IZW0x0000000000000002LRG selection in i/z/W plane (11,778 fibers)
LRG_RIW0x0000000000000004LRG selection in r/i/W plane with (i-z) cut (11,687 fibers)
QSO_EBOSS_CORE0x0000000000000400QSOs in XDQSOz+WISE selection for clustering (19,461 fibers)
QSO_PTF0x0000000000000800QSOs with variability in PTF imaging (13,232 fibers)
QSO_REOBS0x0000000000001000QSOs from BOSS to be reobserved (1,368 fibers)
QSO_EBOSS_KDE0x0000000000002000KDE-selected QSOs (SEQUELS only) (11,843)
QSO_EBOSS_FIRST0x0000000000004000Objects with FIRST radio matches (293 fibers)
QSO_BAD_BOSS0x0000000000008000QSOs from BOSS with bad spectra (59)
QSO_BOSS_TARGET0x0000000000010000Known TARGETS from BOSS with spectra (59 fibers)
QSO_SDSS_TARGET0x0000000000020000Known TARGETS from SDSS with spectra
QSO_KNOWN0x0000000000040000Known QSOs from previous surveys
DR9_CALIB_TARGET0x0000000000080000Target found in DR9-calibrated imaging (28,602 fibers)
SPIDERS_RASS_AGN0x0000000000100000RASS AGN sources (162 fibers)
SPIDERS_RASS_CLUS0x0000000000200000RASS cluster sources
TDSS_A0x0000000040000000Main PanSTARRS selection for TDSS (9,418 fibers)
TDSS_FES_DE0x0000000080000000TDSS Few epoch spectroscopy (42 fibers)
TDSS_FES_DWARFC0x0000000100000000TDSS Few epoch spectroscopy (19 fibers)
TDSS_FES_NQHISN0x0000000200000000TDSS Few epoch spectroscopy (74 fibers)
TDSS_FES_MGII0x0000000400000000TDSS Few epoch spectroscopy (1 target)
TDSS_FES_VARBAL0x0000000800000000TDSS Few epoch spectroscopy (62 fibers)
SEQUELS_PTF_VARIABLE0x0000010000000000Variability objects from PTF (701 fibers)
SEQUELS_COLLIDED0x0000020000000000Collided galaxies from BOSS

Imaging Constraints

Which imaging constraints (if any) do you want applied to your query?


Sky Version

You may constrain your search using either the values of the imaging parameters used in spectroscopic target selection ("Target") or the "latest and greatest" values of the imaging parameters ("Best"). See also the glossary item for Sky Version .

Magnitude Type

Further, your may constrain your search using either:
  1. Petrosian magnitudes and colors,
  2. PSF magnitudes and colors, or
  3. model magnitudes and colors.
Important: Please read the documentation on "Which magnitude should I use?"

Magnitudes

Do you want to search over given range in u, g, r, i, and/or z magnitudes?


Colors

Do you want to search over given range in u-g, g-r, r-i, and/or i-z colors?


Object Type

Which type of objects do you want returned from your query? (Here, the object type is the classification from the photometric pipeline, and are based upon how well an object matches a stellar, de Vaucouleurs, or exponential profile.)

The object types are:

  • Extended Sources (e.g., galaxies)
  • Point Sources (e.g., stars, QSOs)
  • Sky Fibers (sky)
  • Unknown (?)

Photometric Quality

You can restrict the search to objects that have minimum photometric quality as determined by the score column in the PhotoObjAll table. The possible values of score are 0 and 1 (0=BAD, 1=ACCEPTABLE). Independently of this constraint, you may also opt to return the score value from the PhotoObjAll table for each object in your search, by checking the "Return value" checkbox. If no value is entered in the "Match Score" box, no quality constraint will be applied but the score will still be returned with your query results.


Photo Flags

Which set of object flags (from photo) do wish to query on?

These flags are discussed in more detail in the document "Understanding the SDSS Image Data Processing Flags".

Photo flags can be set (ON) or (OFF). If you select one or more flags in the At least one of these flags ON menu, then the bit-wise OR of each of those flag bits is computed and it must be greater than 0. If you select one or more of the flags in the All of these flags OFF menu, then the bit-wise AND of all those flag bits is computed and it must be equal to 0.

The object photo flags are:

namevaluedescription
BRIGHT0x0000000000000002Object detected in first, bright object-finding; generally r*<17.5
EDGE0x0000000000000004Object is too close to edge of frame
BLENDED0x0000000000000008Object had multiple peaks detected within it; was thus a candidate to be a deblending parent.
CHILD0x0000000000000010Object is the product of an attempt to deblend a BLENDED object.
PEAKCENTER0x0000000000000020Given center is position of peak pixel, rather than based on the maximum-likelihood estimator.
NODEBLEND0x0000000000000040No deblending was attempted on this object, even though it is BLENDED.
NOPROFILE0x0000000000000080Object was too small or too close to the edge to estimate a radial profile.
NOPETRO0x0000000000000100No valid Petrosian radius was found for this object.
MANYPETRO0x0000000000000200More than one Petrosian radius was found.
NOPETRO_BIG0x0000000000000400Petrosian radius is beyond the last point in the radial profile.
DEBLEND_TOO_MANY_PEAKS0x0000000000000800There were more than 25 peaks in this object to deblend; deblended brightest 25.
COSMIC_RAY0x0000000000001000Contains a pixel interpreted to be part of a cosmic ray.
MANYR500x0000000000002000Object has more than one 50% light radius.
MANYR900x0000000000004000Object has more than one 90% light radius.
BAD_RADIAL0x0000000000008000Some of the points in the given radial profile have negative signal-to-noise ratio. Not a significant parameter.
INCOMPLETE_PROFILE0x0000000000010000Petrosian radius intersects the edge of the frame.
INTERP0x0000000000020000Object contains one or more pixels whose values were determined by interpolation.
SATURATED0x0000000000040000Object contains one or more saturated pixels
NOTCHECKED0x0000000000080000There are pixels in the object which were not checked to see if they included a local peak, such as cores of saturated stars.
SUBTRACTED0x0000000000100000This BRIGHT object had its wings subtracted from the frame
NOSTOKES0x0000000000200000Object has no measured Stokes params
BADSKY0x0000000000400000The sky level is so bad that the highest pixel in the object is very negative; far more so than a mere non-detection. No further analysis is attempted.
PETROFAINT0x0000000000800000At least one possible Petrosian radius was rejected as the surface brightness at r_P was too low. If NOPETRO is not set, a different, acceptable Petrosian radius was found.
TOO_LARGE0x0000000001000000The object is too large for us to measure its profile (it extends beyond a radius of approximately 260), or at least one child is larger than half a frame.
DEBLENDED_AS_PSF0x0000000002000000Deblender treated obj as PSF
DEBLEND_PRUNED0x0000000004000000At least one child was removed because its image was too similar to a supposedly different child.
ELLIPFAINT0x0000000008000000Object center is fainter than the isophote whose shape is desired, so the isophote properties are not measured. Also flagged if profile is incomplete.
BINNED10x0000000010000000Object was detected in 1x1 binned image
BINNED20x0000000020000000Object was detected in 2x2 binned image, after unbinned detections are replaced by background.
BINNED40x0000000040000000Object was detected in 4x4 binned image
MOVED0x0000000080000000The deblender identified this object as possibly moving.
DEBLENDED_AS_MOVING0x0000000100000000A MOVED object that the deblender treated as moving.
NODEBLEND_MOVING0x0000000200000000A MOVED object that the deblender did not treat as moving.
TOO_FEW_DETECTIONS0x0000000400000000A child of this object was not detected in enough bands to reliably deblend as moving.
BAD_MOVING_FIT0x0000000800000000Moving fit too poor to be believable.
STATIONARY0x0000001000000000This object was consistent with being stationary.
PEAKS_TOO_CLOSE0x0000002000000000At least some peaks within this object were too close to be deblended, thus they were merged into a single peak.
MEDIAN_CENTER0x0000004000000000Center given is of median-smoothed image.
LOCAL_EDGE0x0000008000000000Center in at least one band is too close to an edge.
BAD_COUNTS_ERROR0x0000010000000000An object containing interpolated pixels had too few good pixels to form a reliable estimate of its error; the quoted error may be underestimated.
BAD_MOVING_FIT_CHILD0x0000020000000000A possible moving child's velocity fit was too poor, so it was discarded and the parent was not deblended as moving.
DEBLEND_UNASSIGNED_FLUX0x0000040000000000After deblending, a significant fraction of flux was not assigned to any children.
SATUR_CENTER0x0000080000000000Object center is close to at least one saturated pixel.
INTERP_CENTER0x0000100000000000Object center is close to at least one interpolated pixel.
DEBLENDED_AT_EDGE0x0000200000000000An object close enough to the edge of the frame normally not deblended, is deblended anyway. Only set for objects large enough to be EDGE in all fields/strips.
DEBLEND_NOPEAK0x0000400000000000There was no detected peak within this child in at least one band.
PSF_FLUX_INTERP0x0000800000000000Greater than 20% of the PSF flux is from interpolated pixels.
TOO_FEW_GOOD_DETECTIONS0x0001000000000000A child of this object had too few good detections to be deblended as moving.
CENTER_OFF_AIMAGE0x0002000000000000At least one peak's center lay off of the atlas image. This can happen when the object is deblended as moving, or if the astrometry is bad.
DEBLEND_DEGENERATE0x0004000000000000Two or more candidate children were essentially identical; one one was retained.
BRIGHTEST_GALAXY_CHILD0x0008000000000000This child is the brightest family member (in this band) that is classified as a galaxy.
CANONICAL_BAND0x0010000000000000This is the 'canonical' band; r unless the object is undetected in the r filter.
AMOMENT_FAINT0x0020000000000000Object was too faint to measure weighted moments such as mE1_g; unweighted values are reported.
AMOMENT_SHIFT0x0040000000000000Centroid shift too large when measuring adaptive moments. Row/Column shifts are reported in mE1, mE2.
AMOMENT_MAXITER0x0080000000000000Maximum number of iterations exceeded measuring e.g. mE2_g; unweighted values are reported.
MAYBE_CR0x0100000000000000There is reasonable suspicion that this object is actually a cosmic ray.
MAYBE_EGHOST0x0200000000000000There is reasonable suspicion that this object is actually a ghost produced by the CCD electronics.
NOTCHECKED_CENTER0x0400000000000000The center of this object lies in a region that was not searched for objects.
OBJECT2_HAS_SATUR_DN0x0800000000000000The electrons in this saturated object's bleed trails have been included in its estimated flux.
OBJECT2_DEBLEND_PEEPHOLE0x1000000000000000Deblend was modified by the deblender's peephole optimiser.
GROWN_MERGED0x2000000000000000Growing led to a merger
HAS_CENTER0x4000000000000000Object has a canonical center
RESERVED0x8000000000000000Not used