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 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 |
Results
1218 1186 objects, here are the first 10 (NOTE: THIS IS THE RESULT OF THE QUERY WITHOUT APPLYING THE PSF-KRON CUT):
[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 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107763339788289399107983339959645663 | 333.9788074899599713 | -0.1925374801232781 | 21.9438391 | 0.11106052075 | 20.20341083 | 0.027063012237 | 19.50143927 | 0.006775 | 19.01797151 | 19.01340319 | 0.02995301218 | 813 | 1411 | 1336 | 89 | 24888115000 | 0.998615999441 | 24888115000 | 0.999312999716 | 24888115000 | 0.999381999646 | 24888115000 | 0.99930199915 | |||||
107763340006649595107993340021574948 | 334.0006578500240353 | -0.1923640700455724 | 1914.59955713 | 0.017734002685 | 1813.33728055 | 0.00771400178 | 1713.21074717 | 0.009949 | 13.0040495257 | 1613.6923015 | 0.005484005784 | 12912 | 5 | 123 | 103 | 16696115000 | 0.999146999736 | 16696115000 | 0.999319999613 | 31216875832 | 0.998627999791 | 312115000 | 0.999408998601 | |||||
107763340150042386107993340179693883 | 334.0149945501799251 | -0.1983675400549774 | 2217.04764503 | 0.160347003783 | 2016.80129778 | 0.045506003269 | 1916.61337906 | 0.003371 | 16.0082538453 | 1916.02167163 | 0.030203002006 | 101510 | 14 | 927 | 8 | 16696115000 | 0.99887999711 | 16696115000 | 0.999343999652 | 16688115000 | 0.999042999798 | 16696115000 | 0.999635999419 | |||||
107763340365706349107993340198884334 | 334.0365562301992279 | -0.1950846400509159 | 2119.92884103 | 0.10914701329 | 2118.5784505 | 0.086763004361 | 2118.09641168 | 0.003861 | 18.0664462115 | 2017.39659228 | 0.118844005974 | 1215 | 101313 | 26 | 139 | 16696115000 | 0.999101999391 | 16696115000 | 0.998961999725 | 24888115000 | 0.999252999686 | 16696115000 | 0.999638998421 | |||||
107763340427936906107973340139059530 | 334.0427961401386508 | -0.194597901747886 | 2118.74275957 | 0.092382010269 | 2117.64153003 | 0.091627005493 | 2016.90724259 | 0.002057 | 16.0581884773 | 2116.21960086 | 0.173467002941 | 1214 | 1011 | 1323 | 19 | 16696115000 | 0.998822999782 | 24888115000 | 0.999251999087 | 24888115000 | 0.999312999651 | 16688115000 | 0.996947999328 | |||||
107773339339728631107943340372100416 | 333334.9339693803723218 | -0.184836505004234 | 2021.98230299 | 0.048723056462 | 1920.86631832 | 0.02085034098 | 1819.58137762 | 0.014144 | 19.0038069057 | 1719.99145868 | 0.01321025847 | 126 | 1411 | 122912 | 6 | 16696115000 | 0.999034999709 | 16696115000 | 0.998801999706 | 16688115000 | 0.999195999596 | 16696115000 | 0.999352999113 | |||||
107773339418267057107933340420125830 | 333334.9418436204204708 | -0.1861598205390375 | 21.99664989 | 0.070236212495 | 2021.94566663 | 0.026134041478 | 20.55472705 | 0.019016018235 | 20.25074247 | 19.5763 | 0.09078201725 | 1 | 4 | 627 | 810 | 6 | 16696115000 | 0.998274999029 | 16696115000 | 0.99932998995 | 16688115000 | 0.999224999752 | 16696115000 | 0.99931998695 | ||||
107773339602449349107913340590138100 | 333334.9602434105902907 | -0.1842461606866118 | 2017.98865672 | 0.025514004179 | 1916.7236642 | 0.010273002755 | 1816.44332472 | 0.008773002185 | 1716.8297304 | 0.004637 | 6 | 6 | 10 | 10 | 16.0574 | 0.001708 | 11 | 12 | 27 | 12 | 11500016688 | 0.998774999633 | 16688115000 | 0.998944999512 | 16696115000 | 0.99961299968 | 16688115000 | 0.99922699967 |
107773339666322634108003340636170411 | 333334.9666293206365419 | -07.18984629065E-05 | 1820.2949453 | 0.00797002623 | 1720.73513877 | 0.005475010759 | 1720.52011518 | 0.015449 | 20.004917246 | 1719.39949692 | 0.0050040309 | 84 | 1010 | 19 | 65 | 16696115000 | 0.998668999669 | 16696115000 | 0.99860699959 | 16696115000 | 0.999246999809 | 16688115000 | 0.998957998574 | |||||
107773339901141449108003340636540461 | 333334.9901270806366481 | -06.19081259926E-05 | 2220.01779227 | 0.116995060039 | 20.79354111 | 0.043956073774 | 1920.32851528 | 0.02005 | 20.0159973164 | 1819.58029657 | 0.021108084295 | 127 | 13213 | 6 | 84 | 16696280 | 0.999287999057 | 16696280 | 0.999454982842 | 16696280 | 0.998564999557 | 16696280 | 0.999272998914 |
Galaxy Candidates for K2 C14 SN Search
...