UWDtap

What is UWDtap?

UWDtap connects four distinct water reporting datasets to allow users to download and compile urban water data across California State Department of Water Resources (DWR) and California State Water Resources Control Board (SWRCB) reporting requirements with a single function call. UWDtap pulls data from the following reports:

Many retail and wholesale water agencies across California are required to submit these reports to DWR and SWRCB. To access and use data, a user must download many excel or text files from four distinct web portals. UWDtap makes data across these four urban water reports easily accessible and interoperable. UWDtap provides the groundwork for innovative analysis that could be used to support data driven decision making, the development of dashboards and data visualizations, and also provides a helpful tool that could be used for data quality checks. The goal of this package is to provide a service that pulls data and performs basic standardization for analysis ready data.

Installation 

remotes::install_github("flowwest/UWDtap")

Basic Usage

UWDtap exposes several useful functions to pull and visualize data urban water reporting data. The main function in the package is pull_data(),

# download data from all reporting requirements for 2020
urban_water_data <- pull_data(year_selection = 2020)

The data returned,

Summarize these data across all years for a specific category and report,

# summarize data from all reporting requirements for total demand
demand_summary <- pull_data_summary(category_selection = "demand total")

The data returned,

Visualize these data for a specific category and pwsid,

urban_water_data |> 
    plot_data(data = data, category_selection = "demand", 
          pwsid_selection = "CA0710001")

Note: The package does not QA/QC data. It does preform basic mapping of fields so that data can be compared across reports.