https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368463#M77203 <P>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?</P><P>This layer will then be published as a web service to be added to an experience builder.&nbsp;</P> Wed, 10 Jan 2024 17:30:10 GMT LaurenCammack01 2024-01-10T17:30:10Z https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368463#M77203 <P>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?</P><P>This layer will then be published as a web service to be added to an experience builder.&nbsp;</P> Wed, 10 Jan 2024 17:30:10 GMT https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368463#M77203 LaurenCammack01 2024-01-10T17:30:10Z https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368479#M77209 <P>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 <A href="https://community.esri.com/t5/arcgis-pro-ideas/spatial-definition-query/idi-p/922663" target="_self">idea from 2010</A>, it looks like there is not spatial query, at least that's built into ESRI software natively.</P> Wed, 10 Jan 2024 17:47:41 GMT https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368479#M77209 ZachBodenner 2024-01-10T17:47:41Z https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368609#M77234 <OL><LI>What kind of enterprise geodatabase? Oracle, SQL Server, PostgreSQL?</LI><LI>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.</LI><LI>Can you give us an idea of your level of expertise with advanced SQL queries, spatial indexes, etc? Spatial SQL queries can be tricky.<OL class="lia-list-style-type-lower-alpha"><LI>Do you use a SQL client like Toad or SQL Developer?</LI></OL></LI><LI>Have you considered pre-computing using a scheduled geoprocessing tool, attribute rules, etc?</LI><LI>How many features are there in the trees and parcel feature classes?</LI><LI>What version of ArcGIS Pro and Enterprise?</LI><LI>What spatial type is used? ESRI’s ST_Geometry? PostgreSQL’s native spatial type?</LI></OL><P>Related:</P><UL><LI><A href="https://community.esri.com/t5/arcgis-enterprise-questions/options-for-computing-fields/m-p/1178731" target="_self">Options for computing fields</A></LI><LI><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/select-layer-by-location.htm" target="_self" rel="nofollow noopener noreferrer">Select Layer By Location (Data Management)</A><SPAN>:&nbsp;<EM>Relationship Parameter — Intersect (DBMS)</EM></SPAN></LI></UL> Thu, 11 Jan 2024 03:56:47 GMT https://community.esri.com/t5/arcgis-pro-questions/publish-web-service-based-on-spatial-query/m-p/1368609#M77234 Bud 2024-01-11T03:56:47Z