nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Utilisation des fonctions FeatureSetBy dans Arcade pour explorer d'autres couches et tables

XanderBakker

<\/HEAD>

Aujourd'hui, un excellent blog a été publié par Paul Barker<\/A> sur les nouvelles fonctions FeatureSet : Quoi de neuf avec Arcade : Une promenade à travers FeatureSets (Partie 1)<\/A> et aussi Kelly Gerrow<\/A> a partagé un excellent document sur ce sujet : https:\/\/community.esri.com\/community\/gis\/web-gis\/arcgisonline\/blog\/2018\/12\/10\/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade<\/A> . <\/P>

<\/P>

Je ne voulais pas rester à la traîne, alors j'ai pensé partager quelques exemples utilisant des hydrants, l'historique de maintenance ainsi que les sub sectors et hydraulic sectors pour montrer ce que vous pouvez réaliser avec les nouvelles fonctions Arcade publiées dans ArcGIS Online le 5 décembre.<\/P>

<\/P>

Considérons que nous avons une carte web avec plusieurs couches et une table :<\/P>

<\/P>

Hidrantes<\/EM> est une couche ponctuelle avec des hydrants<\/LI>Sub Sector<\/EM> est une couche polygonale avec une subdivision de la zone d'intérêt<\/LI>Sector Hidraulico<\/EM> est une couche polygonale fusionnant les sub sectors en hydraulic sectors<\/LI>Hist Mantenimiento<\/EM> est une table contenant les enregistrements historiques de maintenance pour chaque hydrant<\/LI><\/UL><\/P>Tout d'abord, appliquons un peu d'Arcade pour visualiser les hydrants en fonction de leur âge. Cela était déjà possible dans la version précédente, donc rien de nouveau ici pour l'instant. Nous avons la date d'installation stockée dans le champ FECHAINSTALACION et nous pouvons utiliser les fonctions DateDiff<\/EM> et Now<\/EM> pour déterminer l'âge en années, ce qui se fait dans les deux premières lignes. Ensuite, nous classons la valeur en plages significatives :<\/P>var<\/SPAN> fecha_inst =<\/ $feature.<\/FECHAINSTALACION;<\/ var<\/ edad =<\/ DateDiff<\/(Now<\/()<\/, fecha_inst,<\/ "years"<\/);<\/ var<\/ clase_edad =<\/ ""<\/;<\/ if<\/ (edad > 50){ clase_edad = "Plus de 50 ans"; } else if (edad > 40) { clase_edad = "Entre 40 et 50 ans"; } else if (edad > 30) { clase_edad = "Entre 30 et 40 ans"; } else if (edad > 20) { clase_edad = "Entre 20 et 30 ans"; } else if (edad > 10) { clase_edad = "Entre 10 et 20 ans"; } else if (edad > 5) { clase_edad = "Entre 5 et 10 ans"; } else { clase_edad = "Moins de 5 ans"; } return clase_edad; <<EMOJI_0>><<EMOJI_1>><<EMOJI_2>><<EMOJI_3>><<EMOJI_4>><<EMOJI_5>><<EMOJI_6>><<EMOJI_7>><<EMOJI_8>><<EMOJI_9>><<EMOJI_10>><<EMOJI_11>><<EMOJI_12>><<EMOJI_13>><<EMOJI_14>><<EMOJI_15>><<EMOJI_16>><<EMOJI_17>><<EMOJI_18>><<EMOJI_19>></PRE><\/P>Le résultat est un texte décrivant l'âge, pour lequel nous pouvons définir des symboles représentatifs (ici en utilisant les symboles Firefly) :<\/P><IMG class="image-2 jive-image" src="https:\/\/us.v-cdn.net\/6038851\/uploads\/legacyfs\/online\/431467_pastedImage_10.png" \/><\/P><\\/P>Aucun symbole fantaisie pour les deux autres couches polygonales afin d'éviter de détourner l'attention des hydrants.<\\/P><\\/P>Nous souhaitons afficher dans la fenêtre pop-up de chaque hydrant la liste de toutes les maintenances effectuées sur cet hydrant. La table historique de maintenance ainsi que la couche hydrant contiennent l'ID de l'hydrant. La table contient également les dates et types de maintenance.<\\/P><\\/P>Dans la configuration du pop-up des hydrants, nous pouvons ajouter une expression Arcade comme celle-ci :<\\/P><PRE class="lia-code-sample line-numbers language-none"><CODE>var tbl = FeatureSetByName($datastore,"Hist_Mantenimiento"); var codigo = $feature["COD_HIDRANTE"]; var sql = "COD_HIDRANTE = '" + codigo + "'"; Console(sql); var mantenimientos = Filter(tbl, sql); var cnt = Count(mantenimientos); var historia = ""; if (cnt > 0) { historia = cnt + " Maintenance(s) :"; pour (var mantenimiento dans mantenimientos) { var txt_fecha = Text(mantenimiento.Fecha_Mantenimiento, ' - (Y/MM/JJ) '); var txt_man = txt_fecha + mantenimiento.Mantenimiento; historia += TextFormatting.NewLine + txt_man; } } sinon { historia = "Pas de maintenances"; } retourner historia; ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<Span‍>

