Choose a database in the left panel then select the table you want!
Table: buzzard_dr1.main
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| absmag_r | SDSS r-band absolute magnitude [mag] | DOUBLE |
| amag_decam_g | Noiseless unlensed rest frame absolute mag in DECAM g band [mag] | REAL |
| amag_decam_i | Noiseless unlensed rest frame absolute mag in DECAM i band [mag] | REAL |
| amag_decam_r | Noiseless unlensed rest frame absolute mag in DECAM r band [mag] | REAL |
| amag_decam_u | Noiseless unlensed rest frame absolute mag in DECAM u band [mag] | REAL |
| amag_decam_y | Noiseless unlensed rest frame absolute mag in DECAM Y band [mag] | REAL |
| amag_decam_z | Noiseless unlensed rest frame absolute mag in DECAM z band [mag] | REAL |
| amag_roman_h | Noiseless unlensed rest frame absolute mag in ROMAN H band [mag] | REAL |
| amag_roman_j | Noiseless unlensed rest frame absolute mag in ROMAN J band [mag] | REAL |
| amag_roman_k | Noiseless unlensed rest frame absolute mag in ROMAN K band [mag] | REAL |
| amag_roman_y | Noiseless unlensed rest frame absolute mag in ROMAN Y band [mag] | REAL |
| amag_rubin_g | Noiseless unlensed rest frame absolute mag in Rubin LSST g band [mag] | REAL |
| amag_rubin_i | Noiseless unlensed rest frame absolute mag in Rubin LSST i band [mag] | REAL |
| amag_rubin_r | Noiseless unlensed rest frame absolute mag in Rubin LSST r band [mag] | REAL |
| amag_rubin_u | Noiseless unlensed rest frame absolute mag in Rubin LSST u band [mag] | REAL |
| amag_rubin_y | Noiseless unlensed rest frame absolute mag in Rubin LSST Y band [mag] | REAL |
| amag_rubin_z | Noiseless unlensed rest frame absolute mag in Rubin LSST z band [mag] | REAL |
| amag_vista_h | Noiseless unlensed rest frame absolute mag in VISTA H band [mag] | REAL |
| amag_vista_j | Noiseless unlensed rest frame absolute mag in VISTA J band [mag] | REAL |
| amag_vista_ks | Noiseless unlensed rest frame absolute mag in VISTA Ks band [mag] | REAL |
| amag_vista_y | Noiseless unlensed rest frame absolute mag in VISTA Y band [mag] | REAL |
| amag_vista_z | Noiseless unlensed rest frame absolute mag in VISTA Z band [mag] | REAL |
| amag_wise_w1 | Noiseless unlensed rest frame absolute mag in WISE W1 band [mag] | REAL |
| amag_wise_w2 | Noiseless unlensed rest frame absolute mag in WISE W2 band [mag] | REAL |
| central | True for central galaxies | SMALLINT |
| dec | Lensed DEC [deg] | DOUBLE |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| epsilon1 | Lensed ellipticities along local RA direction | DOUBLE |
| epsilon2 | Lensed ellipticities along local DEC direction | DOUBLE |
| gamma1 | True gravitational shear along local RA direction | DOUBLE |
| gamma2 | True gravitational shear along local DEC direction | DOUBLE |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| haloid | Halo id of host halo | BIGINT |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| id | Unique galaxy ID | DOUBLE |
| kappa | Weak lensing convergence | DOUBLE |
| lmag_decam_g | Noiseless lensed apparent mag in DECAM g band [mag] | REAL |
| lmag_decam_i | Noiseless lensed apparent mag in DECAM i band [mag] | REAL |
| lmag_decam_r | Noiseless lensed apparent mag in DECAM r band [mag] | REAL |
| lmag_decam_u | Noiseless lensed apparent mag in DECAM u band [mag] | REAL |
| lmag_decam_y | Noiseless lensed apparent mag in DECAM Y band [mag] | REAL |
| lmag_decam_z | Noiseless lensed apparent mag in DECAM z band [mag] | REAL |
| lmag_roman_h | Noiseless lensed apparent mag in ROMAN H band [mag] | REAL |
| lmag_roman_j | Noiseless lensed apparent mag in ROMAN J band [mag] | REAL |
| lmag_roman_k | Noiseless lensed apparent mag in ROMAN K band [mag] | REAL |
| lmag_roman_y | Noiseless lensed apparent mag in ROMAN Y band [mag] | REAL |
| lmag_rubin_g | Noiseless lensed apparent mag in Rubin LSST g band [mag] | REAL |
| lmag_rubin_i | Noiseless lensed apparent mag in Rubin LSST i band [mag] | REAL |
| lmag_rubin_r | Noiseless lensed apparent mag in Rubin LSST r band [mag] | REAL |
| lmag_rubin_u | Noiseless lensed apparent mag in Rubin LSST u band [mag] | REAL |
| lmag_rubin_y | Noiseless lensed apparent mag in Rubin LSST Y band [mag] | REAL |
| lmag_rubin_z | Noiseless lensed apparent mag in Rubin LSST z band [mag] | REAL |
| lmag_vista_h | Noiseless lensed apparent mag in VISTA H band [mag] | REAL |
| lmag_vista_j | Noiseless lensed apparent mag in VISTA J band [mag] | REAL |
| lmag_vista_ks | Noiseless lensed apparent mag in VISTA Ks band [mag] | REAL |
| lmag_vista_y | Noiseless lensed apparent mag in VISTA Y band [mag] | REAL |
| lmag_vista_z | Noiseless lensed apparent mag in VISTA Z band [mag] | REAL |
| lmag_wise_w1 | Noiseless lensed apparent mag in WISE W1 band [mag] | REAL |
| lmag_wise_w2 | Noiseless lensed apparent mag in WISE W2 band [mag] | REAL |
| m200 | M_200 of host halo [M_sun/h] | DOUBLE |
| mu | Weak lensing magnification | DOUBLE |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| px | Comoving position X coordinate [Mpc/h] | DOUBLE |
| py | Comoving position Y coordinate [Mpc/h] | DOUBLE |
| pz | Comoving position Z coordinate [Mpc/h] | DOUBLE |
| r200 | R_200 of host halo [Mpc/h] | DOUBLE |
| ra | Lensed RA [deg] | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
| rhalo | Distance to nearest halo [Mpc/h] | DOUBLE |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| sedid | SDSS training set index for SED assigned to galaxy | BIGINT |
| size | Lensed half light radius [arcsec] | DOUBLE |
| tdec | Unlensed dec [deg] | DOUBLE |
| te1 | Unlensed ellipticity along local RA direction | DOUBLE |
| te2 | Unlensed ellipticity along local DEC direction | DOUBLE |
| tmag_decam_g | Noiseless unlensed apparent mag in DECAM g band [mag] | REAL |
| tmag_decam_i | Noiseless unlensed apparent mag in DECAM i band [mag] | REAL |
| tmag_decam_r | Noiseless unlensed apparent mag in DECAM r band [mag] | REAL |
| tmag_decam_u | Noiseless unlensed apparent mag in DECAM u band [mag] | REAL |
| tmag_decam_y | Noiseless unlensed apparent mag in DECAM Y band [mag] | REAL |
| tmag_decam_z | Noiseless unlensed apparent mag in DECAM z band [mag] | REAL |
| tmag_roman_h | Noiseless unlensed apparent mag in ROMAN H band [mag] | REAL |
| tmag_roman_j | Noiseless unlensed apparent mag in ROMAN J band [mag] | REAL |
| tmag_roman_k | Noiseless unlensed apparent mag in ROMAN K band [mag] | REAL |
| tmag_roman_y | Noiseless unlensed apparent mag in ROMAN Y band [mag] | REAL |
| tmag_rubin_g | Noiseless unlensed apparent mag in Rubin LSST g band [mag] | REAL |
| tmag_rubin_i | Noiseless unlensed apparent mag in Rubin LSST i band [mag] | REAL |
| tmag_rubin_r | Noiseless unlensed apparent mag in Rubin LSST r band [mag] | REAL |
| tmag_rubin_u | Noiseless unlensed apparent mag in Rubin LSST u band [mag] | REAL |
| tmag_rubin_y | Noiseless unlensed apparent mag in Rubin LSST Y band [mag] | REAL |
| tmag_rubin_z | Noiseless unlensed apparent mag in Rubin LSST z band [mag] | REAL |
| tmag_vista_h | Noiseless unlensed apparent mag in VISTA H band [mag] | REAL |
| tmag_vista_j | Noiseless unlensed apparent mag in VISTA J band [mag] | REAL |
| tmag_vista_ks | Noiseless unlensed apparent mag in VISTA Ks band [mag] | REAL |
| tmag_vista_y | Noiseless unlensed apparent mag in VISTA Y band [mag] | REAL |
| tmag_vista_z | Noiseless unlensed apparent mag in VISTA Z band [mag] | REAL |
| tmag_wise_w1 | Noiseless unlensed apparent mag in WISE W1 band [mag] | REAL |
| tmag_wise_w2 | Noiseless unlensed apparent mag in WISE W2 band [mag] | REAL |
| tra | Unlensed RA [deg] | DOUBLE |
| tsize | Unlensed half light radius [arcsec] | DOUBLE |
| vx | Physical velocity X coordinate [km/s] | DOUBLE |
| vy | Physical velocity Y coordinate [km/s] | DOUBLE |
| vz | Physical velocity Z coordinate [km/s] | DOUBLE |
| w | Weak lensing rotation | DOUBLE |
| z | Redshift including RSD | DOUBLE |
| z_cos | Cosmological redshift | DOUBLE |





