Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
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 
107983339959645663333.99599713-0.0123278121.3910.05207520.10830.01223719.39270.00677519.5119.03190.0121813113691150000.9994411150000.9997161150000.9996461150000.99915
107993340021574948334.00240353-0.0045572414.57130.00268513.80550.0017813.47170.00994913.525713.30150.00578495331150000.9997361150000.999613168758320.9997911150000.998601
107993340179693883334.01799251-0.0054977417.45030.00378316.97780.00326916.79060.00337116.845316.71630.00200615142781150000.9997111150000.9996521150000.9997981150000.999419
107993340198884334334.01992279-0.0050915919.41030.0132918.5050.00436118.11680.00386118.211517.92280.00597415132691150000.9993911150000.9997251150000.9996861150000.998421
107973340139059530334.01386508-0.0174788618.59570.01026917.30030.00549316.42590.00205716.477316.00860.00294114112391150000.9997821150000.9990871150000.9996511150000.999328
107943340372100416334.03723218-0.0500423421.02990.05646220.18320.03409819.77620.01414419.905719.58680.0258476112961150000.9997091150000.9997061150000.9995961150000.999113
107933340420125830334.04204708-0.0539037521.49890.21249521.66630.04147820.27050.01823520.424719.57630.017251427101150000.9990291150000.9989951150000.9997521150000.998695
107913340590138100334.05902907-0.0686611817.56720.00417916.6420.00275516.24720.00218516.30416.05740.001708111227121150000.9996331150000.9995121150000.999681150000.99967
108003340636170411334.06365419-7.065E-0520.94530.00262320.38770.01075920.15180.01544920.24619.96920.03094101951150000.9996691150000.999591150000.9998091150000.998574
108003340636540461334.06366481-6.926E-0520.92270.06003920.41110.07377420.15280.0200520.316419.96570.08429572642800.9990572800.9828422800.9995572800.998914

...

gFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfect
108143340320077923334.032014150.1228693916.4460.00643416.13990.0030616.0250.00363415.96730.00487111132061150000.9997611150000.9993191150000.9996131150000.998617
108143340371462685334.03719230.118478221.86840.05984520.65160.0330619.36920.0095918.76550.01497151526101150000.9996871150000.9996561150000.9996361150000.999167
108143339062586492333.906209880.1217017520.86830.04894919.76620.01289219.31930.00677319.06110.010466141426101150000.9997091150000.9992291150000.9998671150000.999306
108143339109884469333.910990370.1200380421.9370.08276621.16380.05663620.80610.02250220.48270.0908376143171150000.9997021150000.9996751150000.999717168922160.999437
108143339196130050333.919619190.1163349317.64480.0070317.14170.00287116.9540.00189216.88250.003997131028111150000.9993591150000.9997081150000.99951150000.99867
108143339336352985333.933734230.118819621.69920.298921.61630.06569921.44060.06032421.27890.034126261821150000.9993251150000.9995771150000.9994391150000.997368
108143339404472900333.940435490.1186921915.34140.00227314.85320.0015514.67570.00159514.59990.0022751092081150000.999441150000.9998361150000.9993151150000.999205
108143339668432294333.966827180.1181909822.02170.06790621.34970.06271420.89610.02829920.56990.0363344123291150000.999024168922160.999603168922160.999577168922160.999465
108143339827340337333.982739180.1165470621.95910.09337821.40440.0676421.31710.03852320.90330.097902692421150000.999171150000.999677168922160.9996541150000.999117
108143339889859962333.988993150.1246012420.67740.02399220.18690.01694120.00410.01327619.84570.0257310153061150000.9998471150000.9996381150000.999761150000.999694

Galaxy Candidates for K2 C14 SN Search

...