SDSS_DR8.SclGalaxy table

The SclGalaxy table links superclusters with individual galaxies. The table is useful for joining Galaxy and Supercluster tables.

Table structure

ColumnTypeUCDUnitDescription
galidintmeta.id
meta.main
galaxy id
dleveldecimal(3,1)stat.paramdensity level
sclidintmeta.idsupercluster id
adapttinyintmeta.codeadaptive flag

Sample queries

  1. Get all galaxies belonging to the supercluster Scl 27 at fixed density threshold D = 5.0. This query joins the Galaxy and SclGalaxy tables, assigns table aliases, and fetches all columns from the Galaxy table.
    SELECT gal.*
    FROM SDSS_DR8.Galaxy AS gal
    JOIN SDSS_DR8.SclGalaxy AS sclgal USING (galid)
    WHERE sclgal.sclid=27 AND sclgal.dlevel=5.0
  2. Get all galaxies from superclusters found with the adaptive density threshold where the luminosity lum_tot_gal is larger than 300. This query joins the Galaxy, SclGalaxy and Supercluster tables, and fetches all columns from the Galaxy table together with the supercluster ID sclid and density level dlevel.
    SELECT gal.*, scl.sclid, scl.dlevel
    FROM SDSS_DR8.Galaxy AS gal
    JOIN SDSS_DR8.SclGalaxy AS sclgal USING (galid)
    JOIN SDSS_DR8.Supercluster AS scl USING (sclid,dlevel)
    WHERE scl.lum_tot_gal > 300 AND scl.adapt=1