search

NYCPlanning / db-cpdb

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

agency_validated_geoms_summary_table geom does not exists #121

Open td928 opened 2 years ago

td928 commented 2 years ago

spotted as running 04_analysis and not sure how this comes about

agency_validated_geoms_summary_table line 12 but the AND a.geom IS NOT NULL throws an error this column does not exist

fvankrieken commented 1 year ago

My best guess is a python/pandas/sqlalchemy thing - I noticed in a different spot in the build the same error (ish) testing locally, and it was due to creating a table using DataFrame.tosql on a dataframe with no rows. The table gets created with the right name, but depending on how the frame was created it might not have column information, leading to an empty sql table with no columns.

I don't see this on the latest build