Latest Contributions by JohannesLindner

You can also calculate a new field that tells you if a point is the closest point: shapes_points = arcpy.management.GeneratePointsAlongLines("shapes_lyr", "memory/shapes_points", 'PERCENTAGE', Percentage=7) arcpy.analysis.Near(shapes_points, road) arcade_expression = """ var fs_points = FeatureSetByName($datastore, "shapes_points", ["ORIG_FID", "NEAR_DIST"], false) var fid = $feature.ORIG_FID fs_points = Filter(fs_points, "ORIG_FID = @fid") return $feature.NEAR_DIST == Min(fs_points, "NEAR_DIST") """ arcpy.management.CalculateField(shapes_points, "IsNearest", arcade_expression, "ARCADE", field_type="Short") with arcpy.da.UpdateCursor("shapes_points", ["IsNearest"], "IsNearest = 0") as cursor: for row in cursor: cursor.deleteRow() arcpy.management.DeleteField(shapes_points, "IsNearest")     ... View more

This calculates the distance to the closest building in the same block: // load the whole feature class var fs_buildings = FeatureSetByName($datastore, "BuildingFC", ["BlockID", "BuildingID"], false) // only select rows with the current feature's BlockID and not this building var block_id = $feature.BlockID var building_id = $feature.BuildingID var fs_buildings_block = Filter(fs_buildings, "BlockID = @block_id AND BuildingID <> @building_id") function closest_feature(fs) { var min_dist = 99999999 var closest_feature = null for(var f in fs) { var f_dist = Distance(f, $feature) if(f_dist < min_dist) { closest_building = f min_dist = f_dist } } return closest_feature } var closest_building = closest_feature(fs_buildings_block) if(closest_building == null) { return null } return Distance($feature, closest_building) ... View more

Dude, relax. We all have our own jobs to take care of before helping others here... ... View more

How do I get the variable loopResults to find the first empty field You're currently looking for !IsEmpty(), so it returns the value of the first non-empty field. Remove the bangs: var loopResults = When(IsEmpty(Project_Design), Project_Design, IsEmpty(PA_Sent), PA_Sent, IsEmpty(PA_Recvd), PA_Recvd, '')   ... View more

Explode the multipart features Calculate a new field that tells you whether a singlepart line is the longest part of a multipart feature var id = $feature.ORIG_FID var fs = $featureset var all_line_parts = Filter(fs, "ORIG_FID = @ID") if($feature.Shape_Length == Max(all_line_parts, "Shape_Length")) { return 1 } return 0   select and delete all exploded lines where "LongestLine = 0"   Calculate the central point coordinates This is not actually the midpoint.  This is what the tool help says: "This point is the same as the centroid if the centroid is inside the feature, otherwise it is an inner label point." But it's probably the best you're going to get without pretty large code blocks...   Convert to points export to actual point feature class Find nearby polygon features  Join MidPoints to the original Line FC using "OBJECTID = ORIG_FID"   Add the polygons to that join, using "MidPoints.NEAR_FID = OBJECTID" Calculate the PolygonID field Remove all joins     ... View more

If you mean you can't edit feature attributes or add/delete features, then yes, that is impossible, because query layers and database views are readonly. If you have to do your workflow manually, you can add this query layer to your map to show you where problematic features are, but you have to edit the original feature class. If you don't have to do it manually, it seems that this can be easily done with the Calculate Field tool. Use Arcade as language, edit and copy this code: // if poly_id is already there, just return it if($feature.poly_id != null) { return $feature.poly_id } // load the parcel_poly fc var fs_parcel_poly = FeatureSetByName($datastore, "DATA.GIS.parcel_poly", ["roll", "correct_id_field"], false) // filter parcel_poly by "roll = roll_num" var roll_num = $feature.roll_num fs_parcel_poly = Filter(fs_parcel_poly, "roll = @roll_num") // if there is a related parcel_poly, return its parcel id var parcel_poly = First(fs_parcel_poly) if(parcel_poly != null) { return parcel_poly.correct_id_field } // else return null return null ... View more

I would like to know if it's possible to get a pic(image) instead the bus line? Sadly, not in the way you want. Ideally, you would do something like this in the Arcade expression:   // this does not work! Push( out_arr, `<img src="https://url.fr/images/line${f.ligne}.png"> vers ${f.destination}...` )   But in the classic Map Viewer, Arcade expressions escape the HTML commands, so they get shown as text.   If you limit it to show only one arrival/departure, you can do it like you do for the images above: Use an Arcade expression to return an image url and use that url in the HTML code.     Also, it is possible to sort the values on a push function? Well, your sort does work, but it sorts the array alphabetically, and so it sorts first by line, then by destination, and only then by time. To change this behavior, you can use the optional comparatorFunction argument (documentation😞   function sort_by_time(a, b) { var time_a = Split(a, " ")[-1] var time_b = Split(b, " ")[-1] if(time_a < time_b) {return -1} if(time_a > time_b) {return 1} return 0 } var out_arr = [ "Lianes 15 vers Courrejean 09:57:07", "Lianes 15 vers Pont De La Maye 09:51:45", ] out_arr = Sort(out_arr, sort_by_time) Concatenate(out_arr, "\n")   Lianes 15 vers Pont De La Maye 09:51:45 Lianes 15 vers Courrejean 09:57:07      Out of interest: Your screenshot is only halfway through the HTML and you're at expression 135. How fast is the popup loading? ... View more

Doing this on the original data is going to be hard or impossible. The two possibilities I see: Use SQL Create a Query Layer or Database View. In a very basic form: SELECT PointName, Max(Value) AS "MaxValue" FROM Featureclass GROUP BY PointName   Use Attribute Rules Create a new point feature class. Needs a value field. On your original point feature class, create an Attribute Rule that edits the newly created fc, something like this (untested): // Calculation Attribute Rule on original point fc // field: empty // triggers: insert, update, delete // load the label point fc var labels = FeatureSetByName($datastore, "LabelPoints", ["OBJECTID", "Value"], false) // intersect the label fc with the active $feature var label = First(Intersects(labels, $feature)) // create empty arrays to hold commands to add, update, or delete features in the label fc var adds = [] var updates = [] var deletes = [] // if we're inserting or updating a point and there is no label point there, add it if($editcontext.editType != "DELETE" && label == null) { var new_label = { "geometry": Geometry($feature), "attributes": {"Value": $feature.Value} } Push(adds, new_label) } // if we're inserting or updating and there already is a label point there, update its value if($editcontext.editType != "DELETE" && label != null) { var updated_label = { "objectID": label.OBJECTID, "attributes": {"Value": Max(label.Value, $feature.Value)} } Push(updates, updated_label) } // if we're deleting a point and there are no other points in that location, delete the label if($editcontext.editType == "DELETE" && label != null) { // load the point fc var points = FeatureSetByName($datastore, "Points", ["OBJECTID"], false) // intersect with label var points_at_location = Intersects(label, points) if(Count(points) == 1) { // only the current $feature, no other points var deleted_label = {"objectID": label.OBJECTID} Push(deletes, deleted_label) } } // return, this instructs the gdb to insert, update, or delete a feature in the label fc return { "edit": [{ "className": "LabelPoints", "adds": adds, "updates": updates, "deletes": deletes }] }   ... View more

Use the Text() function:   var before = $feature.LASTUPDATE var after = Text($feature.LASTUPDATE, "MM/Y") Console(before) Console(after)   2010-01-19T01:00:00+01:00 01/2010 ... View more