Housing Needs Dashboard for All California Counties

PDF report
Client:   California Housing Partnership

Each year, the California Housing Partnership produces 58 variations of a housing needs report for every county in California, helping local affordable housing advocates make the case for funding housing in their communities. They came to GreenInfo for help in designing and developing a new set of PDFs that could be generated automatically, and use the same data to power an interactive dashboard.

First we developed refined and simplified new PDF report designs based on the existing manually produced reports, and then over many iterations we developed the scripted automation processes to reliably produce presentation-quality PDFs from spreadsheet data.

At the same time, we repurposed the visual language, the data, and the chart types for interactive versions, which additionally provide historic views and other web-only slices of the data. The web dashboard also allows for almost infinite comparisons between counties across a range of metrics.

Between the highly polished PDF downloads and the fully custom interactive charts, users can find what they need to understand housing needs across California and to make the case for funding those needs.

We developed the charting with Highcharts.js and built the application on the Django application framework, using Python to batch generate the PDFs.

Focus:   Economic Development, Social Justice/Equity  

Services:  Interactive Solutions, Communications, Graphic Design, Applications Development, Website Design 

Project Years: 2020

GreenInfo Network creates, analyzes, visualizes and communicates information in the public interest. We specialize in mapping and related technology for nonprofits and public agencies, focusing on using it for conservation, social equity, public health, environment and foundation grant making.
2201 Broadway, Suite M5
United States of America