On 23/10/12 6:00 AM, [email protected] wrote:
Message: 1
Date: Mon, 22 Oct 2012 13:20:02 +0200
From: Johannes Radinger<[email protected]>
To:[email protected]
Subject: [GRASS-user] Join sqlite table by coordinate pair (X,Y)
Message-ID:
<CABsGe_xs1NHvOhGX_vvW=fe_afvf-ptkzb2kesa1xuocw5g...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi,
I have a points vector file with the columns X and Y which are
populated with the respective coordinates.
Additionally I have a .csv file for the same points, also with the X
and Y column and a lot more columns
providing additional information. These two files don't share a single
unique key which can be used for joining.
Thus I'd like to use the X-Y pair as a key for importing and then
joining the csv table
to the vector. Is there any possibility to use two columns as a
combined key instead of one
(probably an SQL statement for db.execute)? Or do I need to first
create a new column
and combine x and y into a key for the vector and the csv?
Any suggestions how that can be done in GRASS (6.5, sqlite) in a simple way?
Best regards,
Johannes
My suggestion -
Map_a = your sqlite map
Map_b = the csv file
1. Import the csv file as Map_b
2. Add a column to Map_b to capture the categories in Map_A (a_cat)
3. Use v.distance to populate the "a_cat" column in Map_b
4. v.db.connect Map_a table=Map_b key=a_cat layer=2
Step 4 means that the second table is now connected to your original
map, using the same category values as the key.
cheers,
Richard
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
