Get high-fidelity stars in given area
Goal/Description
We want to get all objects with R degrees of a given position that are high fidelity stellar-like objects.
We get all objects within 0.2 degree of RA=334.0 and Dec=0.0 which have mean magnitudes in griz (i.e. at least 1 detection in each band that can be used for the mean mag). In addition, we require QfPerfect>0.85 in all bands. We select stars with the difference between Kron and PSF magnitude as described here.
Note that the search radius is in arcminutes. This is a recent change in the interface to make the PS1 database functions consistent with those used for SDSS, GALEX, Kepler, the HSC, and other MAST catalogs.
Tables used
MeanObjectView
StackObjectAttributes
Query
|
Results
696 objects, here are the first 10:
107763340006509592 | 334.00067427 | -0.19239401 | 0.00192 | 0.00245 | 60 | 19.6313 | 0.007621 | 14 | 18.3653 | 0.006528 | 15 | 17.2444 | 0.002347 | 26 | 16.7225 | 0.002455 | 12 | 16.4851 | 0.015898 | 13 | 18.4699 | 0.009761 | 93 | 16 | 17 | 34 | 12 | 14 | 115000 | 0.999873 | 115000 | 0.999291 | 115000 | 0.999634 | 115000 | 0.999044 | 115000 | 0.999622 | 1 | 1 |
107763340149672418 | 334.01502523 | -0.19839402 | 0.00518 | 0.00285 | 52 | 21.9751 | 0.083929 | 3 | 20.7948 | 0.031693 | 15 | 19.6486 | 0.013022 | 17 | 19.1114 | 0.012857 | 12 | 18.8021 | 0.026564 | 14 | 20.9895 | 0.053647 | 65 | 3 | 15 | 20 | 13 | 14 | 115000 | 0.999462 | 115000 | 0.999644 | 115000 | 0.999309 | 115000 | 0.999628 | 115000 | 0.998982 | 1 | 1 |
107763340365446394 | 334.03656773 | -0.1951062 | 0.02425 | 0.02707 | 52 | 21.8092 | 0.062935 | 6 | 21.3268 | 0.0751 | 12 | 21.0911 | 0.027663 | 24 | 20.5195 | 0.04418 | 10 | 19.3565 | 0.000343 | 1 | 21.4159 | 0.068216 | 63 | 8 | 14 | 29 | 10 | 2 | 16892216 | 0.999325 | 115000 | 0.999636 | 115000 | 0.999367 | 115000 | 0.999632 | 16892216 | 0.998982 | 1 | 1 |
107773339339718616 | 333.93399766 | -0.18485765 | 0.00422 | 0.00798 | 60 | 21.0967 | 0.057864 | 12 | 19.896 | 0.011242 | 12 | 18.614 | 0.00688 | 29 | 18.0234 | 0.004613 | 10 | 17.7739 | 0.022577 | 9 | 20.0117 | 0.031177 | 85 | 12 | 12 | 37 | 12 | 12 | 115000 | 0.999404 | 115000 | 0.999715 | 115000 | 0.999856 | 115000 | 0.999515 | 115000 | 0.999526 | 1 | 1 |
107773339418197028 | 333.94187857 | -0.18614146 | 0.01971 | 0.03959 | 52 | 21.5705 | 0.012027 | 2 | 20.981 | 0.008091 | 6 | 20.586 | 0.02858 | 27 | 20.3225 | 0.049434 | 8 | 20.3266 | 0.143002 | 1 | 20.9779 | 0.153102 | 60 | 4 | 9 | 35 | 11 | 1 | 115000 | 0.999 | 115000 | 0.999029 | 115000 | 0.999628 | 115000 | 0.999253 | 114992 | 0.997765 | 1 | 1 |
107773339602519327 | 333.96026447 | -0.18427345 | 0.00452 | 0.0079 | 60 | 21.079 | 0.018093 | 6 | 19.7609 | 0.014422 | 6 | 18.456 | 0.004637 | 21 | 17.8612 | 0.006005 | 10 | 17.6079 | 0.035327 | 6 | 19.8238 | 0.015897 | 65 | 8 | 11 | 25 | 10 | 11 | 115000 | 0.999168 | 115000 | 0.999158 | 115000 | 0.999613 | 115000 | 0.999212 | 115000 | 0.998133 | 1 | 1 |
107773339666312601 | 333.96664968 | -0.1898753 | 0.00262 | 0.00237 | 60 | 18.3317 | 0.005523 | 14 | 17.7711 | 0.002763 | 14 | 17.531 | 0.003137 | 27 | 17.4243 | 0.006355 | 7 | 17.3689 | 0.016866 | 8 | 17.8509 | 0.00506 | 77 | 14 | 16 | 29 | 8 | 10 | 115000 | 0.999479 | 115000 | 0.999742 | 115000 | 0.999548 | 115000 | 0.99868 | 115000 | 0.998906 | 1 | 1 |
107773339901521365 | 333.99016194 | -0.19086722 | 0.00392 | 0.00732 | 52 | 21.9495 | 0.067887 | 9 | 20.8339 | 0.024821 | 13 | 19.3754 | 0.005145 | 33 | 18.642 | 0.01119 | 12 | 18.2968 | 0.0151 | 12 | 20.8794 | 0.082054 | 81 | 9 | 14 | 33 | 13 | 12 | 115000 | 0.999095 | 115000 | 0.999729 | 115000 | 0.999428 | 115000 | 0.999706 | 115000 | 0.99911 | 1 | 1 |
107773339922175058 | 333.99225189 | -0.1878471 | 0.00356 | 0.02173 | 60 | 17.8118 | 0.005868 | 12 | 17.0528 | 0.002585 | 12 | 16.7543 | 0.0022 | 26 | 16.6207 | 0.00568 | 12 | 16.5089 | 0.009786 | 12 | 17.1191 | 0.003335 | 87 | 14 | 14 | 31 | 14 | 14 | 115000 | 0.999704 | 115000 | 0.999442 | 115000 | 0.999577 | 115000 | 0.999238 | 115000 | 0.999307 | 1 | 1 |
107773340107508029 | 334.01078438 | -0.18536236 | 0.0057 | 0.0057 | 60 | 17.1406 | 0.001898 | 12 | 16.5837 | 0.002945 | 13 | 16.3375 | 0.001891 | 22 | 16.2293 | 0.002224 | 13 | 16.146 | 0.008295 | 9 | 16.6436 | 0.001166 | 87 | 16 | 15 | 30 | 14 | 12 | 115000 | 0.999684 | 115000 | 0.999464 | 115000 | 0.999912 | 115000 | 0.999435 | 115000 | 0.999022 | 1 | 1 |
Galaxy Candidates for K2 SN Search
Goal/Description
The Kepler Extra-Galactic Survey (KEGS) is a program using the Kepler telescope to search for supernovae, active galactic nuclei, and other transients in galaxies. We have to identify galaxies in a suitable redshift range (z<=0.12) a priori, which will be monitored by K2. Here is an example to get galaxies for Campaign 14. We only select objects with r<=19.5, and we make a cut on (rmeanpsfmag - rmeankronmag)>=0.05 in order to remove stars (More info about Star-Galaxy Separation is here). We only want to use objects for which the majority of pixels were not masked, thus the cut on QFperfect>=0.95. We also obtain the petrosian radii in order to be able to select galaxies by size.
Query
Results
First 10 out of 161,920 Rows of MyDB Table C14
125391633203089697 | 163.32030341 | 14.49934933 | 163.32028882 | 14.49933092 | 10 | 21.0093 | 0.036089 | 20.6731 | 0.074827 | 14 | 19.7703 | 0.026601 | 19.2563 | 0.01528 | 10 | 19.2681 | 0.011538 | 18.6397 | 0.021455 | 14 | 18.9957 | 0.016901 | 18.3729 | 0.01564 | 13 | 18.6968 | 0.030642 | 18.1266 | 0.037591 | 0.999566 | 0.999635 | 0.999213 | 0.999209 | 0.999349 | 61 | 512024576 | 8.6166 | 2.71981 | 2.66062 | 2.67084 | 2.77483 | 1.25887 | 1.19192 | 1.08737 | 1.0683 | 1.02985 | 1 | 1 |
125391634958624964 | 163.49586429 | 14.49541362 | 163.49583602 | 14.4954125 | 10 | 20.3336 | 0.030038 | 19.5583 | 0.020455 | 14 | 19.7966 | 0.03558 | 18.9214 | 0.022374 | 15 | 19.5316 | 0.025872 | 18.6278 | 0.009325 | 13 | 19.367 | 0.033795 | 18.5621 | 0.032986 | 14 | 19.1271 | 0.038272 | 18.3829 | 0.051101 | 0.999619 | 0.999457 | 0.998965 | 0.999023 | 0.999377 | 53 | 444915712 | 5.27407 | 5.04787 | 4.27913 | 4.71588 | 5.21124 | 2.08763 | 1.80538 | 1.5933 | 1.46589 | 3.27605 | 1 | 1 |
125391635282559255 | 163.52826527 | 14.49899141 | 163.52823941 | 14.49899527 | 8 | 20.9598 | 0.062091 | 20.1741 | 0.026735 | 14 | 20.3923 | 0.062902 | 19.417 | 0.029026 | 15 | 20.0727 | 0.036366 | 19.0168 | 0.024443 | 11 | 19.8652 | 0.025211 | 18.8208 | 0.031221 | 8 | 19.2406 | 0.092635 | 18.7778 | 0.141102 | 0.999726 | 0.999435 | 0.9992 | 0.999113 | 0.999185 | 53 | 444915712 | 4.60435 | 5.28031 | 4.94089 | 5.31433 | 4.2082 | 2.20738 | 2.36534 | 2.07909 | 2.09779 | 1.98962 | 1 | 1 |
125391636122615271 | 163.61224801 | 14.49564107 | 163.61222312 | 14.4956375 | 10 | 21.0158 | 0.045075 | 20.3179 | 0.073374 | 16 | 20.0838 | 0.039024 | 19.361 | 0.032028 | 23 | 19.6738 | 0.024572 | 18.9632 | 0.014486 | 13 | 19.4487 | 0.020207 | 18.7097 | 0.024255 | 12 | 19.2102 | 0.063186 | 18.5949 | 0.073146 | 0.999603 | 0.999763 | 0.999656 | 0.998814 | 0.999592 | 53 | 444915712 | 3.83093 | 3.52666 | 3.35348 | 4.64719 | 3.17508 | 1.43311 | 1.45691 | 1.24687 | 1.44055 | 1.13158 | 1 | 1 |
118791643648704345 | 164.36486427 | 8.99489954 | 164.36488729 | 8.99490711 | 12 | 19.1429 | 0.052652 | 18.2254 | 0.01775 | 10 | 18.1585 | 0.047254 | 17.1922 | 0.010684 | 24 | 17.8359 | 0.014582 | 16.7399 | 0.006493 | 15 | 17.529 | 0.034207 | 16.475 | 0.016307 | 12 | 17.3821 | 0.032685 | 16.5217 | 0.016764 | 0.999406 | 0.999925 | 0.999627 | 0.999177 | 0.998446 | 61 | 512024576 | 9.41188 | 7.51037 | 8.15557 | 6.79108 | 6.69249 | 3.239 | 2.89972 | 2.98712 | 2.58567 | 2.53303 | 1 | 1 |
118791644119204724 | 164.41206831 | 8.9951804 | 164.41207311 | 8.99516407 | 11 | 20.4482 | 0.049955 | 19.9932 | 0.031226 | 10 | 19.4595 | 0.055058 | 19.0636 | 0.034954 | 21 | 19.1387 | 0.009942 | 18.6994 | 0.012918 | 18 | 18.9002 | 0.028131 | 18.4224 | 0.017008 | 16 | 18.7551 | 0.03906 | 18.3453 | 0.048406 | 0.999824 | 0.999525 | 0.999536 | 0.999698 | 0.999067 | 53 | 444915712 | 3.239 | 3.36407 | 3.61128 | 2.58715 | 5.26874 | 1.32149 | 1.37188 | 1.33232 | 1.067 | 1.54819 | 1 | 1 |
118791644639089117 | 164.4639088 | 8.99886558 | 164.4638893 | 8.99882395 | 12 | 20.5845 | 0.013954 | 20.5222 | 0.025129 | 9 | 19.5392 | 0.014182 | 19.4673 | 0.028032 | 25 | 19.2291 | 0.009582 | 19.0912 | 0.010408 | 8 | 18.9844 | 0.019372 | 18.8641 | 0.012195 | 10 | 18.8694 | 0.03332 | 18.7261 | 0.050969 | 0.999824 | 0.999727 | 0.999752 | 0.998658 | 0.99909 | 53 | 444915712 | 1.71052 | 2.17727 | 1.84635 | 1.71799 | 1.60121 | 0.810568 | 0.902419 | 0.786221 | 0.69683 | 0.685771 | 1 | 1 |
112311673903612557 | 167.39036582 | 3.59342292 | 167.39034643 | 3.59342679 | 10 | 20.6191 | 0.028819 | 20.0852 | 0.034735 | 13 | 19.2242 | 0.015424 | 18.6072 | 0.019927 | 30 | 18.6517 | 0.029103 | 18.0381 | 0.010267 | 15 | 18.6967 | 0.024408 | 17.833 | 0.016486 | 15 | 18.2745 | 0.050807 | 17.5922 | 0.029465 | 0.999542 | 0.999752 | 0.999918 | 0.999668 | 0.999759 | 61 | 512024576 | 4.49931 | 5.2592 | 5.923 | 6.45203 | 9.71826 | 1.7136 | 1.89471 | 2.12116 | 2.27382 | 2.50151 | 1 | 1 |
112311673903612557 | 167.39036582 | 3.59342292 | 167.39034643 | 3.59342679 | 10 | 20.6191 | 0.028819 | 20.0852 | 0.034735 | 13 | 19.2242 | 0.015424 | 18.6072 | 0.019927 | 30 | 18.6517 | 0.029103 | 18.0381 | 0.010267 | 15 | 18.6967 | 0.024408 | 17.833 | 0.016486 | 15 | 18.2745 | 0.050807 | 17.5922 | 0.029465 | 0.999542 | 0.999752 | 0.999918 | 0.999668 | 0.999759 | 61 | 512024576 | 5.75997 | 6.37828 | 5.77622 | 5.6901 | 6.93946 | 1.83295 | 2.14678 | 1.96195 | 1.98665 | 1.96887 | 1 | 1 |
112311673927395135 | 167.3927613 | 3.59560997 | 167.39274475 | 3.59561368 | 8 | 21.2923 | 0.075464 | 20.5347 | 0.03857 | 12 | 19.8838 | 0.034 | 19.2746 | 0.020544 | 37 | 19.3558 | 0.023752 | 18.7983 | 0.013654 | 14 | 19.3137 | 0.033713 | 18.5508 | 0.025501 | 12 | 18.9165 | 0.035194 | 18.1912 | 0.03329 | 0.999655 | 0.999603 | 0.99976 | 0.999207 | 0.999066 | 53 | 444915712 | 2.69325 | 3.55384 | 2.87281 | 3.02684 | 139.143 | 0.821187 | 1.09999 | 1.06384 | 1.13938 | -999 | 1 | 1 |
Obtain lightcurves for a given set of objects
Goal/Description
The goal is to obtain light curves for a list of objects. The list of objects with their RA/Dec position is uploaded into Mydb, the PS1 objects are identified, and then the light curves are obtained. Here we upload a list of 13 RR Lyrae stars from the Catalina sky survey into mydb.[RRLcatalina]
Query #1: Match Catalina RR Lyrae stars to PS1 objects
We search for objects in the PS1 DB that are within 3 arcsec of the Catalina positions. Most of the parameters (mean mags, # of detections, etc) we get from the MeanObjectView table. We also join the StackObjectAttributes table in order to get primaryDetection and bestDetection (BestDetection is corrupted in DR2, but will be fixed in DR2.1, see the description of StackObjectThin table for a more detailed description). These RR Lyrae stars are bright, thus we can expect many detections, and we therefore require o.nDetections>5. We only want to use objects for which the majority of pixels were not masked, thus the cut on QFperfect>=0.95. In order to select only stars (and exclude galaxies), we require (o.rmeanpsfmag - o.rmeankronmag)< 0.05, as described here.
Results (25 minutes)
There are 12 out of 13 matches, and below are the first 10 entries
CSS_J220309.8+051633 | 330.79097 | 5.27593 | 16.68 | 0.638698 | 0.38 | 294 | 15.62 | 0.057 | 1104118064018 | 114333307910211643 | 330.7910125 | 5.2759626 | 0.00217 | 0.00427 | 60 | 17.0665 | 0.003394 | 5 | 16.6873 | 0.002055 | 3 | 16.5998 | 0.01256 | 17 | 16.4921 | 0.018882 | 8 | 16.5424 | 0.012265 | 12 | 16.7216 | 0.007911 | 75 | 12 | 7 | 28 | 11 | 17 | 115000 | 0.999497 | 115000 | 0.999265 | 115000 | 0.999639 | 115000 | 0.999697 | 115000 | 0.998978 | 1 | 1 |
CSS_J221949.2-024020 | 334.95521 | -2.67224 | 16.51 | 0.709491 | 0.37 | 249 | 14.12 | 0.085 | 1001120004060 | 104793349551433447 | 334.95514654 | -2.6725015 | 0.03063 | 0.02043 | 60 | 16.7444 | 0.006159 | 5 | 16.4611 | 0.006758 | 6 | 16.4771 | 0.004479 | 13 | 16.3752 | 0.005638 | 7 | 16.3594 | 0.018196 | 7 | 16.5058 | 0.003776 | 63 | 8 | 11 | 23 | 10 | 11 | 115000 | 0.999646 | 115000 | 0.999825 | 115000 | 0.999672 | 115000 | 0.998727 | 115000 | 0.999331 | 1 | 1 |
CSS_J220559.8-023949 | 331.49951 | -2.66365 | 18.11 | 0.53717 | 0.89 | 234 | 27.82 | 0.152 | 1001118004001 | 104803314996713860 | 331.49966923 | -2.66380567 | 0.00559 | 0.00857 | 52 | 18.6598 | 0.034348 | 7 | 18.4456 | 0.032674 | 8 | 18.0895 | 0.030017 | 19 | 17.9296 | 0.046795 | 10 | 17.9923 | 0.00375 | 9 | 18.4806 | 0.024847 | 67 | 12 | 12 | 21 | 12 | 10 | 115000 | 0.999129 | 115000 | 0.99931 | 115000 | 0.999638 | 115000 | 0.999217 | 115000 | 0.998798 | 1 | 1 |
CSS_J220457.2-051411 | 331.23867 | -5.23656 | 15.64 | 0.53643 | 0.75 | 173 | 9.67 | 0.06 | 1004118010930 | 101713312388786386 | 331.23888082 | -5.23675594 | 0.00469 | 0.00529 | 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 |
CSS_J215602.1-052021 | 329.00905 | -5.33921 | 16.51 | 0.757558 | 0.47 | 218 | 14.77 | 0.036 | 1004117008292 | 101593290092623326 | 329.00923968 | -5.33928719 | 0.0167 | 0.01841 | 60 | 16.8494 | 0.0078 | 6 | 16.4217 | 0.022047 | 15 | 16.3759 | 0.008041 | 15 | 16.3468 | 0.003574 | 8 | 16.3721 | 0.018063 | 11 | 16.4827 | 0.023415 | 72 | 10 | 16 | 22 | 12 | 12 | 115000 | 0.999921 | 115000 | 0.999677 | 115000 | 0.999406 | 115000 | 0.999167 | 115000 | 0.999435 | 1 | 1 |
CSS_J220820.9-020222 | 332.08714 | -2.0397 | 17.01 | 0.561687 | 0.95 | 263 | 17.61 | 0.092 | 1001119018133 | 105553320871392714 | 332.08715134 | -2.03979472 | 0.0027 | 0.0102 | 60 | 17.7555 | 0.003879 | 8 | 17.382 | 0.008932 | 13 | 17.1634 | 0.03364 | 23 | 17.1783 | 0.007448 | 4 | 16.9441 | 0.013463 | 4 | 17.3846 | 0.009404 | 80 | 14 | 21 | 29 | 8 | 8 | 115000 | 0.999685 | 115000 | 0.999274 | 115000 | 0.999878 | 115000 | 0.998871 | 115000 | 0.999672 | 1 | 1 |
CSS_J222707.9+051259 | 336.78311 | 5.21646 | 16.19 | 0.552557 | 0.73 | 275 | 11.29 | 0.173 | 1104120055941 | 114263367831840264 | 336.78319546 | 5.21647999 | 0.00177 | 0.00188 | 60 | 16.3358 | 0.006233 | 6 | 16.2293 | 0.117566 | 7 | 16.2794 | 0.016904 | 25 | 16.1658 | 0.024596 | 9 | 16.084 | 0.028519 | 9 | 16.2807 | 0.134897 | 87 | 13 | 15 | 36 | 12 | 11 | 115000 | 0.999558 | 115000 | 0.99899 | 115000 | 0.999677 | 115000 | 0.999277 | 115000 | 0.998572 | 1 | 1 |
CSS_J215435.8-005450 | 328.64951 | -0.91416 | 17.75 | 0.575212 | 0.9 | 257 | 24.14 | 0.126 | 1001117050169 | 106903286496013281 | 328.64959053 | -0.91431682 | 0.00219 | 0.00138 | 52 | 18.1409 | 0.074842 | 7 | 17.8706 | 0.057256 | 10 | 17.6159 | 0.042086 | 17 | 17.7657 | 0.024178 | 9 | 17.669 | 0.011157 | 10 | 17.9065 | 0.062371 | 75 | 12 | 12 | 26 | 13 | 12 | 115000 | 0.999682 | 115000 | 0.999313 | 115000 | 0.999291 | 115000 | 0.999697 | 115000 | 0.999024 | 1 | 1 |
CSS_J222942.0-040519 | 337.42517 | -4.08876 | 18.08 | 0.475699 | 1.19 | 230 | 29.63 | 0.067 | 1004120034845 | 103093374253263940 | 337.42533413 | -4.08873128 | 0.00245 | 0.00194 | 52 | 18.838 | 0.022485 | 9 | 18.552 | 0.01008 | 8 | 18.5071 | 0.013825 | 14 | 18.2355 | 0.118849 | 8 | 18.3454 | 0.019402 | 10 | 18.6314 | 0.011776 | 82 | 14 | 16 | 26 | 12 | 14 | 115000 | 0.999522 | 115000 | 0.999581 | 115000 | 0.999479 | 115000 | 0.999669 | 115000 | 0.99935 | 1 | 1 |
CSS_J223105.2+000538 | 337.77177 | 0.09404 | 16.97 | 0.670228 | 0.4 | 278 | 17.7 | 0.071 | 1101121002733 | 108113377718393164 | 337.77185997 | 0.09391985 | 0.01024 | 0.01061 | 60 | 17.1952 | 0.013075 | 7 | 16.9806 | 0.006582 | 14 | 16.8766 | 0.012872 | 30 | 16.8465 | 0.015577 | 8 | 16.7479 | 0.011255 | 9 | 17.0236 | 0.005972 | 94 | 14 | 22 | 35 | 10 | 13 | 115000 | 0.999502 | 115000 | 0.999683 | 115000 | 0.999733 | 115000 | 0.999191 | 115000 | 0.999694 | 1 | 1 |
Query #2: Get the detections
Now we get all detections associated with these objIDs
Results (30 seconds)
There are 946 detection entries for the 12 objects, and below are the first 10 entries
101713312388786386 | 331.23888082 | -5.23675594 | 331.23887966 | -5.23673709 | 0.0142129 | 0.0204369 | 281041231200000230 | 56911.4125766 | 45 | 1.13479 | 0.00236808 | 3.23403E-05 | 0.0749382 | 0.0282996 | 0.001481 | 1.22177 | 3.17838 | 24.5609 | 0.000101192 | 1.15941E-06 | 79216420 | 3 | 7.38736E-05 | 3.65002E-06 | 102760453 | 128 | 32768 | 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 | 331.2388835 | -5.2367367 | 0.00872209 | 0.0136836 | 281040069200000148 | 56911.4009661 | 45 | 1.12094 | 0.00235791 | 2.46269E-05 | 0.115458 | 0.115458 | -0.683352 | 1.38811 | -0.407894 | 24.5606 | 0.000115057 | 1.24099E-06 | 79214720 | 3 | 6.59469E-05 | 3.4392E-06 | 102760453 | 128 | 32768 | 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 | 331.23887945 | -5.23675267 | 0.00255273 | 0.00272007 | 272155268140000054 | 56822.5529494 | 45 | 1.23978 | 0.00160025 | 5.42303E-06 | 0.998273 | 0.998273 | 0.718458 | 1.85151 | 0.36052 | 24.6031 | 0.00163074 | 4.55078E-06 | 75434414 | 3 | 9.63136E-05 | 4.39628E-06 | 102760453 | 128 | 7374912 | 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 | 331.23887517 | -5.23675357 | 0.00255573 | 0.00279838 | 272154101140000055 | 56822.5412889 | 45 | 1.29101 | 0.00163992 | 5.55706E-06 | 0.999095 | 0.999095 | 0.577144 | 1.65577 | 0.557561 | 24.6016 | 0.00165362 | 4.55156E-06 | 75432714 | 3 | 0.000102506 | 4.54961E-06 | 102760517 | 128 | 7374912 | 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 | 331.23888039 | -5.23675471 | 0.00251159 | 0.00252325 | 272156434140000061 | 56822.5646058 | 45 | 1.19898 | 0.001599 | 5.33245E-06 | 0.999192 | 0.999192 | 0.162726 | 1.95035 | 1.39596 | 24.6048 | 0.00165668 | 4.56818E-06 | 75436114 | 3 | 9.17713E-05 | 4.18141E-06 | 102760453 | 128 | 7374912 | 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 | 331.23888187 | -5.23675805 | 0.00228002 | 0.00229566 | 272157596140000058 | 56822.576232 | 45 | 1.16719 | 0.00160726 | 5.26372E-06 | 0.999501 | 0.999501 | 0.222933 | 1.89115 | 1.21877 | 24.6047 | 0.00165819 | 4.55018E-06 | 75437814 | 3 | 8.90853E-05 | 4.19146E-06 | 102760517 | 128 | 7374912 | 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 | 331.23887668 | -5.23673914 | 0.0022578 | 0.0019803 | 273861056470000149 | 56839.6107502 | 30 | 1.13731 | 0.00197136 | 8.18044E-06 | 0.885171 | 0 | -0.226784 | 1.2275 | -1.20868 | 24.2217 | 0.00172437 | 6.86483E-06 | 76384947 | 4 | 5.24721E-05 | 5.20364E-06 | 102760453 | 160 | 34880 | 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 | 331.23888109 | -5.23674994 | 0.00334748 | 0.00308122 | 274160857470000086 | 56842.6087543 | 30 | 1.148 | 0.00144126 | 7.36061E-06 | 0.934025 | 0 | -0.358647 | 1.03449 | -0.917947 | 24.2402 | 0.00138292 | 6.01342E-06 | 76561547 | 4 | 6.60553E-05 | 5.55748E-06 | 102760517 | 160 | 34880 | 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 | 331.23887875 | -5.23674419 | 0.00621135 | 0.00628081 | 284035135370000088 | 56941.351618 | 45 | 1.17746 | 0.00125442 | 5.51837E-06 | 0.999367 | 0.999367 | 0.0518508 | 1.20217 | 1.94437 | 24.5348 | 0.00127698 | 4.00209E-06 | 80756237 | 3 | 5.62479E-05 | 3.33006E-06 | 102760453 | 128 | 7342144 | 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 | 331.23887939 | -5.2367617 | 0.00649579 | 0.00662178 | 284036359370000086 | 56941.3638651 | 45 | 1.21437 | 0.00125844 | 5.59236E-06 | 0.99913 | 0.99913 | 0.0215391 | 2.1285 | 2.2984 | 24.5234 | 0.00114858 | 3.81474E-06 | 80758037 | 3 | 5.97269E-05 | 3.37162E-06 | 102760453 | 128 | 7374912 | 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 |
Query #3: Get the forced detections
Now we get the forced photometry
Results (3:45 minutes)
There are 824 forced detection entries for the 12 objects, and below are the first 10 entries
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 light-curves, 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(46.341468915923, 1.54199810825252, 1.0/60.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) |
Results
ID_GAIA | GAIARA | GAIADEC | G | period | 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 | primaryDetection | bestDetection |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.5554679 | 109850463414820867 | 46.34146986 | 1.54199906 | 0.00303 | 0.00392 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
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 |
Results
ID_GAIA | GAIARA | GAIADEC | G | period | objID | raMean | decMean | ra | dec | raErr | decErr | detectID | obstime | exptime | airmass | psfflux | psffluxErr | psfQf | psfQfPerfect | psfLikelihood | psfChiSq | extNSigma | zp | apFlux | apFluxErr | imageID | filterID | sky | skyerr | infoflag | infoflag2 | infoflag3 | 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 | primaryDetection | bestDetection |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34146583 | 1.54199913 | 0.00930373 | 0.00968925 | 205661127730000150 | 56157.6114477 | 30 | 1.09654 | 0.000312418 | 4.3854E-06 | 0.998354 | 0.998354 | -0.996145 | 0.872386 | -0.00483113 | 24.2666 | 0.000312875 | 2.82293E-06 | 51263373 | 4 | 5.31738E-05 | 4.963E-06 | 102760517 | 128 | 74483776 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147101 | 1.54199584 | 0.00886464 | 0.00930058 | 205661834730000139 | 56157.6185191 | 30 | 1.08464 | 0.000308798 | 4.30705E-06 | 0.997886 | 0.997886 | -0.75122 | 0.885472 | -0.317032 | 24.2646 | 0.000307007 | 2.80718E-06 | 51264773 | 4 | 5.40842E-05 | 4.96676E-06 | 102760517 | 128 | 74483776 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147032 | 1.54199486 | 0.0164824 | 0.0181091 | 205463519730000149 | 56155.6353733 | 30 | 1.07035 | 0.000426476 | 1.07013E-05 | 0.997507 | 0.997507 | -0.401959 | 0.956975 | -0.838127 | 23.2819 | 0.000432489 | 5.24768E-06 | 51173573 | 5 | 0.000280673 | 1.65041E-05 | 102760517 | 128 | 24152128 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147529 | 1.54200729 | 0.0182097 | 0.0185216 | 205463914730000143 | 56155.6393177 | 30 | 1.06675 | 0.000479478 | 1.25106E-05 | 0.997027 | 0.997027 | -0.114679 | 1.03244 | -1.57751 | 23.2795 | 0.000439649 | 5.31304E-06 | 51174373 | 5 | 0.000393003 | 1.91349E-05 | 102760453 | 128 | 91260992 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34148671 | 1.5420009 | 0.0101945 | 0.00999848 | 211347106730000086 | 56214.471324 | 43 | 1.07359 | 0.000336865 | 3.14514E-06 | 0.998881 | 0.970811 | 0.973133 | 0.571017 | 0.0336786 | 24.473 | 0.000340318 | 2.19969E-06 | 53141773 | 1 | 7.04272E-06 | 1.81309E-06 | 102760517 | 128 | 7374912 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147048 | 1.5420066 | 0.0093339 | 0.0087079 | 211348410730000082 | 56214.4843629 | 43 | 1.06252 | 0.000319473 | 2.96694E-06 | 0.999379 | 0.988253 | 0.108993 | 0.560401 | 1.60274 | 24.4774 | 0.000329763 | 2.17398E-06 | 53143773 | 1 | 7.0158E-06 | 1.76822E-06 | 102760517 | 128 | 7374912 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.3414713 | 1.54199819 | 0.00333002 | 0.00338827 | 210557093660000079 | 56206.5712068 | 45 | 1.11613 | 0.000518794 | 2.92105E-06 | 0.998327 | 0.998327 | 0.673599 | 1.16014 | 0.421213 | 24.5794 | 0.000522514 | 2.58357E-06 | 52699966 | 3 | 3.55551E-05 | 2.70531E-06 | 102760517 | 128 | 124815424 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34146626 | 1.54200241 | 0.00347142 | 0.00354816 | 210558442660000091 | 56206.5846906 | 45 | 1.15273 | 0.000516125 | 2.92271E-06 | 0.997907 | 0.766916 | -0.288893 | 1.1114 | -1.06055 | 24.5781 | 0.000511877 | 2.5592E-06 | 52701966 | 3 | 3.64152E-05 | 2.64891E-06 | 102760517 | 128 | 34880 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147538 | 1.54199994 | 0.0039944 | 0.00451317 | 210551778750000080 | 56206.5180227 | 40 | 1.05874 | 0.000475616 | 2.96145E-06 | 0.999002 | 0.999002 | 0.909937 | 1.04836 | 0.113118 | 24.6802 | 0.000480397 | 2.4879E-06 | 52694175 | 2 | 2.8626E-05 | 2.47058E-06 | 102760517 | 128 | 7374912 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 46.34147262 | 1.5419939 | 0.00364916 | 0.00408964 | 210553046750000073 | 56206.530699 | 40 | 1.06117 | 0.000530636 | 3.04363E-06 | 0.999244 | 0.999244 | -0.548617 | 1.09795 | -0.599834 | 24.6789 | 0.000528337 | 2.6191E-06 | 52696175 | 2 | 2.90354E-05 | 2.5104E-06 | 102760517 | 128 | 7374912 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
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 |
Results
ID_GAIA | GAIARA | GAIADEC | Gmag | period | objID | raMean | decMean | detectID | obstime | exptime | airmass | Fpsfflux | FpsffluxErr | FpsfQf | FpsfQfPerfect | FpsfChiSq | zp | FapFlux | FapFluxErr | forcedWarpID | filterID | Fsky | Fskyerr | Finfoflag | Finfoflag2 | Finfoflag3 | 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 | primaryDetection | bestDetection |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119315535889690 | 55507.3712258 | 43 | 1.14572 | 0.000350219 | 2.6488E-06 | 0.998145 | 0.998145 | 0.765097 | 24.4564 | 0.000359496 | 2.33503E-06 | 42521653 | 1 | 6.85638E-08 | 1.5692E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119333789500698 | 55507.3823453 | 43 | 1.11626 | 0.000339841 | 2.61849E-06 | 0.998072 | 0.998072 | 0.749982 | 24.4641 | 0.000348416 | 2.29292E-06 | 42521654 | 1 | 5.37593E-08 | 1.50972E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119407877686554 | 55871.5445119 | 43 | 1.35337 | 0.000254604 | 3.88525E-06 | 0.999324 | 0.999324 | 1.10263 | 24.097 | 0.000262875 | 2.28175E-06 | 42521657 | 1 | 1.09933E-07 | 3.17848E-06 | 169869889 | 0 | 108004352 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119517399352602 | 55871.5567211 | 43 | 1.44557 | 0.000370892 | 3.16762E-06 | 0.998958 | 0.998958 | 1.09638 | 24.3685 | 0.000371724 | 2.40599E-06 | 42521658 | 1 | 8.86901E-08 | 1.97909E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119506930369818 | 56214.471324 | 43 | 1.07359 | 0.00032403 | 3.07634E-06 | 0.999711 | 0.973116 | 0.630758 | 24.4609 | 0.000337913 | 2.19088E-06 | 42521659 | 1 | 3.48615E-09 | 1.49863E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119488676758810 | 56214.4843629 | 43 | 1.06252 | 0.000300591 | 2.80449E-06 | 0.999801 | 0.989282 | 0.589187 | 24.4557 | 0.000332295 | 2.18906E-06 | 42521660 | 1 | -1.36515E-08 | 1.61688E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119737516426522 | 56620.367559 | 43 | 1.0663 | 0.000523414 | 3.368E-06 | 0.999118 | 0.999118 | 0.876506 | 24.4758 | 0.00052687 | 2.74996E-06 | 42521661 | 1 | 5.30874E-08 | 1.7956E-06 | 169869889 | 0 | 124781568 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119783687324954 | 56630.3025631 | 43 | 1.12948 | 0.00026972 | 2.32236E-06 | 0.999089 | 0.999089 | 1.24161 | 24.4652 | 0.000284441 | 2.0379E-06 | 42521662 | 1 | -8.71303E-12 | 1.50396E-06 | 169869889 | 0 | 124781568 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476119928105600282 | 56630.3156559 | 43 | 1.09965 | 0.000349844 | 2.72148E-06 | 0.998917 | 0.998741 | 1.31018 | 24.4706 | 0.000353883 | 2.25995E-06 | 42521663 | 1 | 1.14166E-08 | 1.47287E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
584630948352256 | 46.341468915923 | 1.54199810825252 | 17.4408 | 0.55547 | 109850463414820867 | 46.34146986 | 1.54199906 | 2476125473445250330 | 55859.5429067 | 43 | 1.17982 | 0.000305323 | 2.53239E-06 | 0.9997 | 0.9997 | 1.77898 | 24.4184 | 0.000315776 | 2.18451E-06 | 42521664 | 1 | 2.13619E-08 | 1.48642E-06 | 169869889 | 0 | 7341056 | 60 | 17.6399 | 0.029892 | 12 | 17.1962 | 0.044886 | 13 | 17.4812 | 0.049341 | 23 | 17.5072 | 0.057957 | 10 | 17.5268 | 0.021819 | 10 | 17.2178 | 0.04143 | 92 | 14 | 18 | 30 | 17 | 13 | 115000 | 0.999504 | 115000 | 0.99972 | 115000 | 0.999533 | 115000 | 0.998973 | 115000 | 0.999407 | 1 | 1 |
The following figures show the PS1 i-band light curve for the RR Lyrae based on the detection and force detection aperture and PSF photometry:
FIG. 1: PS1 i-band light curve for the RR Lyrae from aperture photometry (left panel) and PSF photometry (right) from the Detection table.
FIG. 2: PS1 i-band light curve for the same star from aperture photometry (left panel) and PSF photometry (right) from the force detection table.
As a comparison, the Catalina Sky Survey V-band light curve: