idea Utility Network export Tier data to Excel/CSV in ArcGIS Utility Network Ideas

Utility Network export Tier data to Excel/CSV

ScottFierro1 — Wed, 28 Apr 2021 15:14:18 GMT

Under the Network Properties of the Utility Network the "Tiers" section is a very large table that is hard to navigate or use. Providing an option to export this table out to Excel or CSV would be amazing. Even just getting it to a database table is fine as the intermediary step.

Re: Utility Network export Tier data to Excel/CSV

RobertThomson — Wed, 28 Apr 2021 15:21:38 GMT

Also handy would be a visual way to look at the network Tiers, see the attached for ours.

Re: Utility Network export Tier data to Excel/CSV

ScottFierro1 — Wed, 28 Apr 2021 15:28:54 GMT

@RobertThomson also a great idea, is there a posted ideas link you can share to upvote that one?

Re: Utility Network export Tier data to Excel/CSV

RobertThomson — Wed, 28 Apr 2021 15:39:55 GMT

I guess I can just post as a new post? I know one thing for sure there's got to be a better way to represent the Utility Network. When I was learning the UN and putting ours together it was nightmare looking into Network Properties to find out why I was having certain issues not to mention understanding the entire structure of the Water Template Model I used.

Re: Utility Network export Tier data to Excel/CSV

ScottFierro1 — Wed, 28 Apr 2021 15:56:59 GMT

Yeah, it's new and will continue to get refined but these simple changes can make all users lives easier.

I'd say definitely create a new post with it because it is a separate, unique idea but equally valid.

Re: Utility Network export Tier data to Excel/CSV

RobertKrisher — Mon, 12 Feb 2024 15:30:35 GMT

Solutions taken from this idea (Scroll bar on Network Properties in Utility Manage... - Esri Community).

As of ArcGIS Pro 3.2 you can use the Generate Schema Report tool to create an excel or html report for your geodatabase. This includes a section that describes the tiers in your network.

You can also use the utility network properties extractor to produce this in csv format.

If you want to visualize your actual subnetworks, you can use the export subnetwork controllers tool to output all your subnetwork controllers to a csv file (that includes tiers) and use that to generate a graphic like what you referenced above.

Re: Utility Network export Tier data to Excel/CSV - Status changed to: Implemented

RemiMyers — Mon, 12 Feb 2024 16:03:56 GMT

As per Robert's comments above