Skip to content

NicholasMontalbano/park_equity_covid_2022

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Park Equity & COVID-19

Data analysis and visuals for NYCC 4.22.22 'Oversight: The Effect of COVID-19 on Park Equity' hearing.

An associated webpage for this analysis can be found on the council website:


Data Sources

Methodology

Summary & Intention

  • Calculate how much functional acreage of park space residents of NYC have access to.
  • Analyze geographic & income disparities in access to park space & the relation to COVID cases.

Parks included in Analysis

From the Annual Report on Park Maintenance (Local Law 98 of 2015)

10 Minute Walking Distance

Using the access points from Walk-to-a-Park Service Area dataset, we created isochrone polygons or time-distance areas for each point. We used mapbox api for this process and selected a 10 minute walking distance parameter. If the center of a census tract is within 10-minutes walking of any access point associated with a given park, then it is designated as having access to that park.

Acreage Per Capita

If a census tract is designated as having access to a park, then it is assigned the functional acreage of that park. The acreage is summed for all the parks a census tract has access to. The total acreage is then divided by the census tract population to get acreage per capita. For larger parks, we do not assign the full acreage of the park to a census tract. The maximum amount assigned from a park is capped at 7,000,000 square feet or 160.6979 acres. This number is roughly equivalent to 0.25 square miles and is 3 standard deviations above the average acreage of all the parks in NYC.

Zip Code Aggregation

To compare the COVID-19 data to our open space access data, we aggregate the census tracts up to the MODZCTA level. Census tract data is first aggregated to ZCTA5 level using the Census crosswalk relationship file and doing a population-weighted assignment of acreage. Refer to the technical document for more information on the crosswalk.

The data is then aggregated to the MODZCTA level using the NYC DOHMH files. The MODZCTA acreage is a population-weighted average of each nested ZCTA value.

Scripts

load_dependencies.R

Loads necessary libraries and functions for use in the other scripts.

create_processed_data.R

Creates the data found in data/processed. Imports and cleans park maintenance data, imports ACS data, joins and writes shapefiles with ACS data.

park_ct.R

This script determines which open space access points are within 10 minutes walking from each census tract and assigns acreage per capita, demographic variables, and park maintenance variables.

park_modzcta.R

This script aggregates the data up to the zip code (modzcta) level.

park_modzcta_map.R

Creates maps at the zip code (modzcta level).

park_modzcta_corr.R

Creates plots of correlations at the zip code (modzcta level).

About

Repository for work performed for NYCC 4/22/22 Parks Oversight Hearing

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • HTML 97.6%
  • JavaScript 2.0%
  • Other 0.4%