Create Content

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

On this page


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 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.

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.[K2C14pv3_v3] 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 K2C14pv3_v3

 
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


 

 

  • No labels