[Qgis-user] Joining tables and spatial data

[Andreas Neumann]

 asfaik - one to many is currently not possible. It would also result in 
 a duplication of geometries, if you join from one geometry to multiple 
 records ... probably not what you want.

 If you want to join and aggregate, you can do so in a real database, 
 such as PostgreSQL.

 Andreas

 On Thu, 24 Nov 2011 16:14:41 -0000, James Stott wrote:
> 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.
>
>    BSc (Hons) MSc | Senior Professional
>   | 30 Brock Street | Bath | BA1 2LN
>   01225 445548 |  -
>
> 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  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 [2]
>
>  [3] [4]
>
> Information and Registered Address [5]
>
> 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 [6]
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org [7]
> http://lists.osgeo.org/mailman/listinfo/qgis-user [8]
>
>
>
> Links:
> ------
> [1] mailto:James.Stott at npaconsult.co.uk
> [2] http://www.npaconsult.co.uk/
> [3] http://www.npaconsult.co.uk/
> [4] http://www.npaconsult.co.uk/about-news.asp
> [5] http://www.npaconsult.co.uk/terms.asp
> [6] http://www.npaconsult.co.uk/
> [7] mailto:Qgis-user at lists.osgeo.org
> [8] http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland