Water Quality - Effluent - Electronic Self-Monitoring Report (eSMR) Data

Description

Wastewater discharges are regulated by the Water Board. Those regulated are generally required to submit Self-Monitoring Reports to the State or Regional Water Board. Some dischargers submit their reports through the electronic Self-Monitoring Report (eSMR) module of the California Integrated Water Quality System (CIWQS). Generally these are for discharges into surface waters regulated by an individual National Pollutant Discharge Elimination System (NPDES) permit, though other dischargers may be included in this dataset as well. This dataset are the monitoring results that have been submitted as data points after the submitters have been approved for electronic submittals (i.e. after the "all electronic date"). Note that this dataset does not include records where the sampling date falls outside of the years shown below. The excluded records include: records where the sampling date is missing, records where the sampling date is invalid (e.g., records with sampling dates in the future or unreasonably far in the past), and records for samples taken prior to year 2006. The excluded records represent approximately 0.1% of all records in the complete eSMR dataset.

Resources

Name Format Description Link
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2009. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/3607ae5c-d479-4520-a2d6-3112cf92f32f/download/esmr-analytical-export_year-2009_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2022. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/8c6296f7-e226-42b7-9605-235cd33cdee2/download/esmr-analytical-export_year-2022_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2012. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/67fe1c01-1c1c-416a-92e1-ee8437db615a/download/esmr-analytical-export_year-2012_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2010. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/4eb833b3-f8e9-42e0-800e-2b1fe1e25b9c/download/esmr-analytical-export_year-2010_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2013. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/8fefc243-9131-457f-b180-144654c1f481/download/esmr-analytical-export_year-2013_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2011. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/c495ca93-6dbe-4b23-9d17-797127c28914/download/esmr-analytical-export_year-2011_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2024. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/7adb8aea-62fb-412f-9e67-d13b0729222f/download/esmr-analytical-export_year-2024_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2023. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/65eb7023-86b6-4960-b714-5f6574d43556/download/esmr-analytical-export_year-2023_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2020. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/4fa56f3f-7dca-4dbd-bec4-fe53d5823905/download/esmr-analytical-export_year-2020_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2017. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/44d1f39c-f21b-4060-8225-c175eaea129d/download/esmr-analytical-export_year-2017_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2015. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/81c399d4-f661-4808-8e6b-8e543281f1c9/download/esmr-analytical-export_year-2015_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2014. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/c0f64b3f-d921-4eb9-aa95-af1827e5033e/download/esmr-analytical-export_year-2014_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2008. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/c0e3c8be-1494-4833-b56d-f87707c9492c/download/esmr-analytical-export_year-2008_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2007. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/7b99f591-23ac-4345-b645-9adfaf5873f9/download/esmr-analytical-export_year-2007_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2006. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/763e2c90-7b7d-412e-bbb5-1f5327a5f84e/download/esmr-analytical-export_year-2006_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2018. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/bb3b3d85-44eb-4813-bbf9-ea3a0e623bb7/download/esmr-analytical-export_year-2018_2024-05-08.csv
57 This resource contains a single zipped csv file that includes all of the eSMR analytical data from 2006 through present. The data is identical to that contained in the csv files for individual years, and is included here as a faster option for users who want a bulk download of all of the eSMR data made available on the open data portal. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/9146a0f0-cee1-4088-acd2-c1e870da52df/download/esmr-analytical-export_years-2006-2024_2024-05-08.zip
57 This resource contains a zipped set of files in the Apache Parquet file format (see: **https://parquet.apache.org/**), which include all of the eSMR analytical data from 2006 through present, partitioned by region (the [California Water Board Region](https://www.waterboards.ca.gov/waterboards_map.html) where the sampling site is located) and year (the calendar year in which the sample was taken). Parquet is a free and open source data storage format that allows for fast and efficient processing of large datasets. It is compatible with a variety of data analysis platforms, including the R and Python programming languages, through the Apache Arrow platform (see: **https://arrow.apache.org/**). See **[here](https://gist.github.com/daltare/d76d63360050810f99ae8d7a6b4d1443)** for an example showing how to use this dataset with the R programming language. The data in this dataset is essentially identical to that contained in the csv files for the individual years (with the exception that missing values in numeric and date fields are encoded as "NA" rather than "NaN" or empty text strings), and is included here as an alternative option for for users who want a bulk download of all of the eSMR data made available on the open data portal. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/cce982b3-719f-4852-8979-923c3a639a25/download/esmr-analytical-export_years-2006-2024_parquet_2024-05-08.zip
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2021. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/28d3a164-7cec-4baf-9b11-7a9322544cd6/download/esmr-analytical-export_year-2021_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2019. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/2eaa2d55-9024-431e-b902-9676db949174/download/esmr-analytical-export_year-2019_2024-05-08.csv
8 Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2016. https://data.ca.gov/dataset/203e5d1f-ec9d-4d07-93aa-d8b74d3fe71f/resource/aacfe728-f063-452c-9dca-63482cc994ad/download/esmr-analytical-export_year-2016_2024-05-08.csv

Tags

  • monitoring-data
  • effluent-data
  • water
  • self-monitoring-reports
  • regulatory

Topics

Categories