[check for spectra where the coordinates in the FITS header do not match the marshall coordinates] #coordinate #phase_iii #spectrum
SELECT
e.currentFilename,
a.object,
a.ra,
a.decl,
e.ra,
e.decl,
raDeg,
decDeg,
e.transientBucketId,
e.lock_row,
e.isInTransientBucket
FROM
efosc_spectra e,
transientBucketSummaries t,
(SELECT
currentFilename, ra, decl, object
FROM
efosc_spectra) a
WHERE
t.transientBucketId = e.transientBucketId
AND e.arcfile = a.currentFilename
AND t.raDeg != e.ra
AND e.data_rel = 'SSDR3'
order by e.ra;