Listing Topology Rules Used (in user friendly format)

RebeccaStrauch__GISP · ‎08-03-2017

I have an ArcSDE (SQL) database and Feature Dataset with multiple layers involved in a Topology, with about a dozen rules. I've added a new FC and I'm now working on setting up and modifying the rules.

I know I can right-click the properties of the topology to see the rules, but I can't expand the properties box to see all three columns in full. Saving the rules creates a binary (non-readable) .rul file. I tried a select-all, copy/paste from the properties window but that does not work.

I know that a dozen rules isn't so much that I couldn't just right them down (which is what I willdo for now), but wondering if anyone has a tool or procedure for converting/viewing the .rul file as a a text file....or any other simple tool.

I figure this question with either be something simple I am missing, someone has a snazzy tool, or not work pursuing, but worth asking in case it's one of the first two.

Thanks

KathrynCliftonGIS · ‎04-12-2022

I was just trying to find an answer to the same question, and I found a way to create this by Topology.

So, do the following:

1) add the Topology to ArcMap
2) right-click the Topology in the Table of Contents and choose Properties
3) select the Errors tab and click Generate Summary
4) then click Export to File (this will export the results to a comma-delimited text file)

5) Open Excel and create a new file
6) click Data, and choose From Text
7) select the file and choose Import
😎 within the Text Import Wizard, indicate that the data is delimited by commas and has headers

This will create a nicely formatted Excel spreadsheet with all of the rules and how many errors and exceptions exist.

Kathryn Clifton, GISP, PLS

View solution in original post

RebeccaStrauch__GISP · ‎08-03-2017

I will answer and close (unless someone finds an answer) with the answer that it isn't possible (feel free to prove me wrong).

But to summarize, I will include some tips and something that almost got me what I wanted....but really just proved it wasn't possible (maybe with ArcObjects, but I'm not going there).

The 10.0 version of the Topology Rules poster http://help.arcgis.com/en/arcgisdesktop/10.0/help/001t/pdf/topology_rules_poster.pdf which is the last version I could locate...should still be good.
arcgis desktop - List File Geodatabase Topology - Geographic Information Systems Stack Exchange this pointed me to a arcpy script that would find what the name of the topologies in a dataset. This works well

import arcpy
import os
path = r"C:\ArcGIS\Default.gdb"

arcpy.env.workspace = path
gdb_objects = arcpy.ListDatasets(wild_card=None, feature_type='Feature')
print "Feature datasets are: " + str(gdb_objects) #only feature datasets are here
for obj in gdb_objects:
    fd_path = os.path.join(path,obj)
    arcpy.env.workspace = fd_path #get a new workspace pointed to the fd
    fd_objects = arcpy.ListDatasets(wild_card=None, feature_type='')

    for dataset in fd_objects: #iterate feature dataset objects
        desc_dataset = arcpy.Describe(dataset)
        if desc_dataset.datasetType == 'Topology': #finding out whether is topology
            print dataset‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It gives the name of the topology, but no other info. But with that, and pointing me to the properties (I'm including 10.3 links)

I could then list the feature classes that are in the topology

pathtoTopology = r'full path to topology'
descTopoFC = arcpy.Describe(pathtoTopology)
print("{0}".format(descTopoFC.featureClassNames))


‍‍‍‍‍

However, I could not find anything that would print the FeatureClass, Rule, and 2nd-FeatureClass (if applicable) as shown in the properties.

So, closing this thread. If anyone finds anything, I would be interested, but not worth spending more time on it for me right now.

PierreMasson · ‎06-29-2020

I want to do the same, any ideas how to?

KathrynCliftonGIS · ‎04-12-2022