JP3153295B2 - Data retrieval system - Google Patents

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 in which a map data processing system and a customer data system are connected by a communication line, and data between the two systems is simultaneously output.

[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 a block and a topography to create a database. In such a computer mapping system, information such as the space between the burials is added to a map and output as map data, which is used for management of buried pipes, conduit network analysis, emergency search, and the like.

[0003] On the other hand, government offices, electric power companies, gas companies, telephone companies and the like have computer systems for processing customer information into a database. In such a system, information such as customer information and building information is output as character value information.

However, accidents occur in buried pipes, etc.
For example, when the customer wants to repair immediately, if the map information and the customer information including the character and numerical information are output on separate displays, etc., it is difficult to immediately notify the repair work vehicle of the accident site or the like. Was. As described above, in consideration of security and the like, there is a demand for simultaneously outputting map data and customer information to the same display or the like.

[0005]

As described above, it has recently been desired to simultaneously output map data and customer data.

The present invention has been made in view of such a demand, and an object of the present invention 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]

According to a first aspect of the present invention, there is provided 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 customer data, a second input means, a second output means, and a second storage means for storing at least customer identification data and 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 and the When the identification data of the object is designated using the table indicating the correspondence with the customer identification data and the first input means or the second input means, the designated Means for reading customer identification data corresponding to the identification data of the elephant from the table; means for reading customer data corresponding to the read customer identification data from the second storage means; and identification data of the designated object Means for reading coordinate data corresponding to the data from 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. And a means for outputting to the second output means.

According to a second aspect of the present invention, there is provided a map having first input means, first output means, and first storage means for storing at least identification data of an object and coordinate data of the object. A customer data processing system having a data processing system, second input means, second output means, and second storage means for storing at least customer identification data and customer data; and the map data processing system. A communication line that couples with the customer data processing system, a table provided in one of the map data processing system or the customer data processing system, and a table indicating 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 obtained. Means for reading from the second table, means for reading customer data corresponding to the read customer identification data from the second storage means, and means for reading coordinate data corresponding to the identification data of the specified object from the first storage means. , And map data based on the coordinate data read from the first storage means and customer data read from the second storage means, to the first output means and / or the second output. And a means for outputting to the means.

[0009]

According to the first aspect of the 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 corresponds to the identification data. Customer identification data is read from the table, coordinate data corresponding to the object and customer data corresponding to the customer identification data are read, and map data and customer data based on the read coordinate data are output to output means. .

In the second invention, when the customer identification data is designated by using one of the input means of the map data processing system or the customer data processing system, the identification of the object corresponding to the customer identification data is performed. 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 be described below in detail with reference to the drawings.

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

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 displays map data in the map database 27 stored in the external storage device 13 on, for example, the display 21 in response to a command input from an input device such as the digitizer 17 or the tablet 19, or performs communication. Processing such as performing data communication with the customer data processing system 3 via the line 5 is performed.

The external storage device 13 stores the map database 2
The map database 27 has approximately 2700 scaled 1/500 maps of the national land, and the digitizer 17 writes graphic data such as supply pipes on the basic map of the national land. are doing. Each drawing is given a drawing number. Further, the map database 27 has supply pipe information 29.

FIG. 2 shows the data format of the supply pipe information 29. One block of data includes “supply pipe number”, “pressure”, “caliper”, “attribute data”, and “coordinate data (x ₁ , y ₁ , x ₂ , y ₂ ...)”. The “supply pipe number” which is the identification number of the object is a number attached to the gas supply pipe laid by each customer. "Pressure" indicates whether the gas pressure in the supply pipe is high or low. "Diameter" indicates the diameter of the supply pipe. The attribute data indicates the pipe type, the burial date of the pipe, the material of the pipe, and the like. "Coordinate x _1,
“y ₁ ” indicates the coordinates of the inflection point when, for example, the supply pipe buried in a straight line is bent. The data format of this map data processing system is described in PC Mapping Introduction, K. WESTLAND, published by Nikkan Kogyo Shimbun, page 79.

The search output terminal 15 is, 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 determine a setting area.

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

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

The display 21 displays, for example, one map, a hard copy 23 and an electrostatic plotter 25.
Outputs the image data displayed on the display 21 on paper.

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

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 the customer number or the like is inputted from the keyboard 33, the computer 31 searches the customer database in the external storage device 37 for customer data having this customer number, displays it on the display 35, displays the customer data on the display 35, and connects the communication line 5 to the customer. For example, processing such as data communication between the map data processing system and the like is performed.

The external storage device 37 stores the customer database 3
9 and a table 41 are stored. The customer database 39 includes data on each customer.

FIG. 3 shows a data font of the customer database 39. "Customer number" as customer identification data and "address", "street", "name" and "telephone number" as customer data. , "Meter number", "Meter value two months ago", "Meter value last month", "Meter value this month"
Etc.

The “customer number” is a number given to each customer, and includes “address”, “street”, “name”, “telephone number”,
“Meter number” is the address, address, name, telephone number, and meter number of the customer. A meter value such as “Meter value two months before” indicates the gas meter value of the month.

