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?
Cheers,
Richard Chirgwin
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