Integrated Multi-Vendor DMA Monitoring

Take Control of
Non-Revenue Water
in Real Time

Stop Physical Leaks. Recover Commercial Losses. Secure Your Infrastructure.

Take control of Non-Revenue Water with Flowtrix, a production-grade decision engine that integrates multi-vendor telemetry and consumer meters into a single, high-performance dashboard. Empower your engineering, billing, and management teams with real-time smart utility diagnostics and instant, verifiable insights.

<15min Telemetry Sync
600+ Smart Meters
100% Raw Resolution
99.9% System Uptime
Why Flowtrix

The Engine Behind Water Loss Recovery

Four core capabilities that separate Flowtrix from generic monitoring tools.

Multi-Vendor Pipeline Integration

Consolidate data silos. Flowtrix pulls SIV inlet flow rates, reservoir levels, and pressure points from i20 Sentryx telemetry while simultaneously tracking consumption and tamper alerts from smart consumer meters.

Sub-Second Telemetry Caching

Flowtrix utilizes a multi-layered caching system and pre-computed database summaries, delivering complex network metrics and leak calculations in under 0.2 seconds without overloading operational databases.

Native i18n & Multilingual Support

Built for multinational teams. Flowtrix features enterprise-grade localized language mapping across English and Bahasa Melayu, allowing engineering and financial departments to switch layouts instantly.

Confirmed Night Analytics

Establish solid operational benchmarks. Flowtrix implements standard IWA night-flow algorithms (02:00–04:00 AM) and Q1 baseline comparisons to distinguish legitimate night usage from hidden pipeline leaks.

Platform Features

17 Specialized Operational Modules

Each tab of the Flowtrix dashboard is a purpose-built analytical engine. Click any module to explore its capabilities.

Flowtrix Executive KPI Overview Cockpit
01 All Roles

Executive KPI Overview Cockpit

The central command dashboard gives utilities an immediate, high-level window into water network health. By combining main supply telemetry with consumer meter datasets, it displays system-wide efficiency stats and localized zone performance at a glance.

  • 5 KPI Cards: SIV Inlet Volume, NRW %, Active Alerts, Meter Fleet Scale (64 meters), and System Pressure.
  • DMA Performance Cards: Individual summaries for DMA 01, DMA 02, DMA 03, and Non-DMA zones with automated color-coded alerts.
  • NRW Trend Chart: Interactive Chart.js graph with week-to-month period toggles using rolling 7-day windows.
  • Live Alerts Monitor: Compact notification drawer with localized incident descriptions and direct diagnostic navigation.
i20_api.db 8ten_api.db v_overview_kpi
Flowtrix Zone-Based Demand Profiling
02 All Roles

Zone-Based Demand Profiling

Analyzes and visualizes water consumption patterns by district zones, pressure zones, and individual household units to identify billing anomalies, sudden demand spikes, or localized usage patterns.

  • Hourly Demand Flow: 24-hour demand curves for DMA 01, DMA 02, DMA 03, and Non-DMA zones on a single timeline.
  • Top 10 Consumers Grid: High-volume commercial or residential users using parent-child logic with real household names.
  • DMA Share Breakdown: Doughnut chart detailing segment contributions, precise volume and percentage per zone.
  • Diurnal Night Demand Tracker: Total usage during the standard night-flow window to pinpoint high continuous flow zones.
8ten_usage_timeseries Hourly Telemetry
Flowtrix Smart Meter Fleet Manager
03 Analyst+

Smart Meter Fleet Manager

A fleet management module tracking smart meters across the service area, complete with real-time health diagnostics, battery monitoring, and instant alerts.

  • Filterable Sidebar: Search the entire database by logger ID, serial number, household display name, or DMA zone.
  • Telemetry Explorer: Switch between 24-hour consumption bar charts and 5-minute raw telemetry logs.
  • Battery Lifecycle Predictor: Battery level trends over time, helping field crews plan preventative replacements.
  • Visual Status Indicators: Communication health, active warnings, and hardware configuration details.
8ten_meters 8ten_telemetry
Flowtrix GIS Spatial Node Visualizer
04 All Roles

GIS Spatial Node Visualizer

Provides a clear geospatial overview of the utility's water distribution network, tracking device positions, boundary limits, and active warnings via MapLibre GL JS vector tile rendering.

  • Custom Map Styles: Toggle between OpenStreetMap standard maps and high-resolution satellite imagery.
  • DMA Boundary Overlays: Transparent polygons mapping DMA boundaries to associate meters and loggers with zones.
  • Custom SVG Markers: Water meters and consumer accounts, color-coded by active status.
  • Quick Search & Zoom: Click any alert or meter in the side panel to fly to its exact lat/long coordinate.
MapLibre GL JS i20_locations DMA Boundaries
Flowtrix Sankey Flow Path Mapper
05 Analyst+

Sankey Flow Path Mapper

