CUSP Watershed Investments

This repository contains the notebooks which were utilized for exploratory data analysis in the 2020 CUSP Capstone project: Economic Impacts of New York City’s Investment in Water Supply.

For data confidentiality reasons, the data files have not been included.

Description

NYC Department of Environmental Protection (DEP) is interested in understanding the economic impacts of source water protection. This project develops an interactive, web-based visualization tool for exploring trends in and relationships between DEP’s Land Acquisition Program and economic metrics including annual Real Average Salary, Average Employment and number of Establishments in NYC’s watersheds.

This repository is created in fulfillment for NYU CUSP capstone program 2020 requirements.

Team

Asnat Ghebremedhin (ag6917), Angelia Lau (al6481), Ross Alexander MacWhinney (ram844), Pratik Prakash Watwani (ppw220)

Mentor: Prof. Huy T. Vo

Description of Notebooks

1. QCEW: Exploration and data export of Quaterly Census of Employment and Wage data
2. Lands: Exploration of Land Acquisition Program data from DEP
3. Corr_QCEW_LAP: Computation of correlation values between annual QCEW metrics and annual LAP acreage per counties
4. agri_annual_data: Exploration of US Department of Agriculture annual yield per acre data for West Of Hudson (WOH) counties
5. agri_census_data: Exploration of US Department of Agriculture 5-yr agriculture census data for West Of Hudson (WOH) counties
6. LULC_LAP_EDA: Exploration of WOH specific LAP data that has been spatially joined with Land Use data given by DEP, aggregation of land use types
7. Corr_QCEW_LULC_LAP: Computation of correlation values between WOH counties and LAP acreage for each land use
8. Occupation_Analysis: Exploration of NYS and WOH employment and industry trends in the years 2000-2018

Requirements

• Python 3
  • numpy
  • pandas
  • geopandas
  • matplotlib
  • seaborn

Directory Structure

├── README.md
├── notebooks

Project websites

|