Urban Planning
Urban Data Analytics

Comparison between Open Restaurants and Open Restaurants on Open Streets across 3 Metrics

Project by: Annika Nina Yu, Lance Mikhail Punay, & Zoe Lin

Poster Layout by: Zoe Lin

Class: Introduction to Urban Data and Informatics

Faculty: Boyeong Hong

Year: 2022

What are the impacts of Open Restaurants on Vehicular Crash Rates, relevant 311 Complaints, and Rodent Complaints in New York City comparing the period of March 2019 to February 2020 and July 2021 to June 2022? Additionally, to what extent does the presence of Open Restaurants on Open Streets mitigate or exacerbate these impacts?

During the Covid-19 pandemic, New York City implemented outdoor dining initiatives and the Open Streets program to support the struggling hospitality industry and alleviate crowding.

Two years later, the city decided to make the Open Restaurants program permanent. This study aimed to assess the impacts of these initiatives by analyzing correlations between the data collected over the past two years using Python as well as mapping and visualization packages such as GeoPandas and Plotly respectively.

Correlations between various metrics and the number of outdoor restaurants showed a positive relationship with crashes and rodent sightings, suggesting public concerns. Notably, when comparing pre- and post-program periods, there was a positive correlation between rat sightings and Open Restaurant density, supporting anecdotal reports. Additionally, there was a negative correlation between crashes and Open Restaurant density, indicating that the program may have improved road safety. The general relationships do seem to mirror the relationships of Open Restaurants not on Open Streets and the metrics, allowing the study to tentatively claim that Open Streets do not mitigate or exacerbate the impacts of Open Restaurants.

No items found.

Open Restaurants - Choropleth Map

Open Restaurants on Open Streets - Choropleth Map

Motor Vehicle Crashes - Animated Density Map

Rodent Complaints - Animated Density Map

Difference in Number of Motor Vehicle Crashes - Choropleth Map

Difference in Number of Rodent Complaints - Choropleth Map

Difference in Number of Relevant 311 Complaints - Choropleth Map