Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ability to get survey set data from non-shrunk grid #11

Open
seananderson opened this issue May 4, 2023 · 0 comments
Open

Add ability to get survey set data from non-shrunk grid #11

seananderson opened this issue May 4, 2023 · 0 comments
Assignees

Comments

@seananderson
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants