Create Content

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

Compare with Current View Page History

« Previous Version 17 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, and PSF-Kron to be < 0.05 to select only stars (we use the i-band in this example, as this is usually the deepest).

Note that the search radius is in arcminutes.  This is a recent change in the interface to make the PS1 database functions consistent with those used for SDSS, GALEX, Kepler, the HSC, and other MAST catalogs.

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 
INTO mydb.HighFidelityStars 
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.8

Results

1097 objects, here are the first 10:

ObjIDradecgMeanPSFMaggMeanPSFMagErrrMeanPSFMagrMeanPSFMagErriMeanPSFMagiMeanPSFMagErrzMeanPSFMagzMeanPSFMagErrgMeanPSFmagNptrMeanPSFmagNptiMeanPSFmagNptzMeanPSFmagNptgFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfect
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

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,
soa.gpsfLikelihood, soa.gKronRad, soa.rKronRad, soa.iKronRad
       INTO mydb.[C14] FROM MeanObject AS o
       JOIN fgetNearbyObjEq(160.68333, 6.85167 , 8.5*60) cone ON cone.objid = o.objID 
       JOIN ObjectThin AS ot ON ot.objID = o.objID
       LEFT JOIN StackPetrosian AS sp ON sp.objID = o.objID
       LEFT JOIN StackObjectAttributes AS soa ON soa.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.05)

Results

First 10 Rows on MyDB Table K2C14

 
objIDraStackdecStackraMeandecMeannggMeanPSFMaggMeanPSFMagErrgMeanKronMaggMeanKronMagErrnrrMeanPSFMagrMeanPSFMagErrrMeanKronMagrMeanKronMagErrniiMeanPSFMagiMeanPSFMagErriMeanKronMagiMeanKronMagErrnzzMeanPSFMagzMeanPSFMagErrzMeanKronMagzMeanKronMagErrnyyMeanPSFMagyMeanPSFMagErryMeanKronMagyMeanKronMagErrgQfPerfectrQfPerfectiQfPerfectzQfPerfectyQfPerfectqualityFlagobjInfoFlaggpetRadiusrpetRadiusipetRadiuszpetRadiusypetRadiusgpetR50rpetR50ipetR50zpetR50ypetR50gpsfLikelihoodgKronRadrKronRadiKronRad
109081656511207587165.651237990.90602251165.65123160.90600456721.64370.36786520.04930.0585671220.65740.18440619.39620.0720332120.59460.07808219.19980.0261731120.56990.07655219.11580.033139220.240.00860819.10510.2027960.9997340.9994270.9995210.9993960.9974685344491571210.42674.6100414.12256.215495.260254.089351.714275.207232.503062.9793605.316114.991346.30024
109081657271754110165.727168550.90305714165.72715640.903043721420.13350.05522519.37790.0270961819.10850.05028217.94620.022754118.36190.03444217.40180.0063971418.40430.02648317.16190.010811518.08930.0277317.13870.0210280.9998180.9996660.9997560.9992830.9992136151202457617.39587.082746.859666.214116.624785.230862.768162.693692.502312.4374206.147827.207998.64767
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.127764.207983.300793.079223.512891.669211.625551.300191.182621.261711.10623E-284.502344.898164.61272
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.127764.207983.300793.079223.512891.669211.625551.300191.182621.261718.32451E-384.506764.955314.66793
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.451584.515673.299453.263783.356851.716031.699791.290041.214741.320691.10623E-284.502344.898164.61272
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.451584.515673.299453.263783.356851.716031.699791.290041.214741.320698.32451E-384.506764.955314.66793
109081663334564862166.333503430.90367258166.333523840.903649831120.10580.07697518.74240.0180331819.84830.04617118.23470.0287032619.40880.04793317.97610.0125731219.8440.05079218.18780.050531019.49140.07334418.1280.0603830.9996170.99960.9996370.9994390.998929534449157126.443186.3457847.4016.38315.810852.483342.50278-9992.167521.9412906.672846.624357.05478
109091546911366908154.691110520.91371481154.691116130.913722151221.52110.06192520.63930.0387231219.87120.03321419.13340.037061819.36710.02713818.63870.0201941219.1640.03295418.34980.0215661818.77810.02905118.13540.0617770.9996710.9995620.9993270.9990420.99935615120245765.934786.476884.993034.200244.273732.770742.312051.874841.626621.4579404.032145.360955.44253
109091553299077983155.329859960.91460413155.329888860.914582041321.06220.03455420.3840.0257491219.74960.02952919.14910.0183161819.37540.01425618.6970.0189411119.09070.01483618.41810.0228081518.78320.0351618.27930.0441250.9996670.9996340.9992290.9991760.999643534449157123.557874.135223.153722.800533.066621.629891.616361.254561.093981.1970603.31494.098513.95382
109091554897205761-999-999155.489600690.91276146521.34090.09619219.67640.076313420.73410.21086119.24420.062298420.80520.25307219.56610.124974321.22650.12146819.88650.0942780-999-999-999-9990.9991390.999230.9988890.997634-99937310697984              

 

 


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