I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am having issues with the Spatial Join and Union tools where instead of joining the fields, it creates new fields with the same names. The following image shows what I am describing.

Fields not joining

How can I either have the layers merge and their attributes combine into one field. OR could I create a new field and populate it using the field calculator? I've tried my luck at writing an expression but my SQL and Python are very weak.


So I figured it out... kinda. Seems like a work-around but nonetheless I got the result I was looking for.

I performed a Union between the county layers and then created a new field in the resulting layer's attribute table. I used the field calculator and added the 3 NAMELSAD fields together. The Union operation generated some polygon slivers where the county layers overlapped, so I had to go through and individually delete those in an edit session. Then I performed a spatial join between my new County layer and a State layer to get the State field associated with the Counties so they can be queried on that basis.


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.