The California Department of Water Resources (DWR) discrete (vs. continuous) water quality datasets contains DWR-collected, current and historical, chemical and physical parameters found in routine environmental, regulatory compliance monitoring, and special studies throughout the state.

irrigation

Water is the most precious and essential resource among all-natural resources. Some organism survives without oxygen and food such as Tardigrades. But no one can survive without water. The increase in the development of industries and human activities over the previous century is having an overwhelming impact on our environment. Most cities in the world have started to implement the aqua management system. The development of cloud computing, artificial intelligence, remote sensing, big data and the Internet of Things provide new opening and move toward the improvement and application of aqua resource monitoring system. For predicting water quality of rivers, dams and lakes in India, water quality parameter dataset is created. The name of the data set is Aquaattributes. Completely 1360 samples are presented in the Aquaattributes. The data set size is 190 KB. Attributes of the dataset location name along with its longitude and latitude values and water quality parameters.

Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, on the quantity of Europe's water resources, and on the emissions to surface waters from point and diffuse sources of pollution. The dataset contains time series of nutrients, organic matter, hazardous substances and other chemicals in rivers, lakes and groundwater, as well as data on biological quality elements (BQEs) such as phytobenthos and macroinvertebrates in rivers and lakes. A list of monitoring site identifiers with selected attributes, reported through WFD and WISE Spatial data reporting, is added to dataset as spatial reference. The data has been compiled and processed by EEA. Please refer to the metadata for additional information.

In 2015-2016, physicochemical properties and chemical characteristics of stream water, bed sediment, groundwater, and soil were determined in watersheds located outside of, but in proximity to, the Peason Ridge Training Area and Main Post at the Joint Readiness Training Center and Fort Polk boundaries to document background trace element concentrations. Water samples were analyzed for physicochemical properties, major inorganic ions, selected trace elements, and dissolved organic carbon. Selected trace elements included antimony, arsenic, cadmium, copper, iron, lead, manganese, mercury, and zinc. Stream bed-sediment and soil samples were analyzed for major inorganic ions, selected trace elements, and grain size distribution. Surface-water samples were collected near the downstream transect of each stream reach. Monitoring wells were located adjacent to the stream reach and in close proximity to the surface-water sampling sites. Bulk bed-sediment samples were collected during normal low-flow conditions. Each sample consisted of a composite sample from five locations (right edge, left edge, and center of a middle transect, then upstream and downstream of the middle transect) within each stream reach. Three soil samples, one from hilltops, one from side slopes, and one from riparian zones, were collected from areas adjacent to each stream reach. Each soil sample consisted of 5 to 10 grab samples collected by a 21-inch-long, 5/8-inch internal diameter stainless-steel hand auger and composited in Teflon lined pans. All samples were collected following USGS sampling protocols. This data release provides database and mapping information for assessment of trace element concentrations in stream water, bed sediment, groundwater, and soil found in relatively pristine and undisturbed watersheds in proximity to watersheds used for military training.

Long-term freshwater quality data from federal and federal-provincial sampling sites throughout Canada's aquatic ecosystems are included in this dataset. Measurements regularly include physical-chemical parameters such as temperature, pH, alkalinity, major ions, nutrients and metals. Collection includes data from active sites, as well as historical sites that have a period of record suitable for trend analysis. Sampling frequencies vary according to monitoring objectives. The number of sites in the network varies slightly from year-to-year, as sites are adjusted according to a risk-based adaptive management framework. The Great Lakes are sampled on a rotation basis and not all sites are sampled every year. Data are collected to meet federal commitments related to transboundary watersheds (rivers and lakes crossing international, inter-provincial and territorial borders) or under authorities such as the Department of the Environment Act, the Canada Water Act, the Canadian Environmental Protection Act, 1999, the Federal Sustainable Development Strategy, or to meet Canada's commitments under the 1969 Master Agreement on Apportionment.

The ZTRAX data is a national database of property sales collected by Zillow. The data is available to researchers who submit a research proposal to Zillow. Portions of this dataset are inaccessible because: Not publicly available. They can be accessed through the following means: Requires a data sharing agreement with Zillow. Format: National property sales database https://www.zillow.com/research/ztrax/. This dataset is associated with the following publication: Mamun, S., A. Castillo, K. Swedberg, J. Zhang, K.J. Boyle, D. Cardoso, C.L. King, C. Nolte, M. Papenfus, D. Phaneuf, and S. Polasky. Valuing water quality in the United States using a national dataset on property values. PNAS (PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES). National Academy of Sciences, WASHINGTON, DC, USA, 120(5): e2210417120, (2023).

Find data on drinking water quality in Massachusetts. This dataset shows drinking water exceedances for lead by Community Water System and year of exceedance in Massachusetts.

Context

