KR100895773B1 - A database for link of Serch data in GIS system, a serch method - Google Patents

Abstract

The present invention is to easily and conveniently search for CAD drawings, related documents, images, video files generated during the design and construction stages of the construction field using a geographic information system (hereinafter referred to as GIS),

Data DB for storing the original CAD drawings, related documents, and image files generated at the construction stage, Shape file DB for storing shape files converted to be recognized by the GIS, and CAD drawings Automatically construct a complete object-based GIS spatial linkage DB that links the data DB to GIS by extracting information from it, and directly links a specific CAD drawing using drawing reference symbols, or extracts a data list for a target object. By displaying and linking selected files among them, the user can examine the interference between design elements by using layers on GIS, and it is convenient to search various files including CAD drawings, and it is possible to change CAD drawings according to new / expansion. Introduce GIS even in the construction phase, as CAD drawings can be used for real-time updating tasks according to structured transformation without the need for structured editing Many construction information generated in the information relates to a file search method using GIS spatial association DB by linking CAD drawings for CAD and GIS.

 CAD, shape file, GIS, spatial search, search, GIS spatial association DB

Description

A method for retrieving a file using GIs spatial linkage based on CAD drawing. {A database for link of Serch data in GIS system, a serch method}

The present invention utilizes the title column information, layer information, and symbol information in the CAD drawings to make the most of the CAD drawings for the construction CALS, which is promoted by the government. Save time and money, quickly find detailed information about facilities even without searching and opening files, and GIS spatial association DB based on CAD drawings that can search and manage files for objects conveniently and efficiently. It relates to a file search method used.

In general, the GIS system construction process converts the created CAD drawing into a shape file that can be displayed in the GIS, and then searches for data using the property information of the shape file. When a user directly enters a search word, a point corresponding to the search word is displayed on the screen, or similar information found is displayed on the screen so that the user can find it.

However, the above search method uses a search word, so that the user can search only if he or she knows the index word or the file name of the object to be searched, and other files related to the search object must be searched separately. Is a problem that can not be used if a person can not even remember the existence of a long time passed.

On the other hand, the conventional GIS system construction process has the following problems.

Referring to FIG. 2, in general, the created CAD drawings are not uniform in the position of characters in the faces, lines, and group objects for each creator, and in the case of a figure having a face, all of the CAD drawings are not intersected or connected. In-place editing and structured editing process of manually inspecting and compensating objects by human eyes, and manually inputting attribute information of each object are performed. At this time, because the structure of each structured worker is different, not only the work contents are non-uniform, but also a large amount of manpower and the resulting costs are excessively doubled in order to modify the CAD drawings created by using a large amount of project costs.

In addition, in order to update the CAD drawings that are changed as new / extended after construction, the same process as described above is required. Therefore, a long time is delayed in the in-situ editing and structured editing process, and excessive maintenance costs are required. .

In addition, since the original CAD drawings are changed during the in-situ editing and structured editing, the contractor has to build and store the original CAD drawings provided by the client and the CAD drawings for maintenance of the GIS system. .

The present invention is to solve the above problems, the first object is to make the best use of the information in the CAD drawings, and to automatically build the shape file by omitting the exact position and structured editing process in the GIS system construction process. .

In addition, the files of the facilities (CAD drawings, related documents, images, and videos) are built in each completely independent DB, and the attribute information that is not inputted by not performing the linkage and the in-place editing and structured editing process of the independent DB is performed. Automatically constructs a full object-based GIS spatial linkage DB using the title column information, layer information, and symbol information data in the CAD drawing process in batch registration, and matches the object information selected in the GIS rather than the link method. The second object of the present invention is to search the related data in the GIS spatial association DB so that related files can be quickly and accurately searched and linked.

In addition, the object recognized as a line because it is not polygonized by omitting the in-place editing process and the structured editing process is divided into the layer information of the object in the GIS spatial association DB, and the virtual area is designated to allow the GIS structured logic. The third purpose is to enable the display of information about

And the fourth purpose is that the CAD drawings, which are changed according to the establishment / expansion after the GIS system is automatically updated in the GIS spatial linkage database and the data DB, can be immediately used in the GIS system.

In addition, CAD drawings for each field such as terrain, civil engineering, architecture, machinery, electrical equipment, communication facilities, and landscaping are expressed in one drawing using layers for specific objects to examine whether there is interference between major facilities or construction objects. The fifth purpose is to enable discrimination.

