topic How to delete the empty feature class from gdb or mdb arcgis 10.4.1 in Python Questions

How to delete the empty feature class from gdb or mdb arcgis 10.4.1

santhoshp — Mon, 03 Jul 2017 12:04:21 GMT

Dear Friends,

Please find the attached gdb. How to delete the empty feature class from gdb.

Thanks

Santhosh

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

DanPatterson_Retired — Mon, 03 Jul 2017 12:44:47 GMT

the Delete tool pretty well covers how to delete a featureclass... with a series of "can't do". You will have to elaborate why you can't delete one (ps, see the code example

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

AlexanderBrown5 — Sat, 11 Dec 2021 06:28:26 GMT

Santhosh,

You can manually right click on the tables in ArcCatalog and select "delete". You could also write a python script to loop through each feature class, and where total count = 0, run the tool that Dan suggested.

Something like:

import arcpy
from arcpy import env
env.workspace = 'D:/YourPathHere/Power.mdb'

data_sets = arcpy.ListDatasets()

for item in data_sets:
    fcList = arcpy.ListFeatureClasses('', '', item)
    for item in fcList:
        fcLength = arcpy.GetCount_management(item)
        if int(fcLength.getOutput(0)) == 0:
            arcpy.Delete_management(item)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

santhoshp — Tue, 04 Jul 2017 08:02:00 GMT

Thanks for reply but I am getting error.

Below the Snapshot .

My Path :E:\YourPathHere\Power.mdb.

Thanks

Santhosh

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

DanPatterson_Retired — Tue, 04 Jul 2017 08:40:10 GMT

YourPathHere was changed in your real script, wasn't it? and does it exist

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

JoshuaBixby — Wed, 05 Jul 2017 16:24:20 GMT

Do add to Dan's question, please post the specific code generating the error and the whole error message.

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

AlexanderBrown5 — Wed, 05 Jul 2017 19:16:56 GMT

Santhosh,

If you are running my snippet from above (looks like you are from your error message attached)...your syntax is incorrect based on improper spacing.

I copied my snippet directly into idle and did not have an issue, but it looks like something got out of alignment in your error.

Please make sure your indentation is correct:

10 Common Python Errors of Beginning ArcGIS Programmers |

2.1.7 Indentation

Make sure your Power.mdb is actually located here "E:\YourPathHere\Power.mdb." You could have updated this path to something else, I was literally saying "Your path on your computer to your access database here." You created a new path instead of updating the line within the code.

~Alex

Re: How to delete the empty feature class from gdb or mdb arcgis 10.4.1

santhoshp — Thu, 06 Jul 2017 12:00:12 GMT

Hi Alex,

Thank you so much for your help.

Santhosh