KR20220115009A - The viewer system of water supply hydrant attributes and pictures among the underground facility drawing based on AutoCAD - Google Patents

Abstract

The present invention relates to a viewer system of water supply hydrant photo and property information, which is developed to check all the contents of photo and property information in one window within AutoCAD without running other applications, in order to check distant and near-view photos of a location of the water supply hydrant in the water supply pipe network drawing created using AutoCAD among underground facilities, and various property information such as the customer number, address, user name, and investigator of the hydrant.

Description

{The viewer system of water supply hydrant attributes and pictures among the underground facility drawing based on AutoCAD}

The present invention is a single window with various attribute information such as distance and near-view photos of the location of the water supply faucet in the water supply pipe network drawing among the underground facility drawings created using AutoCAD It is about the viewer system developed so that it can be checked in .

In the water supply pipe network drawing, the investigator takes a picture of the location and internal situation of the hydrant at the site, and checks various information about the diameter of the pipe, the guidelines of the hydrant, and the condition of the protection barrel. Information is organized in Excel or other text files. Since it is not possible to immediately check the photo information or property information about the water hydrant that exists as an external file within the AutoCAD drawing, to check the water hydrant information, you need to run other applications that can view the photo file and property information, so the efficiency of work is reduced. is lowered Accordingly, the present invention is to provide an integrated viewer system that can check both the photo and attribute information of the water supply faucet, which can increase the efficiency of work without running other applications within the AutoCAD drawing.

In the water pipe network diagram, the water supply hydrant is the final facility connected to the water supply pipe to supply water to each individual customer. A report is prepared in which various information about the diameter of the existing water supply pipe and the condition of the protection tube, damage, and abnormality are entered. The contents of this protocol are generally organized in Excel data, but when organizing in Excel, the format of the protocol is edited based on the output of one A4 sheet, so it is difficult to insert multiple photos into the Excel protocol. If multiple images are to be entered in the Excel protocol, the size of the images to be inserted must be reduced to a small size. And since you cannot immediately see the photo data connected to the water supply in the AutoCAD drawing, run a separate image viewer program to check it, and check the property information in Excel. It is time consuming and inefficient. Accordingly, in the present invention, it is an object of the present invention to increase the efficiency of the water pipe network drawing work by providing an integrated attribute information viewer system that can simultaneously view the contents of the protocol and several photos in the AutoCAD drawing.

In order to check the external photo file and Excel attribute information within the AutoCAD drawing, the Excel protocol, the photo file, and the water supply in the drawing must have a key value that connects them as one. If the customer number of the water supply hydrant is selected in the water supply network drawing, the work is performed in the order of checking the photos and attribute information of the water supply hydrant, so this customer number, which is the standard in the drawing, is the primary key value It should be linked, and the photo file should be linked with the key value of the survey number checked in the Excel report. This is to build a system that can view photos and attribute information about the water hydrant in one integrated viewer window for materials with key values connected in this way.

If you work with a water pipe network drawing with a viewer system that allows you to check the photo and property information of the water faucet at once within the AutoCAD drawing, you do not need to run an external application to view the photo file or check the property report in Excel. The efficiency of the drawing work is greatly improved because the economic feasibility is improved and the worker can maintain concentration within the water pipe network drawing.

1 is a work flow diagram of the water supply property viewer window system
Figure 2 is an Excel report data before water supply
Figure 3 is the field photo file folder of the water supply hydrant
Figure 4 is an AutoCAD screen running the water supply property viewer window
5 is an example screen for viewing a distant view before a water supply
6 is an example screen for viewing a close-up photo before water supply
7 is an example screen for viewing other pictures before water supply

In order to construct a viewer system that can check the picture of the water supply hydrant and the attribute information of Excel at once in the water supply network drawing, the data structure system in which the attribute data and the photo files are connected with each other as the primary connection key value is the number of the water supply cistern in the water supply network drawing. should have When the customer number (S01 in FIG. 4) of the water supply hydrant is selected in the water supply network drawing, the same key value (S02 in FIG. 2) item is found on the Excel report for the corresponding key value.

The contents of the Excel report found with this primary key value (S04 in Fig. 2) have various information such as the number of the water supply hydrant, the survey number, the diameter of the water hydrant, the state of the protection box, etc. Among them, the contents to be displayed on the viewer system are extracted and linked photos In order to retrieve the file, the search number (S03 in FIG. 2) is set as the secondary connection key value. Before one water supply, the photo file is named in such a way that a serial number is added after the survey number because there are several long-view (Fig. 5), near-view (Fig. 6), and other related photos (Fig. 7). ( S05 in Fig. 3)

In the water supply network drawing, the contents of the Excel report are found using the number of the water supply hydrant selected by the worker as the primary key value, and the photo files for the water hydrant are found using the survey number on the protocol as the secondary key value. The document content and photo file thus found are output to the viewer system (S08 in FIG. 4) at the top (S06 in FIG. 4), and several photos are displayed in the lower part in tab format (S07 in FIG. 4).

If such a water hydrant property viewer system is used, the operator can check the properties of the excel file and photos in one viewer window by selecting the number of the water hydrant in the AutoCAD drawing without running another application program. You can check all the photos of the water hydrant.

S01: Primary key value of customer number before water supply in water pipe network drawing
S02: Customer number before water supply in the Excel report
S03: Second key value of survey number for customer number before water supply in Excel report
S04: Attribute data for water hydrant in Excel report
S05: Field photo files for the water supply hydrant survey number
S06: Excel report content display unit at the top of the property viewer window
S07: Photo tab at the bottom of the property viewer window
S08: Property viewer window of water supply faucet

Claims (1)

In order to check the attribute information and photo files of the water supply pipe network drawing based on AutoCAD among underground facilities at once, in the drawing, the customer number of the water supply hydrant is linked to the protocol of Excel as the primary key value, and the investigation confirmed in the Excel report A water supply faucet property and photo viewer system that allows you to find a photo file with a number as a secondary key value and check the photo and property report in one window.

Images