[check for spectra where the coordinates in the FITS header do not match the marshall coordinates] #coordinate #phase_iii #spectrum

spectra-coordinate-marshall-match-check.sql

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;