NZ Water Metering Compliance

NEMS v3.0.0

Technical reference for the quality assurance framework applied to all water meter data in this portal.

Regulatory Quality Codes Flowchart Child Codes QC Caps Ground Truth Data Integrity Verification Council Reporting Versioning

Regulatory Framework

Water metering in New Zealand is governed by three key standards:

  • Resource Management (Measurement and Reporting of Water Takes) Regulations 2010/2020 — Defines water year (1 July – 30 June), reporting obligations, and accuracy requirements.
  • National Environmental Monitoring Standards (NEMS) — National Quality Code Schema v3.0.0 — The quality coding framework applied to all environmental data, including water meter readings.
  • NEMS Water Meter Data Standard — Sector-specific requirements for electronic water meter data: recording intervals, verification, and submission formats.
Key Requirements
RequirementStandardAuthority
15-minute recording intervals≤15 min between readingsNEMS Water Meter Data
Meter verificationEvery 5 years (Blue Tick)RM Regulations 2010
Council report generation and exportElectronic format with QC codesRM Regulations 2010/2020
Measurement accuracy±5% of actual flowRM Regulations 2010
Water year1 July – 30 JuneRM Regulations 2010 s3(1)

NEMS Quality Codes

Every data point carries a quality code from the NEMS National Quality Code Schema v3.0.0. Codes QC 400–600 reflect measured data quality; codes QC 0–300 are categorisation mechanisms and do not rate quality.

ColourCodeLabelDescription
QC 600 Good Measured data, at time of acquisition, considered a good representation of the monitored variable. Meets all NEMS requirements.
QC 500 Fair Measured data that do not meet all QC 600 requirements at time of acquisition, and/or have undergone minor modification. Fair representation.
QC 400 Compromised Measured data compromised in ability to represent the monitored variable, and/or have undergone significant modification.
QC 300 Synthetic Data estimated from relationships, calculations, models, or limited measured data. Believed to be a reasonable representation of the variable.
QC 200 Unverified Data of unknown quality: not yet passed through QA, uncertain quality, or from external agency not coded to NEMS.
QC 100 Missing Data are missing. Either confirmed not recorded (instrumentation failure, personnel/lab error), deleted due to poor quality, or lost.
QC 0 Non Verified Data as recorded prior to verification: either raw, or modified by documented algorithm during collection. Quality has not been established. New in v3.0.0.

Note: The “Poor” label was removed in NEMS v3.0.0. QC 400 is now “Compromised”. QC 0 (Non Verified) was added in v3.0.0 for raw data prior to quality assessment.

Quality Code Assignment

Based on NEMS v3.0.0 Figure 2 — Generic Quality Flowchart. Each data point is assessed top-down; the first YES determines its quality code.

Is this original data?
Raw or algorithm-modified during collection
YES
QC 0
NO
Is this a verified missing record?
Confirmed gap in data
YES
QC 100
NO
Is quality unknown?
Not yet QA’d, or external data not coded to NEMS
YES
QC 200
NO
Is this synthetic data?
Estimated, modelled, or gap-filled
YES
QC 300
NO
Is data compromised?
Overdue verification, >20% gaps, manual reading, or significant modification
YES
QC 400
NO
Does data meet ALL QC 600 requirements?
Verified meter, <5% gaps, 15-min intervals, ±5% accuracy
NO
QC 500
YES
QC 600 — Good

Supplementary Child Codes

Per NEMS v3.0.0 Section 5, child codes are allocated in-house to provide supplementary quality detail. Format: Parent-Child (e.g., 600-010). When submitting to councils, the parent code is the primary identifier; child codes provide optional additional context.

CodeLabelDescriptionAssignment
600-010Full complianceAll NEMS QC 600 requirements metAuto
600-020Field verifiedQuality confirmed by field visit or site inspectionManual
600-030Meter verifiedQuality confirmed by Blue Tick verification testManual
600-040Post-calibrationPromoted from QC 0 after successful calibrationAuto

CodeLabelDescriptionAssignment
500-010Verification due soonMeter verification due within 30–90 daysAuto
500-020Gap 5–20%Data completeness 80–95% in assessment periodAuto
500-030Minor modificationMinor post-collection data adjustmentManual
500-040Signal degradedLoRa/MQTT signal quality moderate (RSSI < −80)Auto
500-050Timing driftClock drift exceeds 90 seconds per monthAuto

CodeLabelDescriptionAssignment
400-010Manual (verified)Manual reading with verified meterAuto
400-020Manual (due soon)Manual reading, verification due within 90 daysAuto
400-030Verification overdueAutomated QC degradation — meter verification expiredAuto
400-040Gap >20%Data completeness below 80% in assessment periodAuto
400-050Equipment suspectAnomalous range or rate-of-change detectedAuto
400-060Major modificationSignificant post-collection data modification appliedManual

CodeLabelDescriptionAssignment
300-010InterpolatedGap filled using linear interpolationAuto
300-020Manual fillGap estimated from manual meter readingsManual
300-030DerivedVolume derived from other meters in distribution networkManual
300-040Zero confirmedZero flow confirmed by manual reading during no-abstractionManual
300-050Verification ratioRecord adjusted by meter verification failure ratioManual

CodeLabelDescriptionAssignment
200-010Never verifiedMeter has never been verified by Blue Tick installerAuto
200-020Failed verificationMeter failed verification test (>5% error)Auto
200-030QA pendingManual QA review not yet completedManual
200-150Unknown qualityQuality of data point is unknown (per NEMS v3.0.0 Table 2)Manual
200-200External non-NEMSFrom external agency, not coded to match NEMSManual

