Updating pop ups with new survey123 data from another layer, displaying multiple layer's data in one popup, autoselecting the most recent entry
158
2
2 weeks ago
by
Fair bit on the go there and not sure I got my head around exactly what you're looking for. Have a read of the below posts where I asked questions similar to yours whilst learning early on. It definitely is possible to look up feature attributes from other layers. You can do this using normal lookups, (e.g. by a linking value) or by searching within a distance (buffer) and getting intersecting features.
Solved: Can I populate a popup with data from a different ... - Esri Community
Help writing Arcade to get distinct values from intersection in Field Maps
Also, if you're wanting to update a feature in Field Maps after completing a Survey in S123, then callbacks may be what you're looking for (though depends on how you're launching your survey):
Solved: Help with Survey123 link from Field Maps with call... - Esri Community
Below is an example popup in one of my maps that when clicking on an Local Government boundary searches (intersects) with a Plantation layer and returns values and statistics.
This is what you see in the popup designer:
and a sample of the arcade coding used in the Plantation species summary:
//Requires that the FPC Plantations layer is also present in the map or lookups won't work
// Return LGA name and format nicely
var LGAname = proper(Split($feature.name, ", ")[1] + " " + Split($feature.name, ",")[0])
// Access the Plantations feature set, limiting to required fields only
var PlantationsFS = FeatureSetByName($map, "FPC Plantations",['Plantation', 'Map_Symbol', 'AreaHa'], False)
var SoftwoodFS = Filter(PlantationsFS, "Map_Symbol = 'Softwood'")
var HardwoodFS = Filter(PlantationsFS, "Map_Symbol = 'Hardwood'")
var SandalwoodFS = Filter(PlantationsFS, "Map_Symbol = 'Sandalwood'")
var OtherFS = Filter(PlantationsFS, "Map_Symbol = 'Other Species'")
var FallowFS = Filter(PlantationsFS, "Map_Symbol = 'Fallow'")
// Intersect the Plantations with selected LGA feature
var Ptns_fs = Intersects(PlantationsFS, $feature)
var Softwood_fs = Intersects(SoftwoodFS, $feature)
var Hardwood_fs = Intersects(HardwoodFS, $feature)
var Sandalwood_fs = Intersects(SandalwoodFS, $feature)
var Other_fs = Intersects(OtherFS, $feature)
var Fallow_fs = Intersects(FallowFS, $feature)
// Count the Plantations
var PlantationsCount = Count(Distinct(Ptns_fs, "Plantation")) //returned in popup
var SoftwoodCount = Count(Distinct(Softwood_fs, "Plantation")) //used in calulating areas only
var HardwoodCount = Count(Distinct(Hardwood_fs, "Plantation")) //used in calulating areas only
var SandalwoodCount = Count(Distinct(Sandalwood_fs, "Plantation")) //used in calulating areas only
var OtherCount = Count(Distinct(Other_fs, "Plantation")) //used in calulating areas only
var FallowCount = Count(Distinct(Fallow_fs, "Plantation")) //used in calulating areas only
//Calculate Total Area total (the values below are overwritten by the if statement)
var PlantationsArea = 0
var PlantationsResult = ""
// check to see if there are Softwood Plantations in the LGA
if (PlantationsCount > 1) {
// calculate the sum of AreaHa
PlantationsArea = Sum(Ptns_fs , "AreaHa");
PlantationsResult = Round(PlantationsArea,0) + " Ha across " + PlantationsCount + " plantations";
} else {
if (PlantationsCount == 1) {
// calculate the sum of AreaHa
PlantationsArea = Sum(Ptns_fs , "AreaHa");
PlantationsResult = Round(PlantationsArea,0) + " Ha in " + PlantationsCount + " plantation";
} else {
PlantationsResult = "No plantations in " + LGAname;
}
}
//Calculate Softwood Area total (the values below are overwritten by the if statement)
var SoftwoodArea = 0
var SoftwoodResult = ""
// check to see if there are Softwood Plantations in the LGA
if (SoftwoodCount > 1) {
// calculate the sum of AreaHa
SoftwoodArea = Sum(Softwood_fs , "AreaHa");
SoftwoodResult = Round(SoftwoodArea,0) + " Ha across " + SoftwoodCount + " plantations";
} else {
if (SoftwoodCount == 1) {
// calculate the sum of AreaHa
SoftwoodArea = Sum(Softwood_fs , "AreaHa");
SoftwoodResult = Round(SoftwoodArea,0) + " Ha in " + SoftwoodCount + " plantation";
} else {
SoftwoodResult = "No softwood";
}
}
//Calculate Hardwood Area total (the values below are overwritten by the if statement)
var HardwoodArea = 0
var HardwoodResult = ""
// check to see if there are Hardwood Plantations in the LGA
if (HardwoodCount > 1) {
// calculate the sum of AreaHa
HardwoodArea = Sum(Hardwood_fs , "AreaHa");
HardwoodResult = Round(HardwoodArea,0) + " Ha across " + HardwoodCount + " plantations";
} else {
if (HardwoodCount == 1) {
// calculate the sum of AreaHa
HardwoodArea = Sum(Hardwood_fs , "AreaHa");
HardwoodResult = Round(HardwoodArea,0) + " Ha in " + HardwoodCount + " plantation";
} else {
HardwoodResult = "No hardwood";
}
}
//Calculate Sandalwood Area total (the values below are overwritten by the if statement)
var SandalwoodArea = 0
var SandalwoodResult = ""
// check to see if there are Sandalwood Plantations in the LGA
if (SandalwoodCount > 1) {
// calculate the sum of AreaHa
SandalwoodArea = Sum(Sandalwood_fs , "AreaHa");
SandalwoodResult = Round(SandalwoodArea,0) + " Ha across " + SandalwoodCount + " plantations";
} else {
if (SandalwoodCount == 1) {
// calculate the sum of AreaHa
SandalwoodArea = Sum(Sandalwood_fs , "AreaHa");
SandalwoodResult = Round(SandalwoodArea,0) + " Ha in " + SandalwoodCount + " plantation";
} else {
SandalwoodResult = "No sandalwood";
}
}
//Calculate Other Species Area total (the values below are overwritten by the if statement)
var OtherArea = 0
var OtherResult = ""
// check to see if there are Other Species Plantations in the LGA
if (OtherCount > 1) {
// calculate the sum of AreaHa
OtherArea = Sum(Other_fs , "AreaHa");
OtherResult = Round(OtherArea,0) + " Ha across " + OtherCount + " plantations";
} else {
if (OtherCount == 1) {
// calculate the sum of AreaHa
OtherArea = Sum(Other_fs , "AreaHa");
OtherResult = Round(OtherArea,0) + " Ha in " + OtherCount + " plantation";
} else {
OtherResult = "No other species";
}
}
//Calculate Fallow Area total (the values below are overwritten by the if statement)
var FallowArea = 0
var FallowResult = ""
// check to see if there are Fallow areas in the LGA
if (FallowCount > 1) {
// calculate the sum of AreaHa
FallowArea = Sum(Fallow_fs , "AreaHa");
FallowResult = Round(FallowArea,0) + " Ha across " + FallowCount + " plantations";
} else {
if (FallowCount == 1) {
// calculate the sum of AreaHa
FallowArea = Sum(Fallow_fs , "AreaHa");
FallowResult = Round(FallowArea,0) + " Ha in " + FallowCount + " plantation";
} else {
FallowResult = "No fallow areas";
}
}
// Output dictionary as fields to display in the pop-up
return {
type: 'fields',
title: 'Plantation Summary (by species)',
//description : "",
fieldInfos: [{
fieldName: " " // fieldName should match the key in the attributes dictionary
},
{
fieldName: "All Species" // fieldName should match the key in the attributes dictionary
},
{
fieldName: "Softwood" // fieldName should match the key in the attributes dictionary
},
{
fieldName: "Hardwood" // fieldName should match the key in the attributes dictionary
},
{
fieldName: "Sandalwood" // fieldName should match the key in the attributes dictionary
},
{
fieldName: "Other Species" // fieldName should match the key in the attributes dictionary
},
{
fieldName: "Fallow" // fieldName should match the key in the attributes dictionary
}],
attributes : {"All Species" : PlantationsResult, "Softwood" : SoftwoodResult, "Hardwood" : HardwoodResult, "Sandalwood" : SandalwoodResult, "Other Species" : OtherResult, "Fallow" : FallowResult} // replace this dictionary with your own key-value pairs
}
