NYCPlanning / db-cpdb

Capital Projects Database

https://nycplanning.github.io/db-cpdb

0 stars 0 forks source link

Archive cpdb_projects and cpdb_dcpattributes #76

Closed mgraber closed 3 years ago

mgraber commented 3 years ago

74

Archive intermediate tables so that we can debug missing geoms (since geoms are missing, these records don't end up in cpdb_dcpattributes_pts or cpdb_dcpattributes_poly).

SPTKL commented 3 years ago

https://github.com/NYCPlanning/db-cpdb/commit/87d710f36a0f8d5ce36786e6ce9f58e2f34e47ff to make things easier, we will just dump all tables, this actually makes a lot more sense. Also there are ways to change the default schema in postgres from public to cpdb so that all the sql queries would still work, without having to prepend cpdb as schema name