Method and systems for default mapping mechanization

• US 6,981,001 B1
• Filed: 09/21/2001
• Issued: 12/27/2005
• Est. Priority Date: 09/21/2001
• Status: Expired due to Fees

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Mankowski, Paul J., Reddick, Charlie, Garris, C. W., Cole, Robert A., Ingman, Robert M., Glascoe, Jr., Roy E.
• Primary Examiner(s): Alam, Shahid Al
• Application Number:
  US09/957,988
• Time in Patent Office: 1,558 Days
• Field of Search: 707/1, 707/2, 707/3, 707/10, 707/100, 707/104.1, 707/6, 701/29, 701/30, 701/208, 701/213, 705/3, 455/456.6, 342/457, 715/506, 715/507, 715/508, 715/516
• US Class Current: 1/1
• CPC Class Codes: G06F 16/9537 Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16H 40/20 for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• 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

Methods and systems are provided for acquiring and assembling customer facility location data from multiple sources. The customer facility location data is subsequently used for the automated dispatching of service technicians in a resource-efficient fashion.

Claims

1. A computer-implemented method comprising:

receiving a file having an incomplete record, wherein the incomplete record comprises a key value and a null location;

extracting the incomplete record from the file;

extracting the key value from the incomplete record;

searching a data repository for the key value, wherein a successful search yields a match record comprising the key value and a non-null location value;

inserting the match record into a match file; and

forwarding the match file to a follow-on processor that reforms the match file and merges match records with a work order database.

2. The method of claim 1, wherein the non-null location value comprises latitude and longitude coordinates.

3. The method of claim 1, wherein the key value comprises a street address.

4. The method of claim 1, wherein the key value comprises a cross-connect identifier.

5. The method of claim 1, wherein the key value comprises a wire center identifier.

6. The method of claim 1, wherein the key value comprises an allocation area identifier.

7. The method of claim 1, wherein the key value comprises at least two of a street address, a cross-connect identifier, a wire center identifier, and an allocation area identifier.

8. The method of claim 1, wherein the data repository comprises at least one database.

9. The method of claim 8, wherein the at least one database comprises a local database and a wire center database.

10. A computer-implemented system comprising:

a receiver for a file having an incomplete record, wherein the incomplete record comprises a key value and a null location value;

an extractor for extracting the incomplete record from the file;

a parser for parsing the key value from the incomplete record;

a data repository;

a database server searching the data repository for the key value, wherein a successful search yields a match record comprising the key value and a non-null location value;

a computer inserting the match record into a match file; and

a follow-on processor receiving the match file, formatting the match file and merging match records with a work order database.

11. The system of claim 10, wherein the non-null location value comprises latitude and longitude coordinates.

12. The system of claim 10, wherein the key value comprises a street address.

13. The system of claim 10, wherein the key value comprises a cross-connect identifier.

14. The system of claim 10, wherein the key value comprises a wire center identifier.

15. The system of claim 10, wherein the key value comprises an allocation area identifier.

16. The system of claim 10, wherein the key value comprises at least two of a street address, a cross-connect identifier, a wire center identifier, and an allocation area identifier.

17. The system of claim 10, wherein the data repository comprises at least one database.

18. The system of claim 17, wherein the at least one database comprises a local database and a wire center database.