search

NYCPlanning / deprecated-labs-zap-api

Deprecated version of the ZAP API, see https://github.com/NYCPlanning/labs-zap-api
Other
5 stars 3 forks source link

467: Updates the materialized view query to add bbls, keywords; adds bbls, keywords to text query #116

Closed ghost closed 5 years ago

ghost commented 5 years ago

NOTE: do not promote to master until materialized view has been recreated

for no downtime:

BEGIN;
DROP MATERIALIZED VIEW normalized_projects
CREATE MATERIALIZED VIEW normalized_projects AS ...
COMMIT;

additionally, this removes the need to dedupe values in the csv download, so don't forget to clean that up :) (this will be cleaned up with PR #114 )

Closed #467