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 Code to find all Versioned Feature Classes within Enterprise Geodatabase

BenVan_Kesteren1

Hey Everyone,

I am wondering if anyone has got a simple script that they have that will iterate over all feature classes within my Enterprise Geodatabase, and return only the ones that are Registered as Versioned?

Sounds simple enough, I just haven't found an arcpy tool that will return versioned or not versioned.

Cheers

Finde mehr Beiträge mit dem Tag

Accepted answers

DanPatterson_Retired

Ben, you might want to look through this thread.

The arcpy 'isversioned' is part of the 'describe' properties of a featureclass.

You need to cycle through the featureclasses and see if it meets the case

https://community.esri.com/message/782500-re-conditional-statement-unregisterasversioned?commentID=782500#comment-782500

Dataset properties....

isVersioned
(Read Only)
Indicates whether the dataset is versioned.
Boolean

All comments

BenVan_Kesteren1

For anyone interested, below is the full code I used to do the following workflow:

find all datasets within enterprise sde
find only the datasets that have versioning applied
ignore the dataset if it contains the string 'vegetation'
unregister the dataset as being versioned

<SPAN class="comment token"># set workspace</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Database Connections\GISADMIN@SDE_Spatial@SDE-DB.sde'</SPAN>

<SPAN class="comment token"># build list of datasets</SPAN>
datasets <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#iterate over datasets</SPAN>
<SPAN class="keyword token">for</SPAN> dataset <SPAN class="keyword token">in</SPAN> datasets<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># pull back information about the dataset</SPAN>
&nbsp;&nbsp;&nbsp; description <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>dataset<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># ignore datasets that contain vegetation data</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="string token">'vegetation'</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> dataset<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># find if dataset is versioned</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> description<SPAN class="punctuation token">.</SPAN>isVersioned<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># unregister as versioned the dataset</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>UnregisterAsVersioned_management<SPAN class="punctuation token">(</SPAN>in_dataset<SPAN class="operator token">=</SPAN>dataset<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; compress_default<SPAN class="operator token">=</SPAN><SPAN class="string token">"COMPRESS_DEFAULT"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks again for your help Dan.

BenVan_Kesteren1

Exactly what I am looking for, thanks Dan.

DanPatterson_Retired

Ben, you might want to look through this thread.

The arcpy 'isversioned' is part of the 'describe' properties of a featureclass.

You need to cycle through the featureclasses and see if it meets the case

https://community.esri.com/message/782500-re-conditional-statement-unregisterasversioned?commentID=782500#comment-782500

Dataset properties....

isVersioned
(Read Only)
Indicates whether the dataset is versioned.
Boolean

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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