topic Re: Feature count in Geodatabase Questions

Feature count

eyadghatasheh — Wed, 08 Nov 2017 06:22:02 GMT

I have a file geodatabase which have around 23 datasets. under each data set there are a huge number of feature classes. I need to count features inside those feature classes.

is there any automated way to do this? get count tool is a headache in my case.

Regards

Re: Feature count

shan_sarkar — Wed, 08 Nov 2017 11:25:23 GMT

Eyad,

Try using Get Count—Data Management toolbox | ArcGIS Desktop

I hope this helps!

~Shan

Re: Feature count

eyadghatasheh — Wed, 08 Nov 2017 11:43:08 GMT

Shantona

Get count is not helpful in this case as I have batch it and drag hundreds of layers in the wizard. I am doing this daily and its not helpful anymore.

eyad.

Re: Feature count

MitchHolley1 — Sun, 12 Dec 2021 10:04:00 GMT

You can use Python for this. I am going to tag Python here for visibility. I've manipulated a code snippet found on StackExchange here to solve your problem. The below code should do the job.

import arcpy
import os

db = r'path_to_database'

arcpy.env.workspace = db

for ds in arcpy.ListDatasets():
    for fc in arcpy.ListFeatureClasses('','',ds):
        fc_path = os.path.join(db, fc)
        fc_count = arcpy.GetCount_management(fc_path)
        print "{0} : {1} rows".format(fc, fc_count)‍‍‍‍‍‍‍‍‍‍‍‍

Re: Feature count

JoshuaBixby — Sun, 12 Dec 2021 10:04:03 GMT

The ArcPy Data Access Walk function was created for such a situation:

fgdb = # path of file geodatabase

for root, fds, fcs in arcpy.da.Walk(fgdb, datatype="FeatureClass"):
    for fc in fcs:
        fc = os.path.join(root, fc)
        print fc[len(fgdb)+1:], arcpy.GetCount_management(fc)
‍‍‍‍‍‍

Re: Feature count

eyadghatasheh — Thu, 09 Nov 2017 07:00:22 GMT

Mitch

you are amazing. can I do the same to count features of feature classess in a specific dataset???

Re: Feature count

JayantaPoddar — Thu, 09 Nov 2017 08:42:13 GMT

You can just add the Dataset Name inside arcpy.ListDatasets() function.

e.g. Following would be Line No. 8 in Mitch's code

for ds in arcpy.ListDatasets('Dataset1'):‍

Re: Feature count

eyadghatasheh — Thu, 09 Nov 2017 11:30:00 GMT

Jayanta

I ran the script which worked fine; but it doesn't follow the same sequence of FCs in the dataset as shown in the attached image. is there any way to get them in the same sequence and is there a way to export the result to excel?

Regards

Re: Feature count

MitchHolley1 — Sun, 12 Dec 2021 10:04:06 GMT

I use the Python Excel module openpyxl. Please download this if it's not currently installed. The below code should work if the module is installed correctly. Please create an empty .xlsx file and set the path to the variable in line 26.

import arcpy
import os
from openpyxl import Workbook

db = r'path_to_geodatabase_.gdb'

arcpy.env.workspace = db

#wb stuff
wb = Workbook()
ws = wb.active
ws['A1'] = 'FeatureClass'
ws['B1'] = 'Count'

count = 2
for ds in arcpy.ListDatasets():
    for fc in sorted(arcpy.ListFeatureClasses('','',ds)):
        fc_path = os.path.join(db, fc)
        fc_count = str(arcpy.GetCount_management(fc_path))
        print "{0} : {1} rows".format(fc, fc_count)
        ws['A{0}'.format(count)] = fc
        ws['B{0}'.format(count)] = fc_count
        count += 1

        
output = 'path_to_output_Excel_.xlsx'
wb.save(output)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Feature count

MichelleJohnson — Fri, 10 Nov 2017 00:03:46 GMT

If you have the ArcGIS Data Reviewer extension, there is a tool that will provide feature counts for all layers in your map document and you can export that to a CSV file. The Total Feature Count tool.

Re: Feature count

DanPatterson_Retired — Sun, 12 Dec 2021 10:04:08 GMT

Instead of using the print line... why not add the results to a list, collect all the information, then sort the list at the end.

Add this to Mitch's code

result = []  # Mitch's line 7 ie the blank line

# replace this

print "{0} : {1} rows".format(fc, fc_count)

# with

result.append("{0} : {1} rows\n".format(fc, fc_count)) 

#  And at the very end add this line

result.sort()
result_txt = "\n".join([i for i in result])
print(result_txt)

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

Re: Feature count

eyadghatasheh — Sun, 12 Nov 2017 12:12:11 GMT

Thanks for the input, but this will work inside ArcMap which need to add the data to the TOC. the result is also doesn't follow the sequence.

Regards

Re: Feature count

GeorgeHouck — Mon, 13 Nov 2017 19:45:27 GMT

This may be oversimplifying things, but in Layout Mode you can turn on Feature Count and get the count quickly. It will count any feature you put in the legend. I use it from time to time for customer counts against billing spreadsheets.

Re: Feature count

eyadghatasheh — Tue, 14 Nov 2017 10:21:51 GMT

this is good if you have a limited number of FCs and subtypes.

Re: Feature count

GeorgeHouck — Tue, 14 Nov 2017 15:10:49 GMT

Yes, indeed, but when the boss comes asking it is quick.

Get Outlook for Android<https://aka.ms/ghei36>