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)
