Method and apparatus for auditing utility poles

• US 7,752,234 B2
• Filed: 07/31/2007
• Issued: 07/06/2010
• Est. Priority Date: 07/31/2007
• Status: Expired due to Fees

• Current Assignee: Embarq Holdings Company LLC (Lumen Technologies, Inc.)
• Original Assignee: Embarq Holdings Company LLC (Lumen Technologies, Inc.)
• Inventors: Chaitman, Eric, Radel, William A., Morris, Dana
• Primary Examiner(s): Breene; John E
• Assistant Examiner(s): Ly; Anh
• Application Number:
  US11/888,089
• Publication Number:
  US 20090037485A1
• Time in Patent Office: 1,071 Days
• Field of Search: 707/1, 707/3, 707 5- 6, 707/100, 707/802, 707/805, 707/770, 705/1, 705/3, 705/8, 705/11, 705/26, 705/37, 705/40, 702/188
• US Class Current: 707/802
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: G06Q 50/06 Energy or water supply

Abstract

An apparatus and method for managing utility pole information is provided in the illustrative embodiments. A method for managing the utility pole information may include creating several audit forms and searching those forms for an audit of a selected pole. The method may further include pre-populating the audit form with data from a repository of engineering work orders. The method may further include recording general pole information, a pole inspection information, a pole test information, a first attachment information, and inspector'"'"'s notes about the selected pole on the audit form resulting in an updated audit form. The method may then transfer the updated audit form to a repository of utility poles audit information.

Claims

1. A method for managing utility pole information, the method comprising:

creating a plurality of audit forms;

searching for an audit form from the plurality of audit forms for an audit of a selected pole;

pre-populating the audit form with data from a repository of engineering work orders;

recording utility pole audit information of the selected pole audited by an auditor on the audit form;

determining if the selected pole has been previously audited;

searching for an audit form including audit information about the selected pole if the selected pole has been previously audited;

tracking an open item in the audit information;

updating the audit information;

forming an updated audit form;

transferring the updated audit form to a repository of utility poles audit information; and

controlling user access for creating and searching functions.

2. The method of claim 1, further comprising:

generating a report from at least one of the repository of utility poles audit information and repository of engineering work orders.

3. The method of claim 1, wherein transferring the updated audit form to a repository of utility poles audit information includes transferring updates of:

an inspection date;

one of a company pole identification, and a foreign pole identification;

a lead;

a pole structure;

a wire center, one of a grid code, and an original grid code;

one of a global positioning location, and other location information;

an inspector'"'"'s name;

a status of the utility pole wherein the status indicates one of a non-existence of the utility pole, and the utility pole being a foreign pole;

a height of the utility pole in an engineering work order;

a measured height of the utility pole;

a class of the utility pole in the engineering work order;

a material of the utility pole in the engineering work order;

a year of placement of the utility pole in the engineering work order;

an indication of a type inspection test conducted;

an indication of one of inspection passed, and inspection failed;

an indication of the utility pole being one of overstressed and not overstressed;

notations of a set of regulatory violations;

data for a set of attachments on the utility pole;

a set of work activities to be performed on the utility pole;

a notation of the inspector'"'"'s recommendation; and

a notation of the inspector'"'"'s comments on the set of work activities.

4. The method of claim 1, further comprising updating the repository of engineering work orders using the updated audit form.

5. The method of claim 1, further comprising:

generating an improper plant condition ticket if the completed audit form includes an indication of a regulatory violation.

6. The method of claim 1, further comprising determining an entity based on a boundary map that identifies the entity likely to install the attachment in a given geographical area.

7. The method of claim 1, further comprising:

comparing the first attachment information of the selected pole to a second attachment information of the selected pole in a database; and

adjusting billing and taxation information based on a difference between the attachment information and the second information.

8. The method of claim 1, wherein the utility pole audit information includes general pole information, a pole inspection information, a pole test information, a first attachment information, and inspector'"'"'s notes about the selected pole.

9. A system for managing utility pole information, the system comprising:

a first database configured to manage information associated with a plurality of utility poles, wherein the first database is an engineering work order database;

a first processing unit in communication with the first database and configured to extract at least a portion of the information in the first database to form extracted information;

a second database in communication with the first processing unit and configured to store the extracted information, wherein the second database includes additional fields of information not included in the first database, and wherein the additional fields include at least one of information for corrective action to a utility pole, and information of a utility pole not complying with a regulatory standard;

a second processing unit in communication with the second database and configured to execute a software program that, when executed by the second processing unit, causes a graphical user interface to be presented to a user to verify and update the utility pole information stored in the second database; and

a third processing unit in communication with the first database and configured to generate at least one report.

10. The system of claim 9, wherein the second processing unit operates within a portable computing device, the system further comprising:

a third database operating in the portable computing device and configured to store at least a portion of the information in the second database.

11. The system of claim 10, wherein the second processing unit is configured to operate with the third database, and at least one of update the information in the second database and update the information in the third database.

12. The system of claim 9, wherein the second processing unit is configured to update the first database with updated information in the second database.

13. The system of claim 9, wherein the extracted information includes a global positioning information associated with a location of a utility pole.

14. A method for managing utility pole information, the method comprising:

managing information associated with a plurality of utility poles in a first database, wherein the first database is an engineering work order database;

extracting using a first processing unit in communication with the first database, at least a portion of the information in the first database to form extracted information;

storing the extracted information in a second database in communication the first processing unit, wherein the second database includes additional fields of information not included in the first database, and wherein the additional fields comprise at least one of information for corrective action to a utility pole, and information of a utility pole not complying with a regulatory standard;

updating the first database with updated information in the second database, using the second processing unit;

presenting a graphical user interface to a user to verify and update the utility pole information stored in the second database using a second processing unit in communication with the second database; and

generating at least one report using a third processing unit in communication with the first database.

15. The method of claim 14, wherein the second processing unit operates within a portable computing device, the method further comprising:

storing at least a portion of the information in the second database in a third database operating in the portable computing device.

16. The method of claim 15, further comprising:

updating at least one of the information in the second database and the information in the third database, using the second processing unit configured to operate with the third database.

17. The method of claim 15, wherein the extracted information includes a global positioning information associated with a location of a utility pole.