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.

1826
588
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

River water quality modelled state dataservice 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.

362
10
Added
14 May 2019

This item was first added to MfE Data Service on 14 May 2019

4
Document ID21986
File nameriver-water-quality-modelled-state-dataservice-data-quality.pdf
TypePDF
Size586 KB

River water quality modelled state 2013–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.

306
13
Added
16 Apr 2019

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

Document ID21924
File nameriver-water-quality-modelled-state-20132017-raw-data.csv
TypeCSV
Size195 MB

River water quality modelled state 2013–2017 McDowell meets/doesn't meet

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

425
15
Added
16 Apr 2019

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

Document ID21923
File nameriver-water-quality-modelled-state-20132017-mcdowell-meetsdoesnt-meet.csv
TypeCSV
Size57.4 MB

River water quality modelled state 2013–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.

398
13
Added
16 Apr 2019

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

3
Document ID21957
File nameriver-water-quality-modelled-state-20132017-data-quality.pdf
TypePDF
Size510 KB

River water quality binomial trend direction statistics xlsx

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.

719
135
Added
07 Oct 2015

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

Document ID11441
File nameriver-water-quality-binomial-trend-direction-statistics-xlsx.xlsx
TypeXLSX
Size12.2 KB

River flows

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.

19691
1363
Added
17 Feb 2016

This dataset was first added to MfE Data Service on 17 Feb 2016.

"River flow refers to the quantity of water passing a point in the river over a certain amount of time. Different rivers have different flow patterns, such as sharp peak flows following rain with low flows in between, or high spring flows from snow melt. These flow characteristics affect how much water is available for irrigation, drinking water, hydro–electric power generation, and recreational activities such as fishing and boating. River flows are also very important for maintaining the health and form of a waterway.

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

For more information, refer to the March 2015 report: 'Hydrological indices for national environmental reporting' data.mfe.govt.nz/document/11463-hydrological-indic....

Layer ID 53309
Data type Vector multilinestring
Feature count 576277
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

raw_data_for trends_NGMP

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.

640
37
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 ID11708
File nameraw_data_for-trends_ngmp.csv
TypeCSV
Size2.37 MB

Primary use and source of consented freshwater takes, 2013–14

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.

6640
111
Added
25 Apr 2017

This dataset was first added to MfE Data Service on 25 Apr 2017.

Regional councils issue resource consents for the taking of fresh water for various purposes, including irrigation, drinking, hydroelectricity, and industry. Water can be taken from surface water or groundwater.

The file provides the primary source and primary use of the water take for each consented take.

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

Prediction of wetlands before humans arrived

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.

10781
310
Added
11 Jan 2016

This dataset was first added to MfE Data Service on 11 Jan 2016.

"Wetlands support unique biodiversity and provide important services. They clean water of nutrients and sediment, help dampen floods, provide habitat, and act as carbon sinks. They are also valued for their spiritual and cultural significance and as important sources of food and materials, such as flax. Draining them for agricultural and urban development has reduced their extent. Understanding this reduction provides insight into the loss of biodiversity and natural function.
This dataset relates to the ""Wetland extent"" measure on the Environmental Indicators, Te taiao Aotearoa website. "

Layer ID 52677
Data type Vector multipolygon
Feature count 32422
Services Vector Query API, Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 31 to 40 of 170