Re: [R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-06 Thread Noli Sicad
> Depends on your GIS! Shapefiles only have a 1-1 relationship, but > that's because they are a bit rubbish. If you use a proper spatial > database then you can do one-many. This is an application for a > PostGIS or Spatialite database, and if your GIS can read that (Qgis > for example) then you a

Re: [R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-06 Thread Barry Rowlingson
On Wed, Jan 6, 2010 at 6:16 AM, Noli Sicad wrote: > Hi, > > I have problem transposing my database table which is to be merged / > joined with the shapefile file (*.dbf) inorder to have one-to-one > relationship with shapefile polygon. As we know that inorder for the > polygon to be rendered in GI

Re: [R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-06 Thread Roger Bivand
On Wed, 6 Jan 2010, Noli Sicad wrote: Review ?reshape to convert to wide format before trying to merge into your object for using spplot(). Roger OK. The answer is not possible. I have been studying reshape - cast and melt. The illustration submit in my earlier post, can be easily done. But

Re: [R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-06 Thread Noli Sicad
> Review ?reshape to convert to wide format before trying to merge into > your object for using spplot(). > > Roger OK. The answer is not possible. I have been studying reshape - cast and melt. The illustration submit in my earlier post, can be easily done. But here is the real data (below) is b

Re: [R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-05 Thread Roger Bivand
On Wed, 6 Jan 2010, Noli Sicad wrote: Hi, I have problem transposing my database table which is to be merged / joined with the shapefile file (*.dbf) inorder to have one-to-one relationship with shapefile polygon. As we know that inorder for the polygon to be rendered in GIS, it has to have one

[R-sig-Geo] One-to-many table relationship to shapefile polygon in spplot / plot - possible?

2010-01-05 Thread Noli Sicad
Hi, I have problem transposing my database table which is to be merged / joined with the shapefile file (*.dbf) inorder to have one-to-one relationship with shapefile polygon. As we know that inorder for the polygon to be rendered in GIS, it has to have one-to-ope relationship. One to many table: