JPH06110941A - Data retrieval system - Google Patents

Abstract

PURPOSE:To connect map data with the customer data of a customer included in the map data, and to simultaneously output them. CONSTITUTION:A supply tube in the map displayed at a map data processing system 1 is designated, and the number of the supply tube is transmitted through a communication line 5 to a customer data processing system 3. The customer data processing system 3 retrieves the customer number corresponding to the transmitted number of the supply tube by a table 41, retrieves the data attendant customer number from a customer data base 39, transmits the data related with the retrieved customer through the communication line 5 to the map data processing system 1. Then, the map data and the customer data are displayed on the display of the map data processing system 1.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data retrieval system for connecting a map data processing system and a customer data system via a communication line and simultaneously outputting data between both systems.

[0002]

2. Description of the Related Art In recent years, there is a computer mapping system for adding information such as buried pipes to map information such as city blocks and topography to make a database. In such a computer mapping system, information such as the space between buried pipes is added to the map and output as map data, which is used for buried pipe management, conduit network analysis, emergency search, and the like.

On the other hand, public offices, electric power companies, gas companies, telephone companies, etc. have computer systems for processing customer information in a database. In such a system, information such as customer information and building information is output as character numerical value information.

However, an accident occurred in the buried pipe,
In the case of urgent repair, etc., if map information and customer information consisting of numerical character information are output to separate displays, it is difficult to immediately notify the repair work vehicle of the accident site. It was Thus, in consideration of security and the like, it is desired that map data and customer information be simultaneously output to the same display or the like.

[0005]

As described above, it has been recently demanded to output map data and customer data at the same time.

The present invention has been made in view of such a demand, and an object thereof is to provide a data search system capable of simultaneously outputting map data and customer data of a customer included in the map data. It is in.

[0007]

In order to achieve the above-mentioned object, a first invention is a first input means, a first output means, at least identification data of an object and coordinate data of the object. A map data processing system having a first storage means for storing the above, a second input means, a second output means, and a second storage means for storing at least the customer identification data and the customer data. A customer data processing system having, a communication line connecting the map data processing system and the customer data processing system, and one of the map data processing system or the customer data processing system, the identification data of the object and the When the table showing the correspondence with the customer identification data and the identification data of the object are designated using the first input means or the second input means, the designation is made. Means for reading the customer identification data corresponding to the identification data of the elephant from the table, means for reading the customer data corresponding to the read customer identification data from the second storage means, and identification data for the designated object Means for reading coordinate data corresponding to the first storage means, map data based on the coordinate data read from the first storage means, and customer data read from the second storage means. 1 output means and / or means for outputting to the second output means.

A second invention is a map having first input means, first output means, and at least first storage means for storing identification data of an object and coordinate data of the object. A customer data processing system having a data processing system, a second input means, a second output means, and at least a second storage means for storing customer identification data and customer data, and the map data processing system. A communication line coupling the customer data processing system, a table provided in one of the map data processing system or the customer data processing system, and showing a correspondence between the identification data of the object and the customer identification data; When the customer identification data is designated using the first input means or the second input means, the identification data of the object corresponding to the designated customer identification data is displayed. From the table, means for reading the customer data corresponding to the read customer identification data from the second storage means, and coordinate data corresponding to the identification data of the designated object from the first storage means. Reading means, map data based on the coordinate data read from the first storage means, and customer data read from the second storage means, the first output means and / or the second output. And a means for outputting the data to the means.

[0009]

In the first aspect of the present invention, when the identification data of the object is designated by using one of the input means of the map data processing system or the customer data processing system, the identification data of the object is dealt with. The customer identification data is read from the table, the coordinate data corresponding to the object and the customer data corresponding to the customer identification data are read, and the map data and the customer data based on the read coordinate data are output to the output means. .

In the second invention, when the customer identification data is designated by using one of the input means of each of the map data processing system or the customer data processing system, the object identification corresponding to the customer identification data is identified. The data is read from the table, the coordinate data corresponding to the object and the customer data corresponding to the customer identification data are read, and the map data and the customer data based on the read coordinate data are output to the output means.

