River water quality Data - Page 3

"Phosphorus is an essential nutrient for plant and animal life. Total phosphorus (TP) includes all concentrations in a sample, whether dissolved, in solid form or bound to sediment in the river. Dissolved reactive phosphorus (DRP) is the portion which is dissolved and can immediately support plant and algae growth. Excess phosphorus in our rivers can cause large amounts of (sometimes toxic) algae to grow, which can harm river health and reduce the recreational and aesthetic value of rivers.
This dataset relates to the "River water quality trends: phosphorus" measure on the Environmental Indicators, Te taiao "

Benthic macroinvertebrates are small animals without backbones (eg insects and worms). They live on and under submerged logs, rocks, and aquatic plants on the beds of rivers and streams during some part of their life cycle. Macroinvertebrates play a central role in stream ecosystems by feeding on periphyton (algae), macrophytes (aquatic plants), dead leaves and wood, or on each other. A high macroinvertebrate community index (MCI) indicates a high level of river health.

File contains trend statistics and calculation results for the period 2004-2013.

For more information please see:
Larned, S, Snelder, T, Unwin, M, McBride, G, Verburg, P, McMillan, H (2015).Analysis of Water Quality in New Zealand lakes and Rivers: data sources, data sets, assumptions, limitations, methods and results. NIWA Client Report no. CHC2015-033. Available at data.mfe.govt.nz/x/DDui3u from the Ministry for the Environment dataservice.

This dataset relates to the "River water quality: Benthic macroinvertebrates" measure on the Environmental Indicators, Te taiao Aotearoa website.

Urban water quality indicators include heavy metals, nutrients, and E.coli. The concentrations of these indicators are compared to the proportion of urban land cover in catchments.

Heavy metals have the ability to accumulate in sediments, shellfish, and other aquatic organisms. Metals can reach toxic levels in organisms making them unsafe to consume and can be toxic to aquatic life. Nutrients can cause excessive algal growth and E.coli has the ability to make people sick while they are swimming if concentrations are high enough. Rivers with poor water quality are rarely suitable for recreation and provide poor habitats for aquatic species.

File contains data related to each sampling occasion by site for each water quality indicator in Auckland, Wellington, and Christchurch over the period 1985–15.

Benthic macroinvertebrates are small animals without backbones (eg insects and worms). They live on and under submerged logs, rocks, and aquatic plants on the beds of rivers and streams during some part of their life cycle. Macroinvertebrates play a central role in stream ecosystems by feeding on periphyton (algae), macrophytes (aquatic plants), dead leaves and wood, or on each other. A high macroinvertebrate community index (MCI) indicates a high level of river health.

File contains state results for each monitored site, expressed as percentile calculations for the period 2009-2013. See Larned et al. 2015 for further details.

For more information please see:
Larned, S, Snelder, T, Unwin, M, McBride, G, Verburg, P, McMillan, H (2015).Analysis of Water Quality in New Zealand lakes and Rivers: data sources, data sets, assumptions, limitations, methods and results. NIWA Client Report no. CHC2015-033. Available at data.mfe.govt.nz/x/DDui3u from the Ministry for the Environment dataservice.

This dataset relates to the "River water quality: Benthic macroinvertebrates" measure on the Environmental Indicators, Te taiao Aotearoa website.

Urban water quality indicators include heavy metals, nutrients, and E.coli. The concentrations of these indicators are compared to the proportion of urban land cover in catchments.

Zinc and copper are heavy metals that can accumulate in sediments, shellfish, and other aquatic organisms. Metals can reach toxic levels in organisms making them unsafe to eat and can be toxic to aquatic life. Nitrogen and phosphorus are nutrients that can cause excessive algal growth. Ammonical nitrogen and nitrate-nitrogen can be toxic to aquatic life if concentrations in streams are high enough. E.coli is an indicator of disease-causing organisms, which may affect human health and recreational values in streams.

File contains trend analyses by site for water quality indicators in Auckland, Wellington, and Christchurch over the period 2008–15.

Urban water quality indicators include heavy metals, nutrients, and E.coli. The concentrations of these indicators are compared to the proportion of urban land cover in catchments.

Heavy metals have the ability to accumulate in sediments, shellfish, and other aquatic organisms. Metals can reach toxic levels in organisms making them unsafe to consume and can be toxic to aquatic life. Nutrients can cause excessive algal growth and E.coli has the ability to make people sick while they are swimming if concentrations are high enough. Rivers with poor water quality are rarely suitable for recreation and provide poor habitats for aquatic species.

