topic Re: Query with KMZ format output returns bad results in ArcGIS REST APIs and Services Questions

Query with KMZ format output returns bad results

OlegKachirski — Wed, 09 May 2012 13:29:12 GMT

AGS Server 10 SP2, using REST endpoint to query based on attribute value, such as:

http://server/ArcGIS/rest/services/MyService/MapServer/1/query?text=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=&where=STRUCTURENAME+LIKE+%27%25garage%25%27&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=4326&outFields=STRUCTURENAME&f=html

Works great, returns 557 records. If I change the last parameter (format) to f=kmz, the KML returned contains all of the records in that layer (> 2000) - so WHERE clause doesn't seem to matter. A known bug?

Re: Query with KMZ format output returns bad results

RaviNarayanan — Thu, 10 May 2012 14:58:04 GMT

It doesn't seem like a generic bug. For example, give this request a try.

http://servicesbeta.esri.com/ArcGIS/rest/services/Hurricanes/Hurricanes/MapServer/0/query?text=&geometry=&geometryType=esriGeometryPoint&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=&where=EVENTID+LIKE+%27Mic%25%27&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=4326&outFields=EVENTID&f=kmz

Is there any join table in the layer that is queried?

Re: Query with KMZ format output returns bad results

ThomasBarthes — Mon, 05 Aug 2013 15:39:26 GMT

Hello,

Old thread but I'm currently facing the same problem...

I've three layers in a MapService (bus stops, commercial paths and non commercial paths) and each layer is mapped with a table in an SQLServer GeoDatabase. Each field in thoses tables contains an "site id", so that we know to which City it belongs.

There are two relationship classes in my Geodatabase :
- One linking bus stops and commercial paths
- One linking bus stops and non commercial paths

The Map Service is published with the "KML" capability.

Everytime I launch a query request using REST interface on a layer (let's say for example the bus stops layer), using a Where clause to filter on a particular site_id :
- if the out format is "HTML" or "JSON", then the result contains only the bus stops of the desired site
- if the out format is "KMZ", then the results contains the bus stops of the whole database...

Looks like the where clause is not considered when the output format is set to KMZ.

Any idea on this ?

Regards,
Thomas

Re: Query with KMZ format output returns bad results

StevenMoore1 — Mon, 12 Aug 2013 23:56:01 GMT

Hi,

It looks like you are running into the following bug:

NIM075556 - REST queries do not honor the �??Where�?� clause for KMZ response if the map service is created from an MXD

The workaround is to publish your services from an MSD rather than an MXD.

Hope this helps.

Re: Query with KMZ format output returns bad results

KevinGooss — Thu, 02 Oct 2014 21:46:15 GMT

I am now seeing a similar issue. 10.04.

Anyone find a solution?