River water quality trends, 2008–2017, 1998–2017 and 1990-2017 raw data

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

74
13
Added
16 Apr 2019

This item was first added to MfE Data Service on 16 Apr 2019

Document ID21950
File nameriver-water-quality-trends-20082017-19982017-and-1990-2017-raw-data.csv
TypeCSV
Size3.36 MB

River water quality trends, 2008–2017, 1998–2017 and 1990-2017 data quality

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

69
9
Added
16 Apr 2019

This item was first added to MfE Data Service on 16 Apr 2019

3
Document ID21948
File nameriver-water-quality-trends-20082017-19982017-and-1990-2017-data-quality.pdf
TypePDF
Size516 KB

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.

829
16
Added
16 Apr 2019

This dataset was first added to MfE Data Service on 16 Apr 2019.

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 9021
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality modelled state 2013–2017

Online
Only
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

427
92
Updated
31 May 2019

This dataset was last updated on MfE Data Service on 31 May 2019.

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/does not 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 5927520
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

RiverQ ecoli modelled mcdowell meet clean

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

56
3
Added
16 Apr 2019

This item was first added to MfE Data Service on 16 Apr 2019

Document ID21922
File nameriverq-ecoli-modelled-mcdowell-meet-clean.csv
TypeCSV
Size57.4 MB

WQ PredictionsDF REC2 29November 2018

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

49
1
Added
15 Apr 2019

This item was first added to MfE Data Service on 15 Apr 2019

Document ID21921
File namewq-predictionsdf-rec2-29november-2018.csv
TypeCSV
Size195 MB

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.

168
4
Added
15 Apr 2019

This dataset was first added to MfE Data Service on 15 Apr 2019.

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

2226
109
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

Urban water quality - all data - 1985–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.

1949
36
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 related to each sampling occasion by site for each water quality indicator in Auckland, Wellington, and Christchurch over the period 1985–15.

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

Urban stream water quality - trends - 2008–15

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.

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

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.

Table ID 53598
Data type Table
Row count 217
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 1 to 10 of 32