Publish web service based on spatial query

Question

Our city has a tree inventory that includes trees in our community orchards. I would like to filter the entire tree inventory layer based on trees within parcel boundaries (orchard areas). Some trees are retired/added throughout the year so I would like it to automatically update the orchard trees in those boundaries. Is there a way to essentially do a def query but spatially?

This layer will then be published as a web service to be added to an experience builder.

BB1234 · Answer

* What kind of enterprise geodatabase? Oracle, SQL Server, PostgreSQL?
* Are you sure you want to do a spatial definition query (re-run the query every time a user views it in the map)? It can be done with spatial functions, but they're slow.
* Can you give us an idea of your level of expertise with advanced SQL queries, spatial indexes, etc? Spatial SQL queries can be tricky.* Do you use a SQL client like Toad or SQL Developer?

* Have you considered pre-computing using a scheduled geoprocessing tool, attribute rules, etc?
* How many features are there in the trees and parcel feature classes?
* What version of ArcGIS Pro and Enterprise?
* What spatial type is used? ESRI’s ST_Geometry? PostgreSQL’s native spatial type?

ZachBodenner · Answer

Do you have control over the schema of the tree inventory? I think the easiest solution would be to use an attribute as the definition query, either a dedicated attribute or else something else that can work as a stand-in for whether they're in an orchard or not. Looking all the way back to this idea from 2010, it looks like there is not spatial query, at least that's built into ESRI software natively.