NYCPlanning / db-cpdb

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

Issue with geometries coming from Facilities Database #114

Closed AmandaDoyle closed 2 years ago

AmandaDoyle commented 2 years ago

156 records in CPDB have a point geometry from the Facilities Database, but the point is not in or near NYC. See screenshots that explain diagnosis. Screen Shot 2022-06-08 at 11 44 37 AM

Screen Shot 2022-06-08 at 11 45 23 AM No points are in NYC

Screen Shot 2022-06-08 at 11 45 49 AM And the Lat and Long values are incorrect.

Perhaps the projection of the Facilities Database needs to be updated when loading into data libraries? Or?

td928 commented 2 years ago

Issue closed because a new source crs is assigned and now facilities are corrected in CPDB confirmed by looking at pts output in the most recent batch.