KR101585950B1

KR101585950B1 - Drawing conversion automatic creation

Info

Publication number: KR101585950B1
Application number: KR1020150058942A
Authority: KR
Inventors: 양지은
Original assignee: (주)일신이앤씨
Priority date: 2015-04-27
Filing date: 2015-04-27
Publication date: 2016-01-18

Abstract

The present invention relates to a method and apparatus for creating a road-based underground facility and a method for automatically generating a turn-around conversion for creating a road register. More particularly, the present invention relates to a method of creating a road- The method comprising the steps of:

Description

{Drawing conversion automatic creation} method for creating road-based underground facilities and creating a road register.

The Road Register is a drawing that is drawn up to identify the status of roads and carry out maintenance effectively, and the junctions with new roads, new roads, and new roads are continuously generated, and the changes are updated from time to time or with regular field surveys .

In addition, all the pipelines of urban infrastructures that supply water, sewage, electricity, telephone, gas and heating, which are essential for all life, are buried almost underground not only in big cities but also in local small towns. Especially, Hazardous and hazardous material pipelines are buried underground, and it is very important to manage these buried underground facilities.

However, in Korea, the management system of related data for network management and interpretation depends on manual work, and it takes a lot of manpower and cost to store and manage these data, and these data are not systematically managed in a common format .

As a result, it is not easy to grasp the status of maintenance for existing pipelines, and preventive maintenance is not done properly.

On the other hand, general underground hazardous facilities are mainly buried along the roads so that they can be buried in a relatively simple structure and can be used to avoid excavation and other facility management during construction. However, in industrial complexes, Because of the installation of underground hazardous facilities, it is a complicated and dangerous structure that is overlapped with several layers and can no longer be buried underground pipelines.

Also, from the aspect of data management of existing underground facilities, related drawings, road signs, and records are stored in the form of files, so there is a high risk of damage and loss, and data modification is also complicated.

These materials, which are stored in paper form, are difficult to perform the function of superimposing and analyzing various kinds of drawings and maps, and also it is difficult to perform the function of analyzing the position information in drawings and maps, It is difficult to implement a function that can be seen.

On the other hand, in order to make the road register and the land register, the surveying technicians measure the objects of the road / land / facilities by using various surveying instruments, and then store and manage the information as numerical text information.

In general, these data are usually made in the form of excel (Excel), which is then manually calculated and used to create a control ledger, such as a road ledger and a land ledger.

Therefore, it takes a lot of time to produce the land register and the management register, as well as the inaccurate land / road register according to the manual work.

Patent No. 10-1180415

SUMMARY OF THE INVENTION The present invention has been made in order to solve the above-mentioned problems, and an object of the present invention is to provide a method of automatically generating a planar linear shape and a longitudinal linear shape providing basic information to a design by utilizing text data measured at a survey site And to provide a method of generating the same.

According to an aspect of the present invention, there is provided a method of forming a three-dimensional line and a management line by connecting a text file storing information of a road, a land, and a facility, and CAD information having basic drawing information, Is automatically generated.

The method for creating the road-based underground facilities according to the present invention and the method for creating the road register are automatically generated by automatically generating the plane line and the terminal line that provide basic information to the design using the text data measured at the survey site The accuracy of the data is that the road and land register are more accurate.

In addition, the present invention has an advantage in that it can sufficiently utilize the existing stored data because the work is executed by connecting the Excel file storing the survey information and the CAD information having the basic drawing information.

Therefore, it is advantageous to manage the road and land register more effectively.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is an overall schematic diagram of a biometric transformation generation method according to the present invention. FIG.
2 is a flow diagram of a planar linear process in accordance with the present invention;
3 is a flow diagram of a planar linear module according to the present invention;
4 is a planar linear embodiment according to the present invention.
FIG. 5 is a view illustrating a planar linear module according to the present invention. FIG.
6 is an exemplary view showing a state in which a planar linear shape is generated;
7 is a flow diagram of an end-to-end linear process according to the present invention;
Figure 8 is a flow diagram of an end-to-end linear module in accordance with the present invention;
Figure 9 is an end-linear embodiment according to the present invention.
10 is an embodiment in which a longitudinal linear module according to the present invention is applied.
11 is an exemplary diagram of a state in which an end-of-line shape is generated;

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. In the drawings, the same reference numerals are used to designate the same or similar components throughout the drawings.