An S-1 step of automatically extracting and constructing the CAD drawing generated in the construction field from the CAD drawing without inputting a separate GIS property; S-2 which tracks the location of the mouse cursor moving up and down and retrieves specific facility information (business information, construction information, drawing information, management information) of the object where the mouse cursor is located in the GIS spatial association DB and displays it on the screen. Steps; S-3 step of searching for files (CAD drawings, documents, images) for the object in the GIS spatial association DB and displaying the list on the screen when a specific object is selected from the detailed facilities for each part of the building; And outputting the corresponding file to the screen when one file among the searched files is selected.

According to the present invention, by eliminating the in-position editing and structured editing process in the GIS system construction process, not only does not damage the original form of the CAD drawings, but also the effect that the file is not dual management, and shorten the GIS system construction time and manpower It has the effect of minimizing the savings and the construction cost.

In addition, it is possible to efficiently and systematically manage CAD drawings by establishing a schedule of CAD drawings in order to establish a GIS space linkage DB that links various files related to facilities and GIS systems.

In addition, various data files related to GIS spatial linkage DB, shape files, and facilities are automatically extracted and registered in the GIS system for quick and convenient maintenance, cost reduction, and CAD drawings that are changed by new / expansion. It can be updated and the related data can be managed and searched in the facility.

And by searching using the GIS system, even if you do not search and open a specific file separately, you can locate the detailed information by placing the mouse cursor on the target facility as well as intuitively search by the user. It can work.

The present invention relates to a method of collectively extracting and automatically registering data required in the process of constructing a GIS system in a CAD drawing, and a file retrieval method using a GIS spatial association DB. First, automatically extracting necessary data from a CAD drawing 3 to 7 will be described.

The above-mentioned collective registration means that all relevant files (documents, images, and videos) including CAD drawings of each facility provided by the contractor to the client are generated as shape files with only one confirmation button input, and the path information where the original files are stored and Link information is generated from information extracted from a CAD drawing file, and the shape file, link information, and the original file are each a shape file DB. It is to automatically build in GIS spatial link DB and data DB.

Hereinafter, the method will be described in detail step by step.

A shape file conversion step of converting and constructing a CAD drawing including an individual facility or a complex facility to be constructed into a shape file format as shown in FIG. 3; A connection information extraction step of extracting match information between the CAD drawing and a geographic information system (GIS) from the CAD drawing and constructing a database; And a file integration classification step of integrating the CAD drawing, document, video, and image files to construct folders according to the classification system (see FIG. 7).

The shape file conversion step may be performed in the same manner as a shape file conversion process, which is generally performed, but it is preferable not to perform in-situ editing and structured editing.

The step of extracting the linked information is automatically acquired from the title column information of the CAD drawing without inputting GIS attributes separately, automatically from the layer information of the CAD drawing, and automatically obtained from the symbol information of the CAD drawing to obtain the GIS space. Build a linked DB.

Here, the original drawing of CAD drawings can be preserved by not performing the in-situ editing and structured editing process, so it is not necessary to manage the CAD drawings used in the GIS system separately. Will not be entered. To this end, the link information extraction step extracts layer information, symbol information, and title column information from each CAD object for each object to automatically generate and store attribute information, and then link the original file related to the selected facility on the GIS. This can be solved by building a GIS spatial association DB by storing file paths together.

Looking at an embodiment of the data automatically acquired and constructed from the title column information of the CAD drawing with reference to Figure 4, the business information consisting of the business name, orderer, contractor, contract number, contract year, system code, WBS code information and ; Construction information consisting of construction field, construction stage, route direction, railway classification, route name, facility location, tool information; Drawing information consisting of drawing scale, sheet number, drawing name, drawing number, drawing detail information of applicable standard version information; And management information consisting of author, reviewer, and confirmer information.

Looking at the embodiment of the layer information structure system with reference to Figure 5, the construction field code set by the construction CALS / EC standard, the classification code according to the construction industry-specific sectors, the English abbreviation and numeric code for the drawing element, the contractor If necessary, it consists of contractor-defined code that can be arbitrarily extended and the name of the facility for building and utilizing GIS spatial association DB. For example, as shown in the layer insertion window of FIG. 5, the layer name CF-BLDG-STAN can be seen that it is a historical building in a building of a roadbed and a civil engineering facility.

Looking at the embodiment of the symbol information structure system with reference to Figure 6, the construction field code defined in the construction CALS / EC standard, the classification code according to the construction industry-specific sectors, the English abbreviation and numeric code for the drawing element, the contractor If necessary, it consists of the facility number or the unique number of the reference symbol for drawing the GIS spatial linkage DB to be used. For example, as shown in the symbol insertion window of FIG. 6, the symbol name 'ENAT202' may be understood to be an equalization line of the tram line.

