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; } } }

Použití funkcí FeatureSetBy v Arcade pro podrobné prozkoumání dalších vrstev a tabulek

XanderBakker

<\/HEAD>

Dnes byl zveřejněn skvělý blog od Paul Barker<\/A> o nových funkcích FeatureSet: Co je nového v Arcade: Procházka skrz FeatureSets (Část 1)<\/A> a také Kelly Gerrow<\/A> sdílela skvělý dokument na toto téma: 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>

Nechtěl jsem zůstat pozadu, tak jsem si řekl, že sdílím několik příkladů s použitím hydrantů, historie údržby a podsektorů a hydraulických sektorů, abych ukázal, co můžete dosáhnout s novými funkcemi Arcade vydanými v ArcGIS Online 5. prosince.<\/P>

<\/P>

Předpokládejme, že máme webovou mapu s několika vrstvami a tabulkou:<\/P>

<\/P>

Hidrantes<\/EM> je bodová vrstva s hydrantySub Sector<\/EM> je polygonová vrstva s podrozdělením oblasti zájmuSector Hidraulico<\/EM> je polygonová vrstva slučující podsektory do hydraulických sektorůHist Mantenimiento<\/EM> je tabulka s historickými záznamy údržby pro každý hydrant<\/LI><\UL><\P>Nejprve aplikujme Arcade pro vizualizaci hydrantů na základě jejich stáří. To již bylo možné v předchozím vydání, takže zde zatím nic nového. Máme datum instalace uložené ve sloupci FECHAINSTALACION a můžeme použít funkce DateDiff<\EM> a Now<\EM>, abychom určili stáří v letech, což se děje v prvních dvou řádcích. Poté klasifikujeme hodnotu do významných rozsahů:<\P>var<\SPAN> fecha_inst =<\SPAN> $feature.<\SPAN>FECHAINSTALACION;<\SPAN> var<\SPAN> edad =<\SPAN> DateDiff<\SPAN>(Now<\SPAN>()<\SPAN>, fecha_inst, "years"<\SPAN>);<\SPAN> var<\SPAN> clase_edad =<\SPAN> ""<\SPAN>;<\SPAN> if<\SPAN> (edad > 50) { clase_edad = "Více než 50 let"; } else if (edad > 40) { clase_edad = "Mezi 40 a 50 lety"; } else if (edad > 30) { clase_edad = "Mezi 30 a 40 lety"; } else if (edad > 20) { clase_edad = "Mezi 20 a 30 lety"; } else if (edad > 10) { clase_edad = "Mezi 10 a 20 lety"; } else if (edad > 5) { clase_edad = "Mezi 5 a 10 lety"; } else { clase_edad = "Méně než 5 let"; } return clase_edad; <<EMOJI_0>><\span><<EMOJI_1>><\span><<EMOJI_2>><\span><<EMOJI_3>><\span><<EMOJI_4>><\span><<EMOJI_5>><\span><<EMOJI_6>><\span><<EMOJI_7>><\span><<EMOJI_8>><\span><<EMOJI_9>><\span><<EMOJI_10>><\span><<EMOJI_11>><\span><<EMOJI_12>><\span><<EMOJI_13>><\span><<EMOJI_14>><\span><<EMOJI_15>><\span><<EMOJI_16>><\span><<EMOJI_17>><\span><<EMOJI_18>><\span><<EMOJI_19>><\span></pre>Výsledkem je text popisující stáří, pro který můžeme definovat reprezentativní symboly (zde používáme symboly Firefly):<img class="image-2 jive-image" src="https://us.v-cdn.net/6038851/uploads/legacyfs/online/431467_pastedImage_10.png" />Pro ostatní dvě polygonové vrstvy nejsou použity žádné efektní symboly, aby nebyla odváděna pozornost od hydrantů.Chtěli bychom zobrazit v pop-up okně každého hydrantu seznam veškeré údržby provedené na hydrantu. Jak tabulka historie údržby, tak vrstva hydrantů obsahují ID hydrantu. Tabulka také obsahuje data a typ údržby.V konfiguraci pop-up okna hydrantů můžeme přidat Arcade výraz jako tento:<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 + " Údržba(y):"; pro <\/SPAN> (<\/SPAN>var<\/SPAN> mantenimiento v<\/SPAN> mantenimientos)<\/SPAN> {<\/SPAN>\n        var<\/SPAN> txt_fecha =<\/SPAN> Text<\/SPAN>(<\/SPAN>mantenimiento.<\/SPAN>Fecha_Mantenimiento,<\/SPAN> ' - (Y\/MM\/DD) '<\/SPAN>)<\/SPAN>;<\/SPAN>\n        var<\/SPAN> txt_man =<\/SPAN> txt_fecha +<\/SPAN> mantenimiento.<\/SPAN>Mantenimiento;<\/SPAN>\n        historia +<\/SPAN>=<\/SPAN> TextFormatting.<\/SPAN>NewLine +<\/SPAN> txt_man;<\/SPAN>\n    }<\/SPAN>\n}<\/SPAN> jinak<\/SPAN> {<\/SPAN>\n    historia =<\/SPAN> "Žádné údržby nejsou"<\/SPAN>;<\/SPAN>\n}<\/SPAN>\n\nvrátit<\/SPAN> historia;<\/SPAN> \n‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/span>‍‍>‍>‍>‍>‍>‍>‍>‍>‍>Především přistupujeme k tabulce s historií údržby a přiřazujeme ji do proměnné tbl. Poté čteme ID aktuálního hydrantu, pro který chceme vytvořit pop-up. Definujeme SQL výraz pomocí ID hydrantu, který se pak použije k filtrování tabulky historie. Výsledek je uložen v proměnné nazvané mantenimientos. Můžeme provést Count, abychom získali počet údržeb provedených na hydrantu. Pokud je počet (cnt) větší než 0, začneme číst podrobnosti a sestavovat seznam údržby včetně data a typu údržby.

