JP4997978B2 - Address information management program, address information management method, and address information management apparatus - Google Patents

Description

  The present invention relates to a program for causing a computer to manage customer address information.

In a distribution center that delivers parts of a device that is operating at a customer to a customer, an address representing the customer's location is managed by the system. A customer engineer (hereinafter referred to as “CE”) is in charge of management for each customer to manage the customer's equipment, and the responsible CE regularly performs maintenance work or resides at the customer's site. . When a part needs to be replaced during maintenance work, the CE requests the delivery center to deliver the part to a customer. The delivery center causes a delivery person or delivery company to deliver the parts to the customer. In the delivery center, the address information in the customer information managed by the system is referred to, and the delivery person or the like is indicated by the map of the location indicated by the address information, and delivery is instructed. Therefore, customer information, especially address information, needs to be up-to-date and accurate. Regarding the maintenance of information in such a database, techniques of the same purpose are described in Patent Document 1, Patent Document 2, and the like.
JP-A-4-177574 JP-A-11-175593

  As described above, it is desired that the customer address information in the database is always up-to-date. However, such information is not automatically updated, and it is not easy to keep the database up-to-date and accurate by changing the notation due to the merger of cities, towns and villages, or by moving the customer's location itself. The main purpose of the present invention is to individually discover address information that needs to be changed for each customer information, and to notify and recognize the fact to the system administrator etc., together with accurate address information or location information. It is to assist the acquisition of.

  The address information management program according to the present invention refers to a customer DB that stores address information of a customer in association with information for identifying the customer, and based on the information for identifying the customer input or received Information indicating a predetermined area associated with information for identifying the customer, first means for obtaining the address information of the customer, second means for displaying the first map of the location indicated by the address information And a fourth means for determining that a deviation between the first map and the second map is within a predetermined range based on the second means for displaying the second map of the predetermined area. And by causing the computer to function as a fifth means for displaying the result of the determination by the fourth means or transmitting it to a predetermined terminal, thereby forming an address information management device and managing customer address information. . That is, the map displayed based on the address information and the map displayed based on the information other than the address information that indicates the location of the customer should be higher than the address information are displayed together. It is discovered that the address information is not accurate due to the large deviation and the maintenance of the database storing the customer information is necessary, and a predetermined person is notified. The difference between the two map displays can be judged automatically by a computer or by the input of the result of judgment by human eyes. As for the former, the map data being displayed usually has both latitude and longitude information. If the difference between the latitude and longitude is within a predetermined range, the address information is accurate and out of range. It is determined that the address information is incorrect. A notification that the address information is inaccurate as a result of the determination may be transmitted to the terminal device held by the CE at the customer. In response to the notification, the CE can input the address information to the terminal device and transmit it to the address information management device when the address information of the customer is known. Alternatively, when the terminal device possessed by the CE has a GPS (Global Positioning System) function, the latitude and longitude of the location of the terminal device are acquired by the GPS function and transmitted to the address information management device. Can do. The address information management device helps the maintenance of the database storing customer information by registering the received address information or latitude and longitude information in the database.

  As described above, according to the present invention, it is possible to individually find that the address information in the database storing customer information is inaccurate and contribute to the maintenance of the database.

  Embodiments of the present invention will be described with reference to the drawings.

