R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Cmd+Shift+Enter.

setwd("~/Desktop")

#libraries
library(data.table)
library(sp)
library(rgdal)
library(ggplot2)
library(maptools)
library(raster)
library(leaflet)

#read in data table
ny_dat = fread("March 1 - final - March 1 - final.csv")

#convert to data table
ny_dat = as.data.table(ny_dat)

#table of total incidents by community
#filter places outside of chicago communities
#final number of observations = 1021
ny_tab = ny_dat['City or County'!=""]

#filter out NA values
ny_tab = na.omit(ny_dat)

#Change data type to NUM
ny_tab$Lat <- as.numeric(ny_tab$Lat)
ny_tab$Long <- as.numeric(ny_tab$Long)


#make data spatial
coordinates(ny_tab) = c("Long","Lat")
crs.geo1 = CRS("+proj=longlat")  
proj4string(ny_tab) = crs.geo1  


plot(ny_tab, pch = 20, col = "steelblue")

#read in shapefile of New York
New_York_Shape_File = readOGR(dsn = "./NYS Shapefile", layer = "cty036")

OGR data source with driver: ESRI Shapefile 
Source: "/Users/ericfletcher/Desktop/NYS Shapefile", layer: "cty036"
with 67 features
It has 80 fields

plot(New_York_Shape_File)

points(ny_tab, pch = 20, col = "orange")

NA
NA
NA

#read in shapefile of chicago
New_York_Shape_File = readOGR(dsn = "./NYS Shapefile", layer = "cty036")

OGR data source with driver: ESRI Shapefile 
Source: "/Users/ericfletcher/Desktop/NYS Shapefile", layer: "cty036"
with 67 features
It has 80 fields

#reproject coordinates
proj4string(New_York_Shape_File) = crs.geo1

A new CRS was assigned to an object with an existing CRS:
+proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
without reprojecting.
For reprojection, use function spTransform

ny_agg = aggregate(x=ny_tab["Total_Involved"],by=New_York_Shape_File,FUN=length)

qpal = colorBin("Reds", ny_agg$Total_Involved, bins=4)

leaflet(ny_agg) %>%
  addPolygons(stroke = TRUE,opacity = 1,fillOpacity = 0.5, smoothFactor = 0.5,
              color="black",fillColor = ~qpal(Total_Involved),weight = 1) %>%
  addLegend(values=~Total_Involved,pal=qpal,title="Total Injured or Killed <br> in Gun Violence per County <br> 03-01-20 to 4-26-20", na.label = "None Reported")

NA
NA
NA

#bins <- c(0, 10, 20, 30, 40, 50, 60, 70, 80, 100)
qpal = colorBin("Reds", ny_agg$Total_Involved, bins=4)

labels <- sprintf(
  "<strong>%s</strong>",
  ny_agg$Total_Involved
) %>% lapply(htmltools::HTML)

leaflet(ny_agg) %>%
  addPolygons(stroke = TRUE,opacity = 1,fillOpacity = 0.5, smoothFactor = 0.5,
              color="black",fillColor = ~qpal(Total_Involved),weight = 1, label = labels,
              labelOptions = labelOptions(
                style = list("font-weight" = "normal", padding = "3px 8px"),
                textsize = "15px",
                direction = "auto")) %>%
  addLegend(values=~Total_Involved,pal=qpal,title="Total Injured or Killed <br> in Gun Violence per County <br> 03-01-20 to 4-26-20", na.label = "None Reported")

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Cmd+Option+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Cmd+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.