An interactive, visual flow map tracking water from main treatment inlets, through DMA zone boundaries, down to individual consumers. Built on D3.js Sankey Diagram layout engine.

  • Dynamic Flow Routing: Visualizes system input volume (SIV) splitting into DMA zones and consumer accounts.
  • Interactive Drill-Downs: Filter by entire network, specific DMAs, or Non-DMA distribution branches.
  • Flow Detail Tooltips: Hover over any node or flow stream to view exact volumes and percentages.
D3.js Sankey SIV Inlet DMA Flows
Flowtrix District Water Balance Auditor
06 Analyst+

District Water Balance Auditor

Implements international IWA water audit standards to split system-wide inlet volumes into billed consumption, unbilled consumption, and non-revenue water.

  • Auditing Flowchart: Interactive flow diagram detailing SIV minus Consumption, showing remaining NRW volume.
  • IWA Loss Categorization: Splits real water losses (pipe leaks) from commercial losses (under-registration and database gaps).
  • Color-Coded Loss Bars: Compare loss percentages side-by-side for DMA 01, DMA 02, DMA 03, and Non-DMA zones.
IWA Standard NRW Formula DMA Analysis
Flowtrix Minimum Night Flow Diagnostics
07 Analyst+

Minimum Night Flow Diagnostics

Flowtrix's advanced leak detection engine monitors night flow rates, helping operators catch leaks early before they cause major pipe bursts.

  • Configurable Night Window: Custom night hours mapping (02:00–04:00 AM default) aligned with IWA, SPAN Malaysia, and AWWA standards.
  • Baseline Calculations: Q1 (25th percentile), minimum, or median calculations over a 30-day historical window.
  • Excess Flow Analytics: Current night flows vs. historical baselines, calculating excess volume in m³/h.
  • DMA Health Scoring: Overall health rating (0–100%) per DMA, highlighting potential underground leaks.
i20_time_series_raw MNF Analysis IWA/SPAN/AWWA
Flowtrix Real-Time Telemetry Matrix
08 All Roles

Real-Time Telemetry Matrix

A fast, high-density sensor grid displaying current values and health status for all 13 core logger stations. Bulk SQL fetch in ~0.19s execution time.

  • 5-Row Station Grid: SIV Inlet, Storage Reservoirs 1–2, Reservoirs 3–5, DMA Inflow points, and Critical Pressure Points.
  • 8 Core Metrics per Card: Flow rates, inlet/outlet pressure, battery voltage, water levels, temperatures, signal strength.
  • 72-Hour Sparklines: 288 data points per station for clean trendlines of recent performance.
i20_api.db 13 Stations 0.19s Query
Flowtrix Topographical Isobar Mapping
09 All Roles

Topographical Isobar Mapping

An interactive map highlighting pressure distributions and drops across different supply zones to prevent pipeline fatigue and main bursts.

  • Pressure Zone Overlays: Supply areas with transparent overlays, color-coded by pressure levels (blue=high, green=normal, red=low).
  • Critical Point Tracking: Highlights critical network nodes, alerting operators if pressures drop below service agreements.
  • Pressure Drop Warning System: Areas with high pressure drops, pointing to blockages, closed valves, or large leaks.
i20_locations Pressure Telemetry MapLibre GL
Flowtrix Water Storage Reservoir Ledger
10 All Roles

Water Storage Reservoir Ledger

Tracks physical details, dimensions, and capacity calculations for all 9 distribution storage reservoirs.

  • Structured Tank Cards: Logger IDs, structural depths, Top Water Level (TWL), and Bottom Water Level (BWL) figures.
  • Capacity Conversions: Instant conversion between gallons and cubic meters (m³).
  • Water Level Indicators: Visual level bars showing current capacity percentages.
Tank Details.csv 9 Reservoirs TWL/BWL
Flowtrix Tariff & Revenue Loss Ledger
11 Analyst+

Tariff & Revenue Loss Ledger

Links engineering telemetry with financial records, helping management track the monetary value of lost water.

  • Financial KPIs: Total billed amount (RM), billed volume (m³), NRW loss volume (m³), and NRW % for billing cycle.
  • Historical Billing Ledger: Interactive table mapping billed volumes, inlets, and revenue losses month-by-month.
  • Secure Edit System: Authorized admins can update billing entries, adjust tariffs, and add audit notes.
billing_entries flowtrix.db RM Revenue
Flowtrix Centralized Incident Console
12 Operator+

Centralized Incident Console

A centralized console for tracking, filtering, and managing alerts from smart meters and sensors.

  • Status Toggles: Quickly filter between active alerts and historical logs.
  • Diagnostic Filters: Categorize alerts by type: tamper warnings, continuous flow, stuck meters, reverse flow, time sync issues.
  • Map Integration: Click the map icon on any alert to fly directly to the device's location on the Network Map.
8ten_alerts v_alerts_active Real-Time
Flowtrix Pre-Computed Performance Cache
13 All Roles

Pre-Computed NRW Summary

