[R-sig-Geo] Combing attribute table with polygon??

Robert J. Hijmans r.hijmans at gmail.com
Thu Jan 28 02:21:40 CET 2010


Zia, something like this might work as long as MUKEY has no NA values:

poly.data = merge(poly.data, data.table, by="MUKEY" ,all.x = TRUE)

Robert

On Wed, Jan 27, 2010 at 1:58 PM, Zia Ahmed <zua3 at cornell.edu> wrote:
> I have created one data table and one polygon in R. Both have a similar type
> of column.  I want to combine or join them with this column or field
> ("MUKEY").  Then  I will convert this polygon  as  a ESRI  shape file.
> But  when  I  used  spCbind,   I got error. I think i miss something here.
> Is there any way join attribute table with polygon? Thanks
> Zia
>
> poly.data1 <- spCbind(poly.data, data.table)
> Error in spCbind(poly.data, data.table) : different numbers of rows
>
>
> names(poly.data) # polygoan
> [1] "AREASYMBOL" "SPATIALVER" "MUSYM"      "MUKEY"    > names(data.table) #
> data
> [1] "MUKEY" "Sand"  "Silt"  "Clay"  "pH"    "CEC"   "EC"    "SAR"   "CaCO3"
> [10] "SOM"   "BD"    "AWC"   "KSAT"  "Kf"    "Kw"    "LL"    "LEP"
>> length(poly.data$MUKEY)
> [1] 76969
>> length(data.table$MUKEY)
> [1] 184
>>
>
>
> poly.data1 <- spCbind(poly.data, data.table)
>
> combinedShp1 <- "D:/test/combined1.shp" writeOGR(poly.data1,
> dsn=combinedShp1, layer="combined1", driver="ESRI Shapefile")
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>



More information about the R-sig-Geo mailing list