Get Assettype and asettgroup count from the Feature class

kumarprince8071

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)

kumarprince8071

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.