Questions tagged [aggregation]
To combine data into larger units. For example a group of points to a polygon, or political subdivisions (provinces) to larger entities (country).
0
votes
0answers
14 views
Extraction Burned Area from MCD64A1 for Region
I would like to extract burned area and burn date information from MCD64A1 MODIS Collection 6 global burned area product. The data is in monthly composites with burn dates in julian days. I need it ...
2
votes
2answers
61 views
Calculating point layer values aggregated by sub-polygons in QGIS 2
I simply have
a polygon layer BereichBerechnung with a field "Are_Number"
a point layer EW2017 with a field "EWjeAdr"
In QGIS with a Virtual Layer, I want to calculate the sum of the field "EWjeAdr" ...
3
votes
1answer
83 views
Line width and labels based on blended values of features sharing same geometry in QGIS
I want to appropriate line segments that share the same geometry with a particular line width and labels based on the aggregated values of one field "GIS@BUS_5_Min".
My attribute table and polyline ...
0
votes
1answer
40 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 ...
1
vote
1answer
55 views
Referring to the parent layer with aggregate functions in QGIS
I'm trying to find how to refer to a field of a parent layer as a filter for an aggregate function. The instructions specify that the parent layer can be referred to with the variable @parent, but I'...
2
votes
0answers
40 views
Correct resampling method to simulate lower resolution satellite data?
I would like to simulate lower resolution satellite imagery from continuous higher resolution imagery. For example I want to use Landsat derived leaf area index data with a resolution of 30 m and ...
0
votes
0answers
44 views
Convert list of raster* object into rasterBrickTS object in R
I have a list of raster bricks that have a date value in the z slot. I am trying to perform weekly averages across this list. For example, if my list had one brick for each day of a single week, I ...
2
votes
2answers
45 views
tool for point aggregation and mean calculation
I have the huge number of points spread across some map.
Is it possible to calculate the mean value of a parameter in the points of a small area and make one point for the same so that the total ...
0
votes
0answers
9 views
Aggregating dataframe columns : Some columns to sum , and some columns to average
I have a data frame with 100 columns. Around 50 columns i need to add up, and the other 50 i want the average grouped by an id column. I want the new data frame to have the same name as the previous ...
2
votes
2answers
149 views
Cartographic generalization: Dissolve “neighbour” / bordering polygon objects in QGIS
I have a polygon layer with buildings for the area of the whole city.
My question is how to dissolve/aggregate/merge only those buildings, that are "neighbours", in a sense that they share at least ...
1
vote
1answer
42 views
Joining attibutes by location + aggregation per field
I am new to QGIS.
I have a point layer (water permits) and several buffer layers (different distances from WWTPs). I can use "join attibutes by location" and find out the number of points and the ...
3
votes
2answers
48 views
Aggregating polygons with Basic level licence of ArcGIS Desktop?
I need to aggregate near-by polygons, but it has to work with a Basic ArcGIS Desktop Licence. I can't use the Aggregate tool (only Advanced) and I can't use the buffer tool, because the rounded edges ...
1
vote
1answer
80 views
Error concatenating lines in Oracle Spatial
The function SDO_AGGR_CONCAT_LINES is returning an error when concatenating lines from a table with simple line geometries (SDO_GTYPE - 2002):
ORA-29400: erro do cartridge de dados
ORA-06502: PL/...
0
votes
1answer
28 views
Aggregate and split layer by location into multiple layer in ArcMap? [duplicate]
I'm pretty new to GIS, but hope I'm moving in the right direction. I have a layer of the county map of LA, which is divided into communities and a layer of the building coverage of the county. The ...
2
votes
1answer
86 views
Creating an aggregate function filtered by entry value
Can anyone help me parse an aggregate function for Qgis 2.18 which sums the values of one field, for all entries which match a value of the entry in question.
So, for example if I have a simple ...
2
votes
1answer
73 views
Aggregating/Averaging NDVI across pixels. Arithmetic mean seems bad choice
I need to compute an aggregate index for vegetation density in certain (large) shapes, to assess desertification. I have NDVI data at a high spatial resolution (~100 NDVI-pixels per aggregation shape, ...
3
votes
1answer
79 views
How to calculate the number of polygons along a line segment in QGIS
The image below is a representation of a digitised urban area derived from Google Satellite and OSM. The black lines between nodes are street segments and the irregular polygons are households.
I ...
3
votes
1answer
95 views
Aggregating strings in QGIS
My inputs are in this way :
col1 col2 col3
1 a c
1 b c
2 c c
2 d b
2 e z
And I would like to obtain :
col1 col2
1 a, b
2 c, d, e
I ...
2
votes
1answer
67 views
Working with Sentinel-2 data and aggrigation in R
So I was wandering if there is a way to simplify a couple of Sentinel's rasters so I can apply raster analysis on them. Problem is that whenever I try to aggregate the data my RAM, CPU and storage ...
4
votes
1answer
93 views
Visualize challenge: show origin of aggregated minimum r.series job
Using r.series with the aggregate minimum option I'm merging multiple viewshed results to visualize how much vertical space a development area has for new buildings. Meaning that a part of the height ...
2
votes
1answer
71 views
Expression Builder in QGIS in editing Attribute Table
I am working with a simple attribute table that has 4 columns;
'Xcoord'
'Ycoord'
'id'
'id2'
'id2' is a new field that i added to the attribute table.
'id' is a field showing land use classes with ...
4
votes
1answer
743 views
Aggregating raster using GDAL?
I have a GeoTIFF which is at 30m resolution. I need to downsample it to 250m resolution (using some aggregating function such as mean, mode, sum). My stack is python (rasterio and GDAL bindings)
I ...
0
votes
0answers
84 views
Is there a way to retrieve shapefile attribute table information for a given coordinate in R?
Does anyone have an idea how could one get information out of shapefile attribute table (class SpatialPolygonsDataFrame in R), in my case data from column that contains species names, based on a list ...
2
votes
1answer
96 views
Aggregate polygons in edit session using ArcObjects and c#
I want to aggregate some polygons in edit session using ArcObjects and c# language. In other words, my purpose is to use methaheuristic algorithms for polygon aggregation. So, I want to aggregate some ...
12
votes
2answers
270 views
Aggregate Lines Based on Distance between Segments
I have a VectorTile basemap that I am optimizing, (working on reducing the size of individual tiles), the major chunk of tile size is road data (geometry and attributes). I am working on simplifying ...
1
vote
1answer
221 views
Aggregate by date-time and compute a centroid as an output?
(I would prefer using R if possible)
I have a table with coordinates (in latitude, longitude), time information (YYYY-mm-dd HH:MM:SS) and ID information (example provided). I sometimes have multiple ...
0
votes
1answer
34 views
Filtering out class from high resolution map in lower resolution map?
I have a soil sealing fraction map (SSF) with a resolution of 30 meters and a high resolution land cover map (HRLC) with a resolution of 5 meters.
I would like to use the HRLC map to filter some ...
1
vote
1answer
597 views
R spatial aggregate, IDs out of order
HUC12_intersects is a SpatialPolygonsDataFrame object with over 5000 polygons
library(rgdal)
library(sp)
library(rgeos)
library(raster)
library(maptools)
HUC12_intersects@data
AREA_ACR_1 GEOL_CODE ...
-1
votes
2answers
485 views
Aggregation of MODIS 16 days data to annual data set
Is there a way to calculate mean annual NDVI and mean annual EVI from the time series MODIS images (2000 - 2016). I have gridded data downloaded to the local drive. Planning to use R for this work.
3
votes
1answer
94 views
Change raster cell size while keeping attributes
I have a raster with a cell size of 1 and I want to increase the cell size to 5 so I use the Aggregate() function in ArcMap 10.4.
The problem I'm seeing is that after processing I lose the desired ...
3
votes
1answer
47 views
Aggregating georeferenced point data to conflicts site using R
I have a question with regard to joining to datasets.
On the one hand I have information about the location of a conflict regarding its lat/long, radius, and area and how it changes over time. Here ...
4
votes
2answers
2k views
Mean by month on R stacked raster
I work with MODIS NDVI rasters in 2016. I have 23 rasters stacked in one object. I have 2 raster by month. I would like the average by months and conserve a raster for each month.
ndvi.stack <- ...
4
votes
2answers
297 views
Aggregation of multiple POSTGIS records in Geoserver
I have a WMS layer which geoserver fetches from a postgis layer. For a given query to this layer I might have two records for a given geometry. The record contains geoshape and value where value is ...
6
votes
1answer
2k views
Calculating Optimal Geohash Precision from Bounding Box
I'm using Elasticsearch's GeoHash grid Aggregation to plot clusters on a map (using Leaflet). I understand that for larger areas a lower precision setting should be used to limit the number of buckets ...
2
votes
0answers
66 views
Is aggregating points to areal units ever useful - Spatial statistics
I have a large point dataset of a population (By population, I mean that it was not a sample e.g. all houses in a county with an attribute such as size, price, age, etc.). Each point represents each ...
0
votes
0answers
20 views
Collect table-data from multiple polygon layers according to a polygon-fishnet using ArcGIS Desktop? [duplicate]
I have multiple polygon layers of varying geometry (polygon-boundaries not the same) on top of each other:
Now I want to collect table data of these layers in a new layer.
Since the geometries of ...
0
votes
1answer
1k views
R - aggregate with additional argument
I would like to use the function aggregate (R raster package) to assign to a grid point of the new raster the number of grid points of the old raster that have a certain value
for(val in 1:10)
{
...
1
vote
1answer
59 views
Sum of features from one layer to another
I have two different shapefiles and I work in Arcmap. This is what I have:
The areas in picture 1 are smaller areas and the areas in picture 2 are in an aggregated form. File 1 contains number of ...
5
votes
1answer
92 views
Zonal statistics - computation time issue with assigning zones
I would like to upscale a 1/360 degree resolution raster (64800 x 129600) to a 1/12 resolution raster (2160 x 4320) by assigning to each cell in the low-res raster the number of cells in the high-res ...
3
votes
1answer
369 views
How to aggregate pixel in gdal python?
I want to aggregate pixel in raster file like Arcgis(picture).
Is this fuction possible in gdal(python) or geotools?
And I want to add option to select representative value(ex.sum, max, average..)
1
vote
2answers
59 views
Aggregating in FME and subsequent proportional split problem in MapInfo [closed]
I have recently aggregated 6 spatially identical MapInfo TABs in FME. The data has Lotplan and PPN attributes that are then used to group by in the aggregation:
The polygons and figures in the ...
1
vote
1answer
198 views
Sum area of specific poly attributes within raster grid cell
I have a polygon layer (A) containing several different land use types (road, building, etc). I also have a different GIS layer (B), a raster of NLCD land use/land cover. I would like to sum/...
7
votes
1answer
925 views
How to include aggregate field values of clustered points
I am creating a map that has point features representing things like campgrounds, picnic areas, boat launches, etc. In cases where many points are clustered in an area (representing amenities for the ...
2
votes
2answers
542 views
R: creating an error matrix from two rasters
I have two land use rasters (6 classes each) and I'd like to create an error matrix (errors of omission and commission) from them both.
The premise is that I have a very fine 'base' raster and have ...
1
vote
1answer
774 views
Aggregate census tract data to county level
I have data on a census tract basis but I am having trouble aggregating them to county level. Is there any tool to do it in ArcGIS?
1
vote
1answer
635 views
Using FME to aggregate POI to one point
I want to aggregate points of interest (POI) using FME. The aggregation should make it possible to group all POI within an area based on a buffer distance from the centerpoint of n POI.
This would ...
1
vote
1answer
812 views
Counting raster values using another raster as mask in R?
I would like to count the frequency of values in one raster, using another raster (different resolution) as the zonal condition.
The premise is that the coarser resolution raster represents the area ...
0
votes
0answers
39 views
Aggregating Individual District Assignments to Census Block
Working on a solution that may work but figured I'd ask the community to see if there's a smarter way to get this task done.
I have a voter registration file with district assignments for each voter. ...
4
votes
2answers
3k views
R: aggregate raster with 'mode' function - how does it work?
I want to aggregate a very fine resolution raster at various coarser resolutions (that represents many 1000s of categorical polygons).
The aggregate{raster} function is what i've traditionally used, ...
2
votes
1answer
3k views
When aggregating points by polygons with sp::over function, how do I include attribute data from both the points and polygons? [duplicate]
Data: Zipped ea.ml1 shapefile can be found here, and the country outline can be downloaded here at the GADM site. I've been using the Ethiopia ESRI shapefile. Branch locations are here.
I have a ...
