TABLE VIEW  CompleteStars

High completeness sub-selection of stellar objects from Source.

This view of table Source defines a highly complete selection of point
sources. The select statement of the view requires the source to
be present on at least two out of four plates (Nplates > 1) along with an
adequate astrometric fit (ie. chi-squared value < 5.0) and on each plate
the following conditions are placed on available morphological parameters:
ellipticity < 0.33 (ie. image elongation is less than 50%);
-3.0 < profile statistic < 4.5 (ie. the areal profile set of the source is
close to an idealised PSF set in terms of a 3sigma lower limit and +4.5
upper limit on the N(0,1) profile statistic); quality flag < 2048 (ie.
strong warnings concerning quality issues reject sources from the view).

The use of this, or any other, SSA view depends on the particular science
application. If your science application needs a high completeness selection
of stellar objects but can cope with some contamination (particularly
misclassified sources, poorly parameterised deblends at the faint end and
poorly parameterised/calibrated images in very crowded regions)
then use this view.
The details and SQL SELECT corresponding to this view are available here.

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
objIDbigint8 Unique identifier of merged source ID_MAIN
objIDBbigint8 objID for B band detection merged into this object0ID_ASSOCIATED
objIDR1bigint8 objID for R1 band detection merged into this object0ID_ASSOCIATED
objIDR2bigint8 objID for R2 band detection merged into this object0ID_ASSOCIATED
objIDIbigint8 objID for I band detection merged into this object0ID_ASSOCIATED
htmIdbigint8 Hierarchical Triangular Mesh (20-deep) of centroid POS_GENERAL
epochreal4yearEpoch of position (variance weighted mean epoch of available measures) TIME_EPOCH
rafloat8degreesMean RA, computed from detections merged in this catalogue POS_EQ_RA_MAIN
decfloat8degreesMean Dec, computed from detections merged in this catalogue POS_EQ_DEC_MAIN
sigRAfloat8degreesUncertainty in RA (formal random error not inc. systematic errors) ERROR
sigDecfloat8degreesUncertainty in Dec (formal random error not inc. systematic errors) ERROR
cxfloat8 Cartesian x of unit (ra,dec) vector on celestial sphere POS_EQ_X
cyfloat8 Cartesian y of unit (ra,dec) vector on celestial sphere POS_EQ_Y
czfloat8 Cartesian z of unit (ra,dec) vector on celestial sphere POS_EQ_Z
muAcosDreal4mas/yrProper motion in RA direction-0.99999995e9POS_EQ_PMRA
muDreal4mas/yrProper motion in Dec direction-0.99999995e9POS_EQ_PMDEC
sigMuAcosDreal4mas/yrError on proper motion in RA direction-0.99999995e9ERROR
sigMuDreal4mas/yrError on proper motion in Dec direction-0.99999995e9ERROR
chi2real4 Chi-squared value of proper motion solution-0.99999995e9FIT_CHI2
Nplatestinyint1 No. of plates used for this proper motion measurement NUMBER
classMagBreal4magB band magnitude selected by B image class-99.999995PHOT_PHG_BJ
classMagR1real4magR1 band magnitude selected by R1 image class-99.999995PHOT_PHG_R
classMagR2real4magR2 band magnitude selected by R2 image class-99.999995PHOT_PHG_R
classMagIreal4magI band magnitude selected by I image class-99.999995PHOT_PHG_I
gCorMagBreal4magB band magnitude assuming object is galaxy-99.999995PHOT_PHG_BJ
gCorMagR1real4magR1 band magnitude assuming object is galaxy-99.999995PHOT_PHG_R
gCorMagR2real4magR2 band magnitude assuming object is galaxy-99.999995PHOT_PHG_R
gCorMagIreal4magI band magnitude assuming object is galaxy-99.999995PHOT_PHG_I
sCorMagBreal4magB band magnitude assuming object is star-99.999995PHOT_PHG_BJ
sCorMagR1real4magR1 band magnitude assuming object is star-99.999995PHOT_PHG_R
sCorMagR2real4magR2 band magnitude assuming object is star-99.999995PHOT_PHG_R
sCorMagIreal4magI band magnitude assuming object is star-99.999995PHOT_PHG_I
meanClasstinyint1 Estimate of image class based on unit-weighted mean of individual classes CLASS_OBJECT
classBtinyint1 Image classification from B band detection0CLASS_OBJECT
classR1tinyint1 Image classification from R1 band detection0CLASS_OBJECT
classR2tinyint1 Image classification from R2 band detection0CLASS_OBJECT
classItinyint1 Image classification from I band detection0CLASS_OBJECT
ellipBreal4 Ellipticity of B band detection-0.99999995e9PHYS_ELLIPTICITY
ellipR1real4 Ellipticity of R1 band detection-0.99999995e9PHYS_ELLIPTICITY
ellipR2real4 Ellipticity of R2 band detection-0.99999995e9PHYS_ELLIPTICITY
ellipIreal4 Ellipticity of I band detection-0.99999995e9PHYS_ELLIPTICITY
qualBint4 Bitwise quality flag from B band detection-1CODE_QUALITY
qualR1int4 Bitwise quality flag from R1 band detection-1CODE_QUALITY
qualR2int4 Bitwise quality flag from R2 band detection-1CODE_QUALITY
qualIint4 Bitwise quality flag from I band detection-1CODE_QUALITY
blendBint4 Blend flag from B band detection-99999999CODE_MULT_INDEX
blendR1int4 Blend flag from R1 band detection-99999999CODE_MULT_INDEX
blendR2int4 Blend flag from R2 band detection-99999999CODE_MULT_INDEX
blendIint4 Blend flag from I band detection-99999999CODE_MULT_INDEX
prfStatBreal4N(0,1)Profile statistic from B band detection-0.99999995e9CLASS_STAR/GALAXY
prfStatR1real4N(0,1)Profile statistic from R1 band detection-0.99999995e9CLASS_STAR/GALAXY
prfStatR2real4N(0,1)Profile statistic from R2 band detection-0.99999995e9CLASS_STAR/GALAXY
prfStatIreal4N(0,1)Profile statistic from I band detection-0.99999995e9CLASS_STAR/GALAXY
lreal4degreesThe Galactic longitude of the source POS_GAL_LON
breal4degreesThe Galactic latitude of the source POS_GAL_LAT
dreal4degreesThe great-circle distance of the source from the Galactic centre POS_ANG_DIST_REL
Ebmvreal4magThe estimated foreground reddening at this position from Schlegel et al. (1998) PHOT_EXTINCTION_GAL
Total length262