GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
GAMA head image
DR2 > Query > SQL query

SQL Query Results

Processing your query... Done!

Your query:
SELECT * FROM SpecAll LIMIT 5
resulted in 5 records.


Processing results . . . . . Done!

Download the result file: GAMA_HzVs28.fits      

The result set is also shown below.
Hover over a column name to get its description.

SPECIDUnique ID of spectrum SURVEYSurvey this spectrum originated from SURVEY_CODENumerical code for originating survey RARA of spectrum (J2000) DECDEC of spectrum (J2000) WMINMinimum wavelength of spectrum WMAXMaximum wavelength of spectrum ZHeliocentric redshift NQNormalised redshift quality (use nQ > 2 for science) PROBProbability that redshift is correct FILENAMEFull path and filename of the spectrum URLURL of the spectrum URL_IMGURL of the spectrum`s image CATAIDID of matched GAMA object GAMA_NAMEName of matched GAMA object IC_FLAGCatalogue source(s) of matched GAMA object DISTDistance between spectrum and matched GAMA object IS_SBESTIs this the best spectrum of this GAMA object within the originating survey? IS_BESTIs this the best spectrum of this GAMA object?
deg deg A A arcsec
131671727225700352 SDSS 1 132.16668 -0.58222 3797.52 9221.47 0.18984 5 0.998 /GAMA/dr2/data/spectra/sdss/spSpec-51901-0467-001.fit Download file View image 549638 GAMAJ084840.00-003456.0 3 0.1 1 1
131671727229894656 SDSS 1 132.17204 -0.20192 3797.52 9221.47 0.19219 5 0.999 /GAMA/dr2/data/spectra/sdss/spSpec-51901-0467-002.fit Download file View image 536565 GAMAJ084841.29-001207.0 3 0.13 1 1
131671727246671872 SDSS 1 132.24395 -0.57948 3797.52 9221.47 0.23084 4 0.999 /GAMA/dr2/data/spectra/sdss/spSpec-51901-0467-006.fit Download file View image 549654 GAMAJ084858.54-003446.2 3 0.13 1 1
131671727255060480 SDSS 1 132.1767 0.08723 3797.52 9221.47 0.09731 5 1 /GAMA/dr2/data/spectra/sdss/spSpec-51901-0467-008.fit Download file View image 209184 GAMAJ084842.41+000514.0 3 0.06 1 1
131671727267643392 SDSS 1 132.63599 -0.25283 3797.52 9221.47 0.06977 5 0.999 /GAMA/dr2/data/spectra/sdss/spSpec-51901-0467-011.fit Download file View image 203114 GAMAJ085032.63-001510.1 3 0.05 1 1

the objects identified in column SPECID in the Single Object Viewer.

the objects identified in column CATAID in the Single Object Viewer.

the positions identified by columns RA,DEC to the SDSS Image List tool (opens two tabs, ignore the second, i.e. close it).

the files named in the column FILENAME as a single gzipped tarfile.