Child pages
  • Access Freshwater Chemistry Data ("NRWQN")
Skip to end of metadata
Go to start of metadata

NIWA Freshwater Chemistry Data

NIWA has and is collecting freshwater chemistry data as part of its national monitoring operations, supported by the National Centre for Environmental Information.

The data have been collected to consistent national protocols for many decades as part of the National River Water Quality Network (NRWQN).

This database contains scientific observation of freshwater chemistry data across the country, quality assured by NIWA experts.

I want to search and download data

As part of NIWA's Hydro Web Portal, users can query, visualize and download freshwater chemistry observations under this link: http://ei.niwa.co.nz/search/fchem

I want to access data through web services

Data is delivered as public data through a open standard web services, consistent with NIWA's public data access strategy. Data is delivered through OGC compliant web services.

 

Dataset metadata are delivered from the NIWA Data Catalogue as OGC CSW, here is the link: 
https://dc.niwa.co.nz/niwa_dc/srv/eng/csw?request=GetRecordById&id=0113b377-cb92-43f7-b423-79f5d3050aa6&elementsetname=full&service=CSW&version=2.0.2

 

TBD: SOS access

 

Note: The access method described from hereon is being discontinued.

 

OGC web services are provided as a Web Feature Service WFS and can be reached through this URL which returns a WFS with one entry for each observation and fields for what has been observed.

http://gs.niwa.co.nz/nemo/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=nemo:fchem_chemistry

This services returns data as one record per feature, one record being a set of observations for one location at one time, for each record / feature a range of data is returned:

(Note: because one we have collected monthly samples over 25 years at 77 sites, the total number of records / features is ~25,000 and growing so be ware.)
<gml:featureMember>
 <nemo:fchem_chemistry fid="fchem_chemistry.10371">
 <nemo:location_uri>
urn:oid.1.3.6.1.4.1.38899:niwa:ei:station:alias:NN2%20-%20Nelson
</nemo:location_uri>
<nemo:site_ident>NN2</nemo:site_ident>
<nemo:site_desc>Motueka at Gorge</nemo:site_desc>
<nemo:region>Nelson</nemo:region>
<nemo:catchment_area_km2>166</nemo:catchment_area_km2>
<nemo:catchment_height_m>1049</nemo:catchment_height_m>
<nemo:altitude>376</nemo:altitude>
<nemo:start_date>1989-01-23</nemo:start_date>
<nemo:start_time>14:05</nemo:start_time>
<nemo:wq_temperature>15.7</nemo:wq_temperature>
<nemo:wq_dissolved_oxygen_percent>93</nemo:wq_dissolved_oxygen_percent>
<nemo:wq_dissolved_oxygen>8.8</nemo:wq_dissolved_oxygen>
<nemo:wq_instantaneous_discharge>3.01</nemo:wq_instantaneous_discharge>
<nemo:wq_visual_clarity_distance>16.1</nemo:wq_visual_clarity_distance>
<nemo:wq_turbidity_ntu>0.35</nemo:wq_turbidity_ntu>
<nemo:wq_ph>8.01</nemo:wq_ph>
<nemo:wq_conductivity>104</nemo:wq_conductivity>
<nemo:wq_ammoniacal_nitrogen>6</nemo:wq_ammoniacal_nitrogen>
<nemo:wq_nitrate_nitrite>27</nemo:wq_nitrate_nitrite>
<nemo:wq_total_nitrogen>45</nemo:wq_total_nitrogen>
<nemo:wq_dissolved_phosphorus>3</nemo:wq_dissolved_phosphorus>
<nemo:wq_total_phosphorus>4</nemo:wq_total_phosphorus>
<nemo:wq_absorption_coeff_340>1.2</nemo:wq_absorption_coeff_340>
<nemo:wq_absorption_coeff_440>0.29</nemo:wq_absorption_coeff_440>
<nemo:wq_absorbance_340>20</nemo:wq_absorbance_340>
<nemo:wq_absorbance_440>5</nemo:wq_absorbance_440>
<nemo:wq_absorbance_740>0</nemo:wq_absorbance_740>
<nemo:wq_oxygen_demand>0.1</nemo:wq_oxygen_demand>
<nemo:wq_total_coliforms/>
<nemo:wq_e_coli/>
<nemo:wq_calcium>6.8</nemo:wq_calcium>
<nemo:wq_magnesium>7.27</nemo:wq_magnesium>
<nemo:wq_sodium>3.2</nemo:wq_sodium>
<nemo:wq_potassium>0.17</nemo:wq_potassium>
<nemo:wq_total_alkalinity>44</nemo:wq_total_alkalinity>
<nemo:wq_chloride>3.7</nemo:wq_chloride>
<nemo:wq_sulphate>2.3</nemo:wq_sulphate>
<nemo:longitude>172.9137059142536</nemo:longitude>
<nemo:latitude>-41.633484154444396</nemo:latitude>
<nemo:datasource>NRWQN</nemo:datasource>
<nemo:date_uploaded>2014-02-28</nemo:date_uploaded>
<nemo:metadata_uuid>ef734f9e-bff0-4d62-ab21-7671f6135689</nemo:metadata_uuid>
 <nemo:geom>
