如何清除空间数据库中的自相交多边形? [英] How do I clean up self-intersecting polygons in a spatial database?

问题描述

我有一些包含自相交多边形的空间数据(MapInfo文件).这些会在我的处理过程中引起问题，特别是我无法在PostGIS中生成几何并集.有没有简单的方法来解决此问题?如果有必要，我可以处理多面体.

I have some spatial data (MapInfo files) that contains self-intersecting polygons. These cause problems in my processing, in particular I can't generate geometric unions in PostGIS. Is there an easy way to resolve the issue? I can deal with multi-polygons if that should be necessary.

推荐答案

我自己弄清楚了:st_buffer(wkb_geometry,0)至少在我的示例数据上也能奏效.

I figured it out myself: an st_buffer(wkb_geometry,0) does the trick, at least on my sample data.

这篇关于如何清除空间数据库中的自相交多边形?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！