WO2008105611A1

WO2008105611A1 - Database auto-building method for link of search data in gis system using cad drawings

Info

Publication number: WO2008105611A1
Application number: PCT/KR2008/001093
Authority: WO
Inventors: Dong-Hee Park; Jae-Woo Moon
Original assignee: KOREA RAIL NETWORK AUTHORITY
Current assignee: KOREA RAIL NETWORK AUTHORITY
Priority date: 2007-02-28
Filing date: 2008-02-26
Publication date: 2008-09-04
Anticipated expiration: 2009-08-28
Also published as: KR100836235B1

Abstract

The present invention relates to a method of automatically building a GIS space associated database using a CAD drawing in order to associate CAD with a GIS by introducing the GIS in a construction process and using much construction information produced in the construction process, by automatically building a material database for storing original copies of CAD drawings, related documents, and image files that are produced in a construction process, a shape file database for storing shape files converted so that the CAD drawing can be recognized in the GIS, and a GIS space associated database completely on the basis of an object extracting information from the CAD drawing and associating the material database with the GIS.

Description

[DESCRIPTION] [Invention Title]

DATABASE AUTO-BUILDING METHOD FOR LINK OF SEARCH DATA IN GIS SYSTEM USING CAD DRAWINGS [Technical Field]

<i> The present invention relates to a method of automatically building a GIS space associated database using a CAD drawing that can reduce time and cost for building and maintenance of a GIS system by utilizing title information, layer information, and symbol information in a CAD drawing and then automatically building the GIS space associated database to reuse the CAD drawing aiming at the construction CALS promoted by the Korean government, that can allow prompt checking of detailed information regarding facilities without separately searching for and opening a file, and that can allow convenient and efficient search for and management of a file regarding an object. [Background Art]

<2> In a general GIS system building process, after a written CAD drawing is converted into a shape file that can be displayed in a GIS, a material is searched for by using attribute information of the shape file. Generally, as illustrated in Fig. 1, the search method is performed by displaying a point coinciding with a search word on a screen when a user directly inputs the search word or displaying searched similar information on a screen.

<3> However, since the search method uses a search word, it is necessary for a user to know an index word or a file name of an object that is to be searched for. Further, since it is necessary to separately search for other materials associated with a searched object, a file that is not frequently searched for is not used or is neglected if a user forgets its existence with time.

<4> Meanwhile, a conventional GIS system building process has the following problems.

<5> Referring to Fig. 2, a general CAD drawing is accompanied by a field check data editing and structural ized editing process of checking objects of all CAD drawings by naked eyes and correcting and supplementing the objects one by one due to the fact that letter locations are not constant in polygon, line, and group objects and lines do not cross each other or are not connected to each other in the case of a figure having a polygon and a process of manually inputting attribute information of each object. Then, since styles of individual structural izing operators are different from each other, the structurization is inefficient. Furthermore, much manpower and high cost are excessively necessary to correct the CAD drawing that was already made at high business cost again.

<6> In addition, since it is necessary to perform the above-mentioned processes in order to renew the CAD drawing changed according to establishment and extension of a built GIS system, there is a long delay in a field check data editing and structural ized editing process and maintenance cost is excessively consumed.

<7> Moreover, since an original copy of the CAD drawing is changed in the field check data editing and structural ized editing process, it is necessary for a contractor to separately build a CAD drawing for maintenance of an original copy of a CAD drawing and a GIS system that are provided by an orderer . [Disclosure] [Technical Problem]

<8> Therefore, the present invention has been made in view of the above problems, and it is the first object of the present invention to maximally utilize information contained in a CAD drawing and automatically build a shape file by eliminating a field check data editing and structural ized editing process in building a GIS system.

