|
POST
|
Thank you all for the information and quick response. I will try the dictionary approach and let you know how it goes. just a little bit of background on that project, I am running the Near geoprocessing on my Route and Mile Markers (and the RouteID is updated with the OBJECTID of the route, that's why I have to go back and update that RouteID with the RouteName... same with my Mile Markers) Then I do two intersects (structures with Parcels and Structures with Counties)... that's why I have to go back and update the structure fields I need from the parcels and counties data. Thanks!
... View more
01-25-2023
07:29 AM
|
1
|
0
|
2649
|
|
POST
|
Hello, I have to update a feature class (16K records) based on four other feature classes. I am using the following code, which is working, but quite slow (about 35 min to complete). So, I was wondering if you guys could suggest some improvement to speed this up. Thanks! fieldsUpdate = ['OBJECTID','dr_Milepost','DR_distance_MP','Dr_Route','DR_DistanceFromRoute','DR_LANDOWNER_NAME','DR_PARCEL_NUMBER','DR_CountyName','DR_StateName']
fieldsM = ['OBJECTID', 'mile_post']
fieldsRoute = ['OBJECTID', 'id']
fieldsParcels = ['FID_Structures_NAD83_Update', 'LANDOWNER_NAME_1', 'PARCEL_NUMBER_1']
fieldsCounty = ['FID_Structures_NAD83_Update', 'CountyName_1', 'stateAbbr']
with arcpy.da.UpdateCursor(flStructure, fieldsUpdate) as cursorU:
for rowU in cursorU:
#Section to update the MilePost
strMatch = "OBJECTID =" + str(rowU[1])
#print(strMatch)
print("Mile post")
with arcpy.da.SearchCursor(flMilePost, fieldsM,where_clause=strMatch) as cursorM:
for rowM in cursorM:
print(u'{0}'.format(rowM[1]))
rowU[1] = rowM[1]
rowU[2] = rowU[2] * 3.28084
# Section to update the Route
print("Route")
strMatchRoute = "OBJECTID =" + str(rowU[3])
with arcpy.da.SearchCursor(flRouteLYR, fieldsRoute,where_clause=strMatchRoute) as cursorR:
for rowR in cursorR:
#print(u'{0}'.format(rowR[0]))
rowU[3] = rowR[1]
rowU[4] = rowU[4] * 3.28084
## Update using the intersect Parcels data
print("Parcels")
strMatchP = "FID_Structures_NAD83_Update ="+str(rowU[0])
with arcpy.da.SearchCursor(flParcels+"int", fieldsParcels,where_clause=strMatchP) as cursorP:
for rowP in cursorP:
rowU[5] = rowP[1]
rowU[6] = rowP[2]
## Update using the intersect County data
print("County")
strMatchC = "FID_Structures_NAD83_Update =" + str(rowU[0])
with arcpy.da.SearchCursor(flCounty+"int", fieldsCounty,where_clause=strMatchC) as cursorC:
for rowC in cursorC:
rowU[7] = rowC[1]
if rowC[2] == 'SD':
rowU[8] = 'South Dakota'
elif rowC[2]== 'ND':
rowU[8] = 'North Dakota'
elif rowC[2]== 'NE':
rowU[8] = 'Nebraska'
elif rowC[2]== 'MN':
rowU[8] = 'Minnesota'
elif rowC[2]== 'IA':
rowU[8] = 'Iowa'
else:
rowU[8] = ''
cursorU.updateRow(rowU)
... View more
01-24-2023
09:07 PM
|
0
|
8
|
2718
|
|
POST
|
That is a nice tool, thanks for sharing. Unfortunately for me, seems like the webhook is triggered between 2 and 4 minutes (did 5 tests) which are consistent with I was getting within Power Automate. I will contact Support tomorrow. Thank you and I will update the post when I get more info. D
... View more
01-12-2023
02:59 PM
|
0
|
2
|
2997
|
|
POST
|
I have no Fix Connections next to it, and both of my flows are using the same connection
... View more
01-12-2023
12:59 PM
|
0
|
0
|
3055
|
|
POST
|
Hello I have to Power Automate flows that are very similar (one is based on a polygon HFL and the other one is a point HFL). Both layers have a refresh interval set to 0.5 MIN. Both layers have a web hook that has been created while building the flows using he ArcGIS Connector, and the frequency is set at 30 sec So my issue is: When I update a polygon record, the flow is triggered immediately (boom! fast). BUT when I update a point record, it takes 2 minutes for the flow to trigger What am I missing? Thank you!
... View more
01-12-2023
12:45 PM
|
0
|
6
|
3061
|
|
POST
|
Well that's what I was thinking at first, but the time run is the same, no additional minutes. Then a friend of mine observed the same behavior on his AGOL starting January 3rd. Like me, he has scheduled Notebooks that have been setup since last November, nothing has changed since then. and his credit usage has ramped up as well. So, it has to be something else...
... View more
01-11-2023
07:45 AM
|
0
|
1
|
2096
|
|
POST
|
Hello I have a few Notebooks (4) that are scheduled to run using the Task functionality (some every 15 min, some once a day). They have been setup in 2022 around August. Today I was looking at the Credits Report in AGOL and noticed that my credit usage for Notebooks have increased a lot since January 3rd 2023. Did ESRI changed their Notebook usage policies?
... View more
01-11-2023
06:24 AM
|
0
|
4
|
2120
|
|
POST
|
I am experiencing the same issue on IOS 22.4.2 (build954) this functionality used to be working just fine and same as @RichSiko our field crews are relying on those URLs to pull asbuilt, service cards, etc.) it will works if you only have ONE media ... if you have multiple ... not working. I could create Arcade expressions but I would rather have the original functionality back PLEASE ESRI get this fix ASAP
... View more
12-23-2022
08:18 AM
|
0
|
0
|
6104
|
|
POST
|
Hello I have a flow in Power Automate that pull data from a Dataverse table, and update a hosted feature layer on AGOL. Everything seems to be working fine EXCEPT for my Date fields. below is what is the payload form Dataverse { "@odata.editLink": "cr3c3_coa_projectses(a85d55b7-1f82-ed11-81ac-000d3a37d89e)", "cr3c3_coaprjstartdate@OData.Community.Display.V1.FormattedValue": "12/22/2022 6:00 AM", "cr3c3_coaprjstartdate@odata.type": "#DateTimeOffset", "cr3c3_coaprjstartdate": "2022-12-22T06:00:00Z", "_cr3c3_coaemployee_value@OData.Community.Display.V1.FormattedValue": "Dominic Roberge", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "cr3c3_coaEmployee", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.lookuplogicalname": "cr3c3_coa_stafflist", "_cr3c3_coaemployee_value@odata.type": "#Guid", "_cr3c3_coaemployee_value": "b302e0c1-2082-ed11-81ac-000d3a37dbf1", "cr3c3_coa_projectsid@odata.type": "#Guid", "cr3c3_coa_projectsid": "a85d55b7-1f82-ed11-81ac-000d3a37d89e", "statecode@OData.Community.Display.V1.FormattedValue": "Active", "statecode": 0, "statuscode@OData.Community.Display.V1.FormattedValue": "Active", "statuscode": 1, "_createdby_value@OData.Community.Display.V1.FormattedValue": "Dominic Roberge", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_value@odata.type": "#Guid", "_createdby_value": "14855649-5267-ed11-9561-000d3a37d89e", "cr3c3_coaprjname": "test revised no staff", "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "createdon@OData.Community.Display.V1.FormattedValue": "12/22/2022 5:40 PM", "createdon@odata.type": "#DateTimeOffset", "createdon": "2022-12-22T17:40:26Z", "cr3c3_prjuid": "7", } the 4th line has the data I am looking for to update my date field in AGOL. below is the error I am getting I have tried adding aFormatDateExpression (FormatDateTime(outputs('Get_a_row_by_ID')?['body/cr3c3_coaprjstartdate'],'MM-dd-yyyy')) but still no success. Any help would be much appreciated. Thanks!
... View more
12-22-2022
12:51 PM
|
0
|
10
|
6013
|
|
POST
|
hello everyone sorry it took so long, I had open a ticket with ESRI Support regarding this issue and they finally created a BUG as they were able to replicate the issue: Bug Number: BUG-000154427 Synopsis: The Arcade expression configured in a form within a web map does not get honored in Map Viewer Any ideas how I could generate a unique ID automatically? Thanks!
... View more
12-13-2022
12:22 PM
|
0
|
0
|
6257
|
|
POST
|
Thanks for the info. However when the expressio is enabled, I can't click the Create Feature button. when I test the expression it seems to be working if I disable the expresssion, then I can Create feature What am I missing? I also tested the process on a different HFL and different web map and same result.
... View more
11-24-2022
06:08 AM
|
0
|
1
|
6318
|
|
POST
|
Hello I started playing with the ArcGIS connector as well and kept getting the same error as listed in the original message. I was using a Hosted Feature Layer with a relationship class (was published from a FGDB). Then I tested the same workflow with a HFL published from FGDB but no relationship and it worked. Could it be the problem?
... View more
11-23-2022
09:14 AM
|
0
|
1
|
6695
|
|
POST
|
Hi Johannes thanks for helping me on this. I modified my expression accordingly and when I tried it in the web map.... nothing.... Then I decided to try it in the Field Maps app and it was working just fine (new record and updating existing record). I then tried to create and Experience Builder app to see how it would behave... same as web map, Empty FUID field. Any idea why it's not working properly in the web map? For this project, my users will enter/modify data either through a web map or experience builder app. Thanks!
... View more
11-23-2022
07:24 AM
|
0
|
3
|
6326
|
|
POST
|
Hello I have the following Arcade code to create a new Unique ID on a feature layer (hosted on ArcGIS Server). It's working fine for a NEW record, but if I try to select an existing record, it will update the UID field with the next available number. How can I avoid to overwrite an existing value? Thanks for any help you could provide. D var fs=FeatureSetByName($datastore,'dr_testPts',['FUID'],false);
var cCurrentFUID = $feature.FUID
var fFilter = Filter(fs, 'FUID IS NOT NULL');
var fMax = 0
var tMax = 0
for (var k in fFilter){
fMax = Max(Right(k.FUID, Count(k.FUID)-3))
tMax = When(fMax>tMax,fMax, tMax)
}
tMax +=1
var vNewFUID = "EOC" + text(tMax, "00000")
if (IsEmpty(cCurrentFUID)){
return vNewFUID
} else {
return cCurrentFUID
}
... View more
11-22-2022
12:10 PM
|
1
|
14
|
7943
|
|
POST
|
Hello Everyone Any updates on this BUG? I get the same error message but not on all web maps I am trying to load into Teams....
... View more
11-09-2022
06:14 AM
|
0
|
0
|
3943
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-26-2026 01:47 PM | |
| 1 | 08-05-2024 06:19 AM | |
| 1 | 06-11-2025 08:07 AM | |
| 1 | 07-13-2025 04:58 PM | |
| 1 | 02-27-2025 08:13 AM |
| Online Status |
Offline
|
| Date Last Visited |
3 weeks ago
|