In the following description of the present invention, a detailed description of known functions and configurations incorporated herein will be omitted when it may make the subject matter of the present invention rather unclear.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory and are intended to provide further explanation of the invention as claimed.

2 is a flow chart of a planar linear process according to the present invention, Fig. 3 is a flowchart of a planar linear module according to the present invention, Fig. 4 is a plan view of a planar linear module according to the present invention, Fig. 7 is a flowchart of an end-to-end linear process according to the present invention. Fig. 8 is a flow chart of the linear linear process according to the present invention. Fig. Fig. 10 is a diagram illustrating a longitudinal linear module according to the present invention; Fig. 11 is an exemplary diagram illustrating a state in which a longitudinal linear line is generated; Fig.

As shown in FIGS. 1 to 11, the method for creating a road-based underground facility and creating a road registry according to the present invention includes the steps of measuring an object to be surveyed, generating an Excel file according to a predetermined format, Opening the work drawing with CAD TOOL and selecting the work area by opening the Excel file storing the surveyed data, reading and analyzing the information of Excel by selecting the starting point and ending point to create the plane / And a step of automatically generating a plane linear shape and a terminal linear shape in a work area of the CAD.

To explain the planar linear automatic generation step, select the drawing to work with CAD by driving the road ledger conversion tool. After OPEN, open the Excel file that stores the surveyed data to create the plane linear shape, select the work area, If you select the start point and end point that you want to create the line, you can read the information of Excel, analyze / process it, convert it into CAD information, save it, and create a flat line in CAD working area.

As shown in FIG. 4, a road map database conversion tool is driven to read survey information stored in an Excel file to determine whether the survey information has been prepared in a predetermined format. If the information is normal, an Excel file is read and information data and numerical data And store them in the IN-MEMORY database. In case of creation errors, check the start point, end point, and midpoint information, and check if the curve radius, outer cap, curve length, If it is confirmed that it is inputted, it is confirmed whether or not the information is matched with the information opened by the CAD in the normal case, and the survey information is read again in order to classify the information data and the numerical data and store the same in the IN-MEMORY database.

At this time, if an error is detected, error information is output and the user is notified.

The IN-MEMORY database information is converted into the instructions and parameters of the CAD LISP language and the information of the DXF format through the analysis step of deriving the necessary result values by applying the appropriate function to the digitized information through the storing step in the database .

After converting the analyzed information, the converted information is transferred to the CAD environment and the command is executed so that the transferred information can be displayed in the CAD environment.

4 is a view showing an example of a state in which a basic diagram (terminal diagram) is opened on AutoCAD, a diagram of an abstract diagram created in a survey after opening a basic diagram, and an example of an embodiment of the present invention will be described with reference to FIGS. Open the file and select the corresponding area.

In this case, the embodiment is 0 + 000 to 0 + 500 as shown in FIG.

After selecting the Excel (field data), press the "Linear Linear" button of FIG. 5, and then select the starting point of the plane linear reference point of the basic curve as shown in FIG. 6 to display the start point (SECT_ST_KM) SECT_ED_KM) is read, the reference point is shifted by the corresponding position, and the direction of (↗, ↘) is determined based on the SLOP value. After connecting the line to the vertex of the circle, SLOP, ST_HIT, SLP_LEN, The planar linear shape is automatically generated in the state shown in Fig.

In the description of the automatic longitudinal line generation method of the present invention, the drawing tool is operated to select a drawing to be CAD, OPEN, and an Excel file storing the surveyed data is created If you select the starting and ending points that you want to create the end line, you can read the Excel information, analyze / process it, convert it into CAD information, save it, and create the end line in CAD working area.

