Table information for 'sdssdr16.main'


This table is available for ADQL queries and through the TAP endpoint.

Resource Description: This is a redacted version of the SDSS DR16 table prepared for VizieR (V/154/sdss16). It is mainly here to facilitate local matches; for original SDSS-related research, it is probably better to somewhere else. Over VizieR and SDSS, we are keeping most of the per-band values in arrays to keep the column list manageable. Note that in ADQL, array indexes are 1-based. We are trying to orient our column names on SDSS but use underscores instead of camel-casing (e.g. spec_obj_id instead of SpecObjID), since mixed-case identifiers in SQL is asking for trouble. To save space, we do not keep psf-based classifications, per-band offsets, spectrum metadata, and USNO-related information in this table. Let the operators know if you need any of that.

For a list of all services and tables belonging to this table's resource, see Information on resource 'SDSS DR16 Selection'

Citing this table

This table has an associated publication. If you use data from it, it may be appropriate to reference 2020ApJS..249....3A (ADS BibTeX entry for the publication) either in addition to or instead of the service reference.

To cite the table as such, we suggest the following BibTeX entry:

  title={{SDSS} DR16 Selection},
  author={humada, Romina and Prieto, Carlos Allende and Almeida, Andrés and Anders, Friedrich and Anderson, Scott F. and Andrews, Brett H. and Anguiano, Borja and Arcodia, Riccardo and Armengaud, Eric and Aubert, Marie and Avila, Santiago and Avila-Reese, Vladimir and Badenes, Carles and Balland, Christophe and Barger, Kat and Barrera-Ballesteros, Jorge K. and Basu, Sarbani and Bautista, Julian and Beaton, Rachael L. and Beers, Timothy C. and Benavides, B. Izamar T. and Bender, Chad F. and Bernardi, Mariangela and Bershady, Matthew and Beutler, Florian and Bidin, Christian Moni and Bird, Jonathan and Bizyaev, Dmitry and Blanc, Guillermo A. and Blanton, Michael R. and Boquien, Médéric and Borissova, Jura and Bovy, Jo and Brandt, W. N. and Brinkmann, Jonathan and Brownstein, Joel R. and Bundy, Kevin and Bureau, Martin and Burgasser, Adam and Burtin, Etienne and Cano-Díaz, Mariana and Capasso, Raffaella and Cappellari, Michele and Carrera, Ricardo and Chabanier, Solène and Chaplin, William and Chapman, Michael and Cherinka, Brian and Chiappini, Cristina and Doohyun Choi, Peter and et al},
  howpublished={{VO} resource provided by the {GAVO} Data Center}


Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
obj_id Obj_id SDSS unique object identifier [Note 1] N/A;meta.main
ra Ra Right Ascension of the object (ICRS) deg pos.eq.ra;meta.main
dec Dec Declination of the object (ICRS) deg pos.eq.dec;meta.main
ra_err Ra_err Mean error on ra arcsec stat.error;pos.eq.ra
dec_err Dec_err Mean error on dec arcsec stat.error;pos.eq.dec
pm_ra Pm_ra Proper motion along Right Ascension [Note 11] mas/yr;pos.eq.ra
e_pm_ra E_pm_ra Mean error on pmra [Note 11] mas/yr stat.error;;pos.eq.ra
pm_dec Pm_dec Proper motion along Declination [Note 11] mas/yr;pos.eq.dec
pm_dec_err Pm_dec_err Mean error on pmDE. mas/yr stat.error;;pos.eq.dec
pm_sig_ra Pm_sig_ra RMS residual of proper motion fit in RA. [Note 11] mas
pm_sig_dec Pm_sig_dec RMS residual of proper motion fit in Dec. mas
u U Model magnitude in u filter AB scale [Note 7] mag phot.mag;em.opt.U
err_u Err_u Error in the model magnitude in u filter AB scale mag stat.error;phot.mag;em.opt.U
g G Model magnitude in g filter AB scale [Note 7] mag phot.mag;em.opt.V
err_g Err_g Error in the model magnitude in g filter AB scale mag stat.error;phot.mag;em.opt.V
r R Model magnitude in r filter AB scale [Note 7] mag phot.mag;em.opt.R
err_r Err_r Error in the model magnitude in r filter AB scale mag stat.error;phot.mag;em.opt.R
i I Model magnitude in i filter AB scale [Note 7] mag phot.mag;em.opt.I
err_i Err_i Error in the model magnitude in i filter AB scale mag stat.error;phot.mag;em.opt.I
z Z Model magnitude in z filter AB scale [Note 7] mag phot.mag;em.opt.I
err_z Err_z Error in the model magnitude in z filter AB scale mag stat.error;phot.mag;em.opt.I
field_id Field_id The field this object is in. N/A meta.note
mode Mode Photo mode (1=primary, 2=secondary, 3=family, 4=outside) N/A meta.code.class
class Class Type of object (3=galaxy, 6=star) [Note 2] N/A src.class
clean Clean Clean photometry flag (1=clean; 0=unclean) N/A meta.code
photo_flags Photo_flags Photo Object Attribute flags [Note 3] N/A meta.code.error
psfmags Psfmags Array of PSF magnitudes, in ugriz sequence [Note 4] mag phot.mag
psfmag_errs Psfmag_errs Array of the errors of the PSF magnitudes, in ubriz sequence mag stat.error;phot.mag
petmags Petmags Array of Petrosian magnitudes, in ugriz sequence [Note 4] mag phot.mag
petmag_errs Petmag_errs Array of the errors Petrosian magnitudes, in ugriz sequence mag stat.error;phot.mag
petrads Petrads Array of Petrosian radii, in ugriz sequence arcsec phys.angSize;src
petrad_errs Petrad_errs Array of Petrosian radii, in ugriz sequence arcsec stat.error;phys.angSize;src
dev_rads Dev_rads Array of de Vaucouleurs fit radii, in ugriz sequence arcsec phys.angSize;src
dev_abs Dev_abs Array of de Vaucouleurs fit b/a ratios, in ugriz sequence N/A phys.size.axisRatio
dev_phi Dev_phi Array of position angles of de Vaucouleurs fits in ugriz sequence (warning: anything smaller than 0 in here must be considered NULL). deg pos.posAng
flags Flags Array of detection flags, in ugriz sequence [Note 3] N/A meta.code
types Types Array of phototypes (6=Star ; 3=galaxy) in ugriz sequence [Note 2] N/A src.class.starGalaxy
parent_id Parent_id Pointer to parent (if object deblended) N/A
spec_z Spec_z Spectroscopic final redshift (when SpObjID>0) [Note 6] N/A src.redshift
spec_z_err Spec_z_err Mean error on spec_z (negative for bad fit) [Note 6] N/A stat.error
spec_z_warning Spec_z_warning Warning flag on redshift. [Note 9] N/A meta.code
spec_class Spec_class Spectroscopic class: "GALAXY"; "QSO"; "STAR" [Note 6] N/A meta.code.class;pos.parallax.spect
spec_sub_class Spec_sub_class Spectroscopic subclass. [Note 10] N/A src.class
spec_vel_disp Spec_vel_disp Velocity dispersion [Note 6] km/s phys.veloc.dispersion
spec_vel_disp_err Spec_vel_disp_err Mean error on spec_vel_disp [Note 6] km/s stat.error
spec_sn_median Spec_sn_median Median signal-to-noise over all good pixels. [Note 6] N/A em.wl.central;stat.median
photoz_z Photoz_z Photometric redshift estimated by robust fit to nearest neighbors in a reference set [Note 12] N/A src.redshift
photoz_z_err Photoz_z_err Estimated error of the photometric redshift [Note 12] N/A stat.error;src.redshift
photoz_nn_avg_z Photoz_nn_avg_z Average redshift of the nearest neighbors; if significantly different from photoz_z this might be a better estimate than photoz_z N/A src.redshift.phot
photoz_chisq Photoz_chisq Chi-square value for the minimum chi-square template fit [Note 12] N/A stat.value
field_quality Field_quality Quality of the observation: 1=bad; 2=barely acceptable; 3=good [Note 13] N/A meta.code.qual;obs.param;obs
field_mjds Field_mjds Array of dates of observation per ugriz band [Note 13] d time.epoch
sdss_id Sdss_id SDSS object identifier (run-rerun-camcol-field-object) [Note 1] N/A
spectral_id Spectral_id Spectroscopic Plate-MJD-Fiber identifier (plate-mjd-fiberID) N/A

Columns that are parts of indices are marked like this.


The following services may use the data contained in this table:


VO nerds may sometimes need VOResource XML for this table.


Copyright and such:

Please see for the authors' requests on how to cite this material.