Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

Thanks, Seth

share|improve this question

2 Answers 2

up vote 3 down vote accepted

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

share|improve this answer
    
Thanks Swingley! –  Seth P. Nov 18 '10 at 23:29

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.

share|improve this answer
    
I think the default was bumped up to 1000 rows at 10. –  Derek Swingley Nov 19 '10 at 15:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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