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

Výraz využívající FeatureSet k přidání kontextových údajů z jiné vrstvy do vyskakovacího okna nevrací žádné výsledky

FPGIS_FrancescaRohr

Dobrý den,

Upravuji vyskakovací okno hlavní vrstvy (vrstva A) ve webové mapě a chci do něj zahrnout informace z jiné vrstvy (vrstva . Obě vrstvy obsahují bodové prvky. Ve vrstvě A jsou body znázorňující stromy a ve vrstvě B kontroly těchto stromů, přičemž na každý strom připadá jedna kontrola. Ne všechny stromy ale mají záznam o kontrole. Můj výraz však nevrací požadované výsledky.

Řádek 1 mého výrazu vytvoří jedinečné ID ze dvou polí ve vrstvě A:

var treeuniqueid = Text($feature["Grant_ID"]+"_"+$feature["Tree_ID"])

Řádek 2 mého výrazu pomocí funkce FeatureSetByName načte atributy z vrstvy B:

var inspection = FeatureSetByName($map,"UCF Tree Inspections - UCF Tree Inspections")

Řádek 3 přidá filtr, který propojí záznamy ve vrstvách A a B:

var filterStatement = "Tree_UniqueID = @treeuniqueid"

Řádky 4 a 5 pomocí funkce Filter vrátí pouze informace o vybraném bodu stromu ve webové mapě.

var inspected = Filter(inspection, filterStatement)
return inspected

V okně výrazu se zobrazuje, že přistupuji k atributům vrstvy B:

ve vyskakovacím okně se mi ale zobrazuje toto:

Může být problém v tom, že pomocí vytvořené proměnné treeuniqueid v podstatě „propojuji“ tabulky z obou vrstev?

Co mi ještě uniká? Budu vděčná za jakoukoli pomoc. Děkuji, Francesca

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

Arcade

Accepted answers

XanderBakker

Hi @FPGIS_FrancescaRohr ,

Sorry for the delay, but I was stuck in some meetings. I just had a look at the data and I think I have the answer. As you can see it now returns the number of inspections:

There was just a tiny mistake in the expression. when you construct the SQL you use an underscore "_" when the data uses a hyphen "-". Also in my case the name of the layer was a bit different, but this could just be for me.

All comments

XanderBakker

Hi @FPGIS_FrancescaRohr ,

The problem, in this case, is that you are returning a featureset to the pop-up. That is something the pop-up can't visualize. It does show in the expression builder, but this does not mean that it will show in the pop-up. You will probably have to loop through the features in the featureset and construct the text that you want to return.

Have a look at https://community.esri.com/t5/arcgis-online-documents/using-featuresetby-functions-in-arcade-to-drill-down-to-other/ta-p/918691 and the second code block where a list of maintenances of a hydrant is formatted and returned to the pop-up.

FPGIS_FrancescaRohr

Hello @XanderBakker

Thank you for the article link, it was very helpful. I simplified the expression from the article and customized it to work for my data:

var inspections = FeatureSetByName($map,"UCF Tree Inspections - UCF Tree Inspections")
var treeuniqueid = Text($feature["Grant_ID"]+"_"+$feature["Tree_ID"])
var sql = "Tree_UniqueID = @treeuniqueid"
Console(sql)
var inspection = Filter(inspections, sql)
var cnt = Count(inspection)
var history = ""
if (cnt > 0){
history = cnt + "inspection(s):"
}
else {
history = "No inspections"
}
return history

I changed var sql from:

var sql = "Tree_UniqueID = '" + treeuniqueid + "'" to:

var sql = "Tree_UniqueID = @treeuniqueid"because I wasn't getting any return in my pop-up. Now I get 'No inspections' even when an inspection has occurred. Obviously var sql line is incorrect. I followed the example given for attribute related data in https://www.esri.com/arcgis-blog/products/arcgis-online/data-management/pump-up-your-pop-ups-with-arcade-and-the-living-atlas/

I can't find any specific documentation on how to successfully create this variable. It's difficult to know the limits of Arcade - is there an issue with using a created variable as the 'field' on which to match (join) two data layers? My hope is that I just haven't learned how to do it yet.

XanderBakker

Hi @FPGIS_FrancescaRohr ,

Quick question: does your data use a Relationshipclass? If so, you are probably better off using the "FeatureSetByRelationshipName" to get to the related records.

FPGIS_FrancescaRohr

Hi @XanderBakker

No, the inspections are not a related table to the tree data.

XanderBakker

Hi @FPGIS_FrancescaRohr ,

Sorry for the delay, but I was in meetings all afternoon. I was looking at the expression and I can't see any problem with it. I assume as you do that it concerns the SQL. I think you are creating it correctly, but I can't validate without having access to the data. In case possible, can you share the data? You could create a group, share the data to that group and invite me using "xbakker.spx" to the group.

Some minor changes to your expression, but none that will solve the issue.

var inspections = FeatureSetByName($map, "UCF Tree Inspections - UCF Tree Inspections");
var treeuniqueid = $feature["Grant_ID"] + "_" + $feature["Tree_ID"];
var sql = "Tree_UniqueID = @treeuniqueid";
Console(sql);

var inspection = Filter(inspections, sql);
var cnt = Count(inspection);
var history = "";

if (cnt > 0) {
    history = "inspection(s): " + cnt;
} else {
    history = "No inspections";
}

return history;

FPGIS_FrancescaRohr

Hi @XanderBakker

I have created an AGOL group - FROHR Private and invited you join. I have shared the UCF Tree Inspections layer and the CAL FIRE UCF Tree Data layer with this group. Both are views but should work for you.

I made the small changes to the expression and, as you expected, continue to get a return of 'No inspections' for every tree point.

I appreciate your help on this. Francesca

XanderBakker

Hi @FPGIS_FrancescaRohr ,

Sorry for the delay, but I was stuck in some meetings. I just had a look at the data and I think I have the answer. As you can see it now returns the number of inspections:

FPGIS_FrancescaRohr

@XanderBakker It's always something small! 😄 Nice job in spotting the teeny mistake which brought down the whole expression. And for pointing me in the right direction. Thank you very much! I can now use this as a base for adding additional, more complex, information from the contextual layer.

XanderBakker

Hi @FPGIS_FrancescaRohr ,

I'm glad it was fixed. If you need some more help further along the line, don't hesitate to tag me.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? 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.