Questions tagged [sorting]
To arrange according to class, kind, or size; classify.
0
votes
1answer
16 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
30 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
22 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
104 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
47 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
40 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
174 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
84 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
38 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
48 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
49 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 ...
0
votes
0answers
12 views
Map Automation: Auto Sort Legend Items by Quanity
Using ArcMap 10.6.1, I have a python script to automate the production of 10 maps, each representing a State. For each state, I have 4 point layers. The number of points in each layer differs by state....
1
vote
1answer
61 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
0answers
34 views
Using map within a map - error produced using sort()
Objective
I am trying to establish the state of the tide when a Landsat 8 image was collected, allowing further analysis such as using only images from when there are high tides for example.
I am ...
0
votes
1answer
134 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
46 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
88 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
423 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
894 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
193 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
42 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
159 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
77 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
583 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 ...
4
votes
1answer
67 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
792 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
229 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
239 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
339 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
71 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
398 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
648 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
343 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
84 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 ...
4
votes
2answers
304 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
159 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
538 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
43 views
Lowest value first after an 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 in ...
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
156 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
609 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
67 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
6k 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
67 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 ...
11
votes
2answers
2k 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 ...
0
votes
1answer
112 views
I cannot continue with sorted files in ModelBuilder in ArcGIS
When I use the tool "Sort" within modelbuilder I can not access the resulting file from other tools within modelbuilder in order to continue with the model. If I, for example, sort the file PR into ...
1
vote
1answer
99 views
QGIS 2.8.2 Print Composer Attribute Sorting
I need to sort an attribute table added to the Print composer layout with Alphanumeric characters.
I understand this is not desirable but the field is for naming farm paddocks...hard to avoid that. ...
3
votes
1answer
775 views
How to sort layers within groups with Python?
After running a longer script (Qgis Console), all I want to do is sort the layers within my groups;
since some of them are buffers and the 'biggest' buffer is now on top.
I've tried stuff based on: ...
0
votes
2answers
284 views
Remove certain points from point shapefile
I have a point shapefile with 9674 points. The attribute column has three fields: X, Y and value. Out of these 9674 points, I want to remove 1700 points based on X and Y values (I know the X and Y of ...
3
votes
1answer
344 views
Sort Excel table sheets with FME
I have 4 feature types and writing to a single xls file using FME. Each feature type has its own worksheet.
How can I sort the worksheets with FME before creating the xls-file?
I use FME 2012 SP3
