Drinking Water - Public Water System Annually Reported Water Production and Delivery Information

Description

Public Water Systems (PWS) submit their annual inventory information using the Electronic Annual Report (EAR) submission process on the Drinking Water Information Clearinghouse (DRINC) portal, which is reviewed, and manually updated into the Safe Drinking Water Information System (SDWIS). This is self-reported by PWS.

Resources

Name Format Description Link
8 <p>This is a curated dataset that derives from the PWS data submitted in their annual inventory information using the <a href="https://drinc.ca.gov/drinc/">DRINC Portal</a> - EAR module - for the years 2013 through 2016. This data in the EAR is self-reported by PWS. The EAR* data in this dataset includes some data that appears to have not been reported correctly - in some cases the units were missing, in other cases the units were wrong, and in even other cases the numbers just look to be irrational. The dataset in this resource includes some adjustments to units, in some cases. In cases where a record unit has been changed the field "UNIT ADJUSTED BY OIMA?" will indicate what was the adjustment, or "NO CHANGES," if there were no changes made. And if a change was made the original units (or lack of units) remain and new units are in the field named, "WATER PRODUCED Water.Units REVIEWED BY OFFICE OF INFORMATION MANAGEMENT AND ANALYSIS." We estimate that changes were made to less than 3% of the records.</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/8e57923d-d9dc-40f5-9823-d4f09f5e18b0/download/produced-water-public-water-system-reported-in-the-electronic-annual-report-ear-2013-2016.csv
33 <p>This is the template to be used with the dataset and data dictionary for Table 4 specific to LWS.</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/9ffae5da-f7db-4f5a-90f3-d18321803045/download/large-water-system-lws-ear-template-2016-reporting-year.pdf
33 <p>This is the template to be used with the dataset and data dictionary for Table 5 specific to SWS.</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/fe83212e-b6ee-4843-a26d-7da1c4dc7937/download/small-water-system-sws-ear-template-2016-reporting-year.pdf
33 produced-water-data-dictionary.pdf https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/bdd4a2bd-9ece-44fa-b7ea-ebbf73663243/download/produced-water-data-dictionary.pdf
33 <p>Monthly Water Delivery Reported by Water Suppliers in the Electronic Annual Reports (2013-2016)</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/faa10cbc-d231-406d-8e37-dd925bd18c44/download/delivered-water-data-dictionary.pdf
53 <p>This is the 2016 EAR data that is self reported and includes more than produced and delivered water data.</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/155afc1a-6d41-422c-8831-3200c40f26dc/download/2016-ear-self-reported-data-all-raw.xlsx
8 <p>This is a curated dataset that derives from the PWS data submitted in their annual inventory information using the DRINC Portal - EAR module - for the years 2013 through 2016. This data in the EAR is self-reported by PWS. The EAR* data in this dataset includes some data that appears to have not been reported correctly - in some cases the units were missing, in other cases the units were wrong, and in even other cases the numbers just look to be irrational. The dataset in this resource includes some adjustments to units, in some cases. In cases where a record unit has been changed the field "UNIT ADJUSTED BY OIMA?" will indicate what was the adjustment, or "NO CHANGES," if there were no changes made. And if a change was made the original units (or lack of units) remain and new units are in the field named, "WATER PRODUCED Water.Units REVIEWED BY OFFICE OF INFORMATION MANAGEMENT AND ANALYSIS." We estimate that changes were made to less than 3% of the records.</p> https://data.ca.gov/dataset/fdaf48c9-66d7-405c-806f-e1e427d552ef/resource/0563cbaf-c960-42a1-ae7f-f8e73c88904b/download/delivered-water-public-system-water-reported-in-the-electronic-annual-report-ear-2013-2016.csv

Tags

  • public-water-system
  • drinking-water
  • operations
  • public-health
  • ear

Topics

Categories