topic Multiple Utility Networks in one SDE in ArcGIS Utility Network Questions

Multiple Utility Networks in one SDE

GarimaVyas4 — Thu, 29 Apr 2021 17:41:30 GMT

We are going to create multiple utility networks. Are there recommendations around having multiple EUNDM schemas in the same ArcSDE instance (one schema per network) or will that cause conflicts and we need to create a separate ArcSDE with a single EUNDM schema in it?

Other info:

Underlying database is Postgres.
I noticed this old bug but it seems to addressed now.
We are also interested in recommendations and best practices.

Re: Multiple Utility Networks in one SDE

SSMIC3038 — Fri, 30 Apr 2021 13:38:54 GMT

One database can have one utility network with multiple domain networks within. Multiple utility networks on one database doesn't work, I'm assuming it's due to reserved naming conventions.

To date I've never found any material from ESRI on how to create multiple domain networks within one utility network, which is odd because they promote this so much in their marketing. With quite a bit of effort I've managed to get multiple domain networks in a single utility network up and running, some literature from ESRI would be nice.

I also have a couple of threads on this topic and they've never received a comment, so not much help available.

Re: Multiple Utility Networks in one SDE

GarimaVyas4 — Tue, 04 May 2021 16:42:25 GMT

Thank you @SSMIC3038 I thought so too but i want to let someone from Esri chime in and confirm.

Re: Multiple Utility Networks in one SDE

GarimaVyas4 — Tue, 04 May 2021 16:48:28 GMT

@MelissaJarman - you're the pro here. 🙂

Re: Multiple Utility Networks in one SDE

MelissaJarman — Tue, 04 May 2021 19:50:30 GMT

Hey Garima! I even had to retest this to make sure as I typically load multiple UNs as a different database user if they are in the same geodatabase.

It looks like you can create multiple UNs in the same geodatabase as the same user. We properly handle the naming of the geodatabase objects so they are unique and there are no name collisions.

I do not know if we have a best practice recommendation for organization in the geodatabase. Go with what you can best manage without getting your datasets confused. Depending on the configuration, the UN data model can get complex with relationship classes, tables, multiple domain networks, etc. This may be easier to maintain with a level of isolation for administrative and backup purposes.

Re: Multiple Utility Networks in one SDE

GarimaVyas4 — Wed, 05 May 2021 16:08:13 GMT

Thanks, Melissa! Appreciate the extra step of testing with the confirmation.

Re: Multiple Utility Networks in one SDE

Anumita — Mon, 02 Sep 2024 12:59:55 GMT

Hello @MelissaJarman

During a recent deployment of two separate Utility networks within a single Enterprise geodatabase using the same database user, we encountered a naming conflict involving feature classes.

When deploying the second Utility network, the system automatically appended the "_1" suffix to the names of feature classes that are part of the Structure network.

This inconsistency caused the subsequent "Apply Asset Package" process to fail, as the Asset Package did not contain feature classes with the "_1" suffix.

Our research revealed that there may not be a direct method to modify the names of feature classes involved in the Structure Network. Any changes made to the Asset Package during the "Stage Utility Network" process seem to be disregarded.

We did some research and it looks like there might not be a way to change the name of feature classes participating in Structure Network. As any changes made to the asset package does not get acknowledged during ‘Stage utility network’ tool.

To maintain two distinct Utility networks within a single Enterprise Geodatabase, should we consider the following alternatives:

Separate User Accounts: Deploy each Utility network using two different database users. This approach would ensure that the feature class names do not conflict.
Modified Asset Package Naming: Alter the naming convention within the Asset Package to match the automatically generated feature class names (including the "_1" suffix) that are created during the deployment of the second Utility network.

Re: Multiple Utility Networks in one SDE

RobertKrisher — Tue, 03 Sep 2024 19:24:43 GMT

@Anumita the most common approach we see for this is to create separate users and schemas for each utility network. Each utility network then also gets a dedicated feature service. It is possible to have multiple utility networks from different services in the same map, but there are some known issues with some of the tools in the UI with that setup.

Re: Multiple Utility Networks in one SDE

Anumita — Fri, 06 Sep 2024 12:37:46 GMT

Thank you @RobertKrisher
Much appreciated!

Re: Multiple Utility Networks in one SDE

Lorne_Dmitruk — Wed, 02 Oct 2024 13:47:18 GMT

In addition to having separate users owning the schema in the database, would you also create a separate portal user to own each network or would a single user suffice?

Re: Multiple Utility Networks in one SDE

RobertKrisher — Wed, 02 Oct 2024 13:52:12 GMT

There's no technical limitation one-way or the other. That comes down to an organizational decision of whether you want a single portal user to administer both datasets.

Re: Multiple Utility Networks in one SDE

HariYeruva — Fri, 11 Oct 2024 00:47:48 GMT

A single Portal Utility Network Owner can simplify management for multiple utility networks with different database owners. But if security and isolation are crucial, using separate portal users is the way to go.

@RobertKrisher