Skip to main content

Questions tagged [grouping]

Associating or clustering data based on common attributes or properties.

Filter by
Sorted by
Tagged with
2 votes
1 answer
54 views

Aggregate/group points by value, and label aggregated point with aggregate expression (QGIS)

Problem Statement I have a layer of multiple points, and I am trying to: Aggregate/group the points by their attribute values, so that one point is drawn for each group of points with matching ...
MarcusR's user avatar
  • 135
0 votes
0 answers
47 views

Creating non-overlapping boundary polygons with point attributes

I have a set of points that represent the meter locations for my electric company. These points contain a 3 digit code that represents the route number for the meter reader routes. I also have a ...
user238803's user avatar
0 votes
1 answer
64 views

How do I create a Geodataframe which the data is grouped by User ID & the timestamp is sorted from oldest to most recent?

I've been struggling to complete this exercise (Exercise 2 Problem 3) which you guys can refer to this link. A reminder that the kruger_points.shp is obtained from Exercise 2 Problem 2. Here's the ...
mfirdaus_96's user avatar
3 votes
1 answer
121 views

How to group/clean group of scattered points based on their distance and attributes?

I downloaded traffic signs from Mapillary API. I found that many of these points represent the same real life entity, but they are scattered in the map. Since they are distinguished by their category ...
588chm's user avatar
  • 625
3 votes
2 answers
204 views

Classifying in QGIS into arbitrary number of percentiles instead of quantiles, based on attribute field value

Extending this question and this one: In QGIS, there are special expression functions for the first and third quartile (q1 and q3) and as well as median (median). So it's easily possible to categorise ...
Babel's user avatar
  • 73.2k
0 votes
1 answer
100 views

PostgreSQL and extension tablefunc with enumerated type

In PostgreSQL, I created an enumerated type CREATE TYPE w_sebio.t_sebio_type_sad as ENUM ('transféré', 'traité', 'non soumis', 'ouvert', 'non traité','PAC réalisé'); then a table CREATE TABLE w_sebio....
fcka's user avatar
  • 985
3 votes
1 answer
85 views

What is the equivalent of native:aggregate() in QGIS Field Calculator?

