Questions tagged [aggregation]

To combine data into larger units. For example a group of points to a polygon, or political subdivisions (provinces) to larger entities (country).

Filter by
Sorted by
Tagged with
1
vote
1answer
69 views

Aggregating point data into polygons using QGIS

I would like to aggregate point statistics to a specific polygon layer which is a 100*100m raster. The point dataset includes address data of buildings and their heating energy consumption. So the ...
2
votes
1answer
38 views

Counting categorized points in polygons using PostGIS

I want to do an operation i PostGIS similar to the count points in polygon in QGIS. I have A multipolygon table (plan.polygon) consisting of several areas A point table (basemap.points) in a PostGIS ...
3
votes
1answer
50 views

Relation aggregate function error in QGIS using Geometry by expression

I have a point layer, consisting of 12 points with fid 1 to 12. I want to render points with fid > median (fid) - thus in this case, point 7 to 12. That works perfectly if using geometry generator ...
0
votes
0answers
23 views

Open Data Cube: Aggregation of pixels' value based on shapefile and mask raster

I have several Sentinel-2 products connected to ODC. My purpose is to use a shapefile with parcels in order to extract the average value of each parcel (creation of object based dataset). In addition, ...
3
votes
1answer
41 views

Creating polygons based on point layer using QGIS

I have a point layer of residential coordinates which includes an attribute field indicating the most visited hospital for the people living at the coordinate. From these data, I want to create a ...
2
votes
0answers
39 views

Pie charts in QGIS: attributes generated with Expressions not working when using aggregate function

I have a problem to add values generated by expressions with aggregate functions to pie charts (see the screenshot below for better understanding). This question is a follow up question to this one ...
4
votes
2answers
56 views

Build land classes from GIS data

I have combined geo-referenced terrain, climate, and soil data with the requirements of the different agricultural food crops in order to build land classes that tell you where which crop can be grown....
2
votes
1answer
38 views

PostGIS: Creating Polygon from lots of other geometries and then returning list of ID's in the same query

I am fairly new to all of this but in simplistic terms I have the following problem: I need to create lines from points, and from said points group all of those within n distance of one another. From ...
2
votes
3answers
65 views

Label sums of surfaces grouped by common attribute values

I want to label the sums of surfaces ("Groesse") grouped by common attribute values ("Block") in QGIS 3.16. I need one label for each group. The following pictures help to describe ...
0
votes
1answer
13 views

Aggregate tool in ArcMap fails

I created vector polygons from a raster image and now I want to merge adjacent polygons based on a distance. I used the Aggregate Polygons (Cartography) tool after smoothing and running a Repair ...
0
votes
0answers
27 views

Converting protected areas polygons into raster

I am working with protected areas for vulnerability analysis, I have values of 1 for protected areas being vulnerable, and 2 to non-protected areas being less vulnerable. I have transformed this into ...
2
votes
1answer
56 views

Creating aggregate attribute from two polygon layers

I have two layers: one underlying land use information layer (with columns 'land_use_type' and 'area') and one for leased land. To organize the leasing of the land it would be important that when ...
3
votes
1answer
35 views

Calculate focal statistics from a 10m raster to populate a 1km raster, using the 1km raster to define the window?

I have a binary raster (1-0), cell size = 10m. I would like to generate a 1km raster, where cell values equal the mean value of all cells within a 3 km radius. I know I can use focal statistics to ...
2
votes
2answers
79 views

Group geometries of line data based on one common attribute and compute length

I have a vector file of river networks in QGIS. Some of the rivers are split up it multiple rows. What I'd like to do is to aggregate the rivers based on the attribute in one column (S_NAME) and ...
2
votes
0answers
30 views

Aggregate polygons into specific shapes [closed]

So, I've basically got what amounts to a vector-based raster set. It's a series of regular-sized squares that, for all intents and purposes, are raster pixels. The only reason it isn't a raster is ...
2
votes
1answer
208 views

Spatial join and sum aggregation of two polygon GeoDataFrames in GeoPandas

I would like to join two GeoDataFrames with polygon geometries (purple and green, see screenshot below). However, I would like to get the sum of all intersecting green areas per purple feature they ...
1
vote
0answers
44 views

Aggregating data and displaying counts with GeoPandas

