Page History
Tip | ||||||
---|---|---|---|---|---|---|
| ||||||
|
...
Get high-fidelity stars in given area
Goal/Description
We want to get all objects within 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.
Query
Code Block | ||
---|---|---|
| ||
SELECT o.ObjID,x.ra,x.dec, o.gMeanPSFMag, o.gMeanPSFMagErr, o.rMeanPSFMag, o.rMeanPSFMagErr, o.iMeanPSFMag, o.iMeanPSFMagErr, o.zMeanPSFMag, o.zMeanPSFMagErr, o.gMeanPSFmagNpt,o.rMeanPSFmagNpt,o.iMeanPSFmagNpt,o.zMeanPSFmagNpt, o.gFlags, o.gQfPerfect, o.rFlags, o.rQfPerfect, o.iFlags, o.iQfPerfect, o.zFlags, o.zQfPerfect FROM dbo.fGetNearbyObjEq(334, 0.0, 0.2) as x JOIN MeanObject o on o.ObjID=x.ObjId where o.gMeanPSFmagNpt>=1 and o.rMeanPSFmagNpt>=1 and o.iMeanPSFmagNpt>=1 and o.zMeanPSFmagNpt>=1 and o.gQfPerfect>=0.85 and o.rQfPerfect>=0.85 and o.iQfPerfect>=0.85 and o.zQfPerfect>=0.85 |
Results
1218 objects, here are the first 10:
[ObjID]:Int64 | [ra]:Double | [dec]:Double | [gMeanPSFMag]:Single | [gMeanPSFMagErr]:Single | [rMeanPSFMag]:Single | [rMeanPSFMagErr]:Single | [iMeanPSFMag]:Single | [iMeanPSFMagErr]:Single | [zMeanPSFMag]:Single | [zMeanPSFMagErr]:Single | [gMeanPSFmagNpt]:Int16 | [rMeanPSFmagNpt]:Int16 | [iMeanPSFmagNpt]:Int16 | [zMeanPSFmagNpt]:Int16 | [gFlags]:Int32 | [gQfPerfect]:Single | [rFlags]:Int32 | [rQfPerfect]:Single | [iFlags]:Int32 | [iQfPerfect]:Single | [zFlags]:Int32 | [zQfPerfect]:Single |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107763339788289399 | 333.97880748 | -0.19253748 | 21.9438 | 0.11106 | 20.2034 | 0.027063 | 19.5014 | 0.017971 | 19.0134 | 0.029953 | 8 | 14 | 13 | 8 | 24888 | 0.998615 | 24888 | 0.999312 | 24888 | 0.999381 | 24888 | 0.999301 |
107763340006649595 | 334.00065785 | -0.19236407 | 19.5995 | 0.017734 | 18.3372 | 0.007714 | 17.2107 | 0.004049 | 16.692 | 0.005484 | 12 | 12 | 12 | 10 | 16696 | 0.999146 | 16696 | 0.999319 | 312 | 0.998627 | 312 | 0.999408 |
107763340150042386 | 334.01499455 | -0.19836754 | 22.0476 | 0.160347 | 20.8012 | 0.045506 | 19.6133 | 0.008253 | 19.0216 | 0.030203 | 10 | 10 | 9 | 8 | 16696 | 0.99887 | 16696 | 0.999343 | 16688 | 0.999042 | 16696 | 0.999635 |
107763340365706349 | 334.03655623 | -0.19508464 | 21.9288 | 0.109147 | 21.5784 | 0.086763 | 21.0964 | 0.066446 | 20.3965 | 0.118844 | 12 | 10 | 13 | 13 | 16696 | 0.999101 | 16696 | 0.998961 | 24888 | 0.999252 | 16696 | 0.999638 |
107763340427936906 | 334.04279614 | -0.1945979 | 21.7427 | 0.092382 | 21.6415 | 0.091627 | 20.9072 | 0.058188 | 21.2196 | 0.173467 | 12 | 10 | 13 | 1 | 16696 | 0.998822 | 24888 | 0.999251 | 24888 | 0.999312 | 16688 | 0.996947 |
107773339339728631 | 333.93396938 | -0.1848365 | 20.9823 | 0.048723 | 19.8663 | 0.02085 | 18.5813 | 0.003806 | 17.9914 | 0.01321 | 12 | 14 | 12 | 12 | 16696 | 0.999034 | 16696 | 0.998801 | 16688 | 0.999195 | 16696 | 0.999352 |
107773339418267057 | 333.94184362 | -0.18615982 | 21.9966 | 0.070236 | 20.9456 | 0.026134 | 20.5547 | 0.019016 | 20.2507 | 0.090782 | 4 | 6 | 8 | 6 | 16696 | 0.998274 | 16696 | 0.99932 | 16688 | 0.999224 | 16696 | 0.99931 |
107773339602449349 | 333.96024341 | -0.18424616 | 20.9886 | 0.025514 | 19.7236 | 0.010273 | 18.4433 | 0.008773 | 17.8297 | 0.004637 | 6 | 6 | 10 | 10 | 16688 | 0.998774 | 16688 | 0.998944 | 16696 | 0.999612 | 16688 | 0.999226 |
107773339666322634 | 333.96662932 | -0.18984629 | 18.294 | 0.00797 | 17.7351 | 0.005475 | 17.5201 | 0.004917 | 17.3994 | 0.005004 | 8 | 10 | 10 | 6 | 16696 | 0.998668 | 16696 | 0.998606 | 16696 | 0.999246 | 16688 | 0.998957 |
107773339901141449 | 333.99012708 | -0.19081259 | 22.0177 | 0.116995 | 20.7935 | 0.043956 | 19.3285 | 0.015997 | 18.5802 | 0.021108 | 12 | 13 | 13 | 8 | 16696 | 0.999287 | 16696 | 0.999454 | 16696 | 0.998564 | 16696 | 0.999272 |
Galaxy Candidates for K2 C14 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.5 in order to remove stars. 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. This query gives us an initial list of galaxies which then gets vetted more, e.g. with cuts on qualityFlag and objInfoFlag and information from external catalogs.
Query
Code Block | ||
---|---|---|
| ||
SELECT o.objID, ot.raStack, ot.decStack, ot.raMean, ot.decMean, ot.ng, o.gMeanPSFMag,o.gMeanPSFMagErr,o.gMeanKronMag,o.gMeanKronMagErr, ot.nr, o.rMeanPSFMag,o.rMeanPSFMagErr,o.rMeanKronMag,o.rMeanKronMagErr, ot.ni, o.iMeanPSFMag,o.iMeanPSFMagErr,o.iMeanKronMag,o.iMeanKronMagErr, ot.nz, o.zMeanPSFMag,o.zMeanPSFMagErr,o.zMeanKronMag,o.zMeanKronMagErr, ot.ny, o.yMeanPSFMag,o.yMeanPSFMagErr,o.yMeanKronMag,o.yMeanKronMagErr, o.gQfPerfect,o.rQfPerfect,o.iQfPerfect,o.zQfPerfect,o.yQfPerfect, ot.qualityFlag,ot.objInfoFlag, sp.gpetRadius,sp.rpetRadius,sp.ipetRadius,sp.zpetRadius,sp.ypetRadius, sp.gpetR50,sp.rpetR50,sp.ipetR50,sp.zpetR50,sp.ypetR50, soa.gpsfLikelihood, soa.gKronRad, soa.rKronRad, soa.iKronRad INTO mydb.[K2C14] FROM MeanObject AS o JOIN fgetNearbyObjEq(160.68333, 6.85167 , 8.5) cone ON cone.objid = o.objID JOIN ObjectThin AS ot ON ot.objID = o.objID LEFT JOIN StackPetrosian AS sp ON sp.objID = o.objID LEFT JOIN StackObjectAttributes AS soa ON soa.objID = o.objID WHERE ot.ni >= 3 AND ot.ng >= 3 AND ot.nr >= 3 AND (o.rMeanKronMag > 0 AND o.rMeanKronMag <= 19.5 ) AND (o.gQfPerfect >= 0.95) AND (o.rQfPerfect >= 0.95) AND (o.iQfPerfect >= 0.95) AND (o.zQfPerfect >= 0.95) AND (o.rmeanpsfmag - o.rmeankronmag > 0.5) |
Results
First 10 Rows on MyDB Table K2C14
objID | raStack | decStack | raMean | decMean | ng | gMeanPSFMag | gMeanPSFMagErr | gMeanKronMag | gMeanKronMagErr | nr | rMeanPSFMag | rMeanPSFMagErr | rMeanKronMag | rMeanKronMagErr | ni | iMeanPSFMag | iMeanPSFMagErr | iMeanKronMag | iMeanKronMagErr | nz | zMeanPSFMag | zMeanPSFMagErr | zMeanKronMag | zMeanKronMagErr | ny | yMeanPSFMag | yMeanPSFMagErr | yMeanKronMag | yMeanKronMagErr | gQfPerfect | rQfPerfect | iQfPerfect | zQfPerfect | yQfPerfect | qualityFlag | objInfoFlag | gpetRadius | rpetRadius | ipetRadius | zpetRadius | ypetRadius | gpetR50 | rpetR50 | ipetR50 | zpetR50 | ypetR50 | gpsfLikelihood | gKronRad | rKronRad | iKronRad |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109081656511207587 | 165.65123799 | 0.90602251 | 165.6512316 | 0.90600456 | 7 | 21.6437 | 0.367865 | 20.0493 | 0.058567 | 12 | 20.6574 | 0.184406 | 19.3962 | 0.072033 | 21 | 20.5946 | 0.078082 | 19.1998 | 0.026173 | 11 | 20.5699 | 0.076552 | 19.1158 | 0.033139 | 2 | 20.24 | 0.008608 | 19.1051 | 0.202796 | 0.999734 | 0.999427 | 0.999521 | 0.999396 | 0.997468 | 53 | 444915712 | 10.4267 | 4.61004 | 14.1225 | 6.21549 | 5.26025 | 4.08935 | 1.71427 | 5.20723 | 2.50306 | 2.97936 | 0 | 5.31611 | 4.99134 | 6.30024 |
109081657271754110 | 165.72716855 | 0.90305714 | 165.7271564 | 0.90304372 | 14 | 20.1335 | 0.055225 | 19.3779 | 0.027096 | 18 | 19.1085 | 0.050282 | 17.9462 | 0.02275 | 41 | 18.3619 | 0.034442 | 17.4018 | 0.006397 | 14 | 18.4043 | 0.026483 | 17.1619 | 0.01081 | 15 | 18.0893 | 0.02773 | 17.1387 | 0.021028 | 0.999818 | 0.999666 | 0.999756 | 0.999283 | 0.999213 | 61 | 512024576 | 17.3958 | 7.08274 | 6.85966 | 6.21411 | 6.62478 | 5.23086 | 2.76816 | 2.69369 | 2.50231 | 2.43742 | 0 | 6.14782 | 7.20799 | 8.64767 |
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.12776 | 4.20798 | 3.30079 | 3.07922 | 3.51289 | 1.66921 | 1.62555 | 1.30019 | 1.18262 | 1.26171 | 1.10623E-28 | 4.50234 | 4.89816 | 4.61272 |
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.12776 | 4.20798 | 3.30079 | 3.07922 | 3.51289 | 1.66921 | 1.62555 | 1.30019 | 1.18262 | 1.26171 | 8.32451E-38 | 4.50676 | 4.95531 | 4.66793 |
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.45158 | 4.51567 | 3.29945 | 3.26378 | 3.35685 | 1.71603 | 1.69979 | 1.29004 | 1.21474 | 1.32069 | 1.10623E-28 | 4.50234 | 4.89816 | 4.61272 |
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.45158 | 4.51567 | 3.29945 | 3.26378 | 3.35685 | 1.71603 | 1.69979 | 1.29004 | 1.21474 | 1.32069 | 8.32451E-38 | 4.50676 | 4.95531 | 4.66793 |
109081663334564862 | 166.33350343 | 0.90367258 | 166.33352384 | 0.90364983 | 11 | 20.1058 | 0.076975 | 18.7424 | 0.018033 | 18 | 19.8483 | 0.046171 | 18.2347 | 0.028703 | 26 | 19.4088 | 0.047933 | 17.9761 | 0.012573 | 12 | 19.844 | 0.050792 | 18.1878 | 0.05053 | 10 | 19.4914 | 0.073344 | 18.128 | 0.060383 | 0.999617 | 0.9996 | 0.999637 | 0.999439 | 0.998929 | 53 | 444915712 | 6.44318 | 6.34578 | 47.401 | 6.3831 | 5.81085 | 2.48334 | 2.50278 | -999 | 2.16752 | 1.94129 | 0 | 6.67284 | 6.62435 | 7.05478 |
109091546911366908 | 154.69111052 | 0.91371481 | 154.69111613 | 0.91372215 | 12 | 21.5211 | 0.061925 | 20.6393 | 0.038723 | 12 | 19.8712 | 0.033214 | 19.1334 | 0.03706 | 18 | 19.3671 | 0.027138 | 18.6387 | 0.020194 | 12 | 19.164 | 0.032954 | 18.3498 | 0.021566 | 18 | 18.7781 | 0.029051 | 18.1354 | 0.061777 | 0.999671 | 0.999562 | 0.999327 | 0.999042 | 0.99935 | 61 | 512024576 | 5.93478 | 6.47688 | 4.99303 | 4.20024 | 4.27373 | 2.77074 | 2.31205 | 1.87484 | 1.62662 | 1.45794 | 0 | 4.03214 | 5.36095 | 5.44253 |
109091553299077983 | 155.32985996 | 0.91460413 | 155.32988886 | 0.91458204 | 13 | 21.0622 | 0.034554 | 20.384 | 0.025749 | 12 | 19.7496 | 0.029529 | 19.1491 | 0.018316 | 18 | 19.3754 | 0.014256 | 18.697 | 0.018941 | 11 | 19.0907 | 0.014836 | 18.4181 | 0.022808 | 15 | 18.7832 | 0.03516 | 18.2793 | 0.044125 | 0.999667 | 0.999634 | 0.999229 | 0.999176 | 0.999643 | 53 | 444915712 | 3.55787 | 4.13522 | 3.15372 | 2.80053 | 3.06662 | 1.62989 | 1.61636 | 1.25456 | 1.09398 | 1.19706 | 0 | 3.3149 | 4.09851 | 3.95382 |
109091554897205761 | -999 | -999 | 155.48960069 | 0.91276146 | 5 | 21.3409 | 0.096192 | 19.6764 | 0.076313 | 4 | 20.7341 | 0.210861 | 19.2442 | 0.062298 | 4 | 20.8052 | 0.253072 | 19.5661 | 0.124974 | 3 | 21.2265 | 0.121468 | 19.8865 | 0.094278 | 0 | -999 | -999 | -999 | -999 | 0.999139 | 0.99923 | 0.998889 | 0.997634 | -999 | 37 | 310697984 |
...
Sample Query 1 template (this is a template, just cut and paste, do not modify)
Goal/Description
fill in
Query
fill in
Results
fill in
...