Questions tagged [aggregate]
The aggregate tag has no usage guidance.
81
questions
1
vote
1
answer
51
views
Aggregate field in QGIS
I have question about aggregate values from attribute table.
I have something like this:
and I'd like want to get something like this:
I use aggregate tool but without good results.
1
vote
1
answer
38
views
QGIS 3. Point Cluster rendering but with categorization?
Is there a way to obtain the same spatial rendering as what QGIS 3 allows with Point Cluster symbology (spatially close points clustered in a unique symbol) but using an attribute based categorization?...
1
vote
1
answer
67
views
Aggregate a simple features collection in R by a factor variable
I'm trying to aggregate a simple features collection using a group variable that is a factor. Below is a simple example.
library(sf)
#> Warning: package 'sf' was built under R version 4.2.3
#> ...
0
votes
0
answers
16
views
Generating new polygons based on sum of values
I am working with QGIS, and I have created the styled density map with the hexagons to calculate pop figures within these. The pop field is displayed inside each polygon.
I now want to create new ...
1
vote
1
answer
51
views
QGIS atlas print composer : aggregate (bigger overlap)
With QGIS 3.30, In the composer interface, I generate an atlas. My iteration layer is polygonal layer (platforms). I added a text element to automatically get by spatial intersection the 'parcel_id' ...
1
vote
0
answers
40
views
QGIS aggregate intersects points in polygon by filtering values
I have in QGIS 3.28 points and polygon layer.
I want to create virtual field that SUM on the point layer all the specific values the points intersecting in the polygon that are filtered according to ...
4
votes
1
answer
74
views
Aggregate expression seems to be calculating the first value only
I have 2 vector layers: a point layer (named Messedatei, with 5 columns named field_1-5) and a line layer (each feature is build with only 2 vertex points).
I want to calculate the 'z value' of a ...
1
vote
1
answer
37
views
Field Expression to Count Ducts that are Intersecting the Midpoint of a Routeline in QGIS
I am trying to make my field in a Routeline to automatically count all the ducts that passed throught it. I was able to come up with this code.
aggregate(layer:='Duct',
aggregate:='count',
...
0
votes
0
answers
5
views
Can't aggregate data by date to calculate point path length
I have a table with the coordinates of the movement of the car, its id and the time the coordinate point was received. When I try to calculate the mileage of a car by grouping points by day, an error ...
1
vote
0
answers
57
views
Sorting based on aggregate in QGIS Atlas layout
In an Atlas layout, I can in a text field or table with no problem sum the attribute SBT for features being inside the current atlas feature by using this aggregate function:
aggregate(
layer:='...
3
votes
1
answer
52
views
Select text field associated with maximum numeric field during QGIS aggregate process
I have a site layer and a grid layer and want to add attributes to the site layer which include a new area (the intersection) and the grid reference (a text field) associated with the maximum ...
2
votes
2
answers
96
views
QGIS - Aggregate geometries without including the current feature
I'm using this expression:
aggregate(
layer:= 'Dissolved',
aggregate:='concatenate',
expression:= to_string(predicted),
concatenator:=',',
filter:=intersects($geometry, geometry(@parent)))
...
2
votes
1
answer
110
views
Counting polygons with multiple filters in QGIS
I am using the aggregate expression in QGIS to count how often my polygon name appears in another point layer. The 'Polygon_zone_name' exists on both my polygon layer and my points layer, I can ...
2
votes
1
answer
42
views
Retreiving info from another layer
I have two shapefiles:
street (polyline) listing of all streets in one village
with fields 'streetId', 'Streetlength' (virtual field)
streetpanel listing of all panels displaying street name
with ...
1
vote
1
answer
96
views
In "Aggregate" tool, concatenate function and \n delimiter doesn't result in break line
I am encountering problems with the 'Aggregate' tool and the 'concatenate' function with the '\n' delimiter. The process is not resulting in a line break as expected.
Please see the screenshot of the ...
5
votes
2
answers
153
views
QGIS aggregate - filter by newest date
i have two one-to-may related layers (relation name: tree_observation) parent: trees and child: obeservations. The trees should be revisited on a regular base and for each observation a new child ...
2
votes
1
answer
89
views
QGIS: Use layout name as variable in field calculator for referring to a specific column?
I want to do some calculations based on a column which has the same name as the layout name (Graugans in this example).
To have less typing work, I thought about using the layout name as variable. But ...
2
votes
1
answer
84
views
Polygon neighbors in a shapefile in QGIS using aggregate not working
I'm using QGIS 3.28
I want to find the neighboring polygons for each polygon in my layer, which is formed of polygons.
Having searched for available solutions, I've come up with this:
https://...
1
vote
0
answers
98
views
QGIS sum attribute values of overlapping line segments
This is sort of follow-up to this thread. Not sure how I got it working a year ago, but now I'm across the same issue again. Here is a clean dataset which I believe is correct. It contains overlapping ...
1
vote
1
answer
439
views
Aggregate raster in R and get count of contributing pixels
I have a raster with some NULL values. I need to aggregate the raster to a coarser one, and get a count of the pixels that are being aggregated (for every output pixel), excluding the NULLs. I'm ...
0
votes
1
answer
285
views
Aggregate raster using gaussian smoothing as a custom function/Units of the sigma
I am trying to aggregate a raster using a custom function and the terra package. For the custom function I am using a Gaussian smoothing. When I try to run the aggregate function I am getting this ...
5
votes
1
answer
135
views
Summing areas of polygon features listed in field using array_foreach function in QGIS
In QGIS, I have a vector layer with a field listing the names of several polygons features.
I want to calculate the sum of the areas of the polygons in this list, using Field Calculator and displaying ...
0
votes
1
answer
417
views
GeoPandas centroids based on field, while keeping aggregated values
I have a shapefile containing 85.000 points representing houses. I want to create a new shapefile containing the centroid of each subset of houses with the same postal code. This centroids file should ...
3
votes
0
answers
260
views
Aggregate attribute value of polygon within geometry of another polygon layer QGIS
I have two layers, both polygons.
One layer includes watersheds as polygons, each watershed is it's own attribute row. The second layer is a segmented stream network, each segment is it's own ...
0
votes
1
answer
184
views
Aggregating points within certain distance and keeping all points info using QGIS
I have a map with many duplicate points and I want to combine those points together into one, based on the name and geographical location (10 meters), is there a way to do this with QGIS, given that I ...
1
vote
0
answers
37
views
Finding polygon neighbors using intersect function with added conditions
Using aggregate() in field calculator, I tried to find neighboring polygons. The polygons have a field type with two values: new and old. I want to find neighbors of the type old. Hence, I tried the ...
2
votes
1
answer
71
views
Different area values in aggregate function
In QGIS 3.22.8 the aggregate function used in text field shows planar area values instead of spherical. It happens in both the Print Layout and the Report.
How can I get the spherical values of the ...
1
vote
1
answer
413
views
QGIS aggregate expression to filter selected features in 2nd layer
I´m working with two layers in QGIS:
First one with point geometries representing water quality sampling places (LAYER A).
The second is a spreadsheet (no geometries) that contains pollution values ...
2
votes
2
answers
119
views
How to aggregate street lines using value filter
I have a shapefile of a service done on a street. This service has a sequence of execution and whether or not I should run on that street (blue and red). At each corner of the street I'm working on, I ...
1
vote
0
answers
31
views
Neighboring zones using a condition (expression)
We have a census tract layer which contains the total number of dwellings 'V_tot'.
We need to group the census zones that intersect each other where their sum is in the range of greater than 150 and ...
1
vote
0
answers
155
views
QGIS: 'Incorrect parameter value for AGGREGATES' when using Aggregate in a Python-Processing-Script
I am currently working on a QGIS-Python-Processing-Script that creates an automated street register for a printed city map as a CSV file.
In that context I want to give the user the option to choose ...
1
vote
1
answer
107
views
Problem using aggregate function to do a 1:m join
I am using QGIS, version 3.24.0. I have a shapefile called "Map_CorrectionDEF", uniquely identify by fields "GID" and "unitcode". It is a grid cell, in which the field &...
0
votes
1
answer
61
views
Connect polygons with gap without dissolve intersected polygons in ArcMap
I want to close gaps between polygons that are not intersecting and without a barrier in between (like streets).
Its possible by "Aggregate Polygons", but this tool is dissovling all ...
1
vote
0
answers
48
views
How to print numbers per categories of a layer in QGIS Atlas generator?
What I want to achieve is based pretty much on this solution but with the sum and a category text per category. So instead of writing
[% aggregate( 'layer','sum',"category_txt", filter:=&...
0
votes
0
answers
190
views
Getting count of points in grid using Google Earth Engine JavaScript API
I am using Google Earth Engine to map attacks between armed groups in Colombia. I added a grid to the map and I want to get a count of attacks per 'dyad_name' per grid square.
Among the many things I ...
4
votes
1
answer
575
views
Accessing aggregate functions on another layer in QGIS
I am using QGIS where I have:
Layer 1 STREETS : lines each of one representing a street (one line one street), with different fields, with a unique id called "Name" (string)
Layer 2 STAKES :...
7
votes
1
answer
119
views
Setting delimiter in the QgsAggregateCalculator
With PyQGIS I want to aggregate some fields in my layer.
When I use:
mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField)
Then I get a concatenated string without a delimiter. So I ...
4
votes
1
answer
503
views
PyQGIS: Aggregate function used with field calculator
I'm using the following code with processing algorithm "Aggregate" to find neighbor polygons of some selected features in a polygon layer:
from qgis.core import QgsProcessing
from qgis.core ...
1
vote
0
answers
122
views
Unable to aggregate line segments while summing values
I've a layer with multilines, overlapping to a various degrees. I need to merge/dissolve them "downwards" while summing their values for the overlapping segments.
I made it to "Union&...
3
votes
0
answers
416
views
Can I resample a raster in R using "max" as function?
With a raster and a reference raster, I'd like to do something like this:
# resample raster to ref_raster to match resolution/origin using max as aggregate
raster = resample(raster, ref_raster, 'max')
...
2
votes
1
answer
100
views
QGIS List of two intersecting layers features inside Atlas
Learning to use aggregates. Need to know how I can list several streets inside my atlas with the condition that layer 1 (not controlling layer, only visualised and used for statistical purposes) and ...
1
vote
0
answers
31
views
nodata leads to high pixel values after aggregation
I am working in QGIS with binary raster images and my task is to decrease the resolution from 0,1 to 5m.
Problem is, I have several areas that were excluded with “no-data” beforehand. After ...
2
votes
1
answer
67
views
Identifying neighbouring polygons but field calculator preview and output are different
I'm really struggling trying to create a field which lists the neighbouring cells of my grid. I have a grid of 814 cells, and for most cells (i.e. the ones which are fully surrounded) there are eight ...
0
votes
0
answers
48
views
Preserve NA areas in resampled raster
I got a raster image with 2m pixel size, there are some areas with value 1 (black) and roads with value NA (white):
It is made from a rasterized shape:
Now I resample my raster to 5 m pixels, the ...
2
votes
1
answer
946
views
Combine nearby points into single point with average location in ArcGIS Pro
I've added GPS waypoints to my ArcGIS Pro map using the GPX to Feature conversion. However, some points are clearly "duplicates" of the same location because they are so close together. (...
3
votes
3
answers
588
views
Counting and merging features based on attribute field in QGIS
I have a shapefile with a number of features, each with a field called "region". I want to count the number of features corresponding to each region. Outputting a shapefile with one feature ...
2
votes
0
answers
74
views
Use aggregate to create a label from multiple shapefiles
I'm trying to fill one field of a line feature shapefile Cables (CAVI) with a default value that updates based on the start coordinate end the end one. The resulting field is a combination of the id ...
4
votes
1
answer
152
views
Aggregating isochrones with accessibility values in QGIS
I have created a series of isochrones for public transport, for the bus, tram and train, with a 5 and 10 minute walking range. Now I would like to aggregate these values to show which areas are most ...
3
votes
1
answer
180
views
Area of intercepted geometry
I have a polygon layer and a point layer (which was created by obtaining the centroid of each polygon in the polygon layer). I have tried to use the aggregate expression to automatically fill a field ...
4
votes
1
answer
742
views
Aggregating polygons within range between polygons and specific area using QGIS
I wanted and I have tried in many ways to reproduce the "aggregate polygons" function from ArcGIS to QGIS.
I have an input with different types of parcels intersected.
The parcels must be ...