Tout d'abord, nous accédons à la table contenant l'historique des maintenances et l'assignons à une variable tbl. Ensuite, nous lisons l'id de l'hydrant actuel pour lequel nous voulons créer le pop-up. Nous définissons une expression SQL utilisant l'ID de l'hydrant qui est ensuite utilisée pour filtrer la table d'historique. Le résultat est stocké dans une variable appelée mantenimientos. Nous pouvons faire un Count pour obtenir le nombre de maintenances effectuées sur l'hydrant. Si le compte (cnt) est supérieur à 0, nous commençons à lire les détails et construisons une liste de maintenances incluant la date et le type de maintenance.

Le résultat apparaîtra ainsi après avoir configuré un simple html personnalisé pour afficher les attributs et le résultat de l'expression Arcade dans le pop-up :

Poursuivons maintenant avec ces nouvelles fonctions Arcade pour obtenir des données sur les hydrants au niveau du sous-secteur. Puisque le nombre de maintenances dépend évidemment de l'âge de l'hydrant, il serait intéressant d'obtenir quelques détails à ce sujet au niveau du sous-secteur.

Dans la configuration du pop-up des sous-secteurs, nous pouvons ajouter l'expression Arcade suivante :

<SPAn class="keyword token">var</SPAn> fs <SPAn class="operator token">=</SPAn> <SPAn class="token function">FeatureSetByName</SPAn>( $datastore , <SPAn class="string token">"Hidrantes"</SPAn>) ;
<SPAn class="keyword token">var</SPAn> hidrantes <SPAn class="operator token">=</SPAn> <SPAn class="token function">Intersects</SPAn>( fs , $feature ) ;
<SPAn class="keyword token">var</SPAn> cnt <SPAn class="operator token">=</SPAn> <SPAn class="token function">Count</SPAn>( hidrantes ) ;

<SPAn class="keyword token">var</SPAn> edad_tot <SPAn class="operator token">=</SPAn> 0 ;
<SPAn class="keyword token">pour</SPAn>( var hidrante <SPAn class="keyword token">dans</SPAn> hidrantes ) {
    var edad = DateDiff( Now() , hidrante.FECHAINSTALACION , "years" ) ;
    edad_tot += edad ;
}

var resultado = "" ; 
if ( cnt > 0 ) {
    var edad_media = edad_tot / cnt ;
    resultado = "Il y a " + cnt + " hydrants dans le sous-secteur" ;
    resultado += TextFormatting.NewLine + "L'âge moyen des hydrants est de " + Round( edad_media , 2 ) + " ans" ;
} else {
    resultado = "Il n'y a pas d'hydrants dans le sous-secteur" ;
}

return resultado ;
<Spanclass=\"line-numbers-rows\"><Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span‍></Span>

