Questions tagged [summarizing]
The summarizing tag has no usage guidance.
76
questions
1
vote
0answers
29 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
0answers
15 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
27 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 ...
2
votes
3answers
59 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 ...
0
votes
0answers
20 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.
...
1
vote
2answers
45 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
38 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
47 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
27 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
30 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
34 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
52 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
178 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(...
0
votes
0answers
9 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
0answers
43 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, ...
1
vote
1answer
60 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
49 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
39 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
266 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
52 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
21 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
105 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
39 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
111 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
221 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
39 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
259 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
48 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
84 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
992 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
110 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 ...
1
vote
1answer
666 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
646 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
54 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
200 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
157 views
Polyline length within corresponding polygon
ArcGIS Pro 2.3: I have a feature class of polylines and for each polyline I want to analyze against its corresponding polygon. The link is the FLIGHTID field and it is a 1-to-1 relationship. I am ...
0
votes
1answer
60 views
Using ModelBuilder to Summarize Multiple Feature Classes?
I am trying to create a model that will iterate through all the files in a Database, return the counts of each feature class, then add them all together to get a final count and put the result in a ...
0
votes
1answer
40 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
83 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?
4
votes
2answers
4k 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 ...
0
votes
1answer
362 views
Aggregating or summing field by two or more criteria using QGIS?
I am using QGIS 2.18.
I'm trying to sum fields based on two criteria with filed calculator.
I have the "ID" field and the "ZONE" field (ID is secondary key, repited for other table). ZONE field has ...
3
votes
2answers
636 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 ...
5
votes
1answer
533 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
959 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
119 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 ...
2
votes
1answer
358 views
Compute mean attribute value of point features in same category?
I've got a point shapefile wih a column with categorical variable and a column with numerical values like the one below
Point | crop | NDVI
1 | wheat | 0.9
2 | barley | 0.7
3 | ...
1
vote
1answer
2k 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
514 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 ...
