Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I need to join a .csv table into an attribute table of a shapefile. I wanted to do this with QGIS and i don't seem to find anyway of doing it. I know that the mmqgis plugin does it, but my shapefile has 6000 records and this plugin crashes at 2000 and something... Any ideas?

share|improve this question
    
I must be missing a plugin. I have the Ftools loaded, but only "Join attributes by location". Is there an additional step? –  user10525 Sep 27 '12 at 1:42
    
Like it was written, it's a tab in the Layer Properties window. Please open a separate question next time, since this is not an answer. –  lynxlynxlynx Sep 27 '12 at 16:40

2 Answers 2

up vote 10 down vote accepted

In QGIS 1.7 you'll find Table Joins in Layer Properties. Load the CSV file using "Add vector layer".

enter image description here

share|improve this answer

Thats one way if the csv file has location data. I think you should also be aware that |VECTOR|DATA MANAGEMENT TOOLS|JOIN ATTRIBUTES will join non-located data to an existing GIS layer. For instance you have a road layer which was created only with a name attribute. In another data table you have names and road surface but no location data. The join field will be the name attribute, and the output layer will have a new attribute showing road surface. This new layer can then be symbolised to display road surface. In JOIN ATTRIBUTES the dialog asks for a dbf file but .csv files are also supported.

If you need to manipulate your join attribute to ensure the values are identical, open the csv and the dbf of the shapefile in LibreOffice and manipulate them there.

Cannot comment on the number of records supported by DATA MANAGEMENT TOOLS

You may have to turn on the F-TOOLS plugin.

hth

share|improve this answer
    
Or maybe I am still using the dinosaur method..... –  BWill Jul 16 '11 at 7:56
1  
The .csv file does not have to contain location data to be loaded using "Add vector layer". (The naming is misleading.) –  underdark Jul 17 '11 at 14:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.