topic Re: List feature classes in a geodatabase using Python in Python Questions

List feature classes in a geodatabase using Python

JoshThompson — Wed, 25 May 2011 19:43:00 GMT

I am attempting to generate a list of all the feature classes in a file geodatabase using the Python window in ArcCatalog. I want to list all features, by feature dataset, to deliver to the staff at my office. Is this even possible? I am running ArcInfo 10 and not well versed with Python. I have failed miserably in my feeble attempts to generate the list on my own. Any help is greatly appreciated.

Thanks,
Josh

Re: List feature classes in a geodatabase using Python

AnthonyFarndon — Sun, 12 Dec 2021 07:36:55 GMT

I think this is what you are asking for?

datasetList = arcpy.ListDatasets("*", "Feature")
for dataset in datasetList:
    print dataset
    fcList = arcpy.ListFeatureClasses("*","",dataset)
    for fc in fcList:
        print fc

Remember to set env workspace

Re: List feature classes in a geodatabase using Python

JoshThompson — Tue, 07 Jun 2011 20:33:52 GMT

Thanks for the quick response. I've been out of the office for a week, so my apologies for the delayed response. The script worked fine, so thanks for that. I do have one question, though. It generated a list in random order, not in alphabetical order as they are shown in the geodatabase. Do you know why this happens?

Thanks again for your help,
Josh

Re: List feature classes in a geodatabase using Python

ChrisFox3 — Sun, 12 Dec 2021 07:36:58 GMT

Hi Josh,

This is the order in which they are stored in the database, what you see in ArcCatalog has been sorted alphabetically to assist you in finding the proper feature class.

If you wish to display the list of feature classes alphabetically in Python just call the sort method on the list of feature classes

datasetList = arcpy.ListDatasets("*", "Feature")
for dataset in datasetList:
    print dataset
    fcList = arcpy.ListFeatureClasses("*","",dataset)
    fcList.sort()
    for fc in fcList:
        print fc

Re: List feature classes in a geodatabase using Python

JoshThompson — Wed, 08 Jun 2011 18:31:30 GMT

Okay, we are making progress. Thanks so much for your help. I now have a new problem: Within the list, some of the feature classes are not included. All the feature datasets are included, but randomly, the feature classes will be missing from the dataset. I am one tier below beginner when it comes to Python, so any help is greatly appreciated.

Thanks,
Josh

Re: List feature classes in a geodatabase using Python

ChrisFox3 — Wed, 08 Jun 2011 23:27:26 GMT

Josh,

Is it truly random or if you run it on the same feature dataset every time are the same feature classes printed or ormitted each time? Could you send an example of what is printed and what actually exists in the geodatabase? Initially I am guessing that for example you have a topology in the feature dataset and this is printed, which is expected. ListFeatureClasses() will not return topologies. There are other data types that will not be returned as well. So you should look closely at what data types are not actually being returned in python.

Re: List feature classes in a geodatabase using Python

curtvprice — Thu, 09 Jun 2011 13:49:29 GMT

I want to list all features, by feature dataset, to deliver to the staff at my office.

Since you're not well-versed with Python, you may want to look into ModelBuilder 10. I never used to suggest this, but have been very impressed with the new iterator functionality.

To generate a list of anything (even recursively in a folder tree) in model builder right-click, choose Iterators and what you want to list. Then double click it and enter the particulars (ie where you want to look), and then pipe the pathname output into the Collect Values tool and run it. This easily generates a list of with no coding; you could use Calculate Value to convert it to a string to paste into a text file or whatever.

Re: List feature classes in a geodatabase using Python

JoshThompson — Thu, 09 Jun 2011 14:53:00 GMT

Chris,

I do have some topologies included in the geodatabase, however, I do not want them to print, so that is actually a positive outcome. I am referring specifically to feature classes that are not being listed. I have included an excel file with the geodatabase contents compared to the outcome of the fcList, with some formatting to easily compare results. Thanks for the help.

Josh

Re: List feature classes in a geodatabase using Python

JoshThompson — Thu, 09 Jun 2011 14:54:57 GMT

Curtis,

Someone else actually mentioned this as a way to get familiar with Python. I think after this exercise, I will certainly try that. Thanks for your reply.

Josh

Re: List feature classes in a geodatabase using Python

ChrisFox3 — Fri, 10 Jun 2011 15:37:04 GMT

Josh,

From your spreadsheet it looks like anytime there is a feature class that shares the same name as the feature dataset it is in, that no feature classes are returned from listfeatureclasses(). I have attempted to test the same scenario with some of my data, but couldn't reproduce the issue.

Could you share your complete code? What kind of geodatabase are these feature classes stored in and do you know what version the geodabatase is?

Re: List feature classes in a geodatabase using Python

JoshThompson — Mon, 13 Jun 2011 13:29:28 GMT

Hey Chris,

I came to the same confusing conclusion. When the feature name contains the dataset name, it kicks it and all other features in that dataset out. Strange...but probably something in my code. The features are stored in a file geodatabase, v10 (sp2). Below is the code I am using:

import arcpy

arcpy.env.workspace = "D:\Lakeland_GIS\GDB\Lakeland\Lakeland.gdb"