File contains data analysis of medians and percentiles by site for water quality indicators, and includes the proportion of urban land cover in catchments in Auckland, Wellington and Christchurch over the period 2013–2015.

16 April 2020: Subsequent to publication in April 2019 we discovered two small errors with this dataset. These included:

• Errors in the coordinates of some sites and their associated metadata (such as landcover and elevation).
• Errors in our calculation of dominant landcover.

In addition, flow data from TopNet has also been updated.

These changes have a minor impact on overall results. These changes have have been corrected, and are republished here, as part of the Our freshwater 2020 release.

​

This dataset measures how water quality in New Zealand’s rivers is changing over time. It contains nine parameters of water quality based on measurements made at monitored river sites in years 1990-2017:

• Nitrate-nitrogen
• Ammoniacal nitrogen
• Total nitrogen
• Total phosphorus
• Dissolved reactive phosphorus
• Water clarity
• Turbidity
• Escherichia coli
• Macroinvertebrate community index

More information on this dataset and how it relates to our environmental reporting indicators and topics can be found in the attached data quality pdf.

Summary report available at www.mfe.govt.nz/publications/fresh-water/water-qua....

16 April 2020: Subsequent to publication in April 2019 we discovered two small errors with this dataset. These included:

• Errors in the coordinates of some sites and their associated metadata (such as landcover and elevation).
• Errors in our calculation of dominant landcover.

In addition, flow data from TopNet has also been updated.

These changes have a minor impact on overall results. These changes have have been corrected, and are republished here, as part of the Our freshwater 2020 release.

​

IMPORTANT INFORMATION

1) The main (cleaned) dataset is structured by each row having a nzsegment and np_id combination. A large dataset (~ 1 GB) has resulted, due to the inclusion of the ANZG/NOF columns and the 10 different np_id values. There are ~ 6 million rows to this dataset, however a 32-bit version of Microsoft Excel will only display/download ~ 1 million rows. A DBMS, statistical or GIS application is needed to view the entire dataset.

2) A smaller raw dataset (see attachments) is provided which structures each row relating to a river segment and drops the ANZG/NOF columns.

3) The attached metadata/date quality report provides further information on the NOF, ANZG and the "McDowell meet/doesnt meet" attachment.

​

This dataset contains ten parameters of water quality based on measurements made at monitored river sites:

• Nitrate-nitrogen
• Ammoniacal nitrogen
• Ammoniacal nitrogen (adjusted)
• Total nitrogen
• Total phosphorus
• Dissolved reactive phosphorus
• Water clarity
• Turbidity
• Escherichia coli
• Macroinvertebrate community index These parameters are used to measure:
• Modelled median values for all of New Zealand’s river length for the period 2013 to 2017
• For selected indicators, how the modelled values compare to the National Objectives Framework (NOF) (MfE, 2017) bands related to ecosystem health and human health for recreation, and to expected concentrations in natural conditions, as shown by the default guideline values in the Australian and New Zealand guidelines for fresh and marine water quality (ANZG, 2018)

More information on this dataset and how it relates to our environmental reporting indicators and topics can be found in the attached data quality pdf.

Summary report available at www.mfe.govt.nz/publications/fresh-water/spatial-m...

16 April 2020: Subsequent to publication in April 2019 we discovered two small errors with this dataset. These included:

• Errors in the coordinates of some sites and their associated metadata (such as landcover and elevation).
• Errors in our calculation of dominant landcover.

In addition, flow data from TopNet has also been updated.

These changes have a minor impact on overall results. These changes have have been corrected, and are republished here, as part of the Our freshwater 2020 release.

​

This dataset contains ten parameters of water quality based on measurements made at monitored river sites:

• Nitrate-nitrogen
• Ammoniacal nitrogen
• Ammoniacal nitrogen (adjusted)
• Total nitrogen
• Total phosphorus
• Dissolved reactive phosphorus
• Water clarity
• Turbidity
• Escherichia coli
• Macroinvertebrate community index

This dataset includes:

• Median values for the period 2013 to 2017
• for selected indicators, how these values compare to the National Objectives Framework (NOF) (MfE, 2017) bands related to ecosystem health and human health for recreation, and to expected concentrations in natural conditions, as shown by the default guideline values in the Australian and New Zealand guidelines for fresh and marine water quality (ANZG, 2018)

More information on this dataset and how it relates to our environmental reporting indicators and topics can be found in the attached data quality pdf.

Summary report available at www.mfe.govt.nz/publications/fresh-water/water-qua....