Latest Contributions by RobertKrisher

‎10-19-2023

One way to accomplish this would be to write an attribute rule that would run every time a feature is created to give it a unique ID using a sequence. Then what you can do is take that arcade expression and use it in the calculate field tool on this layer (just make sure you set the language to Arcade).

‎10-19-2023

While @AyanPalit is correct about being able to change the XY tolerance and resolution I would caution you against changing these values because they are permanent, and they can have unexpected consequences. If you're having issues with features not being connected in your network because of the resolution/tolerance of your source database, then the recommended approach is to include a process to snap and correct these features during your migration to the utility network (using FME or geoprocessing tools). This gives you an opportunity to experiment with different snapping tolerances so you can find the right tolerance that minimizes topology errors and manual cleanup, while also maximizes the number of features that are connected (appropriately).

‎10-18-2023

The associations widget isn't available in the standard map viewer, but there is a utility network associations widget available out of the box that you can add to your own custom applications. You can learn more about this widget and see the code samples associated with it on this page on developers.arcgis.com.

‎10-18-2023

1) Relationships can be configured to be 1:1, 1:M, or M:N. The cardinality of associations is determined by the feature restrictions of the utility network. 2) By default, associations are M:N. However, point features are only allowed to have a single container. You can learn more about how associations behave by reading the feature restrictions page I linked to above, or by referring to the specific pages for connectivity, containment, and attachment.

‎10-16-2023

This looks like it could actually be a lock escalation issue on the EID mapping table. I'd recommend you reach out to support and reference this knowledge base topic: Bug: Branch Versioned Editing May Encounter Locking, Blocking, and Deadlocking When the Da (esri.com). If it is a lock escalation issue then they can provide a workaround, although if you're applied all the latest utility network patches to your ArcGIS Pro client and ArcGIS Enterprise install then you shouldn't be running into this issue.

‎10-13-2023

There are typically two approaches taken: If you wish to draw each meter on the map, you would draw each meter as a device, connect each meter to a common electric junction (that is in turn connected to the LV line), and create a meter assembly to contain each meter device. If your organization is ok with representing all of this as a single location in your GIS than you would create an electric device (meter) in your network, then connect it to the LV line. If you wish to track individual meters in the GIS then you would create them as non-spatial electrical junction objects that are contained within the device. Ryan's approach is an alternative approach of this where they use a junction instead of a device and do not model the meters in the GIS (instead relying on a link to the CIS).

‎10-11-2023

If you want to get all the poles attached to fuses in your entire network, the fastest and easiest way to achieve this would be to select all your fuses then use the "select associated data" tool to select all the containers and structures for those fuses. This is a new tool added in ArcGIS Pro 3.1, but if you are using ArcGIS Pro 2.9 you can download the add-in on this page of the community site to achieve the same behavior.

‎10-09-2023

@MatheusSparapani specifically, if you're trying to run a downstream trace from the high side terminal of your transformer, and you've set up your subnetwork on the low side terminal of the transformer, it will return no results since there are no transmission controllers upstream of that point.

‎10-06-2023

The latest gas, water, sewer, and storm models do not include any definitions for non-spatial objects so you shouldn't need to worry about encountering any errors with non-spatial objects unless you have added them to your model. I have seen some utilities extend the model to represent co-located service locations using junction objects and containment, but this is not part of the standard model.

‎10-05-2023

There's a few optimizations that could be made to the script. First, instead of doing a "not in" check then getting the value, just use the .get method on the dictionary and return a default value of none and skip the row if you get the default value. This allows you to check for existence and get the value in a single call. Another optimization would be to check whether the existing value on the row already matches the lookup value. If the row already has the correct value you can then continue onto the next row without calling update on the cursor. In situations where you're going to be running this script repeatedly against the same table and only populating a handful of new rows each day this is a huge boost to performance (since you're not having to incur the cost to update/store each row when no value has changed).

‎10-04-2023

@DeepikaJain01 oh, that's your problem. You need to create all the objects in the asset package and populate the C_Assocations table with the foreign keys and other information in order to relate the objects. Setting the association status of a feature to be a container isn't sufficient, as it doesn't tell the system which features should be used as its content. The bug that Pierreloup described means that after you apply your asset package (with all your associations) that the associationstatus field will be out of sync.

‎10-03-2023

The association status field is a system- maintained field that will be populated automatically based on the types of associations present for a feature. When you say that there weren't any associations imported, were there any errors during the apply asset package process? Did you populate the C_Associations table in the asset package ahead of time? Are there any errors associated with your associations?

‎10-03-2023

In a file geodatabase the class name will not be qualified var assoList = featureSetByAssociation($feature, "attached"); for(var asso in assoList) console(asso); produces the correct result in a mobile geodatabase, but doesn't work in a file geodatabase. Here's an example of a result from a mobile geodatabase. {"geometry":null,"attributes":{"className":"ElectricJunction","globalId":"{0B531F4D-3886-4C8E-B4C0-2D85B8F7A7D1}","isContentVisible":0,"ObjectID":8730,"OID":8730,"percentAlong":0,"side":"","terminal":-1}} A "Mobile Geodatabase" is a sqllite database that is stored in a single *.geodatabase file. A File Geodatabase is a file-based structure contained in a folder with a .gdb extension. In a file geodatabase, I was able to get this expression to produce a result when a structure has a junction attached: var assoList = featureSetByAssociation($feature, "attached"); for(var asso in assoList) console(asso); var filterList = Filter(assoList, "className = 'main.ElectricJunction'"); console(count(filterList)); return count(filterList) RobertKrisher_0-1696371410762.png

‎10-03-2023

I recommend you download the utility network foundation for the communication's model and see how the Utility Network makes use of non-spatial objects, containment, and associations to model connectivity. The foundation includes sample maps, data, and a data dictionary to get you started. You can watch the following video for instructions on how to access these industry data models: https://mediaspace.esri.com/media/t/1_7zxo6ynq

‎10-03-2023

Agree with @VinceAngelo, I've been burnt many times by not testing my expressions in the application first and realizing I've made a mistake in my expression or pointed the tool at the wrong dataset. For reference, using a f"" to set your expression would look like the following: sql_exp = f"{delim_field} = 'Seaplane Base'"

Online Status	Online
Date Last Visited	8 hours ago

My Ideas

Latest Contributions by RobertKrisher

Re: How to automatically create ID for existing feature classes?

Re: Utility Network tolerance value

Re: Associations in web maps/apps

Re: Utility Network Associations and Relationships

Re: Enable Topology Error - ERROR 001872:

Re: HOW TO CONNECT LV SERVICES OF MORE THAN 40 FROM SAME BUILDING

Re: Utility Network Trace, Feature Selection

Re: Trace Error (No Valid Subnetwork controllers found)

Re: Utility network - non-spatial objects

Re: Database Auto-Population Using Python

Re: Import associations in Utility Network

Re: Import associations in Utility Network

Re: Use of Arcade featureSetByAssociation

Re: How can non spatial data be part of Utility Network in Telco

Re: Select tool ArcPy SQL expression

Re: How to sync my Utility network geodatabase wit...

Re: Pre UN migration data cleanup workflows

Re: Best practices for managing and validating Uti...

Re: Pre UN migration data cleanup workflows

Re: Can one web map hold two separate utility netw...

European Utility Network Community (UNC)

APAC Utilities Community of Practice