Computer based system, computer program product and method for managing geographically distributed assets

• US 6,609,090 B1
• Filed: 03/09/2000
• Issued: 08/19/2003
• Est. Priority Date: 03/10/1999
• Status: Expired due to Fees

• Current Assignee: Public Service Company of New Mexico (PNM Resources Incorporated)
• Original Assignee: Public Service Company of New Mexico (PNM Resources Incorporated)
• Inventors: Garcia, Gathen L., Hickman, Christopher W., Kircher, Theodor E. III
• Primary Examiner(s): Chilcot, Richard
• Application Number:
  US09/521,962
• Time in Patent Office: 1,258 Days
• Field of Search: 705/28, 705/29, 701/200, 701/201, 701/202, 701/207, 701/208, 701/209, 701/211, 701/212, 701/213, 701/214, 701/215, 704/1, 704/9, 704/10, 704/270-276, 707/100-104
• US Class Current: 704/9
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: Y04S 10/50 Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A computer based system, computer program product, and method for managing geographically distributed assets. A computer based system, computer program product, and method are provided for managing geographically distributed electric power transmission assets. Mapping, routing, and asset location information is managed and combined with real time Global Positioning System (GPS) location information to alarm field maintenance and inspection crews prior to inadvertent entry into restricted areas, such as environmentally protected or otherwise restricted lands. Detailed information is maintained on the electric power transmission assets providing management insight into past performance, as well as predictive information as to future costs and performance.

Claims

1. A computer implemented system for managing geographically distributed assets, comprising:

a master database populated with entries associated with said geographically distributed assets, said entries each being associated with one of the geographically distributed assets and having,

an identification indicator,

a geographic location indicator, and

at least one characteristic attribute indicator;

a processor; and

a computer readable medium encoded with processor readable instructions that when executed by the processor implement,

a geo-spatial query generating mechanism that generates a geo-spatial query containing at least one of the identification indicator, the geographic location indicator, and the at least one characteristic attribute associated with the subset of geographically distributed assets, and

a selection mechanism configured to select a subset of the geographically distributed assets based on the geo-spatial query.

2. The system of claim 1, wherein:

the geographically distributed assets comprise electric power transmission equipment.

3. The system of claim 1, wherein:

said master database is further populated with entries having,

a geographic definition of any restricted area within a predetermined distance from the geographically distributed assets.

4. The system of claim 3, wherein:

said master database is further populated with map information.

5. The system of claim 4 wherein:

said computer readable medium is further encoded with processor readable instructions that when executed by the processor further implements,

a route generating mechanism configured to generate a route from a predetermined location to the geographically distributed assets avoiding the restricted areas.

6. The system of claim 1, further comprising:

a mobile processor configured to access said master database.

7. The system of claim 6, wherein:

said mobile processor includes a wireless modern configured to access said master database via a wireless communication channel.

8. The system of claim 6, wherein:

said mobile processor includes a digital camera configured to store digital images in said master database as said at least one characteristic attribute indicator.

9. The system of claim 6, wherein:

said mobile processor includes a removable media drive configured to store thereon query results.

10. The system of claim 6, wherein:

said mobile processor is configured to generate and transmit audio signals associated with said at least one characteristic attribute indicator for the subset of geographically distributed assets from the geo-spatial query to a vehicle sound system connected to said mobile processor.

11. The system of claim 6, wherein:

said mobile processor includes a removable media mass storage device configured to store thereon query results.

12. The system of claim 6, wherein:

said mobile processor includes a global positioning system receiver configured to provide a real time position of said mobile processor.

13. The system of claim 12, wherein:

said master database is further populated with entries having,

a geographic definition of any restricted area within a predetermined distance from the geographically distributed assets; and

said mobile processor is configured to generate an audible alarm indication to a vehicle sound system in response to said mobile processor determining that said real time position and said geographic definition of restricted areas are less than a predetermined margin.

14. The system of claim 12, wherein:

said mobile processor includes a wireless modem configured to transmit said real time position to said processor via a wireless communication channel.

15. The system of claim 6, wherein:

said mobile processor is configured to generate and display visual maps with visual representations of said subset of geographically distributed assets.

16. The system of claim 6, wherein:

said master database is further populated with entries having,

a geographic definition of any restricted area within a predetermined distance from the geographically distributed assets; and

said mobile processor is configured to generate and display visual maps with visual representations of said subset of geographically distributed assets, and said geographic definition of restricted areas.

17. The system of claim 1, further comprising:

a historical database populated with prior versions of said master database.

18. The system of claim 6, further comprising:

a quality control database initially populated with a replica of a current version of said master database, wherein said mobile processor is configured to access and modify said quality control database.

19. The system of claim 18, further comprising:

a web server configured to perform data queries of said quality control database, wherein said quality control database is in a browsable format.

20. The system of claim 18, further comprising:

an e-mail server configured to generate a notification message when a modification is made to said quality control database, and configured to receive from a remote source an authorization message prior to irrevocably modifying said master database.

21. The system of claim 1, wherein:

said computer readable medium is further encoded with processor readable instructions that when executed by the processor further implements,

a report generating mechanism configured to generate a report listing attributes of a subset of the geographically distributed assets.

