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

Python ListLayers mxd vs ListFeatureClasses sde and compare

MatthewDriscoll

Using python how would I go about listing layers I have in a mxd and seeing which of these features are in or not in certain sde databases?

When I use ListLayers in the mxd I get whatever they are named (issue here would be if the name is changed).

When I use the ListFeatureClassess in the sde I get the database.domain.featureclass returned (here I could probably split the string).

I am not sure the best practice to get the common denominator?

Is there an easier way of doing this?

Trouver plus de publications taguées avec

Accepted answers

RandyBurton

From Layer Help:

<SPAN class="keyword token">print</SPAN> lyr<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> lyr<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">,</SPAN> lyr<SPAN class="punctuation token">.</SPAN>datasetName‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Also, you may have an indentation error on line 20-21.

All comments

AlexanderBrown5

Matthew,

If you have a copy of all the MXDs, or have access to them on a shared network drive, you can do something like:

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

wrkspc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Path_to_mxds'</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> wrkspc
workspaces <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListWorkspaces<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Folder"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># print "** " + str(wrkspc) + " **"</SPAN>
mxdList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFiles<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> mxd <SPAN class="keyword token">in</SPAN> mxdList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># print mxd</SPAN>
&nbsp;&nbsp;&nbsp; mxdPath <SPAN class="operator token">=</SPAN> wrkspc <SPAN class="operator token">+</SPAN> os<SPAN class="punctuation token">.</SPAN>sep <SPAN class="operator token">+</SPAN> mxd
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> mxdPath
&nbsp;&nbsp;&nbsp; mxdObject <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>mxdPath<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxdObject<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>supports<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DATASOURCE"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Layer: "</SPAN> <SPAN class="operator token">+</SPAN> lyr<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">"&nbsp; Source: "</SPAN> <SPAN class="operator token">+</SPAN> lyr<SPAN class="punctuation token">.</SPAN>dataSource
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> lyr

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> mxdObject<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>

Of course you can add additional libraries to write everything out to csv or another database table.

~Alex

bixb0012

rvburton‌ is correct. The datasetName property returns what you are after, you are confusing it for what the name property returns, which is the name of the layer file in the MXD.

MatthewDriscoll

I am not really interested seeing which server the layers are in, I am more interested in the name, more importantly it's name within a database.

The problem I run into is when I list layers in the mxd it returns how it is named in the mxd not it's actual name in the database. If I could get the native feature class name, I could achieve what I am trying to do.

When I list feature classes it returns the database and the version along with the feature class. ie targetdatabase.currentversion.myfeatureclass This I think I can handle by making it a string and split it.

bixb0012

If you are looking to see if layers are mapped to certain SDE databases, I would look to the service properties of the layer. If the layer supports "SERVICEPROPERTIES", then check the ServiceType to see if it is SDE. Then, you can access all types of information about the SDE database and how it is being connected to.

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">for</SPAN> layer <SPAN class="keyword token">in</SPAN> layers<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>layer<SPAN class="punctuation token">.</SPAN>supports<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SERVICEPROPERTIES"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> 
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; layer<SPAN class="punctuation token">.</SPAN>serviceProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ServiceType"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"SDE"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> layer<SPAN class="punctuation token">.</SPAN>serviceProperties<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Service'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

From Layer Help:

<SPAN class="keyword token">print</SPAN> lyr<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> lyr<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">,</SPAN> lyr<SPAN class="punctuation token">.</SPAN>datasetName‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Also, you may have an indentation error on line 20-21.

MatthewDriscoll

import arcpy
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections\SDE_Database.sde"</SPAN>
datasetList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ListDatasets</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">)</SPAN>
datasetList<SPAN class="punctuation token">.</SPAN><SPAN class="token function">sort</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> dataset in datasetList<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> dataset
 fcList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ListFeatureClasses</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>dataset<SPAN class="punctuation token">)</SPAN>
 sorts <SPAN class="operator token">=</SPAN> <SPAN class="token function">sorted</SPAN><SPAN class="punctuation token">(</SPAN>fcList<SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN>lambda v<SPAN class="punctuation token">:</SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="token function">lower</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">for</SPAN> fc in sorts<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> fc

jfkslist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ListFeatureClasses</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN>
sorts <SPAN class="operator token">=</SPAN> <SPAN class="token function">sorted</SPAN><SPAN class="punctuation token">(</SPAN>jfkslist<SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN>lambda v<SPAN class="punctuation token">:</SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="token function">lower</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> sort in sorts<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> sort

mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN><SPAN class="token function">MapDocument</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"mxdpath/MXD.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> lyr in arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ListLayers</SPAN><SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN><SPAN class="token function">supports</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DATASOURCE"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> lyr<SPAN class="punctuation token">.</SPAN>name<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>

bixb0012

Can you share your code?

According to the ListLayers documentation:

Returns a Python list of Layer objects that exist within a map document (.mxd), a data frame within a map document, or layers within a layer (.lyr) file

You should be getting a list of layer objects, not a list of strings. The __str__ special method of the Layer object is the name of the layer, hence printing the Layer object will just print its name.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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