<9> It is the second object of the present invention to build a completely independent database using files (a CAD drawing, a related document, an image, and a moving image) regarding a facility, automatically build a GIS space associated database completely on the basis of an object using title information, layer information, and symbol information in a CAD drawing in a process of registering drawings collectively using attribute information that has not been input by not performing a process of associating the independent database and a field check data editing and structural ized editing process, and allow related files to be searched for and be associated with each other by making a reference to data coincided with object information selected in the GIS in the GIS space associated database, not in a link manner.

<io> It is the third object of the present invention to display information regarding an object by classifying an object that has not been polygonized to be recognized as a line as layer information of the object in the GIS space associated database and designating an imaginary region so that the imaginary region can be allowed in the GIS structural ization logic, by eliminating the field check data editing and structural ized editing process.

<ii> It is the fourth object of the present invention to allow the CAD drawing changed according to establishment and extension of a GIS system after the GIS system is built to be immediately used in the GIS system by automatically renewing the CAD drawing in a GIS space associated database and a material database.

<i2> It is the fifth object of the present invention to allow review and determination on interference between main facilities or constructed objects by displaying CAD drawings for fields such as topography of an object, civil engineering, construction, mechanical equipment, electrical equipment, communication facility, and landscape architecture in one drawing by using a drawing layer regarding a predetermined object. [Technical Solution]

<i3> In accordance with an aspect of the present invention, the above and other objects can be accomplished by the provision of a method of automatically building a GIS space associated database using a CAD drawing comprising: a shape file converting step of converting a CAD drawing including an individual facility or a complex facility of a constructed object into a shape file format of a GIS to build a shape file and a file integrating and classifying step of integrating the CAD drawing, a document, a moving image, and an image file and classifying and building folders according to a classification system, the method further comprising: an associated information extracting step of extracting match information between the CAD drawing and the GIS from the CAD drawing to build a database. [Advantageous Effects]

<i4> According to the present invention, the original shape of a CAD drawing cannot be damaged and a file cannot be dually managed by eliminating a field check data editing and structural ized editing process in building a GIS system, and a GIS system building period can be shortened and manpower and building cost can be minimized.

<i5> Further, a CAD drawing can be efficiently and systematically managed by determining a rule in the CAD drawing in order to build a GIS space associated database associating various files regarding a facility with a GIS system.

<16> Furthermore, a GIS system can be conveniently maintained at a low cost and a CAD drawing changed by its establishment and extension can be promptly renewed in the GIS system by automatically extracting, changing, and registering a GIS space associated database, a shape file, and various material files regarding facilities collectively, and the related materials regarding facilities can be managed and searched for by integrating them.

<i7> Furthermore, detailed information can be checked by locating a mouse cursor on an object facility without separately searching for and reading a predetermined file, by using a GIS system, and necessary materials can be searched for even when a user does not know a search word by allowing the user to intuitively perform a search. [Description of Drawings]

<18> The above and other objects, features and other advantages of the present invention will be more clearly understood from the following detailed description taken in conjunction with the accompanying drawings, in which:

<i9> Fig. 1 is a view illustrating an example of a search method using a conventional GIS system; <20> Fig. 2 is a flowchart illustrating a conventional GIS system building process; <2i> Fig. 3 is a flowchart illustrating a database building process by registration collectively according to the present invention; <22> Fig. 4 is a view illustrating an embodiment of title information according to the present invention; <23> Fig. 5 is a view illustrating an embodiment of a layer information structure system according to the present invention; <24> Fig. 6 is a view illustrating an embodiment of a symbol information structure system according to the present invention; <25> Fig. 7 is a view illustrating an embodiment of classification of files in a file integrating and classifying step according to the present invention; <26> Fig. 8 is a view illustrating a screen displaying facility names using layer and symbol information according to the present invention; <27> Fig. 9 is a view illustrating a main screen of a GIS system according to the present invention; <28> Fig. 10 is a flowchart illustrating a management process using a GIS space associated database according to the present invention; <29> Fig. 11 is a schematic view illustrating a method of designating an imaginary region of an object that has not been merged according to the present invention; <30> Fig. 12 is a flowchart illustrating a process of making a reference to detailed information for objects using a GIS space associated database according to the present invention! <3i> Fig. 13 is a flowchart illustrating a process of searching for files for objects using a GIS space associated database according to the present invention; <32> Fig. 14 is a file searching screen using a drawing reference symbol according to the present invention; <33> Fig. 15 is a view illustrating a screen displaying a CAD drawing selected by displaying a file list related to facilities using symbols and layers according to the present invention;

