topic How to query MapServer service by polygon? in ArcGIS Enterprise Questions

How to query MapServer service by polygon?

EricEagle — Fri, 22 Oct 2021 20:49:10 GMT

I'm attempting to pull a json response of Point records that fall within an arbitrarily defined polygon from an ArcGIS REST endpoint (MapServer). The endpoint supports JSON response and querying. Everything is in EPSG 4326, nothing weird.

I'm trying to query it by esriGeometryPolygon.

It is a simple 4-sided polygon built clockwise. Coords are in Y,X format.

My ring looks like this:

{"rings":[[[10,20],[10,40],[30,40],[30,20],[10,20]]]}

I figure the "spatialReference" element defaults to 4326 for json though couldn't find that explicitly stated in documentation. However, adding the spatialReference property makes no difference.

I am wrapping this all in a GET call that looks like this (the server is not internet accessible so I'm making it generic):

https://server/arcgis/rest/services/PARENT/SERVICENAME/MapServer/0/query?geometry={"rings":[[[10,20],[10,40],[30,40],[30,20],[10,20]]]}&geometryType=esriGeometryPolygon&spatialRel=esriSpatialRelIntersects&outFields=FIELDNAME&returnGeometry=false&returnTrueCurves=false&returnIdsOnly=false&returnCountOnly=false&returnZ=false&returnDistinctValues=false&returnExtentsOnly=false&f=pjson

When I go to this area on the service, there are definitely features within the polygon. However, they will not return via this query. So I figure I'm doing something wrong in structuring my request. Even on the REST querying documentation there are no examples showing how to clearly return record properties from a MapServer service based on a Polygon object.

Re: How to query MapServer service by polygon?

jcarlson — Fri, 22 Oct 2021 20:55:56 GMT

Do you have a corresponding feature service? I don't know that spatial queries work on Map Image services. Or at least, I've not been able to do so.

Re: How to query MapServer service by polygon?

DavidPike — Fri, 22 Oct 2021 21:13:51 GMT

I'd recommend going to the query? endpoint of the service when dealing with these. Then looking at the query being set when you press the query button, either in dev tools or the url formed.

geometry={"rings":[[[10,20],[10,40],[30,40],[30,20],[10,20]]],"spatialReference":{"wkid":4326,"latestWkid":4326}}}

Re: How to query MapServer service by polygon?

EricEagle — Fri, 22 Oct 2021 21:29:15 GMT

So, I had taken coordinate pairs I was using with the esriGeometryEnvelope object (YX) and followed the same YX order with the esriGeometryPolygon.

When flipping the pairs to XY, it worked.

Not sure why that should be the case, but if different pair order for different geometry objects in the same API is a thing, I feel like someone on the QA side of the house might've missed something...

So, @jcarlson - yes it does definitely work

And thank you @DavidPike yes that is where I started on this before moving to python

Re: How to query MapServer service by polygon?

jcarlson — Fri, 22 Oct 2021 21:30:53 GMT

Ah, good! I know that spatial filters don't work in Dashboards for whatever reason. I hardly ever use them, but good to know that spatial query parameters will still work.

Re: How to query MapServer service by polygon?

TanuHoque — Mon, 25 Oct 2021 17:01:04 GMT

Just as FYI: both map service (aka map image layer) and feature service query operations follow the same specs. That is why you can add a feature layer in your web map off a map service or a feature service. When you add a feature layer off a map service, Editing is the only capability you won't have.

here is an example of a map service query request with polygon spatial filter:

https://sampleserver6.arcgisonline.com/arcgis/rest/services/SampleWorldCities/MapServer/0/query?geometry=%7B++%22rings%22+%3A+%5B%5B%5B-50%2C10%5D%2C%5B-50%2C50%5D%2C%5B10%2C50%5D%2C%5B10%2C-50%5D%2C++++++++++++++%5B-50%2C10%5D%5D%5D%2C++%22spatialReference%22+%3A+%7B%22wkid%22+%3A+4326%7D%7D&geometryType=esriGeometryPolygon&spatialRel=esriSpatialRelIntersects&returnGeometry=true&f=html