
Hi,

Is there a way to do a spatial join: MANY to ONE --  and still retain all the feature characteristics in R?  I want to join several towns, villages etc...to a tract of land (survey enumeration area) and keep the names of all the towns, villages, etc...as part of the spatial join.  I am wondering if it would be worthwhile to try using the manageR plugin through QGIS, or readOGR and then run some type of spatial aggregate() function and then writeOGR or perhaps using postGIS with both R and QGIS.  I would prefer to keep my programming to R and not have to introduce postGIS and additional commands, unless there were some significant long-term advantages, such as better integration between R and QGIS or perhaps another open source.

All advice and suggestions are welcome.

Thanks!
Ty

Begin forwarded message:

Subject: Re: [Qgis-user] spatial join, many to 1
Date: October 21, 2012 2:10:52 AM GMT+02:00

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.

Subject: Re: [Qgis-user] spatial join, many to 1
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.

Sent: 21/10/2012 8:54 AM
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/





	[[alternative HTML version deleted]]