Cette expression va : </P>
<ul>
<li>Accéder à la couche Hydrants </li>
<li>Etablir une intersection avec la géométrie du sous-secteur courant </li>
<li>Compter le nombre d'hydrants dans le sous-secteur </li>
<li>Calculer l'âge de chaque hydrant et sommer tous les âges </li>
<li>Calculer l'âge moyen des hydrants et formater le texte avec cette information </li>
</ul>
<p></p>
<p>Le résultat apparaîtra ainsi :</p>
<p><img src='https://us.v-cdn.net/6038851/uploads/legacyfs/online/431475_pastedImage_15.png' alt=''/></p>
<p>Cet exemple montre qu'il y a 93 hydrants dans le sous-secteur et que l'âge moyen est de 20,64 ans.</p>
<p>C'est amusant, mais peut-on aussi afficher les noms des sous-secteurs contenus dans un secteur hydraulique en utilisant ces nouvelles fonctions Arcade ? La réponse est oui. Ajoutons l'expression suivante aux secteurs hydrauliques :</p>
<pre class='lia-code-sample line-numbers language-none'><code>
var fs = FeatureSetByName($datastore, "Sub Sector");
var subsectores = Intersects(fs, $feature);
var cnt = Count(subsectores);

var resultado = "Liste des " + cnt + " Sous-secteurs :";
<span  class="keyword token">for<\/SPAN> <SPAN class="punctuation token">(<\/SPAN><SPAN class="keyword token">var<\/SPAN> subsector <SPAN class="keyword token">in<\/SPAN> subsectores<SPAN class="punctuation token">)<\/SPAN> <SPAN class="punctuation token">{<\/SPAN>\n&nbsp;&nbsp;&nbsp; resultado <SPAN class="operator token">+<\/SPAN><SPAN class="operator token">=<\/SPAN> TextFormatting<SPAN class="punctuation token">.<\/SPAN>NewLine <SPAN class="operator token">+<\/SPAN> subsector<SPAN class="punctuation token">.<\/SPAN>IDSAP<SPAN class="punctuation token">;<\/SPAN>\n<SPAN class="punctuation token">}<\/SPAN>\n\n<SPAN class="keyword token">return<\/SPAN> resultado<SPAN class="punctuation token">;<\/SPAN>\n<SPAN class="line-numbers-rows"><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><SPAN>‍<\/SPAN><\/SPAN><\/CODE><\/PRE><P><\/P><P>Accédez simplement à la couche des sub sectors et faites un Intersect avec le secteur hydraulique actuel et voilà..., n'est-ce pas ? Non, pas si simple. Lorsque vous utilisez un Intersect entre deux couches de polygones, il retournera probablement trop d'entités car lorsque deux polygones ont une frontière commune, ils seront probablement inclus dans le résultat, ce qui conduit à plus de sub sectors que souhaité.<\/P><P><\/P><P>Une façon d'éviter cela est d'utiliser un petit buffer négatif sur le secteur hydraulique et de faire l'Intersect avec cette géométrie tamponnée comme ceci :<\/P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">var<\/SPAN> fs <SPAN class="operator token">=<\/SPAN> <SPAN class="token function">FeatureSetByName<\/SPAN><SPAN class="punctuation token">(<\/SPAN>$datastore<SPAN class="punctuation token">,<\/SPAN><SPAN class="string token">"Sub Sector"<\/SPAN><SPAN class="punctuation token">)<\/SPAN><SPAN class="punctuation token">;<\/SPAN>\n<SPAN class="keyword token">var<\/SPAN> feature_buf <SPAN class="operator token">=<\/SPAN> <SPAN class="token function">Buffer<\/Span>(<$feature>, -100, 'meters');\nvar subsectores = Intersects(fs, feature_buf);\nvar cnt = Count(subsectores);\n\nvar resultado = "Listado de los " + cnt + " Subsectores:";\nfor (var subsector in subsectores) {\n   resultado += TextFormatting.NewLine + subsector.IDSAP;\n}\n\nreturn resultado;\n<span class="line-numbers-rows"><span><<EMOJI_10>></span><span><<EMOJI_11>></span><span><<EMOJI_12>></span><span><<EMOJI_13>></span><span><<EMOJI_14>></span><span><<EMOJI_15>></span><span><<EMOJI_16>></span><span><<EMOJI_17>></span><span><<EMOJI_18>></span><span><<EMOJI_19>></span></span>

Remarquez le Buffer avec une distance négative qui est créé à la ligne 2 et utilisé à la ligne 3 pour obtenir les polygones corrects.<\/P>

Le pop-up résultant s'affichera ainsi :<\/P>

