Questions tagged [summarizing]
The summarizing tag has no usage guidance.
108
questions
4
votes
1
answer
101
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 ...
2
votes
1
answer
32
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 ...
1
vote
3
answers
49
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 ...
3
votes
1
answer
117
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. ...
2
votes
1
answer
36
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 ...
4
votes
1
answer
120
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 ...
4
votes
2
answers
182
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 ...
1
vote
1
answer
51
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 ...
6
votes
2
answers
238
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 ...
3
votes
2
answers
162
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 ...
0
votes
1
answer
57
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 ...
1
vote
0
answers
75
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 ...
1
vote
0
answers
112
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 ...
3
votes
2
answers
60
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 ...
2
votes
1
answer
39
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....
6
votes
3
answers
395
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 ...
5
votes
1
answer
69
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 ...
3
votes
3
answers
376
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 ...
1
vote
1
answer
48
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 ...
2
votes
3
answers
683
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 ...
5
votes
2
answers
158
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 ...
0
votes
1
answer
56
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 ...
7
votes
5
answers
671
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 ...
1
vote
1
answer
49
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 ...
3
votes
1
answer
139
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 ...
0
votes
1
answer
66
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:
...
3
votes
0
answers
195
views
QGIS statistical summary gives exponential value
I need the precise sum of areas for a polygon layer, where I have the area values in an attribute. When I use the Statistical Summary window it shows the sum in exponential notation:
Statistic Value
...
4
votes
2
answers
331
views
Summing area of by several attributes in QGIS
I have a shapefile that contains building footprints with multiple addresses with different functions (with each an usable area). I would like to calculate the sum of the usable area, per building &...
2
votes
1
answer
175
views
Select polyline features and see total length in ArcMap
I have a layer of polylines representing sewer mains. I want to break the layer down into groups of approximately the same length and area.
Is there a way I can select multiple features in ArcMap and ...
1
vote
1
answer
54
views
Combining parcels that are adjacent and add up to more than 10 acres
I am using ArcMap 10.7.
My task is to find a site to be developed for parking. Sites are supposed to be greater than 10 acres. But we can also look at adjacent sites that add up to 10 acres. I read ...
3
votes
1
answer
49
views
Summing area depending on another field value in the Field calculator
I have a landcover layer with an attribute of the administrative region ("GEN"). I am looking for an expression in the field calculator to calculate the summarized area depending on the GEN-...
2
votes
3
answers
222
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 ...
2
votes
0
answers
33
views
QGIS Get maximum sum of a feature subset in Atlas-View
I have a data-layer called data wich looks like this:
I also have an atlas-layout with pagenames defined by the column Jahr from the another Layer, representing the unique values from the Data-Layer.
...
3
votes
2
answers
587
views
"Zonal statistics" for two polygon layers using ArcMap
I have 2 polygon layers:
one is a vector grid with attribute values for each "polygon cell"
the other including administrative boundaries
I would like to calculate the mean value of all ...
1
vote
1
answer
229
views
QGIS Sum Line Length Problem: Values 'nan'. Road length in Grid
I wanted to use the QGIS function 'Sum Line Length' to compute the sum of the road lengths in each grid cell in Nigeria.
My roads data is from here: https://data.humdata.org/dataset/nigeria-roads
My ...
0
votes
1
answer
57
views
Computing together "sum" and "if" formulas in GRASS Raster Calculator [closed]
I'm working on global climate projections raster maps. My starting data are global raster maps of daily future climate, where every map represent one single day (e.g. I have 365 maps for 1 year). ...
2
votes
1
answer
94
views
Summing up columns of the same feature in different layers in QGIS
I have multiple shapefile layers of a city with its districts that have the same shape and information, only the last two columns are different (The picture shows one of the three attribute tables).
...
3
votes
0
answers
31
views
PYQGIS: Summarizing values by defined field and write the result to a specific attribute
I'm using QGIS 3.10 with Python 3.7.
I would like to sum/group the length of 5 attributes by an ID and write the result in an other layer (to an attribute with the same ID).
Example:
I have two layers:...
0
votes
0
answers
204
views
Google Earth Engine: Sum property values for region
I have run the code below, to find regions where data is available from my image collection, which This produces a feature collection per region and per variable (in this case SST and Salinity).
// ...
2
votes
1
answer
62
views
Making summary table of continent wise contribution of research papers in literature using QGIS [closed]
I want to generate a summary table. This table will consists of contribution of each continent in research literature.
I have a CSV file that consists of latitude and longitude information of each ...
-1
votes
2
answers
277
views
PostGIS Clustering with MAX, MIN and SUM Limit of Attribute
I have point data with number of peoples living in a house.
wkt111,members
SRID=4326;POINT(8.40771254932301 52.8935196103868),158
SRID=4326;POINT(8.35609033091261 52.8948388844689),122
SRID=4326;POINT(...
2
votes
1
answer
162
views
Summing attributes from different layers
In QGIS I have some shapefile describing the distribution of an animal, these file have an attribute name "PRESENCE" with value 1. There are points when only one file is present and other ...
2
votes
0
answers
177
views
Calculating Nth percentile from table in ModelBuilder of ArcMap
I am trying to build a complex tool, using ModelBuilder and I am new at this.
I have two feature classes full of polygons:
The first contains 1300 polygons, dividing a city in zones (ex: residential, ...
2
votes
1
answer
259
views
QGIS sum selected line lengths
I need a tool which displays the sum of selected lines as I go in QGIS. Something like the Measure line-tool. I´m new to PyQGIS. The logic seems quite simple, I just don´t know where to start. I guess ...
0
votes
1
answer
75
views
Incomplete summary statistics in ArcMap
I am using ArcMap 10.4.
I have an attribute table of shapefile with more than 20 millions rows stored in gdb. That table has a column with postcodes (that are often repeated) and column with values. ...
0
votes
1
answer
67
views
Summarizing individual data in table using ArcGIS Pro
I am attempting to summarize a a bunch of individual rows in a table I added into ArcGIS Pro, and I'm wondering if there is any type of tool or work flow I could use to do so?
This is kind of a ...
2
votes
1
answer
985
views
Where is Summarize Raster Within tool in ArcGIS Pro?
I am looking for a tool to calculate mean across multiple rasters. I am aware of cell statistics tool that can be used here. I am also aware that raster calculator can also be used here. But, in my ...
0
votes
1
answer
73
views
Projection of TRMM in dictionary
I am trying to extract the 24 hour precipitation data of a given polygon by creating a dictionary . I have gotten results but i'm not sure if the parameters I have inserted in the reducer are correct.
...
1
vote
1
answer
26
views
Cleaning SQL queries [closed]
I have a bit of SQL code that look similar to this:
SELECT
sum(case when latitude = '0' then 1 else 0 end) as count_zero,
sum(case when latitude is NULL then 1 else 0 end) as count_null,
sum((case ...
1
vote
1
answer
66
views
Sum of values based on specific field name or Sum of values based on specific field names from different layers using ArcGIS Desktop
I am looking for a way to sum the numerical values contained in a layer file based on a specific field name in ArcGIS 10.7
Let's say that I have a polygon shapefile that contains region names and the ...