Latest Contributions by Billy

‎08-01-2020

Hi, Is it possible to create cascading select in Survey123 with overlapping option? The image shows choices. As the image shows there are multiple options that have overlapping options when filtered. This is the code that I add to the "choice_filter" column: single_polemount=${transformer_type} or three_polemount=${transformer_type} or single_padmount=${transformer_type} or three_padmount=${transformer_type}

‎06-17-2020

Hi Robert, What would be the benefit of doing what you propose?

‎05-29-2020

Good to know. Thanks for the suggestion.

‎05-29-2020

Hi Xander, As you mentioned, we agree that the benefits of the UN worth the effort. At this point, we have created our data dictionary, selected the Tiers, AG/AT (AssetGroup/AssetType), and related tables that we need. Also, we deployed the Electric Utility Network asset package with the sample data (as a testing environment) and deployed the same asset package with the schema only and the special reference changed to our location (our project environment). Since we don't have GIS quality data to import directly to the UN, we have to basically draw the network one pole at a time, with the help of group and preset templates. But we have decided to start by creating all the substations, then the interconnecting lines between them, and finally the distribution circuits and the other assets (transformers, junction box, street lights, etc) Also we're are taking our time to clean and transform the data that will be added to the UN, which will be added to the features using Arcade rules. Thanks again for your comments and suggestions. Here are my comments: Your first point is very valid. I'll adjust the script accordingly. For you second point, the rule is triggered by insertion. The type of assets (poles, junction box and hanholes) that will be using this rule to generate their assetid are not usually moved, so they will have that number until they are removed from the field. In reality, this id is acting more as a location id than an asset id, because the id will survive the asset. If a pole is replace at the same location, the new pole will get the same assetid. We know that this is not ideal from the point of view of asset management, but we will address this with an asset management system link to the GIS. Regarding your blog: Aqui se hable español. Lo leere con detenimiento, sole le di una hojeada. I'm incrementing the distance, because we want to keep the id length to 6 characters. I was using the postfix as a print to console alternative. If Arcade had a development environment with step-by-step debugging and variables inspection, it would be easier to debug. I thinking something like what MS Office has for VBA. Regards.

‎05-29-2020

Hi Xander, When we were reviewing the different ways to create an assetid we tested the NextSequenceValue option, but we want to have an assetid code that would have some meaning, not just any random number. Our new assetid code has the information about the district where the asset it located and the distance from a reference point. Maybe you would wonder why someone would need that since you can get that information from the map, but when you are jumping from paper maps to digital maps with the utility network, this king of transition is not easy for everybody. Our current assetid system for poles is not database friendly (a lot of duplicate numbers) but it's very intuitive for the people in the field. With our implementation of the utility network we decided to change our current assetid system, but we want to replace it with something that will convey some information for the people in the field when they are not using the digital map. I share your concern about performance with the nested for-loops and growing data volume, that's why I was wondering if there was another method. Right now we have less than 10K poles, but we don't expect that that number will increase beyond 10K. Yesterday, I came to the same conclusion that you are suggesting and this is the new rule: The rule performance, in the test environment, with the ~10K poles on the map is almost the same that we experience when the rule was not checking for duplicate values, so it looks like performance won't be an issue. But we still have to test it in the production environment, where we are adding the poles with a group template that includes other features (lines, electric attachment and street lights) Since the assetid generated by the rule includes a "prefix" (pole district), I'm thinking that maybe filtering the pole class by the "prefix", to reduce the dataset being tested for duplicates, could make the rule more efficient. What do you think? Also, I still wonder why the first rule didn't work, even if it's not very efficient. Thanks.

‎05-28-2020

Hi, I have an Arcade rule that generates an assetid when a point is inserted. This code is generated by measuring and rounding the distance, in feet, of the inserted point feature from a fix reference point. The process could generate repeated assetids for point features that are located at the same distance from the reference point. Therefore, I'm trying to compare the new assetid with the existing ones using 2 for loops, with the code shown below. The code tries to compare the new assetid against all the existing (inner loop), if there is a duplicate then change the new assetid, compare again, and if there is no duplicate then exit the outer loop. The rule is not work. It never enters the if statement inside the inner loop, see code below. I purposely created duplicate assetids, as you can see in the pic below. Tried adding a point and saving the edit, then adding another one and saving again, in case the Arcade rule was not seeing the repeated assetid until the edits have been saved; but that didn't work. Is there something wrong on the code or there is a better and more efficient way to do this?

