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
CrossMatch ID
SkyQuery CrossMatch
More Tools
Overview
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
Contact
Overview
SQL Search
Rectangular Search
Radial Search
Imaging Search
Spectroscopic Search
IR Spectroscopic Search
IR Spectroscopic Search
Output Format
HTML
CSV
XML
JSON
VOTable
FITS
MyDB
Table Name
Limit number of output rows (0 for max) to:
Parameters to return
Infrared Spectra
Minimal
Typical
andflag
apogee_id
apogee_target1
apogee_target2
apogee_target3
apogee2_target1
apogee2_target2
apogee2_target3
apstar_id
apstar_version
chi2_threshold
dec
extratarg
field
file
glat
glon
htmID
location_id
max_h
max_jk
min_h
min_jk
nvisits
ra
reduction_id
rv_autofwhm
rv_ccfwhm
rv_feh
rv_logg
rv_teff
snr
stablerv_chi2
stablerv_chi2_prob
stablerv_rchi2
starflag
survey
synthscatter
synthverr
synthverr_med
synthvhelio_avg
synthvscatter
target_id
telescope
verr
verr_med
vhelio_avg
vscatter
2MASS J
2MASS H
2MASS K_s
Position Constraints
positionType
Ra / Dec
Galactic Coordinates
None
RA
Dec
l
b
radius arcmins (max 30')
radius arcmins (max 30')
Infrared Spectroscopy Constraints
IR Magnitudes
J range
-
H range
-
Ks range
-
IR Colors
J-H range
-
H-Ks range
-
Observational Parameters
SNR range
-
Vhelio range
-
Scatter in V range
-
Stellar Parameters
Temp range
-
log(g) range
-
[M/H] range
-
[alpha;/Fe] range
-
Targeting Flags #1 (APOGEE_TARGET1)
At least one of these flags ON
ignore
APOGEE_IRAC_DERED
APOGEE_WISE_DERED
APOGEE_SFD_DERED
APOGEE_NO_DERED
APOGEE_WASH_GIANT
APOGEE_WASH_DWARF
APOGEE_SCI_CLUSTER
APOGEE_EXTENDED
APOGEE_SHORT
APOGEE_INTERMEDIATE
APOGEE_LONG
APOGEE_SERENDIPITOUS
APOGEE_FIRST_LIGHT
APOGEE_ANCILLARY
APOGEE_M31_CLUSTER
APOGEE_MDWARF
APOGEE_HIRES
APOGEE_OLD_STAR
APOGEE_DISK_RED_GIANT
APOGEE_KEPLER_EB
APOGEE_GC_PAL1
APOGEE_MASSIVE_STAR
APOGEE_SGR_DSPH
APOGEE_KEPLER_SEISMO
APOGEE_KEPLER_HOST
APOGEE_FAINT_EXTRA
APOGEE_SEGUE_OVERLAP
At least one of these flags OFF
ignore
APOGEE_IRAC_DERED
APOGEE_WISE_DERED
APOGEE_SFD_DERED
APOGEE_NO_DERED
APOGEE_WASH_GIANT
APOGEE_WASH_DWARF
APOGEE_SCI_CLUSTER
APOGEE_EXTENDED
APOGEE_SHORT
APOGEE_INTERMEDIATE
APOGEE_LONG
APOGEE_SERENDIPITOUS
APOGEE_FIRST_LIGHT
APOGEE_ANCILLARY
APOGEE_M31_CLUSTER
APOGEE_MDWARF
APOGEE_HIRES
APOGEE_OLD_STAR
APOGEE_DISK_RED_GIANT
APOGEE_KEPLER_EB
APOGEE_GC_PAL1
APOGEE_MASSIVE_STAR
APOGEE_SGR_DSPH
APOGEE_KEPLER_SEISMO
APOGEE_KEPLER_HOST
APOGEE_FAINT_EXTRA
APOGEE_SEGUE_OVERLAP
Targeting Flags #2 (APOGEE_TARGET2)
At least one of these flags ON
ignore
APOGEE_FLUX_STANDARD
APOGEE_STANDARD_STAR
APOGEE_RV_STANDARD
SKY
APOGEE_TELLURIC
APOGEE_CALIB_CLUSTER
APOGEE_BULGE_GIANT
APOGEE_BULGE_SUPER_GIANT
At least one of these flags OFF
ignore
APOGEE_FLUX_STANDARD
APOGEE_STANDARD_STAR
APOGEE_RV_STANDARD
SKY
APOGEE_TELLURIC
APOGEE_CALIB_CLUSTER
APOGEE_BULGE_GIANT
APOGEE_BULGE_SUPER_GIANT