search

pbs-assess / gfdata

:floppy_disk: An R package for data extraction of BC groundfish data
https://pbs-assess.github.io/gfdata/
1 stars 0 forks source link

Remove recreational samples from commercial samples SQL #16

Open seananderson opened 9 months ago

seananderson commented 9 months ago

From Malcolm:

WHERE SM.FE_PARENT_EVENT_ID IS NULL AND SM.TRIP_SUB_TYPE_CODE NOT IN (2, 3) AND --*************************** TRIP_SUB_TYPE_CODE of 11 is RECREATIONAL and would be included