Questions tagged [sorting]
To arrange according to class, kind, or size; classify.
171 questions
6
votes
2
answers
313
views
Directly sorting table field in descending order in QGIS
At QGIS 3.40.8, I am working with large tables (1+ million records) that often need to be sorted in some descending order.
It is simple to sort an attribute table in ascending order by left-clicking ...
- 7,906
4
votes
1
answer
235
views
Sorting layers alphabetically in geospatial PDF
Premise
We're exporting a lot of georeferenced PDF-maps which include layers. There's a scheme to the naming of the layers (e.g. everything being related to aviation safety has the prefix AR_ for ...
- 18.4k
3
votes
1
answer
122
views
Changing the order of attributes in one field in QGIS 3
I have added a field attribute to my layout and would like to sort it based on numerical order.
- 719
2
votes
1
answer
83
views
Sorting Recently Used Coordinate Reference Systems list in QGIS
I want to sort alphabetically all CRSs in the Recently Used Coordinate Reference Systems list in QGIS. But I can't find a way to do this using the user interface.
How one can sort them using PyQGIS?
- 8,548
4
votes
1
answer
260
views
Sorting rows in ascending order by multiple fields in QGIS
Fields:
year field is 2020,2021,2022(integer)
month field is 1~12(integer)
day field is 1~31 (integer)
time field is 0~23(integer)
I've used:
"year" || lpad("month", 3, 0) || lpad(...
- 43
0
votes
1
answer
129
views
GeoServer SLD style : ordering draw from custom attribute
I want to control the order in which the features are being loaded and drawn on the map with the GeoServer vendor parameter sortBy.
I created a layer from an external WFS i'm not owner. So i'can't ...
- 1,138
4
votes
1
answer
146
views
Sorting Classification by another field
I am currently using the QGIS software. I use rule-based classification to extract the monetary values from a field and display them as symbols. For map legend purposes I need to concatenate the ...
- 41
2
votes
1
answer
212
views
Aggregating points into polylines, sorted by timestamp using GeoPandas/Python
I have a geodataframe that contains positions (point geometries). For each position, we know the individual's id (id_individ), DOY (doy), year (année) and timestamp.
I want to aggregate the ...
- 83
5
votes
2
answers
634
views
Saving and applying layout of columns in QGIS Attribute Table
I have multiple projects with similar layers.
Here is an example, with all attributes (fields) visible in default order.
I do use this layout for certain tasks. But for other tasks, I wish to hide ...
- 1,989
1
vote
1
answer
603
views
How to change vertex order to a polyline in QGIS?
I'm trying to change the vertex order of a polyline in QGIS.
I have an existing polyline that's closed (last vertex = first vertex).
The starting point of this polyline is in a totally casual position....
- 13
0
votes
1
answer
36
views
Band calculations and sorting within a specified geometry
I am working on a small geographic area (< 50 km sq.) and am trying to find the 5-10 least cloudy Landsat images for my specified area. The issue I have is that if I simply use:
imageCollection....
2
votes
1
answer
552
views
GEE: How to sort ImageCollection correctly by system:index
I am very new to GEE and I have the following Problem:
I have to create NDVI time series (with MODIS Vegetation indices) and compare the monthly mean value between 2001 and 2021 with the monthly mean ...
- 45
0
votes
1
answer
597
views
How to order attributes by suffix in FME?
I have a table with attributes containing a suffix of the form _DIGIT. FME displays the table like this:
country
name_0
name_1
name_2
platforms_0
platforms_1
platforms_2
The Netherlands
Utrecht ...
- 903
5
votes
3
answers
1k
views
Permanently sorting table so that field of interest is sorted in the same order as the fid in QGIS
Using 3.22.13, consider a non-spatial GeoPackage attribute table containing one text field, named "field_a". This table has the following form:
fid field_a
1 B
2 A
3 X
4 C
How can I sort ...
- 7,906
2
votes
1
answer
848
views
Sorting rows based on calculated values on PostgreSQL's ST_DWithin
I have a question on how to improve sorting performance on PostgreSQL on geospatial data. I want to sort restaurants based on their distance and price, but it's noticeably slower than my study on ...
