I'm working in ArcGIS Pro v2.4 with all extensions. I have a bunch of tables that are the result of running the Tabulate Area tool on a series of raster map tiles to calculate land cover by county in the United States. The issue I am running into is that some counties are covered by two or more different map tiles, so some tables have the partial results for the part of the county that was covered by the map tile.

I thought I'd be able to just run the Merge tool and use field mapping to apply the Sum merge rule on the value fields that need to be added together, like this: enter image description here

Instead, I'm getting duplicate records in the table, like this: enter image description here

Any idea what I might be doing wrong, or if there's a different tool/process I should be using instead?

  • I'm guessing your FIPS field is remaining Unique during the merge process? Try merging as normal then run your data through the summary statistics tool grouping by FIPS and summing your fields? Not sure if that is the logic you are looking for?
    – Hornbydd
    Dec 14, 2021 at 13:09
  • @Hornbydd that did the trick - thanks! Dec 15, 2021 at 1:27


Your Answer

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

Browse other questions tagged or ask your own question.