While spreadsheets are valuable for data organization, mapping unlocks a deeper understanding. It reveals spatial distribution, concentration areas and empowers data-driven decisions with a geographic lens. Midpen’s Geographic Information Systems (GIS) team recently built two interactive dashboards to explore demographics and disadvantaged communities in California, allowing users to reveal and discover meaningful trends on a census tract level.
These dashboards are flexible tools that address an inherently spatial challenge. They are designed to work in concert with one another by synthesizing publicly available datasets across California. Those data are then displayed in a manner that is intuitive, interactive and location based.
“While we are primarily focused on the natural world, we exist of, by, and for people,” said project manager and GIS senior technologist Nathan Greig. “These tools help us better understand the constituents we serve and the communities we work in, which will in turn allow us to advocate more equitable funding opportunities.”
The Disadvantaged Communities Explorer allows users to compare different definitions of "disadvantaged communities," and which communities meet the criteria. These communities face economic, health or environmental burdens and are prioritized for funding. However, the criteria for defining these communities vary, making it difficult to understand how funding is allocated. This dashboard helps visualize the impact of these definitions.
The California Demographics Data Explorer centralizes demographic data like age, race and income. Users can filter by location and explore the data visually on a map. This helps users understand the needs of different communities. While the tools were created for Midpen, the dashboards are functional throughout the entire state, expanding their use.
“One of the foundational aspects of these tools is their availability beyond our jurisdiction,” explained Greig. “They have already been used by legislators of different bodies across the State and by outreach organizations to apply for funding in combatting homelessness.”
Midpen was awarded an Innovation Award from the California Society of Municipal Finance Officers.
Both dashboards are publicly available and allow users to gain insights and ask new questions. The data are updated annually to ensure relevance and accuracy.
By creating these tools, Midpen leverages technology to make data more accessible and useful for the public.