As shown in FIGS. 7 to 11, when the surveying information is stored in an Excel file, it is determined whether the survey information is prepared in a predetermined format. If the survey information is normal, an Excel file is read and information data In the case of a creation error, it is checked whether the starting point, the end point, and the intermediate point information are correctly classified. If it is determined that the inclination, the inclination, the length and the height information are correctly inputted, And then the measurement information is read again to sort the information data and the numerical data and store the same in the IN-MEMORY database.

The IN-MEMORY database information is converted into the instructions and parameters of the CAD LISP language and the information of the DXF format through an analysis step of deriving necessary result values by applying appropriate function to the digitized information through the step of storing in the database .

9 is a diagram showing a state in which a basic diagram (terminal diagram) is OPENed on AutoCAD. FIG. 9 is a diagram showing an example of a state in which a basic diagram is opened, Open the file and select the corresponding area.

At this time, the embodiment is 0 + 000 to 0 + 500 as shown in FIG.

After selecting the Excel (field data), the user selects the starting point of the terminal line reference point of the basic diagram as shown in FIG. 11 after pressing the "vertical line" button of FIG. 10 and displays the start point (SECT_ST_KM) (SECT_ED_KM) is read, and the reference point is shifted by the corresponding position. After determining the direction of (↗, ↘) based on the SLOP value, the line is connected to the vertex of the circle and SLOP, ST_HIT, SLP_LEN, The terminal line data is automatically generated in the state shown in FIG.

The terms used in the present invention are as follows. CAD: Computer-aided design is a general software used in design. DXF: Abbreviation of Drawing Exchange Format. It is a standardized data format used in CAD.

Here, LISP is a kind of XLISP derived from standard LISP, which is the language used to manage and manage drawings in AUTOCAD and is usually called AutoLisp.

As described above, the operation of the automatic generation method for creating the road-based underground facility and the road registry according to the present invention is described in the above description and drawings, but the description is only given by way of example, It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.

delete

Claims

Measuring an object to be surveyed and generating an excel file in accordance with a predetermined format to quantify the survey data;
Opening the work drawing with CAD TOOL and opening the Excel file storing the surveyed data, selecting the work area,
Selecting a start point and an end point to which a plane / termination line is to be created, reading the information of the Excel, analyzing / processing the converted information,
And automatically generating a planar linear shape and a terminal linear shape in the working area of the CAD.

And a step of reading the survey information stored in the excel file and determining whether the survey information is prepared in a predetermined format, and if so, reading the excel file and classifying the information data and the numerical data into the IN-MEMORY database, If it is a creation error, check the start point, end point, and midpoint information. If it is normal, check whether the curve radius, outer cap, curve length, , And then reads out the survey information at the time of coincidence to sort the information data and the numerical data to store them in the IN-MEMORY database, and stores the stored information in the database to apply the numerical information to the necessary result values , The IN-MEMORY database information is stored in the CAD LISP language name And converting the analyzed information into information of a DXF format and transferring the converted information to the CAD environment and executing the command so that the information transmitted in the CAD environment can be displayed. A Method for Automatic Generation of Underground Facilities and Creation of Road Registry.

The method as claimed in claim 2, further comprising the steps of: selecting a drawing to be operated by a CAD by driving a road large-scale conversion tool, selecting an operation file by OPENing an Excel file storing the surveyed data to make a line- When the starting and ending points are selected, the information of the Excel is read, analyzed / processed, converted into CAD information, stored, and the longitudinal linear and the horizontal linear are generated in the working area of the CAD A Method for Automatic Generation of Road - based Underground Facility and Creation Method for Making Road Book.

The method as claimed in claim 2, wherein, when the starting point of the base line of the basic curve and the starting point of the reference line of the terminal linear line are selected, the starting point (SECT_ST_KM) and the ending point (SECT_ED_KM) (↗, ↘) is determined based on the SLOP value, and the line is connected to the circle vertex. Then, the field data such as SLOP, ST_HIT, SLP_LEN, and height value are read, And generating a longitudinal line shape based on the road surface information.