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

Ausdruck mit FeatureSet zum Hinzufügen kontextbezogener Daten aus einem anderen Layer im Pop-up liefert keine Ergebnisse

FPGIS_FrancescaRohr

Hallo,

ich passe das Pop-up für meinen Haupt-Layer (Layer A) in einer Webkarte an und möchte Informationen aus einem separaten Layer (Layer einfügen. Beide Layer enthalten Punkt-Features. Layer A zeigt Baumstandorte und Layer B die Inspektionen dieser Bäume, wobei es eine Inspektion pro Baum gibt. Nicht für alle Bäume liegen Inspektionen vor. Mein Ausdruck liefert jedoch nicht die gewünschten Ergebnisse.

Zeile 1 meines Ausdrucks erstellt anhand zweier Felder in Layer A eine eindeutige ID:

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

Zeile 2 meines Ausdrucks verwendet FeatureSetByName, um auf die Attribute in Layer B zuzugreifen:

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

Zeile 3 fügt eine filterStatement hinzu, um die Datensätze in Layer A und B einander zuzuordnen:

var filterStatement = "Tree_UniqueID = @treeuniqueid"

In den Zeilen 4 und 5 verwende ich Filter, um nur die Informationen zum ausgewählten Baum-Punkt in der Webkarte zurückzugeben.

var inspected = Filter(inspection, filterStatement)
return inspected

Im Ausdrucksfenster wird angezeigt, dass ich auf die Attribute in Layer B zugreife:

im Pop-up selbst wird jedoch Folgendes angezeigt:

Ist es ein Problem, die erstellte Variable treeuniqueid zu verwenden, um die Tabellen der beiden Layer im Prinzip zu verknüpfen?

Was übersehe ich sonst noch? Für jede Hilfe bin ich dankbar. Vielen Dank, Francesca

Finde mehr Beiträge mit dem Tag

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.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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