Home
Visual Tools
Overview
Navigate
Explore
Finding Chart
Quick Look
Image List
Search Tools
Overview
SQL Search
Rectangular Search
Radial Search
Imaging Search
Spectroscopic Search
IR Spectroscopic Search
CrossMatch Tools
Overview
Cross-Match
CrossMatch ID
More Tools
Overview
My History
Schema Browser
Scrolling Sky
Get Fields
Get Spectra
Get Plates
Support
Overview
About the Data
Schema Browser
Sample Queries
SQL in SkyServer
Query Advice
APIs
SQL Tutorial (DR16)
Contact
CasJobs
Sign In
Overview
SQL Search
Rectangular Search
Radial Search
Imaging Search
Spectroscopic Search
IR Spectroscopic Search
Imaging Search
Output Format
HTML
CSV
XML
JSON
VOTable
FITS
MyDB
Table Name
Limit number of output rows (0 for max) to:
Parameters to return
Imaging
minimal
typical
radec
model_mags
model_magerrs
psf_mags
psf_magerrs
petro_mags
petro_magerrs
model_colors
ugModelColor
grModelColor
riModelColor
izModelColor
SDSSname
airmass_g
airmass_i
airmass_r
airmass_u
airmass_z
aperFlux7_g
aperFlux7_i
aperFlux7_r
aperFlux7_u
aperFlux7_z
aperFlux7Ivar_g
aperFlux7Ivar_i
aperFlux7Ivar_r
aperFlux7Ivar_u
aperFlux7Ivar_z
b
balkanId
calibStatus_g
calibStatus_i
calibStatus_r
calibStatus_u
calibStatus_z
camcol
clean
cloudCam_g
cloudCam_i
cloudCam_r
cloudCam_u
cloudCam_z
cModelFlux_g
cModelFlux_i
cModelFlux_r
cModelFlux_u
cModelFlux_z
cModelFluxIvar_g
cModelFluxIvar_i
cModelFluxIvar_r
cModelFluxIvar_u
cModelFluxIvar_z
cModelMag_g
cModelMag_i
cModelMag_r
cModelMag_u
cModelMag_z
cModelMagErr_g
cModelMagErr_i
cModelMagErr_r
cModelMagErr_u
cModelMagErr_z
colc
colc_g
colc_i
colc_r
colc_u
colc_z
colcErr
colcErr_g
colcErr_i
colcErr_r
colcErr_u
colcErr_z
colv
colvErr
cx
cy
cz
dec
decErr
dered_g
dered_i
dered_r
dered_u
dered_z
deVAB_g
deVAB_i
deVAB_r
deVAB_u
deVAB_z
deVABErr_g
deVABErr_i
deVABErr_r
deVABErr_u
deVABErr_z
deVFlux_g
deVFlux_i
deVFlux_r
deVFlux_u
deVFlux_z
deVFluxIvar_g
deVFluxIvar_i
deVFluxIvar_r
deVFluxIvar_u
deVFluxIvar_z
deVMag_g
deVMag_i
deVMag_r
deVMag_u
deVMag_z
deVMagErr_g
deVMagErr_i
deVMagErr_r
deVMagErr_u
deVMagErr_z
deVPhi_g
deVPhi_i
deVPhi_r
deVPhi_u
deVPhi_z
deVRad_g
deVRad_i
deVRad_r
deVRad_u
deVRad_z
deVRadErr_g
deVRadErr_i
deVRadErr_r
deVRadErr_u
deVRadErr_z
err_g
err_i
err_r
err_u
err_z
expAB_g
expAB_i
expAB_r
expAB_u
expAB_z
expABErr_g
expABErr_i
expABErr_r
expABErr_u
expABErr_z
expFlux_g
expFlux_i
expFlux_r
expFlux_u
expFlux_z
expFluxIvar_g
expFluxIvar_i
expFluxIvar_r
expFluxIvar_u
expFluxIvar_z
expMag_g
expMag_i
expMag_r
expMag_u
expMag_z
expMagErr_g
expMagErr_i
expMagErr_r
expMagErr_u
expMagErr_z
expPhi_g
expPhi_i
expPhi_r
expPhi_u
expPhi_z
expRad_g
expRad_i
expRad_r
expRad_u
expRad_z
expRadErr_g
expRadErr_i
expRadErr_r
expRadErr_u
expRadErr_z
extinction_g
extinction_i
extinction_r
extinction_u
extinction_z
fiber2Flux_g
fiber2Flux_i
fiber2Flux_r
fiber2Flux_u
fiber2Flux_z
fiber2FluxIvar_g
fiber2FluxIvar_i
fiber2FluxIvar_r
fiber2FluxIvar_u
fiber2FluxIvar_z
fiber2Mag_g
fiber2Mag_i
fiber2Mag_r
fiber2Mag_u
fiber2Mag_z
fiber2MagErr_g
fiber2MagErr_i
fiber2MagErr_r
fiber2MagErr_u
fiber2MagErr_z
fiberFlux_g
fiberFlux_i
fiberFlux_r
fiberFlux_u
fiberFlux_z
fiberFluxIvar_g
fiberFluxIvar_i
fiberFluxIvar_r
fiberFluxIvar_u
fiberFluxIvar_z
fiberMag_g
fiberMag_i
fiberMag_r
fiberMag_u
fiberMag_z
fiberMagErr_g
fiberMagErr_i
fiberMagErr_r
fiberMagErr_u
fiberMagErr_z
field
fieldID
flags
flags_g
flags_i
flags_r
flags_u
flags_z
fracDeV_g
fracDeV_i
fracDeV_r
fracDeV_u
fracDeV_z
g
htmID
i
insideMask
l
lnLDeV_g
lnLDeV_i
lnLDeV_r
lnLDeV_u
lnLDeV_z
lnLExp_g
lnLExp_i
lnLExp_r
lnLExp_u
lnLExp_z
lnLStar_g
lnLStar_i
lnLStar_r
lnLStar_u
lnLStar_z
loadVersion
mCr4_g
mCr4_i
mCr4_r
mCr4_u
mCr4_z
mCr4PSF_g
mCr4PSF_i
mCr4PSF_r
mCr4PSF_u
mCr4PSF_z
mE1_g
mE1_i
mE1_r
mE1_u
mE1_z
mE1E1Err_g
mE1E1Err_i
mE1E1Err_r
mE1E1Err_u
mE1E1Err_z
mE1E2Err_g
mE1E2Err_i
mE1E2Err_r
mE1E2Err_u
mE1E2Err_z
mE1PSF_g
mE1PSF_i
mE1PSF_r
mE1PSF_u
mE1PSF_z
mE2_g
mE2_i
mE2_r
mE2_u
mE2_z
mE2E2Err_g
mE2E2Err_i
mE2E2Err_r
mE2E2Err_u
mE2E2Err_z
mE2PSF_g
mE2PSF_i
mE2PSF_r
mE2PSF_u
mE2PSF_z
mjd
mode
modelFlux_g
modelFlux_i
modelFlux_r
modelFlux_u
modelFlux_z
modelFluxIvar_g
modelFluxIvar_i
modelFluxIvar_r
modelFluxIvar_u
modelFluxIvar_z
modelMag_g
modelMag_i
modelMag_r
modelMag_u
modelMag_z
modelMagErr_g
modelMagErr_i
modelMagErr_r
modelMagErr_u
modelMagErr_z
mRrCc_g
mRrCc_i
mRrCc_r
mRrCc_u
mRrCc_z
mRrCcErr_g
mRrCcErr_i
mRrCcErr_r
mRrCcErr_u
mRrCcErr_z
mRrCcPSF_g
mRrCcPSF_i
mRrCcPSF_r
mRrCcPSF_u
mRrCcPSF_z
nChild
nDetect
nEdge
nMgyPerCount_g
nMgyPerCount_i
nMgyPerCount_r
nMgyPerCount_u
nMgyPerCount_z
nObserve
nProf_g
nProf_i
nProf_r
nProf_u
nProf_z
obj
objID
offsetDec_g
offsetDec_i
offsetDec_r
offsetDec_u
offsetDec_z
offsetRa_g
offsetRa_i
offsetRa_r
offsetRa_u
offsetRa_z
parentID
petroFlux_g
petroFlux_i
petroFlux_r
petroFlux_u
petroFlux_z
petroFluxIvar_g
petroFluxIvar_i
petroFluxIvar_r
petroFluxIvar_u
petroFluxIvar_z
petroMag_g
petroMag_i
petroMag_r
petroMag_u
petroMag_z
petroMagErr_g
petroMagErr_i
petroMagErr_r
petroMagErr_u
petroMagErr_z
petroR50_g
petroR50_i
petroR50_r
petroR50_u
petroR50_z
petroR50Err_g
petroR50Err_i
petroR50Err_r
petroR50Err_u
petroR50Err_z
petroR90_g
petroR90_i
petroR90_r
petroR90_u
petroR90_z
petroR90Err_g
petroR90Err_i
petroR90Err_r
petroR90Err_u
petroR90Err_z
petroRad_g
petroRad_i
petroRad_r
petroRad_u
petroRad_z
petroRadErr_g
petroRadErr_i
petroRadErr_r
petroRadErr_u
petroRadErr_z
phioffset_g
phioffset_i
phioffset_r
phioffset_u
phioffset_z
probPSF
probPSF_g
probPSF_i
probPSF_r
probPSF_u
probPSF_z
psfFlux_g
psfFlux_i
psfFlux_r
psfFlux_u
psfFlux_z
psfFluxIvar_g
psfFluxIvar_i
psfFluxIvar_r
psfFluxIvar_u
psfFluxIvar_z
psffwhm_g
psffwhm_i
psffwhm_r
psffwhm_u
psffwhm_z
psfMag_g
psfMag_i
psfMag_r
psfMag_u
psfMag_z
psfMagErr_g
psfMagErr_i
psfMagErr_r
psfMagErr_u
psfMagErr_z
q_g
q_i
q_r
q_u
q_z
qErr_g
qErr_i
qErr_r
qErr_u
qErr_z
r
ra
raErr
rerun
resolveStatus
rowc
rowc_g
rowc_i
rowc_r
rowc_u
rowc_z
rowcErr
rowcErr_g
rowcErr_i
rowcErr_r
rowcErr_u
rowcErr_z
rowv
rowvErr
run
score
sky_g
sky_i
sky_r
sky_u
sky_z
skyIvar_g
skyIvar_i
skyIvar_r
skyIvar_u
skyIvar_z
skyVersion
specObjID
TAI_g
TAI_i
TAI_r
TAI_u
TAI_z
thingId
type
type_g
type_i
type_r
type_u
type_z
u
u_g
u_i
u_r
u_u
u_z
uErr_g
uErr_i
uErr_r
uErr_u
uErr_z
z
Spectroscopy
none
minimal
typical
radec
ancillary_target1
ancillary_target2
anyAndMask
anyOrMask
bestObjID
blueFiber
boss_target1
bossPrimary
bossSpecObjID
chi68p
chunk
class
class_noqso
class_person
comments_person
cx
cy
cz
dec
deredSN2
designID
DOF
eboss_target_id
eboss_target0
eboss_target1
eboss_target2
elodieBV
elodieDOF
elodieFeH
elodieFileName
elodieLogG
elodieObject
elodieRChi2
elodieSpType
elodieTEff
elodieZ
elodieZErr
elodieZModelErr
fiberID
firstRelease
fluxObjID
fracNSigHi_1
fracNSigHi_10
fracNSigHi_2
fracNSigHi_3
fracNSigHi_4
fracNSigHi_5
fracNSigHi_6
fracNSigHi_7
fracNSigHi_8
fracNSigHi_9
fracNSigLo_1
fracNSigLo_10
fracNSigLo_2
fracNSigLo_3
fracNSigLo_4
fracNSigLo_5
fracNSigLo_6
fracNSigLo_7
fracNSigLo_8
fracNSigLo_9
fracNSigma_1
fracNSigma_10
fracNSigma_2
fracNSigma_3
fracNSigma_4
fracNSigma_5
fracNSigma_6
fracNSigma_7
fracNSigma_8
fracNSigma_9
htmID
img
instrument
lambdaEff
legacy_target1
legacy_target2
legacyPrimary
loadVersion
mjd
nPoly
plate
plateID
platerun
plateSN2
primTarget
programname
ra
rChi2
rChi2Diff
rChi2Diff_noqso
run1d
run2d
sciencePrimary
sdssPrimary
secTarget
segue1_target1
segue1_target2
segue1Primary
segue2_target1
segue2_target2
segue2Primary
seguePrimary
sn1_g
sn1_i
sn1_r
sn2_g
sn2_i
sn2_r
snMedian
snMedian_g
snMedian_i
snMedian_r
snMedian_u
snMedian_z
snTurnoff
sourceType
special_target1
special_target2
specObjID
spectroFlux_g
spectroFlux_i
spectroFlux_r
spectroFlux_u
spectroFlux_z
spectroFluxIvar_g
spectroFluxIvar_i
spectroFluxIvar_r
spectroFluxIvar_u
spectroFluxIvar_z
spectrographID
spectroSkyFlux_g
spectroSkyFlux_i
spectroSkyFlux_r
spectroSkyFlux_u
spectroSkyFlux_z
spectroSynFlux_g
spectroSynFlux_i
spectroSynFlux_r
spectroSynFlux_u
spectroSynFlux_z
spectroSynFluxIvar_g
spectroSynFluxIvar_i
spectroSynFluxIvar_r
spectroSynFluxIvar_u
spectroSynFluxIvar_z
subClass
subClass_noqso
survey
targetObjID
targetType
tColumn_0
tColumn_1
tColumn_2
tColumn_3
tColumn_4
tColumn_5
tColumn_6
tColumn_7
tColumn_8
tColumn_9
tFile
theta_0
theta_1
theta_2
theta_3
theta_4
theta_5
theta_6
theta_7
theta_8
theta_9
thing_id
thing_id_targeting
tile
velDisp
velDispChi2
velDispDOF
velDispErr
velDispNPix
velDispZ
velDispZErr
waveMax
waveMin
wCoverage
xFocal
yFocal
z
z_noqso
z_person
zErr
zErr_noqso
zOffset
zWarning
zWarning_noqso
Position Constraints
Type of search
rectangular
cone
proximity
none
RA range
-
Dec range
-
Dec
RA
Radius (arcmin - max 30')
List of ra, dec[, radius]
ra,dec,sep 256.443154,58.0255,1.0 29.94136,0.08930,1.0
Type of search:
Nearest Only
All Nearby
Radius (arcmin - max 10')
Upload a file
Imaging Constraints
Magnitude and Color Type
Petro
Model
PSF
Magnitude
u range
-
g range
-
r range
-
i range
-
z range
-
Color
ug range
-
gr range
-
ri range
-
iz range
-
Obj Type
Extended Sources (e.g. Galaxies)
Point Sources (e.g. Stars)
Sky
Unknown
Score
Return Value
Min score (enter value from 0 to 1, e.g. 0.9)
At least one of these flags ON
ignore
CANONICAL_CENTER
BRIGHT
EDGE
BLENDED
CHILD
PEAKCENTER
NODEBLEND
NOPROFILE
NOPETRO
MANYPETRO
NOPETRO_BIG
DEBLEND_TOO_MANY_PEAKS
COSMIC_RAY
MANYR50
MANYR90
BAD_RADIAL
INCOMPLETE_PROFILE
INTERP
SATURATED
NOTCHECKED
SUBTRACTED
NOSTOKES
BADSKY
PETROFAINT
TOO_LARGE
DEBLENDED_AS_PSF
DEBLEND_PRUNED
ELLIPFAINT
BINNED1
BINNED2
BINNED4
MOVED
DEBLENDED_AS_MOVING
NODEBLEND_MOVING
TOO_FEW_DETECTIONS
BAD_MOVING_FIT
STATIONARY
PEAKS_TOO_CLOSE
MEDIAN_CENTER
LOCAL_EDGE
BAD_COUNTS_ERROR
BAD_MOVING_FIT_CHILD
DEBLEND_UNASSIGNED_FLUX
SATUR_CENTER
INTERP_CENTER
DEBLENDED_AT_EDGE
DEBLEND_NOPEAK
PSF_FLUX_INTERP
TOO_FEW_GOOD_DETECTIONS
CENTER_OFF_AIMAGE
DEBLEND_DEGENERATE
BRIGHTEST_GALAXY_CHILD
CANONICAL_BAND
AMOMENT_FAINT
AMOMENT_SHIFT
AMOMENT_MAXITER
MAYBE_CR
MAYBE_EGHOST
NOTCHECKED_CENTER
OBJECT2_HAS_SATUR_DN
OBJECT2_DEBLEND_PEEPHOLE
GROWN_MERGED
HAS_CENTER
RESERVED
All of these flags OFF
ignore
CANONICAL_CENTER
BRIGHT
EDGE
BLENDED
CHILD
PEAKCENTER
NODEBLEND
NOPROFILE
NOPETRO
MANYPETRO
NOPETRO_BIG
DEBLEND_TOO_MANY_PEAKS
COSMIC_RAY
MANYR50
MANYR90
BAD_RADIAL
INCOMPLETE_PROFILE
INTERP
SATURATED
NOTCHECKED
SUBTRACTED
NOSTOKES
BADSKY
PETROFAINT
TOO_LARGE
DEBLENDED_AS_PSF
DEBLEND_PRUNED
ELLIPFAINT
BINNED1
BINNED2
BINNED4
MOVED
DEBLENDED_AS_MOVING
NODEBLEND_MOVING
TOO_FEW_DETECTIONS
BAD_MOVING_FIT
STATIONARY
PEAKS_TOO_CLOSE
MEDIAN_CENTER
LOCAL_EDGE
BAD_COUNTS_ERROR
BAD_MOVING_FIT_CHILD
DEBLEND_UNASSIGNED_FLUX
SATUR_CENTER
INTERP_CENTER
DEBLENDED_AT_EDGE
DEBLEND_NOPEAK
PSF_FLUX_INTERP
TOO_FEW_GOOD_DETECTIONS
CENTER_OFF_AIMAGE
DEBLEND_DEGENERATE
BRIGHTEST_GALAXY_CHILD
CANONICAL_BAND
AMOMENT_FAINT
AMOMENT_SHIFT
AMOMENT_MAXITER
MAYBE_CR
MAYBE_EGHOST
NOTCHECKED_CENTER
OBJECT2_HAS_SATUR_DN
OBJECT2_DEBLEND_PEEPHOLE
GROWN_MERGED
HAS_CENTER
RESERVED