Questions tagged [aggregate]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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.
thorian's user avatar
  • 23
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?...
Henème's user avatar
  • 23
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 #> ...
RichPatter's user avatar
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 ...
A_Y's user avatar
  • 81
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' ...
user35117's user avatar
  • 869
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 ...
Rii Pii's user avatar
  • 353
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 ...
Szymon Piotr Jerzy Czwart's user avatar
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', ...
Suzuha Amane's user avatar
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 ...
Руслан Омалаев's user avatar
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:='...
Morten's user avatar
  • 153
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 ...
benj's user avatar
  • 145
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))) ...
Giene's user avatar
  • 447
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 ...
Hibernian3's user avatar
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 ...
ClaudeVer's user avatar
  • 576
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 ...
Jean's user avatar
  • 21
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 ...
sn1ks's user avatar
  • 2,687
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 ...
Martin's user avatar
  • 299
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://...
Iyad's user avatar
  • 67
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 ...
edge's user avatar
  • 229
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 ...
jaykay's user avatar
  • 31
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 ...
Nikos's user avatar
  • 882
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 ...
Maxime Riou's user avatar
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 ...
Maarten 's user avatar
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 ...
vermicellion's user avatar
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 ...
Abdullah Abdullrhman's user avatar
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 ...
linda theres's user avatar
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 ...
flisior's user avatar
  • 47
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 ...
janavaarro's user avatar
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 ...
Jos David de Souza Santos Jnio's user avatar
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 ...
GIRMAR's user avatar
  • 11
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 ...
enrico_pallazzo's user avatar
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 &...
OgeiD's user avatar
  • 522
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 ...
Saelon's user avatar
  • 55
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:=&...
maxwhere's user avatar
  • 1,098
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 ...
Laura Roldan's user avatar
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 :...
ClaudeVer's user avatar
  • 576
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 ...
André's user avatar
  • 357
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 ...
MLourdes's user avatar
  • 199
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&...
edge's user avatar
  • 229
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') ...
Honeybear's user avatar
  • 2,062
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 ...
Roman Dostál's user avatar
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 ...
Kaymahn's user avatar
  • 31
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 ...
user196896's user avatar
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 ...
sfetan's user avatar
  • 141
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. (...
theforestecologist's user avatar
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 ...
Stuey17's user avatar
  • 199
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 ...
Phil's user avatar
  • 71
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 ...
Topow's user avatar
  • 361
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 ...
Paul LG's user avatar
  • 61
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 ...
Marin Marian's user avatar