Using H3HexagonIndexer, or alternative, to build hexagons grid and then assigning values from points into the hexagons

If you’ve managed to create the hexagons, the rest should be fairly straightforward.

PointOnAreaOverlayer, choose to Generate List on Output ‘Area’ and select the attribute you want to average and set an attribute to hold the overlap count, then ListSummer to sum every value in the list and then divide by the overlap count

Thanks for that, ​@ebygomm.  No, I’ve not created the hexagons. I read somewhere that H3HexagonIndexer creates the hexagons and also does the aggragating and PointOnAreaOverlayer work (or equivalent). Is that right? Or am I misunderstanding  H3HexagonIndexer? Do I need to create the hexagon grid elsewhere first?

I’m assuming you’d want a hexagon grid in BNG so the H3HexagonIndexer isn’t going to be of use here (it’s not something i’m familiar with).

There’s a custom transformer HexagonSampler that might help you create your hexagon grid.

Yes, it would need to be BNG (EPSG: 27700). OK, I’ll look at HexagonSampler.

By the point data was in long/lat (easily done), then would H3HexagonIndexer be a way to go?

​@ebygomm I’m getting somewhere with H3HexagonIndexer, but by first converting the points to epsg: 4326. Then by using the ‘replace with hexagon’ option in the settings I can create the hexagon grid to the selected size. The hexagons inherit the values for the point or points falling within them. That can then be reprojected back to epsg:27700 as required. It’s all very impressive.

The challenge I have now is to do the aggregation of multiple points within a hexagon to create an average score and assign that to the hexagon. I know you made some suggestions on that earlier. I’ll take a look after Easter. Thanks.