Analysis

Continuing with the proposal mentioned above, a map of all the County service requests based on vacant properties was developed. The data was obtained from WPRDC website and Carto was used for the visualization. Some significant insights were revealed from this. In module 2, it was shown that the Hill District had a high proportion of houses in poor condition. However, this new map showed just 8 Service requests made in 2017.

This data had to be Geocoded based on address. As the addresses were in two different columns, they were first ‘merged’ before a complete street address was formed to be used in geocoding.