<gml:coordinates xmlns:gml="http://www.opengis.net/gml" decimal="." cs="," ts=" ">172.91370591,-41.63348415</gml:coordinates>
</gml:Point>
</nemo:geom>
</nemo:fchem_chemistry>
</gml:featureMember>

 

Record metadata, parameters and units service

NIWA provides the full parameter names and units for the data delivered through above data service as through this service:

http://gs.niwa.co.nz/nemo/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=nemo:fchem_chemistry_metadata

Please go to the NIWA Environmental Information Browser for explanations in visual form, e.g.: 

http://ei.niwa.co.nz/details/FCHEM/fchem_locations.urn:oid.1.3.6.1.4.1.38899:niwa:ei:station:alias:WN2%20-%20Wellington

 

More details are found under 'Methods' below.

Observation locations service

A OGC web feature service (WFS) of monitoring locations is available under:

http://gs.niwa.co.nz/nemo/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=nemo:fchem_locations

Following site metadata are provided.

<nemo:site_ident>                      NIWA internal site identifier, e.g. NN2
<nemo:site_desc>                      Site name in the form 'rivername' at 'arbitrary sitedescription', e.g. Motueka at Gorge
<nemo:region>                           Arbitrary region description, e.g. Nelson
<nemo:catchment_area_km2>   Area in km2 of upstream catchment
<nemo:catchment_height_m>    Highest elevation (meters above sea level) of upstream catchment
<nemo:altitude>                          Elevation of site (meters above sea level) 

Methods

The following table explains the methods to capture parameters in more detail   -  as at  March 2014.

 

COLUMN ABBRV. EXPANDED NOTATION UNITS METHOD DESCRIPTION

REFERENCE

Refer Ref.

Method Notes

Detection Limit

(indicative)

Precision

(estimate)

within  +/-

FILT

0.45u

MF

MISC.

COMMENTS

MISC.

COMMENTS 2

