NYC COVID-19 GIS App Tracker
How to build an interactive NYC COVID-19 GIS tracker application with RShiny and Leaflet
Overview
NYC Department of Mental Health and Hygiene (DOHMOH) has a fantastic open source COVID-19 database on their publicly accessible Github. The data is cleaned and requires minor wrangling to track salient aspects of the COVID-19 pandemic. For the most part the visuals they provide on NYC.gov are adequate, however I wanted to create my own interactive easily updatable tracker to view changes in COVID-19 over time via geospatial analysis.
The Data
There are many files in their repository, however, since I was primarily concerned with geospatial data, I gravitated towards those that were sorted as such. The DOH data was aggregated by Modified Zip Code Tabulation Area (MODACTA). Modified ZCTA combines census blocks with smaller populations to allow more stable estimates of population size for rate calculation. This means they collapse multiple smaller zip codes into one, which works well for tracking NYC neighborhood trends. That being said, here are the following files from the DOH repository, this analysis and subsequent RShiny application will utilize.
Case rate — caserate-by-modzcta.csv
contains rate of cases per 100,000 people.