params ▾ | timestamp | NPoints | Length | WKT | GeoJSON | poly | Image |
---|---|---|---|---|---|---|---|
0 | 2024-03-10 23:28:21.120006 | 122138 | 7.66544757586512 | WKT | GeoJSON | poly | image |
0.000000-0.005000-0.005000 | 2024-03-10 23:28:38.029346 | 1170 | 7.665319628039 | WKT | GeoJSON | poly | image |
0.030000-0.030000-0.030000 | 2024-04-15 14:01:37.274596 | 316 | 7.72259671354137 | WKT | GeoJSON | poly | image |
0.080000-0.001000-0.001000 | 2024-03-17 09:55:10.890340 | 1131 | 7.82611659764918 | WKT | GeoJSON | poly | image |
0.100000-0.005000-0.005000 | 2024-04-23 14:49:58.951353 | 399 | 7.86776969668025 | 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)))