<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<STYLE TYPE="text/css">
<!-- /* Style Definitions */ p.4d78591f-8e0f-436b-a2b5-9928720b3dfa, li.4d78591f-8e0f-436b-a2b5-9928720b3dfa, div.4d78591f-8e0f-436b-a2b5-9928720b3dfa, table.4d78591f-8e0f-436b-a2b5-9928720b3dfaTable {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}-->
</STYLE>
<META content="text/html; charset=utf-8" HTTP-EQUIV="Content-Type"><meta content="Microsoft Word 12 (filtered medium)" name=Generator><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><BODY>
<P CLASS="4d78591f-8e0f-436b-a2b5-9928720b3dfa" STYLE=" margin-bottom:5px;">
<div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>If you have managed to do this could you let me know how?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I can only get it to do a one to one join, not a one to many join.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p></div></P><P STYLE=" margin-top:5px; margin-bottom: 10px">
<SPAN STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 10pt">
<STRONG>James Stott</STRONG>
<SPAN STYLE="font-size: 8pt">BSc (Hons) MSc</SPAN> |
Senior Professional<BR>
<SPAN STYLE="font-size: 8pt"><B STYLE="font-weight: bold">Nicholas Pearson Associates </B> | 30 Brock Street | Bath | BA1 2LN<BR>
<B>T:</B>
01225 445548
| <B>M:</B>
-<BR>
<A HREF="http://www.npaconsult.co.uk/" STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 8pt; text-decoration: none;"><STRONG>www.npaconsult.co.uk</STRONG></A>
</SPAN>
</SPAN>
<BR>
<BR>
</P>
<P>
<div class=WordSection1><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Nick Turner [mailto:ngturner@gmail.com] <br><b>Sent:</b> 23 November 2011 19:10<br><b>To:</b> James Stott<br><b>Cc:</b> qgis-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] Joining tables and spatial data<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Georgia","serif"'>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.<br clear=all><br><br><br><br>Nick Turner<br><br></span><br><br><br><o:p></o:p></p><div><p class=MsoNormal>On Wed, Nov 23, 2011 at 11:24 AM, James Stott <<a href="mailto:James.Stott@npaconsult.co.uk">James.Stott@npaconsult.co.uk</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'>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.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'>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? <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'>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?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'>Using qgis-dev from OSGeo4W.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white'>James<o:p></o:p></p></div><p style='mso-margin-top-alt:3.75pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;background:white'><strong><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#00227C'>James Stott</span></strong><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#00227C'> </span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#00227C'>BSc (Hons) MSc</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#00227C'> | Senior Professional<br></span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#00227C'>Nicholas Pearson Associates </span></b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#00227C'>| 30 Brock Street | Bath | BA1 2LN<br><b>T:</b> 01225 445548 | <b>M:</b> -<br><a href="http://www.npaconsult.co.uk/" target="_blank"><strong><span style='font-family:"Verdana","sans-serif";color:#00227C;text-decoration:none'>www.npaconsult.co.uk</span></strong></a> </span><o:p></o:p></p><table border=0 cellpadding=0 cellspacing=0 class=MsoNormalTable style='width:525.0pt;border-collapse:collapse;outline-style:none' width=700><tr><td style='padding:0cm 0cm 0cm 0cm'><p class=MsoNormal><a href="http://www.npaconsult.co.uk/" target="_blank"><span style='border:none windowtext 1.0pt;padding:0cm;text-decoration:none'><img alt="Nicholas Pearson Associates, Logo" border=0 id="_x0000_i1025" src="cid:image001.jpg@01CCAAC4.2BF80C10"></span></a><a href="http://www.npaconsult.co.uk/about-news.asp" target="_blank"><span style='border:none windowtext 1.0pt;padding:0cm;text-decoration:none'><img alt="Nicholas Pearson Associates, Latest News" border=0 id="_x0000_i1026" src="cid:image002.jpg@01CCAAC4.2BF80C10"></span></a><o:p></o:p></p></td></tr></table><p style='mso-margin-top-alt:5.65pt;margin-right:0cm;margin-bottom:5.65pt;margin-left:0cm;background:white'><span style='font-size:7.0pt;font-family:"Verdana","sans-serif";color:black'><a href="http://www.npaconsult.co.uk/terms.asp" target="_blank"><span style='color:black;text-decoration:none'>Information and Registered Address</span></a> <o:p></o:p></span></p><p style='mso-margin-top-alt:3.75pt;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background:white'><span style='font-size:7.0pt;font-family:"Verdana","sans-serif";color:#666666'>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. <o:p></o:p></span></p><p style='mso-margin-top-alt:3.75pt;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background:white'><span style='font-size:7.0pt;font-family:"Verdana","sans-serif";color:#666666'>Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses.<o:p></o:p></span></p><p style='mso-margin-top-alt:3.75pt;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background:white'><span style='font-size:7.0pt;font-family:"Verdana","sans-serif";color:#666666'>Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: <a href="http://www.npaconsult.co.uk/" target="_blank">http://www.npaconsult.co.uk</a><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></P>
</BODY></HTML>