Latest Contributions by JohannesLindner

You had issues before because you didn't have the null check. When IncidentNumber is null, codeStatement will be "incident_number = ". That is an invalid sql statement, so the Filter() function will fail. When the Arcade expression is validated, it uses default values (I think, not too sure about that. @jcarlson ?), so the expression didn't get validated because it raised an error, until you set incident to a non-null value. With the null check I suggested, you return a default response if the IncidentNumber is null. When you return from a script, the rest of the script isn't executed anymore, so Filter() doesn't get a chance to raise an error, so the expression validates. ... View more

You have the wrong order of arguments for DateDiff Date('today') isn't a thing, Today is You want to use IIf You're not using the correct quote marks, but some mixture of apostrophes and accents, but that might be because you posted your code as text var numDays = 20; var days = DateDiff(Today(), $feature.inspection_date, 'days'); return IIf(days > numDays, 'inspection needed', $feature.maintenance)   ... View more

What do you want to show in the indicator? ... View more

You canuse the Append tool: Append (Data Management)—ArcGIS Pro | Documentation use the shaep file as input dataset use the table as target dataset set the field matching type to "Use the field map to reconcile field differences" in the field map, remove the source for each output field, set the source of the target field to the input field you want to copy for example, in this screenshot I'm copying the values of "Shapefile.NEAR_FID" to "Table.IntegerField"   ... View more

For the Calculate Field tool with Arcade: var related = First(FeaturesetByRelationshipName($feature, "TestPoints__ATTACHREL")) if(related == null) { return $feature.ATT_NAME } return related.OBJECTID + ".jpg"   Before:   After:   ... View more

To post code:   Try doing a null check: var incident = $feature.incident_number if(incident == null) { return "No Incident number!" } var u = ... ... View more

Does it work if you set the layer to refresh automatically?   ... View more

You can probably whip up some Python script. But this part is very unclear: Some polygons that have partially overlap will be changed. For example I have one polygon from 2020 that have cross polygon from 2019 and anther cross polygon from 2021 The 2020 polygon will be cut by 2021 polygon but not by 2019 polygon.   Can you clarify that, maybe with a sketch? ... View more

Similarly to @DavidPike 's answer, I would summarize the points by their polygon attribute and generate random point for each region your problematic points belong to. But I would skip the spatial join and just update the geometry directly. Steps to use: Backup your data! This will change the geometry of the problematic points. Create a backup. Select the problematic points this will remove the need for the geometry logic David suggested Copy paste the script into the ArcGIS Pro Python window Edit the varibales point_layer, polygon_layer, polygon_id, and point_polygon_id Run the script   # names of the point and polygon layers in the current map point_layer = "TestPoints" polygon_layer = "TestPolygons" # names of the relationship fields polygon_id = "TextField" # primary key of the polygon layer point_polygon_id = "TextField" # foreign key that links the points to the polygons # get the regions where the points should be point_regions = [row[0] for row in arcpy.da.SearchCursor(point_layer, [point_polygon_id])] regions = {pr for pr in point_regions} # loop over the regions for region in regions: # get the count of points that belong in that region point_count = len([pr for pr in point_regions if pr == region]) # select the region polygon query = f"{polygon_id} = '{region}'" # my id fields are text fields. if yours are not, remove the single quotes around {region} arcpy.management.SelectLayerByAttribute(polygon_layer, "NEW_SELECTION", query) # generate random points in that region and extract their geometries random_points = arcpy.management.CreateRandomPoints("memory", "RandomPoints", polygon_layer, None, point_count) new_shapes = [row[0] for row in arcpy.da.SearchCursor(random_points, ["SHAPE@"])] # start updating the points that belong in this region query = f"{point_polygon_id} = '{region}'" # again, remove the single quotes if you're working with numbers with arcpy.da.UpdateCursor(point_layer, ["SHAPE@"], query) as u_cursor: # loop over the points for i, row in enumerate(u_cursor): # copy the new geometries u_cursor.updateRow([new_shapes[i]])     Before:   After:     ... View more

Regarding irregular cluster shapes: This would be an easy way to generate irregular (but always convex) buffer shapes: def irregular_buffer(point_geometry, min_dist, max_dist, num_points): points = [] for i in range(num_points): angle = random.randint(0, 359) dist = random.randint(min_dist, max_dist) points.append(point_geometry.pointFromAngleAndDistance(angle, dist).firstPoint) multipoint = arcpy.Multipoint(arcpy.Array(points), spatial_reference=point_geometry.spatialReference) return multipoint.convexHull()   The num_points argument controls how much the buffer shapes resemble a circle. Higher value -> more circle-like.   num_points = 5:     num_points = 10:   num_points = 30:     To use this method, replace lines 41-42 in my original answer with this: cluster_buffer = irregular_buffer(cluster_center, min_cluster_radius, max_cluster_radius, 5)   Which indeed results in more irregular clusters:   And you can still add a random offset at the end.   ... View more