<34> Fig. 16 is a view illustrating a screen displaying a CAD drawing selected by displaying a file list related to facilities as a solid figure using symbols and layers according to the present invention;

<35> Fig. 17 is a schematic view illustrating a file searching and referring process using a solid figure according to the present invention;

<36> Fig. 18 is a view illustrating a screen displaying an embodiment of searching for CAD drawings one by one according to the present invention; and

<37> Fig. 19 is a view illustrating a screen overlapping and outputting several drawings to review interference between design elements of a facility using a GIS space associated database according to the present invention. [Best Mode]

<38> The present invention largely relates to a method of automatically extracting data necessary for a process of building a GIS system from CAD drawings and registering the extracted data collectively and a method of searching for a file using a GIS space associated database. First, the method of automatically extracting necessary data from CAD drawings and registering the extracted data collectively will be described in detail with reference to FIGS.3 to 7.

<39> Registering data collectively refers to producing a shape file by only one input of a check button from all related files (documents, images, and moving images) including CAD drawings of facilities provided by a contractor to an orderer, producing associated information from path information in which an original file is stored and information extracted from a CAD drawing file, and automatically building the shape file, the associated information, and the original file in a shape file database, a GIS space associated database, and a material database.

<40> Hereinafter, the method of registering data collectively will be described in detail step by step. <4i> As in Fig. 3, the method of registering data collectively includes: a shape file converting step of converting a CAD drawing including an individual facility or a complex facility of a constructed object into a shape file format to build a shape file; an associated information extracting step of extracting match information between the CAD drawing and a GIS from the CAD drawings to build a database; and a file integrating and classifying step of integrating the CAD drawing, a document, a moving image, and an image files and classifying and building folders according to a classification system.

<42> The shape file converting step is processed in the same way as a conventional shape file converting process, and preferably does not perform a field check data editing and structural ized editing process.

<43> In the associated information extracting step, a GIS space associated data base is built by not inputting an attribute of the GIS separately but automatically acquiring an attribute of the GIS from title information of the CAD drawing, by automatically acquiring the attribute of the GIS from layer information of the CAD drawing, and by automatically acquiring the attribute of the GIS from symbol information of the CAD drawing.

<44> Here, since the original shape of the CAD drawing can be preserved by not performing a field check data editing and structural ized editing process, the CAD drawing used in the GIS system may be managed separately. However, attribute information input for each object in the field check data editing and structural ized editing process cannot be input. This problem can be solved by extracting layer information, symbol information, and title information from the CAD drawing for each object and then automatically producing and storing attribute information and by storing an original file path together so that the original file path can be associated with an original file related to a facility selected from the GIS, in order to build a GIS space associated database.

<45> Referring to Fig. 4, the data built by automatically acquiring them from the title information of the CAD drawing includes: business information regarding a business name, an orderer, a contractor, a contract number, a contract year, a system code, and a WBS code! construction information regarding a construction field, a construction step, a route direction, a railway classification, a route name, a facility location, and a construction section; drawing information regarding details of a drawing scale, an edition number, a drawing name, a drawing number, and an applied standard version; and management information regarding a writer, a reviewer, and a checker.

<46> Referring to Fig. 5, the layer information structure system includes a construction field code determined in the construction CALS/EC standard, a middle-sized classification code according a construction type for each construction field, and an English abbreviated word and a number code regarding drawing elements, a contractor defining code arbitrarily expanded and used when a contactor wants, and a facility name for building a GIS space associated database. For example, like a layer insertion window of Fig. 5, it can be seen that the layer name 'CF-BLDG-STAN' is a historical building in buildings of road and engineering facilities.

<47> Referring to Fig. 6, the symbol information structure system includes a construction field code determined in the construction CALS/EC standard, a middle-sized classification code according a construction type for each construction field, and an English abbreviated word and a number code regarding drawing elements, an identification number of a facility or a drawing reference symbol for building a GIS space associated database arbitrarily expanded and used when a contractor wants. For example, like a symbol insertion window of Fig. 6, it can be seen that the symbol name 'ENAT202' is an equal voltage line of a street car.

<48> The identification number of the drawing reference symbol has a shortcut function capable of immediately associating a symbol with the CAD drawing where the symbol is located when the symbol is selected from a GIS system map, and can designate a path name of an original file without searching for another related file and can immediately associate the original file with symbol information by endowing the symbol information with an independent ID.

<49> Meanwhile, it is preferable that the facility names in the layer and symbol information are classified in detail and the layer names classified when they are displayed on the GIS drawing merge into one or are selectively endowed with one title.

<50> Referring to Fig. 8, for example, the facility names in the layer and symbol information may be classified as names of apartment complexes and Dongs when the facilities form a group such as apartment complexes. As illustrated in Fig. 8, when the name of the apartment complex is 'Doo-Il Royal Mansion' and the names of Dongs are 'A-Dong' , 'B-Dong' , and 'C-Dong' , the facility names in the layer and symbol information are 'Doo-Il Royal Mansion-A-Dong' , 'Doo-Il Royal Mansion-B-Dong' , and 'Doo-Il Royal Mansion-C- Dong'.

<5i> The facility names classified in detail can be endowed by merging the layer names classified when they are displayed on the GIS drawing into one, or selectively. This is achieved by marking in detail the names of groups by manipulating 'Environment setting option' in 'Menu' or simply marking the names of groups. For example, when 'Environment setting option' is classified into 'Detailed marking of names of groups'and 'Brief marking of names of groups', if 'Detailed marking of names of groups' is selected, the facility names classified into 'Doo-Il Royal Mansion-A-Dong' , 'Doo-Il Royal Mansion-B- Dong' , and 'Doo-Il Royal Mansion-C-Dong' are sequentially marked, and if 'Brief marking of names of groups' is selected, the facility names are marked as the lowest classification names of the facility names such that they are classified into 'A-Dong' , 'B-Dong' , and 'C-Dong' .

<52> As mentioned above, the title information is used as a detailed description of an object where a cursor is located in the GIS system to be displayed on a screen and the layer information and the symbol information are used as a search word or associated information of an object where a cursor is located or selected in the GIS system, in which case since the layer information, the symbol information, and the title information are endowed by a user according to a regular rule in a conventionally used CAD drawing tool (AutoCAD), necessary information can be extracted from the initially written CAD drawing information without a separate input process of building a GIS space associated database.

<53> The above-mentioned structure system of the title information and the layer and symbol information is an embodiment for explaining that the present invention is managed completely on the base of an object, in which case it is clear that a determined system such as the construction CALS/EC standard is to be suggested. That is, rules determined by a user may be freely used if necessary.

<54> Hereinafter, a file searching method using the GIS space associated database built as mentioned above will be described in detail with reference to Figs. 9 to 17.

<55> Fig. 9 is a main screen of the GIS system of the present invention and Fig. 10 is a flowchart of a management process using the GIS space associated database of the present invention.

<56> As illustrated in Fig. 10, the present invention is largely classified into four steps, and includes the steps of: automatically extracting and building a CAD drawing produced in the construction field from CAD drawings without inputting a separate attribute of a GIS (S-I); tracing the location of a mouse cursor that is enlarged, reduced, or moved and searching for detailed facility information (business information, construction information, drawing information, and management information) of an object where the mouse cursor is located to display the searched facility information (S-2); searching for files (CAD drawings, documents, images) regarding an object in the GIS space associated database if the object is selected from detailed facilities of a building, to display the items on a screen (S~3); outputting a file on the screen when the file is selected from the searched files (S-4).

