Loading

arcgis删除重复图斑

arcgis 通过过滤条件删除重复数据,仅保留一条 (对于 SDE 或个人地理数据库内的要素类有效)
或者直接使用delete identical工具。

[FIELD_NAME] In (
    SELECT
        [FIELD_NAME]
    FROM
        [TABLE_NAME]
    GROUP BY
        [FIELD_NAME]
    HAVING
        Count(*) > 1  
)
and [OID_FIELD_NAME] NOT In (
    SELECT
        MIN([OID_FIELD_NAME])
    FROM
        [TABLE_NAME]
    GROUP BY
        [FIELD_NAME]
    HAVING
        COUNT(*) > 1
)

参考

地址

posted @ 2025-03-12 22:38  一起滚月球  阅读(187)  评论(0)    收藏  举报