Export list of items within enterprise database

Question

Hello

I am trying to export a list of items within a enterprise geo-database to excel.  I have not used python before or model builder so any guidance on where to start would be much appreciated.

I would love to be able to get the feature class name, the number of records and the type of the feature class, i.e point, area, polyline etc.

Is the above possible???

Thanks

Andy

DavidPike · Answer

It should work through the python window if you're connected to the sde (I guess). Hopefully someone with more ken can solve that one if not. import arcpy import os workspace = r'your sde here' walk = arcpy.da.Walk(workspace, datatype="FeatureClass", type="Polygon") polygon_list = [] for dirpath, dirnames, filenames in walk: for filename in filenames: polygon_list.append([os.path.join(dirpath, filename), filename]) walk = arcpy.da.Walk(workspace, datatype="FeatureClass", type="Polyline") line_list = [] for dirpath, dirnames, filenames in walk: for filename in filenames: line_list.append([os.path.join(dirpath, filename), filename]) walk = arcpy.da.Walk(workspace, datatype="FeatureClass", type="Point") point_list = [] for dirpath, dirnames, filenames in walk: for filename in filenames: point_list.append([os.path.join(dirpath, filename), filename]) print(line_list) for polygon in polygon_list: row_count = arcpy.GetCount_management(polygon[0]) print("Polygon -- " + polygon[1] + " -- " + str(row_count)) print(" ") for line in line_list: row_count = arcpy.GetCount_management(line[0]) print("Line -- " + line[1] + " -- " + str(row_count)) print(" ") for point in point_list: row_count = arcpy.GetCount_management(point[0]) print("Point -- " + point[1] + " -- " + str(row_count))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