### Choose a database in the left panel then select the table you want!

(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 satisfy each condition in G | SMALLINT |

anymask_r | Bitwise mask set if the central pixel from any image satisfy each condition in R | SMALLINT |

anymask_z | Bitwise mask set if the central pixel from any image satisfy each condition in Z | SMALLINT |

brick_primary | T if the object is within the brick boundary | SMALLINT |

brickid | Brick ID [1,662174] | INTEGER |

brickname | Name of brick, encoding the brick sky position | CHAR |

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 (ICRS) | DOUBLE |

dec_ivar | Inverse variance of Dec, excluding astrometric calibration errors | REAL |

decals_id | Unique DECaLS object ID | BIGINT |

dered_flux_g | Dereddened G-band flux | REAL |

dered_flux_r | Dereddened R-band flux | REAL |

dered_flux_w1 | Dereddened W1 flux | REAL |

dered_flux_w2 | Dereddened W1 flux | REAL |

dered_flux_w3 | Dereddened W1 flux | REAL |

dered_flux_w4 | Dereddened W1 flux | REAL |

dered_flux_z | Dereddened Z-band flux | REAL |

dered_mag_g | Dereddened G-band magnitude | REAL |

dered_mag_r | Dereddened R-band magnitude | REAL |

dered_mag_w1 | Dereddened W1 magnitude | REAL |

dered_mag_w2 | Dereddened W2 magnitude | REAL |

dered_mag_w3 | Dereddened W3 magnitude | REAL |

dered_mag_w4 | Dereddened W4 magnitude | REAL |

dered_mag_z | Dereddened Z-band magnitude | REAL |

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 |

flux_g | DECam 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_z | Inverse variance of FLUX_Z | REAL |

flux_r | DECam model flux in (r) | REAL |

flux_z | DECam model flux in (z) | REAL |

fracdev | Fraction of model in deVauc [0,1] | REAL |

fracdev_ivar | Inverse variance of FRACDEV | REAL |

fracflux_g | DECam model flux in (g) | REAL |

fracflux_r | DECam model flux in (r) | REAL |

fracflux_z | DECam model flux in (z) | REAL |

fracin_g | Fraction of a sources flux within the blob, near unity for real sources | REAL |

fracin_r | Fraction of a sources flux within the blob, near unity for real sources | REAL |

fracin_z | Fraction of a sources flux within the blob, near unity for real sources | REAL |

fracmasked_g | Profile-weighted fraction of pixels masked from all observations of this object, strictly between [0,1] | REAL |

fracmasked_r | Profile-weighted fraction of pixels masked from all observations of this object, strictly between [0,1] | REAL |

fracmasked_z | Profile-weighted fraction of pixels masked from all observations of this object, strictly between [0,1] | REAL |

g_r | Computed (g-r) color | REAL |

galdepth_g | As for DEPTH_G but for a galaxy (0.45arcsec exp. round) detection sensitivity | REAL |

galdepth_r | As for DEPTH_R but for a galaxy (0.45arcsec exp. round) detection sensitivity | REAL |

galdepth_z | As for DEPTH_Z but for a galaxy (0.45arcsec exp. round) detection sensitivity | REAL |

glat | Galactic Latitude | DOUBLE |

glon | Galactic Longitude | DOUBLE |

htm9 | HTM index (order 9 => ~10 arcmin size) | BIGINT |

mag_g | Converted G magnitude | REAL |

mag_r | Converted R magnitude | REAL |

mag_w1 | W1 magnitude | REAL |

mag_w2 | W2 magnitude | REAL |

mag_w3 | W3 magnitude | REAL |

mag_w4 | W4 magnitude | REAL |

mag_z | Converted Z magnitude | REAL |

mjd_max | Max MJD of image in stack | DOUBLE |

mjd_min | Min MJD of image in stack | DOUBLE |

mw_transmission_g | Galactic transmission in (g) filters in linear units [0,1] | REAL |

mw_transmission_r | Galactic transmission in (r) filters in linear units [0,1] | REAL |

mw_transmission_z | Galactic transmission in (z) filters in linear units [0,1] | REAL |

nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |

nobs_g | No. of images that contribute to central pixel in G filter (not profile-weighted) | SMALLINT |

nobs_r | No. of images that contribute to central pixel in R filter (not profile-weighted) | SMALLINT |

nobs_z | No. of images that contribute to central pixel in Z filter (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 |

psfdepth_g | For a 5-sigma point source detection in g, 5/sqrt(DEPTH_G) gives flux in nanomaggies and -2.5*log10((5/sqrt(DEPTH_G)-9) gives corresponging magnitude | REAL |

psfdepth_r | For a 5-sigma point source detection in r, 5/sqrt(DEPTH_R) gives flux in nanomaggies and -2.5*log10((5/sqrt(DEPTH_R)-9) gives corresponging magnitude | REAL |

psfdepth_z | For a 5-sigma point source detection in z, 5/sqrt(DEPTH_Z) gives flux in nanomaggies and -2.5*log10((5/sqrt(DEPTH_Z)-9) gives corresponging 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 |

r_z | Computed (r-z) color | REAL |

ra | Right Ascension (ICRS) | DOUBLE |

ra_ivar | Inverse variance of RA, excluding astrometric calibration errors | REAL |

random_id | Random ID in the range 0.0 => 100.0 | REAL |

rchisq_g | Profile-weighted X^2 of model fit normalized by the number of pixels | REAL |

rchisq_r | Profile-weighted X^2 of model fit normalized by the number of pixels | REAL |

rchisq_z | Profile-weighted X^2 of model fit normalized by the number of pixels | REAL |

ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |

shapedev_e1 | Ellipticity component 1 | REAL |

shapedev_e1_ivar | Inverse variance of SHAPEDEV_E1 | REAL |

shapedev_e2 | Ellipticity component 1 | 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 SHAPEDEV_R | 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 SHAPEEXP_R | REAL |

snr_g | Signal-to-Noise ratio in G | REAL |

snr_r | Signal-to-Noise ratio in R | REAL |

snr_w1 | Signal-to-Noise ratio in W1 | REAL |

snr_w2 | Signal-to-Noise ratio in W2 | REAL |

snr_w3 | Signal-to-Noise ratio in W3 | REAL |

snr_w4 | Signal-to-Noise ratio in W4 | REAL |

snr_z | Signal-to-Noise ratio in Z | REAL |

type | Morphological model: PSF=stellar, EXP=exponential, DEV=deVauc, COMP=composite | CHAR |

w1_w2 | Computed (w1-w2) color | REAL |

w2_w3 | Computed (w2-w3) color | REAL |

w3_w4 | Computed (w3-d4) color | REAL |

z_w1 | Computed (z-w1 color | REAL |