FIG. 1 shows an example of the configuration of the present invention. The embodiment shown in FIG. 1 includes a server 1 constituting an address information management device, a terminal 2 for displaying input and output to the server 1, a network 3 connecting the server 1 and the terminal 2, and accessible from the server 1, a database for storing various information (hereinafter referred to as "DB") more configured 41 to 4 5.
The server 1 and the terminal 2 are both configured by a computer.
In the present embodiment, the server 1 and the terminal 2 is configured as a separate computer, which does not exclude that it is configured as a computer that is integral.
Further, D B41 to 45 and require that the server 1 constituting the address information management apparatus capable access references and writing of information, be configured as an internal device of the server 1, or via the network 3 Any of the other devices can be selected.
About the aspect of these structures, the designer of the system containing an address information management apparatus can select suitably.

  The server 1 includes first delivery location display means 11, second delivery location display means 12, location match determination means 13, location mismatch notification means 14, and address information reception means 15.

  The first delivery location display means 11 is used for instructing a delivery destination in a normal delivery operation. At the time of normal delivery instruction, based on the information of the address 414 registered in the customer DB 41, the map data of the customer's location is extracted from the map DB 45, the map data is transmitted to the terminal 2, and displayed by the display means 21. . Then, the map can be delivered by showing the map to the person in charge of delivery. The purpose of the present invention is precisely to keep the information at this address 414 accurate and up to date.

  The second delivery location display means 12 obtains the map data of the location of the customer from the map DB 45 based on information other than the information of the customer's address 414, for example, the information of the postal code 413, from the information specifying the customer. The map data is extracted, transmitted to the terminal 2, and displayed by the display means 21.

  The location coincidence determination unit 13 determines whether the map displayed by the first delivery location display unit 11 matches the map displayed by the second delivery location display unit 12. This determination is based on the input from the user who visually observed the two maps displayed on the display means 21 of the terminal 2 and the difference between the numerical data indicating the display area that the displayed map data should naturally have a predetermined value. It can be considered that the determination is made based on whether or not it exceeds. The numerical data is generally latitude and longitude, but does not exclude the fact that the map data is unique coordinate data.

  The location mismatch notifying unit 14 notifies that when the result of the determination by the location match determining unit 13 is a mismatch. For example, it is conceivable that information indicating that there is a mismatch is transmitted to the terminal 2 and displayed on the display means 21. In addition, information indicating that there is a mismatch can be transmitted to a portable terminal held by a predetermined person by a transmission unit (not shown). This predetermined person can be a CE at the customer.

  The address information receiving means 15 receives the information input by the person who has received the notification that there is a mismatch by the location mismatch notification means 14 and registers the received information in a predetermined field of the customer DB 41. When the address information input by the input means 22 of the terminal 2 is received, the received address information is registered in the field of the address 414 of the customer DB 41. The same applies when address information is received from a mobile terminal held by the CE. In addition, if the mobile terminal is a thing having a GPS function, the latitude and longitude information can be acquired, so the address information receiving means 15 receives the latitude and longitude information transmitted by the mobile terminal, It can also be set as the structure registered into the field of the latitude 416 and the longitude 417 of customer DB41.

  The terminal 2 has a function of transmitting information input by the input unit 22 to the server 1 and displaying information received from the server 1 on the display unit 21. Although only one terminal 2 is shown in FIG. 1, it does not exclude that a plurality of terminals 2 are connected via the network 3.

  The customer DB 41 shown in FIG. 2 is a table that stores information related to various customers in association with a customer name 411 that is information for identifying a customer. The customer ID 412 stores information for uniquely identifying a customer. The postal code information is stored in the postal code 413 field. In general, the postal code information is often associated with the same area even if the address notation of the corresponding area is changed. The customer's address and building name are stored in the address 414 and building name 415 fields. Latitude 416 and longitude 417 are fields for registration when information on the latitude and longitude of the customer's location is received.

  The map search DB 42 shown in FIG. 3 is a table for extracting information on the associated latitude and longitude based on the address information. In the fields of prefecture 421, city 422, town 423, chome 424, and number 425, information on the prefecture, city, town, chome, and number, which are elements of address information, are registered, and fields of latitude 426 and longitude 427 are registered. Stores information on latitude and longitude in association with address information. Latitude and longitude information is stored for each “number” information, but if the address information is not specified up to “number” and has only information on “chome”, it is set to “number one”. The associated latitude and longitude information will be extracted. In addition, when a search is performed based on address information that does not include the information of “town”, information on “latitude” “36.649” and longitude “138.194” which is the location of the Nagano City Hall is obtained. Extracted.

  The zip code DB 43 shown in FIG. 4 is a table that stores a zip code and address information of an area indicated by the zip code in association with each other. The data registered here is provided by a public organization or a similar organization, and it is assumed that the accuracy of the data content is high.

  The latitude / longitude DB 44 shown in FIG. 5 is a table for extracting the latitude and longitude of a representative point of the area from address information indicating a certain range. The data registered here is also premised on having a certain level of reliability.

  Although not shown, the map DB 45 is a database for extracting map data in a predetermined range corresponding to latitude and longitude information.

  Next, processing contents that the address information management program according to the present invention causes the server 1 to perform will be described with reference to processing flowcharts shown in FIGS. The processing described here is usually performed in the scene where parts need to be delivered to the customer and the map information of the delivery destination is acquired from the information identifying the customer such as the customer name. It is a feature of the present invention that maintenance of customer address information is attempted in such a normal use state of the delivery system.

  In step S81, when information on a customer name as a delivery destination to which a part or the like is to be delivered is input to the terminal 2, the server 1 receives the information on the customer name. Here, the description will be given on the assumption that “A publication” or “B electric appliance” is input as the customer name.

  In step S82, the first delivery location display means 11 that has received the data “A publishing” as the customer name refers to the customer DB 41 and reads “Nagano” of the address 414 associated with “A publishing” of the customer name 411. The data of “1-1 Yoshida, Nagano-shi” is acquired. When the data of “B electric appliance” is received as the customer name, the first delivery location display means 11 refers to the customer DB 41 and displays “Nagano” of the address 414 associated with “B electric appliance” of the customer name 411. Data of “2-2 Tokura-cho, Tateshina-gun” is acquired.

  In step S83, the map search DB 42 is referred to, and information on the associated latitude 426 and longitude 427 is acquired based on the address acquired in step S82. When “1-1 Yoshida, Nagano City, Nagano Prefecture” is acquired as address information, referring to the prefecture 421, city 422, town 423, chome 424, and number 425, there is a record corresponding to the address. Therefore, the information of “36.667” of the latitude 426 and “138.217” of the longitude 427 are acquired. If the information of the address “2-2, Tokura-cho, Tateshina-gun, Nagano Prefecture” was acquired, the corresponding record does not exist even if you refer to the prefectures 421 to 425. Information on “36.649” of latitude 426 and “138.194” of longitude 427 of the location of a certain Nagano City Hall is acquired.

  In step S84, referring to the map DB 45, based on the latitude and longitude information extracted in step S83, map data in a predetermined range including the location indicated by the information is extracted, and the extracted map data is stored in the terminal 2. The data is transmitted and displayed on the display means 21. 6 and 7 show screen display examples of the display means 21 of the terminal 2. FIG. When “36.667” and “138.217” are acquired as the latitude and longitude information, the screen display example 61 of FIG. 6 is displayed. When “36.649” and “138.194” are acquired as latitude and longitude information, the screen display example 71 of FIG. 7 is displayed.

  On the other hand, in step S85, with reference to the customer DB 41, information on the postal code 413 associated with the customer such as the input customer name 411 is acquired. When “A publication” is input as the customer name, “381-0043” of the postal code 413 associated therewith is acquired. When “B electric appliance” is input as the customer name, “389-0811” of the corresponding postal code 413 is acquired. The postal code information obtained here is usually kept in correspondence with the area even if there is a change in address display, merger of cities, towns and villages, etc. It is characterized by higher accuracy.

