Export list of items within enterprise database

AndrewIngall1 — Sat, 09 May 2020 10:30:08 GMT

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

Re: Export list of items within enterprise database

DavidPike — Sat, 11 Dec 2021 22:29:12 GMT

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("\n")

for line in line_list:
    
    row_count = arcpy.GetCount_management(line[0])
    print("Line -- " + line[1] + " -- " + str(row_count))

print("\n")

for point in point_list:
    
    row_count = arcpy.GetCount_management(point[0])
    print("Point -- " + point[1] + " -- " + str(row_count))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Export list of items within enterprise database in Python Questions

Export list of items within enterprise database

Re: Export list of items within enterprise database