Choose a database in the left panel then select the table you want!
Table: gogreen_dr2.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 |
| cluster_z | The redshift of the cluster with which the object is associated. This information is taken from the Clusters.fits table, and just identifies the cluster that was targeted when the galaxy was observed. It does not mean the galaxy is a member of the cluster. | DOUBLE |
| 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 |
| dec_centre | The Dec of the cluster with which the object is associated. This information is taken from the Clusters.fits table, and just identifies the cluster that was targeted when the galaxy was observed. It does not mean the galaxy is a member of the cluster. | 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 |
| ei_tot | Total fluxes in ei 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 |
| ej_tot | Total fluxes in ej filter. See survey paper for derivation detail | DOUBLE |
| ek_tot | Total fluxes in ek filter. See survey paper for derivation detail | DOUBLE |
| eks_tot | Total fluxes in eks filter. See survey paper for derivation detail | DOUBLE |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | 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 |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| h_tot | Total fluxes in h filter. See survey paper for derivation detail | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| i_tot | Total fluxes in i 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 |
| j_tot | Total fluxes in j filter. See survey paper for derivation detail | DOUBLE |
| k_flag | SExtractor flag in the K -band. | DOUBLE |
| k_tot | Total fluxes in k filter. See survey paper for derivation detail | DOUBLE |
| ks_tot | Total fluxes in ks 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 |
| nuvminv | NUV - V, Rest-frame colours between GALEX NUV and Johnson V, as measured with EAZY (Brammer et al. 2008). Note that NUV - V colours are only available for the GOGREEN clusters. For the COSMOS galaxies the rest-frame colours are from the UltraVISTA catalogue. | DOUBLE |
| r_tot | Total fluxes in g 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 |
| ra_centre | The RA of the cluster with which the object is associated. This information is taken from the Clusters.fits table, and just identifies the cluster that was targeted when the galaxy was observed. It does not mean the galaxy is a member of the cluster. | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| redshift_quality | Quality flag for associated spectrum in zspec. This includes literature redshifts from the provided SPECZ_MATCHED files, which can be consulted to identify the source of the redshift. Literature redshifts are all assigned Redshift_Quality=4. | DOUBLE |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| 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 |
| u_tot | Total fluxes in u filter. See survey paper for derivation detail. | 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 |
| v_tot | Total fluxes in v filter. See survey paper for derivation detail | DOUBLE |
| vdisp | The velocity dispersion (in km/s) of the cluster with which the object is associated. This information is taken from the Clusters.fits table, and just identifies the cluster that was targeted when the galaxy was observed. It does not mean the galaxy is a member of the cluster. | 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 |
| y_tot | Total fluxes in y filter. See survey paper for derivation detail | DOUBLE |
| z_tot | Total fluxes in z 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. This includes literature redshifts from the provided SPECZ_MATCHED files, which can be consulted to identify the source of the redshift. Literature redshifts are all assigned Redshift_Quality=4. | DOUBLE |
| zspec_gogreen | Identifies redshifts from GOGREEN or GCLASS only. These are also used in the zspec column | DOUBLE |
