Latest Contributions by JohannesLindner

Intersect the point and polygon fcs Dissolve the resulting point fc by the polygon id field into a multipoint fc run Feature To Point on that multipoint fc to get the centroids   ... View more

A naive approach: create clusters with random point counts until you reach 50k points create random center points for the clusters create buffers with random radii around the cluster centers use these buffers as constraining fc for the Random Points tool Script:   import arcpy import random # tool parameters output_folder = "" output_name = "RandomPointClusters" constraining_fc = "TestPolygons" num_of_points = 50000 min_points_in_cluster = 20 max_points_in_cluster = 100 min_cluster_radius = 500 max_cluster_radius = 1500 min_point_distance = 1 # randomly distribute the points into clusters rest = num_of_points clusters = [] while rest > 0: num = random.randint(min_points_in_cluster, max_points_in_cluster) num = min(num, rest) clusters.append(num) rest -= num print(f"{len(clusters)} clusters will be created.") # randomly create the cluster centers cluster_centers = arcpy.management.CreateRandomPoints("memory", "ClusterCenters", constraining_fc, None, len(clusters), min_point_distance) # randomly create the cluster buffers sr = arcpy.Describe(constraining_fc).spatialReference cluster_buffers = arcpy.management.CreateFeatureclass("memory", "ClusterBuffers", "POLYGON", spatial_reference=sr) arcpy.management.AddField(cluster_buffers, "NumOfPoints", "LONG") with arcpy.da.InsertCursor(cluster_buffers, ["SHAPE@", "NumOfPoints"]) as i_cursor: with arcpy.da.SearchCursor(cluster_centers, ["SHAPE@", "OID@"]) as s_cursor: for cluster_center, cluster_id in s_cursor: cluster_radius = random.randint(min_cluster_radius, max_cluster_radius) cluster_buffer = cluster_center.buffer(cluster_radius) num = clusters[cluster_id - 1] i_cursor.insertRow([cluster_buffer, num]) # clip the cluster buffers with the constraining fc cluster_boundaries = arcpy.analysis.Clip(cluster_buffers, constraining_fc, "memory/ClusterBoundaries") # randomly distribute the points inside the cluster boundaries arcpy.management.CreateRandomPoints(output_folder, output_name, cluster_boundaries, None, "NumOfPoints", min_point_distance)       This would be better with irregular cluster boundaries, as now it's very noticeable that they are circles. A random offset for each point could do the trick, too. ... View more

  if COMPLETE and COMPLETE.altered:     You're not checking the value of the parameter, you're checking if a non-empty value is assigned to the variable COMPLETE. Take a look at this code and its output:   test_values = [False, 0, None, "", [], ()] for value in test_values: msg = str(value) + ": " if value: msg += "TRUE" else: msg += "FALSE" print(msg)   False: FALSE 0: FALSE None: FALSE : FALSE []: FALSE (): FALSE   So, your if COMPLETE: could also be written as if COMPLETE not in [False, 0, None, "", [], ()]: # and maybe some other values, too   and that will always return False, because COMPLETE has a value (it is an arcpy.Parameter).   Instead, you have to check the value of that arcpy.Parameter: if COMPLETE.value:   ... View more

Feature To Point generates centroid points for polygons. ... View more

Switch tha language to Arcade, use this expression: var titles = ["ZEE", "OP", "Vast", "Lok"] var values = [ $feature.Km_paal_in_zee, $feature.Oriëntatiepaal, $feature.vaste_plaatsnaam, $feature.Lokale_benaming, ] var lines = [] for(var i in titles) { if(!IsEmpty(values[i])) { var line = `${titles[i]}-<BOL><CLR red="21" green="47" blue="255">${values[i]}</CLR></BOL>` Push(lines, line) } } return Concatenate(lines, TextFormatting.NewLine) ... View more

I believe ArcGIS uses default values when it verifies Arcade expressions. That means that it often doesn't find anything with functions like FeaturesetByRelationshipName() and Filter() adn returns empty featuresets. In your case, it returned an empty fs with FeaturesetByAssociation(), so your globalIDs array is empty, which leads to your query being "GlobalID IN ()" which is invalid. Try guarding against empty featuresets: var contentRows = FeatureSetByAssociation($feature, "content"); var globalIds = []; var i = 0; for (var v in contentRows) { globalIds[i++] =v.globalId } var deviceCount = 0 // set a defaul value if(i > 0) { // only enter this block if contentRows is not empty var asset_Array=[27,26] var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject"); var devicesRows = Filter(deviceClass, "globalid in @globalIds"); deviceCount = Count(deviceRows) // overwrite the default value } return{'errorMessage':deviceCount} ... View more

Ah, I see now that I misunderstood your second question.   I see this behavior in a file gdb. While the Console() command ouputs the right message (empty geometry and only one field [plut OBJECTID]), the error message prints the complete feature, although I didn't load the geometry and the other fields. var fs = FeatureSetByName($datastore, "TestLines", ["IntegerField"], false); Console(First(fs)) return {errorMessage: Text(First(fs))}     In an Enterprise GDB, it works as expected: var fs = FeatureSetByName($datastore, "Bauwerke", ["BauwerkID"], false); Console(First(fs)) return {errorMessage: Text(First(fs))}   @HusseinNasser2 , any insights? ... View more

To post code:     I am trying to filter the database by using profile variable $Map in ArcGIS Pro Attribute Rules You can't use $map in attribute rules. Attribute rules work on the database level and can be triggered from different maps (or even without a map at all), so it doesn't make sense to rely on a featureset in a specific map. Instead, use $datastore if the featureset is in the same database. If not, you have to publish it and load it in using FeaturesetByPortalItem().     I want only to get the field room from this table, but when printing the results all fields are there You return the whole feature, so every field is printed. Instead, return only a specific field: var test="{4EC98101-67C4-44FC-8BF5-C7DF9393AB73}" var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject"); var devicesRows = Filter(deviceClass, "GLOBALID = @test"); var device = First(devicesRows) var room = IIf(device == null, "nodevice found", device.room) return{"errorMessage":"FeatureSetByAssociation: " + room}; ... View more