Page History
...
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 light-curves, both forced and unforced, for this star.
Query #1: Get the ObjID for the star
...
SELECT 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 INTO mydb.[RRL_584630948352256_PS1] FROM dbo.fGetNearbyObjEq(46.341468915923, 1.54199810825252, 1.0/60.0) as x JOIN MeanObjectView o on o.ObjID=x.ObjId |
Results (1 entry, < 1 min)
objID | raMean | decMean | raMeanErr | decMeanErr | qualityFlag | gMeanPSFMag | gMeanPSFMagErr | gMeanPSFMagNpt | rMeanPSFMag | rMeanPSFMagErr | rMeanPSFMagNpt | iMeanPSFMag | iMeanPSFMagErr | iMeanPSFMagNpt | zMeanPSFMag | zMeanPSFMagErr | zMeanPSFMagNpt | yMeanPSFMag | yMeanPSFMagErr | yMeanPSFMagNpt | rMeanKronMag | rMeanKronMagErr | nDetections | ng | nr | ni | nz | ny | gFlags | gQfPerfect | rFlags | rQfPerfect | iFlags | iQfPerfect | zFlags | zQfPerfect | yFlags | yQfPerfect |
109850463414820867 | 46.34146986 | 1.54199906 | 0.00303000002168119 | 0.00392000004649162 | 60 | 17.6399002075195 | 0.029891999438405 | 12 | 17.1961994171143 | 0.0448860004544258 | 13 | 17.4811992645264 | 0.0493410006165504 | 23 | 17.5072002410889 | 0.0579570010304451 | 10 | 17.5268001556396 | 0.0218189992010593 | 10 | 17.2178001403809 | 0.0414300002157688 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504029750824 | 115000 | 0.999719977378845 | 115000 | 0.999532997608185 | 115000 | 0.99897301197052 | 115000 | 0.99940699338913 |
Query #2: Get the detections
...
SELECT 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 INTO mydb.[RRL_584630948352256_PS1det] FROM mydb.[RRL_584630948352256_PS1] o JOIN Detection d on d.ObjID = o.ObjID |
Results (92 entries, < 1 min)
Below are the first 10 entries out of 92 total entries
...
SELECT 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.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 INTO mydb.[RRL__584630948352256_PS1forceddet] FROM mydb.[RRL_584630948352256_PS1] o JOIN ForcedWarpMeasurement fwm on fwm.ObjID = o.ObjID |
Results (84 entries, <1 min)
Below are the first 10 entries out of 84 total entries
...