List nearest feature nearby in popup

DavideDi_Carlo

Hi, I would to show the list of nearest substations in the popup of the areas that I'm drawing. 
I've managed to get it in the console but I cannot return a list; it would be gret if i could display the first 3 from the nearest

var substat= FeatureSetByName($map,"OSM SUBSTATION",["operator"])
var searchDistance = 10;
var inrangesubstat = Intersects( substat, Buffer( $feature, searchDistance, "kilometers") );
var cnt = Count(inrangesubstat)
Console("Total Number of addresses within "+searchDistance+ "km buffer: " + cnt);
var min_dist = infinity;

for (var f in inrangesubstat){
var substDist = Round(Distance(f,$feature,"kilometers"),2);
if (substDist < min_dist) {
inrangesubstat = f.operator;
min_dist = substDist;
}
console(f.operator + ": " + " " + substDist);
}

return f.operator+": at " + " " + substDist+" km"

 

thanks

kenbuja

In that case, push the values into an array of objects ([operator, Name, distance]), sort them by distance (item 2 in the array) and write out the three smallest results.

 

// define Sort comparator returning IsEmpty as least values
function Comp(a,b) { 
    When(
        IsEmpty(a[2]), -1,
        IsEmpty(b[2]), 1,
        IIf(a[2]>b[2],1,-1)
    );
};

var substat= FeatureSetByName($map,"OSM_SUBSTATION",["operator","Name"])
var inrangesubstat = Intersects(substat, Buffer($feature, 10, "kilometers"));

// Cycle through the polygon features and find the nearest one
var geomArea=Geometry($feature)
var arr = Array(0);
var counter = 0;
for (var f in inrangesubstat){
  var geomSub=Geometry(f)
  var substDist = Round(Distance(geomArea,geomSub, "kilometers"),2);
  arr[counter] = [f.operator, f.name, substDist];
  counter++;
}
arr = Reverse(Sort(arr, Comp));
var lbl = '';
for (var k in arr){
  if (k < 3) {
    lbl = Concatenate([lbl, `${arr[k][2]} km: ${arr[k][0]}-${arr[k][1]}`], TextFormatting.NewLine);}
  }
}
return lbl;

 

This is using the sorting method from this post.