3.3.18.3 : Pencil Beam Tables

The database contains pencilbeam light-cones for 24 different lines-of-sight through the scaled MRscPlanck1 catalogue for each stellar populations synthesis model. Total and bulge observer-frame apparent magnitudes in 40 different photometric bands are included both corrected for dust extinction (all in AB system). These cones are named

Henriques2015a.cones.MRscPlanck1_M05_001, Henriques2015a.cones.MRscPlanck1_M05_002, .. , Henriques2015a.cones.MRscPlanck1_M05_024 (Maraston2005 stellar populations)
Henriques2015a.cones.MRscPlanck1_BC03_001, Henriques2015a.cones.MRscPlanck1_BC03_002, .. , Henriques2015a.cones.MRscPlanck1_BC03_024 (Bruzual&Charlot2003 stellar populations)

To retrieve information about the physical properties of galaxies one can join to the MRscPlanck1 table as in the following example:

select c.*, g.stellarmass, g.coldgas
  from Henriques2015a.cones.MRscPlanck1_M05_001 c
  ,    Henriques2015a..MRscPlanck1 g
 where g.galaxyId = c.galaxyId

Note, in contrast to the older cone catalogues in MPAMocks and Henriques2012a, the cones here are circular with opening angle 2^o.

name	datatype	unit	UCD	description
galaxyId	bigint		[ucd]	Identifier of the galaxy in the Henriques2015a..MRscPlanck1 table. Pointer to the galaxyId column in that table.
ix	integer			The number of replications in the X direction that were made to find this galaxy in the light cone.
iy	integer			The number of replications in the Y direction that were made to find this galaxy in the light cone.
iz	integer			The number of replications in the Z direction that were made to find this galaxy in the light cone.
snapnum	integer			The snapshot number for this galaxy in the simulation as defined in Snapshots..MRscPlanck1.
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. There are no negative values of RA, hence roughly half of the galaxies will have RA near 360 degrees.
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.
cx	real	Mpc/h		X-component of galaxy's RA/Dec position expressed as unit vector on the sphere.
cy	real	Mpc/h		Y-component of galaxy's RA/Dec position expressed as unit vector on the sphere.
cz	real	Mpc/h		Z-component of galaxy's RA/Dec position expressed as unit vector on the sphere.
d_comoving	real	Mpc/h	[ucd]	Comoving distance to the galaxy.
dlum	real	Mpc	[ucd]	Luminosity distance to the galaxy.
ang_dist	real	Mpc	[ucd]	Angular diameter distance to the galaxy.
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.
vpec	real	km/s	[ucd]	Line-of-sight (peculiar) velocity of the galaxy in km/s.
gx	real	Mpc/h		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.
gy	real	Mpc/h		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.
gz	real	Mpc/h		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.
diskSize	real	arcsec	[ucd]	Apparent size of disk. Derived from galaxy's intrinsic stellarDiskRadius defined in main galaxy catalogue and angular diameter distance.
bulgeSize	real	arcsec	[ucd]	Apparent size of bulge. Derived from galaxy's intrinsic bulgeSize defined in main galaxy catalogue and angular diameter distance.
inclination	real	deg	[ucd]	Inclination of the galaxy based on the orientation of the disk as defined by the spin axis and the orientation of the light cone. Not the same as the inclination in the galaxy table, which indicates the angle of the spin axis wrt the Z-axis of the simulation cube.
PA	real	deg	[ucd]	Position angle of the galaxy wrt the circle of constant ra through the galaxy.
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.
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.
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_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.