params ▾ | timestamp | NPoints | Length | WKT | GeoJSON | poly | Image |
---|---|---|---|---|---|---|---|
0 | 2023-08-30 07:59:07.998221 | 17244 | 0.323697172760668 | WKT | GeoJSON | poly | image |
0.001000-0.001000-0.001000 | 2023-09-18 01:11:33.816475 | 356 | 0.325379778105524 | WKT | GeoJSON | poly | image |
0.004000-0.001000-0.001000 | 2023-11-01 05:28:02.004846 | 240 | 0.331846349987459 | 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)))