River water quality: Nitrogen, flow adjusted trends, 1991 - 2020

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

375
2
Added
11 Aug 2022

This dataset was first added to MfE Data Service on 11 Aug 2022.

Adapted by Ministry for the Environment and Statistics New Zealand to provide for environmental reporting transparency. Dataset used to develop the “River water quality: Nitrogen” indicator, (available at www.stats.govt.nz/indicators/river-water-quality-n...).

Nitrogen in river waters is one of five parameters that provide an overview of New Zealand’s river water quality and how it is changing over time. Nitrogen is an essential nutrient for plants and algae. Some nutrient supply is a natural component of healthy rivers, but agricultural and urban land use, and infrastructure such as wastewater treatment plants, can add more nitrogen to waterways. Too much nitrogen can lead to excessive growth of algae, which can deteriorate river habitats. In very high concentrations, some forms of nitrogen, including nitrate-nitrogen and ammoniacal nitrogen, can be toxic to aquatic life.

This dataset shows:

  • trends in concentrations of total nitrogen, nitrate-nitrite-nitrogen, and ammoniacal nitrogen based on measurements made at monitoring sites during the 10-year period from 2011 to 2020, the 20-year period from 2001 to 2020, and the 30-year period from 1991 to 2020.

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 environment.govt.nz/publications/environment-aotea....

Table ID 109657
Data type Table
Row count 25623
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality: Phosphorus, state, 2016 - 2020

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

381
2
Added
11 Aug 2022

This dataset was first added to MfE Data Service on 11 Aug 2022.

Adapted by Ministry for the Environment and Statistics New Zealand to provide for environmental reporting transparency. Dataset used to develop the "River water quality: phosphorus" indicator (available at www.stats.govt.nz/indicators/river-water-quality-p...).

Phosphorus in river waters is one of five parameters that provide an overview of New Zealand’s river water quality and how it is changing over time. Phosphorus is an essential nutrient for plants and is a natural component of healthy rivers. Agricultural and urban land use, and infrastructure such as wastewater treatments plants, can add more phosphorus to waterways, which can increase algae growth and biomass. This in turn causes deterioration of river habitats.

This dataset includes:

  • concentrations of total phosphorus (TP) and dissolved reactive phosphorus (DRP) measured at monitored sites, expressed as percentiles for the period of 2016–2020
  • a comparison of measured total phosphorus and dissolved reactive phosphorus concentrations at monitored sites with the proportion of human modified landcover in the upstream catchment area
  • how measured median total phosphorus and dissolved reactive phosphorus concentrations compare to the default guideline values in the Australian and New Zealand guidelines for fresh and marine water quality (ANZG, 2018), which indicates the risk of environmental impairment
  • measured dissolved reactive phosphorus concentrations compared to the National Objectives Framework (NOF) bands related to ecosystem health (MfE, 2020)

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 environment.govt.nz/publications/environment-aotea....

Table ID 109653
Data type Table
Row count 17184
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality, raw observations, 2013-2017

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

1996
9
Added
18 Aug 2021

This dataset was first added to MfE Data Service on 18 Aug 2021.

These data are the raw river water quality observations used to calculate state and trends for the period ending 2017.

It 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

More information on this dataset and how it relates to our environmental reporting indicators and topics can be found in the summary report available at www.mfe.govt.nz/publications/fresh-water/water-qua....

Note: This dataset has a large number of rows, which Microsoft Excel may not be able to fully open. A DBMS, statistical or GIS application is needed to view the entire dataset.

Table ID 105938
Data type Table
Row count 1198633
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality trends by monitoring site, 1989-2013

Licence

Creative Commons Attribution 3.0 New Zealand

You may use this work for commercial purposes.

You must attribute the creator in your own works.

8922
130
Added
29 Sep 2015

This dataset was first added to MfE Data Service on 29 Sep 2015.

River water quality water is valued for many reasons including ecological function and habitat, recreational value, its role in supporting people and industry, and its cultural significance. Nutrients such as nitrogen and phosphorus are essential for plant growth, however too much in rivers can lead to ‘nuisance’ growths of river algae and aquatic plants, degrading habitat. High concentrations in the form of ammoniacal nitrogen and nitrate-nitrogen can be toxic to fish and other aquatic animals. Water clarity is a measure of underwater visibility, and affects habitat of aquatic life such as fish and birds, and can also impact on aesthetic values and recreational use of rivers and streams.

Trend statistics and calculation results for the periods 1989-2013, 1994-2013, and 2004-2013 are provided by monitored site. Units for parameters are mg/m3, except CLAR (m). Refer to Larned at 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" measures on the Environmental Indicators, Te taiao Aotearoa website.

Table ID 52531
Data type Table
Row count 4148
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

Urban water quality - state - 2013–2015

Licence

Creative Commons Attribution 3.0 New Zealand

You may use this work for commercial purposes.

You must attribute the creator in your own works.

6985
34
Added
24 Apr 2017

This dataset was first added to MfE Data Service on 24 Apr 2017.

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.

Table ID 53597
Data type Table
Row count 379
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality, raw data by NRWQN site, 1989-2013

Licence

Creative Commons Attribution 3.0 New Zealand

You may use this work for commercial purposes.

You must attribute the creator in your own works.

11184
233
Added
29 Sep 2015

This dataset was first added to MfE Data Service on 29 Sep 2015.

