search

mattyschell / cscl-subaddress-matched

Creative Commons Zero v1.0 Universal
0 stars 0 forks source link

Move ng911 fields into view definition #8

Closed mattyschell closed 3 years ago

mattyschell commented 3 years ago

This repo outputs a file geodatabase from a fully formatted database view. Instead of populating subaddress_add with permanent suite values the case statement here

https://github.com/mattyschell/cscl-subaddress-matched/blob/main/src/sql/populate911fields.sql

should be moved to the view definition here:

https://github.com/mattyschell/cscl-subaddress-matched/blob/main/src/sql/setup.sql