<57> The step S-I further includes the step of: endowing attribute information regarding the lines constituting one facility using the layer information or the symbol information in the same way, and the step S-2 further includes the step of designating an imaginary region so that the imaginary region can be allowed in a GIS structural ization logic after connecting a start point and an end point by calculating coordinates in a group of lines of the same attribute.

<58> Referring to Fig. 11, the steps are further included because the step S-I allows an original copy of a CAD drawing to be recognized as one facility object without damaging the original copy of the CAD drawing even when a section that is not connected, so as not to be recognized as a polygon and minimizes errors that can be caused during automated conversion, by classifying line information as layer information in the GIS space associated database and connecting line groups of the same attribute in order to designate an imaginary region since lines forming a polygon are converted into a shape file with the lines not crossing each other or merging into one in the original copy of the CAD drawing in the case of a facility including polygon information so that the polygon information can be recognized as line information in the shape file.

<59> For example, the attribute information regarding the lines constituting one facility calculates the coordinates of the lines of the same attribute in order to designate one imaginary region since it is endowed by the layer information and the symbol information in the same way, and can display detailed information (title information) regarding the facility when a cursor is located in the corresponding region and can display items obtained by searching for the file information regarding the facility on a screen when the corresponding region is selected.

<60> Hereinafter, the step S-2 will be described in detail with reference to Fig. 12 step by step.

<6i> The step S-2 includes the steps of: tracing the location of a mouse cursor and checking whether an object where the mouse cursor is located is a symbol object; acquiring a facility name in a structure system of the corresponding symbol information from the GIS space associated database when the object is a symbol; acquiring a facility name in a structure system of referred layer information from the GIS space associated database when the object is not a symbol; acquiring business information, construction information, and drawing information (information built as title information) of the object by making a reference to the facility name in the GIS space associated database; and displaying the acquired information at a location of a cursor in the screen.

<62> The step S^~3 includes the steps of: tracing the location of a mouse cursor and checking whether an object where the mouse cursor is located is a symbol; checking whether the symbol is a drawing reference symbol when the object is a symbol; making a reference to a corresponding CAD drawing number from the GIS space associated database to call the CAD drawing number when the symbol is a drawing reference symbol; displaying a referred CAD drawing on a screen; acquiring a facility name in a structure system of the corresponding symbol information from the GIS space associated database when the object is not a drawing reference symbol; acquiring a facility name in a structure system of the referred layer information from the GIS space associated database when the object is not a symbol; and displaying items of files (CAD drawings, documents, images, and moving images) regarding the object by making a reference to the facility name in the GIS space associated database, or displaying a solid figure of the object on the screen.

<63> Here, a screen displaying a referred CAD drawing by selecting the drawing reference symbol is as illustrated in Fig. 14, and a screen displaying items of files related to an object by selecting a general symbol or a layer instead of a drawing reference symbol is as illustrated in Fig. 15, and a screen displaying a solid figure of an object is as illustrated in Fig. 16.

<64> The step S-4 includes the steps of: displaying a file on a separate screen window by selecting the file in the file list in Fig. 15; selecting a detailed facility in the solid figure of Fig. 16; making a reference to a material regarding the detailed facility in a material database! displaying a referred result list on a screen; and displaying a file selected from the referred result list on a separate screen window (refer to Fig. 17).

<65> The CAD drawing in the file finally selected and displayed in the step S-4 allows another file to be searched for by repeating the steps S-2 to S-4 in the displayed screen window. For example, if a mouse cursor is located at a predetermined facility in the CAD drawing window displaying the drawing referred as in Fig. 18, detailed information regarding an object facility is displayed, and if an object building is selected by a mouse, all related file information is searched for and is displayed on a referred list, and if one is selected from the displayed referred list, detailed reference regarding a facility is allowed by displaying the corresponding CAD drawing on a new window.

