wiki:db/queries/032
Last modified 6 years ago Last modified on 02/01/2013 07:15:42 AM

Find all galaxies brighter than given magnitude

SELECT objectId
FROM   Object
WHERE  fluxToAbMag(rMag) < :rMagMax
  AND  extendedness > 0.8     -- is a galaxy

Origin: SDSS (S-3). Note that the SDSS query also looked at local extinction, which we currently don't have in the schema.