Questions tagged [summarizing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
2answers
7k views

Summing data from column in the 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 ...
1
vote
2answers
4k views

Summarizing data using ArcGIS Desktop?

I am relatively new to GIS and am facing some difficulties trying to summarize/pool data together. I've attached the file to make it easier. FID_pc11_1 (Refers to postcode identifier) and count ...
17
votes
2answers
23k 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?
2
votes
1answer
2k views

SQL query in Python console to sum column based on values of other two columns

We have 100's of shapefiles for which we have to generate excel reports based on a few (combination of) parameters in the attribute table. I am using SQL query to achieve this and when I run the query ...
6
votes
3answers
887 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
825 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 (...
5
votes
4answers
6k views

What is the equivalent of summarize field in QGIS [duplicate]

In ArcMap, user can create a table that groups the field values using summarize field tool (as shown below) How can I create a table that summarizes field values in QGIS?
3
votes
2answers
898 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 ...
3
votes
0answers
123 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 ...
3
votes
1answer
208 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 ...
2
votes
0answers
87 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
3answers
15k views

Summing all values with same ID in ArcGIS Desktop? [duplicate]

I did a one to many spatial join and ended up with an attribute table as follows: Lets say we have 5 different IDs that have numerical values in 500 rows. I need to sum the values for each ID, and end ...
1
vote
2answers
610 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 ...
1
vote
2answers
110 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 ...