topic Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection in Python Questions

Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JayantaPoddar — Sun, 12 Dec 2021 06:38:31 GMT

Hi Guys,

I need a script which would write the name and geometry (Point,Line,Polygon) of the Feature Classes from an Ent. GDB to a CSV file.

So far, I am able to write the names successfully using the below script.

import arcpy 
from arcpy import env 
import os 

# Set the workspace for the ListFeatureClass function 

from arcpy import env 
import os 

# Set the workspace for the ListFeatureClass function 
env.workspace = r"Path\xyz.sde"
# Use the ListFeatureClasses function to return a list of all fc's in the sde gdb: 
fcList = arcpy.ListFeatureClasses() 

# Write the name of the current fc in csv file:
txtFile = open(r"Path\xyz.csv","w")
for fc in fcList:
    print fc

    # Write messages to a csv File
    txtFile.write(fc)
    txtFile.write (os.linesep)

#close csv file
txtFile.close()

print "done"
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

How do I write the Geometry Type?

Also suggestions are welcome to further optimize the above script.

Thanks!!!

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JamesCrandall — Fri, 27 Oct 2017 17:40:01 GMT

Looks like arcy.Describe() is what you will need. http://pro.arcgis.com/en/pro-app/arcpy/functions/featureclass-properties.htm

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JayantaPoddar — Fri, 27 Oct 2017 18:56:29 GMT

Thanks James.

How can I use arcpy.Describe() for all the FCs in a Geodatabase? And ultimately write them next to the name of each FC in CSV.

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JamesCrandall — Sun, 12 Dec 2021 06:38:34 GMT

One possibility is to simply set a variable so that you can use it to write the featureType to your output file:

for fc in fcList:
    desc = arcpy.Describe(fc)
    featType = desc.featureType‍‍‍‍‍‍‍‍‍

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JamesCrandall — Sun, 12 Dec 2021 06:38:37 GMT

Or just write the desc.featureType value to your output:

for fc in fcList:

    desc = arcpy.Describe(fc)

    # Write messages to a csv File
    txtFile.write(fc + " " + desc.featureType)
    txtFile.write (os.linesep)

#close csv file
txtFile.close()

print "done"
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

MicahBabinski — Sun, 12 Dec 2021 06:38:39 GMT

Hi Jayanta,

Here's a couple enhancements I'd make:

First, list the feature classes using Walk—Help | ArcGIS for Desktop. List Feature Classes is great but only lists the FCs at the root level of your geodatabase. If you have feature datasets containing additional feature classes, they will be missed by list feature classes. Here's how to use Walk for your script:

workspace = r"Path\xyz.sde"
fcs = []

walk = arcpy.da.Walk(workspace, datatype="FeatureClass")

for dirpath, dirnames, filenames in walk:
    for filename in filenames:
        fcs.append(os.path.join(dirpath, filename))‍‍‍‍‍‍‍‍

Then you can print (or do whatever you like with) the geometry types like this:

for fc in fcs:
    geometryType = arcpy.Describe(fc).shapeType
    print(geometryType)‍‍‍

As for writing to the CSV, have a look at Using the CSV module in Python. I've never used it but it looks pretty straightforward.

Micah

Re: Write Name and Geometry Type of Feature Classes in an Enterprise Geodatabase Connection

JayantaPoddar — Fri, 27 Oct 2017 19:58:59 GMT

Perfect.

I just replaced Line. No. 6 in your script with the following, as per my requirement

txtFile.write(fc + "," + desc.shapeType)‍