Questions tagged [summarizing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
2answers
42 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
1answer
34 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
3answers
311 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
1answer
66 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
3answers
201 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
1answer
36 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
3answers
230 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
2answers
72 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
1answer
24 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 ...
6
votes
5answers
218 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
1answer
23 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
1answer
55 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
1answer
35 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
0answers
88 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 ...
0
votes
1answer
59 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
1answer
37 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
1answer
39 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
3answers
98 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
0answers
29 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. ...
2
votes
2answers
210 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
1answer
100 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
1answer
52 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). ...
3
votes
0answers
29 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
0answers
128 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
1answer
56 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 ...
-2
votes
2answers
225 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
1answer
88 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
0answers
103 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
1answer
160 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
1answer
64 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
1answer
49 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
1answer
588 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
1answer
63 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
1answer
24 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
1answer
32 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 ...
4
votes
1answer
141 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 ...
1
vote
0answers
41 views

Creating automatic sum column in ArcMap

Using ArcGIS 10.3 I have a table with different categories and would like to summarise each of them. I want it to work as well when these data are selected inside a polygon. Below is an example of ...
0
votes
0answers
25 views

Field summary with hooking one side

I have line like Road and points are like housenumbers! I have fields like side and ID_T Highlighted blue apts having same ID_T because hooking one edge and side, if it hook right get R or else get ...
4
votes
1answer
133 views

Summarize bad handling of null values? [closed]

Summarize by right clicking the field in the table of attributes is giving wrong calculations in some cases. We think is because of null values. The following table is a subset of a larger (>200k ...
2
votes
2answers
325 views

Summing Area of polygons within vector layer within zone using QGIS?

I have one vector layer with multiple polygons (purple). I also have a number of other vector layers which are catchment zones (I also have a layer where these catchments are merged). Is there any ...
1
vote
1answer
47 views

Summing data from a smaller boundary shapefile to a larger boundary shapefile if the boundaries do not align in ArcGIS Pro?

I have a census tract boundary shapefile for the province of BC, with around 620 polygons, varying in size. I have another boundary shapefile, BC service areas, this one has much larger polygons and ...
1
vote
2answers
452 views

Summarizing table into multiple fields using ArcGIS Pro?

I have a large table with 150000 features. Every feature has one key and a keyword that I want to use to make a new field with. Below is an example: |Field A|Field b|Shape_area| |key 1 |Type 1 |300 ...
0
votes
1answer
52 views

Summation of multiple map layers?

What I am trying to do is to take a specific range of time (summer) over multiple years and then sum the total amount of precipitation onto a final layer. This is the code I am working with var ...
1
vote
2answers
116 views

Use a python expression in Field Calculator to sum each row across several columns

this seems like it should be easy but I am new to python and am having trouble... I have four columns. I would like perform a field calculation that sums the values by row for three of the columns and ...
2
votes
2answers
1k views

Sum over Bands, Google Earth Engine

I have this real Big Bandet Image with 25000 Bands. I want to Sum over the Bands, Pixelwise. is there a Way to either : -convert this ee.image, bandwise to an ee.ImageCollection -Collapse all ...
0
votes
1answer
130 views

Pivoting Tables and using Frequency in ArcGIS Desktop?

I have a points layer of specimen samples. They have a field called "RESULT" which is a string field containing the results of a test, "Positive" and "Negative"(you can only see negative in the pic ...
6
votes
3answers
1k views

Summing values in one field using PyQGIS

In QGIS 2.18 there is a shapefile with three fields accordingly id Type Value 1 a 5 2 b NULL 3 c 1 4 d 6 5 e NULL I want to get the total sum of all values in the field "Value". How ...
5
votes
1answer
930 views

Add cumulative sum column to attribute table

I have an attribute table in QGIS in which I would like to calculate the cumulative sum. The table is sorted by N (number of fatalities) and I would like to calculate the cumulative sum on F (...
2
votes
0answers
57 views

Sum of values grouped by owner [duplicate]

When I try to use the following expression, the preview shows me the correct sum, but when I click ok I get this notification. This tells me it can't calculate column "Subsidie J" It seems that it ...
3
votes
1answer
221 views

Join attributes by location gives out wrong sum

I have an input vector polygon layer which has different areas. Now I want to join a different vector polygon layer which contains over 1 million 100x100 meter squares with information about the ...