WATER METER BILLING & READING
2023
A 3-user water utility billing and meter reading ecosystem built in 2023—combining native Android applications (for Field Meter Readers and Household Consumers), a custom Machine Vision model trained on Roboflow (using the Roboflow Inference API to automatically read water meter digits from camera snaps), and a JavaFX Desktop Administration Suite backed by a centralized PostgreSQL database.
PROBLEM & GOAL
Municipal water utility operations relied on manual field reading logs and disconnected billing sheets, leading to delayed bill computation, human transcription errors when reading physical analog/digital water meters in the field, and limited visibility for household consumers checking their monthly cubic-meter consumption and unpaid balances.
END-TO-END EXECUTION
Engineered an integrated 3-role platform backed by PostgreSQL and Computer Vision. Trained a custom Machine Vision model on Roboflow and integrated its Inference API into the Android Studio Meter Reader app—allowing field readers to tap "Snap", send the meter photo to the Roboflow Inference API, and automatically extract the 8-digit meter reading. Paired this with a Consumer Android app (for real-time billing statements and consumption tracking) and a 12-module JavaFX Desktop Admin application handling consumer connections, residential/commercial rate computation, billing posting, official receipt payment processing, and barangay revenue analytics.
- Custom Machine Vision Model Trained on Roboflow + Inference API Integration
- Android Studio Field Meter Reader App (Camera Snap OCR, Barangay Queue & Digital Entry)
- Android Studio Consumer Mobile App (Live Billing Statement & Consumption View)
- JavaFX Desktop Admin Application (12 Operational & Analytics Modules)
- Centralized PostgreSQL Relational Database & Multi-Role Authentication
- Automated Residential & Commercial Cubic-Meter (m³) Tariff Computation
ROLE MODULE 01 // JAVAFX DESKTOP ADMIN APPLICATION (12 SCREENS)
JavaFX Admin
desktop app.
Full-featured desktop administration suite for the Municipal Water Office—covering consumer registration, meter connection charges, manual/list reading entry, residential & commercial rate computation, billing posting, cashier payment receipts, and barangay analytics.
Main JavaFX command center featuring 12 operational modules (Connection, Reading, Bills & Payment, Consumers Info, User Management, Posting, Transaction History, Analytics, Billing Summary, Reports, Basic Charges, Announcement) with the Residential & Commercial tariff configuration modal.
Executive dashboard displaying Total Revenue Collected, Outstanding Balance, Active Consumers, Unpaid Accounts, Barangay Data bar chart, and Outstanding Payments distribution pie chart.
Meter reading workspace with Manual and Reading List tabs, consumer details, Previous/Current reading in cubic meters (m³), disconnection flagging, and automated Residential rate computation.
Billing verification and posting screen where admins review consumer meter readings, inspect computation details, edit readings if needed, and post official bills to consumer accounts.
Cashier payment terminal calculating bill amounts, penalties, and total payables, tracking outstanding bills, and issuing Official Receipt numbers.
Filterable master ledger of Paid and Unpaid consumer bills with Official Receipt records, payment dates, status filtering, and downloadable reports.
Service connection registration capturing Consumer Details, Meter Details (brand, serial number, size), Installation Breakdown, and Other Charges with receipt generation.
Searchable directory of registered water consumers showing Account No, Name, Barangay, Connection Type (Residential/Commercial), Contact Info, Meter No, and Date Applied.
Consumer account management module with side-panel editing for updating household details, contact information, and barangay codes.
Role-based user administration for creating and managing desktop staff and field meter reader credentials.
Reference table mapping municipal Barangay Codes (B01–B15+) to their respective barangay names for routing and analytics.
Municipal Water Office (Liliw, Laguna) JavaFX desktop login portal.
ROLE MODULE 02 // ANDROID STUDIO APPS + ROBOFLOW MACHINE VISION (6 SCREENS)
Reader & Consumer
Android apps.
Two native Android applications built in Android Studio connected to PostgreSQL: a Field Meter Reader app powered by a custom Roboflow Machine Vision model & Inference API for automated meter digit recognition, and a Consumer app for viewing real-time water bills and consumption.
Native Android login screen for field meter readers.
Meter Reader dashboard tracking total households, completed readings (Done Reading), remaining houses (House to go), and barangays left.
Barangay consumer list (e.g., Bagong Anyo) displaying Meter No, Consumer Name, and Account No for quick field selection.
Digital meter reading card showing Last Month’s reading (00000068) and This Month’s 8-digit boxes—tapping "Snap" captures the physical water meter and calls the custom Roboflow Inference API to detect and return the meter digits automatically.
Native Android login screen for household water consumers.
Consumer billing dashboard showing current Amount to Pay, Unpaid Bills access, Billing Period, Meter No, Previous/Current Reading, Cubic-Meter Consumption (m³), and due date reminder.