Hi, I have looked at several Arcade related postings and trying to string together some code to perform the following operation: 1) Intersect a point feature layer with related table with regional polygon feature layer (LLS Layer is where the Arcade expression is being displayed in pop-up): This portion works ok, but I may need to know the count of 'species sampled'. f.species is within the feature layer. 2) I wish to summarise records in the point feature layer related table: End result is pop-up will show: * region name [from feature layer] * f.species and count [from feature layer] * microbe name and the count of microbe (eg. above would be 'Pasteruella aerogenes: 4 samples') [related table] * Each test item and count (eg. 'Amikacin - Intermediate (3 samples)) [related table] * I will also need a decision tree if I have cases where I have a number of mixed samples intermediate/sensitive/resistant) [related table] I am thinking I will need one common expression tailored for: * each microbe or * each microbe and each test item or * combinations or each Advice greatly appreciated.

Hi Craig Poynter , Creating a html table with an Arcade expression is only possible in ArcGIS Pro at the moment. So, yes it would be possible, but only in ArcGIS Pro. In ArcGIS Online, any html returned is not parsed as html but as plain text. To create a html styles table with content from the related table would requiere an arcade expression for each cell of the table and some additional one to hide rows if there is not content. This would take hundreds of Arcade expressions, and forever to return the result to the user. For now, if this 10-15 seconds of processing time is acceptable for your end users (personally, I don't think it will be) you could include the other information as plain text in the pop-up. You need to take into account that when information starts to grow, processing time will further increase.

Hi Xander Bakker, These are a great result. Is it possible to have a result so that it lists Species (eg. equine) > Microbe (eg. Blood Culture) > Treatment > Sensitivity result? If I had a template for one combination I could repeat for each of the combinations I would need to compile for adding to a html table (many copies of the same expression to build my table). I am thinking this would require filtering by species, then microbe and then treatment and result. Accessing the related tables and the associated syntax had me struggling. Is this a possibility? I appreciate all you have achieved so far. Regards, Craig

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

Arcade: Intersect feature layers and summarise related table fields

CPoynter

Hi,

I have looked at several Arcade related postings and trying to string together some code to perform the following operation:

1) Intersect a point feature layer with related table with regional polygon feature layer (LLS Layer is where the Arcade expression is being displayed in pop-up):

This portion works ok, but I may need to know the count of 'species sampled'. f.species is within the feature layer.

2) I wish to summarise records in the point feature layer related table:

End result is pop-up will show:

region name [from feature layer]
f.species and count [from feature layer]
microbe name and the count of microbe (eg. above would be 'Pasteruella aerogenes: 4 samples') [related table]
Each test item and count (eg. 'Amikacin - Intermediate (3 samples)) [related table]
I will also need a decision tree if I have cases where I have a number of mixed samples intermediate/sensitive/resistant) [related table]

I am thinking I will need one common expression tailored for:

each microbe or
each microbe and each test item or
combinations or each

Advice greatly appreciated.

Trouver plus de publications taguées avec

Accepted answers

All comments

XanderBakker

Hi Craig Poynter ,

For the summary you could use the GroupBy function. This will allow you to summarize on a featureset and get the count of microbes. To learn more about the GroupBy function I recommend you to read the blog post by Paul Barker: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/whats-new-in-arcade/

I also have a document explaining the use of GroupBy in a more detailed way, but this is in Spanish: https://community.esri.com/docs/DOC-13951-incluir-reportes-estadísticas-en-las-ventanas-emergentes-con-arcade-usando-groupby

CPoynter

Hi Xander Bakker,

Thank you for the links. I have had a read, but syntax is confusing me with trying to summarise from layer file and associated records in related table. $map, $datastore, $feature, $layer usage and pulling from related table fields is proving difficult.

I can add you to a group if you wished to look at data if that helps.

Regards,

Craig

XanderBakker

Hi cpoynter ,

Sure, having access to the data would help a lot to see what is possible! My AGOL user is "xbakker.spx".

CPoynter

Hi Xander Bakker,

I invited you to Group.

Regards,

Craig

CPoynter

Hi Xander Bakker,

I also wish to add the output to a html formatted table.

Regards,

Craig

Czapiga_Jason

Thank you so much! I've been trying to figure this out for weeks. I had a similar workflow, but my code only returned one record from the related table. I used the example you posted above and it worked great! Here's mine that DID NOT work as an example for others that might be taking this path...use Xander's solution above!

var complaintPts = FeatureSetByName($map,"ComplaintPoints",['*'],true)
var townComplaints = Intersects($feature, complaintPts)
var tbl = FeatureSetByName($map,"IncidentRepeat",['*'],true);
var FeatureID =''
for (var f in townComplaints)
{
FeatureID = f.globalid
var sql = "parentglobalid = '" + FeatureID + "'"
var complaints = Filter(tbl,sql)
var x = GroupBy(complaints,'Species',
{name: 'SpCount', expression: '1', statistic: 'COUNT'})

var popup=""
for (var row in x){
popup += row.Species +": "+row.SpCount + TextFormatting.NewLine
}
}
return popup

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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