Extract Data - Deleting Empty Feature Classes

Question

Hi,
When I use the "Extract Data" tool (Distributed Geodatabase toolbar) I get the data I want plus a heap of empty Feature Classes in the target Geodatabase.

Is there a tool that will look at my Geodatabase and delete these empty Feature Classes? I would prefer a tool that would automatically do this over a script, but any suggestions would be good at this stage.

Thanks!
Mick

BenLeslie1 · Answer

Can you explain why you need to convert the count into a string?

I'd been trying to make this work for a little while and that was my problem - hadn't converted count into string.

MichaelClarke · Answer

@ Heather, Thanks for your reply. I do use the 'Advanced' options to deselect any unwanted feature classes. The problem occurs when if the feature classes I deselect were in a feature dataset, I get an empty dataset (there is no way to deselect the dataset). Also if there were no features within the Area of Interest graphic, but I leave the feature class selected as I'm unsure of this, I get the empty feature dataset.
I agree this is the default behaviour, probably due to the tool being related to 'distributed' databases, users may create new features to upload and therefore need all the feature classes they've extracted. So the problem is more related to how I'm using the tool, not the tool itself.:) (I don't intend to upload the data I've extracted)

@ JSkinn3, Thanks for the script! I'll give it a try tomorrow and let you know how I go. I'm a noob at scripting/python so it could be interesting. Doing the training soon, hence the preference for a tool, but if one doesn't exist, it doesn't exist.

Many thanks!
-Mick

JakeSkinner · Answer

I believe Heather's solution is correct.  Here is a script that you can use to delete empty feature classes just in case:import arcpy
from arcpy import env

env.workspace = r"C:\Temp\Test.gdb"

listFCs = arcpy.ListFeatureClasses("*")

for fc in listFCs:
    count1 = str(arcpy.GetCount_management(fc))
    if count1 == "0":
        arcpy.Delete_management(fc)

You can easily turn this into a tool by changing 'env.workspace' to:

env.workspace = arcpy.GetParameterAsText(0)

Then import the script into ArcToolbox and set an input under the Parameters tab within the Properties.