How do I add the average value of two layers into a hexagon layer?

73
3
05-30-2019 05:08 AM
Labels (1)
Highlighted
New Contributor

Hi all, 

I'm trying to map two ecosystem services for my thesis. In short: Local Climate Regulation is an ecosystem service society benefits from. There is a supply and demand for this service that i'm trying to map. Different land cover classes have been assigned values (0 low demand/supply - 5 very high demand/supply) to map them. Both Demand and Supply maps have been attached to this question for a better picture. For example one land cover class, lets say Urban Areas, can have a demand value of 5 and supply value 0. Urban green areas have a demand value of 2 and supply of 2. When subtracting the demand values from the supply, you get the overall budget map (attachment 3). 

What I am trying to do now is to add a top hexagon layer, with the average value of the two layers in one hexagon (attachment 4). As you can see in the 4th attachment (capture.JPG), one hexagon can have multiple polygons in them, all with different values. How can I average the values in the multiple polygons inside the Hexagon and add that to that hexagon? I have the equation to average the different polygons. Hope someone can help me out.

Best, 


Riad 

Reply
0 Kudos
3 Replies
Highlighted
MVP Esteemed Contributor

Your data are categorical ie…. 0 low demand/supply - 5 very high demand/supply

The average/mean is not appropriate for categorical data. You want the mode, ie dominant value.

If you want to find associations between the two and you want to work in vector world, I would recommend

Tabulate intersection

in raster world

Tabulate area and the raster Combine tool

Reply
0 Kudos
Highlighted
New Contributor

Dan, 

Thank you very much! Tabulate intersection was what I was searching for. Through a detour via excel I calculated everything i needed! Again, thanks for your help!

Riad

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

Glad it worked out

Reply
0 Kudos