BLOG
|
Thank you! I was over thinking it. List position is all that matters 🙂
... View more
12-05-2022
09:19 AM
|
0
|
0
|
653
|
BLOG
|
@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
12-05-2022
06:15 AM
|
0
|
0
|
669
|
POST
|
We are working with ArcGIS Indoors and have the appropriate licensing set up. We have published a service and map from Pro with our ArcGIS Indoors layers configured for a college campus. We have also set up a web map with the indoors items properly configured, sites, facilities, levels etc. So now we would like to work with indoors configured layers to map items within buildings. Let's say we have a service with AEDs, fire extinguishers, fire access roads, etc. This is fictional data for explanatory purposes. We have several layers in the service, but only one/two items that actually need to be floor aware. It's easier to manage the service if all the items that are related are actually in the service. I don't need five different services for each layer. When I publish the service I make sure to set that the AED's have the proper configuration for indoors and the floor field set to Level_ID. When that service is published that information is dropped. So now I have to open the Indoors configured map in Pro and then add the service with the AEDS (or any service that has the floor aware data) and reset the level ID and share a new map. It all has to be done in Pro. You have to use the feature service or add the individual item from the map image layer to make the items behave correctly in the web environment. By behave correctly I mean make the items floor aware and have the floor widget appear in the web mapping or field mapping environments. This is a painful workflow compared to what was possible previously. https://community.esri.com/t5/education-blog/quot-so-do-i-need-arcgis-indoors-to-have-an-indoor/ba-p/1075674 We will be expanding indoors to map hundreds of interior assets over the next several years. My question is 1) is this the best workflow to create and handle indoors map configuration? Is there the possibility of streamlining the process? Is there a way for map image layers to hold the indoors configuration? Are we using the correct process? @JasonHine
... View more
07-18-2022
09:48 AM
|
1
|
1
|
381
|
POST
|
@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
04-05-2022
04:52 AM
|
0
|
2
|
2212
|
POST
|
Perfect! I will switch over to map viewer beta! I was using the wrong map viewer.
... View more
05-12-2021
06:26 AM
|
0
|
0
|
949
|
POST
|
Is it normal for field maps to reset, or not respect changes that have been made to the map the field map is based on? We are working from an enterprise environment (10.8.1) and have services published to portal. I have created a web map and have editable layers in the map. I have set up a form in field maps with all of my questions ordered, grouped, and rephrased. I have made changes to the online map requested by end users. Then I return to field maps and open that map. When I review the form for items in that map everything has been reset and the changes and form set up are no longer shown. I have to recreate everything. Is this an expected pro
... View more
05-12-2021
06:14 AM
|
0
|
3
|
957
|
POST
|
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
11-23-2020
08:09 AM
|
0
|
1
|
3308
|
POST
|
Good Morning, We are working with the utility network and are having trouble keeping feature templates to hold between the map we are publishing from and the feature layer/service. We have feature templates created for all the layers in our initial map based on subtypes. When we publish the feature service and bring that back into ArcGIS Pro some of the templates are not holding their default values. See below. Below is the feature template for the layer Electric Device in the initial map we publish to our portal from, the defaults are holding. After publishing the service we bring the feature layer Electric Device back into a new map in ArcGIS Pro and some of the defaults in the feature template are no longer holding. See the image of the template below. If we delete all templates on the feature service layer in ArcGIS Pro and re-create the templates the defaults come back. But this should not be something we have to do for each layer every time we might need to change something. Has anyone run across this issue and have any suggestions to solutions?
... View more
11-23-2020
05:51 AM
|
0
|
11
|
3728
|
BLOG
|
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
11-09-2020
04:57 AM
|
0
|
0
|
5871
|
BLOG
|
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
11-02-2020
11:35 AM
|
0
|
0
|
5871
|
BLOG
|
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
10-26-2020
05:45 AM
|
0
|
0
|
5871
|
POST
|
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
09-18-2020
03:47 AM
|
0
|
2
|
1393
|
POST
|
Good Morning, As we continue down our road map to implementing a utility network with our electrical system, we have run into a question about containers. Is there any way for all objects in a container to inherit the asset name or information of that container? So if we have a collection of assemblies, devices, and lines that reside in Substation 0001, can all those assets in the container inherit the name Substation 0001. Honestly, this is something the end user is asking about and may not be best practice in the utility network, but I am still so new to figuring out the ins and outs of the utility network that I am not sure what is and is not best practice. Thanks.
... View more
09-01-2020
04:23 AM
|
0
|
4
|
1486
|
Title | Kudos | Posted |
---|---|---|
1 | 07-18-2022 09:48 AM | |
2 | 05-22-2020 05:22 AM | |
2 | 08-19-2020 07:59 AM | |
1 | 08-19-2020 05:29 AM | |
1 | 07-24-2020 11:47 AM |
Online Status |
Offline
|
Date Last Visited |
12-05-2022
05:37 PM
|