The unique reference number of the reference symbol has a shortcut function that can directly link the CAD drawing in which the target symbol is located when the symbol is selected on the GIS system map. The original file can be directly linked by specifying or giving an independent ID to the symbol information.

On the other hand, it is preferable to classify the facility names in the layer and symbol information in detail, and to classify the layer names into one or selectively assign one of them when displayed on the GIS drawing.

Here, referring to FIG. 8, for example, the facility name in the layer and symbol information may be classified into the same name as the apartment complex name when clustered as the apartment complex, as shown in FIG. 8. If the name is' Dong A ',' B ',' D 'C, the facility name is' Doil Royal Mansion A', 'Dool Royal Mansion-B', ' Dooil Royal Mansion-Building C.

Such detailed classified facility names can be assigned as one of the classified layer names when they are displayed on the GIS drawing, or selectively assigned to only one.In this way, the user can select the 'Configuration option' from the 'Menu' of the GIS screen. It is possible to display the cluster name in detail by manipulating or to briefly indicate the cluster name. For example, if you divide 'environment setting option' into 'collective notation of cluster name' and 'collective notation of cluster name', if 'collective name of cluster name' is selected, 'Douille Royal Mansion A' and 'Douille Royal Names of facilities categorized as 'Mountain B Building' and 'Douille Royal Mansion C Building' are all in order, and when 'Family Name of Community Name' is selected, 'A Building', 'B Building' and 'C Building' The name of the facility may be specified as the lowest classification name of the facility to be classified.

As described above, the title column information is used as a detailed description of the object where the cursor is located in the GIS system and displayed on the screen, and the layer information and symbol information are used as a search word and associated information of the object where the cursor is located or selected in the GIS system. At this time, the layer information, symbol information, and title column information are given by a user according to a predetermined rule in a commonly used CAD drawing tool (AutoCAD), so that a separate input process is not required for constructing a GIS spatial association DB. The necessary information can be extracted from the CAD drawing information created in.

The structure system of the title column information, layer, and symbol information described above is an embodiment for explaining that the present invention operates on a completely object basis, and is not intended to present a predetermined system such as the construction CALS / EC standard. Make it clear. In other words, you can use as many rules as you want.

Next, a file search method using the GIS spatial association DB constructed as described above will be described with reference to FIGS. 9 to 17.

9 is a main screen of the GIS system of the present invention, Figure 10 is a flow chart of the operation process using the GIS spatial association DB of the present invention.

As shown in FIG. 10, the present invention consists of four steps. First, an S-1 step of automatically extracting and building a CAD drawing generated in a construction field from a CAD drawing without inputting a separate GIS attribute; S-2 which tracks the location of the mouse cursor moving up and down and retrieves specific facility information (business information, construction information, drawing information, management information) of the object where the mouse cursor is located in the GIS spatial association DB and displays it on the screen. Steps; S-3 step of searching for files (CAD drawings, documents, images) for the object in the GIS spatial association DB and displaying the list on the screen when a specific object is selected from the detailed facilities for each part of the building; And outputting the corresponding file to the screen when one file among the searched files is selected.

The step S-1 further includes equally giving property information of lines constituting one facility by layer information or symbol information, and step S-2 includes coordinates of line groups of the same property forming a line. The method further includes the step of calculating a value, connecting the first start point and the end point, and designating a virtual area to be allowed to the GIS structured logic.

Referring to FIG. 11, the reason for further including the above-described steps is as follows. In the step S-1, in the case of a facility consisting of polygon information in the original CAD drawing, the shape files are not intersected or closed. Since the shape file is recognized as line information instead of face, the line information is classified as the layer information in the GIS spatial linkage DB, and the line group of the same property is connected to designate a virtual area to recognize as unconnected face. This is because it is possible to recognize as a single facility object without damaging the original CAD drawing even if it does not occur, and it is possible to minimize errors that may appear during the automatic conversion.

For example, since the property information of the lines constituting one facility is equally assigned by layer information or symbol information, the coordinates of the lines having the same property are calculated to designate one virtual area, and the cursor is located in the corresponding area. When is located, the detailed information (title column information) about the facility can be displayed on the screen, and when selecting the corresponding area, the list of file information about the facility can be displayed on the screen.

A detailed method of step S-2 for this purpose will be described in detail with reference to FIG. 12.

