[EFOSC SOFI Spectrum Counts for ESO Phase III] #phase_iii #efosc #sofi #spectrum #followup

README.md

How to Scrape the Data for the EFOSC SOFI Spectra for followed objects for ESO Phase III Release Description.

This will get you something like this:

Repeat this for SOFI spectra and export into an excel sheet and sort for the release description

phaseIII_followup_spectrum_count.sql

-- Here is the SQL query to grab the followup objects:

SELECT 
    p.transientBucketId, s.masterName
FROM
    pesstoObjects p,
    transientBucketSummaries s
WHERE
    p.marshallWorkflowLocation LIKE '%follow%'
        AND p.marshallWorkflowLocation NOT LIKE 'revi%'
        AND p.transientBucketId = s.transientBucketId
ORDER BY s.transientBucketId;
    
 --- And once you have the `transientBucketId`s from the query above:

SELECT 
    object as "Target", concat(COUNT(object), "x", DISPELEM) as "Number of Spectra"
FROM
    efosc_spectra
WHERE
    data_rel = 'ssdr2'
        AND currentFilename LIKE '%_sb.fits'
        AND transientBucketId IN (85 , 407,
        1472,
        1475,
         ...
        394311)
GROUP BY object , dispelem;