NYCPlanning / db-cpdb

Capital Projects Database
https://nycplanning.github.io/db-cpdb
0 stars 0 forks source link

add new geospatial check file #120

Closed Oysters1874 closed 2 years ago

Oysters1874 commented 2 years ago

One question regarding this new change. For the first bullet point of geospatial check, we want to see whether all CPDB projects are within the combined geometry of NYC borough boundaries water included. I am wondering whether we can directly put the sql file of constructing this table into our current repo, as the borough boundaries are unlikely to change frequently (based on my intuition), or should we always fetch the data from opendata or any other place.

Oysters1874 commented 2 years ago

I have changed the code to import the borough boundaries from data library and deleted the part for admin boundary type check.