Pour être honnête, je n'aime pas la liste non triée des sub sectors, alors ordonnons cette liste en utilisant OrderBy<\/EM>:<\/P>var fs = FeatureSetByName($datastore,"Sub Sector");\nvar feature_buf = Buffer($feature, -100, 'meters');\nvar subsectores = OrderBy(Intersects(fs, feature_buf), 'IDSAP ASC');\nvar cnt = Count(subsectores);\n\nvar resultado = "Listado de los " + cnt + " Subsectores:";\nfor (var subsector in subsectores) {\n resultado += TextFormatting.NewLine + subsector.IDSAP;\n}\n\nreturn resultado;\n<<EMOJI_21>><<EMOJI_22>><<EMOJI_23>><<EMOJI_24>><<EMOJI_25>>

Cela donnera une liste triée des sub sectors :<\/P>

J'espère que ces exemples vous aideront à comprendre ce qui est possible avec Arcade grâce à la dernière mise à jour d'ArcGIS Online, mais avant que vous ne commenciez à créer des expressions Arcade fabuleuses, je veux citer Oncle Ben (Spider-Man) un instant :<\/P>

Un grand pouvoir implique de grandes responsabilités...<\/EM>

Comme le mentionne Paul Barker dans son blog, soyez prudent et validez toujours que les performances de vos expressions offrent un temps de réponse acceptable pour votre utilisateur final.<\/P>

Trouver plus de publications taguées avec

Réponses

ChrisMartin8

Hi @XanderBakker

This post has been super helpful. I've read through it and all the comments. I have a very similar use case but need a slightly different output.

I have a polygon layer of buildings and a table of category codes that are included in a relationship class. The field that links them is an ID field which is called "UID" in the buildings layer and "UID_Child" in the category code table. I am trying to edit my output so that in the case of multiple occurrences of the same category code within one building, that code would be listed once along with a count of how many times it occurs, rather than listing duplicate codes. Here's my current code:

//identify related table data
var related_table = FeatureSetById($datastore, "11");

//filter relate table for records matching unique ID
var filter_query = "UID_Child = '" + $feature["UID"] + "'";
Console('filtering related data records')
var related_data_filtered = Filter(related_table, filter_query);

//count records matching UID in related table 
var related_data_filtered_count = Count(related_data_filtered);
var output = []
Console('records filtered: '+ related_data_filtered_count)

//push catcode value from related data table to output 
if (related_data_filtered_count > 0) {
  for (var related_data_row in related_data_filtered) {
    Push(output, related_data_row.CATCODE)
  }
} else {
  return "No Related Records."
}
Console(output)

And here's what the popup looks like:

So for this feature for example, I would want it to read "610112 (10 or however many times it occurs)" I think I need to use a for loop to count how many times each catcode occurs. I've tried a ton of different variations with no success. I'll put one sample below. Do you have any ideas?

var filter_query = "UID_Child = '" + $feature["UID"] + "'";
var related_data_filtered = Filter($datastore["11"], filter_query);
var related_data_filtered_count = Count(related_data_filtered);

Console("Filtered data count: " + related_data_filtered_count);

var catcodeCounts = {}; // Object to store counts of each unique CATCODE

if (related_data_filtered_count > 0) {
  Console("Processing related records...");
  
  // Loop through the filtered related features
  for (var i = 0; i < related_data_filtered_count; i++) {
    var feature = related_data_filtered[i];
    var catcode = feature["CATCODE"]; // Accessing the CATCODE attribute directly
    
    // Increment count for the current CATCODE or initialize count to 1
    if (!catcodeCounts[catcode]) {
      catcodeCounts[catcode] = 1;
    } else {
      catcodeCounts[catcode] += 1;
    }
    
    Console("Processed CATCODE: " + catcode);
  }
  
  // Construct output with counts of each unique CATCODE
  var output = "";
  for (var catcode in catcodeCounts) {
    output += "CATCODE " + catcode + ": " + catcodeCounts[catcode] + "\n";
  }
  
  Console("Output: \n" + output);
  return output;
}

Console("No related records found.");
return "No Related Records.";

XanderBakker

Hi @jschuckert ,

Good question... The FeatureSetByRelationshipName function is available in ArcGIS Online, but was not available in ArcGIS Enterprise at version 10.5.1. This might make the request to the server invalid or perhaps the response is not getting through correctly. Have you verified if there is something in the logs of ArcGIS Server?

jschuckert

Hi @XanderBakker

