2

I have a table that looks like:

Name
X
X
X
Y
Y
Z
Z

I have a polygon feature class with the attributes:

Place
X
Y
Z

Essentially, I want to join that table to the polygon, but I want each row in the table to be kept.
When I attempt a join, it only joins to one x, y, z and not all.

I am using ArcMap.

5
  • Is the data the same in all the X's, Y's, Z's? Can the field names be changed in your table?
    – Erica
    Commented Feb 11, 2015 at 18:40
  • No, data in each row is different. Each row has data by a different person but in the same area (X) polygon. I want to provide each of those rows that area as they are different records.
    – MapGeo
    Commented Feb 11, 2015 at 18:47
  • I don't know of a way to join multiple fields to a single field. I think you could do it by breaking the table into three different tables (one for Person 1, Person 2, etc.) instead of keeping the fields (X1, X2, etc.).
    – Erica
    Commented Feb 11, 2015 at 18:52
  • 1
    would a "relate" help you ? It depends what you want to do after. Otherwise, you need to duplicate your polygons (=> you will have geometric overlaps)
    – radouxju
    Commented Feb 11, 2015 at 19:13
  • @radouxju I tried a relate but I would prefer a join in this scenario. Though I'm afraid multiple polygons looks like it might be the answer.
    – MapGeo
    Commented Feb 11, 2015 at 20:23

1 Answer 1

1

@radouxju is correct - it's either a relate or duplicate geometry, and those are your choices. You can duplicate the geometry most easily with the Make Query Table tool. If your version of Arc is recent enough (10.1 or higher I think?) and you're working in a geodatabase, you can do a Join followed by an export of the result and that should give you everything with a polygon for each row in your table. Note that the multiples don't show up until you export, as you've seen just looking at the join result only shows first returned match.

See ArcMap many-to-many join

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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