In step S86, the postal code DB 43 is referred to, and information on the associated address 432 is acquired based on the acquired postal code 431 information. When “381-0043” has been acquired as the postal code information, information on “Yoshida, Nagano, Nagano Prefecture” is acquired. When “389-0811” has been acquired as the postal code information, information on “Suzaka, Chikuma City, Nagano Prefecture” is acquired.
In step S87, the latitude / longitude DB 44 is referred to, and information on the associated latitude 442 and longitude 443 is acquired based on the information on the address 441. When “Yoshida Nagano-shi, Nagano Prefecture” is acquired as address information in step S86, information “36.667679” as latitude 442 and “138.221092” as longitude 443 are acquired. When “Suzaka, Nagano Prefecture Chikuma City” is acquired as address information, information “36.500777” as latitude 442 and “138.117309” as longitude 443 are acquired.

  In step S88, referring to the map DB 45, based on the latitude and longitude information extracted in step S87, the map data in a predetermined range including the location indicated by the information is extracted, and the extracted map data is stored in the terminal 2. The data is transmitted and displayed on the display means 21. When “36.667679” and “138.221092” are acquired as the latitude and longitude information, the screen display example 62 of FIG. 6 is displayed. When “36.500777” and “138.117309” are acquired as the latitude and longitude information, the screen display example 72 of FIG. 7 is displayed. Up to this point, when the customer name “A publishing” is input as information for identifying the customer, as shown in the screen display example of FIG. 6, processing of two different systems of data to display the location of “A publishing” Two maps extracted by the above are displayed. That is, the screen display example 61 is based on the information of the address 414 of “A publication”, and the screen display example 62 is based on the information of the postal code 413 of “A publication”. The former is data that is intended to be maintained in the present invention, and the latter is data that is hardly affected by display changes due to mergers of municipalities. Similarly, FIG. 7 shows two maps that display the location of the customer name “B electric appliance”. The screen display example 71 is based on the information of the address 414, and the screen display example 72 is based on the data of the postal code 413. .

  Next, in the place coincidence determination means 13, it is conceivable that the processes of steps S91 to S92 are performed and the processes of steps S93 to S94 are performed.

  Step S91 is a case in which it is determined whether or not two maps displayed visually match each other. The operator of the terminal 2 who has determined that the two maps displayed on the display means 21 of the terminal 2 match more than a certain amount inputs the fact to the input means 22 and does not match if it is determined that they do not match. Enter to the effect. The operator who views the screen display example in FIG. 6 inputs that they match. The operator who has seen the screen display example in FIG. 7 displays a map near Nagano City Hall on one side, and a map near Suzaka in Chikuma City on the other side. To do.

  In step S92, the process proceeds to step S95 if a match is input in step S91, and the process proceeds to step S96 or S97 if a match is input.

  Step S93 is a case where the place coincidence determining means 13 determines whether or not the two maps are coincident with each other regardless of the visual observation of the operator. Each map data usually has both latitude and longitude information. If the difference between the latitude and longitude data is less than or equal to a predetermined value, it can be determined that they match, and if it exceeds a predetermined value, it can be determined that they do not match. For example, if “0.05” is set as the predetermined value, it is determined that the two maps shown in FIG. 6 match, and the two maps shown in FIG. 7 are determined not to match.

  In step S94, if they match as a result of the determination, the process proceeds to step S95, and if it is determined that they do not match, the process proceeds to step S96 or step S97.

  In step S95, the delivery destination location and the map displayed based on the information of the address 414 can be handled as having a certain level of accuracy, so the delivery of parts to “A Publishing” is referred to as the map. Instruct.

  If the two displayed maps do not match as shown in FIG. 7, it is highly likely that the information in the address 414 of the customer DB 41 is incorrect for some reason. That is, the information of the address 414 of “B electric appliance” is in a state requiring maintenance. As a process for the maintenance, there are a case where the process is based on the process of step S96 and a case where the process is based on the process of steps S97 to S99.

  In step S96, the display means 21 of the terminal 2 displays on the display means 21 that the two displayed maps are inconsistent and the information of the address 414 needs to be maintained, and prompts the operator for maintenance. Thus, the operator can recognize that the information of the address 414 of “B electric appliance” in the customer DB 41 is in a state requiring maintenance.

  On the other hand, in step S97, the location mismatch notification means 14 transmits to the portable terminal possessed by a predetermined person that the information of the address 414 is in a state requiring maintenance. The predetermined person mentioned here may be, for example, a CE already stationed at a customer. This CE is a person who needs some parts to be delivered during maintenance of some apparatus at the customer site.

  In step S98, the address information receiving means 15 receives information on the address or latitude and longitude transmitted from the portable terminal. The CE at the customer can recognize that the information of the address 414 is inaccurate, and can transmit the more accurate address of the customer by the portable terminal. Or when the said portable terminal is provided with the GPS function, the information of the latitude and the longitude acquired using the GPS function in the customer can be transmitted.

  In step S99, the address or latitude and longitude information received in step S98 is registered in the address 414 field or latitude 416 and longitude 417 fields of the customer DB 41. By this processing, maintenance of the information of the address 414 of the customer DB 41 is planned, and when the customer's map is to be displayed next time, a more accurate map of the customer is displayed based on the information of the address 414. Can do. Alternatively, if there is registration of latitude 416 and longitude 417 data for the customer, the first delivery location display means 11 of the server 1 recognizes it and displays a map based on the latitude and longitude information. You can also. Furthermore, the second delivery location display means 12 that has recognized that there is registration of latitude 416 and longitude 417 data for the customer, the map is based on the information registered in latitude 416 and longitude 417 in steps S85 to S88. Can be configured to display.

  Although not shown, the server 1 and the terminal 2 are computers in which the entire apparatus is controlled by a CPU (Central Processing Unit). A storage device such as a RAM (Random Access Memory), a hard disk device (HDD), a graphic processing unit, an input interface, a communication interface, and the like are connected to the CPU as needed.

  The RAM temporarily stores at least a part of an OS (Operating System) program to be executed by the CPU and other programs. The RAM stores various data necessary for processing by the CPU. The HDD stores an OS and other programs and data.

  A monitor device is connected to the graphic processing unit. The graphic processing unit displays an input screen or the like on the monitor device in accordance with a command from the CPU. A keyboard and a mouse are connected to the input interface. The input interface transmits a signal sent from a keyboard, a mouse, or the like to the CPU via the bus.

  The communication interface is connected to the network 3. The communication interface exchanges data with each other between the server 1 and the terminal 2 via the network 3.

  The processing contents of the functions that the computer should have can be described in a program recorded on a computer-readable recording medium. By executing this program on a computer, the above processing can be realized on the computer. Examples of the computer-readable recording medium include a magnetic recording device and a semiconductor memory. When distributing to the market, the program is stored in a portable recording medium such as a CD-ROM (Compact Disk Read Only Memory) or a flexible disk, or stored in a computer storage device connected via a network. In addition, it can be transferred to another computer through the network. When executed by a computer, the program is stored in a hard disk device or the like in the computer, loaded into the main memory, and executed.

  The present invention is not limited to the specifically disclosed embodiments, and various modifications and changes can be made without departing from the scope of the claims.

  The present invention may have the following configurations as described below.

