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!!!

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"

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JayantaPoddar

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.

<SPAN class="keyword token">import</SPAN> arcpy 
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env 
<SPAN class="keyword token">import</SPAN> os 

<SPAN class="comment token"># Set the workspace for the ListFeatureClass function </SPAN>

<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env 
<SPAN class="keyword token">import</SPAN> os 

<SPAN class="comment token"># Set the workspace for the ListFeatureClass function </SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Path\xyz.sde"</SPAN>
<SPAN class="comment token"># Use the ListFeatureClasses function to return a list of all fc's in the sde gdb: </SPAN>
fcList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Write the name of the current fc in csv file:</SPAN>
txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"Path\xyz.csv"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fc

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Write messages to a csv File</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write <SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>linesep<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#close csv file</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"done"</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

How do I write the Geometry Type?

Also suggestions are welcome to further optimize the above script.

Thanks!!!

Najděte více příspěvků označených jako

Accepted answers

JamesCrandall

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

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcList<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Write messages to a csv File</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>fc <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> desc<SPAN class="punctuation token">.</SPAN>featureType<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write <SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>linesep<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#close csv file</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"done"</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JayantaPoddar

Perfect.

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

txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>fc <SPAN class="operator token">+</SPAN> <SPAN class="string token">","</SPAN> <SPAN class="operator token">+</SPAN> desc<SPAN class="punctuation token">.</SPAN>shapeType<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

MicahBabinski

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 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Path\xyz.sde"</SPAN>
fcs <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

walk <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Walk<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"FeatureClass"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> dirpath<SPAN class="punctuation token">,</SPAN> dirnames<SPAN class="punctuation token">,</SPAN> filenames <SPAN class="keyword token">in</SPAN> walk<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> filenames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fcs<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>dirpath<SPAN class="punctuation token">,</SPAN> filename<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; geometryType <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>shapeType
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>geometryType<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

JamesCrandall

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

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcList<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Write messages to a csv File</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>fc <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> desc<SPAN class="punctuation token">.</SPAN>featureType<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write <SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>linesep<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#close csv file</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"done"</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesCrandall

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

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; featType <SPAN class="operator token">=</SPAN> desc<SPAN class="punctuation token">.</SPAN>featureType‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JayantaPoddar

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.

JamesCrandall

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

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.