TimeTime (NZST)hh:mmNew Zealand Standard Time (NZST)11     
CCloud coverx/81/8 to 8/8 observed cloud cover11     
TempTemperatureDeg CGlass Thermometer, or DO meter thermistor (both rated)3, 110.10.1 majority readings via DO meter thermistor 
DO%Dissolved Oxygen% saturationMeter (YSI model 57) to Dec 2008, then HACH HQ40d from Jan 2009 3, 110.51.0   
DO mg/m3Dissolved Oxygenmg/m3  OCalculated from % saturation, water temperature, and pressure at site (to Dec 2008).  Then as direct reading from replacement HACH meters  110.10.1   
FlowInstantaneous Dischargem3/secGauging or rating11-n/a Provisional data only, may be subject to later applied rating changes etc.Most accurate flow data may be obtained from the National Archived flow database
ClarVisual Water Clarity mHorizontal Black Disc.100.010.01 - 0.1   
TurbTurbidityNTUNephelometer (HACH 2100A) to March 2012, then switched to Hach model 2100AN30.1no info Hach 2100A became faulty, and replaced with newer model  
pHHydrogen ion concentrationpHMeter (Radiometer, using Radiometer GK2401C electrode)20.050.05   
CondElectrical conductivityuS/cm @ 25 oCMeter (Radiometer CDM83)30.51, or 2%   
BOD5Biochemical Oxygen Demand - 5 day incubation.  ppm O5 day oxygen depletion test @ 20 Deg C20.20.2 Analyses ceased after JULY 20023  indicator sites continued though - AK2, RO2 and WA9
NH4Ammonia  mg/m3 as Nautomated phenol hypochlorite7 or 1412, or 3%, also Refer CaveatsFiltSamples may be prone to laboratory background NH4 contamination (especially in 1989-2002 period) 
NO3+NO2Nitrate + Nitrite nitrogenmg/m3 as Nautomated hydrazine or cadmium column reduction, diazotisation. 4 or 1210.5, or 3%FiltHydrazine reduction to Dec 2001. Cadmium reduction from Jan 2002.Predominantly Nitrate only present
TNTotal Nitrogen (Organic N+NO3+NH4) mg/m3 as NAlkaline persulphate digestion to Nitrate, then Nitrate determination8 (digestion)1010, or 3%   
DRPDissolved Reactive Phosphatemg/m3 as Pautomated molybdenum blue - ascorbic acid reduction 6 or 130.50.5, or 3%Filt  
TPTotal Phosphatemg/m3 as PAcid persulphate digestion to DRP, then DRP determination2 (digestion)21, or 3%   
A340Absorbance @ 340nmAbs x 1000Spectrophotometric absorbance reading x 1000, 40 mm cell path1115Filtwhole number convention adopted 
A440Absorbance @ 440 nmAbs x 1000Spectrophotometric absorbance reading x 1000, 40 mm cell path1112Filtwhole number convention adopted 
A740Absorbance @ 740 nmAbs x 1000Spectrophotometric absorbance reading x 1000, 40 mm cell path1111Filtwhole number convention adopted 
g340Absorbance co-efficient @ 340 nm /mCalculated from 340 & 740 nm absorbances,90.05n/a   
g440Absorbance co-efficient @ 440 nm /mCalculated from 440 & 740 nm absorbances, 90.05n/a   
CaCalcium  g/m3Atomic Absorption Spectroscopy (emission)50.05no infoFiltData for 1989 only 
MgMagnesium   g/m3Atomic Absorption Spectroscopy (absorbance)50.01no infoFiltData for 1989 only 
NaSodiumg/m3Atomic Absorption Spectroscopy (emission)50.05no infoFiltData for 1989 only 
KPotassiumg/m3Atomic Absorption Spectroscopy (absorbance)50.01no infoFiltData for 1989 only 
AlkTotal Alkalinity (as Calcium Carbonate)g/m3 as CaCO3

Titration, 0.02N HCl tiration to pH 4.9 end-point (using pH meter)

N.B. essentially bicarbonate expressed as ppm CaCO3

1 (403)0.5no info Data for 1989 only 
ClChlorideg/m3Mercuric thiocyanate (manual adaptation)1 (407D)0.1no infoFiltData for 1989 only 
SO4Sulphateg/m3 SO4Turbidimetric (with prior sample evaporation/concentration technique for samples with less than 5 ppm)1 (426C)1 & 0.2no infoFiltData for 1989 only 
T coliTotal coliforms /100mlColilert Quanti-tray MPN enumeration, 24hr incubation @ 35 deg C151refer Caveats Commenced FEB 2005 
E coliFeacal coliforms /100mlColilert Quanti-tray MPN enumeration, 24hr incubation @ 35 deg C, (fluorescent finish)151refer Caveats Commenced FEB 2005 

 

A. PROCEDURAL NOTES:

1) Sampling for the NRWQN programme is carried out by NIWA Environmental Data field teams (14 teams nationwide), covering 77 sites