Step S-2 includes tracking the position of the mouse cursor and checking whether the object where the mouse cursor is located is a symbol object; If the target object is a symbol, acquiring a facility name from a GIS spatial association DB in a structure system of corresponding symbol information; If the specific object is not a symbol object, acquiring a facility name from a GIS spatial association DB in a structure system of inquiry target layer information; Querying the facility name in a GIS spatial association DB to obtain business information, construction information, and drawing information (information of headline information) of a target object; And displaying the obtained information at a cursor position on the screen.

Step S-3 includes tracking the position of the mouse cursor as shown in FIG. 13 and checking whether the object where the mouse cursor is located is a symbol object; Checking whether the target object is a drawing reference symbol when the target object is a symbol; In the case of drawing reference symbols, calling and calling the corresponding CAD drawing numbers from the GIS spatial association DB; Displaying a CAD drawing to be queried on a screen; Acquiring a facility name in a structure system of symbol information from a GIS spatial association DB if the target object is not a drawing reference symbol; If the specific object is not a symbol object, acquiring a facility name from a GIS spatial association DB in a structure system of inquiry target layer information; And querying the facility name in the GIS spatial association DB to display a list of files (CAD drawings, documents, images, and videos) for the target object on the screen or to display a three-dimensional figure of the target object on the screen.

Here, the screen displaying the CAD drawing to be queried by selecting the drawing reference symbol is shown in FIG. 14, and the screen displaying the list of files related to the target object by selecting a general symbol or a layer other than the drawing reference symbol is shown in FIG. 15A. The screen representing the three-dimensional shape of the target object is shown in FIG. 15B.

In step S-4, selecting one of the file list of FIG. 15A and displaying the corresponding file on a separate screen window; Selecting detail facilities for each part in the three-dimensional diagram of FIG. 15B; Querying the data DB for the detailed facilities for each part in a data DB; Displaying the inquiry result list on a screen; Displaying the selected file from the query result list on a separate screen window (see Fig. 16).

Here, among the files finally selected and displayed in the step S-4, the CAD drawing, in particular, searches for another file by repeating steps S-2 to S-4 in the displayed screen window. For example, when the mouse cursor is placed on a specific facility in the CAD drawing window displaying the inquired drawing as shown in FIG. 17, detailed information about the target facility is displayed. When the target building is selected with the mouse, all related file information is searched. The inquiry list is displayed, and if one of the displayed inquiry lists is selected, the corresponding CAD drawings are displayed in a new window to enable detailed inquiry about the facilities.

As described above, when the user places the mouse cursor on a specific facility on the GIS map, the detailed information on the target facility can be checked immediately, and if the user selects the detailed facility for each part of the target building with the mouse, all related file information can be retrieved. In addition, if you select one of them, you can open the file immediately, and if you select a drawing reference symbol with a shortcut function, the target CAD drawing can be displayed directly on the screen.

On the other hand, CAD drawings that are changed according to the establishment / expansion after the GIS system is built are automatically updated in the GIS spatial linkage DB and data data by selecting only the changed parts separately.

In addition, as an embodiment to which the present invention is applied, CAD drawings for each field such as a feature, a civil engineering, a building, a mechanical equipment, an electric equipment, a communication equipment, and a landscape for a specific object may be displayed on a single screen as shown in FIG. 18. .

As a method for this purpose, the specific classification name of the layer information of each CAD drawing of the target facility is given the same, and each layer of CAD drawings is registered in the same manner as described above, and the layer information defined above is displayed on the GIS screen. This is possible by outputting a layer matching the classification name in the same coordinate.

The user can then review and determine if there is interference between major facilities or construction objects.

As described above and described with reference to a preferred embodiment for illustrating the technical idea of the present invention, the present invention is not limited to the configuration and operation as shown and described as described above, it is a deviation from the scope of the technical idea It will be understood by those skilled in the art that many modifications and variations can be made to the invention without departing from the scope of the invention. Accordingly, all such suitable changes and modifications and equivalents should be considered to be within the scope of the present invention.

1 is an example of a search method using a conventional GIS system.

2 is a flow chart showing a conventional GIS system construction process.

Figure 3 is a flow chart of the database construction by batch registration of the present invention.

4 is a diagram showing an embodiment of title column information of the present invention;

5 illustrates an embodiment of a layer information structure system of the present invention.

Figure 6 illustrates an embodiment of a symbol information structure system of the present invention.

7 is a diagram showing an embodiment of file classification in the file integration classification step of the present invention.

