topic Re: Python - SDE Get Feature Count in Python Questions

Python - SDE Get Feature Count

JordanMiller4 — Sat, 11 Dec 2021 22:37:26 GMT

I am trying to figure out how to get a count on each feature class in our SDE database and later record it to a text file but I am having trouble figuring out how to setup the "Get Count" portion of the script. I haven't had any success incorporating the "Get Count" example.

When "My Script" runs it prints the fc name (.e.g. jmillePCReplica.DBO.Wayne_Parcels) but when I plug that variable / fc name in place to the "Get Count" example it fails.

Any ideas?

My Script

# Import system modules
import arcpy, os
from arcpy import env

# Set workspace
sdeConnection = r"Database Connections\STR-DT-JMILLE.sde"

feature_classes = []

walk = arcpy.da.Walk(sdeConnection, datatype="FeatureClass", type="All")
print("Starting..")
for dirpath, dirnames, filenames in walk:
    for filename in filenames:
     feature_classes.append(os.path.join(dirpath, filename))
     print(filename)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Get Count Example

result = arcpy.GetCount_management(filename)
print('{} has {} records'.format(filename, result[0]))‍‍‍‍‍‍‍‍‍‍‍

My Script results

Starting..
jmillePCReplica.DBO.P_AbandonedDevice
jmillePCReplica.DBO.P_AbandonedPipe
jmillePCReplica.DBO.P_AbandonedService
jmillePCReplica.DBO.P_AlignmentSheet
jmillePCReplica.DBO.P_CapitalProject
jmillePCReplica.DBO.P_Coupon
jmillePCReplica.DBO.P_CPArea
jmillePCReplica.DBO.P_DrinkingWater
jmillePCReplica.DBO.P_EcologicalArea
jmillePCReplica.DBO.P_ExcavationDamage
jmillePCReplica.DBO.P_ExposedPipeInspect
jmillePCReplica.DBO.P_GasLeak‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Python - SDE Get Feature Count

deleted-user-NvcfpBOWaKwr — Sat, 11 Dec 2021 22:37:30 GMT

It looks like you are feeding arcpy.GetCount a partial path. Try making a new variable combining sdeConnection and filename so it would look something like whats below. Let me know if it works.

for dirpath, dirnames, filenames in walk:
    for filename in filenames:
        feature_classes.append(os.path.join(dirpath, filename))
        #print(filename) You might not need this
        fileName2 = sdeConnection + "\\" + filename
        result = arcpy.GetCount_management(fileName2)
        print('{} has {} records'.format(filename, result[0]))‍‍‍‍‍‍‍

I also added the GetCount within the filename loop so it would pull filename correctly.

Re: Python - SDE Get Feature Count

JoshuaBixby — Sat, 11 Dec 2021 22:37:32 GMT

Here is a similar suggestion as Jeremy but without the need to define a new sdeConnection variable.

for dirpath, dirnames, filenames in walk:
    for filename in filenames:
        feature_classes.append(os.path.join(dirpath, filename))
        print(filename)
        result = arcpy.GetCount_management(os.path.join(dirpath, filename))
        print('{} has {} records'.format(filename, result[0])
 ‍‍‍‍‍‍‍

Re: Python - SDE Get Feature Count

deleted-user-NvcfpBOWaKwr — Sat, 11 Dec 2021 22:37:35 GMT

Josh, that's the exact way I was going to suggest if the variable worked.Good recommendation! To expand on that even further you could even add a single line of code and set the workspace by using arcpy.env.workspace. Since you imported it already I believe it would be env.workspace

import arcpy, os
from arcpy import env

# Set workspace
sdeConnection = r"Database Connections\STR-DT-JMILLE.sde"

env.workspace = sdeConnection

feature_classes = []

walk = arcpy.da.Walk(sdeConnection, datatype="FeatureClass", type="All")
print("Starting..")
for dirpath, dirnames, filenames in walk:
    for filename in filenames:
     feature_classes.append(os.path.join(dirpath, filename))
     print(filename)
     result = arcpy.GetCount_management(filename)
     print('{} has {} records'.format(filename, result[0]))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Python - SDE Get Feature Count

JordanMiller4 — Wed, 18 Sep 2019 20:11:24 GMT

Thank you guys, I appreciate the help.