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.

2567
33
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

Lake submerged plant index, 1991 - 2019

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

2577
12
Added
06 Apr 2020

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

The most recent assessment of ecological condition of 295 lakes in New Zealand assessed on at least one occasion between 1991 and 2019 was measured using the lake submerged plant index (LakeSPI).

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 104564
Data type Table
Row count 295
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

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

2578
13
Added
06 Apr 2020

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

This indicator reports on six measures of lake water quality based on spatially modelled data for:

  • chlorophyll-a
  • total nitrogen
  • ammoniacal nitrogen
  • total phosphorus
  • water clarity
  • trophic level index (TLI3).

For these measures we report on:

  • modelled median values for the period 2013–17
  • for selected measures, how these values compare to the National Objectives Framework (NOF) bands related to ecosystem health (MfE, 2017).

This indicator includes spatial predictions for 3,802 of 3,820 lakes in New Zealand (majority of New Zealand lakes that are larger than 1 hectare), based on measurements at 61–104 lake sites (the number of sites differs by measure).

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 104560
Data type Table
Row count 30416
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

River water quality, heavy metals, trend, 2011-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.

2016
8
Added
06 Apr 2020

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

Heavy metals in river waters are an indicator of river water quality. We monitor a subset of rivers and streams in predominantly urban areas in Auckland, Wellington, and Christchurch, and look at how these values are changing over time. This indicator shows:

  • trends in concentrations based on measurements made at monitoring sites during the seven-year period from 2011 to 2017

Summary report available at www.mfe.govt.nz/publications/fresh-water/urban-riv....

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 104562
Data type Table
Row count 93
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.

1414
585
Updated
22 Apr 2021

This dataset was last updated on MfE Data Service on 22 Apr 2021.

23 April 2021: A new version of this data set has been published. It includes data on 4 parameters (Ammoniacal nitrogen (adjusted), Escherichia coli, Macroinvertebrate Community Index and Total Phosphorus) that had been missing from the file that was published as part of the Our freshwater 2020 release in April 16 2020. The updated data set also includes data on DRP for all 593,337 REC segments, since the file from April 16 2020 only had data for 255,860 of these segments.

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

Lake Water Quality for Swimming Categories [Raw Model Output]

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

1179
7
Added
27 Jun 2018

This dataset was first added to MfE Data Service on 27 Jun 2018.

Water quality for swimming categories for lakes with perimeters over 1.5 km. This dataset was used to compose the current state for water quality for swimming.

Note this data is under review and will be updated in due course. This information is based on modelled and measured data using the approach outlined at
www.mfe.govt.nz/fresh-water/freshwater-management-...

The modelling methods used are outlined in Snelder et al. (2016) Strategic assessment of New Zealand’s freshwaters for recreational use: a human health perspective. LWP Client Report 2016-011 www.mfe.govt.nz/publications/fresh-water/strategic...

Versions

This dataset is the geometric version of this: data.mfe.govt.nz/table/53620-river-water-quality-f...

This dataset has now been superseded due to consultation with local authorities, and this is the latest version: data.mfe.govt.nz/layer/95555-river-water-quality-f...

Column headings:

LID: FENZ Lake ID

Name: Name of lake (where available

RC: Regional council name

CHLA: Chlorophyll a (mg/L)

SECCHI: Secchi disc depth (m)

TLI3: Trophic Level Index (unitless)

TN: Total nitrogen (mg/m3)

TP: Total phosphorus (mg/m3)

CyanBVl: Cyanobacterial biovolume (mm3/L)

Cy_cat: Water quality for swimming category see www.mfe.govt.nz/fresh-water/what-government-doing/...

Note: blank cells are reaches where a prediction was not possible because of missing predictor variables.

Layer ID 95561
Data type Vector multipolygon
Feature count 3801
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W)

Conservation status of indigenous freshwater species

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

1032
15
Added
07 Apr 2020

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

We report on the conservation status and most recent change in status of indigenous (native), resident (breeds in New Zealand) freshwater fish and invertebrates that have been assessed by New Zealand Threat Classification System (NZTCS) expert panels.
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 104574
Data type Table
Row count 11835
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

Update of National Groundwater Quality Indicators: State and Trends December 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.

914
76
Added
19 Oct 2015

This item was first added to MfE Data Service on 19 Oct 2015

Raw data, and state and trend calculations for key groundwater quality indicators, including nitrate-nitrogen, ammoniacal-nitrogen, dissolved reactive phosphorus, dissolved iron, dissolved manganese, total dissolved solids content, and electrical conductivity.

Statistics reported on include:
- median and median absolute deviation
- percentiles
- trend magnitudes
- statistical test p-values (from the Mann-Kendall trend test, Kruskal-Wallis test for seasonality, and sign-tests and Wilcoxon rank-sum tests for distribution differences).

The following report and spreadsheets relate to the "Ground water quality" measures on the Environmental Indicators, Te taiao Aotearoa website:
- Moreau M, Daughney C, 2015. Update of National Groundwater Quality Indicators: State and Trends December 2004-2013, GNS Science Consultancy Report 2015/16. 38 p.
- Spreadsheet2_NGMP_results
- Spreadsheet1_NGMP_metadata
- raw_data_for trends_NGMP.

Document ID11707
File nameupdate-of-national-groundwater-quality-indicators-state-and-trends-december-2004-2013.pdf
TypePDF
Size1.96 MB

Groundwater quality, state, 2014-18

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

906
18
Updated
11 Jun 2021

This dataset was last updated on MfE Data Service on 11 Jun 2021.

11 June 2021: A revised version of this dataset has been published to correct the terminology used to compare nitrate-nitrogen values to the 3 g/m3 guideline value. The field name has been changed from “reference_condition” to “n_n_guideline”, and values in this field will now be either “Does not exceed” or “Exceeds”, instead of “Meets” or “Does not meet”.

20 July 2020: We corrected the data about drinking water standards for E. coli and nitrate-nitrogen in the key findings for groundwater quality.

For the five-year period 2014‒2018:

  • 68 percent of 364 sites failed to meet the E.coli drinking water standards (changed from 98 percent of 145 sites failed to meet the E. coli drinking water standards)
  • 19 percent of 433 sites didn’t meet nitrate-nitrogen standards (changed from 28 percent of 403 sites failed to meet the nitrate-nitrogen drinking water standards).

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:

  • median values for the period 2014–18
  • nitrate-nitrogen median values compared to a guideline value of 3 grams per cubic metre (g/m3). This value is defined as a concentration that indicates groundwater has been influenced by industrialised agriculture and is highly likely to have been impacted by human activity (per Morgenstern & Daughney, 2012 and Daughney & Reeves, 2005).
  • the proportion of samples from each site that have concentrations of nitrate-nitrogen or E. coli in excess of the Maximum Acceptable Values for protection of human health (Ministry of Health, 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.

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

Hydrological indices for national environmental reporting

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.

752
156
Added
07 Oct 2015

This item was first added to MfE Data Service on 07 Oct 2015

39
Document ID11463
File namehydrological-indices-for-national-environmental-reporting.pdf
TypePDF
Size3.93 MB
Results 131 to 140 of 170