River water quality modelled state 2013–2017


Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

31 May 2019

This dataset was last updated on MfE Data Service on 31 May 2019.


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


Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

1. River water quality modelled state 2013–2017 McDowell meets/doesn't meet 57.4 MB csv
2. River water quality modelled state 2013-2017 raw data 195 MB csv
3. river water quality modelled state dataservice data quality 594 KB pdf
Technical Details
Table ID 99871
Data type Table
Row count 5927520
Columns nzsegment, midcoordx, midcoordy, sof, landcover, seglength, np_id, ann_max, g_260, g_540, median, q_95, sof_name, anz_dgv_q80, anz_dgv_q20, anzg_meet, mci_band, nof_swim, nof_toxicity, landcover2, landcover2_name, np_id_name
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Added 16 Apr 2019
Last updated 31 May 2019
Revisions 16 - Browse all revisions
Current revision Imported on May 31, 2019 from CSV .