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

Table: ls_dr9.tractor_s
(The bold columns are indexed columns)
Column NameDescriptionDatatype
allmask_gBitwise mask set if the central pixel from all images satisfy each condition in g as cataloged on the DR9 bitmasks pageSMALLINT
allmask_rBitwise mask set if the central pixel from all images satisfy each condition in r as cataloged on the DR9 bitmasks pageSMALLINT
allmask_zBitwise mask set if the central pixel from all images satisfy each condition in z as cataloged on the DR9 bitmasks pageSMALLINT
anymask_gBitwise mask set if the central pixel from any image satisfies each condition in g as cataloged on the DR9 bitmasks pageSMALLINT
anymask_rBitwise mask set if the central pixel from any image satisfies each condition in r as cataloged on the DR9 bitmasks pageSMALLINT
anymask_zBitwise mask set if the central pixel from any image satisfies each condition in z as cataloged on the DR9 bitmasks pageSMALLINT
blob_nea_gBlob-masked noise equivalent area in g.REAL
blob_nea_rBlob-masked noise equivalent area in r.REAL
blob_nea_zBlob-masked noise equivalent area in z.REAL
brick_primaryTrue if the object is within the brick boundarSMALLINT
brickidBrick ID [1,662174]INTEGER
bricknameName of brick, encoding the brick sky position, eg 1126p222 near RA=112.6, Dec=+22.2VARCHAR
bxX position (0-indexed) of coordinates in the brick image stack (i.e. in the e.g. legacysurvey--image-g.fits.fz coadd file)REAL
byY position (0-indexed) of coordinates in the brick image stack (i.e. in the e.g. legacysurvey--image-g.fits.fz coadd file)REAL
dchisq_1Difference in chi^2 between successively more-complex model fits: PSF, REX, DEV, EXP, SER. The difference is versus no source.REAL
dchisq_2Difference in chi^2 between successively more-complex model fits: PSF, REX, DEV, EXP, SER. The difference is versus no source.REAL
dchisq_3Difference in chi^2 between successively more-complex model fits: PSF, REX, DEV, EXP, SER. The difference is versus no source.REAL
dchisq_4Difference in chi^2 between successively more-complex model fits: PSF, REX, DEV, EXP, SER. The difference is versus no source.REAL
dchisq_5Difference in chi^2 between successively more-complex model fits: PSF, REX, DEV, EXP, SER. The difference is versus no source.REAL
decDeclination at equinox J2000DOUBLE
dec_ivarInverse variance of DEC, excluding astrometric calibration errorsREAL
dered_flux_gDereddened g band fluxREAL
dered_flux_rDereddened r band fluxREAL
dered_flux_w1Dereddened w1 band fluxREAL
dered_flux_w2Dereddened w2 band fluxREAL
dered_flux_w3Dereddened w3 band fluxREAL
dered_flux_w4Dereddened w4 band fluxREAL
dered_flux_zDereddened z band fluxREAL
dered_mag_gDereddened g-band magnitudeREAL
dered_mag_rDereddened r-band magnitudeREAL
dered_mag_w1Dereddened w1-band magnitudeREAL
dered_mag_w2Dereddened w2-band magnitudeREAL
dered_mag_w3Dereddened w3-band magnitudeREAL
dered_mag_w4Dereddened w4-band magnitudeREAL
dered_mag_zDereddened z-band magnitudeREAL
ebvGalactic extinction E(B-V) reddening from SFD98, used to compute the mw_transmission_ columnsREAL
elatEcliptic LatitudeDOUBLE
elonEcliptic LongitudeDOUBLE
fiberflux_gPredicted g-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fiberflux_rPredicted g-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fiberflux_zPredicted g-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fibertotflux_gPredicted g-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fibertotflux_rPredicted r-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fibertotflux_zPredicted z-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeingREAL
fitbitsBitwise mask detailing pecularities of how an object was fit, as cataloged on the DR9 bitmasks pageSMALLINT
flux_gModel flux in gREAL
flux_ivar_gInverse variance of flux_gREAL
flux_ivar_rInverse variance of flux_rREAL
flux_ivar_w1Inverse variance of flux_w1 (AB system)REAL
flux_ivar_w2Inverse variance of flux_w2 (AB system)REAL
flux_ivar_w3Inverse variance of flux_w3 (AB system)REAL
flux_ivar_w4Inverse variance of flux_w4 (AB system)REAL
flux_ivar_zInverse variance of flux_zREAL
flux_rModel flux in rREAL
flux_w1WISE model flux in W1 (AB system)REAL
flux_w2WISE model flux in W2 (AB system)REAL
flux_w3WISE model flux in W3 (AB system)REAL
flux_w4WISE model flux in W4 (AB system)REAL
flux_zModel flux in zREAL
fracflux_gProfile-weighted fraction of the flux from other sources divided by the total flux in g (typically [0,1])REAL
fracflux_rProfile-weighted fraction of the flux from other sources divided by the total flux in r (typically [0,1])REAL
fracflux_w1Profile-weighted fraction of the flux from other sources divided by the total flux in W1 (typically [0,1])REAL
fracflux_w2Profile-weighted fraction of the flux from other sources divided by the total flux in W2 (typically [0,1])REAL
fracflux_w3Profile-weighted fraction of the flux from other sources divided by the total flux in W3 (typically [0,1])REAL
fracflux_w4Profile-weighted fraction of the flux from other sources divided by the total flux in W4 (typically [0,1])REAL
fracflux_zProfile-weighted fraction of the flux from other sources divided by the total flux in z (typically [0,1])REAL
fracin_gFraction of a sources flux within the blob in g, near unity for real sourcesREAL
fracin_rFraction of a sources flux within the blob in r, near unity for real sourcesREAL
fracin_zFraction of a sources flux within the blob in z, near unity for real sourcesREAL
fracmasked_gProfile-weighted fraction of pixels masked from all observations of this object in g, strictly between [0,1]REAL
fracmasked_rProfile-weighted fraction of pixels masked from all observations of this object in g, strictly between [0,1]REAL
fracmasked_zProfile-weighted fraction of pixels masked from all observations of this object in g, strictly between [0,1]REAL
g_rComputed (g-r) colorREAL
gaia_a_g_valGaia line-of-sight extinction in the G bandREAL
gaia_astrometric_excess_noiseGaia astrometric excess noiseREAL
gaia_astrometric_excess_noise_sigGaia astrometric excess noise uncertaintyREAL
gaia_astrometric_n_good_obs_alGaia number of good astrometric observations along scan directionSMALLINT
gaia_astrometric_n_obs_alGaia number of astrometric observations along scan directionSMALLINT
gaia_astrometric_params_solvedWhich astrometric parameters were estimated for a Gaia sourceSMALLINT
gaia_astrometric_sigma5d_maxGaia longest semi-major axis of the 5-d error ellipsoidREAL
gaia_astrometric_weight_alGaia astrometric weight along scan directionREAL
gaia_duplicated_sourceGaia duplicated source flagSMALLINT
gaia_e_bp_min_rp_valGaia line-of-sight reddening E(BP-RP)REAL
gaia_phot_bp_mean_flux_over_errorGaia BP signal-to-noiseREAL
gaia_phot_bp_mean_magGaia BP magREAL
gaia_phot_bp_n_obsGaia BP number of observationsSMALLINT
gaia_phot_bp_rp_excess_factorGaia BP/RP excess factorREAL
gaia_phot_g_mean_flux_over_errorGaia G band signal-to-noiseREAL
gaia_phot_g_mean_magGaia G band magREAL
gaia_phot_g_n_obsGaia g band number of observationsSMALLINT
gaia_phot_rp_mean_flux_over_errorGaia RP band signal-to-noiseREAL
gaia_phot_rp_mean_magGaia RP magREAL
gaia_phot_rp_n_obsGaia RP band number of observationsSMALLINT
gaia_phot_variable_flagGaia photometric variable flagSMALLINT
galdepth_gAs for psfdepth_g but for a galaxy (0.45 exp, round) detection sensitivityREAL
galdepth_rAs for psfdepth_r but for a galaxy (0.45 exp, round) detection sensitivityREAL
galdepth_zAs for psfdepth_z but for a galaxy (0.45 exp, round) detection sensitivityREAL
glatGalactic LatitudeDOUBLE
glonGalactic LongitudeDOUBLE
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
ls_idUnique LS object IDBIGINT
mag_gConverted g magnitudeREAL
mag_rConverted r magnitudeREAL
mag_w1Converted W1 magnitudeREAL
mag_w2Converted W2 magnitudeREAL
mag_w3Converted W3 magnitudeREAL
mag_w4Converted W4 magnitudeREAL
mag_zConverted z magnitudeREAL
maskbitsBitwise mask indicating that an object touches a pixel in the coadd/*/*/*maskbits* maps, as cataloged on the DR9 bitmasks pageSMALLINT
mjd_maxMaximum Modified Julian Date of observations used to construct the model of this objectDOUBLE
mjd_minMinimum Modified Julian Date of observations used to construct the model of this objectDOUBLE
mw_transmission_gGalactic transmission in g filter in linear units [0, 1]REAL
mw_transmission_rGalactic transmission in r filter in linear units [0, 1]REAL
mw_transmission_w1Galactic transmission in w1 filter in linear units [0, 1]REAL
mw_transmission_w2Galactic transmission in w2 filter in linear units [0, 1]REAL
mw_transmission_w3Galactic transmission in w3 filter in linear units [0, 1]REAL
mw_transmission_w4Galactic transmission in w4 filter in linear units [0, 1]REAL
mw_transmission_zGalactic transmission in z filter in linear units [0, 1]REAL
nea_gNoise equivalent area in gREAL
nea_rNoise equivalent area in rREAL
nea_zNoise equivalent area in zREAL
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
nobs_gNumber of images that contribute to the central pixel in g: filter for this object (not profile-weighted)SMALLINT
nobs_rNumber of images that contribute to the central pixel in r: filter for this object (not profile-weighted)SMALLINT
nobs_w1Number of images that contribute to the central pixel in W1: filter for this object (not profile-weighted)SMALLINT
nobs_w2Number of images that contribute to the central pixel in W2: filter for this object (not profile-weighted)SMALLINT
nobs_w3Number of images that contribute to the central pixel in W3: filter for this object (not profile-weighted)SMALLINT
nobs_w4Number of images that contribute to the central pixel in W4: filter for this object (not profile-weighted)SMALLINT
nobs_zNumber of images that contribute to the central pixel in z: filter for this object (not profile-weighted)SMALLINT
objidCatalog object number within this brick; a unique identifier hash is release,brickid,objid; objid spans [0,N-1] and is contiguously enumerated within each brickINTEGER
parallaxReference catalog parallaxREAL
parallax_ivarReference catalog inverse-variance on parallaxREAL
pmdecReference catalog proper motion in the Dec directionREAL
pmdec_ivarReference catalog inverse-variance on pmdecREAL
pmraReference catalog proper motion in the RA directionREAL
pmra_ivarReference catalog inverse-variance on pmraREAL
psfdepth_gFor a 5 sigma point source detection limit in g, 5/sqrt(psfdepth_g) gives flux in nanomaggies and -2.5[log_10(5 / sqrt(psfdepth_g)) - 9] gives corresponding AB magnitudeREAL
psfdepth_rFor a 5 sigma point source detection limit in r, 5/sqrt(psfdepth_r) gives flux in nanomaggies and -2.5[log_10(5 / sqrt(psfdepth_r)) - 9] gives corresponding AB magnitudeREAL
psfdepth_w1As for psfdepth_g (and also on the AB system) but for WISE W1REAL
psfdepth_w2As for psfdepth_g (and also on the AB system) but for WISE W2REAL
psfdepth_w3As for psfdepth_g (and also on the AB system) but for WISE W3REAL
psfdepth_w4As for psfdepth_g (and also on the AB system) but for WISE W4REAL
psfdepth_zFor a 5 sigma point source detection limit in z, 5/sqrt(psfdepth_z) gives flux in nanomaggies and -2.5[log_10(5 / sqrt(psfdepth_z)) - 9] gives corresponding AB magnitudeREAL
psfsize_gWeighted average PSF FWHM in the g bandREAL
psfsize_rWeighted average PSF FWHM in the r bandREAL
psfsize_zWeighted average PSF FWHM in the z bandREAL
r_zComputed (r-z) colorREAL
raRight ascension at equinox J2000DOUBLE
ra_ivarInverse variance of RA (no cosine term!), excluding astrometric calibration errorsREAL
random_idRandom ID in the range 0.0 => 100.0REAL
rchisq_gProfile-weighted chi^2 of model fit normalized by the number of pixels in gREAL
rchisq_rProfile-weighted chi^2 of model fit normalized by the number of pixels in rREAL
rchisq_w1Profile-weighted chi^2 of model fit normalized by the number of pixels in W1REAL
rchisq_w2Profile-weighted chi^2 of model fit normalized by the number of pixels in W2REAL
rchisq_w3Profile-weighted chi^2 of model fit normalized by the number of pixels in W3REAL
rchisq_w4Profile-weighted chi^2 of model fit normalized by the number of pixels in W4REAL
rchisq_zProfile-weighted chi^2 of model fit normalized by the number of pixels in zREAL
ref_catReference catalog source for this star: T2 for Tycho-2, G2 for Gaia DR2, L3 for the SGA, empty otherwiseVARCHAR
ref_epochReference catalog reference epoch (eg, 2015.5 for Gaia DR2)REAL
ref_idReference catalog identifier for this star; Tyc1*1,000,000+Tyc2*10+Tyc3 for Tycho2; sourceid for Gaia DR2 and SGABIGINT
releaseInteger denoting the camera and filter set used, which will be unique for a given processing run of the data, as documented at https://www.legacysurvey.org/dr9/catalogs/SMALLINT
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
sersicPower-law index for the Sersic profile model (type=SER)REAL
sersic_ivarInverse variance of sersicREAL
shape_e1Ellipticity component 1 of galaxy model for galaxy type typeREAL
shape_e1_ivarInverse variance of shape_e1REAL
shape_e2Ellipticity component 2 of galaxy model for galaxy type typeREAL
shape_e2_ivarInverse variance of shape_e2REAL
shape_rHalf-light radius of galaxy model for galaxy type type (>0)REAL
shape_r_ivarInverse variance of shape_rREAL
snr_gSignal-to-Noise ratio in gREAL
snr_rSignal-to-Noise ratio in rREAL
snr_w1Signal-to-Noise ratio in W1REAL
snr_w2Signal-to-Noise ratio in W2REAL
snr_w3Signal-to-Noise ratio in W3REAL
snr_w4Signal-to-Noise ratio in W4REAL
snr_zSignal-to-Noise ratio in zREAL
typeMorphological model: PSF=stellar, REX=round exponential galaxy, DEV=deVauc, EXP=exponential, SER=Sersic, DUP=Gaia source fit by different model.VARCHAR
w1_w2Computed (w1-w2) colorREAL
w2_w3Computed (w2-w3) colorREAL
w3_w4Computed (w3-w4) colorREAL
wise_coadd_idunWISE coadd brick name (corresponding to the, e.g., legacysurvey--image-W1.fits.fz coadd file) for the center of each objectVARCHAR
wise_xX position of coordinates in the brick image stack that corresponds to wise_coadd_id (see the DR9 updates page for transformations between wise_x and bx)REAL
wise_yY position of coordinates in the brick image stack that corresponds to wise_coadd_id (see the DR9 updates page for transformations between wise_y and by)REAL
wisemask_w1W1 bitmask as cataloged on the DR9 bitmasks pageSMALLINT
wisemask_w2W2 bitmask as cataloged on the DR9 bitmasks pageSMALLINT
z_w1Computed (z-w1) colorREAL