I am attempting to pull attribute information from a related table, although I am not getting an error but rather a blank result. Is FeatureSetByRelationshipName compatible in ArcGIS Online going against a 10.5.1 ArcGIS Server map service?

Thanks,

Jared

XanderBakker

Hi @TSmith ,

Sorry for the delay in my reply.

My first guess would be the date. You need to convert it to epochs to ensure that it is taken as a date when creating the featureset.

You can do something like:

var epoch = DateDiff(insdate, Date(1970, 0, 0));

TSmith

Hi Xander,

I currently am trying to populate dashboard widgets with info from a related table (and some info from the primary table) using the code below:

var features = [];
var feat;
for (var v in valvefs){
    var relatedrecords = OrderBy(FeatureSetByRelationshipName(v, 'System_Valve_Inspection', ["insdate", "turns", "fintorque"],false),'insdate DES');
    var recentrecord = First(relatedrecords);
   if (Count(relatedrecords)>0){
         
        var feat = {
           attributes: {
               'assetid': v["assetid"],
               'insdate': recentrecord["insdate"],
               'diameter': v["diameter"],
               'turns': recentrecord["turns"],
               'fintorque': recentrecord["fintorque"],
           }
       }
       Push(features,feat);
   };
};   
var joinedDict = {
    fields: [
     { name: "assetid", type: "esriFieldTypeString" },
     { name: "insdate", type: "esriFieldTypeDate" },	
     { name: "fintorque", type: "esriFieldTypeDouble" },
     { name: "turns", type: "esriFieldTypeDouble" },
     { name: "diameter", type: "esriFieldTypeDouble" },
    ],
    geometryType: '',
    features: features
};
return FeatureSet(Text(joinedDict))

This code (as it stands right now) returns an empty resultset. Could I try something similar to what you have here, or does the output of a data expression HAVE to be a featureset?

Thanks so much for any help!

KylieRyan

Hi @XanderBakker !

Thank you so much for your help! I looked into it a bit further and could only thing I could come up with was that the layer (being the Council's main property information layer) was not a feature layer but an map image layer - would that be the issue?

XanderBakker

Hi @KylieRyan ,

Not sure what might be going wrong with the expression. The only thing I can think of is it doesn't find the layer in the map (check the exact name) or the feature does not intersect with any features from the featureset or there are differences in coordinate systems between the feature and the featureset.

I reorganized the expression a bit, but no big changes:

function getAttributeFromLargestArea(geom, fs, field) {
    var items = Intersects(fs, geom);
    var counts = Count(items);

    if (counts == 0) {
        return {'errorMessage': 'No intersection found'};
    }

    if (counts == 1) {
        var result = First(items);
        return result[field];
    }

    var largest = -1;
    var result;

    for (var item in items) {
        var size = Area(Intersection(item, geom));

        if (size > largest) {
            largest = size;
            result = item[field];
        }
    }

    return result;
}

// var layerName = $layer;
var fieldName = "parcel_title";
var fs = FeatureSetByName($map, "council_data.property");

return getAttributeFromLargestArea(Geometry($feature), fs, fieldName);

KylieRyan

I have been trying for months to get the parcel details from a property layer to autopopulate in the popup for a data capture layer for a weed point...

I was provided the following to use, however all it returns is "Execution Error:Invalid Parameters for Count" and I have no idea why or how to fix. I'm losing my mind!! Can someone please help?

var layerName = $layer;
var fieldName = "parcel_title";

var set = FeatureSetByName($map,"council_data.property")

function getAttributeFromLargestArea(feat, set, field) {
var items = intersects(set, feat);
var counts = count(items);

if (counts == 0) {
return { 'errorMessage': 'No intersection found' };
}

if (counts == 1) {
var result = first(items);

return result[field];
}

var largest = -1;
var result;

for (var item in items) {
var size = area(intersection(item, feat));

if (size > largest) {
largest = size;
result = item[field];
}
}

return result;
}

getAttributeFromLargestArea($feature, set, fieldName)

XanderBakker

Hola @Carlos_AndresCamacho_Acuña , cómo estás?

Revisando el primer bloque me di cuenta de algunos errores pequeños. Al comienzo el signo "=" después de "var tbl ". Y hacia el final sobraba una corcheta.

// Inicialmente, se relaciona la dbase table que almacena los registros de operaciones realizadas a la válvula
var tbl = FeatureSetByRelationshipName($datastore,"OperacionValvula");

// Se relaciona el atributo en el feature Class que actúa como llave entre el feature y la tabla relacional
var codigo = $feature["GlobalID"];

// Se establece el query que se creará en la tabla para filtrar los registros de operaciones de la válvula seleccionada
var sql = "ID_GLOBAL = @codigo";
Console(sql);

// Se generan los filtros
var operaciones = Filter(tbl, sql);

// Se realiza el conteo de operaciones
var cnt = Count(operaciones);
var historia = "";
if (cnt > 0) {
    historia = cnt + " Operaciones realizadas a la válvula:";
} else {
    historia = "No hay operaciones realizadas a la válvula";
}

return historia;

En la segunda parte te falta declarar el variable resultado:

var fs = FeatureSetByName($map, "Valvulas_IBAL_2021");
var valvulas = Intersects(fs, $feature);
var cnt = Count(valvulas);

var resultado = "";
if (cnt > 0) {
    resultado = "Hay " + cnt + " valvulas en la comuna";
} else {
    resultado = "No hay valvulas en la comuna";
}

return resultado;

Carlos_AndresCamacho_Acuña

hola quería generar un atributo que hiciera el conteo de la cantidad de registros de una operación de válvulas . ( estas controlan el paso del agua en un acueducto ) utilizando el ejemplo de Hidrantes que tienen en la web, sin embargo me genera error y no se como solucionarlo, el código es:

// Inicialmente, se relaciona la dbase table que almacena los registros de operaciones realizadas a la válvula
var tbl FeatureSetByRelationshipName($datastore,"OperacionValvula");

// Se relaciona el atributo en el feature Class que actúa como llave entre el feature y la tabla relacional
var codigo = $feature["GlobalID"];

// Se establece el query que se creará en la tabla para filtrar los registros de operaciones de la válvula seleccionada
var sql = "ID_GLOBAL = '" + codigo + "'";

// Se generan los filtros
Console(sql);
var operaciones = Filter(tbl, sql);

// Se realiza el conteo de operaciones
var cnt = Count(operaciones);
var historia = "";
if (cnt > 0) {
historia = cnt + " Operaciones realizadas a la válvula:";
}
} else {
historia = "No hay operaciones realizadas a la válvula";
}

