Questions tagged [aggregate]
The aggregate tag has no usage guidance.
95
questions
0
votes
0
answers
11
views
Google Earth Engine script for cropping land use Image collection to shp and producing csv aggregate output
I'm new to Google Earth Engine and hoping to get some help.
I'm using ee.ImageCollection("GOOGLE/DYNAMICWORLD/V1") to look at land use types (specifically tree cover - band 1) within a ...
- 1
1
vote
0
answers
35
views
PostGIS: Left Join (ST_intersects) lead to multiple counts (not distinct) in aggregate function [duplicate]
I have a query with 2 left joints (ON ST_Within, ON ST_Intersects).The second left join (ST_Intersects) in the example below causes multiple counts of the point_table in the aggregate function (SUM).
...
0
votes
0
answers
35
views
QGIS - calculate area of intersecting features or features within Atlas_geometry
I have a layout controlled by atlas by parcel numbers. Within the parcel numbers are geometries from another layer "IAN". I would like to sum the areas of the geometries within the ...
- 537
2
votes
1
answer
144
views
QGIS: Count points directly left/right of line using geometry generator
I have a line layer and a points layer. I am trying to count the points that are within 500 meters directly to one side of my lines. I have entered the following code into Value As far as my ...
- 413
2
votes
1
answer
54
views
Aggregate/group points by value, and label aggregated point with aggregate expression (QGIS)
Problem Statement
I have a layer of multiple points, and I am trying to:
Aggregate/group the points by their attribute values, so that one point is drawn for each group of points with matching ...
- 135
0
votes
0
answers
26
views
How to create a field with a list of neighboring residential lots in QGIS?
I need to create a field with a list containing the 'name' information of the geometries that intersect each of the existing geometries. They are residential lots, and I need to list the adjacent ones....
1
vote
0
answers
43
views
Can I halt QGIS doing calculations while I work on the code?
I have a project that quite heavily relies on aggregate() functions and I can live with that it takes QGIS a quarter to do all the calculations.
But QGIS wants to redo all the calculations nomatter ...
- 183
7
votes
2
answers
187
views
QGIS functions: aggregate and array_foreach not working for vertices
I have two layers as the whole project in EPSG:4326:
polygon layer of countries
linestring layer of routes
I want to concatenate the country names (those are stored in "name" attribute) ...
- 71
4
votes
1
answer
261
views
Dissolve consecutive touching lines segments where common value in QGIS
I am trying to dissolve the grey line layer where the field "dis" ( "anzahl" || '-' || "heizlast") has the same value and the segments are touching ( end_point touches ...
- 189
3
votes
1
answer
92
views
Counting points from layer at map extent with QGIS expression
I want to create an expression in the QGIS 3.28 dashboard layer that counts points on a specific point_layer and with a specific value that is displayed in the current map_extent view
aggregate(
...
- 464
5
votes
2
answers
300
views
QGIS Aggregate expression Function with GroupBy argument
I have a Layer "SplitNEW" which is grouped by the "group"-Column as follow:
0-RED , 1-GREEN , 3-BLUE.
The 3 Lines where previous split. Each Row in attribute table stands for an ...
- 189
1
vote
1
answer
153
views
Error with array_foreach when using together with aggregate in QGIS expression [closed]
I want to use array_foreach functionality. But it does not seems to work when used in an aggregate function.
This intermediate test ( array predefined, instead of array generated by another aggregate),...
- 630
0
votes
0
answers
40
views
Merging multiple records into 1 record, group by field ‘group’
I have a point geometry file (GeoPackage) which I am working with in QGIS. It contains tens of thousands of records which discuss the topic 'Mineral occurrences'. Within this point file exist ...
- 29
0
votes
0
answers
32
views
How to average daily precipitation values into weekly sum in R
I would like to sum the daily precipitation values into a weekly format such that the raster layers names would be the first day of the weekly sum.
> print(prec_brick_ES)
class : RasterBrick
...
- 41
2
votes
1
answer
125
views
Merging multiple records into 1 record, group by field 'group'
I have a point geometry file (GeoPackage) which I am working with in QGIS. It contains tens of thousands of records which discuss the topic 'Mineral occurrences'. Within this point file exist ...
- 29