3

Is there a quick way to sort an attribute table in QGIS in ascending order permanently and save it? When you make a map with proportional circles in QGIS the circles overlaps between each other according to their sorting order. I want the smaller circle above the bigger which is why I think sorting can solve this issue.

Note: If I click on the header, the table will be sorted in ascending order using the clicked column. However, if I save it that way and I open it again nothing has changed about row order.

ePoQ
  • 611
  • 5
  • 16
  • @ChrisW, the post you reference relates to ArcGIS – Aaron May 21 '15 at 17:38
  • @Aaron Note while that question body says ArcMap, there is a QGIS solution or two there. There is also http://gis.stackexchange.com/questions/135892/ which is more specific to ArcGIS but gives some general information on why doing this doesn't necessarily make sense. – Chris W May 21 '15 at 17:39
  • 1
    I think that make sense in my case. When you make a map with proportional circles in QGIS the circles overlaps between each other according to their sorting order. I want the smaller circle above the bigger that's why I need to sort it permanently – ePoQ May 21 '15 at 17:42
  • As Vince's answer at the ArcGIS specific question I linked to points out, there is no guarantee that the drawing order will relate to the record order. It is typically last drawn/higher record number on top, and you will probably get what you want by doing the sort (it is a common workaround/solution), just be aware it isn't a guarantee. The MMQGIS plugin underdark mentions or the GDAL solution Mike T presents in the duplicate link should do what you want. @Aaron Maybe migrate the two non-Arc answers from that other question here? Or is it too late to do that? – Chris W May 21 '15 at 18:02
  • I just tried it out. That's working. Smaller circles are above the biggers. – ePoQ May 21 '15 at 18:08
  • @ChrisW Migrating answers from other posts is not an an available action on GIS SE. – Aaron May 21 '15 at 18:21
  • @Aaron Ah, I must be thinking of when questions are merged (which wouldn't be applicable here). A quick search on Meta turned up nothing as well, though the issue has been raised. Thanks for checking. – Chris W May 21 '15 at 18:35
  • 1
    Since the other thread already contained different solutions, I now made the question text more generic in order to have one central thread (covering different platforms) for this issue. – underdark May 22 '15 at 09:38

1 Answers1

4

Finally, that is a very easy treatment with the MMQGIS plugin (Quantum GIS Plugin Repository). It allows to rewrite on another table using selected column and chosen order.

enter image description here

It also works for the circles problem

enter image description here

ePoQ
  • 611
  • 5
  • 16