wiki:db/queries/001
Last modified 7 years ago Last modified on 02/01/2013 06:09:35 AM

Extract light curve for a given object (time, magnitude and/or position)

Object is specified through a given objectId, the query is for a given filter. Magnitude:

SELECT taiMidPoint, psfFlux, psfFluxSigma
FROM   Source
JOIN   Filter USING (filterId)
WHERE  objectId = :objectId
   AND filterName = :filterName

Position:

SELECT taiMidPoint, ra, decl
FROM   Source
JOIN   Filter USING (filterId)
WHERE  objectId = :objectId
   AND filterName = :filterName

Magnitude and position:

SELECT taiMidPoint, psfFlux, psfFluxSigma, ra, decl
FROM   Source
JOIN   Filter USING (filterId)
WHERE  objectId = :objectId
   AND filterName = :filterName