return historia;

El feature tiene un campo llamado "OPERACION_QUE_REALIZA" que le da la simbología a las válvulas, este atributo es el único que se debe diligenciar en el feature antes de diligenciar la información en la tabla relacional.

Adicionalmente, quería hacer el conteo de válvulas por comuna ( Localidad) y la siguiente expresión me genera error:

var fs = FeatureSetByName($map,"Valvulas_IBAL_2021");
var valvulas = Intersects(fs, $feature);
var cnt = Count (valvulas);

if (cnt > 0) {
resultado = "Hay " + cnt + " valvulas en la comuna";

} else {
resultado = "No hay valvulas en la comuna";
}

return resultado;

agradezco la ayuda

XanderBakker

Hi @JussiLehtonen ,

The Field Calculation profile only supports $feature and $datastore. So this means that the data you want to use in the calculation must be in the same $datastore (FGDB, EGDB, hosted feature layer, etc). Although the FeatureSetByPortalItem is available, I haven't been able to use it successfully in ArcGIS Pro for a field calculation.

With the latest version of ArcGIS Dashboards, you can create featuresets on the fly with Arcade and use them as data source. This uses FeatureSetByPortalItem to access the data, so I assume that it a matter of time it will be able to use data from different data sources in an Arcade expression to calculate a field.

Jussi_Lehtonen

Is it possible to reference other layers in ArcGIS Pro project? I can refer to other layers in a webmap but how about ArcGIS Pro map or project? I am looking for a way to calculate distances to objects on other layers in ArcGIS Pro field calculator.

RickardNasstrom

Thanks for testing and your quick reply. I just tried with the same feature layer in AGOL Classic MapViewer where it works.

This is how my pop-up looks in Beta

And here is in classic:

I'll try to get rid of my special charachters, see if it helps.

Thanks for a great guide!

XanderBakker

Hi @RickardNasstrom ,

It is strange that it would not work in Map Viewer Beta, since it should. I just did a test with the example that I constructed for this post and it works as expected in the Map Viewer Beta:

