|
POST
|
Hello PA group another dumb question: Why do I have so many ArcGIS Connections listed in in Power Automate? and each time my flow has a "disconnected connection" the only way to get the flow going again is to Add a new connection. I must be doing something wrong here... Any advice on this issue of mine would be much appreciated. Thanks!
... View more
02-07-2023
08:24 AM
|
0
|
3
|
1164
|
|
POST
|
Yeah I am not sure as I believe this article was for the Old Story Map (Story Map Classic) . Not sure how the new Story Map would do the same. Sorry I can't help you more here. Good luck!
... View more
02-03-2023
12:24 PM
|
0
|
1
|
11781
|
|
POST
|
Hi Katy, I do have a storymap embed in HTML https://gis.cityofames.org/amesconstruction/index.html try this HTML code: (replace the src with the link to your own story map) <!DOCTYPE html>
<html>
<script type="text/javascript">
var http = new XMLHttpRequest();
</script>
<head>
<meta charset="utf-8" />
<title>City of Ames Construction Projects</title>
</head>
<body style="margin:0px;padding:0px;overflow:hidden">
<iframe frameborder="0" style="overflow:hidden;overflow-x:hidden;overflow-y:hidden;height:100%;width:100%;position:absolute;top:0px;left:0px;right:0px;bottom:0px" height="100%" width="100%"
src="https://storymaps.arcgis.com/stories/58266c1834d844a8ab354dca3ecdd638"></iframe>
</body>
</html>
... View more
02-03-2023
10:59 AM
|
1
|
3
|
11787
|
|
POST
|
I solved the problem. I had to convert the INPUT date value to EPOCH using the following expression div(sub(ticks(outputs('Get_a_row_by_ID')?['body/cr3c3_coaprjenddate']),ticks('1970-01-01Z00:00:00')),10000) This ArcGIS Connector is a game changer 😁
... View more
01-31-2023
07:23 AM
|
1
|
8
|
3583
|
|
POST
|
Hi, I created a web map to edit a few feature classes, and attributes. I have a Date Field, but in Web Map, there's no Date Picker anymore? If I use the same map in Web Map Classic I do have the date picker and it's working fine in Field Maps as well.... JUST NOT WORKING IN NEW WEB MAP... Am I missing something? Thanks! D
... View more
01-30-2023
07:44 AM
|
0
|
3
|
1006
|
|
POST
|
that was it: I add a cast to int and everything started working as expected. Thank you so much for all your help D
... View more
01-25-2023
09:06 PM
|
0
|
0
|
1681
|
|
POST
|
Hey Jeff Your solution saved me a bunch if time, thank you. However, I have an issue with only ONE dictionary section (the Route data). The code returns None all the records, but the dictionary has the value related to the specific record ONLY THE ROUTE section return None for every records value returned by Dictionary ({10299: {'OBJECTID': 10299, 'id': 'IAL-331'}, 10300: {'OBJECTID': 10300, 'id': 'NEL-309'}, 10301: {'OBJECTID': 10301, 'id': 'NEL-312B'}, 10302: {'OBJECTID': 10302, 'id': 'NEL-314'}, 10303: {'OBJECTID': 10303, 'id': 'NEL-313'}, 10304: {'OBJECTID': 10304, 'id': 'SDT-208'}, 10305: {'OBJECTID': 10305, 'id': 'SDT-207'}, 10306: {'OBJECTID': 10306, 'id': 'SDL-336'}, 10307: {'OBJECTID': 10307, 'id': 'SDT-209'}, 10308: {'OBJECTID': 10308, 'id': 'SDL-335'}, 10309: {'OBJECTID': 10309, 'id': 'SDT-210'}, 10310: {'OBJECTID': 10310, 'id': 'NDT-211'}, 10311: {'OBJECTID': 10311, 'id': 'MNL-321A'}, 10312: {'OBJECTID': 10312, 'id': 'IAT-205'}, 10313: {'OBJECTID': 10313, 'id': 'SDL-320'}, 10314: {'OBJECTID': 10314, 'id': 'SDT-206'}, 10315: {'OBJECTID': 10315, 'id': 'NEL-333'}, 10316: {'OBJECTID': 10316, 'id': 'NEL-310'}, 10317: {'OBJECTID': 10317, 'id': 'NEL-312A'}, 10318: {'OBJECTID': 10318, 'id': 'NDL-324'}, 10319: {'OBJECTID': 10319, 'id': 'NDL-325B'}, 10320: {'OBJECTID': 10320, 'id': 'NDL-327A'}, 10321: {'OBJECTID': 10321, 'id': 'NDL-323'}, 10322: {'OBJECTID': 10322, 'id': 'NDL-326'}, 10323: {'OBJECTID': 10323, 'id': 'MNL-321B'}, 10324: {'OBJECTID': 10324, 'id': 'NDL-325A'}, 10325: {'OBJECTID': 10325, 'id': 'NDL-327B'}, 10326: {'OBJECTID': 10326, 'id': 'NEL-316B'}, 10327: {'OBJECTID': 10327, 'id': 'NEL-316A'}, 10328: {'OBJECTID': 10328, 'id': 'NEL-315'}, 10329: {'OBJECTID': 10329, 'id': 'IAL-318A'}, 10330: {'OBJECTID': 10330, 'id': 'SDM-104B'}, 10331: {'OBJECTID': 10331, 'id': 'SDM-105B'}, 10332: {'OBJECTID': 10332, 'id': 'NDM-106'}, 10333: {'OBJECTID': 10333, 'id': 'SDM-105A'}, 10334: {'OBJECTID': 10334, 'id': 'NDL-328'}, 10335: {'OBJECTID': 10335, 'id': 'SDM-104A'}, 10336: {'OBJECTID': 10336, 'id': 'IAL-318B'}, 10337: {'OBJECTID': 10337, 'id': 'IAL-329'}, 10338: {'OBJECTID': 10338, 'id': 'IAT-201'}, 10339: {'OBJECTID': 10339, 'id': 'IAT-202'}, 10340: {'OBJECTID': 10340, 'id': 'IAL-306'}, 10341: {'OBJECTID': 10341, 'id': 'IAM-102'}, 10342: {'OBJECTID': 10342, 'id': 'IAM-103A'}, 10343: {'OBJECTID': 10343, 'id': 'IAT-203'}, 10344: {'OBJECTID': 10344, 'id': 'MNL-305'}, 10345: {'OBJECTID': 10345, 'id': 'MNL-303B'}, 10346: {'OBJECTID': 10346, 'id': 'IAL-308A'}, 10347: {'OBJECTID': 10347, 'id': 'IAT-204B'}, 10348: {'OBJECTID': 10348, 'id': 'IAM-101B'}, 10349: {'OBJECTID': 10349, 'id': 'IAL-301B'}, 10350: {'OBJECTID': 10350, 'id': 'IAM-103B'}, 10351: {'OBJECTID': 10351, 'id': 'MNL-303A'}, 10352: {'OBJECTID': 10352, 'id': 'IAL-301A'}, 10353: {'OBJECTID': 10353, 'id': 'LITTLE SIOUX CAPFAC'}, 10354: {'OBJECTID': 10354, 'id': 'IAL-340'}, 10355: {'OBJECTID': 10355, 'id': 'IAM-101A1'}, 10356: {'OBJECTID': 10356, 'id': 'IAM-101A2'}, 10357: {'OBJECTID': 10357, 'id': 'IAL-302B'}, 10358: {'OBJECTID': 10358, 'id': 'IAL-308B'}, 10359: {'OBJECTID': 10359, 'id': 'MNL-304'}, 10360: {'OBJECTID': 10360, 'id': 'IAT-204A'}, 10361: {'OBJECTID': 10361, 'id': 'IAL-302A'}, 10362: {'OBJECTID': 10362, 'id': 'MNL-337'}}) this is what that UpdateCursor returns: before 30833, 58150, 617.5505629486523, 10346, 610.630249122789, 0, 0, 0, 0 MP dict value: {'OBJECTID': 58150, 'mile_post': 73.6} Route dict value: None Parcels dict value: None County dict value: {'FID_Structures_NAD83_Update': 30833, 'CountyName_1': 'Crawford', 'stateAbbr': 'IA'} after 30833, 73.6, 2026.0845889444565, 10346, 610.630249122789, 0, 0, Crawford, Iowa with arcpy.da.UpdateCursor(flStructure, fieldsUpdate) as cursorU:
for rowU in cursorU:
print(u'before {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}'.format(rowU[0],rowU[1],rowU[2],rowU[3],rowU[4],rowU[5],rowU[6],rowU[7],rowU[8]))
strMatch = milepostDct.get(rowU[1],None)
print("MP dict value: " + str(strMatch))
if strMatch:
rowU[1] = strMatch['mile_post']
rowU[2] = rowU[2] * 3.28084
strRoute1 = rteDct.get(rowU[3], None)
print("Route dict value: " +str(strRoute1))
if strRoute1:
rowU[3] = strRoute1['id']
rowU[4] = rowU[4] * 3.28084
strParcel = parcelDct.get(rowU[0], None)
print("Parcels dict value: " +str(strParcel))
if strParcel:
rowU[5] = strParcel['LANDOWNER_NAME_1']
rowU[6] = strParcel['PARCEL_NUMBER_1']
strCounty = cntyDct.get(rowU[0], None)
print("County dict value: " +str(strCounty))
if strCounty:
rowU[7] = strCounty['CountyName_1']
rowU[8] = stateDict.get(strCounty['stateAbbr'])
print(u'after {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}'.format(rowU[0], rowU[1], rowU[2], rowU[3],rowU[4], rowU[5], rowU[6], rowU[7],rowU[8]))
#cursorU.updateRow(rowU) One I figure this issue, the script will run within 2 minutes Thanks!
... View more
01-25-2023
04:03 PM
|
0
|
2
|
1695
|
|
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
|
1710
|
|
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
|
1779
|
|
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
|
1862
|
|
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
|
1920
|
|
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
|
1926
|
|
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
|
1521
|
|
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
|
1545
|
| Title | Kudos | Posted |
|---|---|---|
| 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 | |
| 1 | 11-05-2024 06:51 AM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|