‎05-28-2020

Good to know. Thanks John.

‎05-27-2020

Hi Michael, Thanks for the suggestion. This could be an alternative to what I'm trying to do. Also, it could have other applications as well.

‎05-27-2020

Hi Paul, Thanks for the reply. I had an error in the table's rule code and that was the reason it was not working like I expected, but after the correction the rule in the related table was triggered by returning a dictionary adding records to the table from the feature rule, as you indicated above. I've been trying to do something else with Arcade in the electric utility network (Arcgis Pro 2.5, UN 3.3, Arcgis Enterprise 10.8), but I'm not sure if it's possible. I have a group template with a pole (main feature of the template), electrical attachment and a medium voltage line. The group template also creates the attachment association between the pole and the electrical attachment. I have an Arcade rule in the pole feature that tries to update the data in the electrical attachment returning a dictionary when the group template is inserted. To ID the electrical attachment associated with every pole I'm using FeatureSetByAssociation (https://www.esri.com/arcgis-blog/products/utility-network/data-management/featuresetbyassocaitions-new-utility-network-a… ) But this function is not returning any feature set associated with the pole. The question then is if the associated features are available to the Arcade rule when the group template is being inserted? I was able to use FeatureSetByAssociation after the group template was created, triggered by an update to the pole, and the rule was able to ID'ed the electrical attachment.

‎05-24-2020

Hi, I'm trying to use an Arcade calculation attribute rule in a line feature to add records to a related table. The related table also has an Arcade calculation attribute rule that I want to be triggered when the line feature rule adds the records to the table. Additionally, the rule in the table will use data added by the rule in the line feature in the calculation. So far, the rule in the line feature to add the records to the related table is working, but it looks like the rule in the table is not being triggered by the added records. Is this cascading of rules possible in Arcade? Regards.

‎04-17-2020

Hi, I've been looking for documentation explaining the process to add new asset type in the Utility Network, but I haven't found any details for doing this other that simple updating the attribute domain assigned to the Asset Type field at the subtype level. Here is the list of steps that I had to do to update the attribute domain, many of them not mentioned in the documentation, and at the end the ElectricNetworkEditor map using the utility network service didn't show the new asset type: Disabled the network topology. To update other attribute domains I didn't have to do this, but the first time that I tried updating the domain asset type with the topology enabled I got an error. Important detail not mentioned any where in the documentation available. Stop the service for the utility network web layer to unlock the tables and be able to update the domain with the asset type of interest. Added the new code and description to the asset type domain following the recommendation to use a unique code to avoid code conflict with existing asset types in other subtypes. Save the changes to the domain. Since the domain was already assigned to the Asset Type field at the subtype level, I didn't re-assigned the domain to the Asset Type field. When updating other attribute domains I never had to re-assigned the domain to the field to see the changes, so I followed the same logic. Re-started the service and enabled the network topology. Went to the Asset Group with the modified Asset Type, but the new asset type was not available. Tried update the symbology but the new code for the added asset type was not available there either. Went back to the database connection to check if the changes to the domain asset type were saved, and that was positive. Disable the topology again, and ran the tool "Assign Domain to Field" to force the updated domain to the subtype and field of interest. The tool ran without error. Re-enable the topology. Then checked the layer again for the new asset type, but nothing changed. Refreshed the database connection. Also, re-set the data source for all the layers on the map. Still no new asset type appeared. The pictures below show some of the steps in Arcgis Pro. Picture showing the modified domain. Picture showing the domain assigned to the asset type field at the subtype level, also the asset group on the map doesn't reflect the new asset type (LV Handhole). The Electric Utility Network Foundation advance modelling considerations has this information about asset types: From the Utility Network configuration documentation:

‎04-16-2020