[0011]

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

FIG. 1 is a block diagram showing a schematic configuration of a data search system according to an embodiment of the present invention. Less than,
A gas supply pipe will be described as an example of the object.

As shown in FIG. 1, in this data search system, a map data processing system 1 and a customer data processing system 3 are connected by a communication line 5. This communication line is a line such as a digital line or a wireless line.

The map data processing system 1 has a computer 11, an external storage device 13, a search output terminal 15, a digitizer 17, a tablet 19, a display 21, a hard copy 23, an electrostatic plotter 25 and the like.

The computer 11 causes the display 21 to display the map data in the map database 27 stored in the external storage device 13 in accordance with a command input from an input device such as the digitizer 17 or the tablet 19, or communicates with the map data. Processing such as data communication with the customer data processing system 3 via the line 5 is performed.

The external storage device 13 is a map database 2
This map database 27 stores about 2700 national basic maps with a scale of 1/500, and is saved in a form in which figure data such as supply pipes are written by the digitizer 17 on this national basic map. is doing. A drawing number is attached to each drawing. Further, this map database 27 has supply pipe information 29.

FIG. 2 shows the data format of the supply pipe information 29. The data of one block consists of "supply pipe number", "pressure", "caliber", "attribute data" and "coordinate data (x ₁ , y ₁ , x ₂ , y ₂ ...)". The “supply pipe number”, which is the identification number of the object, is the number given to the gas supply pipe laid by each customer. "Pressure" indicates whether the gas pressure in the supply pipe is high or low. The "caliber" indicates the diameter of the supply pipe. The attribute data indicates a pipe type, a pipe burying date, a pipe material, and the like. "Coordinate x ₁ ,
“Y ₁ ” indicates the coordinates of the inflection point when, for example, the supply pipe buried in a straight line is bent. For the data format of this map data processing system, refer to PC / Mapping Introduction, K. For more information, see WESTLAND, Nikkan Kogyo Shimbun, page 79.

The search output terminal 15 is composed of, for example, a personal computer, and is used when a desired portion of one piece of map data displayed on the display 21 is designated by a rectangle to define a setting area.

The digitizer 17 is used, for example, when writing or modifying graphic data of a supply pipe or the like on one map, or when instructing the coordinates of this supply pipe.

The tablet 19 is used when designating the drawing number of the map database 27 in the external storage device 13.

On the display 21, for example, one map is displayed, and a hard copy 23 and an electrostatic plotter 25 are displayed.
Outputs the image data displayed on the display 21 onto a sheet.

When the map data processing system 1 is used alone, for example, a desired drawing number is input by the tablet 19, a map having this drawing number is searched from the map database 27 and displayed on the display 21. It And writing graphic data such as supply pipe,
Correction and the like are performed using the digitizer 17. Then, the corrected map data is stored again in the map database 27.

Next, the customer data processing system 3 will be described.

The customer data processing system 3 has a computer 31, a keyboard 33, a display 35, an external storage device 37 and the like.

When a customer number or the like is input from the keyboard 33, the computer 31 retrieves customer data having this customer number from the customer database in the external storage device 37 and displays it on the display 35 or the communication line 5. Through this, processing such as data communication between the map data processing system and the like is performed.

The external storage device 37 is the customer database 3
9 and a table 41 are stored. The customer database 39 is composed of data regarding each customer.

FIG. 3 shows a datafort of the customer database 39. The "customer number" as customer identification data and the "address", "address", "name", "telephone number" as customer data. , "Meter number", "Meter value of the month before last", "Meter value of previous month", "Meter value of this month"
It consists of information such as.

The "customer number" is a number given to each customer and includes "address", "address", "name", "telephone number",
The "meter number" is the address, address, name, telephone number, and meter number of the customer. The meter value such as "meter value before two months" indicates the meter value of the gas meter for the month.

