wiki:db/queries/019
Last modified 6 years ago Last modified on 02/01/2013 06:19:26 AM

Select all "new" objects

"New objects" means "objects never observed before"

SELECT objectId
FROM   Object
JOIN   DIASource USING(objectId)
WHERE  latestObsTime > :time
GROUP BY (objectId)
HAVING COUNT(objectId) = 1

This selects objects with a single detection observed later than given time. Assumptions: all difference image sources are available. This is not the case at the Base Camp.

An expansion on this would be 'new transients of a given type' or 'new transients which are not classified above X probability as a particular type' (to find new kinds of transients).