params ▾ | timestamp | NPoints | Length | WKT | GeoJSON | poly | Image |
---|---|---|---|---|---|---|---|
0 | 2023-06-12 15:15:16.064306 | 99326 | 3.54340396712764 | WKT | GeoJSON | poly | image |
0.000000-0.000500-0.000500 | 2024-04-15 09:21:59.182088 | 7962 | 3.54351749678198 | WKT | GeoJSON | poly | image |
0.000000-0.003000-0.003000 | 2024-04-15 09:22:06.108893 | 1551 | 3.54436129648206 | WKT | GeoJSON | poly | image |
0.000000-0.006000-0.006000 | 2024-04-15 09:22:11.910613 | 775 | 3.5424703245052 | WKT | GeoJSON | poly | image |
0.000000-0.009000-0.009000 | 2024-04-15 09:22:17.819745 | 567 | 3.5467879835141 | WKT | GeoJSON | poly | image |
0.004000-0.001000-0.001000 | 2024-02-04 13:29:53.271037 | 2628 | 3.55178053939147 | WKT | GeoJSON | poly | image |
0.020000-0.005000-0.005000 | 2023-06-23 08:11:09.554196 | 512 | 3.58577746102571 | 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)))