newyorkcitycouncil / park_equity_covid_2022 Goto Github PK

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:

• Walk-to-a-Park Service Area
• Parks Maintenance Report
• 2010 Census Tracts
• 2010 ZCTA to Census Tract Relationship File
• NYC DOHMH COVID-19 Data by MODZCTA
• NYC DOHMH Geographic Resources
• 2019 5-Year ACS Survey: *We used R package censusapi to get demographic data

• 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.

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

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.

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.

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.

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

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

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.

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

Creates maps at the zip code (modzcta level).

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