topic Re: Using arcade to rank polygons in ArcGIS Pro Questions

Using arcade to rank polygons

junocs — Mon, 20 Feb 2023 17:19:00 GMT

I have a layer of national parks polygons with differing numbers of train stations near each one. I'm trying to rank them in my pop-ups according to which is the most accessible (Count of Points / Shape_Area), but I don't know the correct functions in arcade. Could someone please advise me on how to proceed?

(picture for context)

Re: Using arcade to rank polygons

DanPatterson — Mon, 20 Feb 2023 18:02:34 GMT

maybe orderby

order by in Arcade expressions

Re: Using arcade to rank polygons

junocs — Tue, 21 Feb 2023 05:25:24 GMT

I know absolutely nothing about SQL lol but I gave it a try and searched the internet about it a bit. I came up with only this from the esri website:

OrderBy($layer, 'Rank ASC')

However, it doesn't return anything, because I think it doesn't know what to rank? How do I tell it to rank a specific expression or field?

Re: Using arcade to rank polygons

JohannesLindner — Tue, 21 Feb 2023 07:39:54 GMT

// order the layer var ordered = OrderBy($layer, "(PointCount/Shape_Area) DESC") var rank = 0 // iterate over the ordered layer for(var f in ordered) { // increase the rank rank++ // if the feature we're looking at is the feature we clicked on, return the current rank if(f.OBJECTID == $feature.OBJECTID) { return rank } }

If you use this expression in the popup, it will recalculate the rank each time you click on a feature. This is good for dynamic data, but it will slow down the popup somewhat.

If you have static data (train stations and national parks sound pretty static), it might be better to use the expression to calculate a new field and show that in the popup.

Re: Using arcade to rank polygons

junocs — Tue, 21 Feb 2023 17:55:41 GMT

Thank you so much! This code has helped me a lot, but I've run into one problem while using it. I've tried OBJECTID and almost every field (alias and name) that my layer has that could match, but I keep getting the error message that the field is not found.

It's this line:

if(f.OBJECTID == $feature.OBJECTID)

I've found that I can double click the field for the $feature.OBJECTID part and the code fills in with my field, but the f. part just won't work. How do I fix this?

btw layer information is from here: https://naturalengland-defra.opendata.arcgis.com/datasets/national-parks-england/explore?location=52.137785%2C-1.007237%2C5.78

I've joined mine with another layer so it's not exactly the same

Re: Using arcade to rank polygons

JohannesLindner — Tue, 21 Feb 2023 18:32:36 GMT

Ah, joins.

When you add a join to a table, the full name of the field is used: Tablename.Fieldname (you can see that in your screenshot, too).

Clean solution: Instead of adding a join, use Join Field to permanently join the point count field to the polygons. This will change the polygon feature class, so it might not be possible for you.

Messy solution: use the full field names.

I downloaded the polygons and replicated your workflow: run the Summarize Nearby tool on the polygons and a point fc, join the output to the National Parks.

My feature class names are "National_Parks__England____Natural_England" for the original polygons and "parks_near" for the parks with summarized points.

This expression works for me:

// order the layer var ordered = OrderBy($layer, "(parks_near.Point_Count / National_Parks__England____Natural_England.Shape_Area) DESC") var rank = 0 // iterate over the ordered layer for(var f in ordered) { // increase the rank rank++ // if the feature we're looking at is the feature we clicked on, return the current rank if(f['National_Parks__England____Natural_England.OBJECTID'] == $feature['National_Parks__England____Natural_England.OBJECTID']) { return rank } }

Re: Using arcade to rank polygons

junocs — Wed, 22 Feb 2023 03:01:57 GMT

Oh, I had no idea that join field was so different. I tried it the clean way and it worked! Thanks so much for your help