Local news site Hoodline asked us to help them tell stories with the amazing data that they’re collecting about the San Francisco. Our first public collaboration working with the team at Hoodline visualized their data on retail vacancies in the Castro.

There wasn’t a comprehensive list of vacancies available anywhere. So Hoodline went out and walked the neighborhood, and “defined any Castro property as vacant if we couldn’t walk in the door and purchase a good, service, or experience.”

Hoodline took this one step further by providing the underlying data for download. With the 2015 study as a baseline, they were able to provide a comparative analysis of what the neighborhood was a few years ago, and what’s in store for the future. We also took a look at the Castro’s mix of businesses relative to other neighborhoods, like the Haight and Valencia Street.