The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [grouping]

Associating or clustering data based on common attributes or properties.

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

How to make analyzeGPS distanceGPS group by trip?

I have a dataset with id, lat, lon and time, where each trip has a unique id. When I try to use mutate with the distanceGPS function in the AnalyzeGPS package and group by trip using this code: gps%&...
1
vote
2answers
87 views

Finding number of days per ID in table using ArcPy?

I need to count the span of days an individual has been observed, from the first til the last observation day. There can be many observations per ID per day and not everyday has observations, hence ...
0
votes
0answers
14 views

Given a table of distances, how do I distribute distances to minimize them between points of interest?

A little domain specificity first: I work for a nonprofit which runs a high school program for the American Legion. I’m trying to “assign” high schools (338) to local American Legion Posts (126) based ...
2
votes
0answers
42 views

Grouping layers by attribute value and finding nearest neighbour using QGIS?

I am new to QGIS. I have two layers (layer_a and layer_b) consisting of two sets of points. If I want to find the nearest point in layer_b for each point in layer_a, I can just use the Distance ...
2
votes
2answers
53 views

Update 1 random value in a group of values

I have an attribute table with a date field and a random field. The date field has three different times for each day. I need to input a '1' in the random field for one of those three times in each ...
1
vote
1answer
40 views

How can QGIS 3.X create atlas by a group field?

