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

[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-to-ope relationship.

Review ?reshape to convert to wide format before trying to merge into 
your object for using spplot().

Roger

>
> One to many table:
>
> Poly_ID Period Age
> 01           1       32
> 01           2       34
> 02           1       30
> 03           2       21
>
>
> One to one table
>
> Poly_ID Period1 Period2 Period3
> 01            32           34
> 02             30
> 03                           21
> 04                                    35
>
> Now,  is it possible to use one-to-many table for mapping using spplot / plot?
>
> The result data I am trying to map using spplot has 1 to 70 years
> periods. I want to produce maps per period, for 10 years or more for
> forest management regimes in forest stand.
>
> Any alternative?
>
> Thanks in advance.
>
> Noli
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>

-- 
Roger Bivand
Economic Geography Section, Department of Economics, Norwegian School of
Economics and Business Administration, Helleveien 30, N-5045 Bergen,
Norway. voice: +47 55 95 93 55; fax +47 55 95 95 43
e-mail: Roger.Bivand at nhh.no