topic Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results in ArcGIS Online Questions

Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

FPGIS_FrancescaRohr — Mon, 10 May 2021 19:20:36 GMT

Hello,

I am customizing the pop-up on my main layer (layer A) in a web map and want to include information from a separate layer (layer B). Both layers are point features. Layer A is tree points and Layer B is inspections on those trees, one inspection per tree. Not all trees have inspections. However, my expression is not returning the desired results.

Line 1 of my expression creates a unique id from two fields in layer A:

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

Line 2 of my expression uses FeatureSetByName to access the attributes from layer B:

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

Line 3 adds in a filterStatement to match the records in layers A & B:

var filterStatement = "Tree_UniqueID = @treeuniqueid"

Lines 4&5 use Filter to only return the information for the selected tree point in the web map.

var inspected = Filter(inspection, filterStatement)
return inspected

In the expression window the results show that I am accessing layer B attributes:

but I get this in the pop-up itself:

Is using the created variable treeuniqueid to essentially 'join' the tables from the two layers an issue?

What else am I missing? Any and all help appreciated. Thank you, Francesca

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

XanderBakker — Tue, 11 May 2021 21:59:23 GMT

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.

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

FPGIS_FrancescaRohr — Thu, 13 May 2021 16:33:50 GMT

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.

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

XanderBakker — Thu, 13 May 2021 17:50:08 GMT

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.

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

FPGIS_FrancescaRohr — Thu, 13 May 2021 18:30:10 GMT

Hi @XanderBakker

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

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

XanderBakker — Thu, 13 May 2021 23:17:20 GMT

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;

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

FPGIS_FrancescaRohr — Fri, 14 May 2021 15:48:27 GMT

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

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

XanderBakker — Fri, 14 May 2021 19:12:20 GMT

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.

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

FPGIS_FrancescaRohr — Fri, 14 May 2021 20:14:37 GMT

@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.

Re: Expression using FeatureSet to add contextual data from another layer in pop-up not returning results

XanderBakker — Fri, 14 May 2021 21:00:30 GMT

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.