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

add max order of blue line to streams table #122

Closed smnorris closed 2 years ago

smnorris commented 2 years ago

Having the max stream order of a given blue_line_key right in the streams table makes for easy filtering mapping at variable scales.

While I'm at it - might as well add stream_order_parent to the streams table rather than using the lookup.