Latest Contributions by JohannesLindner

 I also had to add the Text function to string field types for those values to show up That's weird, this conversion should happen automagically.   The problem with Date fields is something that leads to confusion quite regularly. Please consider lending your support to this idea to hopefully get that fixed: https://community.esri.com/t5/arcgis-online-ideas/arcade-allow-date-values-in-date-fields/idi-p/1204894 ... View more

Hmm... "Request canceled" is an error I have never seen before, and I can't find it online, either. There is always the tried and true "restart ArcGIS", but other than that I have no idea. While checking Shape_Length and Shape_Area should work ( I could do it when testing), maybe start with a simple test table. Yes, you should be able to find identical Strings, Integers, Doubles (excluding rounding errors), Dates, and Geometries.   Good catch with overwriteOutput. That defaults to True in my setup, so I didn't think about that. ... View more

Instead of taking the First() feature of parkA_intersect, you need to loop through the featureset: // get parkA feature (polygon) var parkA = FeatureSetByName($datastore, "parkA", ["*"], false) var parkA_intersect = Intersects(parkA, Geometry($feature)) // return error if $feature doesn't intersect any parkA polygon if (Count(parkA_intersect) == 0) return {"errorMessage": "Buffer must be intersected with parkA polygon."} // create the result dict var result = { "attributes": { } } // initialize the edit arrays for adds and updates var adds = [] var updates = [] if(mode == "INSERT") { for(var p in parkA_intersect) { var add = { "geometry": Geometry(p), "attributes": { "Status_A": p.statusA } } Push(adds, add) } } if(mode == "UPDATE") { for(var p in parkA_intersect) { var update = { "objectID": p.OBJECTID, "geometry": Geometry(p), "attributes": { "Status_A": p.statusA } } Push(updates, update) } }   A note on the update objects: You need to specify which feature you want to update. You do that by supplying either the objectID or the globalID, see line 34 in the code above. Attribute rule dictionary keywords—ArcGIS Pro | Documentation  ... View more

Considering the fact that much of my work both in my job and on this site involves Arcade, it's really odd that I never had this idea. But now that you suggested it: YES, PLEASE. Query Layers and Database Views are great tools and do a lot of the heavy lifting in my applications, but there is only so much you can do with SQL. Arcade enables us to do more complex calculations. We regularily use Arcade Featuresets in Dashboards and Popups, displaying them on maps, both in the online Map Viewer and in ArcGIS Pro, is the next logical step. ... View more

Thanks Jeff, that helps alot. I have done some work with the CIM (especially configuring popups), but I haven't looked too far into it regarding symbology.   ... View more

# input parameters in_table = "path_or_layer_name" out_table_folder = "memory" out_table_name = "identical" fields = ["IntegerField", "Shape"] only_duplicate = False # create output table out_table = arcpy.management.CreateTable(out_table_folder, out_table_name) arcpy.management.AddField(out_table, "IN_FID", "LONG") arcpy.management.AddField(out_table, "FEAT_SEQ", "LONG") # read and group in_table groups = dict() for i, f in enumerate(fields): if f == "Shape": fields[i] = "SHAPE@WKT" with arcpy.da.SearchCursor(in_table, ["OID@"] + fields) as cursor: for row in cursor: oid = row[0] key = tuple(row[1:]) try: groups[key].append(oid) except KeyError: groups[key] = [oid] # write groups into out_table with arcpy.da.InsertCursor(out_table, ["IN_FID", "FEAT_SEQ"]) as cursor: for seq, key in enumerate(groups.keys()): oids = groups[key] if only_duplicate and len(oids) < 2: continue for oid in oids: cursor.insertRow([oid, seq]) ... View more

You actually never call the function, you pass it to Filter() as an argument. Passing functions around is something that is not done very often, so it can seem unintuitive, even for people somewhat familiar with programming. Basically, the argument of the function is a placeholder for the elements of the array to which the function is applied. This is mostly done for code brevity. The expression above could also be written this way: var arr = [20, 20, 21, 21, 21, 22] var filter_arr = [] for(var i in arr) { if(arr[i] == 21) { Push(filter_arr, arr[i]) } } return Count(filter_arr)   This is cumbersome to write and read, especially if you have to do it multiple times. To make the code more manageable, we use a predefined function (Filter) that takes care of the for loop. So, while it may seem confusing, it's actually simply a for loop that returns each element of the array for which the functions returns true. ... View more