Freshwater Tables

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

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

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

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

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

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

This dataset measures groundwater quality in New Zealand’s aquifers based on measurements made at monitored sites. Many factors influence the quality of our groundwater. Nitrogen, which occurs naturally in groundwater, can increase in concentrations due to agricultural and urban land use, and infrastructure such as waste treatment plants. High concentrations of nitrate-nitrogen in groundwater can affect human health and the quality of surrounding rivers and lakes that receive inflows from groundwater. Ammoniacal nitrogen can cause an undesirable smell that may make groundwater unsuitable for drinking water. Natural processes in groundwater can convert nitrate-nitrogen into ammoniacal nitrogen or other forms under some chemical conditions. Surplus phosphorus drains (leaches) into groundwater as dissolved reactive phosphorus. Too much nitrate-nitrogen, ammoniacal nitrogen, and phosphorus can lead to excessive plant and algae growth where groundwater flows into surface water. E. coli in groundwater is measured in colony forming units (cfu) and can indicate the presence of pathogens (disease-causing organisms) from animal or human faeces. The pathogens can cause illness for anyone who ingests them.

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.

This dataset measures groundwater quality in New Zealand’s aquifers based on measurements made at monitored sites. Many factors influence the quality of our groundwater. Nitrogen, which occurs naturally in groundwater, can increase in concentrations due to agricultural and urban land use, and infrastructure such as waste treatment plants. High concentrations of nitrate-nitrogen in groundwater can affect human health and the quality of surrounding rivers and lakes that receive inflows from groundwater. Ammoniacal nitrogen can cause an undesirable smell that may make groundwater unsuitable for drinking water. Natural processes in groundwater can convert nitrate-nitrogen into ammoniacal nitrogen or other forms under some chemical conditions. Surplus phosphorus drains (leaches) into groundwater as dissolved reactive phosphorus. Too much nitrate-nitrogen, ammoniacal nitrogen, and phosphorus can lead to excessive plant and algae growth where groundwater flows into surface water. E. coli in groundwater is measured in colony forming units (cfu) and can indicate the presence of pathogens (disease-causing organisms) from animal or human faeces. The pathogens can cause illness for anyone who ingests them.

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.

Cultural Health Index scores for a waterway is a combination measure of historical cultural use and access, mahinga kai assessment, and water quality assessment from a cultural perspective of a site on a waterway.

The Cultural Health Index scores compile this information into a classification system to provide an overall grading of the state of a site and how the state of a site on a waterway affects the mauri, the ability for tangata whenua to feed the hapu and iwi and the overall water quality for the site. These are all important indicators of the cultural health of a waterway, and are also a consideration for other cultural and recreational activities like karakia, cleansing, swimming and wading.

Water is an important source of energy that contributes to New Zealand’s energy supply and the economy. As the main source of renewable energy in New Zealand, the use of water supports the production of the electricity industry. Tracking the value of this water as a natural resource – along with land form, slope, and elevation, which all help to generate hydroelectricity – shows the economic benefits derived from water use for current and future generations. Changes in flow regimes and climate can affect these values.

We report on the value of water resources used to generate hydroelectricity. This value includes both the returns received from current use (resource rent), and expected benefits from future use (the asset value).