ArcGIS删除SDE存储所有对象但保留Schema

最新推荐文章于 2024-10-22 10:11:28 发布

原创最新推荐文章于 2024-10-22 10:11:28 发布 · 4k 阅读

0 ·

CC 4.0 BY-SA版权

Geodatabase 同时被 2 个专栏收录

59 篇文章

订阅专栏

Python

12 篇文章

订阅专栏

本文介绍了如何使用Python脚本批量清空ArcSDE地理数据库中的数据，包括要素类、表等对象，同时保留其结构。并讨论了版本控制的影响及替代方案。

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

其实该文章的主旨就是，有许多情况，需要对ArcSDE库里面所有的对象（要素类、表）的数据进行清空，但是并不删除该对象，也就是说相关的结构还是保留着。

1：使用Python脚本来实现

大家都知道，ArcToolbox提供了delete features这个GP工具，那么就使用Python脚本来使用该工具以达到相关目的。

首先，修改以下环境变量

logWorkspace = "C:/Temp"
workspace = "C:/connections/LOCATOR_CONN/DATAOWNER.sde"
dLogName = "Log_dataset_del.txt"
fLogName = "Log_fc_del.txt"
tLogName = "Log_table_del.txt"
schema = "sde.DATAOWNER"

schema=DATAOWNER 大小写是敏感的，不同数据库的写法不一
• Oracle: DATAOWNER
• SQL Server: db_name.DATAOWNER
• PostgreSQL: db_name.DATAOWNER

import arcpy, os, string



def DelDatasets(logWorkspace,dLogName,workspace,schema):

    logfile = open(os.path.join(logWorkspace, dLogName), 'w')

    arcpy.env.workspace = workspace

    datasetList = arcpy.ListDatasets()

    for dataset in datasetList:

        if dataset.startswith(schema):
            
            arcpy.Delete_management(dataset)

            print ("Deleted Feature dataset {0}".format(dataset))

            logfile.write("Deleted Feature dataset {0}".format(dataset))

            logfile.write("\n")

    logfile.close()

    del logfile, datasetList
    

def DelFeatureClasses(logWorkspace,fLogName,workspace,schema):

    logfile = open(os.path.join(logWorkspace, fLogName), 'w')

    arcpy.env.workspace = workspace

    fcList = arcpy.ListFeatureClasses()

    for fc in fcList:

        if fc.startswith(schema):
           
            arcpy.Delete_management(fc)

            print ("Deleted feature class {0}".format(fc))

            logfile.write("Deleted feature class {0}".format(fc))

            logfile.write("\n")

    logfile.close()

    del logfile, fcList


def DelTables(logWorkspace,tLogName,workspace,schema):

    logfile = open(os.path.join(logWorkspace, tLogName), 'w')

    arcpy.env.workspace = workspace

    tableList = arcpy.ListTables()

    for table in tableList:

        if table.startswith(schema):           

            arcpy.Delete_management(table)

            print ("Deleted table {0}".format(table))

            logfile.write("Deleted table {0}".format(table))

            logfile.write("\n")

    logfile.close()

    del logfile, tableList


if __name__ == "__main__":
  

    logWorkspace = "C:/Temp"

    workspace = "C:/connections/LOCATOR_CONN/DATAOWNER.sde"

    dLogName = "Log_dataset_del.txt"

    fLogName = "Log_fc_del.txt"

    tLogName = "Log_table_del.txt"

    schema = "sde.DATAOWNER"

    DelDatasets(logWorkspace,dLogName,workspace,schema)

    DelFeatureClasses(logWorkspace,fLogName,workspace,schema)

    DelTables(logWorkspace,tLogName,workspace,schema)

通过上面的例子我们也可以延伸;

比如，批量删除按照某个属性过滤条件查询的功能。