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

508: update migrations for indices, geometry transforms, materialized view #121

Closed trbmcginnis closed 5 years ago

trbmcginnis commented 5 years ago

Add new migrations:

  1. add-geometry-indices: creates geographic indices on polygons and centroid columns to be used in ST_DWithin for radiusDistanceQuery

  2. add-transformed-geometry-columns: add two columns centroid_3857 and polygons 3857

    • these new columns will be updated every time data is added or changed in centroid and polygons columns with function ST_Transform to 3857

  3. create-materialized-view: create materialized view

  4. add-projectid-index: create index on dcp_name column in normalized_projects