The table 41 is a table showing the relationship between the customer number and the supply pipe number. FIG. 4 shows an example of the table. In the figure, the customer A ₁ is supplied to the supply pipe B ₁ ,
The assignment of B ₂ and B ₃ corresponds to the case where, for example, a customer such as a factory has three supply pipes. Two customers A ₂ and A ₃ are assigned to the supply pipe B ₄ , for example, in an apartment house such as an apartment.
This corresponds to the case where there are multiple customers for one supply pipe.

Next, the operation of this embodiment will be described with reference to the flow charts shown in FIGS.

First, when the operator on the side of the map data processing system 1 inputs a desired drawing number or address using the tablet 19 (step 501), the computer 11 reads the map corresponding to this drawing number or address from the map database 27. It searches and displays this map on the display 21 (step 502). When the operator further designates a rectangular area of the map displayed on the display 21 as the setting area by the search output terminal 15 (step 503), the map of the setting area is displayed on the display 21 (step 504). ). This map is for example
As shown in FIG. 7B, this map is displayed on the entire surface of the display 21. Since there are usually a plurality of supply pipes in this setting area, the digitizer 17 is operated to move the cursor to the desired supply pipe on the display 21 to specify the supply pipe (step 505).

The computer 11 reads the supply pipe information 29 of the specified supply pipe from the map database 27,
Supply pipe number of this supply pipe information 29 (for example, 35-755
726-851) to the customer data processing system 3 via the communication line 5 (step 506).

In the customer data processing system 3, the customer number corresponding to the supply pipe number sent from the computer 31 (for example, 13-5270-3384, 13-52).
70-2950, ...) Is searched in the table 41 (step 507), and the customer data such as “address”, “address”, “name” etc. is searched from the customer database 39 using this customer number as a key (step 508). ).

