ERROR: lwgeom_difference: GEOS Error: TopologyException: Input geom 0 is invalid: Too few points in

大白菜炒鸡蛋

于 2022-04-12 16:20:15 发布

阅读量1.7k

点赞数

文章标签： postgis

本文链接：https://blog.youkuaiyun.com/qq_27808209/article/details/124127226

版权

本文探讨了在PostGIS中使用ST_Difference函数时遇到的错误，重点是TopologyException：输入几何对象在120.125613附近存在问题。提供了针对缓冲区操作和解决方案的案例，帮助开发者理解并修复这类几何错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ERROR:  lwgeom_difference: GEOS Error: TopologyException: Input geom 0 is invalid: Too few points in geometry component at or near point 120.125613752384 31.665662179977399 at 120.125613752384

select ST_Difference(
    (
        select geom from table where id=1  -- sqlA
    ),
    (
        select geom from table where id=2  -- sqlB
    )
) as boundar

select ST_Difference(
    (
        select ST_buffer(geom, -0.00) from table where id=1  -- sqlA
    ),
    (
        select ST_buffer(geom, -0.00) from table where id=2  -- sqlB
    )
) as boundar