I have two datasets that I want to use. The first is a shapefile of King County that has polygons broken up by school districts. It has boundaries saved as polygon features on a geo-dataframe. The ...
0
votes
1answer
50 views

Using Spatial Join, Dissolve and Aggregate in ArcGIS Pro ModelBuilder

I am creating a workflow using ModelBuilder in ArcGIS Pro 2.5.2 that will take updated parcel polygons and create/update the Zoning_Parcel (parcels symbolized at the parcel level) and Zoning_Districts ...
0
votes
1answer
71 views

Aggregate number of features by country in Overpass

Does Overpass (or Overpass Turbo) provide a mechanism for query like “show me the number of nodes tagged foo=bar by country”? Output being something like this: Country Count Estonia 5 Latvia ...
2
votes
0answers
125 views

Getting layer id of processing step in QGIS graphical modeler for usage within aggregate() function

How can I get the layer name or layer id of the result of an processing algorithm within QGIS graphical modeler, so I can use aggregate() function in a later processing step? Is this somehow possible ...
1
vote
0answers
76 views

Sum area of features intersecting atlas feature in QGIS

I have AOI layer named "Clusters" which is set as the Atlas coverage layer for my project I want to sum the area(Hectares) of specific intersecting features from my "...
2
votes
3answers
453 views

Using PostGIS to generate a polygon representing the area shared by some (but not all) of a set of polygons

I have an application where several users submit polygons, and I am looking to create an aggregate polygon that represents a kind of average of their submissions. We use PostGIS for our spatial ...
1
vote
0answers
53 views

Creating a new vector by aggregating another vector's value with a specific criterion in QGIS

I have a vector polygon layer in which each polygon represents an olive grove, each polygon has the data of harvestable biomass in that specific olive grove. Now I have to estimate transport costs ...
1
vote
1answer
33 views

Aggregate data from source value to mask layer by overlapping area

Let's assume I have a georeferenced data set seed_layer.geojson and a mask layer leech_layer.geojson. test_leech.geojson: { "type": "FeatureCollection", "features": [ { "type": "Feature", "...
3
votes
2answers
60 views

Ordinary Least Squares Point Aggregation