<66> As mentioned above, if a user locates a mouse cursor on a predetermined facility in a GIS map, detailed information regarding the facility can be immediately checked, and if a detailed facility of an object building is selected by a mouse, all related file information can be searched for, and if one of them is selected, the corresponding file can be immediately opened and read, and if a drawing reference symbol having a shortcut function is selected, an object CAD drawing can be immediately displayed.

<67> On the other hand, the CAD drawing changed according to establishment and extension of a built GIS system can be automatically renewed in a GIS space associated database and material data by separately selecting only the changed section.

<68> Further, as an embodiment applying the present invention, as illustrated in Fig. 19, CAD drawings for fields such as topography of an object, civil engineering, construction, mechanical equipment, electrical equipment, communication facility, and landscape architecture can be displayed on one screen.

<69> One method for this purpose can be achieved by outputting a layer, whose classified names of the defined layer information are identical, at a same coordinate, in displaying a GIS screen after CAD drawings are registered collectively in the same way by identically endowing a classified name of the layer information of the CAD drawings regarding an object facility.

<70> Then, a user can review and determine interference between main facilities or constructed objects.

<7i> Although the preferred embodiments of the present invention have been disclosed for illustrative purposes, those skilled in the art will appreciate that various modifications, additions and substitutions are possible, without departing from the scope and spirit of the invention as disclosed in the accompanying claims.

Claims

[CLAIMS] [Claim 1]

A method of automatically building a GIS space associated database using a CAD drawing comprising: a shape file converting step of converting a CAD drawing including an individual facility or a complex facility of a constructed object into a shape file format of a GIS to build a shape file and a file integrating and classifying step of integrating the CAD drawing, a document, a moving image, and an image file and classifying and building folders according to a classification system, the method further comprising: an associated information extracting step of extracting match information between the CAD drawing and the GIS from the CAD drawing to build a database.

[Claim 2]

The method as set forth in claim 1, wherein in the shape file converting step, a field check data editing and structural ized editing process is not performed regardless of mergence, cross, and topology errors of a polygon in the CAD drawing in order to preserve an original copy of the CAD drawing.

[Claim 3]

The method as set forth in claim 1, wherein in the associated information extracting step, the database is built by automatically acquiring an attribute of the GIS from title information of the CAD drawing without separately inputting an attribute of the GIS.

[Claim 4]

The method as set forth in claim 3, wherein the database built by automatically acquiring an attribute of the GIS from title information of the CAD drawing comprises: business information regarding a business name, an orderer, a contractor, a contract number, a contract year, a system code, and a WBS code; construction information regarding a construction field, a construction step, a route direction, a railway classification, a route name, a facility location, and a tool; drawing information regarding a drawing scale, an edition number, a drawing name, a drawing number, and an applied standard version; and management information regarding a writer, a reviewer, and a checker.

[Claim 5]

The method as set forth in claim 1, wherein in the associated information extracting step, the database is built by automatically acquiring an attribute of the GIS from layer information of the CAD drawing without separately inputting an attribute of the GIS.

[Claim 6]

The method as set forth in claim 5, wherein the layer information is used by a rule determined by a user in a generally used CAD drawing tool.

[Claim 7]

The method as set forth in claim 1, wherein in the associated information extracting step, the database is built by automatically acquiring an attribute of the GIS from symbol information of the CAD drawing without separately inputting an attribute of the GIS.

[Claim 8]

The method as set forth in claim 7, wherein the symbol information is used by a rule determined by a user in a generally used CAD drawing tool.

[Claim 9]

The method as set forth in claim 5 or 7, wherein the facility names are classified (names of an apartment complex and names of Dongs are classified in the case of a group such as an apartment complex) in detail in the layer and symbol information, and the name of the group is marked in detail by a user manipulating Environment Setting Option in Menu in a GIS screen and merging the classified layer names into one or the name of the group is briefly marked as the lowest classification names of the classified facility names.