Presented by:


Jennifer Scheuerell

Sound Data
No video of the event yet, sorry!

For the last two years, Sound Data has been developing a PostgreSQL + Django application for the California Public Utility Commission (CPUC) to securely manage their $1B per year investment in energy efficiency and demand side management. The application is known as the California Energy Data and Reporting System (Cedars), and manages data reporting for three different reporting requirements for program administrators. Each of the three reporting requirements is a module within Cedars; the CPUC required all modules be robust to changes in the data specification over time, per the organization change management protocol.

The first Cedars module, the claims module, enables data processing and quality assurance for energy efficiency and demand side response accomplishment data; prior to Cedars, the CPUC spent $40K per month to manually process and quality check those data. Following the claims module, the filings module was added to enable data processing and assure quality for program administrator budget applications. We recently finished the third module to process and assure quality for program administrator monthly reports.

Cedars includes API integration with other CPUC servers, one of which is an Ubuntu - Windows integration. The first API integration pulls value list data from the Database of Energy Efficiency Resources (DEER) and the Cost Effectiveness Tool (CET) servers to enforce data validation rules as part of the data processing quality assurance. The second integration is with CET server, for the integration Cedars sends data inputs to the CET server and receives back calculated outputs.

2017 November 14 11:40
50 min
PGConf Local: Seattle