Page History
...
Code Block | ||
---|---|---|
| ||
SELECT o.ObjID,x.ra,x.dec,
o.gMeanPSFMag, o.gMeanPSFMagErr,
o.rMeanPSFMag, o.rMeanPSFMagErr,
o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanKronMag,
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
into mydb.HighFidelityStars FROM dbo.fGetNearbyObjEq(334, 0.0, 0.2*60) 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
and o.iMeanPSFMag - o.iMeanKronMag < 0.05 |
...
1186 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107983339959645663 | 333.99599713 | -0.01232781 | 21.391 | 0.052075 | 20.1083 | 0.012237 | 19.3927 | 0.006775 | 19.51 | 19.0319 | 0.01218 | 13 | 11 | 36 | 9 | 115000 | 0.999441 | 115000 | 0.999716 | 115000 | 0.999646 | 115000 | 0.99915 |
107993340021574948 | 334.00240353 | -0.00455724 | 14.5713 | 0.002685 | 13.8055 | 0.00178 | 13.4717 | 0.009949 | 13.5257 | 13.3015 | 0.005784 | 9 | 5 | 3 | 3 | 115000 | 0.999736 | 115000 | 0.999613 | 16875832 | 0.999791 | 115000 | 0.998601 |
107993340179693883 | 334.01799251 | -0.00549774 | 17.4503 | 0.003783 | 16.9778 | 0.003269 | 16.7906 | 0.003371 | 16.8453 | 16.7163 | 0.002006 | 15 | 14 | 27 | 8 | 115000 | 0.999711 | 115000 | 0.999652 | 115000 | 0.999798 | 115000 | 0.999419 |
107993340198884334 | 334.01992279 | -0.00509159 | 19.4103 | 0.01329 | 18.505 | 0.004361 | 18.1168 | 0.003861 | 18.2115 | 17.9228 | 0.005974 | 15 | 13 | 26 | 9 | 115000 | 0.999391 | 115000 | 0.999725 | 115000 | 0.999686 | 115000 | 0.998421 |
107973340139059530 | 334.01386508 | -0.01747886 | 18.5957 | 0.010269 | 17.3003 | 0.005493 | 16.4259 | 0.002057 | 16.4773 | 16.0086 | 0.002941 | 14 | 11 | 23 | 9 | 115000 | 0.999782 | 115000 | 0.999087 | 115000 | 0.999651 | 115000 | 0.999328 |
107943340372100416 | 334.03723218 | -0.05004234 | 21.0299 | 0.056462 | 20.1832 | 0.034098 | 19.7762 | 0.014144 | 19.9057 | 19.5868 | 0.025847 | 6 | 11 | 29 | 6 | 115000 | 0.999709 | 115000 | 0.999706 | 115000 | 0.999596 | 115000 | 0.999113 |
107933340420125830 | 334.04204708 | -0.05390375 | 21.4989 | 0.212495 | 21.6663 | 0.041478 | 20.2705 | 0.018235 | 20.4247 | 19.5763 | 0.01725 | 1 | 4 | 27 | 10 | 115000 | 0.999029 | 115000 | 0.998995 | 115000 | 0.999752 | 115000 | 0.998695 |
107913340590138100 | 334.05902907 | -0.06866118 | 17.5672 | 0.004179 | 16.642 | 0.002755 | 16.2472 | 0.002185 | 16.304 | 16.0574 | 0.001708 | 11 | 12 | 27 | 12 | 115000 | 0.999633 | 115000 | 0.999512 | 115000 | 0.99968 | 115000 | 0.99967 |
108003340636170411 | 334.06365419 | -7.065E-05 | 20.9453 | 0.002623 | 20.3877 | 0.010759 | 20.1518 | 0.015449 | 20.246 | 19.9692 | 0.0309 | 4 | 10 | 19 | 5 | 115000 | 0.999669 | 115000 | 0.99959 | 115000 | 0.999809 | 115000 | 0.998574 |
108003340636540461 | 334.06366481 | -6.926E-05 | 20.9227 | 0.060039 | 20.4111 | 0.073774 | 20.1528 | 0.02005 | 20.3164 | 19.9657 | 0.084295 | 7 | 2 | 6 | 4 | 280 | 0.999057 | 280 | 0.982842 | 280 | 0.999557 | 280 | 0.998914 |
...
gFlags | gQfPerfect | rFlags | rQfPerfect | iFlags | iQfPerfect | zFlags | zQfPerfect | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108143340320077923 | 334.03201415 | 0.12286939 | 16.446 | 0.006434 | 16.1399 | 0.00306 | 16.025 | 0.003634 | 15.9673 | 0.004871 | 11 | 13 | 20 | 6 | 115000 | 0.999761 | 115000 | 0.999319 | 115000 | 0.999613 | 115000 | 0.998617 |
108143340371462685 | 334.0371923 | 0.1184782 | 21.8684 | 0.059845 | 20.6516 | 0.03306 | 19.3692 | 0.00959 | 18.7655 | 0.014971 | 5 | 15 | 26 | 10 | 115000 | 0.999687 | 115000 | 0.999656 | 115000 | 0.999636 | 115000 | 0.999167 |
108143339062586492 | 333.90620988 | 0.12170175 | 20.8683 | 0.048949 | 19.7662 | 0.012892 | 19.3193 | 0.006773 | 19.0611 | 0.010466 | 14 | 14 | 26 | 10 | 115000 | 0.999709 | 115000 | 0.999229 | 115000 | 0.999867 | 115000 | 0.999306 |
108143339109884469 | 333.91099037 | 0.12003804 | 21.937 | 0.082766 | 21.1638 | 0.056636 | 20.8061 | 0.022502 | 20.4827 | 0.090837 | 6 | 14 | 31 | 7 | 115000 | 0.999702 | 115000 | 0.999675 | 115000 | 0.999717 | 16892216 | 0.999437 |
108143339196130050 | 333.91961919 | 0.11633493 | 17.6448 | 0.00703 | 17.1417 | 0.002871 | 16.954 | 0.001892 | 16.8825 | 0.003997 | 13 | 10 | 28 | 11 | 115000 | 0.999359 | 115000 | 0.999708 | 115000 | 0.9995 | 115000 | 0.99867 |
108143339336352985 | 333.93373423 | 0.1188196 | 21.6992 | 0.2989 | 21.6163 | 0.065699 | 21.4406 | 0.060324 | 21.2789 | 0.034126 | 2 | 6 | 18 | 2 | 115000 | 0.999325 | 115000 | 0.999577 | 115000 | 0.999439 | 115000 | 0.997368 |
108143339404472900 | 333.94043549 | 0.11869219 | 15.3414 | 0.002273 | 14.8532 | 0.00155 | 14.6757 | 0.001595 | 14.5999 | 0.002275 | 10 | 9 | 20 | 8 | 115000 | 0.99944 | 115000 | 0.999836 | 115000 | 0.999315 | 115000 | 0.999205 |
108143339668432294 | 333.96682718 | 0.11819098 | 22.0217 | 0.067906 | 21.3497 | 0.062714 | 20.8961 | 0.028299 | 20.5699 | 0.036334 | 4 | 12 | 32 | 9 | 115000 | 0.999024 | 16892216 | 0.999603 | 16892216 | 0.999577 | 16892216 | 0.999465 |
108143339827340337 | 333.98273918 | 0.11654706 | 21.9591 | 0.093378 | 21.4044 | 0.06764 | 21.3171 | 0.038523 | 20.9033 | 0.097902 | 6 | 9 | 24 | 2 | 115000 | 0.99917 | 115000 | 0.999677 | 16892216 | 0.999654 | 115000 | 0.999117 |
108143339889859962 | 333.98899315 | 0.12460124 | 20.6774 | 0.023992 | 20.1869 | 0.016941 | 20.0041 | 0.013276 | 19.8457 | 0.02573 | 10 | 15 | 30 | 6 | 115000 | 0.999847 | 115000 | 0.999638 | 115000 | 0.99976 | 115000 | 0.999694 |
Galaxy Candidates for K2 C14 SN Search
...