I have two layers which I want to connect using the aggregate() function with the Field Calculator. I can do this using the processing tool: processing.run("native:aggregate", { 'INPUT' :...
eagleadmiral's user avatar
0 votes
1 answer
79 views

Count number of records with the same date

I have a table with species sightings and I would like to add a field with the sighting number in that day (every day should start again from number 1). Ideally this should be done automatically as I ...
Kike's user avatar
  • 33
1 vote
0 answers
44 views

Grouping points within counties and symbolizing their data as pie charts in QGIS

I need to combine/categorize points within different polygons while retaining some of their values. I've made up a scenario to try and simplify my problem. The layers I have to work with are a point ...
Inga's user avatar
  • 19
1 vote
1 answer
79 views

Cannot enable 'Any organization's members' setting when creating Group or updating properties using ArcGIS Python API [closed]

I am creating a group using the ArcGIS for Python API, there is limited information in the API Reference here. And I found some more information in the Rest Reference relating to the membershipAccess ...
Clubdebambos's user avatar
  • 1,700
1 vote
1 answer
41 views

What do parameters provider_group_name and provider achieve in GroupManager create function when using ArcGIS Python API?

The create() function in the GroupManager module has two parameters; provide_group_name and provider. See API Reference What is the purpose of these parameters? I cannot find any documentation ...
Clubdebambos's user avatar
  • 1,700
5 votes
2 answers
454 views

Calculating mean with group by based on another column in QGIS Field Calculator

I have daily temperature data for several cities from January to December. I'd like to calculate the average temperature per month for each city in a new column. I have a column "city", &...
GisUser's user avatar
  • 649
0 votes
0 answers
74 views

Mapping groups' data on the map using Map.addLayer - GEE

I wanted to extract the areas of specific clusters. I asked this question. I wanted to extract the areas of object-based clusters but the answer I got, resolved my issue. I need to visualize the ...
th145's user avatar
  • 25
5 votes
1 answer
172 views

Selecting N points within each geometry using SQL

I have grid and point tables in my Postgres db. The points are not equally distributed over the grid. The grid table is 100k+ geometries and the points are in the 100's of millions so efficiency ...
RedM's user avatar
  • 1,565
1 vote
0 answers
103 views

Using function "buildGeometry" of JavaScript library JSTS with 'ol.interaction.Select' and 'ol.Collection.<ol.Feature>' objects?

What type is the argument of a function "buildGeometry" of JavaScript library JSTS? How to use JSTS function "buildGeometry" with OpenLayers 3 selection, which is created is this ...
Kamil Szmit's user avatar
4 votes
1 answer
66 views

Grouping features with identical values in two fields and deleteing the geometry with the lowest value in the third field using QGIS

I've got a shapefile with three fields: "X", "Y" and "Z" they are the geometries as well but I also have them as field values. Every line geometry in the shapefile has a ...
sistema's user avatar
  • 41
2 votes
2 answers
129 views

Looking for QGIS equivalent of ArcGIS "Group values" tool

I have LULC 8 classes. I want to group them in QGIS into five priority score classes in Symbology, just the same as the function in ArcGIS "Group values". But I can't find the same tool in ...
Bokhir Alikhanov's user avatar
6 votes
2 answers
379 views

Categorising data points along transect using QGIS

I have data on the latitude and longitude of several locations in Europe (blue). So far I have been able to read this data into QGIS but not more. I would like to plot a transect (red) and then ...
qgisquesls's user avatar
2 votes
1 answer
44 views

Combine features into new category

Within a vector layer I have dissolved 25k polygons into 43 different categories of land ownership (Ld_Use_Des). But now I want to further ''group'' them. For example I want to select Mineral Rights ...
N_LLC's user avatar
  • 615
2 votes
1 answer
304 views

Get a group from layerTreeRoot using its unique id using PyQGIS

I am having trouble when loading some layers in QGIS. I want to place them in specific groups and sub-groups but a problem occurs when multiple groups and sub-groups have the same name. The only way I ...
Manos Papageorgiou's user avatar
1 vote
0 answers
159 views

Group by multiple columns in QGIS array

I'm looking to create a figure with multiple rule-based symbologies. A graduated range within a category within a main category. The only way I think that's possible is by adding categories, ranges to ...
envsci_melb's user avatar
2 votes
0 answers
53 views

Create variable containing the conditional mean of a group

I have a table with three columns, the first defining a group (Group), the second a characteristic (Species), and the third a numeric value (Height). I would like to obtain a fourth numeric column in ...
Marie_Madeleine's user avatar
2 votes
1 answer
500 views

Create multiple callout lines from a single label

I would like to label groups of points (clusters) with only one label but several call-out lines. I built on top of the very appealing answer from @eurojam here: Giving one label to two points using ...
Beni's user avatar
  • 356
1 vote
2 answers
170 views

Assign ID for coordinates with several points

In ArcGIS pro I have a point layer with XY-coordinates. At each coordinate there are several points with different timestamps. I would like to give each coordinate an ID, for example to be able to ...
DMK's user avatar
  • 33
0 votes
1 answer
430 views

Joining tables with GROUP BY in ArcGIS Pro

I have a layer "Table1" and an attribute table "Table 2" both stored in a PostgreSQL enterprise geodatabase, these 2 data have one field in common for which the cardinality of the ...
MAR's user avatar
  • 183
6 votes
3 answers
1k views

Grouping points to clusters containing similar number of features using QGIS

The question Using QGIS, how to cluster unevenly distributed points from the same layer to groups of about the same size / containing the same number of features? The problem I have a large point ...
Babel's user avatar
  • 73.2k
2 votes
2 answers
2k views

Filling attributes in one field based on second field with same values in QGIS

How do I fill the attribute with "SID_2" of the captured image where the ID of "SID_1" is NULL? I'm using QGIS 3.22
Don's user avatar
  • 29
4 votes
1 answer
210 views

Calculating two columns at once in QGIS

Is it possible to calculate two columns at once? So what I mean is that we have different covers and lengths and I want a total length of "Cover A" after that a total length of cover tb and ...
Joep's user avatar
  • 41
2 votes
0 answers
191 views

Group points based on proximity and equity using QGIS

I would like to group students based on the nearest school, but also having mixed social categories within the group of students. I have x,y coordinates for the students and the shcool. Each student ...
DBeau's user avatar
  • 21
1 vote
0 answers
202 views

How to calculate sum of night light radiance for each feature in a feature collection?

I have a shapefile which contains 36 polygons (districts/counties). For each district, I want to calculate sum of lights (as well as count total number of pixels). I tried following code but failed. ...
Tariq Abbas's user avatar
4 votes
1 answer
152 views

Grouping lines by name and determining their proportions using Virtual Layer

I have a line layer with hiking trails. The hiking trails are divided into their surfaces. So one hiking trail consist of parts with different surfaces. I would like to use a virtual layer to group ...
MartinMap's user avatar
  • 8,338
2 votes
2 answers
250 views

Selected item in layertree group or layer?

How do I check in PyQgis if the selected item in de QgsLayerTree is a group or a layer. I really can't find the answer.
JAS's user avatar
  • 495
4 votes
2 answers
486 views

Grouping and measuring total length of road based on specific attribute in QGIS

I have this dataset that describes the cycleways of a city. I want to measure the km of cycleway for each type of highway (residential, track, unclassified, ecc) and then calculate the percentage of ...
anea's user avatar
  • 161
5 votes
1 answer
1k views

Unsplitting/merging lines that have coincident endpoints using PostGIS

I have a large dataset of lines/linestrings (ie. a road network), which is unregularly segmentised/ split and the lines needs to be merged at coincident endpoints (if only two lines are touching). I'd ...
krenz's user avatar
  • 163
3 votes
2 answers
723 views

Summarizing fields with same ID in QGIS Field Calculator

I am looking for a command, that sums the value of the field "Baulast" if they have the same "ogc_fid" and if there is a Number in the field "WEA". If there is no number ...
lesto's user avatar
  • 327
3 votes
2 answers
767 views

Adding unique ID for consecutive groups using Field calculator in QGIS

I found a similar question on this site and the answer suggested: array_find( array_distinct( array_agg("PortCluster_ID") ), "PortCluster_ID" ) + 1 ...
Peter Mastnak's user avatar
4 votes
2 answers
96 views

Replicating ArcMap legend in QGIS 3

I am trying to replicate this ArcMap legend in QGIS but i can't seem to get it right. I am stuck in print layout and using QGIS 3. I have the title 'LEGEND' but i do not know how to categorize the ...
Ruth's user avatar
  • 41
3 votes
3 answers
860 views

Counting and merging features based on attribute field in QGIS

I have a shapefile with a number of features, each with a field called "region". I want to count the number of features corresponding to each region. Outputting a shapefile with one feature ...
Stuey17's user avatar
  • 199
2 votes
0 answers
47 views

Dynamic buffer regroup [duplicate]

I am using QGIS 3.16 and I want to create a dynamic buffer around a layer of points, so that every time I move some point the buffer also moves. I have succeed by duplicating the layer and then ...
DobleG_95's user avatar
0 votes
1 answer
230 views

Hiding/Displaying dashboard content (tiles) based on user or group logging in using ArcGIS JavaScript API

I want to know if it is possible to either hide or display the content of an Esri webapp, dashboard, or experience (tiles, widgets, data layers, filters) depending on which Portal user is accessing ...
Andrew's user avatar
  • 1
2 votes
1 answer
163 views

Clustering of points but with a condition of not crossing set of lines

I have multiple sets of around 200-300 points and I have the following requirements: Cluster the points in each set into a group of points with a minimum & maximum number (as defined by me). In ...
Akhilesh jj's user avatar
0 votes
0 answers
22 views

Which analysis to use? Analysing points' likeness across multiple fields including proximity. (AHP?)

I don't have much of a background in coding. I have a point layer with 400 points. The attribute table contains 3 fields of interest: Bearing (values between 0-180); a Ratio (ratio of ellipse long/...
GeoStudent's user avatar
6 votes
2 answers
321 views

Counting fire occurences per county per year using QGIS

I wish to loop through this shapefile, and for each "COUNTY_NM", count the number of values corresponding to each "layer" value. I want to output a CSV or equivalent which would be ...
Stuey17's user avatar
  • 199
1 vote
1 answer
831 views

Rename layers within group automatically by adding a prefix derived from group name using QGIS

I have some Sentinel derived rasters (time series) divided in tiles. In my QGIS (3.16) each tile is represented by a group. Each group contains rasters from different dates and according layernames. ...
jaysigg's user avatar
  • 507
0 votes
0 answers
92 views

Graphic grouping in QGIS Map Layout

In QGIS 3.18, I'm trying to draw symbols/graphic for Map Legend manually in the Map Layout. When grouping them, it shows the big box like the screenshot below and seems not convenient to continue ...
GISarath's user avatar
0 votes
1 answer
3k views

GeoPandas TypeError: geometries are not orderable (numpy: TypeError: '<' not supported between instances of 'Point' and 'Point')

I'm trying to group rows of a GeoDataFrame based on a common gid value and aggregating two columns for which the values differ but I am facing this error: TypeError ...
swiss_knight's user avatar
  • 10.5k
2 votes
1 answer
668 views

QGIS - creating a report from attribute table

I create a report from attribute table. At one column I have a name of a street, at second column I have a number. Relation between street and a number is one-to-many. Is there a function to show at ...
pazelvak's user avatar
  • 415
5 votes
3 answers
448 views

Generating unique code for features via grouping by several attributes

I have features with 3 columns of information ("material", "name", "dimension") in the Attribute table. I need these features to group - to create 4th column where ...
pazelvak's user avatar
  • 415
1 vote
1 answer
355 views

Dissolving polygons based on data values in GeoPandas

I have a long list of polygons in the GeoPandas GeoDataFrame (Sample below) Index zone_name value geometry 0 A 100 POLYGON ((77.47638480859382 13.05584728590942, 77....
Ani's user avatar
  • 125
0 votes
2 answers
908 views

Sampling points in R with both distance constraint and group

I have a spatial point data frame with categorical variable as a column named "type", I would like to draw a random sample from these points (let's say 100 points) with maximum and minimum ...
Es_a's user avatar
  • 160