Access to safe drinking-water is essential to health, a basic human right and a component of effective policy for health protection. This is important as a health and development issue at a national, regional and local level. In some regions, it has been shown that investments in water supply and sanitation can yield a net economic benefit, since the reductions in adverse health effects and health care costs outweigh the costs of undertaking the interventions.

Content

The water_potability.csv file contains water quality metrics for 3276 different water bodies.

1. pH value:

PH is an important parameter in evaluating the acid–base balance of water. It is also the indicator of acidic or alkaline condition of water status. WHO has recommended maximum permissible limit of pH from 6.5 to 8.5. The current investigation ranges were 6.52–6.83 which are in the range of WHO standards

2. Hardness:

Hardness is mainly caused by calcium and magnesium salts. These salts are dissolved from geologic deposits through which water travels. The length of time water is in contact with hardness producing material helps determine how much hardness there is in raw water. Hardness was originally defined as the capacity of water to precipitate soap caused by Calcium and Magnesium.

3. Solids (Total dissolved solids - TDS):

Water has the ability to dissolve a wide range of inorganic and some organic minerals or salts such as potassium, calcium, sodium, bicarbonates, chlorides, magnesium, sulfates etc. These minerals produced un-wanted taste and diluted color in appearance of water. This is the important parameter for the use of water. The water with high TDS value indicates that water is highly mineralized. Desirable limit for TDS is 500 mg/l and maximum limit is 1000 mg/l which prescribed for drinking purpose.

4. Chloramines:

Chlorine and chloramine are the major disinfectants used in public water systems. Chloramines are most commonly formed when ammonia is added to chlorine to treat drinking water. Chlorine levels up to 4 milligrams per liter (mg/L or 4 parts per million (ppm)) are considered safe in drinking water.

5. Sulfate:

Sulfates are naturally occurring substances that are found in minerals, soil, and rocks. They are present in ambient air, groundwater, plants, and food. The principal commercial use of sulfate is in the chemical industry. Sulfate concentration in seawater is about 2,700 milligrams per liter (mg/L). It ranges from 3 to 30 mg/L in most freshwater supplies, although much higher concentrations (1000 mg/L) are found in some geographic locations.

6. Conductivity:

Pure water is not a good conductor of electric current rather’s a good insulator. Increase in ions concentration enhances the electrical conductivity of water. Generally, the amount of dissolved solids in water determines the electrical conductivity. Electrical conductivity (EC) actually measures the ionic process of a solution that enables it to transmit current. According to WHO standards, EC value should not exceeded 400 μS/cm.

7. Organic_carbon:

Total Organic Carbon (TOC) in source waters comes from decaying natural organic matter (NOM) as well as synthetic sources. TOC is a measure of the total amount of carbon in organic compounds in pure water. According to US EPA < 2 mg/L as TOC in treated / drinking water, and < 4 mg/Lit in source water which is use for treatment.

8. Trihalomethanes:

THMs are chemicals which may be found in water treated with chlorine. The concentration of THMs in drinking water varies according to the level of organic material in the water, the amount of chlorine required to treat the water, and the temperature of the water that is being treated. THM levels up to 80 ppm is considered safe in drinking water.

9. Turbidity:

The turbidity of water depends on the quantity of solid matter present in the suspended state. It is a measure of light emitting properties of water and the test is used to indicate the quality of waste discharge with respect to colloidal matter. The mean turbidity value obtained for Wondo Genet Campus (0.98 NTU) is lower than the WHO recommended value of 5.00 NTU.

SA Water operate drinking water supplies across metropolitan, regional and remote Aboriginal communities within South Australia. They are extensively tested for health, aesthetic and operational related parameters from catchment to tap, with more than 350,000 analytical results produced annually. The monitoring program is very large. It enables us to assure the quality of our product. The program includes both field and laboratory tests. Trained field staff collect samples, so we know they are taken correctly and are of high quality. Our Laboratory analyses are carried out by the Australian Water Quality Centre (AWQC). The AWQC’s tests are run in line with ISO 9001 Quality Systems and the requirements of the National Association of Testing Authorities (NATA) SA Water consistently meets national water quality targets. Although SA Water aims for 100% compliance, the ADWG recognises that occasional exceedances may occur. Any exceedance requires immediate investigation and corrective action as agreed with SA Health. The following water quality performance results sheet compares the quality of your tap water over the last 12 months to the Australian Drinking Water Guidelines (2011) where applicable.

The Environmental Department releases river water quality monitoring data, including River Pollution Index (RPI) and monitored values of major pollutants. Due to the need for monthly on-site sampling, laboratory testing and data quality control procedures, monitoring data is usually provided every other month.

This is an observation data for water quality monitoring.

The Conagua page containing links to 2012-2019 surface and groundwater quality data, from 5000 monitoring sites in Mexico, available in XLS or KMZ files

