Aggregate Points

The Aggregate Points tool performs statistical analysis of points, e.g. count, sum, min, or max, and aggregates the information on polygons.

1. Explanation

The Aggregate Points tool can be used to analyze the characteristics of points within a given area. It aggregates the information of the points and therewith allows calculation of the point count, the sum of point attributes, or derive e.g. the maximum value of a certain point attribute within a polygon. As a polygon layer, either a feature layer (e.g. city districts) or a hexagonal grid can be used.

2. Example use cases

• Aggregating the population numbers on a hexagon grid.
• Deriving the sum of traffic accidents within a city district.
• Visualizing the average number of carsharing vehicles available per station on a district level.

3. How to use the tool?

1

Click on Toolbox .

2

Under the Geoanalysis menu, click on Aggregate Points.

Layer to aggregate

3

Select your Source Layer, which contains the data you like to aggregate.

4

Select on which Area Type you like to aggregate the source layer. You can choose between Polygon or H3 grid.

Polygon

Polygon

5

Select the Area Layer which contains the polygons on which you like to aggregate your point data.

H3 Grid

H3 Grid

5

Select the H3 Grid Resolution. You can choose resolutions between 3 (average edge length of 69km) and 10 (average edge length of 70m).

NOTE

To learn more about the H3 grid, you can visit the Glossary.

Statistics

6

Select the Statistic Method, and the field you like to use for the Field Statistics (the field in the source layer that is used to group the aggregated points for statistics).

Available Statistics Methods are listed in the following. The available methods depend on the data type of the chosen attribute:

Method	Type	Description
Count	string,number	Counts the number of non-null values in the selected column
Sum	number	Calculates the sum of all the numbers in the selected column
Mean	number	Calculates the average (mean) value of all numeric values in the selected column
Median	number	Yields the middle value in the selected column's sorted list of numeric values
Min	number	Yields the minimum value of the selected column
Max	number	Yields the maximum value of the selected column

7

Click on Run.

Hint

Depending on the size of the datasets, the calculation might take some minutes. The status bar shows the current progress.

Results

8

As soon as the calculation process is finished, the resulting layer "Aggregation Point" will be added to the map. This layer consists of the information of the source layer and an additional column showing the results from the statistical operation. You can see the table by clicking on the polygon on the map.

Tip

Want to style your result layer and create nice-looking maps? See Styling.