3.3.22.3.2  :  GAL_Gonzalez2014a

This table contains the semi-analytic galaxy catalogues which were used to generate the lightcones in the DESI_v1 database. Note that this table is not identical to Gonzalez2014a..MR7 because a different set of bands were used.

The table contains galaxies at 52 snapshots between z=0.0 and z=10.0 in a 500Mpc/h box. Each galaxy has a unique identifier, GalaxyID, assigned in such a way that progenitors or descendants of particular galaxies can easily be identified using SQL queries. See the documentation on merger trees for details of the indexing scheme.

This table is referred to as DESI_v1..GAL_Gonzalez2014a in SQL queries. For example, to retrieve all properties for 10 galaxies from the z=0 snapshot: 

select top 10 * from DESI_v1..GAL_Gonzalez2014a where snapnum = 61

The relation between snapshot number and redshift for this model is given by the table Snapshots..MR7.

Important: Note that absolute magnitude columns in this table contain the quantity M-5 log(h).

columntypeUCDunitdescription
GalaxyID long ID of galaxy, unique within simulation and semi-analytic run
DescendantID long GalaxyID of the descendant of this galaxy.
LastProgenitorID long All galaxies with IDs between the ID of this galaxy and LastProgenitorId are in the merger tree rooted at this galaxy.
MainLeafID long The ID of the galaxy at the end of the main progenitor branch of this galaxy.
DHaloID long The ID of the DHalo which this galaxy belongs to.
Redshift float The redshift at which this galaxy exists
SnapNum integer The snapshot number at which this galaxy exists
type integer Indicates if this galaxy is central (0), a satellite with a resolved subhalo (1) or a satellite with no subhalo (2)
mdhalo float 1.0e10Msolar/h The mass of the DHalo which this galaxy belongs to.
phkey integer Peano-Hilbert key for this galaxy's position in the simulation box. See the text on spatial indexes.
zindex integer The "bit-interleaved" or "Z-curve" index, corresponding to this galaxy's position. See the text on spatial indexes.
ix integer Zone index along x-direction. See the text on spatial indexes.
iy integer Zone index along y-direction. See the text on spatial indexes.
iz integer Zone index along z-direction. See the text on spatial indexes.
random float A random number in the range 0-1, used for random sampling the galaxies
x float Mpc/h (comoving) X coordinate of this galaxy in the simulation box
y float Mpc/h (comoving) Y coordinate of this galaxy in the simulation box
z float Mpc/h (comoving) Z coordinate of this galaxy in the simulation box
velx float km/sec X component of peculiar velocity of this galaxy
vely float km/sec Y component of peculiar velocity of this galaxy
velz float km/sec Z component of peculiar velocity of this galaxy
rdisk float Mpc/h Half mass radius of the disk
rbulge float Mpc/h Half mass radius of the bulge
vdisk float km/sec Circular velocity at the half mass radius of the disk
vbulge float km/sec Circular velocity at the half mass radius of the bulge
stellarmass float 1.0e10Msolar/h Total stellar mass in the galaxy
bulgemass float 1.0e10Msolar/h Total stellar mass of the galactic bulge
blackholemass float 1.0e10Msolar/h Mass of the central black hole
coldgas float 1.0e10Msolar/h Mass of cold gas in the galactic disk
sfr float Msolar/yr Quiescent star formation rate in the disk
sfrbulge float Msolar/yr Star formation rate in bursts
coldgas_atomic float 1.0e10Msolar/h Mass of atomic gas in the galactic disk
coldgas_atomic_bulge float 1.0e10Msolar/h Mass of atomic gas in bursts
coldgas_mol float 1.0e10Msolar/h Mass of molecular gas in the galactic disk
coldgas_mol_bulge float 1.0e10Msolar/h Mass of molecular gas in bursts
hotgas float 1.0e10Msolar/h Mass of hot gas associated with this galaxy
metals_stellarmass float 1.0e10Msolar/h Total mass of metals in stars
metals_bulgemass float 1.0e10Msolar/h Mass of metals in stars in the bulge
metals_coldgas float 1.0e10Msolar/h Mass of metals in cold gas
metals_hotgas float 1.0e10Msolar/h Mass of metals in hot gas
mag_B float Absolute rest frame B magnitude (AB) with extinction
mag_B_obs float Absolute observed frame B magnitude (AB) with extinction
mag_V float Absolute rest frame V magnitude (AB) with extinction
mag_V_obs float Absolute observed frame V magnitude (AB) with extinction
mag_R float Absolute rest frame R magnitude (AB) with extinction
mag_R_obs float Absolute observed frame R magnitude (AB) with extinction
mag_J float Absolute rest frame J magnitude (AB) with extinction
mag_J_obs float Absolute observed frame J magnitude (AB) with extinction
mag_H float Absolute rest frame H magnitude (AB) with extinction
mag_H_obs float Absolute observed frame H magnitude (AB) with extinction
mag_Ks float Absolute rest frame Ks magnitude (AB) with extinction
mag_Ks_obs float Absolute observed frame Ks magnitude (AB) with extinction
mag_K float Absolute rest frame K magnitude (AB) with extinction
mag_K_obs float Absolute observed frame K magnitude (AB) with extinction
mag_L float Absolute rest frame L magnitude (AB) with extinction
mag_L_obs float Absolute observed frame L magnitude (AB) with extinction
SDSS_u float Absolute rest frame SDSS u band magnitude (AB) with extinction
SDSS_u_obs float Absolute observed frame SDSS u band magnitude (AB) with extinction
SDSS_g float Absolute rest frame SDSS g band magnitude (AB) with extinction
SDSS_g_obs float Absolute observed frame SDSS g band magnitude (AB) with extinction
SDSS_r float Absolute rest frame SDSS r band magnitude (AB) with extinction
SDSS_r_obs float Absolute observed frame SDSS r band magnitude (AB) with extinction
SDSS_i float Absolute rest frame SDSS i band magnitude (AB) with extinction
SDSS_i_obs float Absolute observed frame SDSS i band magnitude (AB) with extinction
SDSS_z float Absolute rest frame SDSS z band magnitude (AB) with extinction
SDSS_z_obs float Absolute observed frame SDSS z band magnitude (AB) with extinction
DES_g float Absolute rest frame DES g band magnitude (AB) with extinction
DES_g_obs float Absolute observed frame DES g band magnitude (AB) with extinction
DES_r float Absolute rest frame DES r band magnitude (AB) with extinction
DES_r_obs float Absolute observed frame DES r band magnitude (AB) with extinction
DES_i float Absolute rest frame DES i band magnitude (AB) with extinction
DES_i_obs float Absolute observed frame DES i band magnitude (AB) with extinction
DES_z float Absolute rest frame DES z band magnitude (AB) with extinction
DES_z_obs float Absolute observed frame DES z band magnitude (AB) with extinction
DES_Y float Absolute rest frame DES Y band magnitude (AB) with extinction
DES_Y_obs float Absolute observed frame DES Y band magnitude (AB) with extinction
EUCLID_Y float Absolute rest frame EUCLID Y band magnitude (AB) with extinction
EUCLID_Y_obs float Absolute observed frame EUCLID Y band magnitude (AB) with extinction
EUCLID_J float Absolute rest frame EUCLID J band magnitude (AB) with extinction
EUCLID_J_obs float Absolute observed frame EUCLID J band magnitude (AB) with extinction
EUCLID_Hp float Absolute rest frame EUCLID H band magnitude (AB) with extinction
EUCLID_Hp_obs float Absolute observed frame EUCLID H band magnitude (AB) with extinction
EUCLID_K float Absolute rest frame EUCLID K band magnitude (AB) with extinction
EUCLID_K_obs float Absolute observed frame EUCLID K band magnitude (AB) with extinction
GALEX_FUV float Absolute rest frame GALEX FUV band magnitude (AB) with extinction
GALEX_NUV float Absolute rest frame GALEX NUV band magnitude (AB) with extinction
IRAC_36 float Absolute rest frame IRAC 3.6micron band magnitude (AB) with extinction
IRAC_36_obs float Absolute observed frame IRAC 3.6micron band magnitude (AB) with extinction
IRAC_45 float Absolute rest frame IRAC 4.5micron band magnitude (AB) with extinction
IRAC_45_obs float Absolute observed frame IRAC 4.5micron band magnitude (AB) with extinction
IRAC_58 float Absolute rest frame IRAC 5.8micron band magnitude (AB) with extinction
IRAC_58_obs float Absolute observed frame IRAC 5.8micron band magnitude (AB) with extinction
IRAC_80 float Absolute rest frame IRAC 8.0micron band magnitude (AB) with extinction
IRAC_80_obs float Absolute observed frame IRAC 8.0micron band magnitude (AB) with extinction
MUSYC_I float Absolute rest frame MUSYC I band magnitude (AB) with extinction
MUSYC_I_obs float Absolute observed frame MUSYC I band magnitude (AB) with extinction
PanSTARRS_w float Absolute rest frame PanSTARRS w band magnitude (AB) with extinction
PanSTARRS_w_obs float Absolute observed frame PanSTARRS w band magnitude (AB) with extinction
PanSTARRS_y float Absolute rest frame PanSTARRS y band magnitude (AB) with extinction
PanSTARRS_y_obs float Absolute observed frame PanSTARRS y band magnitude (AB) with extinction
LBulge_Halpha float 1040h-2erg/s Bulge luminosity in the Halpha emission line (with dust extinction)
LBulge_Hbeta float 1040h-2erg/s Bulge luminosity in the Hbeta emission line (with dust extinction)
LBulge_Hgamma float 1040h-2erg/s Bulge luminosity in the Hgamma emission line (with dust extinction)
LBulge_Lyalpha float 1040h-2erg/s Bulge luminosity in the Lyalpha emission line (with dust extinction)
LBulge_NII6583 float 1040h-2erg/s Bulge luminosity in the NII6583 emission line (with dust extinction)
LBulge_OII3727 float 1040h-2erg/s Bulge luminosity in the OII3727 emission line (with dust extinction)
LBulge_OIII4959 float 1040h-2erg/s Bulge luminosity in the OIII4959 emission line (with dust extinction)
LBulge_OIII5007 float 1040h-2erg/s Bulge luminosity in the OIII5007 emission line (with dust extinction)
L_Halpha float 1040h-2erg/s Total luminosity in the Halpha emission line (with dust extinction)
L_Hbeta float 1040h-2erg/s Total luminosity in the Hbeta emission line (with dust extinction)
L_Hgamma float 1040h-2erg/s Total luminosity in the Hgamma emission line (with dust extinction)
L_Lyalpha float 1040h-2erg/s Total luminosity in the Lyalpha emission line (with dust extinction)
L_NII6583 float 1040h-2erg/s Total luminosity in the NII6583 emission line (with dust extinction)
L_OII3727 float 1040h-2erg/s Total luminosity in the OII3727 emission line (with dust extinction)
L_OIII4959 float 1040h-2erg/s Total luminosity in the OIII4959 emission line (with dust extinction)
L_OIII5007 float 1040h-2erg/s Total luminosity in the OIII5007 emission line (with dust extinction)
EWBulge_Halpha float Angstroms Equivalent width of the Halpha emission line (bulge component, with dust extinction)
EWBulge_Hbeta float Angstroms Equivalent width of the Hbeta emission line (bulge component, with dust extinction)
EWBulge_Hgamma float Angstroms Equivalent width of the Hgamma emission line (bulge component, with dust extinction)
EWBulge_Lyalpha float Angstroms Equivalent width of the Lyalpha emission line (bulge component, with dust extinction)
EWBulge_NII6583 float Angstroms Equivalent width of the NII6583 emission line (bulge component, with dust extinction)
EWBulge_OII3727 float Angstroms Equivalent width of the OII3727 emission line (bulge component, with dust extinction)
EWDisk_Halpha float Angstroms Equivalent width of the Halpha emission line (disk component, with dust extinction)
EWDisk_Hbeta float Angstroms Equivalent width of the Hbeta emission line (disk component, with dust extinction)
EWDisk_Hgamma float Angstroms Equivalent width of the Hgamma emission line (disk component, with dust extinction)
EWDisk_Lyalpha float Angstroms Equivalent width of the Lyalpha emission line (disk component, with dust extinction)
EWDisk_NII6583 float Angstroms Equivalent width of the NII6583 emission line (disk component, with dust extinction)
EWDisk_OII3727 float Angstroms Equivalent width of the OII3727 emission line (disk component, with dust extinction)
EWDisk_OIII4959 float Angstroms Equivalent width of the OIII4959 emission line (disk component, with dust extinction)
EWDisk_OIII5007 float Angstroms Equivalent width of the OIII5007 emission line (disk component, with dust extinction)
EW_Halpha float Angstroms Equivalent width of the Halpha emission line (total, with dust extinction)
EW_Hbeta float Angstroms Equivalent width of the Hbeta emission line (total, with dust extinction)
EW_Hgamma float Angstroms Equivalent width of the Hgamma emission line (total, with dust extinction)
EW_Lyalpha float Angstroms Equivalent width of the Lyalpha emission line (total, with dust extinction)
EW_NII6583 float Angstroms Equivalent width of the NII6583 emission line (total, with dust extinction)
EW_OII3727 float Angstroms Equivalent width of the OII3727 emission line (total, with dust extinction)
EW_OIII4959 float Angstroms Equivalent width of the OIII4959 emission line (total, with dust extinction)
EW_OIII5007 float Angstroms Equivalent width of the OIII5007 emission line (total, with dust extinction)