Choose a database in the left panel then select the table you want!
Table: ls_dr8.dr8_north_specobj_dr14
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| allmask_g | Bitwise mask set if the central pixel from all images satisfy each condition in (g) | SMALLINT |
| allmask_r | Bitwise mask set if the central pixel from all images satisfy each condition in (r) | SMALLINT |
| allmask_z | Bitwise mask set if the central pixel from all images satisfy each condition in (z) | SMALLINT |
| anymask_g | Bitwise mask set if the central pixel from any image satisfies each condition in (g) | SMALLINT |
| anymask_r | Bitwise mask set if the central pixel from any image satisfies each condition in (r) | SMALLINT |
| anymask_z | Bitwise mask set if the central pixel from any image satisfies each condition in (z) | SMALLINT |
| apflux_g_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |
| apflux_g_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |
| apflux_g_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |
| apflux_g_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |
| apflux_g_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |
| apflux_g_6 | Aperture fluxes on the co-added images in aperture of radius 3.5arcsec | REAL |
| apflux_g_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |
| apflux_g_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |
| apflux_ivar_g_1 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_2 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_3 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_4 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_5 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_6 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_7 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_g_8 | Inverse variance of FLUX_G | REAL |
| apflux_ivar_r_1 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_2 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_3 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_4 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_5 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_6 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_7 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_r_8 | Inverse variance of FLUX_R | REAL |
| apflux_ivar_z_1 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_2 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_3 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_4 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_5 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_6 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_7 | Inverse variance of FLUX_Z | REAL |
| apflux_ivar_z_8 | Inverse variance of FLUX_Z | REAL |
| apflux_r_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |
| apflux_r_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |
| apflux_r_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |
| apflux_r_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |
| apflux_r_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |
| apflux_r_6 | Aperture fluxes on the co-added images in aperture of radius 3.5 arcsec | REAL |
| apflux_r_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |
| apflux_r_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |
| apflux_resid_g_1 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_2 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_3 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_4 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_5 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_6 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_7 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_g_8 | Aperture fluxes on the co-added residual images in G | REAL |
| apflux_resid_r_1 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_2 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_3 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_4 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_5 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_6 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_7 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_r_8 | Aperture fluxes on the co-added residual images in R | REAL |
| apflux_resid_z_1 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_2 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_3 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_4 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_5 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_6 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_7 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_resid_z_8 | Aperture fluxes on the co-added residual images in Z | REAL |
| apflux_z_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |
| apflux_z_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |
| apflux_z_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |
| apflux_z_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |
| apflux_z_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |
| apflux_z_6 | Aperture fluxes on the co-added images in aperture of radius 3.5 arcsec | REAL |
| apflux_z_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |
| apflux_z_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |
| brick_primary | True if the object is within the brick boundary | SMALLINT |
| brickid | Brick ID [1,662174] | INTEGER |
| brickname | Name of brick, encoding the brick sky position, e.g. 1126p222 near RA=112.6, Dec=+22.2 | VARCHAR |
| brightblob | True if the object shares a blob with a bright (Tycho-2) star | SMALLINT |
| bx | X position (0-indexed) of coordinates in brick image stack | REAL |
| by | Y position (0-indexed) of coordinates in brick image stack | REAL |
| dchisq_1 | Difference in X^2 between successfully more-complex model fits | REAL |
| dchisq_2 | Difference in X^2 between successfully more-complex model fits | REAL |
| dchisq_3 | Difference in X^2 between successfully more-complex model fits | REAL |
| dchisq_4 | Difference in X^2 between successfully more-complex model fits | REAL |
| dchisq_5 | Difference in X^2 between successfully more-complex model fits | REAL |
| dec | Declination at epoch J2000 | DOUBLE |
| dec_ivar | Inverse variance of DEC, excluding astrometric calibration errors | REAL |
| dl_uniqid | DL unique ID | BIGINT |
| dl_uniqid_str | DL unique ID | INTEGER |
| ebv | Galactic extinction (E(B-V)) reddening from SFD98, used to compute DECAM_MW_TRANSMISSION and WISE_MW_TRANSMISSION | REAL |
| elat | Ecliptic Latitude | DOUBLE |
| elon | Ecliptic Longitude | DOUBLE |
| fiberflux_g | Predicted (g)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |
| fiberflux_r | Predicted (r)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |
| fiberflux_z | Predicted (z)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |
| fiberid | Fiber ID | INTEGER |
| fibertotflux_g | Predicted (g)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| fibertotflux_r | Predicted (r)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| fibertotflux_z | Predicted (z)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| flux_g | model flux in (g) | REAL |
| flux_ivar_g | Inverse variance of FLUX_G | REAL |
| flux_ivar_r | Inverse variance of FLUX_R | REAL |
| flux_ivar_w1 | Inverse variance of FLUX_W1 | REAL |
| flux_ivar_w2 | Inverse variance of FLUX_W2 | REAL |
| flux_ivar_w3 | Inverse variance of FLUX_W3 | REAL |
| flux_ivar_w4 | Inverse variance of FLUX_W4 | REAL |
| flux_ivar_z | Inverse variance of FLUX_Z | REAL |
| flux_r | model flux in (r) | REAL |
| flux_w1 | WISE model flux in (W1) | REAL |
| flux_w2 | WISE model flux in (W2) | REAL |
| flux_w3 | WISE model flux in (W3) | REAL |
| flux_w4 | WISE model flux in (W4) | REAL |
| flux_z | model flux in (z) | REAL |
| fracdev | Fraction of model in deVauc [0,1] | REAL |
| fracdev_ivar | Inverse variance of FRACDEV | REAL |
| fracflux_g | Profile-weighted fraction of the flux from other sources divided by the total flux in (g) (typically [0,1]) | REAL |
| fracflux_r | Profile-weighted fraction of the flux from other sources divided by the total flux in (r) (typically [0,1]) | REAL |
| fracflux_w1 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W1) (typically [0,1]) | REAL |
| fracflux_w2 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W2) (typically [0,1]) | REAL |
| fracflux_w3 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W3) (typically [0,1]) | REAL |
| fracflux_w4 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W4) (typically [0,1]) | REAL |
| fracflux_z | Profile-weighted fraction of the flux from other sources divided by the total flux in (z) (typically [0,1]) | REAL |
| fracin_g | Fraction of source flux within the blob in (g), near unity for real sources | REAL |
| fracin_r | Fraction of source flux within the blob in (r), near unity for real sources | REAL |
| fracin_z | Fraction of source flux within the blob in (z), near unity for real sources | REAL |
| fracmasked_g | Profile-weighted fraction of pixels masked from all observations of this object in (g), strictly between [0,1] | REAL |
| fracmasked_r | Profile-weighted fraction of pixels masked from all observations of this object in (r), strictly between [0,1] | REAL |
| fracmasked_z | Profile-weighted fraction of pixels masked from all observations of this object in (z), strictly between [0,1] | REAL |
| gaia_a_g_val | Gaia line-of-sight extinction in the G band | REAL |
| gaia_astrometric_excess_noise | Gaia astrometric excess noise | REAL |
| gaia_astrometric_excess_noise_sireal | Gaia astrometric excess noise uncertainty | REAL |
| gaia_astrometric_n_good_obs_al | Gaia number of good astrometric observations along scan direction | SMALLINT |
| gaia_astrometric_n_obs_al | Gaia number of astrometric observations along scan direction | SMALLINT |
| gaia_astrometric_params_solved | Which astrometric parameters were estimated for a Gaia source | SMALLINT |
| gaia_astrometric_sigma5d_max | Gaia longest semi-major axis of the 5-d error ellipsoid | REAL |
| gaia_astrometric_weight_al | Gaia astrometric weight along scan direction | REAL |
| gaia_duplicated_source | Gaia duplicated source flag | SMALLINT |
| gaia_e_bp_min_rp_val | Gaia line-of-sight reddening E(BP-RP) | REAL |
| gaia_phot_bp_mean_flux_over_erroreal | Gaia BP signal-to-noise | REAL |
| gaia_phot_bp_mean_mag | Gaia BP mag | REAL |
| gaia_phot_bp_n_obs | Gaia BP number of observations | SMALLINT |
| gaia_phot_bp_rp_excess_factor | Gaia BP/RP excess factor | REAL |
| gaia_phot_g_mean_flux_over_errorreal | Gaia G band signal-to-noise | REAL |
| gaia_phot_g_mean_mag | Gaia G band mag | REAL |
| gaia_phot_g_n_obs | Gaia G band number of observations | SMALLINT |
| gaia_phot_rp_mean_flux_over_erroreal | Gaia RP signal-to-noise | REAL |
| gaia_phot_rp_mean_mag | Gaia RP mag | REAL |
| gaia_phot_rp_n_obs | Gaia RP number of observations | SMALLINT |
| gaia_phot_variable_flag | Gaia photometric variable flag | SMALLINT |
| gaia_pointsource | This Gaia-DR2 source is believed to be a star, not a galaxy | SMALLINT |
| galdepth_g | As for PSFDEPTH_G but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |
| galdepth_r | As for PSFDEPTH_R but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |
| galdepth_z | As for PSFDEPTH_Z but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |
| glat | Galactic Latitude | DOUBLE |
| glon | Galactic Longitude | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| lc_flux_ivar_w1_1 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_10 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_11 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_2 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_3 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_4 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_5 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_6 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_7 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_8 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w1_9 | Inverse variance of LC_FLUX_W1 | REAL |
| lc_flux_ivar_w2_1 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_10 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_11 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_2 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_3 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_4 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_5 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_6 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_7 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_8 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_ivar_w2_9 | Inverse variance of LC_FLUX_W2 | REAL |
| lc_flux_w1_1 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_10 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_11 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_2 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_3 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_4 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_5 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_6 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_7 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_8 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w1_9 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_1 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_10 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_11 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_2 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_3 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_4 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_5 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_6 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_7 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_8 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_flux_w2_9 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_1 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_10 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_11 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_2 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_3 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_4 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_5 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_6 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_7 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_8 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w1_9 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_1 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_10 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_11 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_2 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_3 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_4 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_5 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_6 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_7 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_8 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_fracflux_w2_9 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_mjd_w1_1 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_10 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_11 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_2 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_3 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_4 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_5 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_6 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_7 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_8 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w1_9 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_1 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_10 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_11 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_2 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_3 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_4 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_5 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_6 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_7 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_8 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_mjd_w2_9 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |
| lc_nobs_w1_1 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_10 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_11 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_2 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_3 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_4 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_5 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_6 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_7 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_8 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w1_9 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_1 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_10 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_11 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_2 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_3 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_4 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_5 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_6 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_7 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_8 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_nobs_w2_9 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |
| lc_rchisq_w1_1 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_10 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_11 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_2 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_3 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_4 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_5 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_6 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_7 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_8 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w1_9 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_1 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_10 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_11 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_2 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_3 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_4 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_5 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_6 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_7 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_8 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| lc_rchisq_w2_9 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |
| ls_id | Unique LS object ID | BIGINT |
| maskbits | Bitwise mask indicating that an object touches a pixel in the coadd/*/*/*maskbits* maps see http://legacysurvey.org/dr8/bitmasks/ | SMALLINT |
| mjd | Modified Julian Date | INTEGER |
| mjd_max | Maximum Modified Julian Date of observations used to construct the model of this object | DOUBLE |
| mjd_min | Minimum Modified Julian Date of observations used to construct the model of this object | DOUBLE |
| mw_transmission_g | Galactic transmission in (g) filter in linear units [0,1] | REAL |
| mw_transmission_r | Galactic transmission in (r) filter in linear units [0,1] | REAL |
| mw_transmission_w1 | Galactic transmission in (W1) filter in linear units [0,1] | REAL |
| mw_transmission_w2 | Galactic transmission in (W2) filter in linear units [0,1] | REAL |
| mw_transmission_w3 | Galactic transmission in (W3) filter in linear units [0,1] | REAL |
| mw_transmission_w4 | Galactic transmission in (W4) filter in linear units [0,1] | REAL |
| mw_transmission_z | Galactic transmission in (z) filter in linear units [0,1] | REAL |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
| nobs_g | Number of images that contribute to the central pixel in (g): filter for this object (not profile-weighted) | SMALLINT |
| nobs_r | Number of images that contribute to the central pixel in (r): filter for this object (not profile-weighted) | SMALLINT |
| nobs_w1 | Number of images that contribute to the central pixel in (W1): filter for this object (not profile-weighted) | SMALLINT |
| nobs_w2 | Number of images that contribute to the central pixel in (W2): filter for this object (not profile-weighted) | SMALLINT |
| nobs_w3 | Number of images that contribute to the central pixel in (W3): filter for this object (not profile-weighted) | SMALLINT |
| nobs_w4 | Number of images that contribute to the central pixel in (W4): filter for this object (not profile-weighted) | SMALLINT |
| nobs_z | Number of images that contribute to the central pixel in (z): filter for this object (not profile-weighted) | SMALLINT |
| objid | Catalog object number within this brick; a unique identifier hash is BRICKID,OBJID; OBJID spans [0,N-1] and is contiguously enumerated within each blob | INTEGER |
| parallax | Reference catalog parallax | REAL |
| parallax_ivar | Reference catalog inverse-variance on parallax | REAL |
| plate | Plate number | INTEGER |
| pmdec | Reference catalog proper motion in the Dec direction | REAL |
| pmdec_ivar | Reference catalog inverse-variance on pmdec | REAL |
| pmra | Reference catalog proper motion in the RA direction | REAL |
| pmra_ivar | Reference catalog inverse-variance on pmra | REAL |
| psfdepth_g | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_G})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_G})) - 9]) gives corresponding magnitude | REAL |
| psfdepth_r | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_R})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_R})) - 9]) gives corresponding magnitude | REAL |
| psfdepth_w1 | As for psfdepth_g (and also on the AB system) but for WISE W1 | REAL |
| psfdepth_w2 | As for psfdepth_g (and also on the AB system) but for WISE W2 | REAL |
| psfdepth_w3 | As for psfdepth_g (and also on the AB system) but for WISE W3 | REAL |
| psfdepth_w4 | As for psfdepth_g (and also on the AB system) but for WISE W4 | REAL |
| psfdepth_z | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_Z})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_Z})) - 9]) gives corresponding magnitude | REAL |
| psfsize_g | Weighted average PSF FWHM in the (g) band | REAL |
| psfsize_r | Weighted average PSF FWHM in the (r) band | REAL |
| psfsize_z | Weighted average PSF FWHM in the (z) band | REAL |
| ra | Right ascension at epoch J2000 | DOUBLE |
| ra_ivar | Inverse variance of RA (no cosine term!), excluding astrometric calibration errors | REAL |
| rchisq_g | Profile-weighted chi^2 of model fit normalized by the number of pixels in (g) | REAL |
| rchisq_r | Profile-weighted chi^2 of model fit normalized by the number of pixels in (r) | REAL |
| rchisq_w1 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W1) | REAL |
| rchisq_w2 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W2) | REAL |
| rchisq_w3 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W3) | REAL |
| rchisq_w4 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W4) | REAL |
| rchisq_z | Profile-weighted chi^2 of model fit normalized by the number of pixels in (z) | REAL |
| ref_cat | Reference catalog source for this star: T2 for Tycho-2, G2 for Gaia DR2, empty otherwise | VARCHAR |
| ref_epoch | Reference catalog reference epoch (e.g., 2015.5 for Gaia-DR2) | REAL |
| ref_id | Reference catalog identifier for this star; (mathrm{Tyc1} imes 1,000,000 + mathrm{Tyc2} imes 10 + mathrm{Tyc3}) for Tycho2; sourceid for Gaia-DR2 | BIGINT |
| release | Unique integer denoting the camera and filter set used | SMALLINT |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| run2d | Reprocessing version for optical spectroscopy reduced by the SDSS, BOSS and eBOSS pipelines. | VARCHAR |
| shapedev_e1 | Ellipticity component 1 | REAL |
| shapedev_e1_ivar | Inverse variance of SHAPEDEV_E1 | REAL |
| shapedev_e2 | Ellipticity component 2 | REAL |
| shapedev_e2_ivar | Inverse variance of SHAPEDEV_E2 | REAL |
| shapedev_r | Half-light radius of deVaucouleurs model (>0) | REAL |
| shapedev_r_ivar | Inverse variance of R_DEV | REAL |
| shapeexp_e1 | Ellipticity component 1 | REAL |
| shapeexp_e1_ivar | Inverse variance of SHAPEEXP_E1 | REAL |
| shapeexp_e2 | Ellipticity component 2 | REAL |
| shapeexp_e2_ivar | Inverse variance of SHAPEEXP_E2 | REAL |
| shapeexp_r | Half-light radius of exponential model (>0) | REAL |
| shapeexp_r_ivar | Inverse variance of R_EXP | REAL |
| type | Morphological model: PSF=stellar, REX=round exponential galaxy, DEV=deVauc, EXP=exponential, COMP=composite. | VARCHAR |
| wise_coadd_id | unWISE coadd file name for the center of each object | VARCHAR |
| wisemask_w1 | W1 bright star bitmask, (2^0) ((2^1)) for southward (northward) scans | SMALLINT |
| wisemask_w2 | W2 bright star bitmask, (2^0) ((2^1)) for southward (northward) scans | SMALLINT |
