Hi all,
I’m new to GIS and also new to GRASS GIS. I want to zonal statistics from raster map rainfall interpolation(idw) on basin vector polygon. I used v.rast.stats. But there are problems
v.rast.stats -c vector=basin_250@PERMANENT raster=rainfall_idw@PERMANENT colprefix=z
Updating the database …
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing
‘BEGIN’
in statement:
BEGIN TRANSACTION
Error in db_execute_immediate()
ERROR: Error while executing: ‘BEGIN TRANSACTION’
Thank you.
–
Chingchai Humhong
Regional Center of Geo-Informatics and
Space Technology, Lower Northern Region
Naresuan University, Phitsanulok, Thailand. 65000
Lat:16.742496, Lon:100.191605
On Wed, Oct 15, 2014 at 6:16 PM, chingchai humhong
<chingchai.h@gmail.com> wrote:
Hi all,
I'm new to GIS and also new to GRASS GIS.
Welcome here!
I want to zonal statistics from
raster map rainfall interpolation(idw) on basin vector polygon. I used
v.rast.stats. But there are problems
v.rast.stats -c vector=basin_250@PERMANENT raster=rainfall_idw@PERMANENT
colprefix=z
Updating the database ...
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing
'BEGIN'
in statement:
BEGIN TRANSACTION
Error in db_execute_immediate()
ERROR: Error while executing: 'BEGIN TRANSACTION'
Thank you.
ok, the issue is that the DBF driver does not support SQL
transactions. I thought that this would be automatically handled.
I just tried on my system with the DBF driver and did not came across
this issue.
Which GRASS GIS version do you use on which operating system?
I want to zonal statistics from
raster map rainfall interpolation(idw) on basin vector polygon. I used
v.rast.stats. But there are problems
v.rast.stats -c vector=basin_250@PERMANENT raster=rainfall_idw@PERMANENT
colprefix=z
Updating the database …
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing
‘BEGIN’
in statement:
BEGIN TRANSACTION
Error in db_execute_immediate()
ERROR: Error while executing: ‘BEGIN TRANSACTION’
Thank you.
ok, the issue is that the DBF driver does not support SQL
transactions. I thought that this would be automatically handled.
I just tried on my system with the DBF driver and did not came across
this issue.
Which GRASS GIS version do you use on which operating system?
Markus
–
Chingchai Humhong
Regional Center of Geo-Informatics and
Space Technology, Lower Northern Region
Naresuan University Phitsanulok 65000
Lat:16.742496, Lon:100.191605
Dear Markus.
Many thanks for your reply.
I am master student in Thailand,
recently, I learning open source software and using OSGeolive 8. So, in OSGeolive 8 it had GRASS GIS version 6.4.4 on Ubuntu.
Hi Markus.
Thanks for your reply.
I used GRASS GIS version 6.4.4 on Ubuntu.
Chingchai
–
Chingchai Humhong
Regional Center of Geo-Informatics and
Space Technology, Lower Northern Region
Naresuan University Phitsanulok 65000
Lat:16.742496, Lon:100.191605
I want to zonal statistics from
raster map rainfall interpolation(idw) on basin vector polygon. I used
v.rast.stats. But there are problems
v.rast.stats -c vector=basin_250@PERMANENT raster=rainfall_idw@PERMANENT
colprefix=z
Updating the database …
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing
‘BEGIN’
in statement:
BEGIN TRANSACTION
Error in db_execute_immediate()
ERROR: Error while executing: ‘BEGIN TRANSACTION’
Thank you.
ok, the issue is that the DBF driver does not support SQL
transactions. I thought that this would be automatically handled.
I just tried on my system with the DBF driver and did not came across
this issue.
Which GRASS GIS version do you use on which operating system?
Markus
–
Chingchai Humhong
Regional Center of Geo-Informatics and
Space Technology, Lower Northern Region
Naresuan University Phitsanulok 65000
Lat:16.742496, Lon:100.191605
Comment: Instead of trying to add SQL TRANSACTIONS to the DBF driver,
I have now simply conditionalized it in r63789. This fixed script will
ship with the future GRASS GIS 6.4.5.
Markus
On Wed, Oct 22, 2014 at 12:08 PM, Markus Neteler <neteler@osgeo.org> wrote:
On Sun, Oct 19, 2014 at 11:54 PM, Markus Neteler <neteler@osgeo.org> wrote:
On Wed, Oct 15, 2014 at 6:16 PM, chingchai humhong
<chingchai.h@gmail.com> wrote:
Hi all,
I'm new to GIS and also new to GRASS GIS.
Welcome here!
I want to zonal statistics from
raster map rainfall interpolation(idw) on basin vector polygon. I used
v.rast.stats. But there are problems
v.rast.stats -c vector=basin_250@PERMANENT raster=rainfall_idw@PERMANENT
colprefix=z
Updating the database ...
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing
'BEGIN'
in statement:
BEGIN TRANSACTION
Error in db_execute_immediate()
ERROR: Error while executing: 'BEGIN TRANSACTION'
Thank you.
ok, the issue is that the DBF driver does not support SQL
transactions. I thought that this would be automatically handled.
Comment: Instead of trying to add SQL TRANSACTIONS to the DBF driver,
I have now simply conditionalized it in r63789. This fixed script will
ship with the future GRASS GIS 6.4.5.
Markus
On Wed, Oct 22, 2014 at 12:08 PM, Markus Neteler <neteler@osgeo.org> wrote:
On Sun, Oct 19, 2014 at 11:54 PM, Markus Neteler <neteler@osgeo.org> wrote:
Chingchai Humhong
Regional Center of Geo-Informatics and
Space Technology, Lower Northern Region
Naresuan University Phitsanulok 65000
Lat:16.742496, Lon:100.191605