(Supplementary Note 1) A program for causing a computer to manage customer address information,
In the computer,
First means for acquiring address information of a customer based on information for identifying or inputting a customer by referring to a customer DB storing address information of the customer in association with information for identifying the customer When,
A second means for displaying a first map of a place indicated by the address information;
A third means for displaying a second map of the predetermined area based on information representing the predetermined area associated with the information for identifying the customer;
A fourth means for determining that a deviation between the first map and the second map is within a predetermined range;
An address information management program for functioning as a fifth means for displaying or transmitting a result of determination by the fourth means to a predetermined terminal.

  (Supplementary Note 2) The second means refers to the DB storing the address information and the latitude and longitude information in association with each other, and adds the latitude and longitude information associated with the acquired address information. The address information management program according to appendix 1, wherein a first map is displayed based on the first map.

  (Supplementary Note 3) Information indicating a predetermined area referred to in the third means is information on a zip code or latitude and longitude stored in a customer DB in association with information for identifying the customer. The address information management program according to appendix 1 or 2, which is characterized by the following.

  (Additional remark 4) The said 4th means determines that a shift | offset | difference is in a predetermined | prescribed range by the input from the user who looked at the display of said 1st map and said 2nd map, The address information management program according to appendices 1 to 3.

  (Additional remark 5) 6th which receives the address information or the latitude and longitude information from the predetermined terminal, and stores the received information or the latitude and longitude information in association with the information for identifying the customer in the customer DB The address information management program according to any one of supplementary notes 1 to 4, wherein the address information management program is further made to function as the above means.

