Solved

Join and sum points onto polygon grid cells based on attributes in points layer

  • 12 December 2022
  • 3 replies
  • 17 views
albjoh
Rank
Badge +4

I have adress points representing persons and attributes for each point including a categorization into age intervals. I also have a polygon grid to which I want to sum up all persons in each age interval to each grid cell. My output should be the grid polygons with a sum for each age interval, like this:

"grid ID" "age 0_5" "age_6-17"

1 12 56

2 23 109

3 4 13

I've tried several solutions eg. with "point on area overlayer" combined with the "list summer" but havn't been able to make it work. I use the 'generate list on an ouput area' option but my resulting "sum_" from list summer returns only "0" for all rows. Do I miss something with the lists buidling? Or any other ideas how this can be done?

 

Thanks

 

icon

Best answer by albjoh 13 December 2022, 16:22

View original

3 replies

M
Badge +2

@albjoh​ I would try PointOnAreaOverlayer to associate the grid cell to the address only, then use Aggregator - group by the cell id and aggregator has sum options. Or you could also use StatisticsCalculator and also Group By the grid ID.

albjoh
Rank
Badge +4

@albjoh​ I would try PointOnAreaOverlayer to associate the grid cell to the address only, then use Aggregator - group by the cell id and aggregator has sum options. Or you could also use StatisticsCalculator and also Group By the grid ID.

Thanks @markatsafe (Safer)​ Tried this and it results in a nice total sum of points per grid cell.

 

However it will not take care of the grouping of sums for the age intervals. I have tried setting a Testfilter after the PointOnAreaOverlayer and then Aggregators for each filtered stream (4 age intervals in total) which gives me the sums for each interval. However then I want them all back in one final output dataset showing for each gridcell, the sum of people in each age intervall.

 

Tried merging/joining them all together which only partially works since the fields ("age_0_5", ""age_6_17" etc) do get merged but only contents from one field at the time... At most times there are multiple points in one grid cell and those belong to different age intervals. Any Ideas ?

albjoh
Rank
Badge +4

Solved it. Before the pointOnAreaoverlayer I used an attributecreator for setting up the attribute fieldnames (the age intervalls). Then finished off with aggregator grouped on both Id and an attribute for age intervall. Attributes to sum was set to the overlaps col from pointOnAreaoverlayer.

Reply


Community Stats

28,670
Posts
109,364
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.