Code Monkey home page Code Monkey logo

park_equity_covid_2022's Introduction

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

park_equity_covid_2022's People

Contributors

nmontalbanocouncil avatar romartinez-nycc avatar

Watchers

 avatar  avatar  avatar  avatar

park_equity_covid_2022's Issues

10002 + 10009 updates please

Since 58% of East River Park is closed now, can you update the data to account for 21 fewer acres of open space, please? Closures of park space continues north in sections to 25th Street. See http://nyc.gov/escr

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.