Get Assettype and asettgroup count from the Feature class

kumarprince8071 — Sun, 14 May 2023 01:52:57 GMT

In trying to get all the assettype and aasetgroup field values based on assetgroup field which are domain coded from the gdb but the script is not working for some of the gdb's and for some of the gdb's i'm not getting all the Feature Classes which are inside Feature Dataset

Any suggestions or help pleease,

import arcpy,openpyxl,os
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
outputfile = "output8.xlsx"
arcpy.env.overwriteOutput =True
ws.cell(row=1, column =1,value = "Feature Dataset")
ws.cell(row=1, column=2, value="Feature Class")
ws.cell(row=1, column=3, value="Feature Count")
ws.cell(row=1, column=4, value="Asset Group")
ws.cell(row=1, column=5, value="Asset Group Count")
ws.cell(row=1, column=6, value="Asset Type")
ws.cell(row=1, column=7, value=" Asset Type Count")
row_num = 2
gdb = r'path\to\gdb'
arcpy.env.workspace = gdb
fds = arcpy.ListDatasets("*", "Feature")
for fd in fds:
    feature_classes = []
    arcpy.env.workspace = gdb + '\\' + fd
    for fc in arcpy.ListFeatureClasses("","ALL"):
        feature_classes.append(fc)
    #arcpy.env.workspace = gdb
    for feature_class in feature_classes:
        counts = arcpy.GetCount_management(feature_class).getOutput(0)
        ws.cell(row=row_num, column=1, value=fd)
        ws.cell(row=row_num, column=2, value=feature_class)
        ws.cell(row=row_num, column=3, value=counts)
        # row_num+=1
        all_codedvalue = {}
        all_assetgrp = {}
        field_name = ["ASSETGROUP", "ASSETTYPE"]
        Fields = arcpy.ListFields(feature_class)
        subdict = arcpy.da.ListSubtypes(feature_class)
        searchfield = False
        if len(subdict) > 1:
            for stcode in subdict:
                if subdict[stcode]['SubtypeField'] != "":
                    all_assetgrp[stcode] = subdict[stcode]['Name']
                    for i in Fields:
                        if i.name == 'ASSETGROUP':
                            subtypename = {}
                            subtypename[stcode] = subdict[stcode]['Name']
                            codedvalue = {}
                            if subdict[stcode]['FieldValues']['ASSETTYPE'][1] != None:
                                for c in subdict[stcode]['FieldValues']['ASSETTYPE'][1].codedValues:
                                    codedvalue[c] = subdict[stcode]['FieldValues']['ASSETTYPE'][1].codedValues[c]
                            FieldsNames = []
                            for fields in Fields:
                                FieldsNames.append(fields.name)
                            for field_n in field_name:
                                if field_n in FieldsNames:
                                    searchfield = True
                                else:
                                    searchfield = False
                            assetgroup = {}
                            assettype = {}
                            if searchfield == True:
                                for key in subtypename:
                                    whee_clase = "ASSETGROUP = " + str(key)
                                    with arcpy.da.SearchCursor(feature_class,field_name,whee_clase) as cursor:
                                        for row in cursor:
                                            if subtypename[row[0]] in assetgroup:
                                                assetgroup[subtypename[row[0]]] +=1
                                            else:
                                                assetgroup[subtypename[row[0]]] = 1
                                            if codedvalue[row[1]] in assettype:
                                                assettype[codedvalue[row[1]]] += 1
                                            else:
                                                assettype[codedvalue[row[1]]] = 1
                            for group, type_counts in assetgroup.items():
                                ws.cell(row=row_num, column=4, value=group)
                                ws.cell(row=row_num, column=5, value=type_counts)
                                for asset, count in assettype.items():
                                    ws.cell(row=row_num , column=6, value=asset)
                                    ws.cell(row=row_num , column=7, value=count)
                                    row_num+=1
        else:
            row_num += 1
arcpy.env.workspace = gdb
outside_dataset = []
for item in arcpy.ListFeatureClasses("","ALL"):    outside_dataset.append(item)
for item in arcpy.ListTables("*"):    outside_dataset.append(item)
for feature in outside_dataset:
    count_ = arcpy.GetCount_management(feature).getOutput(0)
    ws.cell(row=row_num+1, column=2, value=feature)
    ws.cell(row=row_num+1, column=3, value=count_)
    row_num+=1
wb.save(outputfile)

Re: Get Assettype and asettgroup count from the Feature class

DavidPike — Sun, 14 May 2023 10:06:12 GMT

Can you explain in more detail what you're trying to achieve? The code looks very verbose and seems to have 6 levels of iteration at one point.

Re: Get Assettype and asettgroup count from the Feature class

kumarprince8071 — Sun, 14 May 2023 10:10:16 GMT

By using this code i am trying to get the Asset type field values based on asset group from the gdb and exporting that unique values of Asset type and Asset group in the excel .But while doing that i'm not able to get all the feature class inside a feature dataset.

topic Re: Get Assettype and asettgroup count from the Feature class in Python Questions

Get Assettype and asettgroup count from the Feature class

Re: Get Assettype and asettgroup count from the Feature class

Re: Get Assettype and asettgroup count from the Feature class