Water Quality - Effluent - Electronic Self-Monitoring Report (eSMR) Data
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.
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
2006-Present eSMR Analytical Data (Zipped CSV) 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. | Download | ZIP 355.26 MB | 02/02/24 |
2006-Present eSMR Analytical Data (Parquet Format) 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. | Download | ZIP 231.74 MB | 04/15/22 |
2024 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2024. | Download | CSV 503.69 MB | 02/02/24 |
2023 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2023. | Download | CSV 767.63 MB | 04/25/23 |
2022 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2022. | Download | CSV 747.00 MB | 02/04/22 |
2021 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2021. | Download | CSV 745.61 MB | 09/09/21 |
2020 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2020. | Download | CSV 751.59 MB | 09/09/21 |
2019 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2019. | Download | CSV 786.51 MB | 09/09/21 |
2018 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2018. | Download | CSV 755.40 MB | 09/09/21 |
2017 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2017. | Download | CSV 764.63 MB | 09/09/21 |
2016 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2016. | Download | CSV 752.06 MB | 09/09/21 |
2015 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2015. | Download | CSV 765.19 MB | 09/09/21 |
2014 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2014. | Download | CSV 788.05 MB | 09/09/21 |
2013 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2013. | Download | CSV 754.69 MB | 09/09/21 |
2012 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2012. | Download | CSV 705.60 MB | 09/09/21 |
2011 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2011. | Download | CSV 425.19 MB | 09/09/21 |
2010 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2010. | Download | CSV 128.07 MB | 09/09/21 |
2009 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2009. | Download | CSV 23.83 MB | 09/09/21 |
2008 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2008. | Download | CSV 9.01 MB | 09/09/21 |
2007 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2007. | Download | CSV 3.52 MB | 09/09/21 |
2006 eSMR Analytical Data Electronic Self-Monitoring Report (eSMR) data for samples taken in year 2006. | Download | CSV 1.53 MB | 09/09/21 |
More details
Statewide
Sampling event of a regulated discharge
English