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

Expressie met FeatureSet om contextuele gegevens uit een andere laag aan een pop-up toe te voegen, geeft geen resultaten

FPGIS_FrancescaRohr

Hallo,

Ik pas de pop-up van mijn hoofdlaag (laag A) in een webkaart aan en wil informatie uit een aparte laag (laag opnemen. Beide lagen bevatten puntobjecten. Laag A bevat boompunten en laag B inspecties van die bomen, één inspectie per boom. Niet alle bomen zijn geïnspecteerd. Mijn expressie geeft echter niet de gewenste resultaten.

Regel 1 van mijn expressie maakt een unieke ID aan op basis van twee velden in laag A:

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

Regel 2 van mijn expressie gebruikt FeatureSetByName om toegang te krijgen tot de attributen van laag B:

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

Regel 3 voegt een filterStatement toe om de records in laag A en B met elkaar te laten overeenkomen:

var filterStatement = "Tree_UniqueID = @treeuniqueid"

Regels 4 en 5 gebruiken Filter om alleen de informatie voor het geselecteerde boompunt in de webkaart op te halen.

var inspected = Filter(inspection, filterStatement)
return inspected

In het expressievenster zie ik dat ik toegang heb tot de attributen van laag B:

maar in de pop-up zelf krijg ik dit te zien:

Is het een probleem om de aangemaakte variabele treeuniqueid te gebruiken om de tabellen van de twee lagen als het ware te ‘joinen’?

Wat zie ik nog over het hoofd? Alle hulp is welkom. Alvast bedankt, Francesca

Vind meer berichten getagd met

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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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