Self-reading of water meters via text-messaging

September 18, 2011 - 04:51 -- Water and Sanit...
Revision #27Recommend a SolutionFork
Nairobi

The Problem: The current billing system of Nairobi City Water and Sewerage Corporation (NCWSC) is based on regular water meter reading by utility staff. These utility staffers come to a home and read the installed water-meter that shows cubic meters consumed, and this reading is used to compile a bill which is sent to the consumer. The current system is problematic in a number of ways:

  • In informal settlements, utility reading staff often substitute estimates for actual readings due to security concerns or the absence of tenants. However, consumers have complained about these estimates being inaccurate, often accumulating to unpayably high “burden bills” See a short video on burden bills arising from wrong meter estimates here.
  • In formal settlements, meter reading is often complicated by the absence of tenants who are working during the day and lock their gates/doors so that utility staff can not get access to the water-meters.
  • Even when readings are correct, a problem arises from the fact that these are only done irregularly, leading to large one-off bills. This creates a cash-flow problem for the poor who earn and spend small amounts erratically without saving, and are thus often unable to meet large end-of-month bills.

 

Proposed solution: One solution to this is to allow customers to read their meters and update their bills themselves whenever they want. In principle, NCWSC already allows self-reading of meters, but it currently requires a paper-form to be filled and brought to a central utility office (see a copy of the form here: http://wtrns.fr/1JVOBJwK6Pu6_9). This is complicated, time-consuming and (especially for the poor) almost prohibitively expensive given that informal settlements are far away from central office locations. Moreover, there is still a long delay between the submission of the reading and the updating of the bill, and no reference number is given.

The proposed solution to this is to use an SMS text message or USSD application to submit meter self-readings.  This solution should include the following features:

  • Core functionality:
    • To allow a user to submit a meter reading by text message or USSD, and receive a reference number confirming the receipt of the reading in return. 
    • On the utility (=recipient) side, the submitted readings should show up on a screen (e.g. via a web-app), categorized by customer account number. At this stage, utility staff will simply read off the received readings and enter them manually into the separate billing software. In the future, integration with the billing software may be possible.
  • A number of key variables need to be submitted by the consumer to allow NCWSC to process the reading and match it to a consumer account: (a) meter number; (b) meter reading in cubic meters; (c) account number; (d) date of submission; (e) customer name (optional as double-check)
Recommended Solutions: 
Extra Credit: 

Possible additional functionality:   

  • Deal with submissions that cannot be matched to an account e.g. due to mistyped account number (highlight on recipient app, send an error message to consumer)
  • Once a consumer has sent multiple readings, compute an average and highlight when a new reading is unusually high/low given the time period since last submission
  • Allow utility staff to fill in the updated bill in the app, and have the total new bill sent to the consumer by text message automatically (or alternatively allow online access to the bill). 
Problem Definition Category: 

Comments

A similar project has been done for a municipality on software platform <a href="http://www.sensegrow.com/products/ioeye">ioEYE</a> . The project included monitoring water flow, pollutant levels and PH factor for water supply system in a major city in India. The data is centrally sent over a GPRS device to the software platform (deployed on the cloud). The data can then be analyzed, exported or pulled by other applications (xml) (E.g. for billing purpose). Since the software platform can also monitor energy consumption at pump stations, it can also be used for <a href="http://www.sensegrow.com/products/ioeye-energy">energy management</a>. The software capex and opex cost are minimal as it is offered as a service, which can start from as low as USD 20.0 per month.

Brilliant idea. A few look-out for issues. 1 - How do you deal with fraud? You will come across individuals that will always under-read to get a cheaper bill. 2 - One could match a persons phone number to their account at NCWSC, this way, any SMS/USSD sent from this persons number can quickly bring up the account number. This has a short fall when one number is used for more than one water meter account. Other considerations to look into: 1 - develop and create a digital metering system with a self-submitting system to auto-bill. inbuilt GSM/CDMA/WiFi modules in these meters could be used to contact the central billing areas via a wide area network. One hiccup with this is the power source for the metering device. This could be addresses by having a rotor which is turned when the water is running to charge a (long life) battery in this metering device.
Mike Barnard (not verified) Oct 05, 2011

Camera phones? Would it be feasible in Nairobi to let the user submit a picture of the meter? This would allow a meter reader to "read" the meter back at the office and avoid accidental or deliberate mis-reading by the homeowner.
Jack Hampson (not verified) Oct 14, 2011

On the silly side of suggestions, if one assumed cell users could enable their phones for twitter short code usage (found these for kenya on twitter website - Kenya: 89888 (Safaricom customers); 40404 (Airtel customers) ), users could send a direct message to a specific twitter account and bypass the need for an SMPP stack. operators would read through the inbox. Authentication and receipt message would be more or less manual, but it would be a zero cost solution :-)

 

On the serious side, presumably this means something like using an ESME connector to a paid SMPP provider (also paying for a shortcode). How would this be funded? Otherwise, seems like a pretty straightforward project. (I'm familiar with implementing SMPP in java, but have no knowledge of USSD.)

 

Is there a site for the current status of this project?

jeffery.griffith Dec 09, 2011

UI/UX design support provided by Azavea