Tuna Research and Conservation Center

tblfgsatdeployments - Typically joins will be made to the fgsdkey, toppid or ptt fields. Important fields used as query filters are project, seriesname, successful, taggingdate, tagmodel, tagtype and releasetype.

tblpatprogramming - This table contains programming information for early generation (PAT1 thru PAT5) PAT tags. Typically joins will be made to the fgsdkey field.

tblfgmk10programming - This table contains programming information for MK10 and later generations of PAT tags (including those manufactured by Microwave Telemetry and Lotek). Typically joins will be made to the fgsdkey field.

tblfgsatrecovery - Typically joins will be made to the fgsdkey or toppid fields. Important fields are actpopdate, rdate, lab_recdate, tagrecovered, fish_recaptured, rdateestimated, and recpositionestimated.

Example query:
SELECT d.fgsdkey as eventid,d.tagcode,d.taggingdate,d.seriesname,pr.depth_bins,r.actpopdate
FROM tblfgsatdeployments as d
INNER JOIN tblfgmk10programming as pr ON d.fgsdkey = pr.fgsdkey
INNER JOIN tblfgsatrecovery as r ON d.fgsdkey = r.fgsdkey
WHERE d.seriesname ilike '%newp%'
ORDER BY 1;