Stand alone table with geometry

Discussion created by lhmathys on Jan 25, 2011
Latest reply on Feb 1, 2011 by rnarayanan-esristaff
I'm hoping someone can help...

Currently, I have successfully setup and published a stand alone table with custom parcel data on my REST endpoint.  So, our ArcGIS 10 REST endpoint currently has one published map layer with parcel data including shapes & property ids, and a second published stand alone table (I mentioned above) that contains custom property information for multiple years.  I'd like to be able to query the stand alone table and include the shape data from the parcel data layer.

I can query the data in the stand alone table using property IDs for a given year and get back results.  However, I'd like to be able to set the geometry of a query to the REST endpoint of my custom table like I can on a map layer.  I've tried joining the map parcel layer with the custom table in ArcMap 10; creating a view on the database that joins the parcel/shape layer with our custom data table; but any queries I've tried on the REST endpoint of the stand alone table always return with an error.

Is there a way to include the shape/envelope information with a stand alone table so I can just query one layer with the current geometry?