The Water Quality Portal (WQP) is a cooperative service sponsored by the United States Geological Survey (USGS), the Environmental Protection Agency (EPA), and the National Water Quality Monitoring Council (NWQMC). It serves data collected by over 400 state, federal, tribal, and local agencies. Water quality data can be downloaded in Excel, CSV, TSV, and KML formats. Fourteen site types are found in the WQP: aggregate groundwater use, aggregate surface water use, atmosphere, estuary, facility, glacier, lake, land, ocean, spring, stream, subsurface, well, and wetland. Water quality characteristic groups include physical conditions, chemical and bacteriological water analyses, chemical analyses of fish tissue, taxon abundance data, toxicity data, habitat assessment scores, and biological index scores, among others. Within these groups, thousands of water quality variables registered in the EPA Substance Registry Service (https://iaspub.epa.gov/sor_internet/registry/substreg/home/overview/home.do) and the Integrated Taxonomic Information System (https://www.itis.gov/) are represented. Across all site types, physical characteristics (e.g., temperature and water level) are the most common water quality result type in the system. The Water Quality Exchange data model (WQX; http://www.exchangenetwork.net/data-exchange/wqx/), initially developed by the Environmental Information Exchange Network, was adapted by EPA to support submission of water quality records to the EPA STORET Data Warehouse [USEPA, 2016], and has subsequently become the standard data model for the WQP. Contributing organizations: ACWI The Advisory Committee on Water Information (ACWI) represents the interests of water information users and professionals in advising the federal government on federal water information programs and their effectiveness in meeting the nation's water information needs. ARS The Agricultural Research Service (ARS) is the U.S. Department of Agriculture's chief in-house scientific research agency, whose job is finding solutions to agricultural problems that affect Americans every day, from field to table. ARS conducts research to develop and transfer solutions to agricultural problems of high national priority and provide information access and dissemination to, among other topics, enhance the natural resource base and the environment. Water quality data from STEWARDS, the primary database for the USDA/ARS Conservation Effects Assessment Project (CEAP) are ingested into WQP via a web service. EPA The Environmental Protection Agency (EPA) gathers and distributes water quality monitoring data collected by states, tribes, watershed groups, other federal agencies, volunteer groups, and universities through the Water Quality Exchange framework in the STORET Warehouse. NWQMC The National Water Quality Monitoring Council (NWQMC) provides a national forum for coordination of comparable and scientifically defensible methods and strategies to improve water quality monitoring, assessment, and reporting. It also promotes partnerships to foster collaboration, advance the science, and improve management within all elements of the water quality monitoring community. USGS The United States Geological Survey (USGS) investigates the occurrence, quantity, quality, distribution, and movement of surface waters and ground waters and disseminates the data to the public, state, and local governments, public and private utilities, and other federal agencies involved with managing the United States' water resources. Resources in this dataset:Resource Title: Website Pointer for Water Quality Portal. File Name: Web Page, url: https://www.waterqualitydata.us/ The Water Quality Portal (WQP) is a cooperative service sponsored by the United States Geological Survey (USGS), the Environmental Protection Agency (EPA), and the National Water Quality Monitoring Council (NWQMC). It serves data collected by over 400 state, federal, tribal, and local agencies. Links to Download Data, User Guide, Contributing Organizations, National coverage by state.

Data DescriptionWater Quality Parameters: Ammonia, BOD, DO, Orthophosphate, pH, Temperature, Nitrogen, Nitrate.Countries/Regions: United States, Canada, Ireland, England, China.Years Covered: 1940-2023.Data Records: 2.82 million.Definition of ColumnsCountry: Name of the water-body region.Area: Name of the area in the region.Waterbody Type: Type of the water-body source.Date: Date of the sample collection (dd-mm-yyyy).Ammonia (mg/l): Ammonia concentration.Biochemical Oxygen Demand (BOD) (mg/l): Oxygen demand measurement.Dissolved Oxygen (DO) (mg/l): Concentration of dissolved oxygen.Orthophosphate (mg/l): Orthophosphate concentration.pH (pH units): pH level of water.Temperature (°C): Temperature in Celsius.Nitrogen (mg/l): Total nitrogen concentration.Nitrate (mg/l): Nitrate concentration.CCME_Values: Calculated water quality index values using the CCME WQI model.CCME_WQI: Water Quality Index classification based on CCME_Values.Data Directory Description:Category 1: DatasetCombined Data: This folder contains two CSV files: Combined_dataset.csv and Summary.xlsx. The Combined_dataset.csv file includes all eight water quality parameter readings across five countries, with additional data for initial preprocessing steps like missing value handling, outlier detection, and other operations. It also contains the CCME Water Quality Index calculation for empirical analysis and ML-based research. The Summary.xlsx provides a brief description of the datasets, including data distributions (e.g., maximum, minimum, mean, standard deviation).Combined_dataset.csvSummary.xlsxCountry-wise Data: This folder contains separate country-based datasets in CSV files. Each file includes the eight water quality parameters for regional analysis. The Summary_country.xlsx file presents country-wise dataset descriptions with data distributions (e.g., maximum, minimum, mean, standard deviation).England_dataset.csvCanada_dataset.csvUSA_dataset.csvIreland_dataset.csvChina_dataset.csvSummary_country.xlsxCategory 2: CodeData processing and harmonization code (e.g., Language Conversion, Date Conversion, Parameter Naming and Unit Conversion, Missing Value Handling, WQI Measurement and Classification).Data_Processing_Harmonnization.ipynbThe code used for Technical Validation (e.g., assessing the Data Distribution, Outlier Detection, Water Quality Trend Analysis, and Vrifying the Application of the Dataset for the ML Models).Technical_Validation.ipynbCategory 3: Data Collection SourcesThis category includes links to the selected dataset sources, which were used to create the dataset and are provided for further reconstruction or data formation. It contains links to various data collection sources.DataCollectionSources.xlsxOriginal Paper Title: A Comprehensive Dataset of Surface Water Quality Spanning 1940-2023 for Empirical and ML Adopted ResearchAbstractAssessment and monitoring of surface water quality are essential for food security, public health, and ecosystem protection. Although water quality monitoring is a known phenomenon, little effort has been made to offer a comprehensive and harmonized dataset for surface water at the global scale. This study presents a comprehensive surface water quality dataset that preserves spatio-temporal variability, integrity, consistency, and depth of the data to facilitate empirical and data-driven evaluation, prediction, and forecasting. The dataset is assembled from a range of sources, including regional and global water quality databases, water management organizations, and individual research projects from five prominent countries in the world, e.g., the USA, Canada, Ireland, England, and China. The resulting dataset consists of 2.82 million measurements of eight water quality parameters that span 1940 - 2023. This dataset can support meta-analysis of water quality models and can facilitate Machine Learning (ML) based data and model-driven investigation of the spatial and temporal drivers and patterns of surface water quality at a cross-regional to global scale.Note: Cite this repository and the original paper when using this dataset.

The City publishes an annual water quality report that meets the TCEQ's Consumer Confidence Report requirements. The report summarizes data collected on drinking water during a calendar year. Water samples are taken daily and tested for chemical, bacteriological and disinfectant residual contaminants. The samples are taken from various locations throughout the water plant’s production and distribution system. The report also documents any monitoring or testing violations of drinking water standards set by the EPA and the TCEQ

The federal Clean Water Act was established to restore and maintain the chemical, physical, and biological integrity of the nation's waters. Water quality standards have been established by federal and state governments to ensure that waterbodies attain their designated uses. Designated uses include human uses and ecological conditions: general aquatic life, trout, recreation, drinking water supply, industrial water supply, agricultural water supply, shellfish harvesting, and fish consumption.

As mandated by the Clean Water Act, surface water quality in all states is monitored and assessed every two years. During this time, government-employed scientists take samples of water at various waterbody sites and test them to determine whether or not that waterbody has attained its designated use(s). The designated use of general aquatic life is the most indicative of overall surface water quality and is the most comprehensively monitored across the region. Therefore, aquatic life is used as the indicator of regional water quality.

Water quality in Pennsylvania is assessed based on stream segments. Attainment (or lack of attainment) is determined by analyzing the health of aquatic macroinvertebrates (i.e. insect larvae, crayfish, clams, snails, worms) present in the stream. Pennsylvania's Department of Environmental Protection's (PADEP) assessment plan covers the entire state in 10-year increments. Interim evaluations are performed using targeted sampling in each of the state's major subwatersheds every two years. New Jersey Department of Environmental Protection (NJDEP), on the other hand, assigns attainment or lack of attainment to entire subwatersheds (land area). Similar to PADEP, this determination is based on in-stream sampling of macroinvertebrates. New Jersey's most recent report for 2014 is based on data collected between 2008 and 2012.

Since the two states do not report water quality data using the same criteria (stream miles in Pennsylvania versus acres of subwatershed in New Jersey), the percentage of non-attaining water(s) in each state is taken according to its preferred unit, and then the two percentages are averaged together to obtain a regional value.

Dataset

This dataset was created by Sanjila Tania

Contents

it is imperative to rely on dependable and extensive data. Therefore

This dataset contains a summary of the global data availability for 38 monitored water quality constituents, as described and used in: Jones et al 2024 Environ. Res. Lett. https://doi.org/10.1088/1748-9326/ad6919This includes information on the location (e.g. site_id, latitude, longitude, country_name), the database of origin (database), water quality constituent information (e.g. group, sub-group) and the number of daily measurements in the period 1980-2021.Additionally, the spatial and temporal distribution of water quality data per constituent are provided as Figures.