List Feature Classes in Database

JustinFuto1 — Tue, 22 Aug 2017 19:11:08 GMT

I'm trying to create a list of features classes inside of our LGIM database for handouts to staff. I can successfully print out a list of all of the feature classes using the code below, but I want to only list feature classes that have content in them. Does anyone have a script they could share? Or has anyone done this before? If it helps, the data I'm trying to access is in SDE.

Code:

import arcpy

import os

arcpy.env.workspace = "c:/base/gdb.gdb"

datasets = arcpy.ListDatasets(feature_type='feature')

datasets = [''] + datasets if datasets is not None else []

for ds in datasets:

for fc in arcpy.ListFeatureClasses(feature_dataset=ds😞

path = os.path.join(arcpy.env.workspace, ds, fc)

print(path)

Re: List Feature Classes in Database

MicahBabinski — Sat, 11 Dec 2021 23:39:42 GMT

Heya Justin,

Check out the code example for the Data Access Walk function:

Walk—Help | ArcGIS for Desktop

It will let you quickly list all your feature classes without needing separate code to peek in each feature dataset. Once you've got a nice list of all feature classes, you can identify which ones are populated with at least one feature using Get Count—Data Management toolbox | ArcGIS Desktop. Note with Get Count that you need to access the result as an integer in your script. So use something like:

for fc in fcs:
    if int(arcpy.GetCount_management(fc).getOutput(0)) > 0:
        print(fc)‍‍‍

Happy listing!

Micah

topic Re: List Feature Classes in Database in Python Questions

List Feature Classes in Database

Re: List Feature Classes in Database