Hi Michael, Thanks for you answer. You are right, I was using the ElectricNetworkEditor solution when I tried to add the new fields, and this solution works with the Utility Network service. My reasoning was that the ADD FIELD geoprocessing tools would be able to access the database, since the documentation of the tool doesn't indicate otherwise. I think that this tool and the others in the Fields Tools group could benefit from the addition of more details about the source of their inputs. In the interest of giving more details, this is what I learned from Alex (Esri Technical Support) to be able to add the fields: First stop the service for the utility network web layer with the server manager, otherwise the tables in the database will locked. Since I had already established the database connection, in the catalog pane, I expanded the Utility Network Dataset and right click on the feature class where I needed to add the fields, then in the pop-up menu I clicked on Design > Fields, to open the fields view. Now the fields view didn't show the message that it was "read-only", and I proceeded to add the fields and save the changes. Finally, I re-started the web layer service in the server manager. After this, the NetworkEditor map layer reflected the added fields. In summary, to add, modify or assign: Fields, Domains, Attribute Rules, Contingent Values or Subtypes; the web layer service has to be stop, then make the changes through the database connection. Thanks.

‎04-12-2020

Hi, I'm using ArcPro 2.5, Electric Utility Network Asset Package 3.3, and SQL Database. The Asset Package was deployed with the sample data and publish to the portal. Now when I try to add or modify a field or domain I see this warning: "Table or feature class corresponding with this view is read-only" and "The domains for this workspace are read-only". Is this the way this should work when working with a Utility Network? or Is there something that is blocking the access? I can't find any documentation or previous question regarding this and the message doesn't say way or has a link to a documentation explaining why. I also tried with the "Add Field" tool, but I also got an error, see picture below. The error message is not very specific.

‎03-12-2020

Hi, Version 2.5 of Arcgis Pro and the Utility Network Package Tools now allow the deployment of the Utility Network Foundation in a file geodatabase, in addition to the deployment to an enterprise geodatabase. This is a very welcome functionality but it would be more useful if the Electric Network Editor could work with the Utility Network deployed in to the file geodatabase as well. The Electric Network Editor safe a lot of time and already comes with all the symbology for the asset types.

‎03-06-2020

Hi, The ESRI provided electric utility network fundation doesn't include a low voltage electric meter as part of any of the Asset Groups in the Device Class. There is a Low Voltage Service Asset Group but it's not for meters. Then, what is the recommended practice if we need to add meter data to the model? Would it be to create a relationship class and connect the Low Voltage Service features with a standalone table with the meters data? Or, create a new asset group/asset type for meter? And, what would be the best option if we want to implement an Outage Management System (OMS) using this model as a foundation?

Online Status	Offline
Date Last Visited	‎05-30-2024 04:54 PM

My Ideas

Latest Contributions by Billy

Survey123 Overlapping Cascading Select

Re: Check for Duplicate AssetID Values with Arcade

Re: Check for Duplicate AssetID Values with Arcade

Re: Check for Duplicate AssetID Values with Arcade

Re: Check for Duplicate AssetID Values with Arcade

Check for Duplicate AssetID Values with Arcade

Re: Create an Attribute Rule in Arcade that Trigger Another Arcade Rule in a Different Feature?

Re: Create an Attribute Rule in Arcade that Trigger Another Arcade Rule in a Different Feature?

Re: Create an Attribute Rule in Arcade that Trigger Another Arcade Rule in a Different Feature?

Create an Attribute Rule in Arcade that Trigger Another Arcade Rule in a Different Feature?

Can't add asset type to the Electric Utility Network

Re: Can't Add Field or Modify Domain in Electric Utility Network Sample Asset Package

Can't Add Field or Modify Domain in Electric Utility Network Sample Asset Package

Electric Network Editor for Utility Network in File Geodatabase

What is the Recommended Practice to Track Electric Meters in the Utility Network

Make Switching between Markup Layers More User Fri...

Error DBMS table not found [UN_6_Associations] Whe...

Re: Only Allow Edits to Repeat

Re: Restrict or Track Records Deletion on the WebA...

Copy Pictures Taken with Field Maps to Utility Net...