How to build an app to filter land parcels by multiple themes

[OliverIshmael]

I have been tasked with building an ArcGIS Online app that will let users filter land parcels based on thematic categories that intersect them. For example, show me all land parcels that have a waterfall.

To this end, I plan to run an intersect query for each theme and then save the output as a new layer for users to switch on and off.

However, if users wish to find all land parcels where 2 or more themes are present they would need to run their own intersect query in the browser, which could consume a lot of credits.

Alternatively, I could create a matrix in Excel that users could filter on, but with many themes and over 3,000 land parcels this will be very laborious!

Please can you suggest alternative solutions for me to consider?

[OliverIshmael · Accepted solution]

To solve this. I dissolved the features on a Reference ID field to create unique land parcels. Then I ran intersect queries on the land parcel layer for each theme and exported the result as a new geodatabase feature class.  

Next i used FME to merge all of the feature class themes into a single dataset and pivot the attribute tables, grouping the rows by the Reference ID and the columns by Theme. Where the total count of a theme is >=1 the theme was present in that land parcel. The result was output to ArcGIS Online.

Finally, in Experience Builder i was able to set up filters using SQL to turn off land parcels that didn't match the users criteria.