POST
|
Hello, I am working on a citizen science project where we need at least 3 surveys completed at 45 different lakes. We are using survey123 and AGOL to try and create a map showing how many surveys have been conducted and how many surveys are needed. We have successfully joined the survey feature layer with a point layer (representing each of the 45 lakes) with success and have been able to write an Arcade expression to show how many surveys have been completed in the popup. We would now like to label this Joined Feature using the same Arcade expression used in cinfig pop-up. But it does not work with the message " Parse Error: featuresetbyname is not available". Any thoughts on this issue would be much appreciated. The following is the code we use to to see the number of surveys submitted at each lake. var sql = "selectTerritory = '" + $feature . selectTerritory + "'" ; var tbl = Filter ( FeatureSetByName ( $map , "Survey123Form_July2019_ForNPS - surveyPoint" ) , sql ) ; var tblCnt = count ( tbl ) When ( tblCnt < 3 , "#FF0000" , tblCnt == 4 , "#FFFF00" , tblCnt == 5 , "#FFFF00" , tblCnt == 6 , "#FFFF00" , tblCnt == 7 , "#FFFF00" , tblCnt > 8 , "#008000" , null ) return tblCnt - 1
... View more
09-24-2019
09:46 AM
|
0
|
1
|
88
|
POST
|
Hi Doug, Thank you for the help. I just had a couple follow up questions. We are wanting this map to be dynamic, as surveys come in the map will show how many surveys are completed. If I join the two FC (Lakes and Surveys) together will that layer be dynamic? I tried to hack your code above with no success. Would you mind looking it over? The two layers I am working with are 1) "Loon Priority Lake" and 2) "Survey Point". The common field between them is "selectTerritory". Thank you for your patience, my coding abilities are very limited. var sql = "Loon Priority Lake = '" + $feature . selectTerritory + "'" ; var tbl = Filter ( FeatureSetByName ( $map , "Survey Point" ) , sql ) ; var tblCnt = count ( tbl ) if ( tblCnt < 1 ) { return "\n----No Surveys Conducted" } else if ( tblCnt > 1 ) { return "\n----More than 1 Survey Conducted" } else { return '' }
... View more
09-19-2019
10:13 AM
|
0
|
1
|
8
|
POST
|
Hello, I am working on a citizen science project where we need at least 3 surveys completed at 45 different lakes. We are using survey123 and AGOL to try and create a map showing how many surveys have been conducted and how many surveys are needed. We have tried the summarize nearby fundtion, which does not update in real time and are currently trying to join the survey feature layer with a point layer (representing each of the 45 lakes) without any success. Any thoughts would be greatly appreciated.
... View more
09-19-2019
06:10 AM
|
0
|
5
|
129
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|