Access UN connectivity in geodatabase

[PierreloupDucroix]

Hello,

I would like to create a view that summarizes topological connectivity between objects of my network. The result should be very simple, like FromOID | ToOID and no geometry.

I found a table (un_XX_associations) that has information about the connectivity associations (junction-junction, structural attachment, etc.) but nothing related to topological connectivity between edges and points.

Is there a way to access this information, or do I need to trace the network and process the resulting JSON graph (which I would like to avoid) ?

[AnthonyRyanEQL]

The data is a binary proprietary format and not available. You'll have to trace/export subnetwork and construct it yourself

[MikeMillerGIS · Accepted solution]

I would suggest starting with the output of https://esri.github.io/Utility-Data-Management-Support-Tools/docs/3.3/TraceFilesToGeodatabase.html.  We process the json files into a database, which might make it easier to work it.

[RobertKrisher]

You can find a blog post describing the different outputs, options, and best practices for using JSON files here: Journey to the Utility Network: Network Integrations (esri.com)

You can find a description of how to parse those JSON files here: https://community.esri.com/t5/arcgis-utility-network-documents/parsing-utility-network-json-files/ta...

[PierreloupDucroix]

Hi,

thank you all for your answers.

@MikeMillerGIS, I didn't know about the TraceFileToGeodatabase, so many geat tools in this toolbox. As far as I understand, it "only" translates a JSON to more readable GDB tables. This is a great way to manipulate trace results with arcpy and cursors instead of parsing the JSON.

@RobertKrisher, I just watched your presentation at the dev summit about parsing JSON for network analysis, great work. We made our own code to translate trace JSON to electric CIM XML files, but will definitely look at your solution. For the current purpose, I would like to stay arcpy-y and will look at Mike's solution.

Best regards