The table 41 is a table showing a relationship between a customer number and a supply pipe number. FIG. 4 shows an example of the table. Supply pipe B ₁ in FIG customer A _1,
The assignment of B ₂ and B _{3 corresponds} to, for example, a case where three supply pipes are drawn by a customer such as a factory. Further, two customers A ₂ and A ₃ are assigned to the supply pipe B _{4 because} , for example, in an apartment house such as an apartment,
This corresponds to a case where a plurality of customers exist for one supply pipe.

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

First, when the operator of the map data processing system 1 inputs a desired drawing number or address using the tablet 19 (step 501), the computer 11 outputs a map corresponding to the drawing number or address from the map database 27. A search is made and this map is displayed on the display 21 (step 502). When the operator further specifies the 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,
This map is displayed on the entire surface of the display 21 as shown in FIG. 7B. Since there are usually a plurality of supply pipes in this setting area, the user operates the digitizer 17 to position a cursor on a desired supply pipe on the display 21 and designates a supply pipe (step 505).

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

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

Further, predetermined data ("address,""address,""name,""telephonenumber") of the retrieved customer data 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
It 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 printed image data is printed on paper by the hard copy 23 or the electrostatic plotter 25.
FIG. 7 shows an example of a display screen on the display 21 in step 509. As shown in FIG.
The customer data A and the map data B including the gas supply pipe are displayed on one screen. In this case, “Takara Heights” is an apartment house, and a plurality of customers exist 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, for example, if an accident such as a gas leak occurs and the customer makes a telephone call, The position can be easily checked, the position can be accurately notified to the accident processor, and the accident can be dealt with at an early stage.

The present invention can be variously modified.

For example, in the above-described embodiment, the customer data processing system 3 has the table 41, but the 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 the supply pipe number is sent to the customer data processing system 3, 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 the customer number in the table 41, and send the supply pipe number to the map data processing system.

Further, in the above-described embodiment, the display as shown in FIG. 7 is performed on the display 21 of the map data processing system 1 on the input side. When an input is designated from the map data processing system 1, the display is displayed on the display 35 of the customer data processing system 3. Conversely, when an input is designated from the customer data processing system 3, the display of the map data processing system 1 is displayed. 21.), and a display as shown in FIG. 7 can be performed on both displays.

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

In the above-described embodiment, the customer number is taken as the customer identification data. However, the customer identification data may be a meter number or a telephone number.

In the above-described embodiment, the gas supply pipe has been described as an example of an object. You can also.

[0044]

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

[Brief description of the drawings]

FIG. 1 is a block diagram showing a schematic configuration of a data search system according to one 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 the correspondence between customer numbers and supply pipe numbers in a table 41;

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

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

FIG. 7 is a diagram showing customer data and map data displayed on a 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

Continuation of the front page (56) References JP-A-64-10383 (JP, A) JP-A-2-75071 (JP, A) JP-A-3-233681 (JP, A) JP-A-2-36477 (JP) , A) JP-A-2-2463 (JP, A) JP-A-1-169675 (JP, A) "Map information systems that are becoming more popular with the advent of low-priced systems", Business Administration Vol. 30, No. 1, pp. 15-19 (January 1, 1991) Hidemi Hayashi, "Map Information System as a Strategic Information System Tool", Office Automation Vol. 12, No. No. 3 (No. 52), pp. 139-143. 70-76 (October 25, 1991) Hideaki Endo, Takao Yoshikane, "Local Government Map System: ARISTOWN", FUJI TSU Vol. 37, No. 3, pp. 208-215 (May 1986) Ryosuke Hotaka, "Introduction to Databases", pp. 63-78, Ohmsha (December 25, 1978) Shigeyuki Shimauchi, Shinichiro Miyaoka, et al., "Advanced Information Control System in Water and Sewage Waterways", Hitachi Rikkyo Review Vol. 60, no. 6, pp. 569-574 (June 1988) (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 17/30 170 G06F 17/30 110 JICST file (JOIS)

Claims (13)

(57) [Claims] 1. A first input means, a first output means,
A map data processing system having at least identification data of an object and first storage means for storing coordinate data of the object; a second input means; a second output means; Second storage means for storing customer data;
A customer data processing system having: a communication line connecting the map data processing system and the customer data processing system; and a map provided in one of the map data processing system or the customer data processing system, and identification data of the object. When the identification data of the object is specified using the table indicating the correspondence with the customer identification data and the first input means or the second input means, the table corresponds to the identification data of the specified 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; and coordinate data corresponding to the identification data of the designated object.
Means for reading from 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, to the first output means and / or Or a means for outputting to the second output means. 2. A first input means, a first output means,
A map data processing system having at least identification data of an object and first storage means for storing coordinate data of the object; a second input means; a second output means; Second storage means for storing customer data;
A customer data processing system having: a communication line connecting the map data processing system and the customer data processing system; and a map provided in one of the map data processing system or the customer data processing system, and identification data of the object. A table indicating correspondence with the customer identification data; and, when 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; and coordinate data corresponding to the identification data of the designated object. Means for reading from the means; map data based on the coordinate data read from the first storage means; And a means for outputting 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 according to claim 1, wherein the object is a water pipe.
Item 3. The data retrieval system according to item 2 or 2. 5. The first object according to claim 1, wherein the object is a sewer pipe.
Item 3. The data retrieval system according to item 2 or 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 according to claim 1, wherein the object is a power pole.
Item 3. The data retrieval system according to item 2 or 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.