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


SELECT *
FROM   gcsSource
/*     Seamless selection of unique objects: */
WHERE  (priOrSec <= 0 OR priOrSec = frameSetID)
/*     High quality, highly likely point detection in J, H and K1: */
AND    jClass   = -1 AND jppErrBits = 0
AND    hClass   = -1 AND hppErrBits = 0
AND    k_1Class = -1 AND k_1ppErrBits = 0
/*     High quality, highly likely point detection, OR none, in Z, Y and K2: */
AND    (zClass   = -1 OR zClass = -9999) AND zppErrBits <= 0
AND    (yClass   = -1 OR yClass = -9999) AND yppErrBits <= 0
AND    (k_2Class = -1 OR k_2Class = -9999) AND k_2ppErrBits <= 0
/*     J, H and K (first epoch) positional coincidence within 1 arcsec: */
AND    jXi   BETWEEN -1.0 AND +1.0 AND jEta BETWEEN -1.0 AND +1.0
AND    hXi   BETWEEN -1.0 AND +1.0 AND hEta BETWEEN -1.0 AND +1.0
AND    k_1Xi BETWEEN -1.0 AND +1.0 AND k_1Eta BETWEEN -1.0 AND +1.0
/*     Z and Y positional coincidence within 1 arcsec when available: */
AND    ((zXi BETWEEN -1.0 AND +1.0 AND zEta BETWEEN -1.0 AND +1.0) OR zXi < -0.9e9)
AND    ((yXi BETWEEN -1.0 AND +1.0 AND yEta BETWEEN -1.0 AND +1.0) OR yXi < -0.9e9)

The details of the table defined by this view are available here.