| Flags identifying and characterising outlier stars. |
| This view contains the results of the analyses performed by WG14 to identify outlier spectra joined to the WG15 recommended analyses. The WG14 analyses pertain to spectra characterised by large residuals when processed using automatic classification tools and typically correspond to stars with unusual characteristics. In iDR2 the outlier analyses generates the columns of flags peculi, remark and tech. In subsequent releases additional columns may be generated. The corresponding WG15 flags are also included. |
SELECT
wg14.specGroupID AS WG14_specGroupId,
wg15.specGroupID AS WG15_specGroupId,
spg14.specID AS specId,
spg14.fileName AS fileName,
wg15.cName AS cName,
wg15.instrument AS instrument,
wg15.gratings AS gratings,
wg15.gesField AS gesField,
wg14.peculi AS WG14_peculi,
wg14.remark AS WG14_remark,
wg14.tech AS WG14_tech,
wg15.peculi AS WG15_peculi,
wg15.remark AS WG15_remark,
wg15.tech AS WG15_tech
FROM
AstroAnalysis AS wg14,
AstroAnalysis AS wg15,
SpectrumGroup AS spg14,
SpectrumGroup AS spg15
WHERE wg14.wg = 'WG14'
AND wg15.wg = 'WG15'
AND wg14.specGroupID = spg14.specGroupID
AND wg15.specGroupID = spg15.specGroupID
AND spg14.specID = spg15.specID
The details of the table defined by this view are available here.