[GRASS-user] Vector - thematic question

[Moritz Lennert]

On 23/03/07 23:12, Richard Chirgwin wrote:
> Thanks for all the previous help! - I am getting to a point where I am 
> feeling nearly competent.
> 
> I am now nearing the tasks for which I first started working with 
> Grass-GIS. It involves working with multiple tables to create a thematic 
> map, and it's the linking that's busting my brain.
> 
> I have:
> - A map of Australia as a boundary, with locations as boundaries, and a 
> numeric index of locations (vector 1), in a DBF (it was imported from a 
> Geosciences Australia shapefile).
> - A points file of locations within the boundaries as 
> latitude/longitude, with the same numeric index identifying which 
> location the points fall within (vector 2). This file is on a MySQL DB, 
> with a "total" column showing the number of locations in each index number.
> 
> What I want to do is use the "total" column in vector 2 to colour vector 
> 1 as a thematic map. What is the best way to create this link?

Just put these two tables into another backend (mysql, postgresql, 
sqlite) and create a view or new table.

See my previous mail for details.

Moritz