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 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(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
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
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 |