Clean Energy Grantee Mapper

Clean Energy Grant Mapper overview
Client:   JPB Foundation

Pushing for clean energy is vital to addressing climate change, and managing economic transformation in the U.S.  The JPB Foundation and other funders have supported a broad array of groups to work in states (and nationally) on clean energy program advocacy.  They asked GreenInfo to develop a web map application that lets funders, the grantees and others easily see who is doing what.

In 2015, President Obama and EPA announced the Clean Power Plan - a historic and important step in reducing carbon pollution from power plants that takes real action on climate change. The JPB Foundation's request to GreenInfo to map organizations being funded to work on state implementation plans (SIPs) came with a long and complicated spreadsheet of those grantees - our challenge was how to quickly parse this data into an application that could easily users show many views of it.

The spreadsheet was essentially a relational database - grantees had subgrantees, who were active in various states under various grants. Working with the JPB foundation's consultant, we worked out the relationships that needed to be shown and set up the spreadsheet in a web database that could manage the visualizations.

We also designed a mapping interface that built on another, similar project.  By allowing users to choose categories of views on top of the map, or click on a state directly, they could visualize the overall pattern of groups and funding - and topics - very quickly. 

Technically, this is a simple and very adaptable map that uses the D3 JavaScript library for rendering and interaction. We back that with some data-processing scripts that take source geography files in TopoJSON format and cross them with CSV data (like those saved out of Excel) to generate a composite JSON file that drives the map. This map could be quickly adapted to show other categories of data and other geometries (counties within a particular state, for example).




Focus:   Environment, Philanthropy  

Services:  Interactive Solutions, Applications Development, Web Mapping 

Tags:   energy, united states  

Project Years: 2016

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 604
Oakland
CA
94612
United States of America