Questions tagged [aggregate]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
53 views

Group neighbouring features based on sum of attribute

Each polygon (building) contains "x" number of flats (eg "flat_num"=10 in one polygon/building). I would like to group multiple polygons if: the grouped polygons are neighbors ...
6
votes
1answer
151 views

QGIS - Expression to aggregate values from an array

In a calculated field in QGIS 3.10.2 I wan't to aggregate values from an array field. For this aggregation I'm using a filter to compare matching id's and return value from another field. I can ...
1
vote
1answer
36 views

Shapefile simplification

Sorry for the lack of terminology as it escapes me. I have a shapefile that contains 96000 individual polygons and I'd like to simplify the shapefile so that it creates 1 polygon. I think it is ...
0
votes
0answers
21 views

Aggregate heating energy demand based on building data and street segments with PostgreSQL and PostGIS

I have two datasets / tables: Georeferenced building data with the yearly heating energy demand per building Street line segments from OpenStreetMap. My goal is to calculate the total heating energy ...
0
votes
1answer
53 views

Merging shapefile with dataframe and plotting using R

I am using R. I have a shapefile that gives me the provincial boundaries for a state and I want to use another dataset to combine the aggregate total enrolment in schools by 'district' to the ...
1
vote
1answer
47 views

QGIS: Creating contours at a certain elevation from DEM that match a value from a polygon layer

Trying to create contours from a 1m DEM at certain levels only when the contours fall inside a polygon with an field containing the desired contour elevation value. See images below. For example in ...
0
votes
1answer
54 views

Aggregate data from several polygons into one in QGIS [duplicate]

I am using QGIS 3.10.1, and I am trying to aggregate Census data (polygons) according to another set of polygons (neighbourhood areas that I have drawn). While I am able to clip the Census data to ...
2
votes
2answers
160 views

Translate aggregate into SQL function

In this question I was asking for a aggregate solution to update a attribute (ID) if I change or add an new feature and got a great answer from OGmaps: Add and change attribute / feature cascaded (...
0
votes
0answers
46 views

Using aggregate function in r with function from package landscape metrics

I am trying to combine the information from two raster data sets: The first data set contains information on the numer of fotos uploaded on flickr in a given raster cell (ot_fl1k). The second dataset ...
0
votes
0answers
21 views

Aggregating multiple time series to match MODIS timestep in R

I have multiple time series data for precipitation and evapotranspiration that are irregularly spaced. All but one of the datasets are daily products, but sadly one is a MODIS product that has ...
0
votes
0answers
24 views

SAGA Aggregate tool in QGIS yields empty result

Using QGIS 3.10.1-A Coruña, the SAGA Raster Tool Aggregate appears to yield no output, despite finishing normally. No new layer apears in the Layers window, nor do I see an output file specified in ...
2
votes
1answer
62 views

Expression to show specific attribute of feature within (aggregate?)

I simply want to get a specific attribute (f.e. as label or default value in form) of a feature within another feature. Aggregate could do the job but it don't. Hard for me to write it down, so let ...
1
vote
1answer
76 views

QGIS - Aggregating in virtual field

I'm using Qgis 3.10. I have two layers, let's say A and B. In layer A, there is informations about construction work (one row by construction). Each construction has an ID (ID-A). In layer B, there ...
5
votes
1answer
68 views

Count values from another layer based on value of current feature

I have two layers. One is a shapefile of U.S. states where each state is labeled with the attribute STATE_NAME, and the other is a CSV data layer named rid with many points that are labeled with a ...
0
votes
1answer
30 views

Aggregating administrative boundaries using ArcMap

I am working with a shapefile with polygons at the state level which I am grouping using the dissolve tool. How can I save the resulting layers produced from the several dissolve output layers into ...
1
vote
1answer
116 views

Making a spatial link to points within polygons in the field calculator in QGIS

I have a polygon shapefile of the counties in the UK and a separate point shapefile of project sites. Within the project sites attribute table I would like to add a new virtual column with the name ...
4
votes
1answer
109 views

Calculating the sum of a column based on another column in another table in the field calculator of QGIS

I have a records table with site numbers and abundances of different species at that site (e.g. site 1 has 6 common bats and 13 pipistrellus bats). I would like to sum total number (i.e. 6+13=19) at ...
2
votes
1answer
414 views

Aggregates Functions - QGIS - Calculating Area Explained

I've been reading through question and answers on the Aggregates Function, but have been unable to obtain a clear understanding and solution to my problem. I have a polygon grid ("Grid 4km") and I ...
4
votes
1answer
299 views

Layout expression for getting all features of layer within the current map view in QGIS 3?

In a map layout template, I want to insert an expression which gets all feature's names of a certain layer, which are contained in the current layout's view/extent. Is there a way to get an aggregate ...
1
vote
1answer
2k views

Using Aggregate and Infowindow in CartoDB

I'd like to use CartoDb to map historic addresses of a city (link to demo). Individual addresses are mapped as points on the map. Detailed information for each address point should be displayed in ...