Page History
...
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.
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
Code Block | ||
---|---|---|
| ||
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*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 |
...
Code Block | ||
---|---|---|
| ||
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)
|
...