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?


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
 
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: [email protected]


This mail was received via Mail-SeCure System.


_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
This mail was received via Mail-SeCure System.




-- 
Micha Silver
GIS Consulting
052-3665918
http://www.surfaces.co.il
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to