topic Re: Connectivity Trace - Setting up combined condition barriers in ArcGIS Utility Network Questions

Connectivity Trace - Setting up combined condition barriers

Jens_Dalsgaard — Wed, 11 Dec 2024 14:22:01 GMT

Hi there

Need to do a connected trace stopping whenever encountering a low voltage cable or a low voltage overhead line.

ElectricLine::37::Low Voltage Underground Conductor::102::AC Underground LV
ElectricLine::6::Low Voltage Overhead Conductor::100::AC Overhead LV

This is done using condition barriers - in SQL I would create a query like

(ASSETGROUP = 37 and ASSETTYPE = 102) or (ASSETGROUP = 6 and ASSETTYPE = 100)

Using the GP tool I would set it up like this:

How do i know that ArcGIS does an (A and B) or (C and D) and not a A and (B or C) and D?

It's the first combination / query that I need.

Re: Connectivity Trace - Setting up combined condition barriers

MikeMillerGIS — Wed, 11 Dec 2024 22:23:08 GMT

You cannot group sql like that easily. I would suggest using a category.

Re: Connectivity Trace - Setting up combined condition barriers

Jens_Dalsgaard — Thu, 12 Dec 2024 14:08:39 GMT

Please elaborate.

How may I solve the need through Categories, Mike?

Re: Connectivity Trace - Setting up combined condition barriers

MikeMillerGIS — Thu, 12 Dec 2024 15:24:55 GMT

Network Categories are just tags of Asset Group/Asset Types. Just make a category and assign to all the AG/ATs that you want to stop your trace and then use that category as the condition barrier:

Re: Connectivity Trace - Setting up combined condition barriers

Jens_Dalsgaard — Thu, 12 Dec 2024 16:23:10 GMT

Of course, obviously. Should have seen this myself.

Despite this, do you see any arguments against adding an idea for allowing grouping as was my initial proposal?

Adding categories will work fine in this specific case, yet in may other cases it would seem unflexible.

Re: Connectivity Trace - Setting up combined condition barriers

MikeMillerGIS — Thu, 12 Dec 2024 16:37:18 GMT

The trace parameters do not support sql grouping, you have to rely on the AND and ORs, so it gets tricky to make a correct sql statement without group

Re: Connectivity Trace - Setting up combined condition barriers

Jens_Dalsgaard — Mon, 16 Dec 2024 15:57:56 GMT

Creating network categories and assigning these as relevant to asset types representing cables and overhead lines works out - to some extent.

For example - I have created a new network category Volue_LV_OHUG and have assigned this to low voltage cables and overhead lines asset types.

And setting up a named trace configuration doing a connected traced yet using this network category (Volue_LV_OHUG) as conditional barrier seems to work as intended. the trace stops at low voltage cables and overhead lines.

But if I create a named trace configuration (or simply perform a trace) downstream from a medium voltage trace starting point to continue into low voltage (because I want the low voltage part of the substation included in the trace result) yet using the same network category as a conditional barrier the trace still seems to continue into the low voltage grid.

What should I look for when debugging?

Re: Connectivity Trace - Setting up combined condition barriers

MikeMillerGIS — Tue, 17 Dec 2024 00:02:42 GMT

Jens,

If you want to provide a sample, I can help troubleshoot.

Re: Connectivity Trace - Setting up combined condition barriers

Jens_Dalsgaard — Tue, 17 Dec 2024 07:40:09 GMT

Certainly, I have sent you a mail allowing you to immediately test what works and what apparently seems to not to be working.

Re: Connectivity Trace - Setting up combined condition barriers

MikeMillerGIS — Tue, 17 Dec 2024 19:36:29 GMT

Jens sent me a sample dataset and was able to see what is going on.

The behavior is as designed.

When selecting a target tier in trace, the condition barriers and other parameters defined in the trace, are only applied to tracing the tier in the Tier parameter. The subnetwork definition of the target tier and all the tiers between Tier and Target tier are used. The user specified trace configuration is not applied to those tiers.