[GRASS-user] creating a new vector layer by table selection fails

GRASS GRASS user
1

Hello,
I am trying to create a new vector by selecting with an SQL query. But I cannot
suceed.

Here is the command I used:

v.extract input=country@PERMANENT output=country_selected
type=boundary,centroid,area,face layer=1 where='("name = Ukraine")' --overwrite

The output in the console:

Load categories from the database (table = country, db =
grassdata/testlocation/PERMANENT/dbf/).
dbmi: Protocol error
-1 categories loaded from the database
dbmi: Protocol error
Building topology ...
0 primitives registered
0 areas built
0 isles built
Attaching islands:
Attaching centroids: Topology was built.
Number of nodes : 0
Number of primitives: 0
Number of points : 0
Number of lines : 0
Number of boundaries: 0
Number of centroids : 0
Number of areas : 0
Number of isles : 0
Writing attributes...

If I use the following command:
v.extract input=country@PERMANENT output=country_selected
type=boundary,centroid,area,face layer=1 list=34 --overwrite
it all works well.
What could be the error?

Thanks in advance!

Regards,
Timmie

2

Hi,

2008/8/13 Tim Michelsen <timmichelsen@gmx-topmail.de>:

v.extract input=country@PERMANENT output=country_selected
type=boundary,centroid,area,face layer=1 where='("name = Ukraine")' --overwrite

'("name = Ukraine")'

is bogus, should be

where="name = Ukraine"

Load categories from the database (table = country, db =
grassdata/testlocation/PERMANENT/dbf/).
dbmi: Protocol error
-1 categories loaded from the database
dbmi: Protocol error

...

Martin

--
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa *

3

Hi,
thanks for the fast response.

'("name = Ukraine")'

is bogus, should be

where="name = Ukraine"

It worked finally with

where="name = 'Ukraine'"

Timmie