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

Compare with Current View Page History

« Previous Version 14 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.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

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

 

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.[K2C14] 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.5)

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