0

I am using ArcMap 10.5 to display the distribution of Revenues by Region, for each product I have defined.

Each product has a layer of its own consisting of a collection of polygons, and each polygon contains attribute fields for revenues over a period of 10 years (e.g. Revenues2005, Revenues2006, etc)

I am trying to create a kind of cumulative heatmap.

For example, let's take two polygons with the following fields, each in a separate layer, but that overlap exactly:

Layer1

Rev1 | Rev2 | Rev3

5000 | 6000 | 7000

And

Layer2

Rev1 | Rev2 | Rev3

1000 | 2000 | 2500

Would it be possible to combine the above layers, such that when the polygons overlap, I would obtain a new layer with a polygon of the following attributes:

Layer3

Rev1 | Rev2 | Rev3

6000 | 8000 | 9500

So far the (tedious) solution I found is to combine the fields pairwise and use a python script to add the revenues for each year one by one.

  • If you're only interested in symbology, then you could use transparency, so overlapping polygons would appear darker, representing larger numbers. – Paul Feb 15 '17 at 1:30
  • Hi Paul, I would actually like to add the fields from the layers and obtain new values per polygon. Are you aware of a good way to do this? I already tried using unions on tables on which I joined my xlsx tables, however the fields get renamed to Rev1_1, Rev2_1, etc instead of being given a way of combining them – johnmarkovich Feb 15 '17 at 5:39
  • gis.stackexchange.com/questions/133866/… has a few solutions. – Paul Feb 15 '17 at 16:17
0

Turned out the issue was due to using the Join functionality available through the context menu.

For the above to work the fields in the different layers need to be of the same nomenclature, and joined using the "Field Join" method, which is a permanent join. The excel file itself should be exported to DBF before the join procedure to avoid errors.

Once this is the case, merge the layers to be aggregated together, then create a separate layer which will hold the aggregate values.

Use the spatial join tool, while setting the appropriate merge rules (sum, average, etc), on the newly created layer and the layer resulting from the merge.

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.