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

GRASS GRASS user
1

Hi,

when using v.rast.stats to get stats for a raster over a polygon layer, 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).
-----

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)?

Thanks,
António

2

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

3

Please ignore this question...

On Apr 5, 2010, at 9:34 PM, António M. Rodrigues wrote:

Hi,

when using v.rast.stats to get stats for a raster over a polygon layer, 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).
-----

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)?

Thanks,
António
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user