UNDP-Data / geohub

GeoHub Frontend Application
https://geohub.data.undp.org
BSD 3-Clause "New" or "Revised" License
42 stars 6 forks source link

optimize polygon simplification per zoom level #3273

Open iferencik opened 6 months ago

iferencik commented 6 months ago

Feature Description

Currently dynamic vector layers in Geohub prefetch the admin geometries from simplified down tables for specific intervals of zoom level in order to reduce the computation time. However the output geometries appear to have gaps at loww zoom lelvels

image

This needs to be improbed but without affecting the computation times

Feature Implementation

No response

Feature Alternatives

No response

Feature Impact

No response

Feature Rationale

No response

Feature Considerations

No response

Feature Requirements

No response

┆Issue is synchronized with this Wrike task by Unito

JinIgarashi commented 6 months ago

I assume we need to set more precise tolerance value to simplify polygons based on zoom level here

https://github.com/UNDP-Data/pgsql/blob/6bcd18603622d3a00c1e14238e28328b07b6624c/src/geohubsql/sql/plpgsql/utils.sql#L298-L332