[GRASS-user] Error using v.rast.stats: "begin transaction"

GRASS GRASS user
1

Hi,
I’m quite new in using Grass, so maybe this is not a very complicate error.

I’m trying to use v.rast.stats to calculate statistics on a vector poligon from a raster map, but I always receive this error:
v.rast.stats vector=samo_calc_v@samoggia raster=dem80@samoggia colprefix=elev
Updating the database …
DBMI-DBF driver error:
ERROR: Errore durante l’esecuzione: ‘BEGIN TRANSACTION’
The new columns were created but they’re empty and the table of attributes isn’t corrupted.

Following the suggestion of a member of the Osgeo Team, I tried to download this nc dataset
grass.osgeo.org/sampledata/north_carolina/nc_spm_latest.zip
and I tried to do this, just to remove all doubt:

(Tue Jul 08 10:04:05 2014)
g.copy vect=zipcodes_wake,myzipcodes_wake
Copy vector zipcodes_wake@PERMANENT to current mapset as <myzipcodes_wake>
(Tue Jul 08 10:04:06 2014) Comando terminato (0 sec)

(Tue Jul 08 10:04:51 2014)
g.region rast=elevation -p
projection: 99 (Lambert Conformal Conic)
zone: 0
datum: nad83
ellipsoid: a=6378137 es=0.006694380022900787
north: 228500
south: 215000
west: 630000
east: 645000
nsres: 10
ewres: 10
rows: 1350
cols: 1500
cells: 2025000
(Tue Jul 08 10:04:51 2014) Comando terminato (0 sec)

(Tue Jul 08 10:11:27 2014)
v.rast.stats -c myzipcodes_wake raster=elevation colprefix=elev

Updating the database …
DBMI-DBF driver error:
ERROR: Errore durante l’esecuzione: ‘BEGIN TRANSACTION’

(Tue Jul 08 10:11:36 2014) Comando terminato (9 sec)

The error remain.
I’m using Grass 6.4.4 on Windows 7, but if I make the same passages in an other pc (always Windows 7, Grass 6.4.4), it works without problems.

Has anybody a suggestion about why does it happen and what to do?

All suggestions all welcome! Thanks!

Best regards,
Francesca

··· 
-- 
Francesca Carisi
PhD Student
 
Università di Bologna
Dip. DICAM - Costruzioni Idrauliche
Viale Risorgimento, 2 - 40136 Bologna (ITALY)
Tel: +39 051 20 93371
Fax: +39 051 20 93140
E-mail: [francesca.carisi@unibo.it](mailto:francesca.carisi@unibo.it)
2

My guess is the DBF driver. Can you try to change your default DB driver to sqlite then try? You will have to: * change the default driver to sqlite with db.connect * copy the original vector (still with the DBF backend) to a new name to create a new vector with an sqlite based attribute table * then try v.rast.stats

···

On 08/07/2014 15:35, Francesca Carisi wrote:

Hi,
I’m quite new in using Grass, so maybe this is not a very complicate error.

I’m trying to use v.rast.stats to calculate statistics on a vector poligon from a raster map, but I always receive this error:
v.rast.stats vector=samo_calc_v@samoggia raster=dem80@samoggia colprefix=elev
Updating the database …
DBMI-DBF driver error:
ERROR: Errore durante l’esecuzione: ‘BEGIN TRANSACTION’
The new columns were created but they’re empty and the table of attributes isn’t corrupted.

Following the suggestion of a member of the Osgeo Team, I tried to download this nc dataset
grass.osgeo.org/sampledata/north_carolina/nc_spm_latest.zip
and I tried to do this, just to remove all doubt:

(Tue Jul 08 10:04:05 2014)
g.copy vect=zipcodes_wake,myzipcodes_wake
Copy vector zipcodes_wake@PERMANENT to current mapset as <myzipcodes_wake>
(Tue Jul 08 10:04:06 2014) Comando terminato (0 sec)

(Tue Jul 08 10:04:51 2014)
g.region rast=elevation -p
projection: 99 (Lambert Conformal Conic)
zone: 0
datum: nad83
ellipsoid: a=6378137 es=0.006694380022900787
north: 228500
south: 215000
west: 630000
east: 645000
nsres: 10
ewres: 10
rows: 1350
cols: 1500
cells: 2025000
(Tue Jul 08 10:04:51 2014) Comando terminato (0 sec)

(Tue Jul 08 10:11:27 2014)
v.rast.stats -c myzipcodes_wake raster=elevation colprefix=elev

Updating the database …
DBMI-DBF driver error:
ERROR: Errore durante l’esecuzione: ‘BEGIN TRANSACTION’

(Tue Jul 08 10:11:36 2014) Comando terminato (9 sec)

The error remain.
I’m using Grass 6.4.4 on Windows 7, but if I make the same passages in an other pc (always Windows 7, Grass 6.4.4), it works without problems.

Has anybody a suggestion about why does it happen and what to do?

All suggestions all welcome! Thanks!

Best regards,
Francesca
This mail was received via Mail-SeCure System.

-- 
Micha Silver
GIS Consulting
052-3665918
[http://www.surfaces.co.il](http://www.surfaces.co.il)


-- 
Francesca Carisi
PhD Student
 
Università di Bologna
Dip. DICAM - Costruzioni Idrauliche
Viale Risorgimento, 2 - 40136 Bologna (ITALY)
Tel: +39 051 20 93371
Fax: +39 051 20 93140
E-mail: [francesca.carisi@unibo.it](mailto:francesca.carisi@unibo.it)

_______________________________________________
grass-user mailing list
[grass-user@lists.osgeo.org](mailto:grass-user@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/grass-user](http://lists.osgeo.org/mailman/listinfo/grass-user)
This mail was received via Mail-SeCure System.
3

On Tue, Jul 8, 2014 at 3:03 PM, Micha Silver <micha@arava.co.il> wrote:
...

My guess is the DBF driver. Can you try to change your default DB driver to
sqlite then try?
You will have to:
* change the default driver to sqlite with db.connect
* copy the original vector (still with the DBF backend) to a new name to
create a new vector with an sqlite based attribute table
* then try v.rast.stats

BTW:
If that works well (likely), you can change all vector maps in a
mapset to use the SQLite backend easily in an automated way:

http://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7

Markus