On the city of Saint Paul Data Portal, there is information on the number of current vacant buildings in Saint Paul. You can download the data from here. If a building is occupied, then it will be removed for the list. Thus there will be more vacant houses within the last 2 to 3 years. The number of vacant properties can provide concern for a community but also an opportunity to revitalize an area. Classic example of urban blight is when many commercial fronts have closed down, which impacts development nearby. Vacant/abandoned properties, for better or for worse could provides a space space for illicit activities or it can provide housing for the homeless and downtrodden.
With this report, I hope residents can find areas that need more resources (i.e. economic development and housing resources) and consider options in dealing with the looming housing.
This dataset contains all of the registered vacant buildings in the City, as well as their type, and Vacant Building Category.
|0||937 SHERBURNE AVE||04/30/2019 12:00:00 AM||Duplex||2||1.0||7.0||32500.0||(44.9567603300828, -93.139762414751)||10.0||7.0||55.0||47.0||44.95676||-93.139762||2019-04-30||2019||2019-04-30|
|1||535 FOREST ST||04/26/2019 12:00:00 AM||Single Family Residential||2||7.0||4.0||34500.0||(44.957410404869, -93.061161243197)||15.0||2.0||196.0||42.0||44.95741||-93.061161||2019-04-26||2019||2019-04-26|
plt.figure(figsize=(10,6)) sns.set_style("darkgrid") #white, white-grid, ticks sns.distplot(df['Year'], kde=False).set_title("Current Vacant Buildings by Year of Vacancy")
Text(0.5, 1.0, 'Current Vacant Buildings by Year of Vacancy')
Commercial 65 Duplex 86 Mixed Use 7 Multi-family Residential 17 Single Family Residential 322 Name: Dwelling, dtype: int64
plt.figure(figsize=(10,6)) sns.distplot(df['District'], bins=17, vertical=True, kde=False).set_title("Current Vacant Buildings by District Council")
Text(0.5, 1.0, 'Current Vacant Buildings by District Council')
plt.figure(figsize=(10,6)) sns.distplot(df['Ward'], bins=17, vertical=True, kde=False).set_title("Current Vacant Buildings by Ward Grid")
Text(0.5, 1.0, 'Current Vacant Buildings by Ward Grid')
<Figure size 720x432 with 0 Axes>
CLick on dots to get more information; please zoom in
Legend: Vacant Year Range
Legend: Dwelling Type