wiki:db/queries/038
Last modified 6 years ago Last modified on 02/01/2013 12:13:13 AM

Find galaxies with an isophotal surface brightness (SB) larger than ? in the ? band, with an ellipticity > ? and with position angle between ? and ? arc seconds

This is a full table scan on the Object table.

SELECT  objectId
FROM    Object   
WHERE   extendedness > 0.8                         -- select galaxies
  AND   fluxToAbMag(rFlux_SG) < 24                 -- brighter than magnitude 24  
  AND   rRadius_SG BETWEEN 30 AND 60               -- major axis between 30" and 60"
  AND   (POWER(rE1_SG,2) + POWER(uE1_SG,2)) > 0.25 -- square of ellipticity is > 0.25 squared

This query originally came from SDSS (S-4)