Page History
...
101713312388786386 | 331.23888082 | -5.23675594 | 2473948760665753129 | 55509.1963096 | 30 | 1.12528 | 0.00226155 | 8.89297E-06 | 0.998447 | 0.899065 | 1.70509 | 24.2184 | 0.00225853 | 7.8829E-06 | 57306884 | 4 | 2.44443E-07 | 5.58402E-06 | 169869889 | 0 | 124781568 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2473949315790276137 | 55509.2069606 | 30 | 1.11611 | 0.00237623 | 8.73044E-06 | 0.997987 | 0.619015 | 1.98874 | 24.2053 | 0.00234477 | 8.07563E-06 | 57306886 | 4 | -7.89231E-08 | 4.77904E-06 | 706740801 | 8 | 0 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2473960382578820649 | 56084.5997338 | 30 | 1.16011 | 0.00154027 | 7.7769E-06 | 0.998149 | 0.998149 | 1.79974 | 24.2926 | 0.00168208 | 6.49405E-06 | 57306888 | 4 | 1.73045E-07 | 6.09569E-06 | 169869889 | 0 | 7341056 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2473961698449425961 | 56439.5801154 | 60 | 1.34319 | 0.00156916 | 9.80598E-06 | 0.272597 | 0.180329 | 1.17526 | 24.2592 | 0.000423637 | 2.32656E-06 | 57306890 | 4 | -1.71004E-07 | 3.96178E-06 | 169869889 | 0 | 0 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2473962046341776937 | 56595.2046749 | 60 | 1.15427 | 0.00151238 | 4.94983E-06 | 0.998573 | 0.998573 | 3.21986 | 24.2944 | 0.00155572 | 4.46429E-06 | 57306893 | 4 | 8.98555E-08 | 3.09952E-06 | 169869889 | 0 | 40895488 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2473962214919243305 | 56084.5880277 | 30 | 1.19001 | 0.00150664 | 7.84793E-06 | 0.998277 | 0.998277 | 1.7081 | 24.2845 | 0.00161956 | 6.38274E-06 | 57306894 | 4 | 3.2375E-07 | 6.02042E-06 | 169869889 | 0 | 7341056 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2474105536904169001 | 55451.3857987 | 40 | 1.11324 | 0.000895305 | 6.75477E-06 | 0.725763 | 0.559601 | 71.772 | 24.69 | 0.00205695 | 5.07366E-06 | 57306901 | 2 | 6.39024E-09 | 1.49626E-06 | 169869889 | 0 | 0 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2474105805339625001 | 55801.4656768 | 40 | 1.16095 | 0.000616471 | 4.43598E-06 | 0.998961 | 0.998961 | 63.0533 | 24.6782 | 0.00206805 | 5.10856E-06 | 57306905 | 2 | 5.8963E-08 | 1.63808E-06 | 169869889 | 0 | 7341056 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2474105863321683497 | 55801.4755793 | 40 | 1.18592 | 0.001098 | 4.21394E-06 | 0.998708 | 0.998708 | 2.32906 | 24.6883 | 0.001268 | 4.01415E-06 | 57306906 | 2 | 1.10105E-07 | 1.71416E-06 | 169869889 | 0 | 108004352 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
101713312388786386 | 331.23888082 | -5.23675594 | 2474105881038423593 | 55804.378647 | 40 | 1.13812 | 0.00159737 | 7.25792E-06 | 0.613981 | 0.505588 | 12.0862 | 24.692 | 0.00101107 | 3.5996E-06 | 57306907 | 2 | 7.46216E-08 | 1.61881E-06 | 169869889 | 0 | 0 | 60 | 16.2717 | 0.027581 | 6 | 15.5956 | 0.03394 | 6 | 15.8879 | 0.034506 | 12 | 15.8923 | 0.017074 | 3 | 15.8542 | 0.007946 | 5 | 15.7368 | 0.076347 | 73 | 16 | 14 | 24 | 10 | 9 | 115000 | 0.999681 | 115000 | 0.999384 | 115000 | 0.999501 | 115000 | 0.998761 | 115000 | 0.997996 | 1 | 1 |
...
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, 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, FROM mydb.[RRL_584630948352256_PS1] o JOIN ForcedWarpMeasurement fwm on fwm.ObjID = o.ObjID |