wiki:db/queries/054
Last modified 6 years ago Last modified on 02/01/2013 12:30:58 AM

Select all unresolved objects in a specified region with cuts on attributes

SELECT objectId
FROM   Object
WHERE  areaSpec_box(:raMin, :declMin, :raMax, :declMax)
  AND  extendedParameter < 0.2
  AND  gMag-rMag > :grThreshold
  AND  (muRa * muRa + muDecl * muDecl) < :properMotionThreshold
  AND  redshift BETWEEN :z1 AND :z2

Origin: suggested by the LSST Science Collaboration (Stellar Populations)