search

NYCPlanning / labs-applicantmaps

5 stars 5 forks source link

Point to aliased views #582

Closed allthesignals closed 4 years ago

allthesignals commented 4 years ago

We learned in https://github.com/NYCPlanning/labs-applicantmaps/issues/579 that some of our queries are pointing to old versions of data tables.

I did a check and a few of the other queries are too:

/Users/wmattgardner/labs-applicantmaps/app/components/project-geometries/modes/lots.js:
   13: const plutoTable = 'mappluto_v18_1';

/Users/wmattgardner/labs-applicantmaps/app/utils/queries/proposed-commercial-overlays-query.js:
   26:       FROM planninglabs.commercial_overlays_v201809 co, buffer

/Users/wmattgardner/labs-applicantmaps/app/utils/queries/proposed-special-districts-query.js:
   26:       FROM planninglabs.special_purpose_districts_v201809 spd, buffer