[GRASS-dev] [GRASS GIS] #3352: Behavior of v.sort.points

[GRASS GIS]

#3352: Behavior of v.sort.points
---------------------+-------------------------
 Reporter:  spawley  |      Owner:  grass-dev@…
     Type:  defect   |     Status:  new
 Priority:  normal   |  Milestone:  7.4.0
Component:  Addons   |    Version:  unspecified
 Keywords:           |        CPU:  Unspecified
 Platform:  Linux    |
---------------------+-------------------------
 Hello devs,

 I appear to be having some problems with the add on v.sort.points. Two
 issues, potentially bugs:

 (1) the module fails if the 'cat' column is not the first attribute in the
 table (i.e. if points have been generated from a database table),
 returning the error:

 'Error in sqlite3_prepare(): duplicate column name: cat'

 (2) even if 'cat' is the first column, sorting by an integer column does
 not appear to be sorting point datasets in numeric order. Example from the
 nc_spm location:

 v.sort.points input=firestations at PERMANENT output=firestations_sorted
 column=ID

 The order of the points based on opening the attribute table, and the
 relationship between the 'ID' column and 'cat' appears to be the same as
 the original dataset, where 'ID' was not in ascending order.

 Either I'm doing something wrong or the add on requires some tweaks.
 Otherwise his would be a very useful tool.

 Steve

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3352>
GRASS GIS <https://grass.osgeo.org>