Questions tagged [sum]

The tag has no usage guidance.

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

QGIS: dissolve with statistics (summarize) for several attribute fields in graphical modeler

I'm trying to dissolve a shapefile by one attribute field "HYBAS_ID" and I need the other fields to be summarized simultaneously. I've worked a lot with ArcGis and the dissolve tool there ...
0
votes
0answers
16 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
49 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
1answer
142 views

PostGIS Clustering with MAX and MIN 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(...
0
votes
0answers
7 views

How to create custom calculations with filters using C# when generating reports on ArcGIS Desktop 10.7.1

I have read the help page on calculating fields in reports which has shown me that calculating fields when generating a report is possible, however, I am unsure how to write a C# expression to be able ...
1
vote
1answer
38 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
46 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
41 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
23 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
20 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
91 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
2answers
155 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 ...
0
votes
1answer
43 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
79 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
657 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 ...
1
vote
1answer
505 views

Summing field values with PyQGIS

In QGIS 2.18 there is a shapefile with three fields accordingly "id" | "Type" | "Value" I want to get the total sum of all values in the field "Value". How can I achieve that in Python console? ...
5
votes
1answer
478 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
53 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 ...
2
votes
1answer
172 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 ...
0
votes
1answer
31 views

Drawing polygon and summarizing values in map on Portal for ArcGIS?

I have a map application created in Portal for ArcGIS. I have a points layer in the map. Each point has a numeric value. I want to be able to draw a polygon on the map, containing some of the points. ...
-1
votes
1answer
79 views

Sum fields in ArcGIS

I need to merge fields in rows in the attribute table based on common values of some attributes and calculate the sum of the area associated to them. How can I do that?
2
votes
3answers
2k views

Summing data from column in Attribute table

I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. In my attribute table, I'd like to add all the numbers in the red ...
2
votes
2answers
404 views

QGIS “Sum Line Lengths” return 'nan.'

I have a polygon shapefile and a (merged) line shapefile (both are zipped). When I use Vector -> Analysis Tools -> Sum Line Lengths on these shapefiles, I get a layer with some of the LENGTHS filled ...
4
votes
1answer
361 views

Summing attribute values of overlapping polyline portions in QGIS 3.0.3

Note: This is basically the same question that I asked before in Summing attribute values of overlapping polyline portions in ArcGIS Desktop?, but this time, I'm trying to solve the same problem using ...
2
votes
2answers
739 views

Summing values from multiple polygons per neighbourhood in QGIS?

I'm measuring different values of urban parks (groundwater recharge, CO2 sequestration etc.), assignning values to the park polygons as attributes of a layer. Now I would like tu sum them up to have ...
3
votes
0answers
116 views

Grouping neighbor points based on field sum in QGIS

I have about 14,000 points. These points have a specific field "time", an integer value, mainly between 1, 2 or 3. I would like to split these 14,000 points into groups based on the "time" field ...
0
votes
1answer
1k views

Calculate sum of line lengths in R

I have object1 with polygons and object2 with lines. I am looking for a way in R (preferably with the package sf) to calculate the sum of line lengths from object2 for each polygon in object1. The ...
1
vote
2answers
439 views

Summing attribute values of overlapping polyline portions in ArcGIS Desktop?

I have polylines of 80+ bus routes operating in a city. The polylines have attribute values for the number of passengers, number of trips, etc. Many of the polylines overlap at certain areas of the ...
0
votes
1answer
185 views

Creating column in attribute table from summarised fields using QGIS?

I want to create a new (third) column in my attribute table. The fields of the new column are supposed to be the summarised value of the two other columns' fields. For example field 1 of the column I ...
2
votes
1answer
75 views

Using Sum in QGIS Attributes?

How to sum all 'Luas_sawah' attributes in accordance with the 'Kabupaten' attributes?
1
vote
1answer
249 views

Get sum of a field for each element of overlapping paths

I've used the very useful Openroute service to develop a number of routes which I have populated with traffic numbers (on each route). I want each section of road to present the total of a field (...
0
votes
1answer
70 views

Adding Values in Overlapping Buffers

I have a series of points that represent oil and gas wells (over 1,000), and an emissions value for each well. I created 3 concentric buffers that represent increasing distance from the well, and ...
1
vote
1answer
35 views

Summing attribute values from many points geocoded on same location using ArcGIS Desktop?

I have geocoded a batch of addresses and many of these are geocoded on the same location. Now I want to keep just one point on each location but sum the field values of all points from the same ...
2
votes
2answers
693 views

Adding up data values from different vector layers

I have multiple files each loaded as a layer. Each file has just an easting northing and a count value, as below. easting,northing,count 435575,804275,15 435625,804225,29 435625,804275,39 435625,...
2
votes
1answer
358 views

Why QgsRasterCalculator result is incorrect in pyqgis?

I want to sum 4 raster layers by QgsRasterCalculator. Below code creates a raster layer as result, but pixel values in raster result is wrong. what is the error in this code? from qgis.core import * ...
5
votes
2answers
132 views

How to sum multi values for each pixel in PyQGIS?

I have a raster layer and a vector point layer. I calculated distance between center each pixel and each point based on @YoLecomte and @mgri, this link and xunilk, this link. For each pixel there are ...
1
vote
0answers
520 views

How to summarize overlapping polygon values within a single layer?

At ArcGIS Desktop 10.5, I have a polygon file geodatabase feature class. Many of its polygons are spatially coincident; that is, if I click on a single polygon in Arcmap to select it, the resulting ...
7
votes
3answers
752 views

Sum integer values if values in another column are equal in QGIS?

I want a new column called "Summed" containing the summed value per "Populatie" name. How can I accomplish this?
17
votes
2answers
21k views

Summing values in field

Using QGIS 1.8, I've got a shapefile with an integer field called "AREA" and I'd like to sum the values which are in this shapefile. Does anybody know how to?