Latest Contributions by AnneSanta_Maria1

Thank you! I was over thinking it. List position is all that matters 🙂 ... View more

@RichardFairhurst I don't know where you have been all my ESRI life but this post is the best thing! I have a situation where the I want to modify "Example 2 - Transfer of Multiple Field Values between Feature Classes where there is a 1:1 Match between Field Sets", so that the it will run when the fields or columns are not a 1:1 match. Data for updating is coming from an excel table and will be used to update a feature service in Portal. Eventually, I want to create a tool for an end user to put in the excel table, the service to update, and set the join field, and potentially the fields to match for updating, but for now I am creating a notebook for the end user to enter information into. I am stuck on how to use a dictionary to update data in the feature service with nonmatching field names. I think I may be missing a critical step. I also wasn’t sure if I needed to use the field mapping tool from ESRI to match the fields or if the dictionary was sufficient. I may be completely off as well-my python lacks confidence. import arcpy import pandas as pd arcpy.env.workspace = “myworkspace” feature_class = “myservice” input_table= “myexceltable” table = pd.read_excel(input_table) join_field_excel = "fieldA" join_field_FC = "fieldA_differentname" feature_class_fields =arcpy.ListFields(feature_class) # Set the names of the Excel columns to update from table_columns = list(table.columns) #Create a dictionary mapping the Excel columns to the feature fields column_mapping = {"excelfield1": "matchingservicefield", "excelfield2":"matchingservicefield2"…..} ###field_mappings= arcpy.FieldMappings() #try: # for excel_column, fc_field in column_mapping.items(): # field_map = arcpy.FieldMap() # field_map.addInputField(feature_class, fc_field) # field_map.addInputField(input_table, excel_column) # field_mappings.addFieldMap(field_map) #except Exception as e: # print(arcpy.GetMessages()) try: with arcpy.da.UpdateCursor(feature_class,column_mapping.values()) as cursor: for row in cursor: id_value = row[join_field_FC] if id_value in table[join_field_excel].values: for excel_column,fc_field in column_mapping.items(): row[fc_field]=table.loc[table[join_field_excel]==id_value,table_column].values[0] cursor.updateRow(row) except Exception as e: print(arcpy.GetMessages())   ... View more

@XanderBakker I am responding to this a tad late, but it also refers to stacked polygons or any stacked features for that matter. If you have stacked polygons, say a building with three floors, and you want to return the value of only the current floor/room on that floor shown (that might be set by the floor picker in indoors or any definition query on a feature service) is that possible with arcade. This would be a dynamic component set by the editor. So lets say I wanted to place a point on the third floor of a building in room A, but ignore all the other floors in the feature class that exist below it. If I run intersect it only returns the value on the first record in the table, or seems to ignore the user set definition query. Any suggestions? ... View more

100% agree.  ... View more

Perfect! I will switch over to map viewer beta! I was using the wrong map viewer.  ... View more

1. Fields that don't work have different domains based on the subtype. The domains vary based on the subtype. So some subtypes have the domain electric device status Open/Closed and others have Electric Device State- Active/Inactive. The field is short integer, the domain is also a short coded value domain. 2. Defaults are set in the database configured at the subtype level - not in the feature template.  3. Pro Version 2.6.2 4. Yes it is all branch versioned. It cannot be published without branch versioning.  5. Next step would be to involve tech support.    ... View more

Thank you for your response. I had a hunch it wasn't possible, worth asking though. We've totally re-worked the utility network package, so this is just one way we are symbolizing items for the end user by asset group. The second screenshot related to compatible units was just a quick example, we aren't defining symbols based on this field currently.   ... View more

Essentially, what we are looking for is a way to retain that arcade script within the same layer and have that custom field we created be available from the attribute mapping drop down, that is without actually adding a field. So this symbology could be applied to other layers of any geometry type, since this expression is varying color based on an existing field in the attribute table. You can import the arcade expression to re-use it, but it's a pain to click through the dialog boxes to do so. For example in layer A, Electric Device, we symbolize by unique values using the field asset group. Then we want to apply attribute mapping to each symbol using the same custom arcade expression by walking through the steps to set attribute mapping. We write a custom arcade expression for that unique symbol and apply the expression. Next we want to apply that same expression to all the other unique symbols, but when we walk through the steps to set attribute mapping that custom arcade expression isn't in the drop down menu. You basically have to import the saved expression over and over. It would be nice if the software would remeber the custom attribute mapping information and save it in the dropdown. ... View more

Once you have set attribute mapping on one symbol in your unique values group, is there any way to have that custom attribute field appear in the drop down for all the other symbols?  For example, below, we have created a custom expression to vary color by the voltage level in the map. It then appears in the set attribute mapping box for that particular symbol. Is there anyway to have that custom symbol "field" carry across to other unique symbols without having to go through the trouble of opening the expression dialog box and importing that saved expression from a file?  Xander Bakker‌ ... View more

I will try that out, Thank you! ... View more

It took me some time to respond to this, but are there any examples out there of a similar attribute rule using Arcade, I've been able to find a few related to creating new features and associating information as outlined here: Advanced Attribute Rules – Creating Utility Network Associations with attribute Rules, but not much about calculations with existing features.  Also is there any way to mass associate content to their containers. So lets say we have 60 substations and each of those has associated content, is there any way to avoid having to click on each feature and just mass associate content by container. We are loading data into our asset package using the out of the box ESRI data loading tools and there is no way to do that beforehand. Manoj Patil ... View more