topic Re: Need to do spatial query when using Export Map operation in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/need-to-do-spatial-query-when-using-export-map/m-p/43804#M190 <HTML><HEAD></HEAD><BODY><SPAN>OK, I found that "layerDefs" on export map operation do accept spatial sql function to perform spatial query, such like:</SPAN><BR /><SPAN>layerDefs = "0:sde.st_within (shape, sde.st_geometry ('polygon ((13033822 4374104, 13124324 4374104, 13124324 4438923, 13033822 4438923,13033822 4374104))', 3857)) = 't'"</SPAN><BR /><BR /><SPAN>The same to Query Definition tab on layer properties dialog in ArcMap.</SPAN></BODY></HTML> Thu, 25 Apr 2013 04:20:49 GMT wangzhifang 2013-04-25T04:20:49Z Need to do spatial query when using Export Map operation https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/need-to-do-spatial-query-when-using-export-map/m-p/43803#M189 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone,</SPAN><BR /><SPAN>I have a need to do spatial query and attributed query when using export map operation on a map service resource. However, there is only "layerDefs" parameter on export operation.</SPAN><BR /><SPAN>While my map service only contains a point layer, so now I have a workround that do a spatial query(including where clause) on the point layer resource using query operation and fetch only lots of objectIDs, then push these result IDs to layerDefs of export, such as </SPAN><BR /><SPAN>"layerDefs=0:objectids in (1,2,3...9999,10000,....15000,....)".</SPAN><BR /><SPAN>This works but, as you see, the spatial query result may have more than 10 thousands IDs, and do such query only in database would be time consumed...</SPAN><BR /><SPAN>So I wonder is there any other ways to do my job? Or why not export map operation add a "geometry" parameter as query operation do?</SPAN><BR /><BR /><SPAN>Many thanks!</SPAN></BODY></HTML> Thu, 25 Apr 2013 01:57:43 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/need-to-do-spatial-query-when-using-export-map/m-p/43803#M189 wangzhifang 2013-04-25T01:57:43Z Re: Need to do spatial query when using Export Map operation https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/need-to-do-spatial-query-when-using-export-map/m-p/43804#M190 <HTML><HEAD></HEAD><BODY><SPAN>OK, I found that "layerDefs" on export map operation do accept spatial sql function to perform spatial query, such like:</SPAN><BR /><SPAN>layerDefs = "0:sde.st_within (shape, sde.st_geometry ('polygon ((13033822 4374104, 13124324 4374104, 13124324 4438923, 13033822 4438923,13033822 4374104))', 3857)) = 't'"</SPAN><BR /><BR /><SPAN>The same to Query Definition tab on layer properties dialog in ArcMap.</SPAN></BODY></HTML> Thu, 25 Apr 2013 04:20:49 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/need-to-do-spatial-query-when-using-export-map/m-p/43804#M190 wangzhifang 2013-04-25T04:20:49Z