Sloan-Digital-Sky-Survey-DR16 (Q6036555)

Feedback: Mukharbek Organokov organokov.mgmail.com\NContext\NSloan Digital Sky Survey current DR16 Server Data release with Galaxies, Stars and Quasars.\NLicense: Creative Commons Attribution license (CC-BY) More datailes here. Find more here.\NContent\NThe table results from a query which joins two tables: \N\N"PhotoObj" which contains photometric data \N"SpecObj" which contains spectral data.\N\N16 variables (double) and 1 additional variable (char) 'class'.\NA class object can be predicted from the other 16 variables.\NVariables description: \Nobjid = Object Identifier \Nra = J2000 Right Ascension (r-band) \Ndec = J2000 Declination (r-band) \Nu = better of deV/Exp magnitude fit (u-band) \Ng = better of deV/Exp magnitude fit (g-band) \Nr = better of deV/Exp magnitude fit (r-band) \Ni = better of deV/Exp magnitude fit (i-band) \Nz = better of deV/Exp magnitude fit (z-band) \Nrun = Run Number \Nrerun = Rerun Number \Ncamcol = Camera column \Nfield = Field number \Nspecobjid = Object Identifier \Nclass = object class (galaxy, star or quasar object) \Nredshift = Final Redshift \Nplate = plate number \Nmjd = MJD of observation \Nfiberid = fiberID \NComments\N\NA four-color UVGR intermediate-band photometric system (Thuan-Gunn astronomic magnitude system) is discussed in [1]. The Sloan Digital Sky Survey (SDSS) photometric system, a new five-color (u g r i z) wide-band CCD system is described in [2] \NThe variables 'run', 'rerun', 'camcol' and 'field' features which describe a field within an image taken by the SDSS. A field is basically a part of the entire image corresponding to 2048 by 1489 pixels. A field can be identified by: - run number, which identifies the specific scan, - the camera column, or "camcol," a number from 1 to 6, identifying the scanline within the run, and the field number. The field number typically starts at 11 (after an initial rampup time), and can be as large as 800 for particularly long runs. - An additional number, rerun, specifies how the image was processed. \NThe variable 'class' identifies an object to be either a galaxy (GALAXY), star (STAR) or quasar (QSO). \N\NReferences:\N[1] Thuan Gunn (1976, PASP, 88,543) \N[2] Fukugita, M. et al, Astronomical J. v.111, p.1748 \NData server\NData can be obtained using SkyServer SQL Search with the command below: \N-- This query does a table JOIN between the imaging (PhotoObj) and spectra \N-- (SpecObj) tables and includes the necessary columns in the SELECT to upload \N-- the results to the SAS (Science Archive Server) for FITS file retrieval. \NSELECT TOP 100000 \N p.objid,p.ra,p.dec,p.u,p.g,p.r,p.i,p.z, \N p.run, p.rerun, p.camcol, p.field, \N s.specobjid, s.class, s.z as redshift, \N s.plate, s.mjd, s.fiberid \NFROM PhotoObj AS p \N JOIN SpecObj AS s ON s.bestobjid = p.objid \NWHERE \N p.u BETWEEN 0 AND 19.6 \N AND g BETWEEN 0 AND 20 \NLearn how to. Some examples. Full SQL Tutorial. \NOr perform a complicated, CPU-intensive query of SDSS catalog data using CasJobs, SQL-based interface to the CAS. \NAcknowledgements\NSDSS collaboration.\NInspiration\NThe Sloan Digital Sky Survey has created the most detailed three-dimensional maps of the Universe ever made, with deep multi-color images of one-third of the sky, and spectra for more than three million astronomical objects. It allows to learn and explore all phases and surveys - past, present, and future - of the SDSS.