[Qgis-user] spatial join, many to 1

[pcreso at pcreso.com]

Agreed,

Qgis is not really a spatial data management tool, use a spatial database for that, then use QGIS as a gui to interact with the database.

Whether you use Spatialite, MySQL or Postgis (from the FOSS world) depends on how powerful you want your database solution to be. QGIS works very well with Spatialite & Postgis.


Brent Wood

--- On Sun, 10/21/12, Nathan Woodrow <madmanwoo at gmail.com> wrote:

From: Nathan Woodrow <madmanwoo at gmail.com>
Subject: Re: [Qgis-user] spatial join, many to 1
To: "Frazier, Tyler James" <tyler.j.frazier at tu-berlin.de>, "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Date: Sunday, October 21, 2012, 12:03 PM

Hey Tyler,

My advice would be to load you data into a spatialite database and use that to run your query. It will give you the most control.  Have a look at the QSpatialite plugin, it will let you load in your QGIS layers and run queries.


- Nathan
From: Frazier, Tyler James
Sent: 21/10/2012 8:54 AM

To: qgis-user at lists.osgeo.org

Subject: [Qgis-user] spatial join, many to 1




 


Hi,



Is there a way to do a spatial join: MANY to ONE --  and still retain all the feature characteristics in QGIS?  I want to join several towns, villages etc...to a tract of land and keep the names of all the towns, villages, etc...as part of the spatial
 join.  I have done something similar in R with aggregate() but without the spatial component.  Any advice suggestions are welcome.



Thanks!
Ty




-----
Tyler Frazier
Department of Transportation Planning and Telematics
Technical University Berlin
http://www.vsp.tu-berlin.de/














-----Inline Attachment Follows-----

_______________________________________________
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/20121020/5e0d1781/attachment.html>