The California Data Collaborative (“CaDC”) had a great quarterly workshop at Metropolitan Water District this Tuesday! Please see here for presentations from that workshop.
During the morning, the CaDC steering committee also had very productive conversations with the exciting new USC Sustainability Solutions Center and discussed the latest analytical results from SCUBA.
The next CaDC workshop will be held April 30th at Inland Empire Utilities Agency. There have also been important updates on the CaDC’s open data work. Please see below for the latest on open water rates.
Open Water Rate Technology Ecosystem Update
The Open Water Rate ecosystem powered the 2017 CA-NV AWWA water rate survey and has data for 418 CA water utilities (and 3 utilities outside of the state). This technology won the “moonshot” award at the 2018 water data challenge put on by the two state water agencies and Gov Ops.
What does “Open Water Rates” mean?
The Open Water Rate Specification provides a standardized, machine readable and flexible data format. This means the data can accurately specify any type of water rate structure (including volumetric to tiered rate structures to water budgets). These data are made publicly available in a centralized location for analysts, researchers, and others to access.
What benefits do Open Water Rates provide?
The integrated technology ecosystem powers several tools of benefit to the California water community. Those include:
Bill Calculator -- a customer facing tool that show what a bill would be under different usage volumes.
Rate Comparison -- a water manager planning tool showing the impact of a rate shift on revenue and typical customer bills.
OWRS Analysis -- trends analyzing water rate changes across the industry used in the 2017 CA-NV AWWA report.
How are Open Water Rate data collected and curated?
The Open Water Rate data was collected as part of the 2017 rate survey of the California - Nevada Section American Water Works Association.
A web-based survey tool is used to input water rate information, convert this information into the standard Open Water Rate Specification format, and submit this data to a central database. All submissions to the database are checked for quality and accuracy by comparing against available Prop 218 notices before becoming part of the official record.
The diagram below summarizes the various pieces of open source technology that power the open water rate ecosystem.