Problem with query to an XY event source data layer

[PaulHuppé]

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

[RaviNarayanan]

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.

[PaulHuppé]

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?

[RaviNarayanan]

SP2 schedule is around April 2011.

[PaulHuppé]

Ok, thanks for the update.
Paul