A central ledger showing aggregated network loss calculations over daily, weekly, and monthly intervals.

  • Pre-Computed Aggregates: SIV inlet volumes, DMA inflows, transmission losses, consumer usage, and loss percentages.
  • Transmission Loss Calculations: Verified formula: Transmission Loss = SIV − Combined DMA Inlet − Non-DMA Consumption.
  • Background Cache Refreshes: Auto-refreshes every 5 minutes to protect DB performance.
nrw_summary flowtrix.db 5-min Cache
Flowtrix PDF Automated Compliance Generator
14 Analyst+

PDF Automated Compliance Generator

An automated reporting tool for generating print-ready compliance PDFs of water system metrics using the Python fpdf2 library.

  • Standard NRW Summaries: System-wide monthly reports summarizing water inputs, losses, and financial impacts.
  • DMA Comparison Reports: Performance across DMA zones, highlighting areas with high water losses.
  • Historical Archive: Previously generated reports with download links, file sizes, and creation timestamps.
fpdf2 PDF Export Compliance
Flowtrix Multi-Vendor Pipeline Status
15 Operator+

Multi-Vendor Pipeline Status

A system status panel monitoring connection health across all integrated databases, APIs, and services.

  • Integration Metrics: Active connections, device counts, and records processed over the last 24 hours.
  • Connection Status Lights: Green/orange/red indicators for i20 Sentryx, 8ten, PocketBase, and Resend.
  • Active Ping Tests: Test connection APIs directly from the browser with a single click.
IntegrationService i20 + 8ten PocketBase
Flowtrix RBAC Permission Matrix
16 Admin+

RBAC Permission Matrix

Flowtrix's central security console, allowing administrators to manage user access, assignments, and role permissions across 5 granular user levels.

  • Access Levels: Role summaries and user counts for Superadmin, Admin, Operator, Analyst, and Viewer accounts.
  • Visual Permissions Grid: Matrix mapping all 16 tabs against 5 user roles, showing access levels at a glance.
  • User Role Editor: Assign or change user roles with secure, modal confirmation dialogs.
user_roles 5 RBAC Levels flowtrix.db
Flowtrix Smart Meter Summary Ledger
17 All Roles

Smart Meter Summary Ledger

A consolidated, high-performance table designed for fast loading of all 64 consumer smart meters, pulling cached performance aggregates from flowtrix.db for instant retrieval.

  • Cached Grid Performance: Connects to the database-driven meter cache to fetch status, type, and usage data in milliseconds.
  • Rich Asset Columns: Tracks Location icons, Meter IDs, usage telemetry, online/offline status, and active alert indicators.
  • Interactive Navigation: Location map pins link directly to the GIS spatial visualizer, while meter links jump to the specific fleet manager logs.
  • Admin Rebuild Command: Allows administrators to rebuild the summary cache on demand via a POST request endpoint.
meter_summary flowtrix.db 1-Hour Cache
Standards Based

Defense-in-Depth Security & Compliance

Flowtrix is independently assessed against three compliance pillars covering critical infrastructure security, water industry methodologies, and data governance. Here is where we stand.

Pillar 01

Cyber Security & Critical Infrastructure

IEC 62443 OT/ICS Security — Out-of-band telemetry sync, 5-tier RBAC local authority
Partial
ISO/IEC 27001 ISMS — HMAC-SHA256 tokens, mandatory secrets, nonce-CSP, full audit log
Compliant
NIST SP 800-82 ICS Guide — SHA-256 API keys, raw resolution enforcement, DB isolation
Compliant
Pillar 02

Water Industry & NRW Methodology

IWA Water Loss NRW = Inlet − Consumption, NNF reservoir mass-balance, aggregator filtering
Compliant
AWWA M36 Water Audits — Daily/monthly NRW calculations follow M36 definitions
Partial
ISO 4064 Smart Meters — Flow (L/s→m³/h) and volume (L→m³) conversions verified
Partial
Pillar 03

Data Governance & Privacy

PDPA / GDPR Masked emails, truncated IDs, redacted credentials, anonymized IPs
Compliant
RFC 7519 (JWT) HMAC-SHA256 constant-time comparison, active exp claim enforcement
Compliant
Data Residency Exclusively hosted in Malaysian Tier-III data centers, satisfying local sovereign data residency requirements for government utilities
Compliant
Interactive Tool

Assess Your Water Losses Instantly

See how small reductions in water loss translate directly into municipal revenue recovery.

100,000 m³/mo
70,000 m³/mo
Non-Revenue Water 30.0% 30,000 m³/month
Monthly Lost Revenue RM 45,000 at current NRW level
Est. Financial Recovery RM 22,500 with 50% NRW reduction via Flowtrix
Get In Touch

Modernize Your Water Utility Today

Flowtrix is built and maintained by GeoICON Pte. Ltd. in collaboration with HiWater Sdn Bhd. We partner with water utilities to deploy clean, modern monitoring solutions.

-