VIEW  reliableGcsPointSource

Reliable, but incomplete, point source catalogue derived from UKIDSS GCS

This view defines a reliable subset of point-like sources from the UKIDSS
Galactic Clusters Survey (GCS). If your application requires a seamless
selection of reliable sources consistently classified as point-like (i.e.
stars) in the GCS then use this view. NB: as always, there is a
trade-off between completeness and reliability. If completeness is more
important than high reliability, then use gcsPointSource since it is
optimised for completeness and NOT high reliability. If a very clean,
highly reliable selection is required, then use this view. Because
reliability is optimised over completeness here, discrete classification
codes are used as these are conservative in flagging ojects as point-like.
The selection is based on stellar detecions in JHK (e.g. single passband
detections will NOT appear in this view) with a tighter ellipticity cut
than is in the notionally complete view.


SELECT *
FROM gcsSource
WHERE (priOrSec<=0 OR priOrSec=frameSetID)-- seamless selection
AND   ((zClass=-1 AND zEll<0.2) OR zClass = -9999)-- reliable Z point det OR no Z det
AND   ((yClass=-1 AND yEll<0.2) OR yClass = -9999)-- reliable Y point det OR no Y det
AND   jClass=-1 AND jEll<0.2  -- reliable J point det
AND   hClass=-1 AND hEll<0.2  -- reliable H point det
AND   k_1Class=-1 AND k_1Ell<0.2  -- reliable K1 point det
AND   ((k_2Class=-1 AND k_2Ell<0.2) OR k_2Class = -9999) -- reliable K2 point det OR no K2 det