2) Field observations are made of time (NZST), cloud cover, water temperature, dissolved oxygen (% saturation), clarity (horizontal black disc), stage height, flow, and atmospheric pressure. A conversion of %DO to ppm DO is made back at the laboratory.

3) Samples are colleced in 1 litre polyethylene bottles, sealed air-tight, packed in ice in chilly bins, and dispatched directly to the NIWA Hamilton Chemistry Laboratory (usually received within a 24 hour period).

4) Samples are processed as soon as possible upon receipt, being first warmed to room temperature (sample bottles placed in a water bath). Immediate analyses are made for pH, conductivity and turbidity. Remaining sample is then sub-sampled (both unfiltered and membrane filtered) into smaller 100 ml containers for total nutrients (unfiltered for TN &TP -samples prior shaken for representative aliquot) and dissolved nutrients (membrane filtered for DRP, NH4, NO3 and absorbance measurments for g340 and
g440.) For 1989 (first year only of NRWQN) membrane filtered subsamples were also taken for major anions ( Cl, SO4) and cations (Ca, Mg, Na, K).  Alkalinity analyses were carried out on unfiltered samples.

5) Membrane filtration is through a 0.45 micron membrane filter to remove turbidity and microorgansims

6) Sample containers for total and dissolved nutrients are stored frozen until time of analysis.

7) Remaining sample in the initial 1 litre sample bottles was utilised for the BOD test (5 day incubation at 20 degrees C), in duplicate. N.B. BOD analyses ceased after July 2002, except for sites AK2, RO2, and WA9 which have been left in as indicator sites.

8) TP test: colorimetric finish from 1989 to 1995 incl. done by manual test tube method. From 1996 onward, by automated method.

9)Total & Faecal coliform (E coli) analyses commenced February 2005. Sample collected in separate container, processed immediately
upon receipt at lab (utilising Colilert Quanti-tray MPN enumeration).

10) Periphton observations made directly if possible by wading and using underwater viewer (as for water clarity), ten observation circles  of 0.5m radius, full cross section if possible otherwise a number of transects from either bank. NOTE: A high degree of sujectivity inherent in this measurement, more so for some sites than others. Enquiries should be directed to Dr John Quinn of NIWA Hamilton regarding any data interpretation/clarification preceding preparation/publication of any reports.

B. REFERENCE METHOD NOTES:

1 APHA, 1985
2 Smith et al, Water and Soil Miscellaneous Publication No. 38
3 Manufacturer's Instructions
4 Downes, 1978a; Technicon Auto-analyser (until December 2001)
5 DSIR Chemistry Division reports, CD 2151, 1971 and 1972
6 Downes, 1978b; Technicon auto-analyser (until December 2001)
7 Technicon, 1978; Technicon auto-analyser (until December 2001)
8 Koroleff, 1983
9 Davies-Colley & Vant, 1987 - Refer Miscellaneous Notes 2).
10 Davies-Colley, "Measuring water clarity with a black disk", Limno. Oceanogr., 33(4, part1), 1988, 616-623
11 NIWA Instruction/Adaptation
12 Quik Chem Method 31-107-04-1-A ; Lachat Flow Injection Analyser (from January 2002)
13 Quik Chem Method 31-111-5-01-1-1; Lachat Flow Injection Analyser (from January 2002)
14 Quik Chem Method 31-107-06-1-B ; Lachat Flow Injection Analyser (from January 2002)
15 IDEXX laboratories Inc, Colilert quanti-tray MPN enumeration method
16 Smith et al, 1989, Water Quality Centre Consultancy Report 8016/2, A National Water Quality Network for New Zealand

C. MISCELLANEOUS NOTES:

1) FILT column - indicates use of 0.45 micron membrane filtered sample for analysis

2) ppb (parts per billion) = ug/l (micrograms/litre) = mg/m3 (milligrams/cubic metre)

