Choose a database in the left panel then select the table you want!
Table: gogreen_dr1.photo
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| b_tot | Total fluxes in b filter. See survey paper for derivation detail | DOUBLE |
| cluster | Name of the corresponding cluster, when there is an associated photometric catalogue. Objects in the COSMOS or SXDF photometric catalogues are identified with those labels, unless there is a GOGREEN spectroscopic redshift, in which case we use the name of the associated target. Note that SXDF49 and SXDF87 share a field, and are identified here only by SXDF49. Similarly SXDF76a and SXDF76b are identified here as SXDF76. | VARCHAR |
| cphotid | This is a unique identifier for each object in this table. The first digit identifies the source of the photometry (1: GOGREEN; 2: GCLASS; 3: UltraVISTA/COSMOS; 4:SPLASH/SXDF). The next two digits are the cluster_id column from Table 2. The remaining numbers are the PHOTID identifier in the main photometric catalogues | INTEGER |
| dec | J2000 positions, in degrees. Calibrated with SDSS DR7 or USNO-b whenever a cluster falls outside of the SDSS footprint. | DOUBLE |
| eb_tot | Total fluxes in eb filter. See survey paper for derivation detail | DOUBLE |
| efuv_tot | Total fluxes in efuv filter. See survey paper for derivation detail | DOUBLE |
| eg_tot | Total fluxes in eg filter. See survey paper for derivation detail | DOUBLE |
| eh_tot | Total fluxes in eh filter. See survey paper for derivation detail | DOUBLE |
| eia484_tot | Total fluxes in eia484 filter. See survey paper for derivation detail | DOUBLE |
| eia527_tot | Total fluxes in eia527 filter. See survey paper for derivation detail | DOUBLE |
| eia624_tot | Total fluxes in eia624 filter. See survey paper for derivation detail | DOUBLE |
| eia679_tot | Total fluxes in eia679 filter. See survey paper for derivation detail | DOUBLE |
| eia738_tot | Total fluxes in eia738 filter. See survey paper for derivation detail | DOUBLE |
| eia767_tot | Total fluxes in eia767 filter. See survey paper for derivation detail | DOUBLE |
| eib427_tot | Total fluxes in eib427 filter. See survey paper for derivation detail | DOUBLE |
| eib464_tot | Total fluxes in eib464 filter. See survey paper for derivation detail | DOUBLE |
| eib505_tot | Total fluxes in eib505 filter. See survey paper for derivation detail | DOUBLE |
| eib574_tot | Total fluxes in eib574 filter. See survey paper for derivation detail | DOUBLE |
| eib709_tot | Total fluxes in eib709 filter. See survey paper for derivation detail | DOUBLE |
| eib827_tot | Total fluxes in eib827 filter. See survey paper for derivation detail | DOUBLE |
| eirac1_tot | Total fluxes in eirac1 filter. See survey paper for derivation detail | DOUBLE |
| eirac2_tot | Total fluxes in eirac2 filter. See survey paper for derivation detail | DOUBLE |
| eirac3_tot | Total fluxes in eirac3 filter. See survey paper for derivation detail | DOUBLE |
| eirac4_tot | Total fluxes in eirac4 filter. See survey paper for derivation detail | DOUBLE |
| ei_tot | Total fluxes in ei filter. See survey paper for derivation detail | DOUBLE |
| ej_tot | Total fluxes in ej filter. See survey paper for derivation detail | DOUBLE |
| eks_tot | Total fluxes in eks filter. See survey paper for derivation detail | DOUBLE |
| ek_tot | Total fluxes in ek filter. See survey paper for derivation detail | DOUBLE |
| emips24_tot | Total fluxes in emips24 filter. See survey paper for derivation detail | DOUBLE |
| enuv_tot | Total fluxes in enuv filter. See survey paper for derivation detail | DOUBLE |
| er_tot | Total fluxes in er filter. See survey paper for derivation detail | DOUBLE |
| eu_tot | Total fluxes in eu filter. See survey paper for derivation detail | DOUBLE |
| ev_tot | Total fluxes in ev filter. See survey paper for derivation detail | DOUBLE |
| ey_tot | Total fluxes in ey filter. See survey paper for derivation detail | DOUBLE |
| ez_tot | Total fluxes in ez filter. See survey paper for derivation detail | DOUBLE |
| fuv_tot | Total fluxes in fuv filter. See survey paper for derivation detail | DOUBLE |
| g_tot | Total fluxes in g filter. See survey paper for derivation detail | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| h_tot | Total fluxes in h filter. See survey paper for derivation detail | DOUBLE |
| ia484_tot | Total fluxes in ia484 filter. See survey paper for derivation detail | DOUBLE |
| ia527_tot | Total fluxes in ia527 filter. See survey paper for derivation detail | DOUBLE |
| ia624_tot | Total fluxes in ia624 filter. See survey paper for derivation detail | DOUBLE |
| ia679_tot | Total fluxes in a679 filter. See survey paper for derivation detail | DOUBLE |
| ia738_tot | Total fluxes in ia738 filter. See survey paper for derivation detail | DOUBLE |
| ia767_tot | Total fluxes in ia767 filter. See survey paper for derivation detail | DOUBLE |
| ib427_tot | Total fluxes in ib427 filter. See survey paper for derivation detail | DOUBLE |
| ib464_tot | Total fluxes in ib464 filter. See survey paper for derivation detail | DOUBLE |
| ib505_tot | Total fluxes in ib505 filter. See survey paper for derivation detail | DOUBLE |
| ib574_tot | Total fluxes in ib574 filter. See survey paper for derivation detail | DOUBLE |
| ib709_tot | Total fluxes in ib709 filter. See survey paper for derivation detail | DOUBLE |
| ib827_tot | Total fluxes in ib827 filter. See survey paper for derivation detail | DOUBLE |
| irac1_tot | Total fluxes in irac1 filter. See survey paper for derivation detail | DOUBLE |
| irac2_tot | Total fluxes in irac2 filter. See survey paper for derivation detail | DOUBLE |
| irac3_tot | Total fluxes in irac3 filter. See survey paper for derivation detail | DOUBLE |
| irac4_tot | Total fluxes in irac4 filter. See survey paper for derivation detail | DOUBLE |
| i_tot | Total fluxes in i filter. See survey paper for derivation detail | DOUBLE |
| j_tot | Total fluxes in j filter. See survey paper for derivation detail | DOUBLE |
| k_flag | SExtractor flag in the K -band. | DOUBLE |
| ks_tot | Total fluxes in ks filter. See survey paper for derivation detail | DOUBLE |
| k_tot | Total fluxes in k filter. See survey paper for derivation detail | DOUBLE |
| mips24_tot | Total fluxes in mips24 filter. See survey paper for derivation detail | DOUBLE |
| mstellar | Total stellar masses, measured with the FAST (Kriek et al. 2009) code and assuming the best redshift for the object (spectroscopic or zphot). These assume tau-model star formation histories, and are known to underestimate the stellar mass obtained with a non-parametric star formation history, by up to 0.3 dex (Leja et al. 2019). For objects in COSMOS and SXDF the stellar masses are taken from their respective catalogues. | DOUBLE |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
| nuv_tot | Total fluxes in nuv filter. See survey paper for derivation detail | DOUBLE |
| ra | J2000 positions, in degrees. Calibrated with SDSS DR7 or USNO-b whenever a cluster falls outside of the SDSS footprint. | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| redshift_quality | Quality flag for associated spectrum in zspec | DOUBLE |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| r_tot | Total fluxes in g filter. See survey paper for derivation detail | DOUBLE |
| specid | The ID corresponding to Table 4 for objects with a corresponding GCLASS or GOGREEN spectrum | INTEGER |
| star | Star/galaxy classification based on colours, as described in van der Burg et al. (2020). Flag is 1 for a star, and 0 otherwise. | DOUBLE |
| totmask | Manual mask at position of detection, where objects are masked (totmask= 1) if they do not have an image in all available filters for that cluster. Only sources with totmask=0 are included in this compilation catalogue. Photometry for other sources must be obtained from the original catalogues. | DOUBLE |
| uminv | U - V, Rest-frame colours between Johnson U and V, as measured with EAZY (Brammer et al. 2008). Small offsets, as described in van der Burg et al. (2020), have been applied on a cluster-by-cluster basis to improve correspondence with UltraVISTA. For the COSMOS galaxies the rest-frame colours are from the UltraVISTA catalogue. | DOUBLE |
| u_tot | Total fluxes in u filter. See survey paper for derivation detail. | DOUBLE |
| vminj | V - J, Rest-frame colours between Johnson V and J, as measured with EAZY (Brammer et al. 2008). Small offsets, as described in van der Burg et al. (2020), have been applied on a cluster-by-cluster basis to improve correspondence with UltraVISTA. For the COSMOS galaxies the rest-frame colours are from the UltraVISTA catalogue. | DOUBLE |
| v_tot | Total fluxes in v filter. See survey paper for derivation detail | DOUBLE |
| y_tot | Total fluxes in y filter. See survey paper for derivation detail | DOUBLE |
| zphot | Photometric redshift from the 68 per cent confidence region. Based on the zpeak output from EAZY (Brammer et al. 2008), where for the GOGREEN galaxies a polynomial correction is applied to improve the correspondence with spectroscopy. | DOUBLE |
| zphot_l68 | Photometric redshift loweri uncertainty for zphot | DOUBLE |
| zphot_u68 | Photometric redshift upper uncertainty for zphot | DOUBLE |
| zspec | The spectroscopic redshift for the associated spectrum, if any. (See redshift_quality for the quality flag). Redshifts without a corresponding Redshift_Quality are copied from the parent (UltraVISTA or SPLASH) catalogue. | DOUBLE |
| z_tot | Total fluxes in z filter. See survey paper for derivation detail | DOUBLE |
