<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Agreed,<br><br>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.<br><br>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.<br><br><br>Brent Wood<br><br>--- On <b>Sun, 10/21/12, Nathan Woodrow <i><madmanwoo@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Nathan Woodrow <madmanwoo@gmail.com><br>Subject: Re: [Qgis-user] spatial join, many to 1<br>To: "Frazier, Tyler James" <tyler.j.frazier@tu-berlin.de>, "qgis-user@lists.osgeo.org" <qgis-user@lists.osgeo.org><br>Date: Sunday, October 21, 2012, 12:03 PM<br><br><div
id="yiv1037699263"><div><div><div style="font-family:Calibri, sans-serif;font-size:11pt;">Hey Tyler,<br><br>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.<br>
<br>- Nathan<br></div></div><hr><span style="font-family:Tahoma, sans-serif;font-size:10pt;font-weight:bold;">From: </span><span style="font-family:Tahoma, sans-serif;font-size:10pt;">Frazier, Tyler James</span><br><span style="font-family:Tahoma, sans-serif;font-size:10pt;font-weight:bold;">Sent: </span><span style="font-family:Tahoma, sans-serif;font-size:10pt;">21/10/2012 8:54 AM</span><br>
<span style="font-family:Tahoma, sans-serif;font-size:10pt;font-weight:bold;">To: </span><span style="font-family:Tahoma, sans-serif;font-size:10pt;"><a rel="nofollow" ymailto="mailto:qgis-user@lists.osgeo.org" target="_blank" href="/mc/compose?to=qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a></span><br>
<span style="font-family:Tahoma, sans-serif;font-size:10pt;font-weight:bold;">Subject: </span><span style="font-family:Tahoma, sans-serif;font-size:10pt;">[Qgis-user] spatial join, many to 1</span><br><br></div>
<div>
<div>Hi,</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thanks!</div>
<div>Ty</div>
<br>
<div><span class="yiv1037699263Apple-style-span" style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium;"><span class="yiv1037699263Apple-style-span" style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium;">
<div style="word-wrap:break-word;">
<div>-----</div>
<div>Tyler Frazier</div>
<div>Department of Transportation Planning and Telematics</div>
<div>Technical University Berlin</div>
<div><a rel="nofollow" target="_blank" href="http://www.vsp.tu-berlin.de/">http://www.vsp.tu-berlin.de/</a></div>
<div><br>
</div>
</div>
</span><br class="yiv1037699263Apple-interchange-newline">
</span><br class="yiv1037699263Apple-interchange-newline">
</div>
<br>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="/mc/compose?to=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><br></div></blockquote></td></tr></table>