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; } } }

Copy a list of feature classes from Enterprise to Geodatabase

AhmadSALEH1

I am trying to write a code that uses “arcpy.CopyFeatures_management” to copy all feature classes inside an Enterprise geodatabase to a Geodatabase.

The issue here happens when using FOR loop to copy the whole list of F.C’s to the geodatabase, I am trying to assign the same name for the features. But it seems that there is something that I am missing.

I tried different statements for “out_feature_class” with no luck, sometimes the code fails to run or it copies a single F.C only.

<SPAN class="keyword token">import</SPAN> arcpy <SPAN class="punctuation token">,</SPAN>sys
adminconn<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'C:\1\b2.sde'</SPAN>
gdbFile<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'c:\1\x.gdb'</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>adminconn
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN>


SDEfcList<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>gdbFile
<SPAN class="keyword token">for</SPAN> dataitem <SPAN class="keyword token">in</SPAN> SDEfcList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fcdesc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>dataitem<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>dataitem<SPAN class="punctuation token">,</SPAN>gdbFile<SPAN class="operator token">+</SPAN>fcdesc<SPAN class="punctuation token">.</SPAN>name<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks

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

Accepted answers

JonathanQuinn

The first thing that stands out is the path of the output data. If you add

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="operator token">+</SPAN>fcdesc<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>‍

You'll probably see that you're missing an OS separator between the gdbFile name and the data set name.

You can use the OS module to correct that:

os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="punctuation token">,</SPAN>fcdesc<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

The other thing is that you're already getting the feature class name from the loop, stored in the dataitem variable, so the Describe function is not necessary. You'll also likely need to split off the database name and data owner as the feature class name will likely come across as database.owner.table and periods are not supported in the name of a feature class in a FGDB.

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os
adminconn<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'C:\1\b2.sde'</SPAN>
gdbFile<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'c:\1\x.gdb'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>adminconn
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN>

SDEfcList<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> dataitem <SPAN class="keyword token">in</SPAN> SDEfcList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>dataitem<SPAN class="punctuation token">,</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="punctuation token">,</SPAN>dataitem<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SDE."</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍

All comments

JonathanQuinn

The first thing that stands out is the path of the output data. If you add

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="operator token">+</SPAN>fcdesc<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>‍

You'll probably see that you're missing an OS separator between the gdbFile name and the data set name.

You can use the OS module to correct that:

os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="punctuation token">,</SPAN>fcdesc<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os
adminconn<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'C:\1\b2.sde'</SPAN>
gdbFile<SPAN class="operator token">=</SPAN>r<SPAN class="string token">'c:\1\x.gdb'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>adminconn
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN>

SDEfcList<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> dataitem <SPAN class="keyword token">in</SPAN> SDEfcList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>dataitem<SPAN class="punctuation token">,</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="punctuation token">,</SPAN>dataitem<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SDE."</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍

XanderBakker

If your data is stored in feature datasets inside the database, you will only get the featureclasses that are outside any feature dataset. To avoid that you will have to get the list of datasets and loop through that list and use it in the list Featureclasses. Example:

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

ws <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Esri\Curso\Aguas\WaterUtilityNetworkEditing - Ejercicio 2\localgovernment.gdb'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> ws

fdss <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fdss<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> fds <SPAN class="keyword token">in</SPAN> fdss<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fc_names <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN>feature_dataset<SPAN class="operator token">=</SPAN>fds<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> fc_name <SPAN class="keyword token">in</SPAN> fc_names<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fc <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>ws<SPAN class="punctuation token">,</SPAN> fds<SPAN class="punctuation token">,</SPAN> fc_name<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fc<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>

AhmadSALEH1

Thanks Jonathan,

it worked fine with me now. another question I am trying do do the same method to use Table to table tool, it seems that the split ("SDE.") fails to truncate database.owner. for the Tables!

arcpy.TableToTable_conversion(tableitem,os.path.join(gdbFile,tableitem.split("SDE.")[0]))‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

what do you think ?

JonathanQuinn

Woops, it should be

arcpy.TableToTable_conversion(tableitem,os.path.join(gdbFile,tableitem.split("SDE.")[<STRONG>1</STRONG>]))

Which means split on SDE., (or whatever database owner you're using), and take the second item in the list which is the FC name.

AhmadSALEH1

Thanks again Jonathan,

I tried to change it form [0] to [1] but I keep getting the following message:

Failed to execute. Parameters are not valid. ERROR 00732: Output Location. Dataset .... dose not exist or not supported.

I think that the tool considers the output path (os.path.join(gdbFile,tableitem.split("DBO.")[1])) as a dataset and tries to store the table inside it!

TableList<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> tableitem <SPAN class="keyword token">in</SPAN> TableList <SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>tableitem<SPAN class="punctuation token">,</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdbFile<SPAN class="punctuation token">,</SPAN>tableitem<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DBO."</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Připojte se ke konverzaci

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.