8 is a facility name display screen using the layer and symbol information of the present invention

9 is a main screen of a GIS system according to the present invention;

10 is a flow chart of the operation process using the GIS spatial association DB of the present invention.

11 is a schematic diagram of a method for designating a virtual region of an unclosed object of the present invention.

12 is a flow chart of detailed object-specific inquiry using the GIS spatial association DB of the present invention.

13 is a flowchart of file search by object using the GIS spatial association DB of the present invention.

14 is a file search screen using the drawing reference symbol of the present invention.

15A is a screen showing a CAD drawing selected by expressing a file list related to a facility using symbols and layers of the present invention.

15B is a screen showing a CAD drawing selected by expressing a list of files related to a facility using symbols and layers of the present invention in a three-dimensional figure.

16 is a file search query simplified view using the three-dimensional diagram of the present invention.

17 is a screen showing an embodiment for subsequently searching the CAD drawings of the present invention.

18 is a screen output of a plurality of overlapping outputs for interference review between design elements of a facility using the GIS spatial linkage DB of the present invention.

Claims (7)

In the file retrieval method using GIS spatial association DB by CAD drawing in GIS, An S-1 step of automatically extracting and constructing the CAD drawing generated in the construction field from the CAD drawing without inputting a separate GIS property; It tracks the position of the mouse cursor moving up and down on the Geographic Information System (GIS), and retrieves the specific facility information (business information, construction information, drawing information, management information) of the object where the mouse cursor is located from the GIS spatial association DB. S-2 step to display on; S-3 step of searching for files (CAD drawings, documents, images) for the corresponding object in the GIS spatial association DB when a specific object is selected from the detailed facilities for each part of the building and displaying the list on the screen; And outputting a corresponding file to a screen when one file among the searched files is selected, using the GIS spatial association DB according to a CAD drawing. The method of claim 1, The step S-1 further includes equally giving property information of lines constituting one facility by layer information or symbol information, and step S-2 includes coordinates of line groups of the same property forming a line. A method of searching for a file using a GIS spatial association DB according to a CAD drawing, further comprising the step of calculating a value and connecting a first start point and an end point to designate a virtual area to be allowed for the GIS structured logic. The method of claim 1 Step S-2 includes tracking the position of the mouse cursor and checking whether the object where the mouse cursor is located is a symbol object; If the target object is a symbol, acquiring a facility name from a GIS spatial association DB in a structure system of corresponding symbol information; If the specific object is not a symbol object, acquiring a facility name from a GIS spatial association DB in a structure system of inquiry target layer information; Querying the facility name in a GIS spatial association DB to obtain business information, construction information, and drawing information (information of headline information) of a target object; And displaying the acquired information at a cursor position on a screen, using a GIS spatial association DB according to a CAD drawing. The method of claim 1, Step S-3 tracks the position of the mouse cursor and checks whether the object where the mouse cursor is located is a symbol object; Checking whether the target object is a drawing reference symbol when the target object is a symbol; In the case of drawing reference symbols, calling and calling the corresponding CAD drawing numbers from the GIS spatial association DB; Displaying a CAD drawing to be queried on a screen; Acquiring a facility name in a structure system of symbol information from a GIS spatial association DB if the target object is not a drawing reference symbol; If the specific object is not a symbol object, acquiring a facility name from a structure system of inquiry target layer information from a GIS space association DB; And displaying the list of files (CAD drawings, documents, images, and videos) for the target object on the screen by displaying the facility name in the GIS spatial association DB or displaying a three-dimensional figure of the target object on the screen. File retrieval method using GIS spatial association DB by CAD drawing. The method according to claim 1 or 4, The step S-4 includes selecting one of the file list of the step S-3 and displaying the corresponding file on a separate screen window; Selecting detailed facilities for each part in the solid figure; Querying the data DB for the detailed facilities for each part in a data DB; Displaying the inquiry result list on a screen; File searching method using a GIS spatial linkage DB according to the CAD drawing, characterized in that the step of expressing the selected file from the list of the query results in a separate screen window. The method of claim 5, CAD drawing of the files finally selected and expressed in the step S-4 is characterized in that the detailed file can be searched in succession by repeating the steps S-2 to S-4 in the displayed screen window File search method using GIS spatial association DB by drawing. The method of claim 1, Step S-4 further includes the step of displaying the CAD drawings for each field, such as the feature, civil engineering, construction, mechanical equipment, electrical equipment, communication equipment, landscape for a specific object on a single screen File retrieval method using GIS spatial association DB.

Images