Processing Fish Metadata
tblfgprocessingstatus - This table contains data for tracking the status of recovered and/or popup tag data. Typically joins will be made to the fgdkey and toppid fields. The most common fields used to filter queries are med_fish, gom_fish, breedingstatus, qc_track, geolocated, ssm_complete, date_last_depth, date_last_etemp, date_last_itemp, date_last_light, no_pdt, no_tad, and no_tat.
Example query:
SELECT d.fgsdkey as eventid,d.tagcode,d.taggingdate,d.seriesname,r.actpopdate,p.ssm_complete
FROM tblfgsatdeployments as d
INNER JOIN tblfgsatrecovery as r ON d.fgsdkey = r.fgsdkey
INNER JOIN tblfgprocessingstatus as p ON d.fgsdkey = p.fgdkey
WHERE d.seriesname ilike '%newp%'
ORDER BY 1;