smnorris / fwapg

PostgreSQL tools for working with British Columbia's Freshwater Atlas
https://smnorris.github.io/fwapg
MIT License
9 stars 5 forks source link

assessment watersheds -> streams lookup #150

Closed smnorris closed 10 months ago

smnorris commented 10 months ago

This lookup assumes all streams in a given assessment watershed will have the same watershed_group_code - is this important?

Streams in assessment watershed 13967 are now in both VICT and SANJ.

This is not an important data quirk - can watershed_group_code simply be removed from the lookup and the load script revised?

smnorris commented 10 months ago

Lookup adjusted and data inconsistency reported/fixed.