Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

101713312388786386331.23888082-5.23675594247394876066575312955509.1963096301.125280.002261558.89297E-060.9984470.8990651.7050924.21840.002258537.8829E-065730688442.44443E-075.58402E-0616986988901247815686016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247394931579027613755509.2069606301.116110.002376238.73044E-060.9979870.6190151.9887424.20530.002344778.07563E-06573068864-7.89231E-084.77904E-06706740801806016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247396038257882064956084.5997338301.160110.001540277.7769E-060.9981490.9981491.7997424.29260.001682086.49405E-065730688841.73045E-076.09569E-06169869889073410566016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247396169844942596156439.5801154601.343190.001569169.80598E-060.2725970.1803291.1752624.25920.0004236372.32656E-06573068904-1.71004E-073.96178E-06169869889006016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247396204634177693756595.2046749601.154270.001512384.94983E-060.9985730.9985733.2198624.29440.001555724.46429E-065730689348.98555E-083.09952E-061698698890408954886016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247396221491924330556084.5880277301.190010.001506647.84793E-060.9982770.9982771.708124.28450.001619566.38274E-065730689443.2375E-076.02042E-06169869889073410566016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247410553690416900155451.3857987401.113240.0008953056.75477E-060.7257630.55960171.77224.690.002056955.07366E-065730690126.39024E-091.49626E-06169869889006016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247410580533962500155801.4656768401.160950.0006164714.43598E-060.9989610.99896163.053324.67820.002068055.10856E-065730690525.8963E-081.63808E-06169869889073410566016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247410586332168349755801.4755793401.185920.0010984.21394E-060.9987080.9987082.3290624.68830.0012684.01415E-065730690621.10105E-071.71416E-0616986988901080043526016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611
101713312388786386331.23888082-5.23675594247410588103842359355804.378647401.138120.001597377.25792E-060.6139810.50558812.086224.6920.001011073.5996E-065730690727.46216E-081.61881E-06169869889006016.27170.027581615.59560.03394615.88790.0345061215.89230.017074315.85420.007946515.73680.076347731614241091150000.9996811150000.9993841150000.9995011150000.9987611150000.99799611


...

Obtain lightcurves for a single object

Goal/Description

Star CSS J030521.9+013231 (Catalina Sky Survey), 584630948352256 (GAIA) is an RR Lyrae with period = 0.55547 days and coordinates RA = 46.341468915923 and DEC = 1.54199810825252 (ref. GAIA DR2,  2018yCat.1345....0G). In the following, we obtain the PSF and aperture photometry lightcurves, both forced and unforced, for this star.

Query #1: Get the ObjID for the star

SELECT d.ID_GAIA,d.RA_GAIA as GAIARA, d.DEC_GAIA as GAIADec, d.Gmag, d.period,
o.objID, o.raMean, o.decMean, o.raMeanErr, o.decMeanErr, o.qualityFlag, o.gMeanPSFMag, o.gMeanPSFMagErr, o.gMeanPSFMagNpt, o.rMeanPSFMag, o.rMeanPSFMagErr, o.rMeanPSFMagNpt, o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanPSFMagNpt, o.zMeanPSFMag, o.zMeanPSFMagErr, o.zMeanPSFMagNpt, o.yMeanPSFMag, o.yMeanPSFMagErr, o.yMeanPSFMagNpt, o.rMeanKronMag, o.rMeanKronMagErr, o.nDetections, o.ng, o.nr, o.ni, o.nz,o.ny, o.gFlags, o.gQfPerfect, o.rFlags, o.rQfPerfect, o.iFlags, o.iQfPerfect, o.zFlags, o.zQfPerfect, o.yFlags, o.yQfPerfect, soa.primaryDetection, soa.bestDetection  INTO mydb.[RRL_584630948352256_PS1] FROM mydb.[rrl_584630948352256] d
CROSS APPLY dbo.fGetNearbyObjEq(d.RA_GAIA, d.DEC_GAIA, 1.0/3600.0) as x
JOIN MeanObjectView o on o.ObjID=x.ObjId
LEFT JOIN StackObjectAttributes AS soa ON soa.objID = x.objID
WHERE o.nDetections>8 
AND soa.primaryDetection>0 
AND o.gQfPerfect>0.85 and o.rQfPerfect>0.85 and o.iQfPerfect>0.85 and o.zQfPerfect>0.85 
AND (o.rmeanpsfmag - o.rmeankronmag < 0.05)

