Roy:
Hi Micha, To follow up on my problem and your fix, I am no longer
getting the error message i used to get. When i look at the attribute
table, however, the RGB_column variable (which i named `hc2' in my
example) -- created by v.colors -- has a lot of missing values. Do
you have an idea why this is the case?
one thing to try is to remove the hc2 column (v.db.dropcol) and try again.
what does v.univar say about the numerical column?
Hamish
Hi Hamish and Micha,
Many thanks for your help.
I tried to generate a new rgb_column using v.colors, but that did not help.
When I submit “v.univar map=pse column=y2009”, i get:
“number of features with non NULL attribute: 96
number of missing attributes: 0
number of NULL attributes: 0
minimum: 0.0947129
maximum: 0.388736
range: 0.294023
WARNING: Incompatible vector type(s) specified, only number of features,
minimum, maximum and range can be calculated”
To follow up on your earlier comment, submitting: v.db.connect -g map=pse layer=1 fs=“;”
yields: 1/pse;pse;cat;C://test/poverty/sqlite.db;sqlite
Does this help?
Thanks again,
Roy
-----Hamish hamish_b@yahoo.com wrote: -----
To: Micha Silver micha@arava.co.il, rvanderweide@worldbank.org
From: Hamish hamish_b@yahoo.com
Date: 12/19/2010 04:43PM
Cc: grass-user@lists.osgeo.org
Subject: Re: [GRASS-user] SQL Error using “v.color”Roy:
Hi Micha, To follow up on my problem and your fix, I am no longer
getting the error message i used to get. When i look at the attribute
table, however, the RGB_column variable (which i named `hc2’ in my
example) – created by v.colors – has a lot of missing values. Do
you have an idea why this is the case?one thing to try is to remove the hc2 column (v.db.dropcol) and try again.
what does v.univar say about the numerical column?Hamish
Hi Hamish and Micha,
Many thanks for your help.
To follow up on your earlier comment, submitting: v.db.connect -g map=pse layer=1 fs=“;”
yields: 1/pse;pse;cat;C://test/poverty/sqlite.db;sqlite
Here’s the problem. That slash and “pse” (layer name) after the digit ‘1’.
Any grep expression with a character following the $GIS_OPT_LAYER will fail…
--
Micha Silver
Arava Development Co. +972-52-3665918
[http://surfaces.co.il](http://surfaces.co.il)
Hi Micha and Hamish,
Do you see a way of fixing this?
I also tried it with a numeric variable that takes integer values only – but the rgb_column created by v.colors still holds many missing values.
Many thanks!
Roy
-----Micha Silver micha@arava.co.il wrote: -----
To: rvanderweide@worldbank.org
From: Micha Silver micha@arava.co.il
Date: 12/19/2010 05:26PM
Cc: Hamish hamish_b@yahoo.com, grass-user@lists.osgeo.org
Subject: Re: [GRASS-user] SQL Error using “v.color”On 12/20/2010 12:07 AM, rvanderweide@worldbank.org wrote:
Hi Hamish and Micha,
Many thanks for your help.
To follow up on your earlier comment, submitting: v.db.connect -g map=pse layer=1 fs=“;”
yields: 1/pse;pse;cat;C://test/poverty/sqlite.db;sqlite
Here’s the problem. That slash and “pse” (layer name) after the digit ‘1’.
Any grep expression with a character following the $GIS_OPT_LAYER will fail…Does this help?
Thanks again,
Roy
-----Hamish hamish_b@yahoo.com wrote: -----
To: Micha Silver micha@arava.co.il, rvanderweide@worldbank.org
From: Hamish hamish_b@yahoo.com
Date: 12/19/2010 04:43PM
Cc: grass-user@lists.osgeo.org
Subject: Re: [GRASS-user] SQL Error using “v.color”Roy:
Hi Micha, To follow up on my problem and your fix, I am no longer
getting the error message i used to get. When i look at the attribute
table, however, the RGB_column variable (which i named `hc2’ in my
example) – created by v.colors – has a lot of missing values. Do
you have an idea why this is the case?one thing to try is to remove the hc2 column (v.db.dropcol) and try again.
what does v.univar say about the numerical column?Hamish
This mail was received via Mail-SeCure System.
–
Micha Silver
Arava Development Co. +972-52-3665918
http://surfaces.co.il