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.

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

2449
32
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

Groundwater quality, trend, 1999-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.

677
23
Added
07 Apr 2020

This dataset was first added to MfE Data Service on 07 Apr 2020.

This indicator measures groundwater quality in New Zealand’s aquifers and how it is changing over time, based on measurements made at monitored sites. We report on nitrate-nitrogen, ammoniacal nitrogen, dissolved reactive phosphorus, chloride, conductivity and Escherichia coli (E. coli) including:

  • trends in concentrations for 10-year (2009–18) and 20-year (1999–2018) periods.

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.

Table ID 104571
Data type Table
Row count 1699
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

Nitrate leaching from livestock time series 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.

3327
45
Added
16 Apr 2019

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

We report on trends in nitrate-nitrogen from livestock that has leached from soil per year across New Zealand since 1990.

Nitrogen is an essential nutrient for plant growth. It occurs naturally, but in agricultural systems more nitrogen is commonly added to soils as fertiliser or as urine or dung from livestock. Not all the additional nitrogen can be used by plants and microorganisms, so some nitrate-nitrogen may leach (drain) from the soil. Livestock urine is the dominant source of nitrate-nitrogen leached from soil. Leached nitrate-nitrogen can enter groundwater and waterways, potentially causing ecological harm. The amount of nitrate-nitrogen leaching from the soil varies around the country as a result of different land uses, climates, and soils.

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

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

Lake water quality trends, 2004-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.

4702
83
Added
29 Sep 2015

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

When nutrients accumulate in lakes (referred to as ‘nutrient enrichment’) above certain levels, they can make the lakes murky and green with algae, and lower oxygen levels. Lakes with extremely poor water quality are rarely suitable for recreation and provide poor habitats for aquatic species.

Trends in the following parameters are provided:
Trophic Level Index 3 (TLI)
Chlorophyll-a (CHLA)
Bottom-water dissolved oxygen (DObottom)
Ammoniacal nitrogen (NH4N)
Oxidised nitrogen (NO3N)
Total nitrogen (unfiltered) (TN)
Dissolved reactive phosphorus (DRP)
Total phosphorus (unfiltered) (TP)

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 "Lake water quality: Trophic Level Index" measure on the Environmental Indicators, Te taiao Aotearoa website.

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

Natural river flow statistics, predicted for all river reaches

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.

6707
267
Added
29 Sep 2015

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

River flow is the quantity of water passing a point over a certain time. Each river or stream has its own natural flow characteristics, such as peak flows following rain or high spring flows from snow melt. Overall, this affects how much water is available for irrigation, drinking water, hydroelectricity generation, and recreational activities. River flows also influence a waterway’s physical form, habitat, and ecological processes like migration, spawning, and food supply for aquatic life.

This dataset relates to the "The geographic pattern of river flows" measure on the Environmental Indicators, Te taiao Aotearoa website.

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

Fish Index of Biotic Integrity, 1998 - 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.

1189
7
Added
15 Apr 2020

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

This dataset summaries backpack electric fishing observations from the New Zealand Freshwater Fish Database for the period 1998 - 2018. It provides the locations and scores for Fish Index of Biotic Integrity (IBI) (including sub-metric scores).

Technical report available at www.mfe.govt.nz/publications/environmental-reporti....

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.

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

Estimated contemporary and pre-human wetland area, by type (2008 estimate)

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.

3713
36
Added
29 Sep 2015

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

Wetlands support unique biodiversity and provide important services. They clean water of excess nutrients and sediment, help absorb floodwaters, and act as carbon sinks (remove carbon dioxide from the atmosphere). They also have cultural importance for Māori, and provide valuable food and materials (eg flax). Draining wetlands for agricultural and urban development over the past 150 years has significantly reduced their extent, leading to a loss of biodiversity and natural function. This dataset contains estimates of the national extent of the different types of wetlands in contempary and pre-human times.

This dataset relates to the "Wetland extent" measure on the Environmental Indicators, Te taiao Aotearoa website.

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

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

3149
19
Added
16 Apr 2019

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

This dataset contains ten lake water quality variables based on measurements made at monitored lake sites: chlorophyll-a, nitrate-nitrogen, total nitrogen, ammoniacal nitrogen, dissolved reactive phosphorus, total phosphorus, Escherichia coli, water clarity, and lake trophic level index (TLI3 and TLI4). 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 When nitrogen and phosphorus accumulate above certain concentrations in lakes (referred to as ‘nutrient enrichment’), they can stimulate excessive growth of algae and cyanobacteria. Chlorophyll-a is a measure of the phytoplankton (algae) biomass. The lake trophic level index (TLI) indicates the health of a lake based on concentrations of three variables:
· total nitrogen
· total phosphorus
· chlorophyll-a.
Water clarity is a measure of underwater visibility. Lakes with poor clarity and TLI are poor habitats for some species of animals and plants, and they may not be suitable for recreation. Ammoniacal nitrogen can be toxic to aquatic life if concentrations are high enough.

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 99872
Data type Table
Row count 454
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 1 to 10 of 57