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

standardize the spp upstr/dnstr columns in crossings and streams tables? #433

Open
smnorris opened this issue Dec 20, 2023 · 0 comments
Open

Comments

@smnorris
Copy link
Owner

smnorris commented Dec 20, 2023

  • source for crossings columns is bcfishobs.fiss_fish_obsrvtn_events (all species)
  • source for streams columns is bcfishpass.observations (all target species)

questions/todo:

  • why not list all species in the streams table, as in the crossings table?
  • calculate the crossings columns by inserting to lookup table as per streams for speed/simplicity rather than running slow updates

Note that both these sets of columns are separate from access models - they use bcfishpass.observations and filter the included species (and observation date) as appropriate for the given model (for removing natural barriers downstream of observations).

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

1 participant