The first thing where I would look at is renaming the layer and not using special characters provides a valid result. I don't see anything else that could explain this behaviour.

RickardNasstrom

Hi @XanderBakker ,

Thanks for a great example and workflow. I am basically trying to replicate this workflow, but I get stuck when trying to summarize the info in my subsectors in MapViewer Beta in AGOL. When using MapViewer Classic in Portal it works.

I wanted to use MapViewer Beta for this, and since our Portal is currently on 10.8 I shared the data through a distributed collaboration to our AGOL account. I get the previous expressions for summarizing related table records for individual assets to work.

In my Arcade window in MapViewer beta it all looks great and I get a correct looking result, in my pop-ups however, I only get a result when there is no objects in the sub-sector.

This is what it looks like when I write my expression. - It recognises dates and the number of objects.

I am quite novice in terms of using Arcade, but my guess here is that it has something to do with me not accessing the data correctly, however it seems strange to me that I get a result in the Arcade window?

Here is my code: (basically just copy/paste frome yours)

var fs = FeatureSetByName($map,"Belysningsstolpar_Gävle");
var belysning = Intersects(fs, $feature);
var cnt = Count(belysning);
Console(cnt)

var age_tot = 0;
for (var lyse in belysning) {
var age = DateDiff(Now(), lyse.Installationsdatum, "years");
age_tot += age;
Console(age_tot)
Console(lyse.Installationsdatum)
}

var resultat = "";
if (cnt > 0) {
var age_media = age_tot / cnt;
resultat = "Det finns " + cnt + " Belysningsstolpar i subsektorn";
resultat += TextFormatting.NewLine + "Medelåldern är " + Round(age_media, 2) + " år";
} else {
resultat = "Inga belysningsstolpar i subsektorn";
}

return resultat;

Could it be accessing the data or is there something different when you use MapViewer Beta?

Best Regards

Rickard

CarstenRisager

Hi Xander,

Thank you for this great example and all your answers, it's an Arcade goldmine.

I'm trying to replicate the popup functionality in one of my own webmap on a portal, but I keep running into the same error: "Execution Error:Runtime Error: Variable must be declared before it is used.." but I can't see any undeclared variables in the code.

--------------------

-------------------------------

The map is shared on: https://gis.nst.dk/portal/home/webmap/viewer.html?webmap=b8be8d61e775431c8f5a92887b49860e

I have tried almost the same code in ArcGIS Pro ($datastore instead of $map in the first line) to calculate a field and in this environment I don't get any errors.

Note: I tried the code on ArcGIS Online and it ran without any problems, so I assume that it must be the portal security kicking in somehow.

XanderBakker

Hi Michael Layne ,

Good question. As far as I know, the Attribute Calculation Rule profiel only has support for $datastore, which makes me believe that it is not possible if the information is not in the same datastore. Maybe in the feature support for other data sources will be added so that this will be possible. For now, if possible, it might be good to include the other layer in the same datastore to be able to use Attribute Rules and Arcade or schedule a task (python script) to update the information at a certain frequency.

Anonymous User

Hey Xander,

Is it possible to use arcade to reference data from another gdb?

For example, we are trying to create an attribute rule (for lines and points), where by they acquire an attribute of an intersecting polygon from another geodatabase. We are wanting to create this rule using arcpy. I've gotten it to work using $datastore with a polygon inside the same gdb, but we'd like to be able to cross reference databases. Any idea?

Anonymous User

Appreciate your efforts Xander. I had a phone call with Support and I didn't quite understand their explanation on that second parameter - I was told if it's from SQL it can be blank but if its hosted it needs it? I think you are correct in that if the layer only has one relationship, empty quotes works because it doesn't need to search through multiple relationships. Not sure why it worked for him though and not on my setup.

I did test my data by publishing as a hosted service in my Portal and the Arcade expressions all work wonderfully. So I've narrowed it down to something with SQL. My options are to backup my data, blow away the current SQL DB, create a new one and try to set this up again and see if that helps. My other option is to publish my data as it is now as a hosted service and forget trying to use SQL. I'm debating the pros/cons of doing that as I don't want to get in the middle of this data effort and hit limitations with the route I chose. Honestly nobody is editing the SQL data directly - it would all be done through Portal and Survey123, so hosted may be the way to go. Especially if this Arcade stuff works fine on the hosted data.

