List of available polygons for id = 1660242

params ▾	timestamp	NPoints	Length	WKT	GeoJSON	poly	Image
0	2023-07-05 06:57:14.142869	1945	1.71739079774728	WKT	GeoJSON	poly	image
0.005000-0.005000-0.005000	2023-11-15 19:28:02.291354	234	1.72896645427261	WKT	GeoJSON	poly	image
0.010000-0.005000-0.005000	2023-11-15 19:27:09.281578	200	1.74086903585537	WKT	GeoJSON	poly	image
0.010000-0.010000-0.010000	2023-11-15 19:27:16.432270	136	1.74195292703334	WKT	GeoJSON	poly	image
0.020000-0.005000-0.005000	2023-11-15 19:27:02.303896	169	1.76040478299736	WKT	GeoJSON	poly	image

Generate a simplified polygon

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:

X > 0 will give a polygon bigger than the original geometry, and guaranteed to contain it.
X = 0 will give a polygon similar to the original geometry.
X < 0 will give a polygon smaller than the original geometry, and guaranteed to be smaller.

SQL requests:

X > 0: ST_Union(ST_MakeValid(ST_SimplifyPreserveTopology(geom, 0.00001)), ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))
X = 0: ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))
X < 0: ST_Intersection(geom, ST_Buffer(ST_SimplifyPreserveTopology(ST_SnapToGrid(ST_Buffer(geom, X), Y), Z)))