topic Re: find out the list of versioned feature classes or Dataset. in Data Management Questions

find out the list of versioned feature classes or Dataset.

AntonyPaul_M1 — Mon, 21 May 2012 08:15:12 GMT

Hi All,

I have a ArcSDE Geodatabase and have n number of dataset and layers, Its really huge.

I want to find out the list of versioned feature classes or Dataset.

Is there any way to query the SDE syetem tables and find?

Your help is really appreciated

Many Thanks

Cheers
Antony

Re: find out the list of versioned feature classes or Dataset.

VinceAngelo — Mon, 21 May 2012 10:11:43 GMT

The problem with using SQL in pre-10.0 databases to query this information is that the
same query won't work in 10.x instances. Both ArcObjects and Python can generate
lists of feature datasets and the feature classes within them in a release-independent
manner. You'd have to poll each FC to deterimine if it was versioned.

There are forums dedicated to both ArcObjects and Python where you could pursue the
details for each, but be sure to specify your ArcGIS version and service pack, so they
can give you the most appropriate "best" solution.

- V

Re: find out the list of versioned feature classes or Dataset.

AntonyPaul_M1 — Tue, 22 May 2012 01:14:56 GMT

The problem with using SQL in pre-10.0 databases to query this information is that the
same query won't work in 10.x instances. Both ArcObjects and Python can generate
lists of feature datasets and the feature classes within them in a release-independent
manner. You'd have to poll each FC to deterimine if it was versioned.

There are forums dedicated to both ArcObjects and Python where you could pursue the
details for each, but be sure to specify your ArcGIS version and service pack, so they
can give you the most appropriate "best" solution.

- V

Thanks for the Reply.

I am currently in ArcGIS 9.3 and Oracle 10g

Cheers
Antony

Re: find out the list of versioned feature classes or Dataset.

AntonyPaul_M1 — Fri, 10 Dec 2021 21:10:56 GMT

Hi

I got python script to find out all the verioned feature classes inside the Geodatabase. It works for me so I thought of sharing it with you guys,

import sys, string, os, arcgisscripting, logging

log_File = "c:\\Documents and Settings\\apaul\\desktop\\sde_dataset_versioning.log"

# Set up log file
logger = logging.getLogger('myapp')
hdlr = logging.FileHandler(log_File)
formatter = logging.Formatter('%(message)s')
hdlr.setFormatter(formatter)
logger.addHandler(hdlr)
logger.setLevel(logging.INFO)

gp = arcgisscripting.create(9.3)
gp.workspace = "C:\\Documents and Settings\\apaul\\\desktop\\sde_con.sde"

fds = gp.ListDatasets()

for fd in fds:
    gp.workspace = "C:\\Documents and Settings\\apaul\\\desktop\\sde_con.sde\\%s" % fd
    fcs = gp.ListFeatureClasses()
    
    try:
        fc1 = fcs[0]
        desc = gp.Describe(fc1).IsVersioned
        print fd,desc
        logger.info('%s %s'%(fd,desc))
        
    except:
        pass

Re: find out the list of versioned feature classes or Dataset.

VinceAngelo — Wed, 23 May 2012 10:13:01 GMT

The indent scheme is hyper-important in Python. Please edit your solution so
it will work. It would also be a good idea to post in a CODE block, so the text
is more legible (fixed-width font) -- use the "#" in the editor widgits.

- V

Re: find out the list of versioned feature classes or Dataset.

FrédéricPRALLY — Fri, 25 May 2012 11:33:59 GMT

Hi antony,
Maybe you can used this add-in List versioned data,

Hope this help you,

Fred