sdssdr16.main 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.1300000000obj_idSDSS unique object identifiermeta.id;meta.main12376458768612720721.2376487029592556e+181.237663789570392e+181.2376802409161032e+1812376805313565831161.0longindexedprimaryraRight Ascension of the object (ICRS)degpos.eq.ra;meta.main8.15592e-079.62755191.806352.1833601doubleindexednullabledecDeclination of the object (ICRS)degpos.eq.dec;meta.main-25.0091-10.109913.833862.842684.97911doubleindexednullablera_errMean error on raarcsecstat.error;pos.eq.ra00.001130530.07389110.3449319238.571floatnullabledec_errMean error on decarcsecstat.error;pos.eq.dec00.001108430.07284670.3369759238.571floatnullablepm_raProper motion along Right Ascensionmas/yrpos.pm;pos.eq.ra-4964.48-18.0276016.08253986.860.273693floatnullablee_pm_raMean error on pmramas/yrstat.error;pos.pm;pos.eq.ra002.528835.663022055.030.273693floatnullablepm_decProper motion along Declinationmas/yrpos.pm;pos.eq.dec-4033.23-20.7891012.85252017.10.273693floatnullablepm_dec_errMean error on pmDE.mas/yrstat.error;pos.pm;pos.eq.dec002.528835.663022055.030.273693floatnullablepm_sig_raRMS residual of proper motion fit in RA.masstat.fit.residual0077.6644498.8658362.950.273693floatnullablepm_sig_decRMS residual of proper motion fit in Dec.masstat.fit.residual0074.436504.3458519.070.273693floatnullableuModel magnitude in u filter AB scalemagphot.mag;em.opt.u4.9787917.377723.433426.173637.2390.961699floatnullableerr_uError in the model magnitude in u filter AB scalemagstat.error;phot.mag;em.opt.u2.65705e-070.01006090.6128051.684961984.410.961699floatnullablegModel magnitude in g filter AB scalemagphot.mag;em.opt.v4.9384215.856822.449225.524239.09720.95831floatnullableerr_gError in the model magnitude in g filter AB scalemagstat.error;phot.mag;em.opt.v3.93157e-080.003757220.1508460.855073894.4170.95831floatnullablerModel magnitude in r filter AB scalemagphot.mag;em.opt.r5.2685515.206821.364124.953337.92830.965748floatnullableerr_rError in the model magnitude in r filter AB scalemagstat.error;phot.mag;em.opt.r1.66778e-070.003584960.08796560.765091684.6430.965748floatnullableiModel magnitude in i filter AB scalemagphot.mag;em.opt.i4.5105914.977920.7124.408638.05220.96356floatnullableerr_iError in the model magnitude in i filter AB scalemagstat.error;phot.mag;em.opt.i1.53781e-070.003719770.07318130.719741480.1930.96356floatnullablezModel magnitude in z filter AB scalemagphot.mag;em.opt.i4.1633214.682720.250723.205436.61830.960951floatnullableerr_zError in the model magnitude in z filter AB scalemagstat.error;phot.mag;em.opt.i2.04563e-070.005017460.1767141.011911041.670.960951floatnullablefield_idThe field this object is in.meta.note12376458768612720641.2376487029592556e+181.237663789570392e+181.2376802409161032e+1812376805313565818881.0longmodePhoto mode (1=primary, 2=secondary, 3=family, 4=outside)meta.code.class11.02.04.041.0shortclassType of object (3=galaxy, 6=star)src.class00.06.06.081.0shortindexedcleanClean photometry flag (1=clean; 0=unclean)meta.code00.00.01.011.0shortphoto_flagsPhoto Object Attribute flagsmeta.code.error26843545668987912192.0105622137864208.0545426790027536.013712737918332485901.0longpsfmagsArray of PSF magnitudes, in ugriz sequencemagphot.magfloatnullablepsfmag_errsArray of the errors of the PSF magnitudes, in ubriz sequencemagstat.error;phot.magfloatnullablepetmagsArray of Petrosian magnitudes, in ugriz sequencemagphot.magfloatnullablepetmag_errsArray of the errors Petrosian magnitudes, in ugriz sequencemagstat.error;phot.magfloatnullablepetradsArray of Petrosian radii, in ugriz sequencearcsecphys.angSize;srcfloatnullablepetrad_errsArray of Petrosian radii, in ugriz sequencearcsecstat.error;phys.angSize;srcfloatnullabledev_radsArray of de Vaucouleurs fit radii, in ugriz sequencearcsecphys.angSize;srcfloatnullabledev_absArray of de Vaucouleurs fit b/a ratios, in ugriz sequencephys.size.axisRatiofloatnullabledev_phiArray of position angles of de Vaucouleurs fits in ugriz sequence (warning: anything smaller than 0 in here must be considered NULL).degpos.posAngfloatnullableflagsArray of detection flags, in ugriz sequencemeta.codelongnullabletypesArray of phototypes (6=Star ; 3=galaxy) in ugriz sequencesrc.class.starGalaxyshortnullableparent_idPointer to parent (if object deblended)meta.id.parent12376458768612720691.2376487040566077e+181.2376653303895163e+181.237680241432265e+1812376805313565830380.40204456longnullablespec_zSpectroscopic final redshift (when SpObjID>0)src.redshift-0.0101934-0.0004861680.4277882.473757.013090.00374838floatindexednullablespec_z_errMean error on spec_z (negative for bad fit)stat.error-67.32932e-069.20743e-050.00103451235.310.00374838floatnullablespec_z_warningWarning flag on redshift.meta.code00.00.04.09020.0037483769shortnullablespec_classSpectroscopic class: "GALAXY"; "QSO"; "STAR"meta.code.class;pos.parallax.spectcharnullablespec_sub_classSpectroscopic subclass.src.classcharnullablespec_vel_dispVelocity dispersionkm/sphys.veloc.dispersion00131.81685.7348500.00339887floatnullablespec_vel_disp_errMean error on spec_vel_dispkm/sstat.error-7014.4179120.2632262.740.00339887floatnullablespec_sn_medianMedian signal-to-noise over all good pixels.em.wl.central;stat.median-1926.590.7174153.7563641.6322131.2360.00339887floatnullablephotoz_zPhotometric redshift estimated by robust fit to nearest neighbors in a reference setsrc.redshift0.00050.111430.4410590.86923510.150934floatindexednullablephotoz_z_errEstimated error of the photometric redshiftstat.error;src.redshift0.0033940.0296170.0899910.1848210.2915180.150934floatnullablephotoz_nn_avg_zAverage redshift of the nearest neighbors; if significantly different from photoz_z this might be a better estimate than photoz_zsrc.redshift.phot0.010190.1366740.4118340.7034550.8010410.169369floatnullablephotoz_chisqChi-square value for the minimum chi-square template fitstat.value8.32632e-120.4042688.0555898.36123.27581e+070.169369floatnullablefield_qualityQuality of the observation: 1=bad; 2=barely acceptable; 3=goodmeta.code.qual;obs.param;obs11.03.03.031.0shortfield_mjdsArray of dates of observation per ugriz banddtime.epochdoublenullablesdss_idSDSS object identifier (run-rerun-camcol-field-object)meta.idcharnullablespectral_idSpectroscopic Plate-MJD-Fiber identifier (plate-mjd-fiberID)meta.idcharnullable