On 19/12/2010 14:44, [email protected] wrote:
Dear GRASS,
I am using the December 19 (2010) build of GRASS 6.4 for Windows. I
have loaded a vector map (for a country with approx 20 province
boundaries) with an attribute table that contains a continuous
variable at the province level (name of column is `y2009'). Trying to
put the `y2009' variable on the map, i begin with defining the color
grading to be used by means of the following command:
"GRASS 6.4> v.colors map=pse column=y2009 rgb_column=hc2 color=bcyr"
Doing so I get the following error:
"GRASS 6.4> v.colors map=pse column=y2009 rgb_column=hc2 color=bcyr
Creating column <hc2> ...
Scanning values ...
Looking up colors ...
Writing 16 colors ...
DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "SET": syntax error
ERROR: Error while executing: 'UPDATE SET hc2 = '0:0:255' WHERE y2009 =
0.094713'
ERROR: Processing SQL transaction
rm: cannot remove `C://test/poverty/.tmp/636.0_vcol.sql': Permission
denied"
Any idea what is creating the error -- or what i am doing wrong? Is
there a way to get around this/fix it?
I have a suggestion that might fix this problem. The v.colors script on
line 209 uses the expression:
grep "^$GIS_OPT_LAYER;"
to isolate the TABLE name, and I think that the windows version of grep
is confused by the semicolon ';'.
Please locate the script (should be under %GISBASE\scripts) and open it
in an editor. Then replace line 209 as follows:
(original)
TABLE=`v.db.connect -g map="$GIS_OPT_MAP" layer="$GIS_OPT_LAYER" fs=";"
| grep "^$GIS_OPT_LAYER;" | cut -f2 -d';'`
(change to:)
TABLE=`v.db.connect -g map="$GIS_OPT_MAP" layer="$GIS_OPT_LAYER" fs=";"
| grep "^$GIS_OPT_LAYER" | cut -f2 -d';'`
(just remove the ; from "^$GIS_OPT_LAYER" after grep)
Let us know if this works.
Regards,
Micha
Many thanks in advance!
Roy
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.
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