datasetList = arcpy.ListDatasets("*", "Feature")
datasetList.sort()
for dataset in datasetList:
    print dataset
    fcList = arcpy.ListFeatureClasses("*","",dataset)
    fcList.sort()
    for fc in fcList:
        print fc

Thanks,
Josh

Re: List feature classes in a geodatabase using Python

ChrisFox3 — Tue, 14 Jun 2011 14:54:02 GMT

Hi Josh,

I think your code looks fine. Is there anything else in the Cemetary Feature Dataset other than the Cemetary Feature Class? Same with Churches? I think the issue is specific to your geodatabase. Would you be able to send me the GDB or if it is too large try pulling out some of the good and offending feature datasets into a new GDB to send?

Re: List feature classes in a geodatabase using Python

TiCrossman — Sat, 08 Oct 2011 02:40:01 GMT

Was there ever a resolution to this issue? I have code essentially identical to that in this thread, and I am now experiencing the same problem with ListFeatureClasses leaving out feature classes for particular feature datasets. I am working with a file geodatabase, v10.0 (no service packs--see note below). In my case I have one feature dataset that has one of ~30 feature classes whose name contains the name of the feature dataset. I get no feature classes from that dataset. The fGDB was just thrown at me to work on, and I don't know the provenence. I suspect, however, that it was exported from SDE.

Notably, there are other anomalies happening, too: (1) I get no feature classes from another dataset that has just two feature classes, neither of which contains the name of the feature dataset; and (2) In a couple of other datasets, most of the feature class names end with "_MT" or other "_XX" or "XX" (like "ZM") letter combination. In those cases the feature classes are listed, but the "_XX" (or "XX") suffix is deleted, leaving just the portion of the name to the left of the suffix. The only other thing of note is the lack of service packs on my system. I had SP2 installed, but that service pack introduces a bug (now reported as such by ESRI Support) that breaks a lot of my existing scripts. I had to uninstall SP2. Anyone have any further info on this problem. Chris? Thanks for the help.

Re: List feature classes in a geodatabase using Python

JoshThompson — Fri, 14 Oct 2011 19:39:36 GMT

I did confirm that if a feature class had the exact same name as the feature dataset, the features were left out of the list. It would list the feature dataset as it appeared, but no feature classes were shown. I had to either change the name of the dataset or the feature class for the script to work correctly.

Re: List feature classes in a geodatabase using Python

RobertBlischke — Wed, 12 Dec 2012 14:54:15 GMT

I just had the same issue. For my workspace I'm using a connection file string. I discovered that my connection file string had a hidden carriage return/line feed at the end. Once I removed the hidden characters, the feature classes started listing.

Re: List feature classes in a geodatabase using Python

MeleKoneya — Fri, 05 Apr 2013 16:36:28 GMT

I am using the IGeoProcessor in .NET and have seen the same behavior. I am using with ArcGIS 10 SP5. If a Feature Dataset contains a feature class with the same name, when I use IGeoProcessor.ListFeatureClasses(), None of the Feature Classes within the Feature Dataset are returned.

Was there any resolution to this issue?

Re: List feature classes in a geodatabase using Python

MatthewRantala — Wed, 02 Apr 2014 13:14:22 GMT

I just want to confirm that as of 10.2, this still occurs, at least using a postgresql geodatabase (10.2 ArcGIS, postgres 9.2). I was NOT able to re-create the problem using either a file or personal geodatabase.

Re: List feature classes in a geodatabase using Python

curtvprice — Wed, 30 Apr 2014 19:48:32 GMT

To generate a list of anything (even recursively in a folder tree) in model builder right-click, choose Iterators and what you want to list. Then double click it and enter the particulars (ie where you want to look), and then pipe the pathname output into the Collect Values tool and run it. This easily generates a list of with no coding; you could use Calculate Value to convert it to a string to paste into a text file or whatever.

I received a request today on how you would use Calculate Value to create the list.

The key is to to connect the dataset of the iterator into the Collect Values tool, then set the output of that as an output parameter, save and close your model. Make a new model and drop your first model into that one. When you run the model you can see the string using Calculate Value with the expression: r"%Collected values%" - which I think will show a ;-delimited string of paths. If you want to print them, one per row, you can use an expression like : chr(10) + chr(10).join(r"%Collected values%".split(";"))

See the 10.2 help article - scroll down to "Advanced Use of Model Iterators".
http://resources.arcgis.com/en/help/...0000007p000000

Re: List feature classes in a geodatabase using Python

AndresCastillo — Sun, 16 Aug 2020 19:49:41 GMT

relevant references:

How To: Print the list of feature classes for an Enterprise geodatabase

Python List Shapefiles

ListFeatureClasses—ArcGIS Pro | Documentation

arcpy - Listing all feature classes in File Geodatabase, including within feature datasets? - Geographic Information Sys…

os.walk | ArcPy Café

Walk—ArcGIS Pro | Documentation

arcpy - Listing Feature Classes of Multiple geodatabase in Multiple Folder? - Geographic Information Systems Stack Excha…

gist:4577289 · GitHub

arcpy - How to make a GIS inventory? - Geographic Information Systems Stack Exchange

arcpy - List all Feature datasets & feature classes from a single geodatabase into CSV - Geographic Information Systems …