3.3.13.4  :  Pencil Beam Tables

All the pencil-beam lightcones stored in the Henriques2012a table have the same structure. The difference is in the cosmology, wmap1 or wmap7 and in the stellar population synthesis models. The cosmology is indicated by the database schema the tables reside in. The synthesis model by the names of the tables themselves. We have the following tables:

Henriques2012a.wmap1.BC03_[001 to 024] 
Henriques2012a.wmap1.M05_[001 to 024] 
Each schema contains light cones for 24 different lines-of-sight (which can be used to test the effects of cosmic variance). Total and bulge observer-frame apparent magnitudes in 40 different photometric bands are included both corrrected for dust extinction (all in AB system). These cones were created from the galaxies in Guo2010a..MR (but with the extended photometry). To retrieve information about the physical properties of galaxies one can join to that table as in the following example:

select c.*, g.stellarmass, g.coldgas
  from Henriques2012a.wmap1.M05_001 c
  ,    Guo2010a..MR g
 where g.galaxyid = c.galid
namedatatypeunitUCDdescription
GalIDbigint[ucd]Identifier of the galaxy in the Guo2010a..MR table. Pointer to the galaxyId column in that table.
HaloIDbigint[ucd]Identifier of the halo (in the MPHalotrees..MHalo table) that this galaxy resides in. Pointer to the haloId column in that table.
cxrealMpc/h[ucd]X-component of galaxy's position in 3D space. Origin of coordinate system is at the origin of the cone. The coordinate axes are aligned with those of the simulation box which is supposed to be periodically extended.
cyrealMpc/h[ucd]Y-component of galaxy's position in 3D space. Origin of coordinate system is at the origin of the cone. The coordinate axes are aligned with those of the simulation box which is supposed to be periodically extended.
czrealMpc/h[ucd]Z-component of galaxy's position in 3D space. Origin of coordinate system is at the origin of the cone. The coordinate axes are aligned with those of the simulation box which is supposed to be periodically extended.
rarealdeg[ucd]Right ascension, i.e. longitude component of the galaxy's position on the sky. Assumed that center of cone is at RA=0.
decrealdeg[ucd]Declination, i.e. latitude component of the galaxy's position on the sky. Assumed that center of cone is at Dec=0.
z_georeal[ucd]Redshift of the galaxy based on its position. Peculiar velocity is not included.
z_appreal[ucd]Apparent redshift. Including peculiar velocity.
dlumrealMpc/h[ucd]Luminosity distance in Mpc/h.
vlosrealkm/s[ucd]Line-of-sight velocity of the galaxy in km/s.
inclrealdeg[ucd]Inclination of the galaxy. Randomly generated and used in the galaxy formation model to perform dust correction on the luminosities.
Ureal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel U filter (dust corrected) of the galaxy.
Breal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel B filter (dust corrected) of the galaxy.
Vreal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel V filter (dust corrected) of the galaxy.
Rcreal[ucd]Observer-frame apparent (AB) magnitude in the Cousins Rc filter (dust corrected) of the galaxy.
Icreal[ucd]Observer-frame apparent (AB) magnitude in the Cousins Ic filter (dust corrected) of the galaxy.
Zreal[ucd]Observer-frame apparent (AB) magnitude in the VISTA Z filter (dust corrected) of the galaxy.
Yreal[ucd]Observer-frame apparent (AB) magnitude in the VISTA Y filter (dust corrected) of the galaxy.
Jreal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS J filter (dust corrected) of the galaxy.
Hreal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS H filter (dust corrected) of the galaxy.
Kreal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel K filter (dust corrected) of the galaxy.
Ksreal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS Ks filter (dust corrected) of the galaxy.
i1real[ucd]Observer-frame apparent (AB) magnitude in the IRAC 3.6μm filter (dust corrected) of the galaxy.
i2real[ucd]Observer-frame apparent (AB) magnitude in the IRAC 4.5μm filter (dust corrected) of the galaxy.
i3real[ucd]Observer-frame apparent (AB) magnitude in the IRAC 5.8μm filter (dust corrected) of the galaxy.
i4real[ucd]Observer-frame apparent (AB) magnitude in the IRAC 8.0μm filter (dust corrected) of the galaxy.
SDSS_ureal[ucd]Observer-frame apparent (AB) magnitude in the SDSS u filter (dust corrected) of the galaxy.
SDSS_greal[ucd]Observer-frame apparent (AB) magnitude in the SDSS g filter (dust corrected) of the galaxy.
SDSS_rreal[ucd]Observer-frame apparent (AB) magnitude in the SDSS r filter (dust corrected) of the galaxy.
SDSS_ireal[ucd]Observer-frame apparent (AB) magnitude in the SDSS i filter (dust corrected) of the galaxy.
SDSS_zreal[ucd]Observer-frame apparent (AB) magnitude in the SDSS z filter (dust corrected) of the galaxy.
U_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel U filter (dust corrected) of the bulge.
B_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel B filter (dust corrected) of the bulge.
V_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel V filter (dust corrected) of the bulge.
Rc_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Cousins Rc filter (dust corrected) of the bulge.
Ic_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Cousins Ic filter (dust corrected) of the bulge.
Z_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VISTA Z filter (dust corrected) of the bulge.
Y_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VISTA Y filter (dust corrected) of the bulge.
J_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS J filter (dust corrected) of the bulge.
H_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS H filter (dust corrected) of the bulge.
K_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the Johnson-Bessel K filter (dust corrected) of the bulge.
Ks_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VISTA/2MASS Ks filter (dust corrected) of the bulge.
i1_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the IRAC 3.6μm filter (dust corrected) of the bulge.
i2_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the IRAC 4.5μm filter (dust corrected) of the bulge.
i3_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the IRAC 5.8μm filter (dust corrected) of the bulge.
i4_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the IRAC 8.0μm filter (dust corrected) of the bulge.
SDSS_u_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the SDSS u filter (dust corrected) of the bulge.
SDSS_g_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the SDSS g filter (dust corrected) of the bulge.
SDSS_r_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the SDSS r filter (dust corrected) of the bulge.
SDSS_i_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the SDSS i filter (dust corrected) of the bulge.
SDSS_z_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the SDSS z filter (dust corrected) of the bulge.
ACS435real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.435μm filter (dust corrected) of the galaxy.
ACS475real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.475μm filter (dust corrected) of the galaxy.
ACS606real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.606μm filter (dust corrected) of the galaxy.
ACS625real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.625μm filter (dust corrected) of the galaxy.
ACS775real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.775μm filter (dust corrected) of the galaxy.
ACS814real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.814μm filter (dust corrected) of the galaxy.
ACS850real[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.850μm filter (dust corrected) of the galaxy.
GFUVreal[ucd]Observer-frame apparent (AB) magnitude in the GALEX FUV filter (dust corrected) of the galaxy.
GNUVreal[ucd]Observer-frame apparent (AB) magnitude in the GALEX NUV filter (dust corrected) of the galaxy.
NIC110real[ucd]Observer-frame apparent (AB) magnitude in the NICMOS 1.1μm filter (dust corrected) of the galaxy.
NIC160real[ucd]Observer-frame apparent (AB) magnitude in the NICMOS 1.6μm filter (dust corrected) of the galaxy.
VIMOSUreal[ucd]Observer-frame apparent (AB) magnitude in the VIMOS U filter (dust corrected) of the galaxy.
WFC105real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.05μm filter (dust corrected) of the galaxy.
WFC125real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.25μm filter (dust corrected) of the galaxy.
WFC160real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.60μm filter (dust corrected) of the galaxy.
WFC225real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.225μm filter (dust corrected) of the galaxy.
WFC275real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.275μm filter (dust corrected) of the galaxy.
WFC336real[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.336μm filter (dust corrected) of the galaxy.
WFPC300real[ucd]Observer-frame apparent (AB) magnitude in the HST WFPC2 0.300μm filter (dust corrected) of the galaxy.
WFPC450real[ucd]Observer-frame apparent (AB) magnitude in the HST WFPC2 0.450μm filter (dust corrected) of the galaxy.
ACS435_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.435μm filter (dust corrected) of the bulge.
ACS475_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.475μm filter (dust corrected) of the bulge.
ACS606_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.606μm filter (dust corrected) of the bulge.
ACS625_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.625μm filter (dust corrected) of the bulge.
ACS775_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.775μm filter (dust corrected) of the bulge.
ACS814_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.814μm filter (dust corrected) of the bulge.
ACS850_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.850μm filter (dust corrected) of the bulge.
GFUV_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the GALEX FUV filter (dust corrected) of the bulge.
GNUV_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the GALEX NUV filter (dust corrected) of the bulge.
NIC110_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the NICMOS 1.1μm filter (dust corrected) of the bulge.
NIC160_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the NICMOS 1.6μm filter (dust corrected) of the bulge.
VIMOSU_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the VIMOS U filter (dust corrected) of the bulge.
WFC105_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.05μm filter (dust corrected) of the bulge.
WFC125_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.25μm filter (dust corrected) of the bulge.
WFC160_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.60μm filter (dust corrected) of the bulge.
WFC225_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.225μm filter (dust corrected) of the bulge.
WFC275_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.275μm filter (dust corrected) of the bulge.
WFC336_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.336μm filter (dust corrected) of the bulge.
WFPC300_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFPC2 0.300μm filter (dust corrected) of the bulge.
WFPC450_Bulgereal[ucd]Observer-frame apparent (AB) magnitude in the HST WFPC2 0.450μm filter (dust corrected) of the bulge.