topic Re: Problem with query to an XY event source data layer in ArcGIS REST APIs and Services Questions

Problem with query to an XY event source data layer

PaulHuppé — Thu, 16 Dec 2010 13:57:28 GMT

Hi,

I am trying to query a layer in a service which was created from an XY Events Data source. The data is in geographic, but for the Coordinate System of the Data Frame, I selected Canada Lambert Conformal Conic as the projection (WKID=102002).

I tried to do a query and to specify an output spatial reference of WKID=102002, but I get lat/longs back. The url was:

http://myservernamehere.mydomain/ArcGIS/rest/services/TestGeology/MapServer/0/query?text=&geometry=%7B%22xmin%22%3A359116.578934065%2C%22ymin%22%3A3862731.70544748%2C%22xmax%22%3A401068.487002091%2C%22ymax%22%3A3890699.6441595%2C%22spatialReference%22%3A%7B%22wkid%22%3A102002%7D%7D&geometryType=esriGeometryEnvelope&inSR=102002&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=&where=&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=102002&outFields=PHOTO_NUM%2CPHOTO_LAT%2CPHOTO_LONG&f=html

And the result is shown in the attachment.

Is there a problem with the REST API for XY event Layers?:confused:

Thanks,
Paul

Re: Problem with query to an XY event source data layer

RaviNarayanan — Thu, 16 Dec 2010 17:26:36 GMT

This sounds related to this bug in MapServer (NIM051154)
http://resources.arcgis.com/content/nimbus-bug?bugID=TklNMDUxMTU0

Does the query return correct results if a spatial filter is not used and if a WHERE clause is used? If so, then it is related to the above issue which will be addressed in 10.0 SP2.

Re: Problem with query to an XY event source data layer

PaulHuppé — Thu, 16 Dec 2010 17:34:04 GMT

I tried a query without a spatial filter and with a WHERE clause as you suggested and it does return the correct results (see attachment). So, looks like it is related to that bug. Do you know when SP2 is scheduled to be released?

Re: Problem with query to an XY event source data layer

RaviNarayanan — Fri, 17 Dec 2010 19:41:36 GMT

SP2 schedule is around April 2011.

Re: Problem with query to an XY event source data layer

PaulHuppé — Mon, 20 Dec 2010 10:31:26 GMT

Ok, thanks for the update.
Paul