watershed code field names

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

watershed code field names #119

Open smnorris opened 2 years ago

smnorris commented 2 years ago

wscode_ltree and localcode_ltree can be just wscode and localcode - there is no need to specify the type in the column names. Consider also dropping the source watershed code columns.

NewGraphEnvironment commented 1 year ago

wondering if this is related to error thrown on build

CREATE TABLE
psql:sql/tables/temp/fwa_stream_order_max.sql:19: ERROR:  column "wscode_ltree" does not exist
LINE 7: where wscode_ltree is not null
              ^
make: *** [Makefile:124: .make/fwa_stream_networks_sp] Error 3