River water quality water is valued for many reasons including ecological function and habitat, recreational value, its role in supporting people and industry, and its cultural significance. Nutrients such as nitrogen and phosphorus are essential for plant growth, however too much can lead to ‘nuisance’ growths of river algae and aquatic plants, degrading habitat. High concentrations in the form of ammoniacal nitrogen and nitrate-nitrogen can be toxic to fish and other aquatic animals. Water clarity is a measure of underwater visibility, and affects habitat of aquatic life such as fish and birds, and can also impact on aesthetic values and recreational use of rivers and streams. Escherichia coli (E.coli) can indicate the presence of pathogens (disease-causing organisms) from animal or human faeces, which can cause illness.

File contains raw data collected at NIWA monitored sites of the National River Water Quality Network (NRWQN) over the period 1989-2013. The NRWQN network is used to calculate national trends in river water quality. Fields are described as follows. Refer to Larned et al. 2015 for further details:
sID ---- Unique site ID
srcid ---- Region site is located in
sflag ---- River (r) or Estuary (e)
river ---- River name
location ---- Name of site
nzmge ---- easting
nzmgn ---- northing
NZReach ---- REC1 segment identifier
sDate ---- sample date
Q ---- Recorded flow when sample was taken, cumecs
npid ---- NIWA parameter ID (as used in Larned et al. 2015)
values ---- Parameter value (units are mg/m3, except CLAR (m) and ECOLI (n/100 mL))

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" measures on the Environmental Indicators, Te taiao Aotearoa website.

Table ID 52532
Data type Table
Row count 145039
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality modelled, state, 2013–2017

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

3769
601
Updated
22 Apr 2021

This dataset was last updated on MfE Data Service on 22 Apr 2021.

23 April 2021: A new version of this data set has been published. It includes data on 4 parameters (Ammoniacal nitrogen (adjusted), Escherichia coli, Macroinvertebrate Community Index and Total Phosphorus) that had been missing from the file that was published as part of the Our freshwater 2020 release in April 16 2020. The updated data set also includes data on DRP for all 593,337 REC segments, since the file from April 16 2020 only had data for 255,860 of these segments.

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...

Table ID 99871
Data type Table
Row count 5933730
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality: Macroinvertebrate community index, trends, 1991 - 2020

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

451
1
Added
11 Aug 2022

This dataset was first added to MfE Data Service on 11 Aug 2022.

Adapted by Ministry for the Environment and Statistics New Zealand to provide for environmental reporting transparency. Dataset used to develop the "River water quality: macroinvertebrate community index" indicator (available at www.stats.govt.nz/indicators/river-water-quality-m...).

Benthic macroinvertebrates are small animals without backbones (for example, 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. In turn, they are an important food source for fish and birds.

The macroinvertebrate community index (MCI) is used as an indicator of water quality and overall stream health. It is one of five parameters that provide an overview of New Zealand’s River water quality and how it is changing over time. This data shows

  • trends in median MCI scores for the 10-year period from 2011 to 2020, the 20-year period from 2001 to 2020, and the 30-year period from 1991 to 2020.

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 environment.govt.nz/publications/environment-aotea....

Table ID 109669
Data type Table
Row count 7376
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality: Macroinvertebrate community index, flow adjusted trends, 1991 - 2020

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

393
1
Added
11 Aug 2022

This dataset was first added to MfE Data Service on 11 Aug 2022.

Adapted by Ministry for the Environment and Statistics New Zealand to provide for environmental reporting transparency. Dataset used to develop the "River water quality: macroinvertebrate community index" indicator (available at www.stats.govt.nz/indicators/river-water-quality-m...).

Benthic macroinvertebrates are small animals without backbones (for example, 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. In turn, they are an important food source for fish and birds.

The macroinvertebrate community index (MCI) is used as an indicator of water quality and overall stream health. It is one of five parameters that provide an overview of New Zealand’s River water quality and how it is changing over time. This data shows:

  • trends in median MCI scores for the 10-year period from 2011 to 2020, the 20-year period from 2001 to 2020, and the 30-year period from 1991 to 2020.

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 atenvironment.govt.nz/publications/environment-aotea... .

Table ID 109671
Data type Table
Row count 7234
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

Predicted river water quality, 2009–13

Licence

Creative Commons Attribution 3.0 New Zealand

You may use this work for commercial purposes.

You must attribute the creator in your own works.

8787
143
Added
24 Apr 2017

This dataset was first added to MfE Data Service on 24 Apr 2017.

River water quality is valued for many reasons including ecological function and habitat, recreational value, its role in supporting people and industry, and its cultural significance. Nutrients such as nitrogen and phosphorus are essential for plant growth, however too much in rivers can lead to excessive growth of river algae, which can degrade habitat.

High concentrations of nitrogen in the form of ammoniacal nitrogen and nitrate-nitrogen can be toxic to fish and other aquatic animals, and nitrate-nitrogen can be toxic to humans. Water clarity is a measure of underwater visibility, and affects habitat of aquatic life such as fish and birds, and can also impact on aesthetic values and recreational use of rivers and streams. Escherichia coli (E.coli) can indicate the presence of pathogens (disease-causing organisms) from animal or human faeces, which can cause illness.

File contains the model outputs for river water quality indicators as medians for each river segment in New Zealand’s digital river network.

Table ID 53601
Data type Table
Row count 593444
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 11 to 20 of 31