3

I use ArcGIS 10.1 for Desktop.

I have a polygon Feature Class with municipalities.

In a non-geographic table, I have these same municipalities, with an additional contract information.

The contract name is stored as a String in a field. Each municipality can have either zero, one or more contracts. In the table it appears as often as it has the information, i.e. a municipality with three contracts appears three times in my table.

At the end, I need a dissolved polygon for each contract where every munipality of the specific contract is within. These polygons must be overlapping when a municipality has more than one contract.

Does anyone have any idea how to to this, preferably in ModelBuilder, that another user could reuse it, only pointing where he has the existing table and feature class?

3

In ArcMap, here's an example of municipalities:

enter image description here

And a table:

enter image description here

Initiate a join on the municipalities polygon feature class by right-clicking on it in the table of contents:

enter image description here

Join by municipality fields and keep all records:

enter image description here

Export the polygon feature class to a new feature class:

enter image description here

The new feature class will have a polygon per contact:

enter image description here

  • Hi, Thanks for your answer, but I cannot get it working. With this join it keeps only the first contact per municipality even if I have selected "keep all records". So if I have 1300 municipalities before, it stays at 1300 polygons and some got a contact, and some did not because they do not have one. I have a 1 : n relation, and ArcMap only gets me a 1:1 join without dublicating the polygons for the number of needed contacts. – Jupter1 Oct 29 '15 at 14:10
  • Did you export after joining? – Emil Brundage Oct 29 '15 at 14:11
  • At first I did, it did not work. But now it is OK! Thank you very much for your help! – Jupter1 Oct 29 '15 at 14:52
  • I'm glad to help. – Emil Brundage Oct 29 '15 at 14:53
  • How can I get the same result using ModelBuilder? As join does not function within a geodatabase... – Jupter1 Feb 9 '16 at 13:45

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.