topic Re: Access UN connectivity in geodatabase in ArcGIS Utility Network Questions

Access UN connectivity in geodatabase

PierreloupDucroix — Thu, 23 May 2024 04:06:45 GMT

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) ?

Re: Access UN connectivity in geodatabase

AnthonyRyanEQL — Thu, 23 May 2024 04:20:50 GMT

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

Re: Access UN connectivity in geodatabase

MikeMillerGIS — Thu, 23 May 2024 10:32:10 GMT

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.

Re: Access UN connectivity in geodatabase

RobertKrisher — Thu, 23 May 2024 13:19:00 GMT

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-p/1314718

Re: Access UN connectivity in geodatabase

PierreloupDucroix — Thu, 23 May 2024 23:40:36 GMT

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