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@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 this would be a useful tool.
Steve
Please report both as new issues in trac to not loose them:
https://trac.osgeo.org/grass
Māris.
2017-05-27 6:33 GMT+03:00 Steven Pawley <dr.stevenpawley@gmail.com>:
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@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 this would be a useful tool.
Steve
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-dev