[GRASS-user] Cat problem with v.db.join

Wesley Roberts wroberts at csir.co.za
Wed Jun 25 09:57:08 EDT 2008

Dear User list,

I am having some trouble with v.db.join.

I have 13 point vector files with tables connected and created using sqlite. 

I copy one of the files and rename it AnalysisData

I would now like to use v.db.join to join all of my 13 files to AnalysisData. All 13 files have the same number of points as they were generated from rasters of exactly the same size (125*125). My join field is cat in both and unfortunately I have run into the duplicate 'cat' issue mentioned in the archives. I then updated AnalysisData and generated a new column and copied the values from 'cat' using v.db.update to create a new join column. Again the 'cat' issue poped up. It isnot possible to change the column name cat either.

In the archives I see that this problem has been solved in 6.4 but am weary of installing a 'development' version of grass.

One other thing, surely all grass vectors have a column 'cat' and even if they were not used in the join the problem would persist.

Am I missing something?

Many thanks for all your help,

This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.

More information about the grass-user mailing list