Spatialpolygonsdataframe
Hi
I tried to use sp merge to join the spatialpolygonddataframe (xx) and an
dataframe (yy4), which have 2 observations for each spatial ID. But it did
not allow with an error message as below:
Error in .local(x, y, ...) : 'y' has multiple records for one or more
'by.y' key(s)
I also tried the mapmerge in eeptools but failed.
Any suggestion? Thank you very much.
Meta
library("eeptools")
library("sp")
xx <- maptools::readShapePoly(system.file("shapes/sids.shp",
package="maptools")[1], IDvar="FIPSNO")
yy<-as(xx,"data.frame")
yy$newvar<-sample(0:100,nrow(yy),replace=TRUE)
yy<-subset(yy,select=c("FIPS","newvar"))
yy3<-yy
yy3$newvar<-10*yy3$newvar
yy4<-data.frame(rbind(yy,yy3))
newpoly<-merge(xx,yy4,sort=FALSE, by.x="FIPS",
by.y="FIPS" ,all.y=TRUE)
On Tue, Aug 18, 2015 at 7:31 PM, Metastate Metastate <metastate at gmail.com>
wrote:
Cool. Let me take a look. Thank you very much, Lo?c. Meta On Tue, Aug 18, 2015 at 3:31 AM, Lo?c Dutrieux <loic.dutrieux at wur.nl> wrote:
Hi, Have a look at merge in the sp package. ?sp::merge Cheers, Lo?c On 08/18/2015 04:12 AM, Metastate Metastate wrote:
Hi all,
I am starting to learn spatial analysis using R. Do anyone know if the
attribute data in a spatialpolygonsdataframe can contain multiple
observations within the same polygon? To be specific, I have a
spatialpolygonsdataframe that contain USA county polygons and the
relevant
attribute data contains the relevant state,county and FIPs. And I also
have another data-frame that contains weather features by year by county
(For example there are yearly average temperature for each county) . How
can I join the spatialpolygondataframe with the weather data so that the
resulted attribute table in the joint spatialpolygonsdataframe can
contain
*multiple-year* weather features within each county?
Thank you very much for any kindly help.
Meta
[[alternative HTML version deleted]]
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-geo
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-geo