I have a line layer with 8 features and a field TYPE (5 features is type_A and 5 features is type_B). I want to create a atlas which output is two single image (one is grouped by typ_A with 5 features,...
0
votes
0answers
131 views

Leaflet markers at same geo location (ClusterGroup)

I have a map created with leaflet with different markers. Sometimes the markers have the same (1:1) geo position. I have already tested the great addon clustergroup, but I need the function to be ...
1
vote
1answer
61 views

Group by variable and create layers from that in QGIS [duplicate]

I have a large shapefile with one layer with several variables. The shapefile has US block groups that I'll use for analysis. However, as I want to use this for leaflet, I would like to create ...
3
votes
0answers
59 views

Clustering based on eqaul populations

I have a map of a city that is divided into 65 sectors (building lots in purple, sector boundaries in red): In my shapefile of building lots, I have an attribute that is the total population within ...
1
vote
2answers
77 views

Selecting features from grouped shapefile

I have downloaded some glacier outlines from the GLIMS database (http://www.glims.org/maps/glims) as a SHP file. This contains multi-temporal data, that is, more than one outline per glacier (more ...
1
vote
0answers
23 views

Grouping overlapping points by UTC Time, sum and average?

I have data from airplane calibrations where the plane flies in a crossing pattern; i.e. going E->W and W->E, then N->S and S->N. I need to sum and average the values for both flights in each ...
6
votes
1answer
372 views

Creating Groups of points based on proximity in QGIS?

I have a dataset with around 900 points and I want to cluster them into groups of 44 based on proximity. Is this possible in QGIS? I have tried to use the convex hull tool with no success.
1
vote
1answer
311 views

Get child layers from a layer group

I'm using a geoserver and openlayers3 with html. I cannot find the way to obtain the child layers from a layer group. I have a layer group, and I show it in html perfectly, but what I want is to be ...
2
votes
2answers
392 views

Replace several coordinates by its mean value grouped by multiindex Pandas

I have a table with some info that are getting by a GPS, in my table I have this structure: Date Time Latitude Longitude Accuracy Weather Visibility ViewPoint Species Bearing ...
3
votes
0answers
109 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 ...
1
vote
0answers
364 views

Group by index column, compare area and add values to new column in Python?

I have these columns: index, area_of_poly, cad_admin I have to group by index (it is a normal column called index) in order to take the rows that have the same value. #all the ones, all the twos, ...
1
vote
1answer
578 views

Extract and sort x coordinates in groups from a column to a new one in geopandas?

I am working with geopandas There are these columns:geo,cat and I have to make the new column called rank. rank should contain according to the groups with the similar cat number an increasing ...
0
votes
1answer
84 views

Filtering out clusters of features based on collective area threshold using QGIS/python?

I have a map I generated that roughly estimates timber industry land ownership (designated by the green on the map) in the counties surrounding the Salish Sea in the US state of Washington: I want to ...
4
votes
1answer
436 views

r - Can dplyr::group_by work with sf::st_intersects

Trying to combine dplyr::group_by and sf::st_intersects to see which of the objects within groups in a sf dataframe are intersecting with each other but in the end all objects are compared with all ...
0
votes
2answers
573 views

Creating a population dot density map at the block group level in QGIS

I'm new to QGIS, always used ArcMap, and I'm struggling to find out how to best display population density at the block group level for a county (the most granular level of detail for census geography)...
1
vote
0answers
458 views

Clustering points into *n* number of groups of equal counts with ArcGIS

I have to divide points into groups. These groups will be used by agents to talk to property owners. The goal is to make the agent's job easy by grouping parcels that are near each other together, as ...
1
vote
2answers
100 views

How to cluster/group points based on their frequency and event time without overlapping them?

I am trying to group around 100 points based on their frequency and occurred month (similar to https://i.stack.imgur.com/i7Mzi.png) but I haven't found a solution yet. Tried many tools in QGIS but ...
17
votes
1answer
2k views

Is it ok to group by geometry in PostGIS?

Is it OK to group by geometry? We do a lot of counting points by polygon geometries, which involves intersecting the data first in order to count instances of students. by school boundary, block ...
1
vote
1answer
52 views

Reducing the number of records

I have a very extensive GPS track from which I am trying to reduce the number of plotted points. I though that I would be able to do so by grouping by a round of the timestamp /900 ( every 15 mins ), ...
4
votes
0answers
1k views

Clustering of events within a space-time window (R)

I am relatively new to clustering methods and am trying to determine the best method for clustering (or merely grouping) events that fall within a space-time window using preferably R. My goal is to ...
1
vote
1answer
494 views

Load Named Style within a group on QGIS

I am trying to apply the style from .qml to a group of layers in QGIS. I have tried to incorporate LoadNamedStyle within jkall's code here: https://github.com/jkall/qgis-processing-scripts/blob/master/...
1
vote
1answer
90 views

Grouping roads based on existing condition and AADT? (QGIS) [closed]

For QGIS software, I have municipality service agreement roads and an end-plan to group the roads based on close proximity (roads and communities close together or close to each other and on the same ...
1
vote
1answer
232 views

Grouping database results based on intersection using MySQL GIS?

I am using MySQL GIS (5.7.18). I have a number of locations in the database. I also have a number of other polygons (not in the database). I would like to perform a single query, intersecting all ...
1
vote
0answers
196 views

Use of Hot Spot Analysis (Getis-Ord Gi*) [duplicate]

I'm working with a polylines shape. I'm searching for a tool that could help me to define neighbourhoods using the values of the polylines. I have good results with Hot Spot Analysis (Getis-Ord Gi*), ...
2
votes
1answer
192 views

Group geotagged photos in MapInfo

The situation is: There are many photos (between 900 to 3000), geotagged and I can see them on MapInfo. The photos are of certain objects and there may be 2 to 8 photos for each object. These objects ...
2
votes
1answer
95 views

AcrMap- How to use the dissolve tool with large amounts of polygons?

I am a college student working on an independent research project and I am trying to figure out how many points fall within a polygon. I am examining the impacts of zoning in the Great Barrier Reef ...
0
votes
1answer
355 views

Clustering point data to obtain maximum count groups using QGIS?

I am working with a data set of over 3000 points which I need to cluster/group based on a distance criteria. What I would like to do is build clusters from the point data which contain the maximum ...
2
votes
2answers
155 views

ArcGIS 10.3 - Create/extract/summarize data from unique values symbology

I have a bunch of data symbolized by categories - unique values. I have grouped together many (10 to 40 per grouping) different values to create this symbology. Now I need to figure out the total ...
2
votes
3answers
79 views

Grouping and exporting a set number of features in ArcGIS

I have an areal feature class that has approximately 4,700 features. I need to divide this feature class into multiple feature classes that contain EXACTLY 60 features in each. Location of features ...
2
votes
0answers
358 views

Problem with grouping items in print composer- QGIS 2.14

This is print composer: when i group all elements with "group items" and minimize the frame- some items step out from the frame: How can i group all items, and still maintain the same ratio of ...
1
vote
2answers
43 views

Introduce year instead of whole date in date type field using ArcGIS Desktop?

I have a field with numbers in it (concentration of chemical compounds that were presented in aquatic environments) and I'd like to combine them with a field which would have date type capabilities ...
1
vote
1answer
98 views

Combine / Group - ArcGIS attributes table [closed]

I need to group several rows in a single one, combining data cell (mainly “text”) in Arcgis desktop 10.2.2. One cell could have several records separated by comma. I have attached a screenshot in ...
1
vote
0answers
48 views

How to group different values of a variable so that they plot with same shape?

I have a table with two columns of number X and Y, and one column of strings called crystals. crystals A A B C B D B C Using ggplot2, how can I make a scatter plot of X versus Y with two ...
1
vote
0answers
142 views

How to handle multiple rasters (precipitation data) in QGIS?

Currently I am working at a hydrological model for Rwanda which needs monthly precipitation data averaged over the area of subcatchments. The precipitation data are 144 TIF's from CHIRPS for timespan ...
1
vote
1answer
867 views

QGIS Group Points Together Based on Multiple Attributes

I'm using QGIS and I want to group points that are: within 20m of each other (as I have multiple mobile basestations on the same site) based on a categorical variable (the mobile operator) I have ...
7
votes
1answer
6k views

Clustering points/polygons based on proximity (within specifed distance) using QGIS?

I have seen similar questions asked about grouping points and Concave Hull being given as an answer, but in my case there are no "features"/attributes that will classify the points. The only parameter ...
1
vote
1answer
5k views

Enable groupbox only when checkbox is checked - pyqgis

I have a groupbox which is always enable. I want it to be enable only when user want to edit something, so I made a checkbox for it. However, I have no idea how to 'link' if checkbox if selected with ...
0
votes
1answer
73 views

Selecting inputs within groups - arcpy

I need help with some python in selecting correct input and near feature classes in Near Table analysis. The project aim is to run Near Table Analysis (distance) on point locations collected at time ...
1
vote
0answers
28 views

Statistics for geo-referenced floristic inventory [closed]

I have a dataset consisting of several thousand geo-tagged photographs of flowering plants (dozens of families, roughly 240 species). The inventory was conducted monthly over three years along a ...
13
votes
1answer
5k views

Clustering geographical data based on point location and associated point values

Given data points with longitude, latitude, and a third property value of this point. How can I cluster points into groups (geographical sub-regions) based on the property value? I searched by google ...
3
votes
1answer
52 views

Get the full list of commons

In QGIS I've loaded the shapefile "province" in which attribute table contains 242 fields (the municipalities of this province) and also two other files downloaded from OpenStreetMap about hotels (...
5
votes
2answers
3k views

How to group by attributes and give unique categories in QGIS?

I have features and each of them has an attribute about what it is. In my case, I have points representing trees and each tree has its species name as an attribute. I would like to group them by ...
2
votes
1answer
68 views

Identify groups of stacked geometries in PostGIS

I need to create a column in my PostGIS table with values identifying different groups of stacked/duplicate geometries, such that one group of stacked geometries might get a value of 1, another group ...
2
votes
0answers
790 views

How to cluster point data into equal sized groups [closed]

I need to cluster point data into equal sized groups. I have 180 points and want to create 3 groups each containing 60 points. The groups should contain points which are close to each other. Is there ...
7
votes
1answer
599 views

Finding density centroids within polygons in PostGIS

I want to find the highest density of OpenStreetMap nodes within a dataset of census geometries. I want to tie the census data to the location of the node which is most central in terms of population. ...