topic Compare the feature count between features in SDE in Python Questions

Compare the feature count between features in SDE

NishiChauhan-Patel — Thu, 24 May 2012 13:29:07 GMT

Any help with the follow Python Script would be great!

I'm trying to compare the feature count between features in production SDE and development SDE. So far I have got the following attached, which works but I have the loop in the wrong place, so the comparison at the end compares all DEV features against the first PROD features.

Thanks in advance,
Nish

Re: Compare the feature count between features in SDE

MathewCoyle — Sat, 11 Dec 2021 16:27:22 GMT

I have run this exact procedure before. Except it was between two FGDB.

Hopefully it translates for you.

import arcpy, os

sde1 = r"D:\sde_transit\sde1.gdb"
output = r"D:\sde_transit\sdeCSRS.gdb"

arcpy.env.workspace = sde1
sdeList = arcpy.ListFeatureClasses()

for fc in sdeList:
    
    result = arcpy.GetCount_management(fc)
    count1 = result.getOutput(0)

    fc2 = os.path.join(output,fc)
    if arcpy.Exists(fc2):
        result = arcpy.GetCount_management(fc2)
        count2 = result.getOutput(0)
        if count1 == count2:
            print fc+" OK"

        else:
            print "Problem with "+fc
            print count1
            print count2
    else:
        print fc2+" not found"
        pass

# Clean up
sdeList = None
del arcpy.env.workspace
del arcpy

Re: Compare the feature count between features in SDE

NishiChauhan-Patel — Fri, 25 May 2012 07:15:24 GMT

Mathew,

Thanks very much, worked really well, just needed to adapt it a little!

Cheers,
Nish