This map showcases data and stories related to low-income housing by state legislative district in Washington State. It is a joint project YWCA of King, Pierce, and Snohomish and the Washington Low Income Housing Alliance.
View the live map.
It's a statically loaded page that displays legislative district polygons stored as static GeoJSON. Additional attributes are joined to each legislative district from two sources:
-
A static JSON file that contains related data on the counties that intersect each legislative district. This was produced using the array_to_json() function in a local PostgreSQL instance.
-
A Google Sheet published as JSON that contains 'Story' text and media. This was done so non-technical staff users could easily and securely add stories and associated media it is gathered over the course of the coming year. I manually inspected the object to grab the fields I wanted to use. However, I discovered Tabletop.js after completing my version and would probably use that instead if using Google Sheets as an easy-to-use-and-permission tiny backend in the future.