Výsledek bude vypadat takto poté, co nakonfigurujeme jednoduchý vlastní HTML pro zobrazení atributů a výsledku Arcade výrazu v pop-upu:

Nyní pokračujme s využitím těchto nových funkcí Arcade k získání dat o hydrantech na úrovni podsektoru. Jelikož počet údržeb samozřejmě závisí na stáří hydrantu, bylo by hezké získat nějaké podrobnosti o tom na úrovni podsektoru.

V konfiguraci pop-upu podsektorů můžeme přidat následující Arcade výraz:

<span class="keyword token">var</span> fs <span class="operator token">=</span> <span class="token function">FeatureSetByName</span>( $datastore , "Hidrantes" ) ;
<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">pro</span>( var hidrante in hidrantes ) {
&nbsp;&nbsp;&nbsp; var edad = DateDiff( Now() , hidrante.FECHAINSTALACION , "years" ) ;
&nbsp;&nbsp;&nbsp; edad_tot += edad ;
}

<span class="keyword token">var</span> resultado = "" ; 
<span class="keyword token">pokud</span>( cnt > 0 ) {
&nbsp;&nbsp;&nbsp; var edad_media = edad_tot / cnt ;
&nbsp;&nbsp;&nbsp; resultado = "Je zde " + cnt + " hydrantů v podsektoru" ;
&nbsp;&nbsp;&nbsp; resultado += TextFormatting.NewLine + "Průměrný věk hydrantů je " + Round(edad_media, 2) + " let" ;
} jinak {
&nbsp;&nbsp;&nbsp; resultado = "V podsektoru nejsou žádné hydranty" ;
}

<span class="keyword token">vrátit</span> resultado ;
<span class="line-numbers-rows"><Span><<EMOJI_19>></Span><Span><<EMOJI_20>></Span><Span><<EMOJI_21>></Span><Span><<EMOJI_22>></Span><Span><<EMOJI_23>></Span><Span><<EMOJI_24>></Span><Span><<EMOJI_25>></Span><Span&gt.<. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span><. ></Span>

Tento výraz udělá:<p>- Přístup k vrstvě Hydrants<p>- Provede průnik s aktuálním prvkem podsektoru<p>- Spočítá počet hydrantů v podsektoru<p>- Vypočítá věk každého hydrantu a sečte všechny věky<p>- Vypočítá průměrný věk hydrantů a formátuje text s touto informací<p>
Výsledek bude vypadat takto:<p>
<img src='https://us.v-cdn.net/6038851/uploads/legacyfs/online/431475_pastedImage_15.png' alt='Výsledek' />
<p>
V tomto případě je v podsektoru 93 hydrantů a průměrný věk je 20,64 let.
<p>
To je zábava, ale můžeme také zobrazit názvy podsektorů, které jsou obsaženy v hydraulickém sektoru pomocí těchto nových funkcí Arcade? Odpověď je ano. Přidáme následující výraz do hydraulických sektorů:<pre>
var fs = FeatureSetByName($datastore, "Sub Sector");
var subsectores = Intersects(fs, $feature);
var cnt = Count(subsectores);

