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.
Drawings
Claims40
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.
6 more elements
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.
1 more element
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.
1 more element
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.
2 more elements
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.
#The present invention is directed to systems, methods, and computer program products for managing geographically distributed assets and more particularly comprehensive systems, methods, and computer program products for both centralized and remote management of geographically distributed assets such as electric power transmission equipment.
#A more complete appreciation of the present invention, and many of the attendant advantages thereof, will be readily obtained as the same becomes better understood by reference to the following detailed description when considered in connection with the accompanying drawings, wherein:
#FIG. 1 is a block diagram showing an overall system configuration for one embodiment of the present invention;
#FIG. 2 is a block diagram showing mechanisms of a network desktop workstation and a field laptop workstation shown in FIG. 1;
Detailed description4,475 words
#Referring now to the figures, wherein like reference numerals are used to identify the same or corresponding elements throughout the several views, FIG. 1 shows an overall system architecture of the present invention.
#The present embodiment is discussed in the context of the managing an electric power transmission and distribution system. However, the invention may be used to manage assets of other systems, for example, any business that must manage assets that are geographically distributed such as other utilities (e.g., water or gas) where the information about the assets is of interest to both central management personnel, as well as the field technicians responsible for servicing the assets.
#As shown in FIG. 1, the system includes a master database 1 that serves as a central repository for all information regarding the geographically distributed assets. The master database 1 is a commercially available database, such as ACCESS, available from Microsoft Corporation hosted on a computer readable medium. However, other commercially available databases may be used, such as ORACLE, SYBASE, or INFORMIX. In one embodiment, the master database 1 contains all current information of interest on the geographically distributed electric power transmission assets 14 (e.g., transmission lines, poles, maintenance history, etc.). Data in the master database 1 is maintained from a network desktop workstation 2. The network desktop workstation 2 is connected to the master database 1, for example by way of a local area network L1 although other communications links such as a virtual private network, wireless link or Internet-enabled link may be used as well. The desktop workstation 2 interacts with the master database 1 through a software product, one embodiment of which is described by the inventors as “TAMIS”. TAMIS is a software application that uses commercially available geographic information system (GIS) software such as ESRI's ARC/INFO and ARCVIEW GIS products. Through the TAMIS application software and the GIS software, the user is able to create, read, update, and delete the information held in the master database 1 from the network desktop workstation 2. The network desktop workstation 2, through the TAMIS application software and the GIS software, gives those users with appropriate access (e.g., password protected) full capability to maintain the information being held in the master database 1. Furthermore, the information being maintained in the master database 1 may be used for management purposes such as reporting, planning, status checking, budget preparation, etc., presented in written report form, video streaming data, graphical display information, as examples.