1

I'm very new to spatial stuff in R and am trying to do something I imagine is very simple but am having trouble. I have two spatialpolygonsdataframes. 1 is of all US counties and another is of core-based statistical areas (CBSA's). Each CBSA aligns with county borders, but can cover more than one county. In other words, for example, a CBSA can cover all of one county or several adjacent counties, but no CBSA covers part of a county and no county is covered by multiple CBSA's. Attached is a picture of the CBSA's overlapping the counties (Produced in Qgis)enter image description here

What I'd like to do is basically create a dummy variable called CBSA with a 1 for CBSA counties (red in the map) and a 0 for those not. My first hunch after some searching was to use over from sp. I tried over(cbsa,county), which spit out a data frame of 929 observations (the number of CBSAs) with attributes from the county dataframe.

This seems right, except quickly looking at the table shows that the counties are not correctly identified. Multiple observations are tied to the same counties and looking in QGIS verifies that many counties that are part of CBSA's do not appear.

Am I using the right command and just doing something wrong or is there another way I should do this?

my code appears below:

library(sp)
setwd("~/Desktop/test_folder")
load("county.rda")
load("cbsa.rda")
test<-over(cbsa, county)

Data:http://www.filedropper.com/testfolder

0

What I'd like to do is basically create a dummy variable called CBSA with a 1 for CBSA counties (red in the map) and a 0 for those not.

I'm no spatial expert, but maybe you tweak something based on this:

library(rgeos)
# shrink the cbsa polygons a bit to play it safe:
cbsa_b <- gBuffer(cbsa, byid=TRUE, width=-0.05)
# get intersection matrix:
m <- gIntersects(county, cbsa_b, byid=TRUE)
# which county polygons intersect any cbsa?
in_cbsa <- colSums(m)>0

in_cbsa is the dummy variable CBSA with TRUE (or 1 if you make it in_cbsa+0L) for CBSA counties:

head(in_cbsa)
#     0     1     2     3     4     5 
# FALSE FALSE FALSE  TRUE  TRUE  TRUE 
sum(in_cbsa)
# [1] 1868

# plot to verify:
library(ggplot2)
county_f <- fortify(county)
cbsa_f <- fortify(cbsa)
ggplot() + 
  geom_polygon(aes(long,lat,group=group), county_f, fill=NA, color="black") + 
  coord_quickmap(xlim=c(-128,-75), ylim=c(25,55)) +
  geom_polygon(aes(long,lat,group=group), cbsa_f, fill="red", color=NA) +
  geom_polygon(aes(long,lat,group=group), county_f[county_f$id %in% names(which(!in_cbsa)), ], fill="blue", color=NA, alpha = .3)  

enter image description here

  • 1
    I ended up doing something similar to this, thanks. Merging back on column ID's was not as simple as I hoped, but a few extra lines of code never killed anyone. – winitheju Jun 16 '17 at 14:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.