Questions tagged [summarizing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
23 views

Update summary statistics columns using field calculator

I want to update 2 columns, which were made by summarizing field values in the first column (WEQ) based on spatial location. The summarized field (WEQ) has been updated using the field calculator, but ...
JTHW's user avatar
  • 1
3 votes
2 answers
139 views

Calculating sum of Euclidian distances from one point to multiple points within buffer in QGIS

I want to calculate the sum of the inverse distances from one main point to multiple other points within a buffer around the main point in QGIS I have a point file with multiple home addresses (red ...
Anouk's user avatar
  • 33
0 votes
0 answers
12 views

Calculation surface area for every cells [duplicate]

Surface area= Plan area /cosine (in Radian) slope. I used cell plan area by multiplying cell size for example 12,5*12,5=156,25square meters Surface Area = 156,25/cosine slope result became surface ...
Mojtaba's user avatar
1 vote
0 answers
69 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
  • 425
3 votes
1 answer
53 views

QGIS Summing attributes of polygons contained inside region polygons. Some share boundaries. Intersection gets unwanted neighbors

So I am trying to sum up populations from a census polygons layer into a region polygon layer. Now I want to sum up the total population contained in each region polygon (A & B). Here's the ...
Michael J Steele's user avatar
0 votes
0 answers
131 views

ArcGIS Pro - Summarize within - 90th percentile

I have some point data which has a response time in minutes value. I've generated a hexagon tessellation and I want to calculate the 90th percentile response time for values falling within each of the ...
Daniel Sim's user avatar
6 votes
1 answer
495 views

Summing attribute values along line layer in direction: accumulating the attribute values of side lines in QGIS

I want to sum up the attribute values from a line layer along another line layer in QGIS in a direction: The values from the orange line should be summed up along the red line, which is divided into ...
fabian96's user avatar
  • 115
1 vote
1 answer
34 views

Calculating individual Sum of multiple fields

I am trying to calculate the sum in each field in my list: Cost_Adders = ["RR_CROSSING", "INTERSTATE", "RIVER"] for Cost in Cost_Adders: where = f"Cost_Adders = {...
hBiery's user avatar
  • 13
0 votes
1 answer
127 views

Partial and Total Sum in one table (QGIS print composer)

In QGIS 3.22.14, I'd like to present in the print composer a sub- and total sum in one table. The values in the attribute table can be anything (area, count, etc.), the key is to present them in one ...
flisior's user avatar
  • 47
1 vote
0 answers
71 views

Summarize Within Returns with zero values

I am trying to summarize the areas of tree canopies (almost 2.3 million records) within each each city (Multipart). The tools runs without error, however the columns of interest are empty. How can ...
Arthur_Morgan's user avatar
4 votes
2 answers
1k views

Expression to calculate sum in QGIS Attribute table

There is a shapefile about facilities with columns "country" and "annual production". I am looking for an expression for a calc field to summarize total production for all ...
GeoEth's user avatar
  • 347
2 votes
1 answer
116 views

How to sum the values of two collections in Google Earth Engine?

I'm using GLDAS image collection in Google Earth Engine, and what a want is to sum four bands for a specific time like 10 years, and to obtain a collection with the sum date by date of the four bands: ...
user216730's user avatar
3 votes
1 answer
218 views

How to create a dynamic label for a polygon layer that sums line length and other attributes of another linestring layer

For an agroforestry design in QGIS I am trying to add dynamic labels to an area polygon that displays the number of rows, total length and the total number of trees that are in the design. So far I ...
Adamski's user avatar
  • 81
5 votes
2 answers
227 views

Summing values of different layers based on another

I have a layer (called here 'layer_top') made of multiple polygons (in orange in the picture). Each polygon of the 'layer_top' overlaps with polygons of other different layers (called here 1,2,3,...). ...
AUS85's user avatar
  • 446
4 votes
1 answer
197 views

Summing on multiple attribute value on same coordinate in QGIS

I have data like this: If we see clearly then there is same data in same coordinate, now I am doing manually like this picture which is very time-consuming. How can do it easily in QGIS?
Kazi's user avatar
  • 151
4 votes
1 answer
143 views

Creating iso-contours of cumulative values of overlapping polygons in QGIS

I start by drawing polygons by hand and assigning each polygon an attribute value for a frequency (or probability). What I then need is to create a heat map or iso-contours that show the cumulative ...
HenrikM's user avatar
  • 41
3 votes
1 answer
200 views

Summing line lengths inside each polygon in QGIS

In QGIS 3.26 I have polygon layers (districts) and line layers (roads) in my project. I need to sum the line lengths inside the polygons and write them in an attribute table of this polygon. The goal ...
MarinT's user avatar
  • 75
1 vote
0 answers
152 views

Using Filter-Argument in Sum-Expression

I am a QGIS-Newbie who is trying to get familiar with the Field-Calculator. I want to sum up the "Length" of all objects with "Calc-ID" of value 1. I know it is possible to select ...
hendrini's user avatar
0 votes
1 answer
567 views

Weighted average values of overlapping polygons in python

I am trying to reproduce the “summarize within” ArcGIS Pro geoprocessing tool with GeoPandas. I have basically two polygon files: one with socio-economic data in census units and one with income data ...
rido's user avatar
  • 11
1 vote
0 answers
73 views

Calculating percentage of classes of raster present in cells of larger raster using ArcMap

I have a Landcover raster layer at 25m resolution and would like to calculate the fraction of different classes within this layer present in each cell of a 1km resolution raster. The diagram below ...
Alex's user avatar
  • 21
4 votes
1 answer
417 views

Summing numbers separated by commas in string field in QGIS

In QGIS, I have a column separated by comma (shown by column "lengths"). I want to sum up elements in it for each row. The column is a text field string.
Eren E's user avatar
  • 143
1 vote
0 answers
384 views

How to sum-up values of a column A, with same ID in column B in QGIS field calculator

In my QGIS, I have a shape file that already contains a column stating the size of each urban green space and a column that holds the area ID (equal to a zip code). Via the field calculator, I would ...
green's user avatar
  • 41
2 votes
1 answer
193 views

Calculating cumulative sum of area values in attribute table by graphics in QGIS

In QGIS I have a set of polygons divided into plots, each polygon has a diameter and area. I would like to sum up the polygons per each plot area. From the attribute table, the polygons are not ...
David's user avatar
  • 69
4 votes
1 answer
195 views

Calculating two columns at once in QGIS

Is it possible to calculate two columns at once? So what I mean is that we have different covers and lengths and I want a total length of "Cover A" after that a total length of cover tb and ...
Joep's user avatar
  • 41
2 votes
1 answer
316 views

Categorizing field and summing attributes for label in QGIS

Using QGIS, my goal is to group "FSA"s (postal code or zip code ordering) into larger regions, and have data labels labelling these larger regions. The labels themselves would be the sum of ...
Mark Clarabut's user avatar
1 vote
3 answers
62 views

How to prevent '+' operator from concatenating rather than summing [closed]

I am trying to sum two fields and am using the expression below. "Q1 answer" + "Q2 answer" This expression is concatenating the answer to '32' when the answer should be '5' (3 ...
Laura Bennett's user avatar
3 votes
1 answer
1k views

Calculating sum of values based on another attribute as filter in QGIS [duplicate]

I have shapefile data set (Road segments) my area of interest is to calculate the length of all road segments having a particular attribute, e.g.: sum of (length attribute) when Attribute1=something. ...
Tirumani yaswanth Varma's user avatar
2 votes
1 answer
67 views

ArcGIS spatial joins: how many species are in an area as well as averaging enviro data (polygon+points)

I am trying to work out how many species are within certain boundaries (ie. states) as well as find the average of the environmental factors (like rainfall). I am using: A map of Australia broken ...
Kathleen's user avatar
6 votes
1 answer
528 views

Summing up values in rows with exceptions in QGIS

I have given my objects multiple value that represent a "need for action". I want to sum up those individual numbers to an overall "pressure for action". I have multiple objects ...
e-shirt's user avatar
  • 667
4 votes
2 answers
479 views

Grouping and measuring total length of road based on specific attribute in QGIS

I have this dataset that describes the cycleways of a city. I want to measure the km of cycleway for each type of highway (residential, track, unclassified, ecc) and then calculate the percentage of ...
anea's user avatar
  • 161
1 vote
1 answer
297 views

QGIS aggregate only specific values in a column

I have a QGIS file (see img attached) and I want to calculate the same as Area_HA only with CODE_06 between 100 and 500. I can't find the expression to add to the field calculator. yes, I want to ...
Robagb's user avatar
  • 417
7 votes
2 answers
553 views

Faster calculation of cumulative sum in attribute table in QGIS

I have a shapefile attribute table in QGIS that I would like to calculate the cumulative sum. The thing is that it has over 1.5 million features. Type of device: HDD. The attribute table looks like ...
Matias Franke's user avatar
6 votes
3 answers
1k views

Calculating cumulative SUM in QGIS Attribute table

I'm trying to get the cumulative sum of the column "uren_duur" in a new column "uren_tot" based on the recorded water height "NUMERIEKEWAARDE". The water height ranges ...
timdub's user avatar
  • 61
3 votes
2 answers
676 views

Summarizing fields with same ID in QGIS Field Calculator

I am looking for a command, that sums the value of the field "Baulast" if they have the same "ogc_fid" and if there is a Number in the field "WEA". If there is no number ...
lesto's user avatar
  • 317
0 votes
1 answer
148 views

Summing values of field in polyline layer that intersects grid in QGIS [closed]

In QGIS I have created a grid. Now I want this grid to be intersected with a line shape. The line shape contains numbers in field "x". I want to know the sum of field "x" in each ...
Hannes's user avatar
  • 129
1 vote
0 answers
617 views

Counting several groups of variables within same attribute table using ArcGIS Pro

I have a building layer. Different types of buildings have different codes, and several types of buildings belong to the same group (not actual codes but as an example codes 100-149 are residential ...
ThatArchaeologist's user avatar
1 vote
0 answers
543 views

Summing raster files through GDAL

I have a folder with over 500 raster (.tif) files. I want to produce an output raster file that is the sum of all the raster files in my folder. I am trying to use gdal and sepcifically the gdal_calc ...
LostinSpatialAnalysis's user avatar
4 votes
2 answers
167 views

Clustering vectorpoints

I created a layer of vector points out of a raster. The raster was a .png, where I extracted all the pixels with the value 1. Initially, it was a Paper, where I marked points with a pen. Now I am ...
Katja's user avatar
  • 65
2 votes
1 answer
50 views

Summing all record in field and putting value in new field

I try to sum all record in "AREA" field and put a value in "SUM" field for calculate a "Ratio" field by using Python. But I struck in a sum part. Here is my code : arcpy....
punchika munrangsee's user avatar
6 votes
3 answers
660 views

Calculating sum of line length for hundred vector layers

I usually calculate total line length by adding a $length field and going to summary statistics. How would I do this if I have many layers? Is there a faster way? I batch added the $length to all of ...
Ben Hendel's user avatar
5 votes
1 answer
90 views

Query for adding new field that is the sum of months fields

I have a table where fields are a specific month of a year. And I just want to add a new field that is the sum of the months fields that are ticked. Practically speaking I need to know the duration of ...
Noël's user avatar
  • 61
3 votes
3 answers
2k views

Summing data in row of certain attributes in QGIS

In my shapefile, I have calculated some indicators for each polygon. Now I want to create a new field having sum of these indicators. I created new field and populated it with desired values using ...
rgt's user avatar
  • 107
2 votes
1 answer
102 views

Accessing features in a cluster group in point cluster symbology

I would like to get a dynamic stat value on attributes using point cluster symbology, like it is exposed in this topic QGIS 3.10 - Point cluster symbology sum attribute Unfortunately, the answer ...
Eric Lefevre's user avatar
2 votes
3 answers
3k views

Summing multiple fields in QGIS

I have a layer/table with several fields I need to sum together to create a value in another field. I have tried using aggregate() and sum() but I can't get the a correct syntax to be able to do the ...
user187976's user avatar
5 votes
2 answers
788 views

Dissolving features with two fields and summing values for third field in QGIS

I'm trying to dissolve the fields "Inundation" and "EVC_BCS" (to get the areas of inundation and non-inundation for each rarity category). When I do the dissolve, I would also like ...
Misaki's user avatar
  • 53
0 votes
1 answer
675 views

Sum/aggregation of polygon's values within other polygons using dyplr

Let's say you have two sf objects made of polygons. In my case, one is administrative units (ADM) and the other is buildings (SHAPES). I would like to calculate the sum of the surface area of SHAPES ...
ePoQ's user avatar
  • 611
7 votes
5 answers
3k views

Counting values of each classification code using QGIS

I feel like this is an easy fix, but I'm struggling to just get a count of how many attributes I have for each value in a certain column for an Attribute table. I have a column of landfire ...
Rebekah Lumkes's user avatar
1 vote
1 answer
166 views

QGIS: Join attributes by location calculates values wrong

It seems like I got the same problem which is discussed in this thread. But since it's 2 years old already, there's an easy solution to this by now? I'm joining a vector layer which contains seperat ...
Jonas's user avatar
  • 159
3 votes
1 answer
305 views

Summing values in Virtual Layer returns NULL

In a Virtual layer I'm trying to sum the values (real) on a table ('PESQUISA') but it returns NULL. What am I doing wrong? This is the code I'm using: select sum("renda_mensal") as sum from ...
Felippe M.'s user avatar
  • 1,082
0 votes
1 answer
488 views

Summarizing table based on 2 columns using ArcMap

I got a shapefile that has the landuse and the area of every single piece of ground near a specific road. Like this: I want to summarize all landuse areas of near each road in one row. Like this: ...
Ali Riazi's user avatar