[GRASS-user] v.db.join question

Johannes Radinger johannesradinger at gmail.com
Tue Feb 12 07:15:43 PST 2013


Hi,

I try to join a vector attribute table (points, sqlite-db) with
another sqlite table that is already imported to GRASS.
Both tables share some columns and have a column called AB_ID as
unique identifier (key to join).

I opened the sqlite database with the SQLite Manager (Firefox) and can
successfully perform a simple query:
SELECT * FROM Vector_1, Table_2 WHERE Vector_1.AB_ID=Table_2.AB_ID

however when I want to join the tables in GRASS using v.db.join the
new columns (*_other) are empty for all rows:
v.db.join -a map="Vector_1" column="AB_ID" otable="Table_2" ocolumn="AB_ID"

As some of the columns have the same names in both tables I used the 'a'-flag.

What I am doing wrong? I am working with GRASS65 (rev 55016) on Ubuntu 12.04.

/Johannes


More information about the grass-user mailing list