Further, of the retrieved customer data, predetermined data ("address," address "," name "," telephone number ") is sent to the map data processing system 1 via the communication line 5 (step 509). Here, only necessary items are sent. For example, data such as the previous month's meter value is
Not sent to the map data processing system 1.

In the map data processing system 1, the computer 11 displays the data and the map data sent from the customer data processing system 3 on the display 21 (step 510) and, if necessary, on the display 21. The hard copy 23 or the electrostatic plotter 25 prints the generated image data on a sheet.
FIG. 7 shows an example of the display screen on the display 21 in step 509. As shown in the figure, the customer data processing system 3 is displayed on the display 21.
Customer data A sent from the company and map data B including a gas supply pipe are displayed on one screen. In this case, "Takara Heights" is an apartment house, and there are multiple customers for one supply pipe.

As described above, since the customer data A and the map data B in the setting area are simultaneously displayed on one screen, when there is an accident such as a gas leak and the customer calls the customer, The position can be easily checked, the position can be accurately notified to the accident handler, and the accident can be dealt with early.

The present invention can be modified in various ways.

For example, in the above-described embodiment, the customer data processing system 3 has the table 41. However, conversely, this table may be stored in the external storage device 13 of the map data processing system 1. .

In the above-described embodiment, the operator of the map data processing system 1 specifies the supply pipe on the map,
Although this supply pipe number is sent to the customer data processing system 3, on the contrary, the operator of the customer data processing system 3
It is also possible to specify a customer number, search the supply pipe number corresponding to this customer number in the table 41, and send this supply pipe number to the map data processing system.

Further, in the above-described embodiment, the display 21 of the map data processing system 1 on the input side is configured to display as shown in FIG. 7, but it may be displayed on the display opposite to the input side (for example, , When the input is designated from the map data processing system 1, it is displayed on the display 35 of the customer data processing system 3. Conversely, when the input is designated from the customer data processing system 3, the display of the map data processing system 1 is displayed. It is also possible to display as shown in FIG. 7 on both displays.

When the map data processing system 3 is installed in an accident handling vehicle or the like, the display 3 on the side of the accident handling vehicle is displayed.
If these information can be displayed in 5, the accident site can be accessed immediately.

Further, in the above-mentioned embodiment, the customer number is taken as the customer identification data, but the customer identification data may be a meter number or a telephone number.

In the above-mentioned embodiment, the gas supply pipe has been described as an example of the object. However, in addition to the gas supply pipe, a water supply pipe, a sewer pipe, a house, a telephone line, a power line, a telephone pole, and a power pole are targeted. You can also do it.

[0044]

As described above in detail, according to the present invention, it is possible to provide a data search system capable of simultaneously outputting map data and customer data of customers included in the map data.

[Brief description of drawings]

FIG. 1 is a block diagram showing a schematic configuration of a data search system according to an embodiment of the present invention.

FIG. 2 is a diagram showing a data format of a map database 27.

FIG. 3 is a diagram showing a data format of a customer database 39.

FIG. 4 is a diagram showing correspondence between customer numbers and supply pipe numbers in the table 41.

FIG. 5 is a flowchart showing the operation of this embodiment.

FIG. 6 is a flowchart showing the operation of this embodiment.

FIG. 7 is a diagram showing customer data and map data displayed on the display.

[Explanation of symbols]

 1 ... Map data processing system 3 Customer data processing system 5 Communication line 11 Computer 13 External storage device 15 Search output terminal 17 Digitizer 19 … Tablet 21 ……… Display 23 ……… Hard copy 25 ……… Electrostatic plotter 31 ……… Computer 33 ……… Keyboard 35 ……… Display 37 ……… External storage device

Claims (13)

[Claims] 1. A first input means, a first output means, and
A map data processing system having at least identification data of an object and first storage means for storing coordinate data of the object, second input means, second output means, and at least customer identification data. Second storage means for storing customer data;
A customer data processing system, a communication line connecting the map data processing system and the customer data processing system, and one of the map data processing system or the customer data processing system, the identification data of the object, When the table showing the correspondence with the customer identification data and the identification data of the target object are designated using the first input means or the second input means, the table corresponds to the designated identification data of the target object. Means for reading customer identification data from the table; means for reading customer data corresponding to the read customer identification data from the second storage means; coordinate data corresponding to identification data of a designated object; Means for reading from the storage means, and map data based on the coordinate data read from the first storage means A data retrieval system, comprising: the customer data read from the second storage means; and means for outputting the customer data to the first output means and / or the second output means. 2. A first input means, a first output means, and
A map data processing system having at least identification data of an object and first storage means for storing coordinate data of the object, second input means, second output means, and at least customer identification data. Second storage means for storing customer data;
A customer data processing system, a communication line connecting the map data processing system and the customer data processing system, and one of the map data processing system or the customer data processing system, the identification data of the object, A table showing correspondence with the customer identification data, and when the customer identification data is designated using the first input means or the second input means, identification of an object corresponding to the designated customer identification data Means for reading data from the table; means for reading customer data corresponding to the read customer identification data from the second storage means; coordinate data corresponding to identification data for a designated object; the first storage Means for reading from the means; map data based on the coordinate data read from the first storage means; And a means for outputting the customer data read from the second storage means to the first output means and / or the second output means. 3. The data search system according to claim 1, wherein the object is a gas pipe. 4. The first object is a water supply pipe.
The data search system according to item 2 or item 2. 5. The first object is a sewer pipe.
The data search system according to item 2 or item 2. 6. The data search system according to claim 1, wherein the object is a house. 7. The data search system according to claim 1, wherein the object is a telephone line. 8. The data search system according to claim 1, wherein the object is a power line. 9. The data search system according to claim 1, wherein the object is a telephone pole. 10. The first object is a power pole.
The data search system according to item 2 or item 2. 11. The data search system according to claim 1, wherein the customer identification data is a customer number. 12. The data search system according to claim 1, wherein the customer identification data is a meter number. 13. The data search system according to claim 1, wherein the customer identification data is a telephone number.