You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently being filtered to USABILITY_CODE IN (0, 1, 2, 6) within proc_catmat_2011.sql.
Perhaps as part of this we may want to write our own simpler SQL query that just gets all the catch and set data for all species and all usability codes, which would better match what we're doing over in surveyjoin and would make it much faster to get lots of species at once. I assume the time consuming part is the cross product to get zero-weight sets, but we can grab that once and join it on once, as we are in that other package.
Currently being filtered to
USABILITY_CODE IN (0, 1, 2, 6)
within proc_catmat_2011.sql.Perhaps as part of this we may want to write our own simpler SQL query that just gets all the catch and set data for all species and all usability codes, which would better match what we're doing over in surveyjoin and would make it much faster to get lots of species at once. I assume the time consuming part is the cross product to get zero-weight sets, but we can grab that once and join it on once, as we are in that other package.
@ecophilina
The text was updated successfully, but these errors were encountered: