[Qgis-user] Joining tables and spatial data

[James Stott]

If you have managed to do this could you let me know how?

 

I can only get it to do a one to one join, not a one to many join.

 

From: Nick Turner [mailto:ngturner at gmail.com] 
Sent: 23 November 2011 19:10
To: James Stott
Cc: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Joining tables and spatial data

 

I have overcome what I think to be a similar problem by using the second
method you mention, then sorting the table by any column. All entries
then show on my system.




Nick Turner






On Wed, Nov 23, 2011 at 11:24 AM, James Stott <
James.Stott at npaconsult.co.uk> wrote:

I would like to join an attribute table (.csv) to some spatial data
(shapefile). I have added both the shapefile and the CSV into QGIS.

 

Now I can join them using the Join tab on the csv file layer properties
tab, but this doesn't give me any spatial information from the
shapefile. What I would like to be able to do is see the polygons that
have been joined from the shapefile. Is this possible? 

 

I have also joined the csv to the shapefile but this does not give me
multiple records. The CSV has multiple records and when I join in this
way then I only get one record back from the shapefile. Is it possible
to do one to many using the join tab?

 

Using qgis-dev from OSGeo4W.

 

James

James Stott BSc (Hons) MSc | Senior Professional
Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN
T: 01225 445548 | M: -
www.npaconsult.co.uk <http://www.npaconsult.co.uk/>  

  <http://www.npaconsult.co.uk/>  
<http://www.npaconsult.co.uk/about-news.asp> 

Information and Registered Address
<http://www.npaconsult.co.uk/terms.asp>  

This Electronic Transmission is intended only for the attention of the
addressee. It may contain privileged and confidential information. If
you are not the person for whom it is intended, you must not copy,
distribute or take any action in reliance on it. If you have received
this electronic transmission in error please notify us immediately by
telephone, delete the transmission and destroy any hard copies. 

Nicholas Pearson Associates has used all reasonable efforts to ensure
that this message and any attachments are free from viruses.

Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44
(0) 01225 445548, Fax: +44 (0) 01225 312387, Website: 
http://www.npaconsult.co.uk <http://www.npaconsult.co.uk/> 



James Stott BSc (Hons) MSc | Senior Professional
Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN
T: 01225 445548 | M: -
http://www.npaconsult.co.uk/ 

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111124/5d370cb6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 28847 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111124/5d370cb6/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 35658 bytes
Desc: image002.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111124/5d370cb6/attachment-0001.jpg>