PORTFOLIO / 2026 // V2.6 ONLINE
← BACK TO ARCHIVE CASE STUDY // 04 — ANDROID & DESKTOP

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.

+ Android Studio (Java)+ Roboflow Machine Vision+ Roboflow Inference API+ JavaFX (Desktop UI)+ PostgreSQL+ JDBC / REST API+ Multi-Role Architecture (Admin / Reader / Consumer)
04 / ANDROID STUDIO + JAVAFX + ROBOFLOW VISION + POSTGRESQL ORG // Municipal Water Office (Liliw, Laguna)
3 APPS / ROLES
USER ROLES
ROBOFLOW API
AI / VISION
POSTGRESQL
DATABASE
01 // THE CHALLENGE ROLE: Android Studio, JavaFX & Machine Vision Developer

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.

02 // THE SOLUTION YEAR: 2023

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.
DESK 01 // 12-MODULE ADMIN DASHBOARD & BASIC CHARGES ↗

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.
DESK 02 // CONSUMER & BILLING ANALYTICS ↗

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.
DESK 03 // WATER METER READING & COMPUTATION ↗

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.
DESK 04 // BILLING POSTING MODULE ↗

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.
DESK 05 // BILLS & PAYMENT PROCESSING ↗

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.
DESK 06 // BILLING SUMMARY (PAID & UNPAID) ↗

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.
DESK 07 // NEW METER CONNECTION SETUP ↗

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.
DESK 08 // MASTER CONSUMER DIRECTORY ↗

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.
DESK 09 // CONSUMER INFORMATION & ACCOUNT EDITOR ↗

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.
DESK 10 // STAFF & READER USER MANAGEMENT ↗

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.
DESK 11 // BARANGAY MASTER CONFIGURATION ↗

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.
DESK 12 // JAVAFX DESKTOP AUTHENTICATION ↗

Municipal Water Office (Liliw, Laguna) JavaFX desktop login portal.

NEXT CASE STUDY // 05

PLSPCART

PHP + POSTGRESQL / CAMPUS E-COMMERCE

VIEW NEXT PROJECT →