(Supplementary Note 6) A computer is a method for managing customer address information,
The computer
First step of acquiring address information of the customer based on the information for identifying the customer inputted or received with reference to the customer DB storing the address information of the customer in association with the information for identifying the customer When,
A second step of displaying a first map of the location pointed to by the address information;
A third step of displaying a second map of the predetermined area based on information representing the predetermined area associated with the information identifying the customer;
A fourth step of determining that the difference between the first map and the second map is within a predetermined range;
And a fifth step of displaying the result of determination by the fourth means or transmitting the result to a predetermined terminal.

(Appendix 7) A device for managing customer address information,
A customer DB storing address information of the customer in association with information for identifying the customer;
A first means for referring to the customer DB and acquiring address information of the customer based on information for identifying the customer inputted or received;
A second means for displaying a first map of a place indicated by the address information;
A third means for displaying a second map of the predetermined area based on information representing the predetermined area associated with the information for identifying the customer;
A fourth means for determining that a deviation between the first map and the second map is within a predetermined range;
An address information management apparatus comprising: fifth means for displaying a result of determination by the fourth means or transmitting the result to a predetermined terminal.

It is a block diagram for implement | achieving this invention. An example of a customer DB is illustrated. An example of a map search DB is illustrated. An example of a zip code DB is illustrated. The example of latitude longitude DB is illustrated. The example of a screen display is illustrated. The example of a screen display is illustrated. It is a flowchart explaining the content of the process of an address information management program. It is a flowchart explaining the content of the process of an address information management program.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Server 11 1st delivery location display means 12 2nd delivery location display means 13 Location match judgment means 14 Location mismatch notification means 15 Address information reception means 2 Terminal 21 Display means 22 Input means 3 Network 41 Customer DB
42 Map Search DB
43 Postal code DB
44 Latitude / Longitude DB
45 Map DB

