Latest Contributions by RobertKrisher

‎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)

‎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'"

‎10-03-2023

If all you want is the attachments, you can just pass in the feature and the association type ("attachment"). You only need to pass in the other information if you want to be more specific about the types of associations returned. You can find many example arcade expressions in the following github repository from Esri (Esri/arcade-expressions: ArcGIS Arcade expression templates for all supported profiles in the ArcGIS platform. (github.com)). There are 16 rules that include examples of using the featureSetByAssociation command and while most of them only pass in the feature and the association type you can find one example that makes use of the class name parameter here (although as I said I think you can use the simpler form of the function): arcade-expressions/popup/has_proposed_features.md at 801d086d4bdc6ad10ebb9c7fde9fdc7b4717a9c6 · Esri/arcade-expressions (github.com)

‎10-03-2023

Unfortunately, that's what I suspected was going to be the case. The version changes tool will show you all the edits that have been made in your version (including deletes), but it does not provide the ability to undo edits like the conflict management dialog does. In order to undo an edit, you would have to use the information found in the dialog to manually undo any edits (deleting creates, creating deletes, and reverting any changed values).

‎10-02-2023

You can use the version differences tool on the versioning toolbar/tab to see all the edits in the version (depending on whether you're talking about ArcMap or ArcGIS Pro). This dialog is very similar to the dialog shown during conflict resolution, and while it will definitely show you all the edited features and their original values, I'm not sure if it actually allows you to revert changes.

‎09-29-2023

As an update on this thread. Support for subtype group layers was added to the map viewer in ArcGIS Enterprise 11.1.

‎09-29-2023

@FenuxLabs Another approach is to use the Export Subnetwork or Trace tool to export the connectivity to a JSON file and use the resulting file to walk the graph. You can find a code sample of how to do this along with instructions over on this community article page: Parsing Utility Network Exports (esri.com).

‎09-25-2023

The correct approach for what you want to do is to use the ArcGIS API for Python. I was able to get around some of this by saving an existing utility network layer to a file, then opening it as a layer file, accessing the first layer in the file. But I ran into problems in getting the rest the tools to behave properly, especially since they don't get me the ability to set/clear locks as I discussed above.

‎09-21-2023

You can either manually create associations in the conversion by explicitly populating the C_Associations table with parent/child guids or you can use the Create Association Records tool to establish these relationships using spatial proximity.

‎09-21-2023

Switch the order of input/near parameters in your GP tool. You want the poles to each find their nearest road (then use the near_x and near_y), doing it the other way around means that each road will only find its nearest pole 🙂 Specifying a reasonable threshold is always a good idea. One of the biggest limitations of this approach is going to be how streetlights are captured in intersections (which street do they get assigned to?), but this approach will work well for long running stretches of road.

Online Status	Online
Date Last Visited	yesterday

My Ideas

Latest Contributions by RobertKrisher

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: Use of Arcade featureSetByAssociation

Re: Reject nonconflicting edits in a version

Re: Reject nonconflicting edits in a version

Re: Error to using the Map Utility Network Editor Runtime

Re: ForwardStar or something like that

Re: Using python to Validate Network Topology in a version

Re: How does containment get built in a new Sewer Utility Network

Re: Finding Gaps in Light Pole data

Re: Valid paths not routing upstream trace correct...

Re: Feedback on the Prune Branch History Tool

Re: Edit Widget: Create Feature function not displ...

Re: Asset Package - Change Asset Type Domain for a...

Re: Feedback on the Prune Branch History Tool

European Utility Network Community (UNC)

APAC Utilities Community of Practice