<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 08/07/2014 15:35, Francesca Carisi
wrote:<br>
</div>
<blockquote cite="mid:53BBE580.9050802@unibo.it" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1255">
Hi,<br>
I'm quite new in using Grass, so maybe this is not a very
complicate error.<br>
<br>
I'm trying to use <b>v.rast.stats</b> to calculate statistics on
a vector poligon from a raster map, but I always receive this
error:<br>
<font color="#3333ff">v.rast.stats vector=samo_calc_v@samoggia
raster=dem80@samoggia colprefix=elev <br>
Updating the database ...<br>
DBMI-DBF driver error:<br>
ERROR: Errore durante l'esecuzione: 'BEGIN TRANSACTION'</font><br>
The new columns were created but they're empty and the table of
attributes isn't corrupted.<br>
<br>
Following the suggestion of a member of the Osgeo Team, I tried to
download this nc dataset<br>
<a moz-do-not-send="true"
href="http://grass.osgeo.org/sampledata/north_carolina/nc_spm_latest.zip">grass.osgeo.org/sampledata/north_carolina/nc_spm_latest.zip</a><br>
and I tried to do this, just to remove all doubt:<br>
<br>
<font color="#3333ff">(Tue Jul 08 10:04:05
2014) <br>
g.copy
vect=zipcodes_wake,myzipcodes_wake
<br>
Copy vector <zipcodes_wake@PERMANENT> to current mapset as
<myzipcodes_wake><br>
(Tue Jul 08 10:04:06 2014) Comando terminato (0 sec) <br>
<br>
(Tue Jul 08 10:04:51
2014) <br>
g.region rast=elevation
-p <br>
projection: 99 (Lambert Conformal Conic)<br>
zone: 0<br>
datum: nad83<br>
ellipsoid: a=6378137 es=0.006694380022900787<br>
north: 228500<br>
south: 215000<br>
west: 630000<br>
east: 645000<br>
nsres: 10<br>
ewres: 10<br>
rows: 1350<br>
cols: 1500<br>
cells: 2025000<br>
(Tue Jul 08 10:04:51 2014) Comando terminato (0
sec) <br>
<br>
(Tue Jul 08 10:11:27
2014) <br>
v.rast.stats -c myzipcodes_wake raster=elevation
colprefix=elev <br>
</font>
<div class=""><font color="#3333ff"> Updating the database ...<br>
DBMI-DBF driver error:<br>
ERROR: Errore durante l'esecuzione: 'BEGIN TRANSACTION'<br>
</font></div>
<font color="#3333ff"> (Tue Jul 08 10:11:36 2014) Comando
terminato (9 sec)</font><br>
<br>
The error remain.<br>
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.<br>
<br>
Has anybody a suggestion about why does it happen and what to do?<br>
<br>
</blockquote>
<br>
My guess is the DBF driver. Can you try to change your default DB
driver to sqlite then try?<br>
You will have to:<br>
* change the default driver to sqlite with db.connect<br>
* copy the original vector (still with the DBF backend) to a new
name to create a new vector with an sqlite based attribute table<br>
* then try v.rast.stats<br>
<br>
<blockquote cite="mid:53BBE580.9050802@unibo.it" type="cite">
<div>All suggestions all welcome! Thanks!</div>
<div><br>
</div>
<div>Best regards,</div>
Francesca<br>
<pre class="moz-signature" cols="72">--
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: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:francesca.carisi@unibo.it">francesca.carisi@unibo.it</a></pre>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consulting
052-3665918
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a>
</pre>
</body>
</html>