Claims (5)

A method of managing customer information, including customer identification information, address information, and postal code, wherein a computer communicating with a terminal comprises:
From the information specifying the customer received from the terminal, search the address information and the zip code,
Search the postal code DB for local address information corresponding to the postal code,
From the map search DB, search the first location information corresponding to the address information and the second location information corresponding to the area address information,
From the map DB, the first and second maps corresponding to the first position information and the second position information are searched and displayed on the terminal,
When a request for maintenance of customer information and new address information are received from the terminal, a process for rewriting the address information with the new address information is executed. . A method for managing customer information according to claim 1, comprising:
The customer information includes latitude and longitude information,
In the process of displaying the computer,
When it is determined that the latitude / longitude information is input to the customer information corresponding to the information specifying the customer received from the terminal ,
A method for managing customer information, wherein first and second maps respectively corresponding to the latitude / longitude information and the second position information are retrieved from the map DB and displayed on the terminal, respectively. . A method for managing customer information according to claim 2, comprising:
The computer further includes:
When the terminal has a function of acquiring position information, when the maintenance request for the customer information and new latitude / longitude information are received from the terminal, the latitude / longitude information is obtained from the new latitude / longitude information. A method for managing customer information, characterized by executing a rewriting process . A program that causes a computer to execute processing for managing customer information including customer identification information, address information, and postal code,
In the computer,
From the information identifying the customer received from the terminal, the address information and the zip code are searched,
Search the postal code DB for local address information corresponding to the postal code,
From the map search DB, search the first location information corresponding to the address information and the second location information corresponding to the area address information,
From the map DB, the first and second maps corresponding to the first position information and the second position information are searched and displayed on the terminal,
When the customer information maintenance request and new address information are received from the terminal, the address information is rewritten with the new address information.
A program for managing customer information, characterized in that processing is executed. A device for managing customer information including customer identification information, address information, and postal code,
A storage unit for storing a zip code DB, a map search DB, and a map DB;
The address information and the zip code are searched from the information specifying the customer received from the terminal, the local address information corresponding to the zip code is searched from the zip code DB, and the map search D
The first position information corresponding to the address information and the second position information corresponding to the area address information are searched from B, and the first position information and the second position information are respectively searched from the map DB. The first and second maps are retrieved and displayed on the terminal, respectively, and when the customer information maintenance request and new address information are received from the terminal, the address information is rewritten with the new address information. A device for managing customer information.

Images