How to delete the empty dataset from gdb

santhoshp — Sat, 31 Mar 2018 10:38:30 GMT

Hi Dear,

Attached gdb here.How to delete the empty dataset from gdb in this gdb data available in HVAC, Fire alarm, Audiovisual, Fire Protection dataset rest of datasets empty for information any python code available plz help.

Thanks

Santhosh

Re: How to delete the empty dataset from gdb

DanPatterson_Retired — Sat, 31 Mar 2018 10:50:58 GMT

Not sure what you mean by wanting 'arcpy'.

Through arcpy, you implement the code snippet to match your case using Delete_management

Re: How to delete the empty dataset from gdb

XanderBakker — Fri, 10 Dec 2021 21:28:32 GMT

To show you how you can delete empty featureclasses, feature datasets and tables, see the code below:

def main():
    import arcpy
    import os

    fgdb = r'C:\GeoNet\DeleteEmpty\SSUC_FGDB_V3.gdb'

    # list feature datasets
    arcpy.env.workspace = fgdb
    fdss = arcpy.ListDatasets()
    fdss.append('')

    # loop through feature datasets to delete empty ones
    print("Delete empty featureclasses")
    for fds in fdss:
        print("Processing FDS: {}".format(fds))
        fcs = arcpy.ListFeatureClasses('*', None, fds)
        # loop through featureclasses in feature dataset
        for fc_name in fcs:
            fc = os.path.join(fgdb, fds, fc_name)
            count = GetCount(fc)
            if count == 0:
                # if fc is empty, delete it
                print(" - Deleting: {}".format(fc_name))
                arcpy.Delete_management(fc)
            else:
                print(" - Skip: {}".format(fc_name))

    # delete empty feature datasets
    print("Delete empty feature datasets")
    fdss = arcpy.ListDatasets()
    for fds in fdss:
        print("Processing FDS: {}".format(fds))
        fcs = arcpy.ListFeatureClasses('*', None, fds)
        if len(fcs) == 0:
            print(" - Delete FDS {}".format(fds))
            arcpy.Delete_management(fds)
        else:
            print(" - Keep FDS {}".format(fds))

    # delete empty tables
    print("Delete empty tables")
    tbls = arcpy.ListTables()
    for tbl_name in tbls:
        tbl = os.path.join(fgdb, tbl_name)
        count = GetCount(tbl)
        if count == 0:
            # if tbl is empty, delete it
            print(" - Deleting: {}".format(tbl_name))
            arcpy.Delete_management(tbl)
        else:
            print(" - Skip: {}".format(tbl_name))


def GetCount(fc):
    return int(arcpy.GetCount_management(fc).getOutput(0))

if __name__ == '__main__':
    main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to delete the empty dataset from gdb

santhoshp — Mon, 02 Apr 2018 11:30:18 GMT

Xander Bakker ,

Thank you So much .

Thanks

Santhosh

Re: How to delete the empty dataset from gdb

XanderBakker — Mon, 02 Apr 2018 11:40:54 GMT

You're welcome, I'm glad it worked.

topic Re: How to delete the empty dataset from gdb in Python Questions

How to delete the empty dataset from gdb

Re: How to delete the empty dataset from gdb

Re: How to delete the empty dataset from gdb

Re: How to delete the empty dataset from gdb

Re: How to delete the empty dataset from gdb