3) ppm (parts per million) = mg/l (milligrams/litre = g/m3 (grams/cubic metre)

4) Absorbance Coefficients (g340 & g440) - Derived from spectrophotometric absorbance measurements at 340nm and 440nm. These wavelengths are recommended for monitoring concentrations of yellow substance in water i.e. 0.45 micron filter-passing ("dissolved") organic matter. The expression for converting spectrophotometer absorbance measurements to an absorption coefficient is as follows:
g340 = ((In 10) * Corrected Abs 340) / cuvette path length (m); g440 = ((In10 * Corrected Abs 440) / cuvette path length (m);
where (In 10) = Log e 10 = 2.303; Corrected Abs 340 or 440 = spectrophotometric absorbance at the respective wavelengths
(340nm & 440 nm) corrected for absorbance by any residual particulates measured at 740nm. Correction values (which are subtracted from
the 340 and 440 nm spectro readings) comprise respectively the 740nm spectro reading x 2.176471 (ratio of 740/340), and the 740nm spectro
reading x 1.681818 (ratio of 740/440). EXAMPLE: Say sample absorbances at 340, 440 and 740 nm are 0.100, 0.025, 0.002 ABS units using
40 mm path length.
g340 therefore = (2.303*( 0.100-( 0.002*2.176471)))*(1000/40)) = 5.51. g440 therefore = (2.203*(0.025-(0.002*1.681818)))*(1000/40) = 1.25.
For a fuller discourse on absorbance coefficients refer to the following publication:
"Absorption of Light by Yellow Substance in Freshwater Lakes", Authors R.J. Davies-Colley and W.N.Vant,
published in Limnology and Oceanography, Vol.32, No. 2, March 1987.

5) Anions (sulphate, chloride & "alkalinity") & cations (calcium, sodium, magnesium, potassium) analysed monthly for year 1989 only

6) BOD analyses ceased after JULY 2002

7) Bacteriological analyses (Total & Faecal coliforms) commenced February 2005

 

CAVEATS - as at March 2014

1) Flow Data:
Flow data is Instantaneous flow data only, provided by NIWA field teams at the time of site visits from known ratings, estimates, or provided by Regional/District Councils, or Energy Provider, with some data not always accurate (e.g. due to later applied rating changes). For most accurate flow data this should be independently sourced from Flow Data Archives.

2) Nominal Detection Limits: (as presented in the Methods sheet)
For dissolved nutrients (DRP, NO3 and NH4) in particular - Finished laboratory values have been rounded to nearest whole numbers with values that registered between zero and 0.5 mg/m3 given a <1 designation. Initial uncensored data may be provided separately upon request.

3) Accuracy and Precision (General Guide only):
For dissolved nutrients (DRP, and NO3) these range from +/- 0.5 mg/m3 (P or N) at nominal detection limit to +/- 3% above 100 mg/m3.

For dissolved ammonia (NH4-N) the range is +/- 1mg/m3 N at nominal detection limit to +/-3% above 100 mg/m3 (based on repetitive low concentration standards).

However, Ammonia analysis at low concentration is inherently less stable than for DRP and NO3, as may be compromised by backgound laboratory atmospheric contamination during initial sample handling processes, especially for samples already with low NH4 concentrations and this may effectvely alter precision (in the main) up to +/- 2 mg/m3 N. This effect is difficult to counter, or to gauge the real extent of, within each analytical sample batch. Greater NH4 contamination prevalence and spikes were noted (retro-suspected) for period 1989-1994 incl. due to unsatisfactory (cramped and non-air conditiond) laboratory premises. Significant Improvements (tighter results banding) were obtained from 1995 onward following a shift into new premises, with further improvement from 2002 onward when dissolved nutrient analyses shifted from segmented autoanalyser system to unsegmented Flow injection Analyser (FIA), along with upgraded quality control measures.

For other determinands, refer to precision data in Methods Note though that for TN and TP the precision data is based on clean standards. Samples values may be influenced outside these ranges (to an unknown extent) if turbidity is high. i.e. due to difficulty of achieving representative sub-sampling (of suspended particles) from sample container to test tube.


