Can a map layer in Pro be based on a spatial query?

Question

Definition Queries on map layers in Pro don't appear to allow spatial queries. So I thought I'd try using a Query Layer instead. These require the query be written in SQL. But I'm not finding any example of spatial queries in SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation So I'm thinking maybe Query Layers don't support spatial queries either.

Is that the case? And if so, anyone know the best way to create a map layer that conforms to a spatial query? It's a simple query - points in the layer need to be inside a polygon in another layer.

DougGreen · Answer

I think I see what the seeking to do and there was a way in ArcMap to add a subquery inside the definition query if both feature classes lived in an enterprise geodatabase. I attempted this in Pro and it does validate the query but on saving it, it never applies. Then, when you open up the definition query editor, it shows no active definition queries. So I agree with your desire and others that it would be nice to have a way to limit the features by a spatial definition query.

LukasFalk · Answer

I don't believe the Clip Layer functionality deals with the records but more so with what is displayed.  If you want to only show records within those polygons and exclude all others from the attribute table wouldn't a select by location and then exporting the selected records be the best option?  Is there something that is preventing you from wanting to do this?  Creating a new layer which only contains what you want would be like a more permanent version of what a definition query would do.

Let me know what you think!

Lukas

AngelaDeegan · Answer

I'll see if I can accomplish this in Portal using Analysis > Overlay Layers.