Electronic Annual Report (eAR) Data for California Water Systems: Processing Scripts and Formatted Data Files

Authors:
Erik Porse
Owners: Erik Porse
  • Contributions
    Joined

Type: Resource
Storage: The size of this resource is 44.8 MB
Created: Oct 11, 2023 at 5:15 p.m.
Last updated: Oct 11, 2023 at 8:58 p.m.
Citation: See how to cite this resource
Sharing Status: Public
Views: 764
Downloads: 39
+1 Votes: Be the first one to 
 this.
Comments: No comments (yet)

Abstract

In California, water systems, submit annual operational data such as demographics, water production, water demand, and retail rates to the State Water Resources Control Board. The State Water Resources Control Board publishes data in a flat file text format (https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html) From 2013-2019, distinct data was published for small and large systems. Since 2020, data is combined in a single file.

This Hydroshare repository publishes user-friendly versions of the 2020-2022 eAR files, which were created to improve accessibility. Flat files of raw data were formatted to have all questions associated with a water system (PWSID) on one line. This allows for data to be viewed and analyzed in typical worksheet software programs.

This repository contains 1) Python script templates for parsing the 2020, 2021, and 2022 flat data files, and 2) the formatted eAR data files, saved as an Excel worksheet. There are separate Python scripts for parsing 2020 data and 2021/2022

Use of the script and files is permitted with attribution. Users are solely responsible for any issues that arise in using or applying data. If any errors are spotted, please contact the author.

Subject Keywords

Coverage

Spatial

Coordinate System/Geographic Projection:
WGS 84 EPSG:4326
Coordinate Units:
Decimal degrees
Place/Area Name:
California
North Latitude
42.1080°
East Longitude
-114.0820°
South Latitude
32.0751°
West Longitude
-125.7275°

Temporal

Start Date: 01/01/2020
End Date: 12/31/2022
Leaflet Map data © OpenStreetMap contributors

Content

    No files to display.

How to Cite

Porse, E. (2023). Electronic Annual Report (eAR) Data for California Water Systems: Processing Scripts and Formatted Data Files, HydroShare, http://www.hydroshare.org/resource/8108599db4934252a5d0e6e83b5d3551

This resource is shared under the Creative Commons Attribution CC BY.

 http://creativecommons.org/licenses/by/4.0/
CC-BY

Comments

There are currently no comments

New Comment

required