Clean polygon from ST_Difference problem

المشرف العام

Administrator
طاقم الإدارة
I'm trying to make union then difference between the same polygons using this code: ST_Simplify(ST_Difference(ST_Simplify(ST_MakePolygon(ST_ExteriorRing(ST_UNION(parcelles.shape_prcelle, d_poly.geom))), 0.001), d_poly.geom), 0.001)

i've added some simplify to remove any very small errors in geometry.

but the result is not always good, the result polygon gets extra vertex, this vertex is bound only to one other vertex in the polygon so there's no area between the 2 vertices, is there any idea about how to clean this error or any solution for this problem.





أكثر...
 
أعلى