3.3.17.1 : 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

name	datatype	unit	UCD	description
GalID	bigint		[ucd]	Identifier of the galaxy in the Guo2010a..MR table. Pointer to the galaxyId column in that table.
HaloID	bigint		[ucd]	Identifier of the halo (in the MPHalotrees..MHalo table) that this galaxy resides in. Pointer to the haloId column in that table.
cx	real	Mpc/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.
cy	real	Mpc/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.
cz	real	Mpc/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.
ra	real	deg	[ucd]	Right ascension, i.e. longitude component of the galaxy's position on the sky. Assumed that center of cone is at RA=0.
dec	real	deg	[ucd]	Declination, i.e. latitude component of the galaxy's position on the sky. Assumed that center of cone is at Dec=0.
z_geo	real		[ucd]	Redshift of the galaxy based on its position. Peculiar velocity is not included.
z_app	real		[ucd]	Apparent redshift. Including peculiar velocity.
dlum	real	Mpc/h	[ucd]	Luminosity distance in Mpc/h.
vlos	real	km/s	[ucd]	Line-of-sight velocity of the galaxy in km/s.
incl	real	deg	[ucd]	Inclination of the galaxy. Randomly generated and used in the galaxy formation model to perform dust correction on the luminosities.
U	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel U filter (dust corrected) of the galaxy.
B	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel B filter (dust corrected) of the galaxy.
V	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel V filter (dust corrected) of the galaxy.
Rc	real		[ucd]	Observer-frame apparent (AB) magnitude in the Cousins R_c filter (dust corrected) of the galaxy.
Ic	real		[ucd]	Observer-frame apparent (AB) magnitude in the Cousins I_c filter (dust corrected) of the galaxy.
Z	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA Z filter (dust corrected) of the galaxy.
Y	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA Y filter (dust corrected) of the galaxy.
J	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS J filter (dust corrected) of the galaxy.
H	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS H filter (dust corrected) of the galaxy.
K	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel K filter (dust corrected) of the galaxy.
Ks	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS K_s filter (dust corrected) of the galaxy.
i1	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 3.6μm filter (dust corrected) of the galaxy.
i2	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 4.5μm filter (dust corrected) of the galaxy.
i3	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 5.8μm filter (dust corrected) of the galaxy.
i4	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 8.0μm filter (dust corrected) of the galaxy.
SDSS_u	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS u filter (dust corrected) of the galaxy.
SDSS_g	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS g filter (dust corrected) of the galaxy.
SDSS_r	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS r filter (dust corrected) of the galaxy.
SDSS_i	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS i filter (dust corrected) of the galaxy.
SDSS_z	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS z filter (dust corrected) of the galaxy.
U_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel U filter (dust corrected) of the bulge.
B_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel B filter (dust corrected) of the bulge.
V_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel V filter (dust corrected) of the bulge.
Rc_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Cousins R_c filter (dust corrected) of the bulge.
Ic_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Cousins I_c filter (dust corrected) of the bulge.
Z_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA Z filter (dust corrected) of the bulge.
Y_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA Y filter (dust corrected) of the bulge.
J_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS J filter (dust corrected) of the bulge.
H_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS H filter (dust corrected) of the bulge.
K_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the Johnson-Bessel K filter (dust corrected) of the bulge.
Ks_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VISTA/2MASS K_s filter (dust corrected) of the bulge.
i1_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 3.6μm filter (dust corrected) of the bulge.
i2_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 4.5μm filter (dust corrected) of the bulge.
i3_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 5.8μm filter (dust corrected) of the bulge.
i4_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the IRAC 8.0μm filter (dust corrected) of the bulge.
SDSS_u_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS u filter (dust corrected) of the bulge.
SDSS_g_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS g filter (dust corrected) of the bulge.
SDSS_r_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS r filter (dust corrected) of the bulge.
SDSS_i_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS i filter (dust corrected) of the bulge.
SDSS_z_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the SDSS z filter (dust corrected) of the bulge.
ACS435	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.435μm filter (dust corrected) of the galaxy.
ACS475	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.475μm filter (dust corrected) of the galaxy.
ACS606	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.606μm filter (dust corrected) of the galaxy.
ACS625	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.625μm filter (dust corrected) of the galaxy.
ACS775	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.775μm filter (dust corrected) of the galaxy.
ACS814	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.814μm filter (dust corrected) of the galaxy.
ACS850	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.850μm filter (dust corrected) of the galaxy.
GFUV	real		[ucd]	Observer-frame apparent (AB) magnitude in the GALEX FUV filter (dust corrected) of the galaxy.
GNUV	real		[ucd]	Observer-frame apparent (AB) magnitude in the GALEX NUV filter (dust corrected) of the galaxy.
NIC110	real		[ucd]	Observer-frame apparent (AB) magnitude in the NICMOS 1.1μm filter (dust corrected) of the galaxy.
NIC160	real		[ucd]	Observer-frame apparent (AB) magnitude in the NICMOS 1.6μm filter (dust corrected) of the galaxy.
VIMOSU	real		[ucd]	Observer-frame apparent (AB) magnitude in the VIMOS U filter (dust corrected) of the galaxy.
WFC105	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.05μm filter (dust corrected) of the galaxy.
WFC125	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.25μm filter (dust corrected) of the galaxy.
WFC160	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.60μm filter (dust corrected) of the galaxy.
WFC225	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.225μm filter (dust corrected) of the galaxy.
WFC275	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.275μm filter (dust corrected) of the galaxy.
WFC336	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.336μm filter (dust corrected) of the galaxy.
WFPC300	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFPC2 0.300μm filter (dust corrected) of the galaxy.
WFPC450	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFPC2 0.450μm filter (dust corrected) of the galaxy.
ACS435_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.435μm filter (dust corrected) of the bulge.
ACS475_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.475μm filter (dust corrected) of the bulge.
ACS606_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.606μm filter (dust corrected) of the bulge.
ACS625_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.625μm filter (dust corrected) of the bulge.
ACS775_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.775μm filter (dust corrected) of the bulge.
ACS814_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.814μm filter (dust corrected) of the bulge.
ACS850_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST ACS-WFC 0.850μm filter (dust corrected) of the bulge.
GFUV_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the GALEX FUV filter (dust corrected) of the bulge.
GNUV_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the GALEX NUV filter (dust corrected) of the bulge.
NIC110_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the NICMOS 1.1μm filter (dust corrected) of the bulge.
NIC160_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the NICMOS 1.6μm filter (dust corrected) of the bulge.
VIMOSU_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the VIMOS U filter (dust corrected) of the bulge.
WFC105_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.05μm filter (dust corrected) of the bulge.
WFC125_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.25μm filter (dust corrected) of the bulge.
WFC160_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-IR 1.60μm filter (dust corrected) of the bulge.
WFC225_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.225μm filter (dust corrected) of the bulge.
WFC275_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.275μm filter (dust corrected) of the bulge.
WFC336_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFC3-UVIS 0.336μm filter (dust corrected) of the bulge.
WFPC300_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFPC2 0.300μm filter (dust corrected) of the bulge.
WFPC450_Bulge	real		[ucd]	Observer-frame apparent (AB) magnitude in the HST WFPC2 0.450μm filter (dust corrected) of the bulge.