This system provides real-time monitoring and automated billing for dam water distribution to third-party vendors in the Nagpur region. Built as an EcoStruxure Geo SCADA Expert clone using advanced IoT protocols including Modbus TCP and OPC UA, powered by TimescaleDB time-series database.
Real-time monitoring with 5-second updates, automated billing, and multi-vendor portals
Built for industrial water distribution management with enterprise-grade reliability and scalability
Monitor flow rates, pressure, total volume, and valve positions with 5-second update intervals. Supports Modbus TCP and OPC UA protocols for seamless RTU and PLC integration.
TimescaleDB-powered time-series database with continuous aggregates. Store raw data for 90 days, 1-minute aggregates for 1 year, and 1-hour aggregates for 5 years.
Generate daily, weekly, and monthly consumption reports automatically. Export to PDF and CSV formats. Email delivery with configurable schedules and pricing rates per cubic meter.
Configurable thresholds for flow rates, pressure anomalies, equipment failures, and communication loss. Multi-channel notifications via email, SMS, and push notifications.
Segregated access with Row Level Security (RLS). Each vendor sees only their supply line data. Role-based access control for admins, vendors, and operators.
React Native apps for iOS and Android. Monitor consumption on the go, receive push notifications, acknowledge alarms, and download reports from anywhere.
Modern, scalable architecture built with industry-leading technologies
Edge server for data acquisition
PostgreSQL with time-series extension
Modern web dashboards
iOS and Android mobile apps
Industrial protocol support
Web hosting and edge deployment
Real-time sensor readings from simulated flow meters
Designed for various water distribution scenarios
Monitor and bill water distribution from dams to industrial facilities. Track consumption patterns, detect leaks early, and ensure fair billing based on actual usage with sub-meter accuracy.
Manage water supply to multiple municipal zones. Real-time monitoring helps identify distribution inefficiencies and optimize pressure management across the network.
Distribute dam water to agricultural cooperatives with precise metering. Seasonal reporting and consumption analytics help farmers plan irrigation schedules efficiently.
Third-party water utility companies can monitor their allocated supply lines. Transparent billing and historical data access build trust and streamline operations.
Immediate alarm notifications for pressure drops, flow anomalies, or equipment failures. Quick response capabilities minimize water loss and service disruptions.
Historical trend analysis with TimescaleDB enables accurate demand forecasting. Plan infrastructure upgrades and maintenance based on actual consumption data.
Common questions about the SCADA water distribution system
The system supports Modbus TCP and OPC UA protocols for communication with RTUs, PLCs, and flow meters. The edge server can be configured to poll devices at custom intervals (default 5 seconds) and includes a built-in simulator for development and testing.
Data is stored in Supabase PostgreSQL with TimescaleDB extension. Raw sensor data is retained for 90 days, 1-minute aggregates for 1 year, and 1-hour aggregates for 5 years. Automatic compression reduces storage costs while maintaining query performance.
Yes. The system implements Row Level Security (RLS) policies in Supabase. Each vendor can only view their assigned supply lines and consumption data. Admins have full system access for monitoring and configuration.
The system supports flow rate alarms (high/low), pressure anomaly detection, equipment failure alerts, communication loss warnings, and total volume threshold notifications. All alarms are prioritized (Critical, High, Medium, Low) and can trigger email, SMS, or push notifications.
Billing reports are generated automatically using Node-Cron scheduler. Daily summaries are emailed at 6 AM, weekly reports every Monday, and monthly invoices on the 1st. All reports include total volume consumed, peak flow rates, average rates, downtime periods, and calculated charges based on configurable rates per cubic meter.
Absolutely. The monorepo architecture with pnpm workspaces supports horizontal scaling. The edge server can be deployed in Docker containers, web dashboards on Vercel, and the Supabase backend scales automatically. The system currently supports 10-50 vendors but can be extended to hundreds with proper infrastructure.
Web dashboards deploy to Vercel with automatic CI/CD. The edge server can be deployed as a Docker container on-premise or in the cloud (AWS, GCP, Azure). Mobile apps are built using Expo EAS Build for iOS and Android. All components connect to the centralized Supabase backend.
Yes. React Native mobile apps are available for iOS and Android. Features include real-time monitoring, push notifications for alarms, consumption history, report downloads, and alarm acknowledgment. Offline mode caches recent data for viewing without connectivity.
Get started with the SCADA Water Distribution System today