22. A method of managing geographically distributed assets, comprising the steps of:

populating a master database with data that is descriptive of the geographically distributed assets, data pertaining to historical maintenance and inspection of the geographically distributed assets, geographic location of the geographically distributed assets, map information, and data identifying restricted areas within a predetermined distance from the geographically distributed assets;

generating route information indicating respective locations of restricted areas and candidate routes from a predetermined location to the geographically distributed assets; and

updating the master database from a remote location with updated maintenance and inspection information of the geographically distributed assets.

23. The method of claim 22, wherein:

the geographically distributed assets comprise electric power transmission equipment.

24. The method of claim 22, wherein the step of updating comprises:

populating a quality control database with the data in the master database; and

updating the quality control database from a remote location with updated maintenance and inspection information.

25. The method of claim 24, further comprising the steps of:

generating a notification message when updates are made to the quality control database;

receiving a verification message from a remote terminal of an update event;

copying the data in the master database to a historical database; and

updating the master database if said verification message indicates an approval of said update event.

26. The method of claim 22, further comprising the steps of:

accessing the data pertaining to historical maintenance and inspection of the geographically distributed assets in the master database;

processing the data pertaining to historical maintenance and inspection of the geographically distributed assets; and

generating a report listing attributes of a subset of the geographically distributed assets.

27. The method of claim 22, wherein the step of generating route information comprises:

generating and displaying visual maps on a display indicating respective locations of the geographically distributed assets, the route information, and the restricted areas;

receiving real time position information from a global positioning system receiver; and

generating an audible alarm when a current position of a vehicle in which the display is located and information from the master database indicate the vehicle is nearing an area that has been identified in the master database as a restricted area.

28. A system for managing geographically distributed assets, comprising:

means for populating a master database with data that is descriptive of the geographically distributed assets, data pertaining to historical maintenance and inspection of the geographically distributed assets, geographic location of the geographically distributed assets, map information, and data identifying restricted areas within a predetermined distance from the geographically distributed assets;

means for generating route information indicating respective locations of restricted areas and candidate routes from a predetermined location to the geographically distributed assets; and

means for updating the master database from a remote location with updated maintenance and inspection information of the geographically distributed assets.

29. The system of claim 28, wherein:

the geographically distributed assets comprise electric power transmission equipment.

30. A computer program product, comprising:

a computer storage medium and a computer program code mechanism embedded in the computer storage medium for causing a processor to facilitate the management of geographically distributed assets, the computer program code mechanism comprising;

a first computer code device configured to populate a master database with data that is descriptive of the geographically distributed assets, data pertaining to historical maintenance and inspection of the geographically distributed assets, geographic location of the geographically distributed assets, map information, and data identifying restricted areas within a predetermined distance from the geographically distributed assets;

a second computer code device configured to generate route information indicating respective locations of restricted areas and candidate routes from a predetermined location to the geographically distributed assets and configured to generate and display visual maps with visual representations of at least one of the route information, the restricted areas and the geographically distributed assets; and

a third computer code device configured to update the master database from a remote location with updated maintenance and inspection information of the geographically distributed assets.

31. A mobile processor for facilitating a maintenance of geographically distributed assets comprising:

a wireless modem configured to convey a query message to a master database and configured to receive a reply message from said master database, said master database having entries associated with respective of said geographically distributed assets, said entries each including,

an identification indicator,

a geographic location indicator,

at least one characteristic attribute indicator, and

a geographic definition of any restricted area within a predetermined distance from each of the assets;

a processor; and

a computer readable medium encoded with processor readable instructions that when executed by the processor implement,

a geo-spatial query generating mechanism that generates a geo-spatial query containing at least one of the identification indicator, the geographic location indicator, and the at least one characteristic attribute associated with the subset of geographically distributed assets, and

a selection mechanism configured to select a subset of the geographically distributed assets based on the geo-spatial query.

32. The apparatus of claim 31, wherein:

the geographically distributed assets comprise electric power transmission equipment.

33. The apparatus of claim 31, further comprising:

a digital camera, wherein;

said mobile processor is configured to store digital images from said digital camera.

34. The apparatus of claim 31, further comprising:

a removable media drive configured to store thereon query results.

35. The apparatus of claim 31, wherein:

said mobile processor is configured to generate and transmit audio signals associated with said at least one characteristic attribute indicator for the subset of geographically distributed assets from the geo-spatial query to a vehicle sound system connected to said mobile processor.

36. The apparatus of claim 31, further comprising:

a removable media mass storage device configured to store thereon query results.

37. The apparatus of claim 31, further comprising:

a global positioning system receiver configured to provide a real time position of said mobile processor.

38. The apparatus of claim 37, wherein:

said mobile processor is configured to generate an audible alarm indication to a vehicle sound system in response to said mobile processor determining that said real time position and said geographic definition of restricted areas are less than a predetermined margin.

39. The apparatus of claim 37, wherein:

said mobile processor includes a wireless modem configured to transmit said real time position via a wireless communication channel.

40. The apparatus of claim 31, wherein:

said mobile processor is configured to generate and display visual maps with visual representations of said subset of geographically distributed assets.