|
These six views named Kitzbichler2006a_Obs - Kitzbichler2006f_Obs
combine the observables from the
Kitzbichler & White (2006)
Johnson
and
SDSS tables.
The sql creating these views was
create view Kitzbichler2006a_Obs as
select j.objectId, j.galaxyId, j.ra,j.dec, j.redshift_obs,j.cos_inc
, j.M_B_stellar/j.M_stellar as bulge2total
, j.B_J,j.V_J,j.R_J,j.I_J,j.K_J,s.g_SDSS,s.r_SDSS,s.i_SDSS,s.z_SDSS
from MPAMocks..Kitzbichler2006a_Johnson j
, MPAMocks..Kitzbichler2006a_SDSS s
where j.objectId = s.objectId
and similar for the other views.
All have the following schema:
| name | datatype | unit | UCD | description |
|---|
| objectID | long | | | Unique ID which encodes the cone directions and observer position plus a sequential number within each cone.
|
| galaxyID | long | | | ID which allows to join light-cone table to galaxy table DeLucia2006a.
|
| ra | float | degree | | right ascension
|
| dec | float | degree | | declination
|
| redshift_obs | float | | | apparent redshift
|
| cos_inc | float | | | cosine of inclination angle
|
| bulge2tot | float | | | bulge/total stellar mass ratio
|
| B_J | float | | | Observer frame apparent (AB) magnitude in Johnson B filter (with dust)
|
| V_J | float | | | Observer frame apparent (AB) magnitude in Johnson V filter (with dust)
|
| R_J | float | | | Observer frame apparent (AB) magnitude in Johnson R filter (with dust)
|
| I_J | float | | | Observer frame apparent (AB) magnitude in Johnson I filter (with dust)
|
| K_J | float | | | Observer frame apparent (AB) magnitude in Johnson K filter (with dust)
|
| g_SDSS | float | | | Observer frame apparent (AB) magnitude in SDSS g filter (with dust)
|
| r_SDSS | float | | | Observer frame apparent (AB) magnitude in SDSS r filter (with dust)
|
| i_SDSS | float | | | Observer frame apparent (AB) magnitude in SDSS i filter (with dust)
|
| z_SDSS | float | | | Observer frame apparent (AB) magnitude in SDSS z filter (with dust)
|
|
