wiki:db/queries/006
Last modified 7 years ago Last modified on 02/01/2013 06:13:32 AM

Select the full color image of a single (given) galaxy

To complete this request we need to:

  1. Run a database query that selects the galaxy based on a given objectId, determines its ra, decl and size as well as corresponding exposureId. Since the epoch is not specified, the most recent one will be fetched.
  2. Generate image cut out through Cutout Service.

The database query:

SELECT s.ra, s.decl, o.raRange, o.declRange
FROM   Object o
JOIN   Source s USING (objectId)
WHERE  o.objectId = :objectId
AND    o.latestObsTime = s.taiMidPoint;