Utility Network properties extractor

7773
15
05-11-2021 09:09 AM
MichaelHirschheimer
Esri Contributor
12 15 7,773

April 2024:

Toolbar2024.PNG

The April 2024 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 except where noted.

1. Symbol Scale button: New extract that lists out the scales for each symbol in the map

2. Pop-ups:

  • Pop-up Fields: New extract that lists the layers or tables “popup fields”. The visibility and Pop-up Order fields can be changed
  • Import Pop-up Field Settings: Imports the Pop-up Fields CSV
    • In the Master (3.1) branch, the import button is included in the toolbar.
    • In the 2.9 branch, the import button is commented out in the config.daml file . Waiting for BUG-000165908 to be fixed before making the button visible in the toolbar.

3. Extract Location Button: Displays the location to where all CSVs are created for the active map. Folder path is copied to the clipboard so that you can paste into File Explorer

4. Layer Info button:

  • Generates a new “labeling” file that contains the labels defined on each layer
  • Enhanced report header information with the map’s coordinate system and units
  • Added new fields to the main report that shows Label Count and additional Pop-up information

5. Layer Scales: Added a new range value of 25,000 feet

6. Network Diagrams Button: When the Utility Network layer data source is a featureservice, the REST endpoint is queried for template details

7. Added Progress bars on multiple buttons for the longer running extracts

Please use the GitHub link at the bottom of this blog to access the updated source code

============================================================

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:

  1. Map Field Settings CSV now contains an editable column to “Reorder fields in a Web Map”.  This applies to both layers and tables
  2. Import Field Settings button will reorder the fields in the Web Map based on the CSV file
  3. Additional attributes added to the UN Featureservice CSV, including Sync capabilities
  4. Labeling range column added to the Layer Scales CSV
  5. 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.  

Toolbar.PNG

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:

  1. Which network rules are defined for a specific Asset Group and Asset Type?
  2. Are database field names and aliases assigned consistently across multiple featureclasses?
  3. Which features are assigned to a network category? 

MichaelHirschheimer_1-1620654500401.png

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

 

 

15 Comments