4

I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field.

My question is, if I publish this data to ArcGIS Server, will an identify operation on that layer return all of the related values in the non-spatial table?

I want to try this, but I don't have sample data that meets these requirements (if anyone knows where I can find some, it would be very helpful).

Here is an example from ESRI of an Identify operation in ArcMap on two tables with a one-to-many relationship. I need to know if the results in ArcGIS Server would be consistant.

I am using ArcGIS 10 and SQL Server 2008 R2.

3

Regarding your question about identify: no, an identify wouldn't bring back the related records.

But you're in luck since you're using 10. You can now query via relationship classes through REST. You could use a RelationshipQuery to find your related records. Here's a JS API sample showing how this works: Query related records

1

I'm not sure, but for a lot of methods there is a 500 row default limit, so if you have a feature related to more than 500 rows you might want to test for that.

Here's the Query Related records REST request.

  • I think the default was bumped up to 1000 rows at 10. – Derek Swingley Nov 19 '10 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.