Questions tagged [aggregate]
The aggregate tag has no usage guidance.
20
questions
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 ...