[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