Lake water quality 10 year trends, 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.

232
3
Added
16 Apr 2019

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

Document ID21928
File namelake-water-quality-10-year-trends-raw-data.csv
TypeCSV
Size167 KB

Lake water quality trends 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.

304
0
Added
16 Apr 2019

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

3
Document ID21927
File namelake-water-quality-trends-data-quality.pdf
TypePDF
Size517 KB

Lake water quality 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.

338
29
Added
16 Apr 2019

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

Document ID21926
File namelake-water-quality-state-20132017-raw-data.csv
TypeCSV
Size174 KB

Lake water quality 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.

331
12
Added
16 Apr 2019

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

3
Document ID21925
File namelake-water-quality-state-20132017-data-quality.pdf
TypePDF
Size504 KB

Lake water quality 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.

5186
25
Added
16 Apr 2019

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

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

Table ID 99872
Data type Table
Row count 454
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.

1404
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

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.

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

378
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

RiverQ ecoli modelled mcdowell meet clean

Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

375
6
Added
16 Apr 2019

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

Document ID21922
File nameriverq-ecoli-modelled-mcdowell-meet-clean.csv
TypeCSV
Size57.4 MB

WQ PredictionsDF REC2 29November 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.

337
4
Added
15 Apr 2019

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

Document ID21921
File namewq-predictionsdf-rec2-29november-2018.csv
TypeCSV
Size195 MB
Results 31 to 40 of 169