Method and system for providing a self-populating database for the network collection of meter data

• US 7,930,392 B2
• Filed: 08/06/2008
• Issued: 04/19/2011
• Est. Priority Date: 02/25/2008
• Status: Active Grant

• Current Assignee: Badger Meter Incorporated
• Original Assignee: Badger Meter Incorporated
• Inventors: Saadeh, Theresa M., Malinowski, Michele R. B.
• Primary Examiner(s): Ismail; Shawki S
• Assistant Examiner(s): SHAW, ROBERT A
• Application Number:
  US12/186,895
• Publication Number:
  US 20090216878A1
• Time in Patent Office: 986 Days
• Field of Search: 709/224, 709/217, 340/870.02
• US Class Current: 709/224
• CPC Class Codes: G01D 21/00 Measuring or testing not otherwise provided for
• CPC Class Codes: G01D 4/002 Remote reading of utility meters
• CPC Class Codes: Y02B 90/20 Smart grids as enabling technology in buildings sector smart grids supporting the management or operation of end-user stationary applications in general, or like technologies with no associated climate change mitigation effect Y04S20/00
• CPC Class Codes: Y04S 20/30 Smart metering, e.g. specially adapted for remote reading

Abstract

The invention provides a method and a system for collection of meter readings from the field and for providing a self-populating database for storing and retrieving the meter data. A network data collection computer operating according to a stored computer program reads in data from the receivers and detects the meter reading devices that are sending data through a respective receiver. If not previously detected, the network data collection computer allocates space in the database for the data and stores the meter data and indexes it by the receiver and meter reading device from which it was received, and by the date and time of reception at the network data collection system. This data can then be retrieved and displayed or printed out by these parameters in database reports.

Claims

1. A method for collection of meter reading data at a data collection computer through a wide area network from at least one receiver communicating in a local area fixed network with a plurality of meter reading devices, the method comprising:

addressing at least one receiver through a wide area network at a receiver network address, wherein the receiver communicates with a plurality of meter reading devices located within a geographic area served by a utility;

receiving a data file through the wide area network from the receiver that includes meter data from a plurality of meter reading devices that have previously communicated with the receiver;

reading a meter reading device identifier for each of the meter reading devices from the data file and automatically setting up a database including organizing the meter reading device identifier in the database in association with the receiver network address and in association with the meter data for each respective meter reading device;

storing meter data from each of the meter reading devices in the database for retrieval by at least one of;

a receiver address, the meter reading device identifier and a time and date of collection; and

wherein setting up the database includes setting up a plurality of receiver records such that the data collector addresses each of a plurality of receivers at scheduled times, according to a reading schedule, and wherein the meter data is stored in the database by a time and date of collection.

2. The method of claim 1, wherein the wide area network is the Internet.

3. The method of claim 2, wherein the receiver network address is an Internet Protocol address.

4. The method of claim 2, wherein the receiver network address is a uniform resource locator (URL).

5. The method of claim 1, wherein the meter reading devices include devices for reading condition status data related to a meter or to supply links connected to the meter, and wherein the meter data includes the condition status data.

6. The method of claim 1, wherein the data file received through the wide area network is an HTML-coded web page of data, and wherein the data collector decodes the data file for storage of the meter reading data in the database.

7. The method of claim 1, wherein the data collection computer communicates with a plurality of fixed network receivers through the wide area network, and further comprising calculating a percentage of the meter devices reporting from each respective fixed network receiver over a selected time period and displaying certain location points on a map, wherein the points on the map are color-coded and displayed according to the percentage of meter data devices from which data was collected for each respective fixed network receiver.

8. The method of claim 1, wherein the identifier for each meter reading device is a serial number.

9. A meter data collector for use in collection of utility meter data at a data collection center from at least one receiver for communicating in a local area fixed network with a plurality of meter reading devices, the meter data collector comprising a computer program stored in a tangible, non-transitory medium, for execution by a network meter data collection computer, the meter data collector comprising:

a network reader portion executable by the network meter data collection computer for addressing at least one receiver through a wide area network at a receiver network address, wherein the receiver communicates with a plurality of meter reading devices located within a geographic area served by a utility;

the network reader portion receiving a data file through the wide area network from the at least one receiver that includes meter reading data from a plurality of meter reading devices that have previously communicated with the receiver;

a database organization portion for detecting a meter reading device identifier for each of the meter reading devices from the data file, and executable by the network meter data collection computer for setting up a database including adding each of the meter reading devices to the database by organizing the meter reading device identifier for each meter reading device in the database in association with the receiver network address and the meter data for the respective meter reading device;

a database reports portion executable by the network meter data collection computer for retrieving meter data for each of the meter reading devices according to each of;

a receiver network address, a meter reading device identifier and a time and date of collection; and

wherein setting up the database includes setting up a plurality of receiver records for a respective plurality of receivers, wherein the network reader portion addresses the receiver at scheduled times, according to a reading schedule, and wherein the meter data is stored in the database by the time and date of collection.

10. The meter data collector of claim 9, wherein the wide area network is the Internet.

11. The meter data collector of claim 9, wherein the receiver network address is an Internet Protocol address.

12. The meter data collector of claim 9, wherein the receiver network address is a uniform resource locator (URL).

13. The meter data collector of claim 9, wherein the meter reading devices include devices for reading condition status data related to a meter or to supply links connected to the meter, and wherein the meter reading data includes the condition status data.

14. The meter data collector of claim 9, wherein the data file received through the wide area network is an HTML-coded web page of data, and wherein the data collector decodes the data file for storage of the meter reading data in the database.

15. The meter data collector of claim 9, wherein the meter data collector communicates with a plurality of fixed network receivers through the wide area network, and further comprising a calculating portion for calculating a percentage of the meter devices reporting from each respective fixed network receiver over a selected time period and a display portion for displaying certain location points on a map, wherein the points on the map are color-coded and displayed according to the percentage of meter data devices from which data was collected for each respective fixed network receiver.

16. The meter data collector of claim 9, wherein the identifier for each meter reading device is a serial number.