Freshwater Tables

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.

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

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

Groundwater is the water stored beneath Earth’s surface in aquifers (layers of water-bearing rock or sand). It is used for human and stock drinking water, irrigation, and industry, and also has a role in sustaining some rivers, lakes, and wetlands, especially during low-flow periods. The health of surface-water ecosystems also depends on groundwater.

Estimated average groundwater volumes by 16 regional councils
* region = Regional Council
* bil_cubicm = Average estimated groundwater volume in billion cubic metres

For more information please see:
Moreau M, & Bekele, M (2015). Groundwater Component of the Water Physical Stock Account (WPSA) GNS Science Consultancy Report 2014/290. 35p. Available at data.mfe.govt.nz/x/Tebsax from the Ministry for the Environment dataservice.

This dataset relates to the "Groundwater physical stocks" measure on the Environmental Indicators, Te taiao Aotearoa website.

Groundwater is the water stored beneath Earth’s surface in aquifers (layers of water-bearing rock or sand). It is used for human and stock drinking water, irrigation, and industry, and also has a role in sustaining some rivers, lakes, and wetlands, especially during low-flow periods. The health of surface-water ecosystems also depends on groundwater.

Estimated national groundwater volumes by year and aquifer type (confined, or unconfined)
aquifer_ty = aquifer type
cubicm = estimated groundwater volume in cubic metres (m3)

This dataset relates to the "Groundwater physical stocks" measure on the Environmental Indicators, Te taiao Aotearoa website.