nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How we get Feature count of 2 GDB(Include dataset and feature class) in CSV format.

Rakesh_Kumar_GIS

How we get Feature count of 2 GDB(Include dataset and feature class) in CSV format in Model builder or script tool.

In CSV format GDB can differentiate with sheets and every sheet have count of respective feature classes.

Find more posts tagged with

Accepted answers

curtvprice

This can't be done in ModelBuilder tools, but you can use the Calculate Value tool like this in ModelBuilder.

Expression: proc(r"C:\users\me\my.gdb", r"C:\users\me\my.csv")

Code Block:

def get_gdb_feature_count(gdb_path):
    # set workspace to gdb
    prev_ws = arcpy.env.workspace
    arcpy.env.workspace = gdb_path
    # list all feature classes and tables in workspace
    fcs_and_tbls = arcpy.ListFeatureClasses() + arcpy.ListTables()
    # GetCount() on all of these
    counts = [int(arcpy.management.GetCount(ft)[0]) for ft in fcs_and_tbls]
    # revert workspace
    arcpy.env.workspace = prev_ws
    # return [ ["TableName", count] ]
    return zip(fcs_and_tbls, counts)

def proc(gdb, csv_path):
    result = get_gdb_feature_count(gdb)
    with open(csv_path, "w") as f:
        f.write("Name,Count\n")
        for r in result:
            f.write(f"{r[0]},{r[1]}\n")

curtvprice

Use ModelBuilder variables for example r"%gdb% and r"%csv%" - the path is substituted in at runtime.

All comments

JohannesLindner

Basic structure:

def get_gdb_feature_count(gdb_path):
    # set workspace to gdb
    prev_ws = arcpy.env.workspace
    arcpy.env.workspace = gdb_path
    # list all feature classes and tables in workspace
    fcs_and_tbls = arcpy.ListFeatureClasses() + arcpy.ListTables()
    # GetCount() on all of these
    counts = [int(arcpy.management.GetCount(ft)[0]) for ft in fcs_and_tbls]
    # revert workspace
    arcpy.env.workspace = prev_ws
    # return [ ["TableName", count] ]
    return zip(fcs_and_tbls, counts)


csv_path = "path:/to/your/csv_file.csv"
result = get_gdb_feature_count("path:/to/your/gdb")
with open(csv_path, "w") as f:
    f.write("Name,Count\n")
    for r in result:
        f.write(f"{r[0]},{r[1]}\n")

Rakesh_Kumar_GIS

Hi Johannes ,

Thanks your effort.

Please give me this script as a model builder.

thanks for advance,

Rakesh

JohannesLindner

Sorry, I don't know how to do this in ModelBuilder.

Try running the script in the Python Window first, that makes it easier to troubleshoot.

curtvprice

This can't be done in ModelBuilder tools, but you can use the Calculate Value tool like this in ModelBuilder.

Expression: proc(r"C:\users\me\my.gdb", r"C:\users\me\my.csv")

Code Block:

def get_gdb_feature_count(gdb_path):
    # set workspace to gdb
    prev_ws = arcpy.env.workspace
    arcpy.env.workspace = gdb_path
    # list all feature classes and tables in workspace
    fcs_and_tbls = arcpy.ListFeatureClasses() + arcpy.ListTables()
    # GetCount() on all of these
    counts = [int(arcpy.management.GetCount(ft)[0]) for ft in fcs_and_tbls]
    # revert workspace
    arcpy.env.workspace = prev_ws
    # return [ ["TableName", count] ]
    return zip(fcs_and_tbls, counts)

def proc(gdb, csv_path):
    result = get_gdb_feature_count(gdb)
    with open(csv_path, "w") as f:
        f.write("Name,Count\n")
        for r in result:
            f.write(f"{r[0]},{r[1]}\n")

Rakesh_Kumar_GIS

Hi curtvprice ,

Thanks for the reply.

can be set gdb path and csv path as a parameter. if possible then please let me know.

thanks,

Rakesh

curtvprice

Use ModelBuilder variables for example r"%gdb% and r"%csv%" - the path is substituted in at runtime.

Rakesh_Kumar_GIS

Thank you so much !!!!!!! curtvprice

But I observe its working on both are same folder path.

But any how... Its really usefull for me

thanks for your time in future I will defiantly reach you 🙂

Rakesh_Kumar_GIS

And I think its not write dataset name and inside the dataset feature class.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.