Query #2: Get the detections

SELECT o.ID_GAIA,o.GAIARA, o.GAIADec, o.Gmag, o.period,
o.objID, o.raMean, o.decMean,
d.ra, d.dec, d.raErr, d.decErr, 
d.detectID, d.obstime, d.exptime, d.airmass, d.psfflux, d.psffluxErr, d.psfQf, d.psfQfPerfect, d.psfLikelihood, d.psfChiSq, d.extNSigma, d.zp, d.apFlux, d.apFluxErr,
d.imageID, d.filterID,
d.sky, d.skyerr, d.infoflag, d.infoflag2, d.infoflag3,
o.qualityFlag,
o.gMeanPSFMag, o.gMeanPSFMagErr, o.gMeanPSFMagNpt,
o.rMeanPSFMag, o.rMeanPSFMagErr, o.rMeanPSFMagNpt,
o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanPSFMagNpt,
o.zMeanPSFMag, o.zMeanPSFMagErr, o.zMeanPSFMagNpt,
o.yMeanPSFMag, o.yMeanPSFMagErr, o.yMeanPSFMagNpt, 
o.rMeanKronMag, o.rMeanKronMagErr,
o.nDetections, o.ng, o.nr, o.ni, o.nz,o.ny,
o.gFlags, o.gQfPerfect,
o.rFlags, o.rQfPerfect,
o.iFlags, o.iQfPerfect,
o.zFlags, o.zQfPerfect,
o.yFlags, o.yQfPerfect,
o.primaryDetection, o.bestDetection
 INTO mydb.[RRL_584630948352256_PS1det]
 FROM mydb.[RRL_584630948352256_PS1] o
JOIN Detection d on d.ObjID = o.ObjID

Query #3: Get the forced detections

SELECT o.ID_GAIA,o.GAIARA, o.GAIADec, o.Gmag, o.period,

o.objID, o.raMean, o.decMean,
fwm.detectID, fwm.obstime, fwm.exptime, fwm.airmass, fwm.Fpsfflux, fwm.FpsffluxErr, fwm.FpsfQf, fwm.FpsfQfPerfect, fwm.FpsfChiSq, fwm.zp, fwm.FapFlux, fwm.FapFluxErr,
fwm.forcedWarpID, fwm.filterID,
fwm.Fsky, fwm.Fskyerr, fwm.Finfoflag, fwm.Finfoflag2, fwm.Finfoflag3,
o.qualityFlag,
o.gMeanPSFMag, o.gMeanPSFMagErr, o.gMeanPSFMagNpt,
o.rMeanPSFMag, o.rMeanPSFMagErr, o.rMeanPSFMagNpt,
o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanPSFMagNpt,
o.zMeanPSFMag, o.zMeanPSFMagErr, o.zMeanPSFMagNpt,
o.yMeanPSFMag, o.yMeanPSFMagErr, o.yMeanPSFMagNpt,
o.rMeanKronMag, o.rMeanKronMagErr,
o.nDetections, o.ngo.nro.ni, o.nz,o.ny,
o.gFlags, o.gQfPerfect,
o.rFlags, o.rQfPerfect,
o.iFlags, o.iQfPerfect,
o.zFlags, o.zQfPerfect,
o.yFlags, o.yQfPerfect,
o.primaryDetection, o.bestDetection
INTO mydb.[RRL__584630948352256_PS1forceddet]

FROM mydb.[RRL_584630948352256_PS1] o

JOIN ForcedWarpMeasurement fwm on fwm.ObjID = o.ObjID