Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updated table in high-fi star sample

...

Code Block
languagesql
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 
107763339788289399107983339959645663333.9788074899599713-0.192537480123278121.94383910.1110605207520.203410830.02706301223719.501439270.00677519.0179715119.013403190.029953012188131411133689248881150000.998615999441248881150000.999312999716248881150000.999381999646248881150000.99930199915
107763340006649595107993340021574948334.0006578500240353-0.19236407004557241914.599557130.0177340026851813.337280550.007714001781713.210747170.00994913.00404952571613.69230150.005484005784129125123103166961150000.999146999736166961150000.999319999613312168758320.9986279997913121150000.999408998601
107763340150042386107993340179693883334.0149945501799251-0.19836754005497742217.047645030.1603470037832016.801297780.0455060032691916.613379060.00337116.00825384531916.021671630.030203002006101510149278166961150000.99887999711166961150000.999343999652166881150000.999042999798166961150000.999635999419
107763340365706349107993340198884334334.0365562301992279-0.19508464005091592119.928841030.109147013292118.57845050.0867630043612118.096411680.00386118.06644621152017.396592280.118844005974121510131326139166961150000.999101999391166961150000.998961999725248881150000.999252999686166961150000.999638998421
107763340427936906107973340139059530334.0427961401386508-0.1945979017478862118.742759570.0923820102692117.641530030.0916270054932016.907242590.00205716.05818847732116.219600860.17346700294112141011132319166961150000.998822999782248881150000.999251999087248881150000.999312999651166881150000.996947999328
107773339339728631107943340372100416333334.9339693803723218-0.1848365050042342021.982302990.0487230564621920.866318320.020850340981819.581377620.01414419.00380690571719.991458680.0132102584712614111229126166961150000.999034999709166961150000.998801999706166881150000.999195999596166961150000.999352999113
107773339418267057107933340420125830333334.9418436204204708-0.186159820539037521.996649890.0702362124952021.945666630.02613404147820.554727050.01901601823520.2507424719.57630.09078201725146278106166961150000.998274999029166961150000.99932998995166881150000.999224999752166961150000.99931998695
107773339602449349107913340590138100333334.9602434105902907-0.18424616068661182017.988656720.0255140041791916.72366420.0102730027551816.443324720.0087730021851716.82973040.00463766101016.05740.00170811122712115000166880.998774999633166881150000.998944999512166961150000.99961299968166881150000.99922699967
107773339666322634108003340636170411333334.9666293206365419-07.18984629065E-051820.29494530.007970026231720.735138770.0054750107591720.520115180.01544920.0049172461719.399496920.00500403098410101965166961150000.998668999669166961150000.99860699959166961150000.999246999809166881150000.998957998574
107773339901141449108003340636540461333334.9901270806366481-06.19081259926E-052220.017792270.11699506003920.793541110.0439560737741920.328515280.0200520.01599731641819.580296570.02110808429512713213684166962800.999287999057166962800.999454982842166962800.998564999557166962800.999272998914

 

Galaxy Candidates for K2 C14 SN Search

...