River water quality, raw data by site, 1975-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.

15059
400
Added
30 Mar 2017

This dataset was first added to MfE Data Service on 30 Mar 2017.

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. 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 regional council and NIWA monitored sites over the period 1975-2013. Fields are described as follows. Refer to Larned et al. 2015 for further details:
* nemarid ---- Unique NIWA ID
* lawaid ---- Unique LAWA ID
* rcid ---- Collection agency
* srcid ---- Region site is located in
* sflag ---- River (r) or Estuary (e)
* river ---- River name
* location ---- Name of site, assigned by collection agency
* nzmge ---- easting
* nzmgn ---- northing
* nzreach ---- REC1 segment identifier
* sdate ---- Sample date (yyyy-mm-dd)
* Q ---- Flow recorded when sample was taken (if available), cumecs
* npid ---- NIWA parameter ID (as used in Larned et al. 2015)
* lpid ---- LAWA parameter ID
* fdval ---- 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/Mo8VUY 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 53590
Data type Table
Row count 732014
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality, 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.

3032
59
Updated
15 Apr 2020

This dataset was last updated on MfE Data Service on 15 Apr 2020.

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

Table ID 99867
Data type Table
Row count 7988
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.

480
360
Updated
15 Apr 2020

This dataset was last updated on MfE Data Service on 15 Apr 2020.

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

6572
220
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

Water clarity trends, 2009–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.

5708
45
Added
11 Jan 2016

This dataset was first added to MfE Data Service on 11 Jan 2016.

Water clarity is a measure of underwater visibility in rivers and stream. Water clarity can be reduced by the presence of fine particles like silt, mud or organic material in the water. This affects the habitat and feeding of aquatic life like fish and aquatic birds. Water clarity is an important indicator of the health of a waterway, and is also a consideration for recreational activities like swimming and wading.
This dataset relates to the "River water quality trends: clarity" measure on the Environmental Indicators, Te taiao Aotearoa website.

Layer ID 52685
Data type Vector point
Feature count 722
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality trends, 2008–2017, 1998–2017, and 1990–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.

2075
27
Updated
15 Apr 2020

This dataset was last updated on MfE Data Service on 15 Apr 2020.

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

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

Dissolved Reactive phosphorus, 2009–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.

4966
46
Added
11 Jan 2016

This dataset was first added to MfE Data Service on 11 Jan 2016.

"Phosphorus is an essential nutrient for plant and animal life. Phosphorus can vary due to differences in land use, climate, elevation, and geology. 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 ""Geographic pattern of phosphorus in river water"" measure on the Environmental Indicators, Te taiao "

Layer ID 52696
Data type Vector point
Feature count 762
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

Water clarity, 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.

5138
41
Added
11 Jan 2016

This dataset was first added to MfE Data Service on 11 Jan 2016.

"Water clarity is a measure of underwater visibility in rivers and streams and can vary due to differences in land use, climate, elevation, and geology. Water clarity can be reduced by the presence of fine particles like silt, mud or organic material in the water. This affects the habitat and feeding of aquatic life like fish and aquatic birds. Water clarity is an important indicator of the health of a waterway, and is also a consideration for recreational activities like swimming and wading.
This dataset relates to the ""Geographic pattern of river water clarity"" measure on the Environmental Indicators, Te taiao Aotearoa website. "

Layer ID 52686
Data type Vector point
Feature count 77
Services Vector Query API, 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.

3905
130
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

Total phosphorus, 2009–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.

4617
53
Added
11 Jan 2016

This dataset was first added to MfE Data Service on 11 Jan 2016.

"Phosphorus is an essential nutrient for plant and animal life. Phosphorus can vary due to differences in land use, climate, elevation, and geology. 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 "Geographic pattern of phosphorus in river water" measure on the Environmental Indicators, Te taiao "

Layer ID 52737
Data type Vector point
Feature count 716
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 1 to 10 of 38