Utility Network properties extractor
June 2023:
The June 2023 release of the “Utility Network Properties Extractor” Add-in has been deployed to Esri GitHub. The Master (3.1) and 2.9 branches have been updated with the same functionality.
What's new:
- Map Field Settings CSV now contains an editable column to “Reorder fields in a Web Map”. This applies to both layers and tables
- Import Field Settings button will reorder the fields in the Web Map based on the CSV file
- Additional attributes added to the UN Featureservice CSV, including Sync capabilities
- Labeling range column added to the Layer Scales CSV
- The path to the CSV file location now includes a folder for the current map
Please use the Github link at the bottom of this blog to access the updated source code.
============================================================
February 2023:
In accordance with the Network Management Release Plan, the source code for a 3.1 compliant version of the Utility Network Properties Extractor Add-in has been uploaded to GitHub.
The Master branch contains the latest code. Branch, 2.9, was created to support those users who aren't ready to upgrade to the latest release.
Please use the Github link at the bottom of this blog to access the updated source code.
============================================================
May 2022: New functionality has been added to the Utility Network properties extractor add-in.
What's new:
- 3 new extractor buttons that generate reports for the UN Featureservice, Layer Scales and Layer Counts
- A new efficiency tool that displays machine info (O/S, CPU, memory, etc) and also copies that information to the clipboard
- Additional attributes added to many of the original reports
Please use the Github link at the bottom of this blog to access the updated source code.
============================================================
Original post from 2021:
If you are interested in extracting ArcGIS Utility Network, Geodatabase or Map properties to CSV files, the source code for a new ArcGIS Pro SDK add-in is available on Esri GitHub. Once these properties are in Excel, filtering capabilities can be used to quickly get answers to these types of questions:
- Which network rules are defined for a specific Asset Group and Asset Type?
- Are database field names and aliases assigned consistently across multiple featureclasses?
- Which features are assigned to a network category?
You can absolutely get these answers from within ArcGIS Pro but the information is spread across many panes and it is time consuming to retrieve all of it. The Add-in contains 21 extractor buttons that generate individual CSVs into a single folder. There is even an “Extract All” button.
The Add-in also contains 3 efficiency tools that help setup the map. As an example, the “Set Containment Display Filters” button will define the Display Filter on the appropriate layers with the correct SQL query.
The Add-in is domain network agnostic. It doesn’t matter if the Utility Network is Electric, Gas, Communications, District Heating & Cooling, Water, Sewer, or others. The add-in determines if the map contains a Utility Network and then enables or disables buttons.
Note: The code was written against ArcGIS Pro 2.7. If you are using a version earlier then 2.8, you may need to comment out some sections of code.
The effort to manage a Utility Network, Geodatabase and its Maps is large. The Add-in was written with efficiency in mind. Get the information into CSVs and use filtering capabilities in Excel to find the answer.
https://github.com/Esri/utility-network-properties-extractor