[GRASSLIST:9497] v.to.rast problem

GRASS GRASS user
1

hello

what can I do to overcome the problem ?

v.to.rast input=jgenel1 layer=1 output=jgenel1 use=attr column=yas rows=4096
Loading vector information ...ERROR: Column type not supported by db_select_to_array()

please post the result of
v.info -c jgenel1

to the list as well.

regards

Markus

regards

Ahmet Temiz

______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.

Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.

thank you for your quick help

v.info -c jgenel1
Displaying column type for database connection of layer 1:
INTEGER|cat
CHARACTER|yas
INTEGER|count
DOUBLE PRECISION|sum_cat

in postgresql

bzk=# \d jgenel1
          Table "public.jgenel1"
Column | Type | Modifiers
---------+-----------------------+-----------
cat | integer |
yas | character varying(80) |
count | integer |
sum_cat | double precision |

______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.

Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.

2

>>v.to.rast input=jgenel1 layer=1 output=jgenel1 use=attr column=yas
>>rows=4096
>>Loading vector information ...ERROR: Column type not supported by
>>db_select_to_array()

..

v.info -c jgenel1
Displaying column type for database connection of layer 1:
INTEGER|cat
CHARACTER|yas
INTEGER|count
DOUBLE PRECISION|sum_cat

in postgresql

bzk=# \d jgenel1
          Table "public.jgenel1"
Column | Type | Modifiers
---------+-----------------------+-----------
cat | integer |
yas | character varying(80) |
count | integer |
sum_cat | double precision |

The v.to.rast column= must be numeric (integer, double).
(ok, poorly documented & error message might make a suggestion)

Alternately if you really want to save the labels, use the cat column
for the value and then make a "$MAPSET/cats/" file with the cat numbers
and the text labels. This would be pretty easy to generate
automatically. I am not sure if/where this is mentioned in the modern
documentation. Should probably be in grass6/raster/rasterintro.html or
a grass6/doc/raster/specification.html ? Doxygen?

Hamish

3

Hamish wrote:

v.to.rast input=jgenel1 layer=1 output=jgenel1 use=attr column=yas rows=4096
Loading vector information ...ERROR: Column type not supported by db_select_to_array()
       

...

v.info -c jgenel1
Displaying column type for database connection of layer 1:
INTEGER|cat
CHARACTER|yas
INTEGER|count
DOUBLE PRECISION|sum_cat

in postgresql

bzk=# \d jgenel1
         Table "public.jgenel1"
Column | Type | Modifiers
---------+-----------------------+-----------
cat | integer |
yas | character varying(80) |
count | integer |
sum_cat | double precision |
   
The v.to.rast column= must be numeric (integer, double).
(ok, poorly documented & error message might make a suggestion)

Alternately if you really want to save the labels, use the cat column
for the value and then make a "$MAPSET/cats/" file with the cat numbers
and the text labels. This would be pretty easy to generate
automatically. I am not sure if/where this is mentioned in the modern
documentation. Should probably be in grass6/raster/rasterintro.html or
a grass6/doc/raster/specification.html ? Doxygen?

Hamish

thank you

I converted vect. to rast with cat. Then I reclassify resulting raster map with
attributed values' of mother vector map.

kind regards

______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.

Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.