Housing Rental Analysis for San Francisco

• Author: Aaron Singh
• Credits data.sfgov.org authors/engineers

Data Visualization

This project utilizes Python visualizations packages, such as Plotly Express, HVPlot and PyPlot/Matplotlib to create an interactive dashboard exploring the 2010-2021 San Francisco housing market.Uses API to grab data and create visualizations.

Files

• Houing Rental Analysis

• Rent Analysis

• neighborhoods_coordinates CSV File

• sfo_neighborhoods_census_data CSV File

• https://docs.google.com/presentation/d/1xsBC9tL6a0b6NZPd50ilc9VYkQBUAda3tOiwHZvf0Q0/edit#slide=id.gc6f972163_0_0

Housing Rental Analysis for San Francisco Web App

• https://dataviz.runmercury.com/
• https://dataviz.runmercury.com/app/dashboard-0
• https://dataviz.runmercury.com/app/rental_analysis
• https://dataviz.runmercury.com/app/rental-analysis-2

Introduction

This project analyzes the housing rental market in San Francisco from 2010 to 2021. The analysis uses data from the San Francisco Open Data website: https://data.sfgov.org/.

The analysis focuses on the following aspects of the housing rental market:

• Number of housing units per year
• Average sale prices per square foot
• Average sale prices by neighborhood

The analysis also includes an interactive neighborhood map that shows the average gross rent and sale price per square foot by neighborhood.

Key Findings

• The number of housing units in San Francisco has increased steadily over the years, from 31,744 in 2010 to 42,204 in 2021.
• The average sale price per square foot in San Francisco has also increased steadily over the years, from $547 in 2010 to $920 in 2021.
• The average sale price per square foot varies by neighborhood in San Francisco. The most expensive neighborhoods are Pacific Heights, with an average sale price per square foot of $1,498 in 2021, and Sea Cliff, with an average sale price per square foot of $1,436 in 2021.
• The neighborhoods with the highest gross rent are also the neighborhoods with the highest sale price per square foot. The neighborhoods with the highest gross rent are Pacific Heights, with an average gross rent of $4,118 in 2021, and Sea Cliff, with an average gross rent of $3,987 in 2021.

The analysis provides valuable insights into the housing rental market in San Francisco. These insights can be used by investors, policymakers, and other stakeholders to make informed decisions about the housing market. [ [ [ [ [ [ [ [ [

Conclusion

The trend in rental income growth has outpaced the trend in sales prices. This is likely due to the fact that the supply of rental units has not kept up with the demand. This trend is not the same for all neighborhoods across San Francisco. Some neighborhoods, such as Pacific Heights and Sea Cliff, have seen a significant increase in both rental income and sales prices. Other neighborhoods, such as Bayview and Excelsior, have seen a more modest increase in rental income and sales prices.

The data suggests that the one-click, buy-and-rent strategy that the company is pursuing could be successful in San Francisco. However, the company should carefully consider the neighborhood in which they invest. Some neighborhoods, such as Pacific Heights and Sea Cliff, may be more lucrative than others.