Skip to content

Merging Shape files

3 messages · El Mechry El Koudouss, Dexter Locke, Zia Ahmed

#
Dear readers,
I downloaded a shapefile with data on crime incidents in Washington DC in
2016 (available here:
https://opendata.dc.gov/datasets/crime-incidents-in-2016) and another
shapefile with data on parks and recreation areas, also in Washington DC
(available here: https://opendata.dc.gov/datasets/parks-and-recreation-areas).
I was able to read both shapefiles using st_read() from the sf package. My
question is, how can I merge the two data sets? I tried st_join() but it
simply resulted in empty columns from the parks dataset getting added to
the crime data. Any guidance would be much appreciated.
library(sf)
parks <- st_read("Parks_and_Recreation_Areas.shp")
crime <- st_read("Crime_Incidents_in_2016.shp")
df <- st_join(crime, parks)
#
Within st_join() see the options like "left = TRUE".

You may also want to look at st_intersects()

Here are other helpful reference websites:
https://r-spatial.github.io/sf/reference/geos_binary_pred.html

https://cran.r-project.org/web/packages/sf/vignettes/sf3.html

-Dexter


On Tue, Mar 17, 2020 at 10:29 AM El Mechry El Koudouss <
eelkoudouss at fordham.edu> wrote:

            

  
  
1 day later
#
Please  check this:

https://zia207.github.io/geospatial-r-github.io/geoprocessing-vector-data.html
Best
Zia
On Tue, Mar 17, 2020, 10:39 AM Dexter Locke <dexter.locke at gmail.com> wrote: