topic Re: how to delete multiple mdb or gdb empty feature class. in Python Questions

how to delete multiple mdb or gdb empty feature class.

santhoshp — Tue, 03 Apr 2018 13:36:05 GMT

Dear Friends,

Kindly find the attached multiple mdb's. how to delete multiple mdb or gdb empty features class.any code available please help me.

Thanks

Santhosh

Re: how to delete multiple mdb or gdb empty feature class.

JamesCrandall — Sat, 11 Dec 2021 15:22:38 GMT

http://pro.arcgis.com/en/pro-app/arcpy/functions/listfeatureclasses.htm

arcpy.env.workspace = <workspace>
fcs = arcpy.ListFeatureClasses('*')
for fc in fcs:
    test = int(arcpy.GetCount_management(fc).getOutput(0))
    print 'Feature Count: {}'.format(test)
    if test > 0:
        print 'Deleting Feature Class: {}'.format(fc)
        arcpy.Delete_management(fc)‍‍‍‍‍‍‍‍

Re: how to delete multiple mdb or gdb empty feature class.

MitchHolley1 — Sat, 11 Dec 2021 15:22:40 GMT

To add onto the concepts covered by @James, the following will take an input directory and loop over the gdbs and FCs for each one.

import arcpy
import os

inputDir = r'path\to\directory\that\houses\geodatabases'
ext = ['.mdb','.gdb']
gdbs = [x for x in os.listdir(inputDir) if x[-4:] in ext]

for g in gdbs:
    fullpath = os.path.join(inputDir, g)
    arcpy.env.workspace = fullpath
    for fc in arcpy.ListFeatureClasses():
        rowCount = arcpy.GetCount_management(fc)[0]
        if rowCount == '0':
            print "Deleting empty FC: {0}".format(os.path.join(g,fc))
            arcpy.Delete_management(os.path.join(fullpath,fc))
        else:
            print "{0} contains {1} records".format(os.path.join(g,fc), rowCount)

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: how to delete multiple mdb or gdb empty feature class.

DanPatterson_Retired — Tue, 03 Apr 2018 15:33:44 GMT

Did you forget about this one?

https://community.esri.com/thread/197602-how-to-delete-the-empty-feature-class-from-gdb-or-mdb-arcgis-1041

Re: how to delete multiple mdb or gdb empty feature class.

santhoshp — Wed, 04 Apr 2018 11:06:45 GMT

Hi Dear,

attached below snapshot can you give the solution for attached image.Delete multiple mdb empty feature class one time all mdb.

Thanks

Santhosh

Re: how to delete multiple mdb or gdb empty feature class.

RandyBurton — Wed, 04 Apr 2018 17:03:03 GMT

You are using filename in the listing of extensions. Just use the extension:

ext = ['.mdb','.gdb']‍

If the file ends in either of these extensions, then the filename will be found. Also, you need to set the inputDir to the correct value.

Re: how to delete multiple mdb or gdb empty feature class.

MitchHolley1 — Wed, 04 Apr 2018 20:10:18 GMT

Change the inputDir path to the directory that houses your geodatabases...