search

NYCPlanning / db-developments

🏠 🏘️ 🏗️ Developments Database
https://nycplanning.github.io/db-developments
8 stars 2 forks source link

Drop _geo_devdb in dataloading step #562

Closed SashaWeinstein closed 2 years ago

SashaWeinstein commented 2 years ago

Small PR, one reviewer 🌎 Addresses issue #561

td928 commented 2 years ago

hey sorry late to this PR but seems like there is query to drop the table later in the same file. But it just didn't work with the IF EXISTS? is the correct approach here to drop that then the issue is fixed? @SashaWeinstein @mbh329

SashaWeinstein commented 2 years ago

Sorry I'm not sure I understand, is the fix just to change the code to DROP TABLE IF EXISTS _geo_devdb? And to take out the same code below? The drop needs to come before downloading geocode results as they share an index