4) Special NH4 and TN Note for 1994 calendar year:
There is no reported NH4 or TN data for 1994 calendar year due to gross NH4 contamination arising from storage of sample pottles for that year in an off-site coolstore freezer later found to have had leaking ammonia-based refrigerant.

5) Total coliforms and E. Coliforms:
The official Colilert test method statistically derived values have been consistently applied i.e. Values may have a decimal placing. A null result is recorded as <1 (the data user however is at liberty to delete decimals, and convert <1 values to zeroes). Highest possible reading using 100ml undiluted sample is 2419.2 (readings greater than this are designated as >2419.2). Dilution of sample prior to analysis (e.g. x10) extends reportable range (dilutions carried out only if if thought warranted). Robust E.coliform results are higher priority than Total coliform results hence many Total coliform results record over-range because sample dilution is not required in the majority of cases to obtain optimum E. Coliform counts. Statistical 90% confidence limit data can be supplied separately upon request.

6) Dissolved Oxygen
From Jan1989 to Dec 2008 the YSI model 57 DO/temperature meter (DO probe employing polaragraphic principle) was used by the field teams. (DO probe employing polarographic principle). From Jan 2009 onward the YSI were replaced with the HACH Model HQ40d DO/temperature meter (DO probe employing luminescent principle). The new technology proved superior re calibration stability and ease of use. However, the probe longevity has proved to be a problem, with numerous probe replacements required, and resulting in loss of some field data (DO and temperature) whenever the probe suddenly ceases to function in the field. In January 2015 the HACH meters were replaced with new model YSI 'Pro ODO' meters and probes (also employing luminescent principle) with no reported problems (as at August 2015).

7) Missing data: represented by "missing"
Usually this indicates that a value could not be assigned due to some circumstance beyond remedial control. e.g. Sample site incaccessible (no sample collected), sample leaked/lost from sample container, sample inadvertently became contaminated, faulty instrumentation or analytical response, or a decision to delete out a grossly anomalous value that cannot be re-checked. On occasion though "missing" may represent data pending inclusion at a later date. e.g. late submission of flow data, repeated analytical results, etc.

8) Data updating:
Scheduled on a 3 monthly basis i.e. quarterly calender updates, but may take some further weeks to action.

9) Site & Data amendments:
May be effected at any time without further notice (Includes closing down of old sites and addition of new sites)

10) Changes in analytical regime:
7.1 Laboratory premises change - Jan 1989 - Dec 19944 the chemistry laboratory operated in a cramped non air-conditioned environment. From Jan 1995 the laboratory moved to new, larger air-conditioned premises that facilitated improved analytical operations.

7.2 Nutrient analyses (DRP, NO3, NH4, TN, TP) - analysed by segmented flow Technicon AutoAnalyser (AA) II, Jan 1989-Dec2001 Data output determined manually from recorder traces until Jan 1995, then replaced by electronic data capture. AA then replaced by unsegmented flow Latchat Flow Injection Analyser (FIA), Jan 2002 to date. For nitrate (NO3) this required a change from hydrazine reduction method to cadmium column reduction method, but retaining same colorimetric finish. Trial testing of all determinands between the Autoanalyser and the FIA showed excellent agreement, with FIA demonstrating better stability.

7.3 BOD - ceased July 2002 for majority of samples. Key indicator sites AK2, RO2 and WA9 retained to date.
Reason: BOD inherently very low at most sites (median all sites = 0.4 mg/m3 O ), with no discernible trends.

7.4 Total and E. Coilform bacteria - commenced February 2002 following stakeholder interest to institute testing.

7.5 Turbidity - change from original HACH model 2100A to model 2100AN March 2012.
Reason: Old meter became inoperable. Measurements considered reasonably comparable. (unable to run actual comparisons of NRWQN samples)

11) Quality Assurance:
In addition to established in-house laboratory QA practices, finished data from the laboratory is regualrly scrutinised for anomalies and dubious values with appropriate measures taken to resolve any issues. Refer narrative in relevant sections in Davies-colley et al, "Twenty Years of New Zealand's National Rivers Water Quality Monitoring Network".

 

 

  • No labels