params ▾ | timestamp | NPoints | Length | WKT | GeoJSON | poly | Image |
---|---|---|---|---|---|---|---|
0 | 2025-05-24 05:11:49.608497 | 57357 | 9.65218308490152 | WKT | GeoJSON | poly | image |
0.002000-0.001000-0.001000 | 2025-05-28 23:07:51.874834 | 4589 | 9.65688200197144 | WKT | GeoJSON | poly | image |
0.020000-0.005000-0.005000 | 2025-05-24 17:55:46.662606 | 1063 | 9.6934578453718 | WKT | GeoJSON | poly | image |
0.040000-0.005000-0.005000 | 2025-05-27 09:11:26.293294 | 791 | 9.73436310191889 | WKT | GeoJSON | poly | image |
X, Y, Z are parameters for the following postgis equation. The default values are chosen according to the size of the original geometry to give a slighty bigger geometry, without too many nodes.
Note that:ST_Union(ST_MakeValid(ST_SimplifyPreserveTopology(geom, 0.00001)), ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))
ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))
ST_Intersection(geom, ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))