Identifying Municipally Owned Land Suitable for Affordable Housing Development

These R scripts and resulting map are an analysis of municipally owned and community land resources which could be leveraged for the development of affordable housing in the City of Atlanta.

The R scripts to complete the analysis are included as well as the R script to make our visualizations. The data used in this analysis can be found here or downloaded individually from the following resources:

• Transportation Cost
• Environmental Hazards
• Economic Mobility
• Grocery Data
• Job Access
• Park Proximity
• Bus Stop Proximity
• Train Station Proximity
• Tax Parcels
• Building Footprints

Identify which parcels in the City of Atlanta are owned by municipal organizations or community organizations

We aquired a list of ownership entities which are municipal organizations or community organizations. With that list of owners, we completed filtering of all tax parcels. This was completed using the grepl function to allow us to search for combinations of text strings. The tax parcel data is very messy so the filter function needed flexibility. Once this was complete, we used OpenRefine (should have done this initially) to clean and cluster the owners.

Create the 8 Factor Suitability Map

We used 8 data sources to create a suitability score for each parcel in the City of Atlanta. Each data source was converted to a Raster Image and all Raster Images were added together.

Extract Raster Values to tax parcels

Next we extracted the raster values to each identified tax parcel.