This project needs to be deployed next week so if I can't get this expression stuff figured out it won't prevent the project from moving forward, I was just hoping to get something simple working.

XanderBakker

Hi Nathan Fazer ,

I did some tests and providing an empty string in the FeatureSetByRelationshipName did not work for me. I don't think it is the correct way of using the function.

XanderBakker

Hi Nathan Fazer ,

I think they managed to not only the confuse you but me as well. The second parameter is not optional, and providing an empty string is not documented in the help. Maybe if you have a single relationshipclass, providing an empty string just takes the first one available and everything works, but I see no documentation to aid that assumption. Let me run some tests and get back to you.

XanderBakker

Hi Paul Sweeney ,

I am not really aware of what limitations there are when using Arcade in the dynamic text. Maybe you could use other functions like Portal and FeatureSetByPortalItem to get access to the data you need. You can also pre-calculate the data in a new field and use that static information in the map series.

Regarding your comment on using the pop-up in the map series... a pop-up will only be present when you click on a feature. You could use labeling, but Arcade functions in this profile are very limited.

Anonymous User

Xander, I sent Esri tech support my sample data with related tables and related feature classes. They brought it into a SQL environment and published it to Portal and sent me an email that this - FeatureSetByRelationshipName($feature,"",["householdcontacts_casename"]) - resulted in a successful test. When I do it, it's empty. What I found odd is in his test there is nothing in the quotes between $feature and [fieldname]. I thought that was a crucial piece of making this work is the relationship name needed to be there, like this - FeatureSetByRelationshipName($feature, "Cases_householdcontacts", ["housecontactname"].

So now I'm really confused how Esri tech support was able to get a successful test missing information and I can't get anything trying 10 variations. This seems so simple yet I either get errors or empty results.

PaulSweeney3

i want it to be an expression built into the map series. When you select dynamic text you have the option to use an arcade expression if you are inserting an attribute value or a table. They are not in the same feature service, i had not realised that was what the $datastore represented on Arcgis online but it makes sense now. it would be useful if you could essentially show your pop up on Arcgis online in a map series.

XanderBakker

Hi Paul Sweeney ,

Where do you want to calculate the count? Is that in a Field Calculation? Are the polygon and point layer part of the same feature service (are they in the same $datastore)? I haven't worked with Arcade in combination with map series, so I don't have a straight answer for you.

PaulSweeney3

Hi Xander Bakker i have created a map series from an Arcgis online Map in Arcgis pro based on a series of polygons and i wanted to count the number of intersecting points on another layer. The arcade expression works fine on ArcGIS online but in the map series it does not recognise the layer i reference in the featuresetbyname function when i use $datastore. From you responses above it sounds like there is no way to reference ArcGIS online layers in an Arcgis pro map series using arcade or am i missing something?

XanderBakker

Hi nfazer_midlandcounty ,

If Esri support provides a solution please share it here so that other user may benefit from it too.

Anonymous User

Hi Xander

Yep I just updated to 10.8.1 this past Friday from 10.8, so this should be working. I've got an open case right now with Esri so I'll pass this info along to them and see what they may be able to figure out. I appreciate the help. It works pretty well in AGO, unfortunately this project is in Portal. My other thought was to try a test on our Portal with a hosted service and see if that makes a difference, instead of referencing data in our SQL.

XanderBakker

Hi Nathan Fazer ,

Quick questions... is your Enterprise 10.8 or later? The FeatureSetByRelationshipName was introduced in Arcade version 1.8 and became available starting with Enterprise 10.8.

If you have 10.7.x you could use FeatureSetByName together with a filter on the key field to get the related records.

Have a look at:

Version Matrix | ArcGIS for Developers
and in the function reference you will find in which version it was introduced: Data Functions | ArcGIS for Developers

Anonymous User

Appreciate the help (and quick replies). I probably should have provided all the relevant info. Here's the entire code I got working in AGO based on what I've found here and in other posts. Replicating this in Portal however, gives me the error invalid parameters for count. Everything is the same - layer names, relationships, etc. So even though I made progress in my testing in AGO, this actually has to be in Portal as it's for our Health Department.

return result;

So now I'm baffled as to why this works in AGO but not in Portal.

Rejoignez la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.