wiki:db/queries/001
Last modified 6 years ago Last modified on 01/31/2013 11:09:35 PM

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