var resultado = "Seznam " + cnt + " Podsektorů:";
<span  class="keyword token">for<\/SPAN> <SPAN class="punctuation token">(<\/SPAN><SPAN class="keyword token">var<\/SPAN> subsektor <SPAN class="keyword token">in<\/SPAN> subsectores<SPAN class="punctuation token">)<\/SPAN> <SPAN class="punctuation token">{<\/SPAN>
&nbsp;&nbsp;&nbsp; vysledek <SPAN class="operator token">+<\/SPAN><SPAN class="operator token">=<\/SPAN> TextFormatting<SPAN class="punctuation token">.<\/SPAN>NewLine <SPAN class="operator token">+<\/SPAN> subsektor<SPAN class="punctuation token">.<\/SPAN>IDSAP<SPAN class="punctuation token">;<\/SPAN>
<SPAN class="punctuation token">}<\/SPAN>

<SPAN class="keyword token">return<\/SPAN> vysledek<SPAN class="punctuation token">;<\/SPAN>
<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>Stačí přistoupit k vrstvě sub sektorů a provést Intersect s aktuálním hydraulickým sektorem a voilà3, správně? Ne, ne tak docela. Když použijete Intersect mezi dvěma polygonovými vrstvami, pravděpodobně vrátí příliš mnoho prvků kvůli tomu, že když dva polygony mají společnou hranici, pravděpodobně budou zahrnuty ve výsledku, což vede k více sub sektorům, než chceme.<\/P><P><\/P><P>Způsob, jak tomu předejít, je použít malý záporný buffer na hydraulický sektor a provést Intersect s touto bufferovanou geometrií takto:<\/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>
<SPAN class="keyword token">var<\/SPAN> feature_buf <SPAN class="operator token">=<\/SPAN> <SPAN class="token function">Buffer<\/Span>(<$feature>, -100, 'meters');
<span class="keyword token">var</span> subsectores = Intersects(fs, feature_buf); 
<span class="keyword token">var</span> cnt = Count(subsectores);

<span class="keyword token">var</span> vysledek = "Listado de los " + cnt + " Subsectores:";
<span class="keyword token">for</span> (<span class="keyword token">var</span> subsektor in subsectores) {
   vysledek += TextFormatting.NewLine + subsektor.IDSAP;
}

<span class="keyword token">return</span> vysledek;
<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>

Pozorujte Buffer se zápornou vzdáleností, který je vytvořen na řádku 2 a použit na řádku 3 pro získání správných polygonů.<\/P>

Výsledný pop-up se zobrazí takto:<\/P>

Abych byl upřímný, nelíbí se mi neuspořádaný seznam sub sektorů, takže tento seznam seřadíme pomocí OrderBy<\/EM>:<\/P>
var fs = FeatureSetByName($datastore,"Sub Sector"); var feature_buf = Buffer($feature, -100, 'meters'); var subsectores = OrderBy(Intersects(fs, feature_buf), 'IDSAP ASC'); var cnt = Count(subsectores); var vysledek = "Listado de los " + cnt + " Subsectores:"; for (var subsektor in subsectores) { vysledek += TextFormatting.NewLine + subsektor.IDSAP; } return vysledek; <<EMOJI_21>><<EMOJI_22>><<EMOJI_23>><<EMOJI_24>><<EMOJI_25>>

Který bude mít za následek seřazený seznam sub sektorů:<\/P>

Doufám, že tyto příklady vám pomohou pochopit, co je možné pomocí Arcade s nejnovější aktualizací v ArcGIS Online, ale než začnete vytvářet úžasné Arcade výrazy, chci na chvíli citovat strýčka Bena (Spider-Man):<\/P>

S velkou mocí přichází velká odpovědnost...<\/EM>

Jak zmiňuje Paul Barker<\/A> ve svém blogu, buďte opatrní a vždy ověřte, že výkon vašich výrazů přináší přijatelnou dobu odezvy pro vašeho koncového uživatele.<\/>

Najděte více příspěvků označených jako

Komentáře

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Nový zde? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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