params ▾ | timestamp | NPoints | Length | WKT | GeoJSON | poly | Image |
---|---|---|---|---|---|---|---|
0 | 2023-11-20 12:06:32.037282 | 75488 | 33.464307405637 | WKT | GeoJSON | poly | image |
0.000000-0.010000-0.010000 | 2023-11-20 12:06:42.627980 | 1592 | 33.4722721069246 | WKT | GeoJSON | poly | image |
0.010000-0.010000-0.010000 | 2023-11-22 05:33:41.784610 | 1600 | 33.4884338242325 | WKT | GeoJSON | poly | image |
0.080000-0.001000-0.001000 | 2023-11-26 10:31:39.764358 | 3811 | 33.6250326096496 | 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)))