[GRASS-user] v.reclass and sqlite

GRASS GRASS user
1

Looking at v.dissolve ( which uses v.reclass ) I see that it fails when the vector has an sqlite based attribute table:

GRASS 6.4.2 (WGS84):~ > v.db.connect -p test_pg2
Vector map test_pg2@burkina is connected by:
layer <1> table <test_pg2> in database </home/micha/geodata/grass/WGS84/burkina/sqlite.db> through driver with key
GRASS 6.4.2 (WGS84):~ > v.info -c test_pg2
Displaying column types/names for database connection of layer 1:
INTEGER>cat
CHARACTER>label
INTEGER>id
GRASS 6.4.2 (WGS84):~ > v.reclass test_pg2 out=test_pg2_rcl col=label
WARNING: Vector map <test_pg2_rcl> already exists and will be overwritten
DBMI-SQLite driver error:
Cannot step:
SQL logic error or missing database

ERROR: Unable to fetch data from table <test_pg2>
GRASS 6.4.2 (WGS84):~ >

This, of course causes v.dissolve to fail. Is this an sqlite limitation?

(WHen I copied the same vector to a new one with dbf based attrib table, v.reclass worked fine)

Thanks,

Micha

ยทยทยท 
-- 
Micha Silver
GIS Consultant, Arava Development Co.
[http://www.surfaces.co.il](http://www.surfaces.co.il)
2

On Sun, May 27, 2012 at 5:01 PM, Micha Silver <micha@arava.co.il> wrote:

Looking at v.dissolve ( which uses v.reclass ) I see that it fails when the
vector has an sqlite based attribute table:

This sqlite issue should already be fixed in GRASS 7, and v.dissolve
waits for testing before the fix can be backported to GRASS 6.x.
Please test!

Markus M

GRASS 6.4.2 (WGS84):~ > v.db.connect -p test_pg2
Vector map <test_pg2@burkina> is connected by:
layer <1> table <test_pg2> in database
</home/micha/geodata/grass/WGS84/burkina/sqlite.db> through driver <sqlite>
with key <cat>
GRASS 6.4.2 (WGS84):~ > v.info -c test_pg2
Displaying column types/names for database connection of layer 1:
INTEGER|cat
CHARACTER|label
INTEGER|id
GRASS 6.4.2 (WGS84):~ > v.reclass test_pg2 out=test_pg2_rcl col=label
WARNING: Vector map <test_pg2_rcl> already exists and will be overwritten
DBMI-SQLite driver error:
Cannot step:
SQL logic error or missing database

ERROR: Unable to fetch data from table <test_pg2>
GRASS 6.4.2 (WGS84):~ >

This, of course causes v.dissolve to fail. Is this an sqlite limitation?

(WHen I copied the same vector to a new one with dbf based attrib table,
v.reclass worked fine)

Thanks,

Micha

--
Micha Silver
GIS Consultant, Arava Development Co.
http://www.surfaces.co.il

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user