FT Crusader Logo

Saint Paul, MN, Vacant Building Report; 12/15/19

By Abu Nayeem aka Frogtown Crusader

Introduction

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.

Data

This dataset contains all of the registered vacant buildings in the City, as well as their type, and Vacant Building Category.

In [32]:
df.head(2)
Out[32]:
Address VacantDate Dwelling Vacant_Building_Category Ward District Census_Tract Coordinates DistrictCouncilMap CouncilWard Gunk1 Gunk2 Latitude Longitude Datetime Year Date
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

Vacant Buildings by Year Plot

In [20]:
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")
Out[20]:
Text(0.5, 1.0, 'Current Vacant Buildings by Year of Vacancy')

Vacant Buildings Types

In [4]:
print(df['Dwelling'].value_counts().sort_index(level=1))
Commercial                    65
Duplex                        86
Mixed Use                      7
Multi-family Residential      17
Single Family Residential    322
Name: Dwelling, dtype: int64

Vacant Buildings Broken Down by District Council

In [21]:
plt.figure(figsize=(10,6))

sns.distplot(df['District'], bins=17, vertical=True, kde=False).set_title("Current Vacant Buildings by District Council")
Out[21]:
Text(0.5, 1.0, 'Current Vacant Buildings by District Council')

Vacant Dwellings Categories broken down by District

In [6]:
barplot('District',12,9)

Vacant Buildings Broken Down by Ward

In [22]:
plt.figure(figsize=(10,6))
sns.distplot(df['Ward'], bins=17, vertical=True, kde=False).set_title("Current Vacant Buildings by Ward Grid")
Out[22]:
Text(0.5, 1.0, 'Current Vacant Buildings by Ward Grid')
In [23]:
plt.figure(figsize=(10,6))
barplot('Ward',7,7)
<Figure size 720x432 with 0 Axes>

Interactive Saint Paul Vacant Buildings Map by Year Range

CLick on dots to get more information; please zoom in

Legend: Vacant Year Range

  • Red: Earlier than 2013
  • Orange: 2013 to 2015
  • Brown: 2016
  • Blue: 2017
  • Green: 2018 to present
In [24]:
map_Vacancy_byYear()
Out[24]:

Saint Paul Interactive Vacant Buildings by Dwelling Type

Legend: Dwelling Type

  • Red: Mixed Use
  • Orange: Duplex
  • Brown: Commercial
  • Blue: Multi-Family
  • Green: Single Family
In [25]:
map_Vacancy_TypeWard()
Out[25]: