search

pbs-assess / gfiphc

:fishing_pole_and_fish: An R package for data extraction and analysis of groundfish data from the IPHC Longline Survey in British Columbia
3 stars 0 forks source link

New query for Yelloweye Rebuilding plan project #4

Closed andrew-edwards closed 3 years ago

andrew-edwards commented 5 years ago

For hook competition adjustments (for external Yelloweye assessment), we need a new query that just returns the numbers per set of the targetted species, all non-targetted species, empty hooks and baited hooks.

Easiest may be to adapt get-iphc-hook-level.sql to get all non-species, and empty and baited hooks returned. I could then roll up to the set level in the same way as is currently done (and also do a first-20-hook version).

Could first wait until we figure out why the set-level counts (in database) differ from the rolled up ones. I'll discuss that with Norm.

andrew-edwards commented 5 years ago

May not be needed if I use the simpler way to account for hook competition. Can just query for the baited hooks and I think use that.

andrew-edwards commented 3 years ago

All done along the way.