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

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
107763339788289399333.97880748-0.1925374821.94380.1110620.20340.02706319.50140.01797119.01340.029953814138248880.998615248880.999312248880.999381248880.999301
107763340006649595334.00065785-0.1923640719.59950.01773418.33720.00771417.21070.00404916.6920.00548412121210166960.999146166960.9993193120.9986273120.999408
107763340150042386334.01499455-0.1983675422.04760.16034720.80120.04550619.61330.00825319.02160.030203101098166960.99887166960.999343166880.999042166960.999635
107763340365706349334.03655623-0.1950846421.92880.10914721.57840.08676321.09640.06644620.39650.11884412101313166960.999101166960.998961248880.999252166960.999638
107763340427936906334.04279614-0.194597921.74270.09238221.64150.09162720.90720.05818821.21960.1734671210131166960.998822248880.999251248880.999312166880.996947
107773339339728631333.93396938-0.184836520.98230.04872319.86630.0208518.58130.00380617.99140.0132112141212166960.999034166960.998801166880.999195166960.999352
107773339418267057333.94184362-0.1861598221.99660.07023620.94560.02613420.55470.01901620.25070.0907824686166960.998274166960.99932166880.999224166960.99931
107773339602449349333.96024341-0.1842461620.98860.02551419.72360.01027318.44330.00877317.82970.004637661010166880.998774166880.998944166960.999612166880.999226
107773339666322634333.96662932-0.1898462918.2940.0079717.73510.00547517.52010.00491717.39940.005004810106166960.998668166960.998606166960.999246166880.998957
107773339901141449333.99012708-0.1908125922.01770.11699520.79350.04395619.32850.01599718.58020.0211081213138166960.999287166960.999454166960.998564166960.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

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
       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
       JOIN StackPetrosian AS sp ON sp.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

 
objIDraStackdecStackraMeandecMeannggMeanPSFMaggMeanPSFMagErrgMeanKronMaggMeanKronMagErrnrrMeanPSFMagrMeanPSFMagErrrMeanKronMagrMeanKronMagErrniiMeanPSFMagiMeanPSFMagErriMeanKronMagiMeanKronMagErrnzzMeanPSFMagzMeanPSFMagErrzMeanKronMagzMeanKronMagErrnyyMeanPSFMagyMeanPSFMagErryMeanKronMagyMeanKronMagErrgQfPerfectrQfPerfectiQfPerfectzQfPerfectyQfPerfectqualityFlagobjInfoFlaggpetRadiusrpetRadiusipetRadiuszpetRadiusypetRadiusgpetR50rpetR50ipetR50zpetR50ypetR50
123311549281210477154.9281261112.75831367154.9281143112.758325181020.08350.02440119.3010.0281611619.04150.03971818.2090.0093432018.63260.02330917.70530.0118491218.01350.02964317.42830.0099141418.10770.04253417.32810.0235530.9998120.999530.9994080.9998180.999398615120245767.654646.897815.744125.579774.210742.781332.361782.054822.05141.67238
123311556359837190155.6359545612.76391817155.6359425412.763930651720.63170.02961220.13220.0308722219.58720.03523619.0090.0155462419.20380.02263218.54630.0135141318.72410.02960518.24880.0164071518.71480.02514318.16580.0365890.9998410.9996670.9997230.9996960.999486615120245764.117643.192343.371763.557033.554011.646431.286591.304571.413521.64367
123311563608493897156.3608017212.76123503156.3608191812.761232671219.68280.05332417.59690.0139961019.69950.21460917.24010.0148491419.65990.08852617.14260.013593619.25740.07735617.32680.023463519.49230.21471217.93440.0357960.9995780.9998050.9997710.9995480.9982635344491571210.875911.19911.148410.53479.508674.437944.407084.526884.212623.28768
123311564766811688156.4767324812.75933957156.4767647912.759337741020.60360.03883520.22540.0288231219.61610.02944919.06410.0263251919.29170.02141718.78120.016662918.91180.02102518.54090.0359191218.82950.02484718.36640.056010.999620.9996730.9996850.9995860.99939534449157124.005643.491434.640694.7902-9.089561.38871.119211.253591.44259-9.07378
123311565993385602156.5993128912.76262096156.5993187212.762623021019.35030.02654218.47210.0225391418.80370.03286418.00290.0204261518.55670.01202417.63360.0123151118.32970.06131917.3870.0167211718.24860.05307417.25160.0872250.9998340.9993080.9994170.9998120.999327615120245763.114292.812842.978543.1178.682951.008330.9806321.071040.9847752.965
123311564444738006156.4444791712.76459414156.4445027712.76459045919.95330.02600519.45650.0180231418.96690.01797118.26640.0118211418.5550.0180517.79320.00674718.15250.04844917.50990.019581618.03240.05489917.37980.0214010.9996580.9995810.9996570.9995160.999339615120245764.858214.281384.095613.925654.571841.852111.57081.530561.57951.66867
123311566009794928156.6010257412.76200927156.6010230412.762018481019.0360.05909618.08170.022481417.94790.04404117.12540.0157341417.64110.02353416.71420.006589917.22560.05724716.43490.0057361617.08580.05509616.14440.032470.9996660.9990910.9996630.9994640.998955615120245765.992775.451154.691985.37832.765492.436622.23881.86532.152311.06782
123311566048421351156.6048448112.75900132156.6048454612.7590098819.23690.03449118.7270.0242391218.39250.0109517.75540.0102321618.03910.02866117.34290.0056091117.66640.02475517.08230.0109941817.55880.03483517.02710.0118150.9996640.9995440.9996020.9996230.999433615120245764.166813.540433.218583.6975526.10361.568391.363761.275061.37458-999
123311569207978960156.9207648212.76540801156.9207605612.76544365920.88240.06393520.12540.0383681220.19920.02804719.39530.026821419.9630.01710419.11690.0223851119.39160.09316918.84230.0472321419.37030.05030218.62630.0604360.9995120.9997060.9998580.9993530.999578534449157125.588584.867154.594965.163384.859842.104452.048281.827242.169792.12018
123311577928974093157.7928819512.76131325157.7928603812.761336821019.84320.02699419.41510.0373581419.02660.01078318.50780.009612018.64030.01435918.10070.0080811518.3020.02894917.90150.0164421418.34220.02580217.82780.008720.9992930.9992350.9990650.9992430.9993746151202457613.27313.464663.095033.83952.81046.115661.39391.233341.35631.08618

 


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