search

smnorris / bcfishpass

Model and monitor aquatic habitat connectivity in BC. Tools to plan and prioritize the assessment and remediation of barriers.
https://smnorris.github.io/bcfishpass
Apache License 2.0
8 stars 13 forks source link

crossings_vw - include admin columns #370

Open smnorris opened 1 year ago

smnorris commented 1 year ago

Create materialized view of crossing/admin area overlay and include results in crossings_vw

https://github.com/smnorris/bcfishpass/blob/main/reports/crossings/sql/crossings_admin.sql

smnorris commented 6 months ago

Query is now here: https://github.com/smnorris/bcfishpass/blob/main/db/views/02_crossings_admin.sql Last step is to add script to load the various datasets required.

smnorris commented 5 months ago

Punting this to v0.4.0 or greater - the admin data is now loaded and the materialized view is there if needed but it takes >30min to run (not sure what total time would be). Query needs to be optimized before including.