Consider the following screenshot. What I have there is a point feature layer (Properties), containing some attribute data pertaining to every blue pin on the map. I also have multiple polygon layers covering the map, so that "under" each pin there are three polygon layers, each of which contains its own attributes. The polygons from different layers overlap, but they are not the same.
Here is the question: how can I filter the point layer (the pins) not only by the point attributes, but also by the attributes of the polygon layers that the point belongs to? So, in my specific example, I want the map to only show pins where, for example (using the layers found on the screenshot):
* the pin attribute of "number of floors" is greater than 3 (from the Properties layer) AND
* the census tract that the pin is in has Affordability Index of greater than 50 (from the Location Affordability Index Data layer) AND
* the statistical area that the pin is in has Median Age of greater than 30 (from the usa_cbsa layer) AND
* the school attendance area that the pin belongs to has Total Enrollment of less than 300 (from the SABS_1516_Primary layer)
I understand that I could run a Spatial Join and merge all the attributes of all the polygon layers into the point layer and then just filter by that joined layer's attributes, but it would burn through a ton of credits and will result in a monster layer with hundreds of attributes (possibly pushing up against the limit of 255).
Is there a way to query this data across the multiple layers on the fly, without pre-joining it?
Your procedure of spatial join to get all the attributes is the way to go.
You have this posted in the ArcGIS Pro community. If preprocessing before publishing is not an option and If you need an AGOL solution, I could move it there if you like
If you have access to ArcGIS Pro you can use the processing power of your computer or server that will help with reducing the credits usage as geoprocessing tools can consume quite a few credits, you can always check before you confirm.
In ArcGIS Pro, you can use a number of SQL queries that can report on both searches. Will this search be used on the fly for multiple people or just yourself? you can save the query for reuse later
in ArcGIS Online there is a limited number of geoprocessing tools but they can be quite useful, they are on above the map on the lefthand side.