Wolfram Computation Meets Knowledge

California Urban Water Supplier Monitoring Reports

Monthly reports of the larger urban water suppliers in California on water production and conservation activities, from the State of California's Drinking Water Information Clearinghouse (DRINC)

Originator: California State Water Resource Control Board

The data is published by California State Water Resource Control Board, which is an organization to preserve, enhance, and restore the quality of California's water resources and drinking water for the protection of the environment, public health, and all beneficial uses, and to ensure proper water resource allocation and efficient use, for the benefit of present and future generations. The dataset contains the water consumption report both in local units and converted units (gallons).

Examples

Basic Examples

Retrieve the resource:

In[1]:=
ResourceObject["California Urban Water Supplier Monitoring Reports"]
Out[1]=

Retrieve the default content:

In[2]:=
ResourceData["California Urban Water Supplier Monitoring Reports"]
Out[2]=

Plot the monthly production of a single supplier:

In[3]:=
DateListPlot[
 Select[ResourceData[
    "California Urban Water Supplier Monitoring Reports"], #PWSID == 
     "CA4910002" &][
  All, {"ReportingMonth", 
   "ProductionReported"}], {#ReportingMonth, #ProductionReported} &]
Out[3]=

Identify the 5 largest water producers in April 2018:

In[4]:=
TakeLargestBy[
 Select[ResourceData[
   "California Urban Water Supplier Monitoring Reports"], \
#ReportingMonth == 
    DateObject[{2018, 4, 15}] &], #ProductionReported &, 5]
Out[4]=

Wolfram Research, "California Urban Water Supplier Monitoring Reports" from the Wolfram Data Repository (2018) 

Data Resource History

Source Metadata

Data Downloads

Publisher Information