Questions tagged [sorting]
To arrange according to class, kind, or size; classify.
96
questions
1
vote
0answers
24 views
More stable spatial sort using Shapely's within?
I was trying to use a modified version of the spatial sorting method illustrated in shapely's documentation, using only polygons exteriors (so that I can detect if a polygon lies inside another ...
2
votes
1answer
37 views
Sorting polygons into a n x n spatial array
I have a square group of contiguous polygons:
By using the centroid coordinates of each polygon, I want to assign each polygon's spatial sequence in a row by row fashion:
I have tried this ...
2
votes
2answers
71 views
Sorting a table based on if-then statement
I have a large table with two attribute fields "layers" and "Meas" both contain numbers, I would like to sort "Meas" in the odd numbered "layers" in ascending order, and "Meas" in the even numbered "...
0
votes
0answers
20 views
Selecting lowest values in from attribute table in ModelBuilder? [duplicate]
I am trying to select the lowest value from an attribute table within model builder. I have used the Sort tool to sort the values in ascending order but when I add the Select tool and go to enter an ...
1
vote
1answer
39 views
Ordering FeatureGroups
I'm using Leaflet right now and I have issues on ordering a list of FeatureGroups.
Each feature group is either an imageOverlay or a list of Features
I tried using bringToFront / bringToBack and it's ...
3
votes
1answer
93 views
Automatically numbering points East-West & North-south on QGIS?
I have a dataset over with points every 100m over several km.
I want to number points so that they follow an 's' shaped path.
For example:
1 2 3 4 5
10 9 8 7 6
11 12 13 14 15
20 19 18 ...
3
votes
1answer
57 views
Sequentially number attribute field as the table is currently ordered in QGIS?
At QGIS 3.8.2, I need to populate a field (let's call it field_a) in a sequentially increasing (1, 2, 3,...) order. However, I need the sequence to increase in the order that the table is currently ...
2
votes
1answer
80 views
Labeling features in given order in QGIS?
I want to sort the address numbers where would show only the bigger number and smaller value should be suppressed away.
I have used earlier ORDER BY-method when using PostGIS but now it isn't ...
0
votes
0answers
64 views
Sorting Identify feature results by DATE field in ArcMap?
I'm using ArcMap 10.3. When I use the Identify tool, I often have many results and would like to sort those results in the Identify window. If I right-click on the layer name or features in Identify ...
2
votes
1answer
65 views
Sorting join layer based on attribute column?
Im joining dots with a CSV file and map my data with proportional circles. Unfortunately I have some overlapping.
How do I sort a join layer based on attribute column called aPOPCLA72 ?
Filtering ...
0
votes
0answers
14 views
Lizmap Relations Sort
I am using Lizmap Atlas function on a layer with clusters.
A 1-M relationships allows me to link a certain number of sites through this cluster in the atlas.
I am wondering if I can sorter the order ...
0
votes
1answer
25 views
How to use insert extension for more than one value
I am trying to insert 2 values into the 'extensionsofArcGIS' variable as you can see below, just not sure how to insert more than one at a time? I have tried a few different variations but still no ...
0
votes
1answer
70 views
Using Editor tab Clip function in ArcPy?
I am using ArcGIS Desktop 10.6, basic license, Spatial Analyst, python 2.6, 2019 AD.
I have a polygon feature class with representing a lake, with multiple features overlapping (all in the same ...
0
votes
1answer
25 views
ArcGIS Pro Sort based on more then one field?
I want to sort attribute table based on more then one column.
Is there a way to do that?
1
vote
1answer
54 views
Attribute Table Sort Disordered in QGIS?
I am using QGIS. I opened my attribute table in Open Office Calc and sorted the table by a column. I believe I had all the columns selected when I sorted. Now when viewing the layer, everything is ...
2
votes
0answers
23 views
Filter pictures in directory
I have a drone project with 50,000 pictures in 50 layers.
Each layer has 2 to 5 zones.
When I put them all together, we have a lot of overlap and in some places, we have up to 4 pictures of the same ...
2
votes
1answer
208 views
QGIS 3.4.4 sorts numerical values as text, solution?
I'm trying to sort my numerical values in my attribute table but instead of getting 1, 2, 3 I get 1, 10, 100, 100 etc. When searching for a solution here on Stack Exchange, many people with earlier ...
2
votes
0answers
52 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 ...
1
vote
2answers
56 views
Sort by multiple fields and delete record with highest value
I have some GPS points that I am trying to find the highest precision point for. How would I go about sorting the table by time collected and horizontal precision and then deleting the highest ...
4
votes
2answers
607 views
Sort data in an ascending order based on the geometry of an sf object in R (Sort by Lat/Long)
I am trying to sort my data based on the latitude and longitude. I have an sf object in R, which essentially stores the latitude and longitude as a separate column called geometry.
See below:
> ...
6
votes
1answer
161 views
Sorting layers in specific group layer with ArcPy?
I have to programmatically sort several layers in an .mxd project that are each placed in the same group layer. I have found a script that partially works by sorting all layers in the TOC (Arc GIS 10....
1
vote
1answer
43 views
Sorting by shape token in ArcPy cursors?
I have a script that uses the sql orderby parameter to sort my arcpy cursors by a user defined field or fields and deletes duplicates, but keeps the duplicate with the highest value. I'd like to be ...
3
votes
0answers
125 views
QGIS Python: sort by attributes <= 0
In QGIS 2.18 I'm try to sort features by an integer attribute with a Python script. The problem is, that some of the values of the sorting attribue are <= 0 (for sure they have to be <=0) and ...
2
votes
1answer
125 views
PyQGIS - get spatial/positional order of featurelist
I would like to know if it is possible to sort a list of line features in the exact order in which they appear on the canvas, given the starting feature. In this case the list of linefeatures ...
1
vote
1answer
120 views
Sorting numbers into categories in QGIS?
I need to sort a column of population figures into categories in a new column so that I can split them out and create layers for each one. Something like 0-99, 100-249, 250-500 etc.
Struggling to ...
0
votes
1answer
234 views
Why does using next() with an update cursor nested inside a Search cursor yield such weird results
I did this:
with arcpy.da.SearchCursor(
in_table = in_table, field_names = '*', where_clause = "",
sql_clause = (None, "ORDER BY date"))\
as ordered_cursor:
with ...
1
vote
1answer
53 views
Sorting based on computed property (NDWI)
I am trying to sort a series of sentinel 2 images based on their average NDWI in the google earth engine. But nothing I do in sorting seems to work. Here I ll show what i tried:
's2_ndwi_mean' is a ...
2
votes
1answer
99 views
Sort PDF Files based on last 7 Characters [closed]
I have a Python script that creates PDF Map Books from pre-existing map PDFs, created in ArcGIS Pro. The PDF file names end with the month abbreviation and year they are associated with (example: ...
1
vote
1answer
646 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
1k views
Sorting strings separated by commas within field using Python Parser of ArcGIS Field Calculator?
In ArcGIS 10.4.1, I am using the Python Parser of the Field Calculator. My Python knowledge is limited.
I would like to recalculate a field of strings that are separated by commas so that they are ...
1
vote
0answers
249 views
Advanced Sorting in QGIS
Can someone explain how to do advanced sorting of an attribute table using QGIS?. Every time I try to sort by script, it does not give me what I need and I don't know if there is any plugin that can ...
4
votes
1answer
44 views
Reconciling Differences Between Python List Sort and ArcMap Table Sort
I have a feature class being used in Data Driven Pages, which sorts as follows:
APPLE LARRY
JOHNSON SHIRLEY
KENT-STATE-GOODS LLC
KENT TIMOTHY
KENT VANESSA
KENT WAYNE
SMITH JEEVES
I also have the ...
1
vote
0answers
195 views
Easily convert multiple attribute columns from text to integer?
I uploaded a CSV with WKT polygon coordinates. Each polygon was displayed spatially and I re-saved the file as a shapefile.
The problem is most attribute columns are being detected as text, and they ...
1
vote
1answer
105 views
Establishing attribute order in table using ArcPy with ArcGIS Pro?
I have the following piece of code hoping to have a table with a set of fields on a specific order:
#Removing the fields we do NOT want to show in the output
arcpy.MakeFeatureLayer_management(...
1
vote
1answer
875 views
How to SortBy a GetFeature WFS request by FeatureId (fid) in XML?
This is my XML for a GetFeature request. I want to Sort By FeatureId (fid) but this doesn't work. I can't find an example of how to format this XML correctly:
(SEE THE ogc:SortBy SECTION)
<?xml ...
3
votes
1answer
85 views
Ordering of bands in ArcCatalog
I have a multi-band GeoTIFF with >10 bands, for example 11. I would have expected these to be shown in an ordered numerical sequence from 1 to 11. However, ArcCatalog 10.3.1 wants to show the string ...
3
votes
3answers
1k views
Sorting line features into route order in attribute table using QGIS?
I have a several line features stored as shapefiles, obviously constructed of several connecting segment.
I wish to export the attribute tables of each feature as a CSV to use in a separate ...
1
vote
1answer
436 views
Special sorting of symbols in a layer
I have this feature class
I would like it to be :
First
Second
Third
Fourth
Unsuitable
Water
No data
The only was I know how to sort it in the Symbology tab is alphabetically. I know I can ...
0
votes
1answer
364 views
Determining spatial sort order with ArcPy? [closed]
How do I determine if a varying hypothetical set of lines (example in image) needs to be sorted by X (longitude) rather than Y (latitude) programmatically to ensure they are ordered from 1 to 14 as ...
4
votes
1answer
491 views
How to sort the order of track points?
I have a shapefile, which contains track points of a gpx file. Every track point has a number in its "number" field that tells the numeric name of the track the point belongs to. So points are ...
1
vote
0answers
89 views
Sort a Raster attribute field in ArcGIS
I need to combine several rasters. One of them has an alphanumeric data in the attribute I need to combine. However, when combined the output raster has a 'LONG' attribute type where should be 'STRING'...
2
votes
1answer
586 views
QGIS sorting as 1, 10, 100 not 1, 2, 3
I suspect I'm missing something basic but when ever I sort a table with an integer field it ends up sorting 1, 10, 100, not 1, 2, 3.
5
votes
1answer
877 views
How to sort field by ascending numerical order in QGIS 2.14?
I work with this field (in categorized style):
I try to find how can I sort the "value" column (in the style properties) by ascending numerical order. In the attribute table "value" is "YEUD" field:
...
1
vote
1answer
407 views
Sorting polygon elements with arcpy.SearchCursor
I'm wondering if there's a way to sort my records on the fly using a searchCursor. I know you can't sort using the data access (da) module but can with the legacy function.
Without adding a record ...
3
votes
1answer
94 views
Ordering polygon centroid points in a row(s)
I have a image from a field, where I converted the plants to polygons, and then I found the centroid of those polygons (attached image). The numbers displaying on the image are the FID numbers.
I am ...
3
votes
2answers
384 views
Restoring attribute table order to original in QGIS?
I've sorted my attribute table by clicking on one of the column headers. Now I'd like to undo the sort and go back to the original table order. Each row has a reference number down the left edge but ...
2
votes
1answer
185 views
Sorting string column in QGIS Print Composer?
Previously asked a the same generic question (Sorting string column Qgis), but would need to know a solution in Print Composer.
A added an atribute table in my print composer, and I need to sort the ...
1
vote
1answer
676 views
Sorting tables alphabetically in Mapinfo Professional 10
I have appended one table to another, and now they are not sorted alphabetically. Is there any way to resort the table so that it is in alphabetical order?
0
votes
2answers
48 views
Showing lowest value first after one-to-one spatial join with delimiter?
After a spatial join (one-to-one) in ArcGIS my result looks like this: (I use a / as delimiter)
2015/2015/2014/2014/2013
After that i use python in calculate field to filter out duplicate values ...
5
votes
1answer
1k views
Why are numeric values in attribute table not sorted correctly?
I have a problem with the new QGIS version (2.16.0 or 2.16.1 Nodebo). I want to sort numeric values in the attribute table by clicking on the field name. But in contrast to older QGIs versions the ...