I want to run an ordinary least squares regression in ArcGIS Pro on my dataset which is composed of about 400 fire occurrences (point data) and demographic variables (100x100m polygons of income, ...
1
vote
0answers
23 views

Unioning PLSS Polygons

I want to union a set of Public Land Survey System (PLSS) polygons in a PostgreSQL/PostGIS layer, based on two fields, ‘sec_qtr’ and ‘qq’. A sample subset of polygons looks like this: I want to ...
1
vote
1answer
63 views

Aggregating pixels of raster dataset using ArcMap

*I am fairly new to working with raster data in ArcMap. * I have a raster dataset like in the picture I have uploaded, and you can assume that each individual pixel of the raster has a value which is ...
0
votes
0answers
26 views

How to add up election zone voting upto county level?

Sorry if it is a trivial question. I am trying to add voting data from election zone up to county-level using spatial join tool, but I cannot figure out which relationship I should use. When I use ...
3
votes
2answers
140 views

Aggregating numerous polygons into one with PostGIS

I have this PostGIS query which aggregates many polygons according to a variable ("region"): SELECT ST_AsGeoJSON((ST_Collect(polygons)),3) as geom FROM table GROUP BY region; The ST_Collect returns ...
1
vote
1answer
83 views

QGIS 3.14 vs PostgreSQL 11.5 : same query, different result

My layer has 82431 points. Each point has an attribute var with a single value a, or b or c,... I snap points, group by geometry and count the number depending the var attribute. So I start with : ...
7
votes
2answers
686 views

Get all related attribute values from features in list (QGIS)

According to this question: Get Attributes from 1:n relation in QGIS as Expression to use in Atlas I try to bulid waysigns for a hiking-GIS using the QGIS Atlas. The user should be able, to choose the ...
0
votes
0answers
95 views

Aggregate Willmott and Matsuura Temperature Climate Data on Country Level

I'm looking for monthly mean temperature data on the country-level since 1900, or at least 1950, with temperature weighted according to population density. The common database for the spatial ...
7
votes
1answer
1k views

Counting number of features within another feature using aggregating function in field calculator of QGIS?

My data: 1 polygon layer + 1 point layer My target: Calculate the number of points and the sum of a field within each polygon using the aggregate function in the QGIS field calculator. I know I can ...
3
votes
1answer
181 views

Assigning parent polygon using QGIS?

I use QGIS 3.8.0 and I'm looking for tools to assign a polygon parent depending on the value. I attach the picture, where there are several polygons with different names. I would like to get the name ...
2
votes
1answer
57 views

Generating map with polygon aggregation in PostGIS

Generate the map of federal units from the municipalities map in PostgreSQL with PostGIS. Example below: The table has only the geometry information and the "id". I tried: SELECT st_union(m.geom) ...
2
votes
1answer
293 views

Google Earth Engine, imagecollection aggregate_max (or min, or min), return null. What's the problem?

I am a little confused about this function in ee.ImageCollection: aggregate_max(property) Aggregates over a given property of the objects in a collection, calculating the maximum of the values ...
-1
votes
1answer
63 views

Calculating new raster metrics without polygonizing in R?

I have an enormous number of large rasters representing tree canopies. Every individual canopy has a unique number that is assigned to each pixel that is part of the tree. I am working with R and the ...
2
votes
4answers
842 views

Count touching and near points for every polygon (QGIS)

I have a polygon and a point layer. The polygons contains buildings, the points should be the edges of the buildings. A building is "good" as much as points are touching or in the near (buffer 0.2 ...
3
votes
0answers
593 views

Aggregate functions in QGIS using spatial intersection

I am trying to compute a virtual filed using aggregate functions in QGIS (3.6). I want to compute the average on a field in the child layer based on the spatial intersection with the parent layer. ...
2
votes
2answers
120 views

Get attributes from touching lines in network - results seems random

This question is similar to this one: Get attribute from touching line layer (QGIS) but there is a new and more komplex problem in that context I need to solve: I have to plan drains, usually along ...
4
votes
1answer
190 views

Labeling polygons with the number of related table entries in QGIS

Using QGIS 3.6.1 I have a layer with areas and a table with entries related to the areas: A relation is defined like this: What I would like to achieve is to label the areas with the number of ...
3
votes
2answers
519 views

Rescale raster to custom resolution using sum as the function to aggregate

I have a 0.0083 resolution population raster dataset which I would like to upscale to a 0.5 resolution raster. In particular, I would like the aggregation process to sum all the 0.0083 pixels ...
3
votes
1answer
129 views

Count features in polygon by using aggregate (virtual field)

I have a points layer and a polygon layer. The points are placed randomly. Some are within a polygon, some are outside. I would like to write the amount of points inside each polygon as virtual field ...
0
votes
1answer
62 views

Trying to Count Number of Points within Specified Distance from Lines using Carto?

There were multiple points stacked on the same coordinates that I did not notice. I am trying to count the number of points within 10km of lines (routes) so the routes can be styled according to the ...
5
votes
2answers
360 views

Calculating point layer values within polygon features in QGIS 2

There are two layers polygon 'BereichBerechnung' with a field "Are_Number" points 'EW2017' with a field "EWjeAdr" In QGIS with a Virtual Layer, I want to calculate the sum of the ...
0
votes
1answer
416 views

Aggregating or summing field by two or more criteria using QGIS?

I am using QGIS 2.18. I'm trying to sum fields based on two criteria with filed calculator. I have the "ID" field and the "ZONE" field (ID is secondary key, repited for other table). ZONE field has ...
3
votes
1answer
885 views

Referring to the parent layer with aggregate functions in QGIS

I'm trying to find how to refer to a field of a parent layer as a filter for an aggregate function. The instructions specify that the parent layer can be referred to with the variable @parent, but I'...
2
votes
0answers
733 views

Correct resampling method to simulate lower resolution satellite data?

I would like to simulate lower resolution satellite imagery from continuous higher resolution imagery. For example I want to use Landsat derived leaf area index data with a resolution of 30 m and ...
2
votes
2answers
300 views

tool for point aggregation and mean calculation

I have the huge number of points spread across some map. Is it possible to calculate the mean value of a parameter in the points of a small area and make one point for the same so that the total ...
2
votes
2answers
423 views

Dissolving “neighbour”/bordering polygon features in QGIS

I have a polygon layer with buildings for the area of the whole city. My question is how to dissolve/aggregate/merge only those buildings, that are "neighbours", in a sense that they share ...