CodeLabelDescriptionAssignment
100-010Comms failureDevice communication failure — no heartbeat receivedAuto
100-020Battery deadDevice powered off or battery below thresholdAuto
100-030Deleted (poor quality)Data removed during QA due to corruptionManual
100-040Auto gap detectionGap detected by automated missing records scanAuto
100-050Planned maintenanceScheduled maintenance outage periodManual

CodeLabelDescriptionAssignment
0-010Raw telemetryRaw telemetry data, no processing appliedAuto
0-020Pulse-to-volumePulse-to-volume conversion applied during collectionAuto
0-030Offset calibratedCounter offset calibration applied at display timeAuto
0-040Awaiting QAData awaiting quality assessment pipelineAuto
0-050Backfilled from secondary storeData backfilled from InfluxDB dual-write — identical original telemetry via alternate storage pathAuto

QC Caps Reference

Certain conditions cap the maximum achievable quality code, regardless of other factors.

ConditionMaximum QCAuthority
Meter verification current (<5 years)QC 600NEMS Water Meter Data
Meter verification due soon (30–90 days)QC 500Meter verification requirements
Meter verification overdue (>5 years)QC 400NEMS & verification policy
Meter never verifiedQC 200NEMS quality codes
Meter failed verificationQC 200NEMS quality codes
Gap <5%QC 600 eligibleNEMS v3.0.0
Gap 5–20%QC 500NEMS v3.0.0
Gap >20%QC 400NEMS v3.0.0
Manual reading (any)QC 400NEMS & quality codes
Gap-filled / interpolated dataQC 300NEMS v3.0.0 Figure 2
Confirmed missing recordQC 100NEMS v3.0.0 Figure 2
Raw unprocessed telemetryQC 0NEMS v3.0.0 (new in v3.0)

Ground Truth Methodology

All consent compliance totals use ground truth calculations — the only method that provides 100% accurate volume totals from pulse-counter telemetry.

Why Ground Truth?

Water meters transmit cumulative pulse counter values at 15-minute intervals. Pre-aggregated data (e.g., “volume per bucket”) can lose pulses that fall on bucket boundaries. The ground truth formula avoids this entirely by using the raw counter extremes over any period.

Formula
-- Ground truth: 100% accurate for any time period
SELECT MAX(gpio_counter_1) - MIN(gpio_counter_1)
FROM telemetry
WHERE device_id = :device_id
  AND time >= :period_start
  AND time <= :period_end

This returns the exact number of pulses recorded, regardless of how they align with reporting intervals. Each pulse represents a fixed volume (typically 1 litre per pulse).

When to Use What
Use CaseData SourceAccuracy
Consent limits & compliance totalsRaw telemetry (MAX−MIN)100%
Dashboard charts & visualisation15-minute aggregates~95%

Data Integrity

Our data integrity approach ensures that original measurements remain trustworthy and auditable.

  • Append-only telemetry — Raw telemetry data is append-only. Original measurement values are preserved as received from field devices.
  • Manual readings preserved — Manual meter readings are stored alongside telemetry data with their own quality codes and are never overwritten.
  • Corrections via audit trail — When data corrections are necessary, they are tracked through an auditable workflow. Original values are retained.
  • Calibration logging — When meter calibration factors are adjusted (e.g., after a verification test reveals offset), both the before and after values are recorded.
  • Quality code metadata — Quality code changes are the one permitted metadata update on existing records. The measurement data itself is not modified — only the quality assessment of that data.

Meter Verification

All water meters must be verified to ensure measurement accuracy, as required by the Resource Management (Measurement and Reporting of Water Takes) Regulations 2010.

Blue Tick Programme

Meters are verified by accredited Blue Tick installers (IrrigationNZ) every 5 years. Verification tests confirm the meter reads within ±5% of actual flow across the operating range.

QC Impact

Verification status directly affects data quality codes. Overdue verification caps data at QC 400 (Compromised). The system tracks verification dates and automatically degrades quality codes when verification expires.

Alert Timeline
StatusTimeframeQC ImpactAlert
CurrentVerified within 5 yearsQC 600 eligibleNone
Due soon90 days before expiryQC 500 maxWarning notification
Due30 days before expiryQC 500 maxUrgent notification
OverduePast 5-year expiryQC 400 maxAlert — quality degraded

Council Reporting

The portal generates council-ready reports in the format required by regional councils under the Resource Management Regulations.

Report Format
  • 15-minute interval CSV export
  • NEMS quality code on every reading
  • Ground truth totals for all compliance values
  • NZ timezone aligned (Pacific/Auckland)
Required Fields
  • Timestamp (NZST/NZDT with timezone offset)
  • Device identifier
  • Volume reading (m³)
  • Quality code (QC 0–600)
  • Consent number
  • Well number (where applicable)

NEMS Version Tracking

Per NEMS v3.0.0 Section 7, systems must track which schema version their quality codes conform to.

PropertyValue
Current schemaNEMS National Quality Code Schema v3.0.0
Quality code rangeQC 0 – QC 600 (7 parent codes)
Child codes35 supplementary codes (in-house allocated per Section 5)
Key Changes in v3.0.0
  • QC 0 (Non Verified) added — New code for raw data prior to quality assessment. All incoming telemetry starts at QC 0.
  • “Poor” label removed — QC 400 is now “Compromised”, not “Poor”.
  • Version tracking required — Systems must record which NEMS schema version is in use (Section 7).
  • Child coding formalised — Section 5 provides the framework for supplementary quality codes allocated by data providers.

Quality codes conform to NEMS National Quality Code Schema v3.0.0

Customer Data Quality Guide | Sign In