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 have 3 columns within a polygon layer I'm working with.

Column 1 = Landowner, 3 different values Column 2 = Parcel, N different values Column 3 = Management type, 5 different values

I would like to dissolve column 3 based on unique values in column 2, and again within column 1.
Example
C1 = A, B, C
C2 = 1, 2, 3, 4, 5
C3 = Z, Y, X

A 1 Z
A 1 Z
A 1 Y
A 2 X
A 2 Z
A 2 Z
B 1 Z
B 1 Y

Results
A 1 Z
A 1 Y
A 2 X
A 2 Z
B 1 Z
B 1 Y

Is there a tool in any version of ArcMap that I can set this up in or will I have to create something within the model builder or python?

Thanks

share|improve this question

2 Answers 2

up vote 2 down vote accepted

You can use the dissolve command (found in the toolbox).
Dissolve on C1, C2 and C3. decide if you want to save any statics and what type.
Then decide how you want the geometry to be handled.
Probably uncheck the multipart.

enter image description here

if it works from there you can easily create a modelbuilder for it.

share|improve this answer
    
Wow, I don't know how I missed this. Thank you very much –  mkmitchell Sep 27 '12 at 21:14

In ArcMap you could make a new field and then calculate it to

[Field1] + " " + [Field2] + " " + [Field3]

Then dissolve on the new field.

If one of the fields is numeric, convert it to a string

str([Field1])

share|improve this answer
    
That would work too. Thank you. –  mkmitchell Sep 27 '12 at 21:14

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.