Skip to content

Latest commit

 

History

History
207 lines (90 loc) · 7.56 KB

owrs_analysis.md

File metadata and controls

207 lines (90 loc) · 7.56 KB
title output
California Water Rate Survey Results 2017
html_document pdf_document
keep_md
true
default

Introduction

The California Data Collaborative ("CaDC") is a coalition of water utilities that have pioneered a new data infrastructure non-profit 501 (c) (3) to support water managers in meeting their reliability objectives and serve the public good.

One important contribution of the CaDC was to establish a standard format and to provide the infrastructure for storage and maintainance of an open database for water rates, facilitating the work of analysts, economists and software developers interested in analyzing and understanding the differences in water rate structures and prices across many different agencies and locations. The water rate structures were organized in Open-Water-Rate-Specification (OWRS) files, a format based on YAML, which is designed to be easy to store, transmit, and parse in any programming language while also being easy for humans to read.

This report presents a summary of the types of analyses and insights that can be obtained from analyzing the OWRS, especially when this information is combined with the water consumption data from water agencies and Census Data.

Data

This report provides the combined analysis of data from 4 different sources:

  • Water Rates from the Open-Water-Rates-Specification.
  • Water Consumption data reported by the water agencies [ADD MORE DETAIL]
  • Demographic Data from the American Community Survey [??]
  • Qualitative Data from a Survey realized by the California Data Collaborative with water agencies in 2017.

Load suppliers report info and join with the Utilities list from the OWRS files

Analysis Using Customized Usage Benchmarks from Supplier Report

Summary Statistics

This section discusses general characteristics of the rates for utilities analyzed in this survey.

Figure  1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure 1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure  1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure 1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure  1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure 1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure  2: Average bill by parts for all agencies, considering a consumption of 10 CCF in a month. The average total bill is $60.68. With an average service charge (fixed) of $24.63 (40.6%) and an average commodity charge (variable) of $35.61 (58.7%).

Figure 2: Average bill by parts for all agencies, considering a consumption of 10 CCF in a month. The average total bill is $60.68. With an average service charge (fixed) of $24.63 (40.6%) and an average commodity charge (variable) of $35.61 (58.7%).

Figure  1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure 1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure  1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Figure 1: Bill Frequency Pie Chart. About three quarters of the water agencies use a monthly billing system.

Variation in Bills at Different Use Levels

Interaction between Rates and Efficiency

Joining Data from the Qualitative Survey

Affordability

Analysis Using 15 CCF Usage Benchmark for comparison with previous years

Summary Statistics

This section discusses general characteristics of the rates for utilities analyzed in this survey.

Figure  2: Average bill by parts for all agencies, considering a consumption of 10 CCF in a month. The average total bill is $60.68. With an average service charge (fixed) of $24.63 (40.6%) and an average commodity charge (variable) of $35.61 (58.7%).

Figure 2: Average bill by parts for all agencies, considering a consumption of 10 CCF in a month. The average total bill is $60.68. With an average service charge (fixed) of $24.63 (40.6%) and an average commodity charge (variable) of $35.61 (58.7%).

Interaction between Rates and Efficiency

Joining Data from the Qualitative Survey

Affordability