Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
Geographic Information Systems

Questions tagged [sorting]

Ask Question

To arrange according to class, kind, or size; classify.

90 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
3
votes
1answer
49 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
71 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
45 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
63 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
12 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
23 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
63 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
20 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
49 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
173 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
49 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 ...
3
votes
2answers
465 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: > ...
5
votes
1answer
126 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
42 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
88 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
95 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
110 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
204 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
52 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
93 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
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
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
230 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
184 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
92 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
763 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
75 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
375 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
320 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
441 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
81 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
511 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
805 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
388 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
87 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
347 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
177 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
636 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 ...
1
vote
0answers
192 views

Passing an ICursor to ArcObjects ITableSort

I'm trying to pass a cursor (from a querydef with a prefixclause of DISTINCT) to itablesort.cursor. I've read another post on GIS SE on the same subject that warned against doing this. That post is 4 ...
0
votes
1answer
670 views

Assigning irregular points to a grid and assigning grid number as attribute

I have a large point data set that has irregular geometry (random sampling) that I want to bin in 2D XY space. I've attached a sketch below to illustrate what I mean. Apologies for hand drawing, hope ...
2
votes
0answers
73 views

Selecting rows of attributed relationship class (intermediate table) using relate table function [closed]

I have 2 classes: Owners Properties And 1 relation class (M-N) attributted In my ArcMAP (10.3.1) the intermediate table doesn't appear automatically (The table of relationed class appear). If I ...
11
votes
3answers
8k views

Calculating sequential numbers into sorted table using ArcGIS Desktop?

Is there a way to calculate a sorted field with sequential numbers? I have seen Sorting feature class to calculate sequential ID field using ArcGIS Field Calculator? that outlines how to calculate ...
1
vote
1answer
73 views

Difficulty in sorting selected features

My script is terribly underdeveloped, I am trying to select cities within a country and then order these cities by their "POP_RANK" = population rank. I am not sure whether to use a searchcursor or ...
12
votes
2answers
3k views

Is there a way to assign row number for sorted table by column in QGIS?

Field calculator has a great function under "Records" called "$rownum" which returns (assigns) the number of the current row. Is there a way to make it work together with sorting? Lets say I want to ...

1 2