[GRASS-user] Problem with v.rast.stats

[Nikos Alexandris]

António M. Rodrigues wrote:
> when using v.rast.stats to get stats for a raster over a polygon layer,

Could you please copy-paste the exact command you have used?

>  I get the following error:
> 
> -----
> DBMI-DBF driver error:
> Error while executing: 'ALTER TABLE caop09c2 ADD COLUMN  a2_per0-10 DOUBLE PRECISION
> '
> 
> Cannot continue (problem adding column).
> 
> SQL parser error: syntax error, unexpected '-' processing '-'
> in statement:
> ALTER TABLE caop09c2 ADD COLUMN  a2_per0-10 DOUBLE PRECISION
> Error in db_execute_immediate()
> Cannot continue (problem adding columns).
> -----

Antonio, maybe it's the "-" character (in the table's name) that gets on
the way. But as far as I remember, it should be ok to use it [1].

Nikos

> This only happens when I choose the extended statistics option. If not, it works fine. Actually, GRASS 
> adds all the new fields but does not calculate the quantiles.
> 
> An extra question: is it possible to get more quantiles than those calculated using the default (1st, 
> median and 3rd)?

---
[1] http://grass.osgeo.org/gdp/html_grass64/sql.html