KR20010037981A - Method for converting map data to data for object_related geographic information system - Google Patents

Abstract

PURPOSE: A method for exchanging different type of drawing data to object-relational type geographic information system(GIS) is provided to use drawing and facility information data built by another GIS or drawing drafted by CAD system even with GIS for facility management using GEUS by exchanging drawing data such as data exchange format(DXF) or shapefile to data of data base management system(DBMS) for object-relational type GIS like GEUS. CONSTITUTION: The first stage is that initial environment is set up inputting(501) database name to be created at DBMS for object-relational type GIS and file name of drawing data to be exchanged. The second stage is that attributes having space data type defined in class and class reading through drawing data file to be exchanged is defined(503) at database of DBMS for object-relational type GIS. The third stage is that drawing data file to be exchanged is exchanged(506) into space data provided from DBMS for object-relational type GIS extracting space data, reading again drawing data file to be exchanged. and the exchanged space data is stored(507) at database of DBMS for object-relational type GIS. A recorder is provided to be able to read it by computer.

Description

METHOD FOR CONVERTING MAP DATA TO DATA FOR OBJECT_RELATED GEOGRAPHIC INFORMATION SYSTEM}

The present invention relates to a format conversion method of drawing data and a computer-readable recording medium having recorded thereon a program for realizing the method, and more particularly, to a method for converting drawing data of another format into data for an object relational geographic information system. A computer readable recording medium having recorded thereon a program for realizing the method.

First, the concept of terms used in the present invention will be described.

The Data eXchange Format (DXF) is a CAD drawing exchange file developed by Autodesk for the exchange of drawing data between AutoCAD and Computer Aided Design (CAD) systems. It is composed of ASCII (American Standard for Information Interchange) file and is a data exchange format that is widely used in Korea for data format conversion between Geographic Information System (GIS) and CAD system.

Shapefile data format is a spatial data format file developed by the Arc / Info system to represent drawing data. It is composed of binary files and is widely used for data format exchange between geographic information systems. The data format.

Geographic Information System (GIS) manages the graphic elements of spatial objects including geographic attributes and their corresponding attribute information as if the database system processes general data and presents graphic screens that are visible to users. It is an integrated system that can be used for I / O and analysis.

Geographic Information System (GIS) is widely used for facility management and planning in various fields such as environment, urban development, civil engineering, water resources, transportation, statistics, as well as telecommunication facilities and defense. Thus, due to the overlapping investment in introducing a geographic information system (GIS) for each institution, it is not only possible to waste budget and data compatibility with other institutions, but also to standardize the geographic information system (GIS) field that is gradually spreading. Becomes difficult.

Conventionally, drawing data such as DXF or Shapefile is not converted into data in object relational geographic information system (GIS) database management system (DBMS: DataBase Management System) such as GEUS. In the geographic information system for facility management where the relational GIS DBMS is used, there is a problem in that the drawings drawn in the CAD system or the drawings and facility information data constructed in other geographic information systems cannot be used.

In addition, not only basic graphic data but also symbol and attribute data must be converted due to the characteristics of drawing data. DXF data cannot be used in geographic information system using DBMS for object relational GIS such as Zeus because there is no conversion method. There was a problem.

The present invention has been made to solve the problems described above, it is not the data for the object-relational geographic information system, but look through the entire file of the drawing data to define the defined content in the database and read again by the corresponding object-objective geography It is an object of the present invention to provide a method of converting data for information system and a computer-readable recording medium having recorded thereon a program for realizing the method.

1 is an exemplary configuration diagram of a computer to which the present invention is applied.

2 is a schematic explanatory diagram of a method for converting drawing data of another format according to the present invention into data for an object relational geographic information system;

3 is an exemplary view showing spatial data types in DXF and GEUS used in the present invention.

4 is an example of a group code of DXF used in the present invention.

5 is a flow diagram of an embodiment of a method for converting DXF data into data for an object relational geographic information system in accordance with the present invention.

6 is an exemplary view showing a section of the DXF used in the present invention.

7 is a detailed flowchart illustrating an example of a process of extracting information from each section by analyzing a DXF file according to the present invention.

8 is a detailed flowchart illustrating a process of extracting spatial data from a DXF file according to the present invention.

9 is a detailed flowchart illustrating an example of a process of converting data in the form of a GEUS database for an entity section of a DXF file according to the present invention.

FIG. 10 is a flow diagram of an embodiment of a method for converting Shapefile drawing data into data in GEUS. FIG.

FIG. 11 is an exemplary diagram showing spatial data types in a Safefile and a Zeus used in the present invention. FIG.

* Explanation of symbols for the main parts of the drawings

101: central processing unit 102: main memory unit

103: auxiliary memory 104: output device

105: input device

In order to achieve the above object, the present invention provides a method of converting drawing data of another format into data of a database management system for an object relational geographic information system, the file name of the drawing data to be converted and the object relational geographic information system (GIS). A first step of setting an initial environment by receiving a database name to be created in a database management system (DBMS) for a geographic information system; Reading a drawing data file to be converted from beginning to end and defining attributes having a class and spatial data types defined in the class in a database of the DBMS for object relational GIS; And re-reading the drawing data file to be converted, extracting spatial data, converting the spatial data into a spatial data type provided by the DBMS for object relational GIS, and storing the converted spatial data in a database of the DBMS for object relational GIS. Characterized in that comprises a.

The present invention also provides a database management system for an object-relational geographic information system having a large capacity processor, a file name of a drawing data to be converted, and a database management system (GMS) for the object-relational geographic information system (GIS). A first function of setting an initial environment by receiving a database name to be created in a management system; A second function of reading a drawing data file to be converted from beginning to end and defining attributes having a class and a spatial data type defined in the class in a database of the DBMS for object relational GIS; And a third function of reading the converted drawing data file again, extracting spatial data, converting the spatial data into a spatial data type provided by the object relational GIS DBMS, and storing the converted spatial data in a database of the object relational GIS DBMS. A computer readable recording medium having recorded thereon a program for realizing the present invention is provided.

The above objects, features and advantages will become more apparent from the following detailed description taken in conjunction with the accompanying drawings. Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is an exemplary configuration diagram of a computer to which the present invention is applied.

The computer to which the present invention is applied includes a central processing unit 101, a main memory device 102, an auxiliary storage device 103, an output device 104, and an input device 105.

The central processing unit 101 controls and manages the entire operation and performs a given task, and the main memory unit 102 stores a program to be executed in the central processing unit 101 and stores various data used during the execution of the task. Since the storage in the main memory device 101 is limited, the auxiliary memory device 103 is responsible for storing a wider and larger amount of data. The output device 104 is responsible for providing information to the user, such as execution results of the monitor, printer, etc., execution process and system information, and the input device 105 receives a user's input such as a keyboard, a touch screen, etc. It is in charge of the function to deliver to 101.

The process of converting the drawing data of another format into the data of the database management system (DBMS) for the object relational geographic information system (GIS) is recorded in the main memory device 102, and the central processing unit 101 according to the flow of control. Is executed. It is assumed that a database related to the spatial information requested through the input device 105 has already been created and stored in the auxiliary storage device 103.

2 is a schematic explanatory diagram of a method for converting drawing data of another format according to the present invention into data for an object relational geographic information system.

After the program is uploaded from the auxiliary memory device 103 to the main memory device 102 and the work is started by the CPU 101, the input module 201 inputs information such as the name of a database to be created and a drawing data file name. Get input. The extraction module 202 extracts various kinds of information of the drawing data file, and performs a data conversion on the drawing data in the conversion module 203. The storage module 204 converts the values according to the spatial type provided by the GEUS, which is an object relational GIS DBMS, and stores the values in the database 205 as the GEUS spatial type.

3 is an explanatory example showing spatial data types in DXF and GEUS used in the present invention.

First, let's look at GEUS and DXF files.

GEUS is a DBMS for object-relational GIS developed by Korea Telecom. The data types provided are generally point, simple line, polyline, polygon, and circle. There is a rectangle type. Each data type is an object type for representing points, simple lines, compound lines, polygons, rectangles, and circles.

GEUS supports line tables, symbol tables, annotation tables, color tables, A range table is defined. In addition, in the GEUS, not only the coordinates of the spatial type but also other extraction information may be converted into a unique form defined in the Zeus and extracted according to the defined form if necessary.

The line table in GEUS contains information about the thickness, color, type, etc. of the line. At this time, the color applied to the line is expressed using the color defined in Zeus.

A symbol table in GEUS has a symbol area, a type of symbol, a type constituting the symbol, and coordinate information thereof.

The symbol types provided by GEUS are as follows.

It is a line symbol (SymbolLine), a symbol symbol (SymbolCurve), a square symbol (SymbolRectangle), a centrifugal ball (SymbolCircle), a selection symbol (SymbolSelect), a polygon symbol (SymbolPolygon), a group symbol (SymbolGroup), a symbol symbol (SymbolPencil), and the like.

The color table in GEUS has red (R), green (G: green), blue (B: blue) and color name information.

An annotation table in GEUS contains information such as font, color, annotation content, and annotation coordinates associated with the annotation.

The range table in GEUS has maximum minimum region information in other formats.

That is, a class called "gis_info" is defined, and attributes "sc_left_low_pt" and "sc_right_high_pt" exist in this class and have area information.

As for the data conversion format (DXF), DXF is composed of four sections: header section, table section, block section, and entity section. Is defined.

The header section of the DXF contains general information about the drawing. Each of the 136 parameters, including the bottom and top coordinates of the drawing, the AutoCAD version, and the font size that appear in the header section, are set to the relevant values when converting from CAD data to DXF. This information affects the entities. give.

The table section of the DXF defines eight tables that are used for drawing: line type, layer, and style. The contents of the tables, such as the shape of the line, the size of the text, and the designated color, affect drawing preferences and the elements, and are referred to when the elements are drawn.

The block section of the DXF is a block composed of several elements such as a line, an arc, and a circle, and is inserted into the drawing by an insert element in an entity section.

The entity section of the DXF contains the actual data list for the entity.

The entities used in DXF include Line, PolyLine, Circle, Arc, Text, Insert, Dimension, etc. It has a separate format consisting of group codes, and among the group codes for defining an element, there are always codes and optionally codes.

Such a Zeus (GEUS) and DXF are described by matching spatial data types in FIG.

The points of the spatial data types provided by DXF are "POINT" and "TEXT". In GEUS, "DB_POINT" is used. Simple lines are "LINE" in DXF, "DB_SIMPLELINE" in GEUS, "POLYLINE" in DXF, and "DB_POLYLINE" in GEUS.

Polygons among the spatial data types provided by DXF are "POLYLINE" with a flag value of 1, and "DB_POLYGON" in GEUS. The squares correspond to "TRACE" and "SOLID" in DXF and "DB_RECTANGLE" in GEUS. The circle corresponds to "CIRCLE" in DXF and "DB_CIRCLE" in GEUS.

4 is an example of a group code of DXF used in the present invention.

Each of the elements used in the DXF has a separate format consisting of group codes. Among the group codes for defining the elements, there are codes that must always exist and optionally codes that exist.

The values defining the entities appear after these group codes and are used in the manner defined for each entity format. Each entity is described after group code 0 and refers to what is defined in the table and block sections according to their characteristics.

4 shows the group codes shown in the DXF file and their meanings.

5 is a flowchart illustrating a method of converting DXF data into data for an object relational geographic information system according to the present invention.

In the process of converting a DXF file to data in GEUS, which is a database for an object relational geographic information system, an initial environment is set by receiving a DXF file name to be converted and a GEUS database file name to be generated (501). The extraction module 202 analyzes the DXF file to extract information from each section (502). In other words, the DXF file is read in sequence, the header section extracts the header parameters related to the drawing environment of the DXF file, and the block section uses the line type, layer, and style ( Style) information is extracted, and the entity data extracts actual data about the entities.

The extraction module 202 checks each layer of the DXF file, generates a class related to the layer for the first appearing layer, and generates necessary attributes according to the group code therein (503). That is, the extraction module 202 checks the first layer that appears when creating the first class and its related attributes, and checks if there is a class with the same name, and if not, creates the class and generates the necessary attributes according to the group code therein. do. If a class with this name exists, the class is already created, so look for the next layer. When creating a new class each time a layer is encountered at scan time, the class name is the layer name and the attribute is associated with the group code.

For a layer with a common layer name and a different spatial type, there can be multiple attributes with a spatial type in a class so that the same layer can have different spatial types in the DXF file. In other words, when you extract information from a DXF file and put it into a database, you check the spatial type and store it in the desired attribute accordingly. The required variables depend on the group code of the DXF file. The variables needed before extraction are already defined and the variables accordingly must be defined. Use this variable to iteratively extract entities in the DXF file.

It is checked whether a new layer exists in the DXF entity section (504). If it does not exist, the process ends. If so, the DXF spatial data is extracted (505).

The transformation module 203 performs data transformation for the entity section, which is the actual data list of the DXF file (506). The transformation module 203 converts the elements corresponding to the DXF data transformation range into the spatial data type of the GEUS database. When performing data conversion, each of the elements performs the conversion by referring to the header, line type, and style information. If the type provided by DXF is not provided by the GEUS database, it should be converted to match the most suitable type. Through the description of FIG. 3 described above, matching spatial data types have been described.

The storage module 204 stores the data in the database as a GEUS spatial data type (507). When the storage module 204 scans the DXF file a second time and the relevant entities appear in the DXF file, the extraction module 202 converts the values for the spatial data type provided by GEUS and then applies the GEUS space. Stored in the database as a data type.

Finally, it is checked whether another layer exists in the DXF file (508), and if another layer exists, the process is repeated from the process of extracting new layer DXF spatial data (505), and ends if no other layer exists.

6 is an exemplary view showing a section of the DXF used in the present invention.

The DXF is divided into four sections, each with its own unique information about the graphics. The section starts with group code 0 followed by the section and the section ends with group code 0 and "ENDSEC".

The group code 0 means that the new content starts from the next line as well as the section. The exact meaning depends on what comes on the next line.

Each section (SECTION) of the DXF file has a header section (HEADER SECTION, 601), a table section (TABLE SECTION, 602), a block section (BLOCK SECTION, 603) and an entity section (ENTITY SECTION, 604) as shown in the figure. It consists of.

The header section HEADER SECTION 601 will be described as follows.

The header section (HEADER SECTION, 601) consists of a number of variables that contain the setting values of the variables associated with the drawing, followed by the group code 9 followed by the variable name, followed by the group code and the group value with the variable values. Each variable name is prefixed with $, and only the values of "$ EXTMIN" and "$ EXTMAX" required to set the coordinates are used for the format conversion for Zeus.

The table section (TABLE SECTION, 602) is described below.

The table section (TABLE SECTION 602) consists of several tables, each of which is not related in order, but the "LTYPE" table always precedes the LAYER table. Each table starts with a table of group code 0 and ends with "ENDTAB" of group code 0.

The "LTYPE" table, which constitutes a table section (TABLE SECTION 602), represents the shape of a special line. When converting to a spatial data type of GEUS, the "LTYPE" table is read to form a line pattern of a GEUS line style file. The configuration of the "LTYPE" Table may be made as shown in Table 1 below.

Group code Contents 72 Sort code 73 Dash Length (Repeat Times) 40 Total pattern length 49 Dash Length 1 49 Dash Length 2 3 pattern

The layer table constituting the table section 602 represents a common element to be used by each layer. This is where you get the layer name and the shape and color of the lines used by that layer. The structure of the layer table (LAYER Table) is shown in [Table 2].

Group code Contents 2 Layer name 62 Number of colors 6 Line type name 70 Maximum number of layers

There are many other tables, but the two tables above are required for spatial data conversion. You can use the "LTYPE" table and the LAYER table to extract the colors and shapes associated with the graphic lines.

A block section 603 will be described below.

In the block section 603, information about all the blocks BLOCK is included together with the entities forming the block BLOCK. The format is the same as the entity section (ENTYTY SECTION 604) and all blocks (BLOCKs) must be between "BLOCK" and "ENDBLK" and cannot overlap between entities. A block is a collection of spatial objects in which complex objects are grouped together to form a symbol using the information contained therein.

The entity section ENTITY SECTION 604 is described as follows.

The entity section 604 is composed of objects necessary to represent actual drawings such as points, lines, planes, circles, and texts representing spatial objects. Representation forms and components are almost identical to block sections 603. All elements required for data transformation are extracted from this entity section (ENTITY SECTION, 604).

First, a line is a straight line having a start point and an end point, and may be configured as shown in [Table 3] below.

Entity Group code Contents LINE 10 Starting point X coordinate 20 Starting point Y coordinate 30 Starting point Z coordinate 11 Endpoint X coordinate 21 End point Y coordinate 31 End point Z coordinate

Secondly, POINT is an object having only one coordinate and can be used for expressing an annotation and can be configured as shown in [Table 4] below.

Entity Group code Contents POINT 10 X coordinate 20 Y coordinate 30 Z coordinate

Third, the circle (CIRCLE) is represented by the coordinates and the radius of the center point, it can be configured as shown in [Table 5].

Entity Group code Contents CIRCLE 10 Center point X coordinate 20 Center point Y coordinate 40 radius

Fourthly, the arc (ARC) is expressed as a center point, a radius, a start angle, and an end angle, and may be configured as shown in [Table 6] below.

Entity Group code Contents Arc (ARC) 10 ARC center point X coordinate 20 ARC center point Y coordinate 40 radius 50 Starting angle 51 Angle

Fifthly, it is SOLID. This object is a triangle or rectangle filled inside. If the coordinates have 4 coordinates and 4 points are different from each other, the result is a quadrangle. It may be configured as shown in the following [Table 7].

Entity Group code Contents Solid (SOLID) 10 First corner X coordinate 20 First corner Y coordinate 11 Second corner X coordinate 21 Second corner Y coordinate 12 3rd corner X coordinate 22 3rd corner Y coordinate 13 4th corner X coordinate 23 4th corner Y coordinate

Sixth, the text may be composed as shown in Table 8 below.

Entity Group code Contents TEXT 10 The X coordinate of the text insertion point 20 Y coordinate of text insertion point 40 The height of the uppercase text One A string of text 50 Rotation angle 41 Relative X-Axis Scale 51 Tilt angle 7 Text style name 71 Text forming flag 72 Horizontal arrangement 73 Vertical array 11 ALIGNMENT POINT

Seventh is SHAPE. This spatial object is represented using LINE, ARC, and CIRCLE, and is input at the POINT position and is the same as TEXT. It may be configured as shown in Table 9 below.

Entity Group code Contents SHAPE 10 X coordinate of SHAPE insertion point 20 X coordinate of SHAPE insertion point 40 size 2 SHAPE Name 50 Rotation angle One Relative X-Axis Scale 51 Tilt angle

The eighth insert is where the symbols defined in the block section 603 are entered. It may be configured as shown in Table 10 below.

Entity Group code Contents INSERT 66 Attribute follow-up flag (FOLLOW FLAG) (default 0) 2 Block Name 10 Block insertion position 41 X scale factor (optional, default 1) 42 Y scale factor (optional, default 1) 43 Z scale factor (optional, default 1) 50 Rotation angle (optional, default 1) 70 Column Count (optional, default 1) 71 Row Count (optional, default 1) 44 Column Spacing (optional, default value 0) 45 Row Spacing (optional, default value 0)

Ninth, the compound line (POLYLINE) may be configured as shown in Table 11 below.

Entity Group code Contents Compound line (POLYLINE) 66 Verticals follow flag 10 Dummy Point 70 POLYLINE flag (FLAG) 40 The width of the starting point 41 The width of the endpoint 71 Polygon Mash M vertex count 72 Polygon Mash N vertex count 73 Smooth surface M density 74 Smooth surface N density 75 Curve & Smooth surface

Tenth, the vertex is This is used with POLYLINE and represents the midpoints of POLYLINE.

The eleventh trace is a straight segment for a particular purpose. It looks like a polyline, but has a similar data structure to solids (SOLID). It may be configured as shown in Table 12 below.

Entity Group code Contents TRACE 10 First corner X coordinate 20 First corner Y coordinate 11 Second corner X coordinate 21 Second corner Y coordinate 12 3rd corner X coordinate 22 3rd corner Y coordinate 13 4th corner X coordinate 23 4th corner Y coordinate

The twelfth three-dimensional (3DFACE) is similar to the solid (SOLID) in structure, but having a Z value is three-dimensional.

Thus each section of the DXF file is organized.

In order to convert the DXF file to the spatial data type of GEUS, the header section is first shown in the DXF file and correspond to the GEUS region table. $ EXTMIN "and" $ EXTMAX "are converted to" gis_info "which is the area table of GEUS.

DXF Zeus Header variable Group code Group value Class name The object name Object type $ EXTMIN 10 X coordinate value gis_info sc_left_low_pt Point 20 Y coordinate value 30 Z coordinate value Not converted $ EXTMAX 10 X coordinate value sc_right_high_pt Point 20 Y coordinate value 30 Z coordinate value Not converted

The insert type extracted from the entity section 604 is where a symbol defined in the block section 603 is inputted. The information extracted from this section is extracted to a symbol table in GEUS. Match it.

The SHAPE type provided by DXF is expressed by using LINE, ARC, and CIRCLE. It is input at the POINT position and is the same as TEXT. In the case of SHAPE type, it corresponds to the symbol type provided by GEUS, and the text inputted at the POINT position corresponds to coordinates, annotation contents, annotation font, color, etc. in the annotation table, and the information is converted to Zeus ( GEUS) to switch to the table type provided.

7 is a detailed flowchart illustrating a process of extracting information from each section by analyzing a DXF file according to the present invention.

FIG. 7 describes in detail the process 502 of analyzing a DXF file and extracting information from each section.

It is determined whether information to be extracted while reading the DXF file exists in the header section (701). As a result, if the information to be extracted exists in the header section, the information "$ EXTMIN" and "$ EXTMAX" necessary for the contour coordinates is extracted (702). "$ EXTMIN" has positional information on the left-bottom of the figure, and "$ EXTMAX" has information on the right-top of the figure, so that the size of the entire figure can be grasped.

As a result of determining whether the information to be extracted exists in the header section, and if information extracted from the header section does not exist or exists in the header section, the process proceeds to the next step and checks whether information to be extracted exists in the table section (703).

As a result of checking whether the information to be extracted exists in the table section, if it exists, it affects the drawing elements of the spatial data type such as the shape of the line, text size, designated color, line pattern, color number, and line type. The feature is extracted from the table section (704).

As a result of checking whether the information to be extracted exists in the table section, if information that does not exist in the table section or extracted in the table section is moved to the next step, it is checked whether information to be extracted exists in the block section (705).

As a result of checking whether the information to be extracted exists in the block section, the block is a collection of spatial objects, and if so, the symbol is constructed using this information (706).

As a result of checking whether the information to be extracted exists in the block section, and if information extracted from the block section does not exist or exists in the block section, the process proceeds to the next step and checks whether information to be extracted exists in the entity section (707). .

As a result of checking whether information to be extracted exists in the entity section, if present, spatial data about objects necessary to represent the actual drawing is extracted (708).

As a result of checking whether the information to be extracted exists in the entity section, if information that does not exist in the entity section or extracted information present in the entity section is analyzed, the process of analyzing the DXF file and extracting information from each section (502) is terminated.

8 is a detailed flowchart illustrating a process of extracting spatial data from a DXF file according to the present invention.

8 illustrates a process 505 of extracting a characteristic value related to DXF spatial data.

It is determined whether the type of spatial data in the layer to be extracted is a point or text (801). As a result of the determination, if the spatial data type is a point or text, the X and Y coordinates are extracted, and the color of the point, whether or not the annotation is included, and the annotation content information is extracted (802).

As a result of determining whether the type of spatial data is a point or text, if it is not a point or text or if the spatial data information is extracted from a point or text, extraction is performed. In operation 803, it is determined whether the type of spatial data in the layer to be formed is a simple line or a polyline.

As a result of checking whether the spatial data type is a simple line or polyline, if the line is simple or polyline, the shape of the line, text size, designated color, and line In operation 804, the coordinates for the actual space type and the characteristics affecting the drawing elements of the space type such as the pattern, the color number, and the line type are extracted.

As a result of checking whether the spatial data type is a simple line or a polyline, the spatial data from a simple line or a polyline, a simple line, or a polyline After the information is extracted, it is checked whether the type of spatial data in the layer to be extracted is a circle, a polygon, a solid, or a trace (805).

The result of checking whether the type of spatial data is Circle, Polygon, Solid, or Trace is shown. Circle, Polygon, Solid, or Trace ), Information such as center coordinates, fill status, fill color, line pattern, and thickness is extracted (806).

It is not a result of checking whether the type of spatial data is Circle, Polygon, Solid, or Trace, or it is Circle, Polygon, Solid, or Trace. If the spatial data information is extracted from (Trace), it is checked whether there is another spatial data type (807).

As a result of checking whether there is any other spatial data type, information necessary from the spatial type provided by GEUS is extracted (808).

If there is no result of checking whether there is another spatial data type or if information is extracted from the other spatial data types, the DXF spatial data extraction process 505 is terminated.

FIG. 9 is a detailed flowchart illustrating a process of converting data in a format of a GEUS database for an entity section of a DXF file according to the present invention.

FIG. 9 illustrates in detail a process 506 of converting the relevant characteristic values of the extracted spatial data in correspondence with a special class provided by GEUS.

Special classes and properties of GEUS are created to convert and store the actual extraction values. Special classes include line tables, symbol tables, annotation tables, and color tables.

First, it is determined whether the extracted spatial data type to be converted has the characteristics of a line (901). As a result of the determination, if the line has characteristics, the shape, character size, designated color, and line of the line extracted in the attributes such as color, thickness, line type, and line file header information defined in the line table defined in GEUS The pattern and the number of colors are converted in correspondence with each other (902).

As a result of determining whether the extracted spatial data type to be converted has the characteristics of the line, if the conversion is performed without the characteristics of the line or the characteristics of the line, it is checked whether the extracted spatial data type to be converted has the characteristic of color. (903).

As a result of checking whether the extracted spatial data type has the color characteristic, if it has the color characteristic, red (R), green (G), blue (B), color name, The extracted color-related values are mapped to attributes such as the original color type to be extracted (904).

As a result of checking whether the extracted spatial data type has the characteristic of color, if the transformation is performed without the characteristic of the color or the characteristic of the color, it is checked whether the extracted spatial data type to be converted has the characteristic of annotation (905). ).

As a result of checking whether the extracted spatial data type has the characteristics of the annotation, if it has the characteristics of the annotation, the annotation-related values extracted in the attributes such as font size, color, and content of the annotation in the annotation table defined in GEUS These are matched and converted (906).

As a result of checking whether the extracted spatial data type has the characteristics of the annotation, or if the annotation has the characteristics of the annotation or the conversion is performed with the annotation, the extracted spatial data type to be converted has the characteristics of the symbol ( 907).

As a result of checking whether the extracted spatial data type has the characteristics of the symbol, the maximum color of the symbol defined in the symbol table defined in GEUS, the type of the symbol, and the original color for each spatial type constituting the symbol The symbol-related values extracted in the attribute such as the type are mapped and converted (908).

As a result of checking whether the extracted spatial data type has the characteristics of the symbol, if the conversion does not have the characteristics of the symbol or has the characteristics of the symbol, the conversion to the format of the GEUS database is terminated (506).

Thus, an embodiment of a method for converting DXF data into data for an object relational geographic information system has been described.

Next, a description will be given of the conversion of a Safefile, which is drawing data of another format that needs to be converted to data for an object relational geographic information system.

FIG. 10 is a flowchart illustrating a method for converting Shapefile drawing data into data in GEUS according to the present invention.

First of all, the Shapefile data format includes a main file (* .shp), an index file (* .shx), and a dbase file (* .dbf). The main file consists of fixed-length headers and variable-length records, with the types and actual values of the attributes that have a spatial type in them, and the index file contains the start of the instance for the defined attributes. Dbase files have type definitions and actual values for attributes that have nonspatial types. The definitions and values of the spatial attributes are in the main file (.shp) and the definitions and values of the non-spatial attributes are in the dbase file (.dbf).

Shapefiles have a main header first, followed by a description of the entire file, followed by each record header followed by the actual spatial data.

In the process of converting a safefile to data in GEUS, an initial environment is set by receiving a shapefile file name to be converted and a file name of a GEUS database to be generated (1001).

The extraction module 202 analyzes a safefile and extracts main header information (1002). In other words, the safety file is read sequentially, and the type of spatial data type present in the MBR and the shape file of the entire area is extracted from the main file header. Dbase files contain data with non-spatial attributes.

The extraction module 202 generates a database creation, related classes and attributes (1003). When the extraction module 202 first generates a class and its related attributes, it refers to the Shapefile spatial data type and related information extracted from the main file header, and defines the class and related attributes. If there is a class with such a name, since the class is already created, the actual spatial data is extracted. For dbase files, you define attributes in the GEUS database for data with related nonspatial properties.

The extraction module 202 checks whether a new record header exists (1004), terminates if the new record header does not exist, and extracts spatial data from the safefile (1005) if the new record header exists. That is, the extraction module 202 extracts the spatial data of the actual safe file by referring to the record header, and extracts the relevant non-spatial data from the dbase file dbf. Once again, the record number and the length of the actual data are extracted from each record header of the drawing data file in the Shapefile data format. After the header of the record comes the actual data.

Spatial data extracted by the extraction module 202 is passed to the conversion module 203, and converted to suit Zeus data, and stored in the database in the storage module 204. When you extract the information from your Shapefile and put it into the database, it checks the space type and stores it in the desired attribute accordingly. In this regard, first, the conversion module 203 converts data into a GEUS database format (1006). That is, the conversion module 203 performs data conversion on the actual data of the safefile. The conversion module 203 converts the spatial data corresponding to the Shapefile data conversion range into the spatial data type of the GEUS database.

The storage module 204 stores the data converted into the spatial data type of the GEUS database in the database (1007). That is, the second time the Shapefile is scanned in the storage module 204, if the relevant entity appears in the Shapefile, the extraction module 202 converts the values according to the space type provided by GEUS. It is then stored in the database as a GEUS space type.

Finally, the controller checks whether another record header exists in the Shapefile (608), and if another record header exists, repeats the process of extracting spatial data from the Shapefile (604). If it doesn't exist, exit.

FIG. 11 is an exemplary view illustrating spatial data types in a Safefile and a Zeus used in the present invention.

As shown in the drawing, the spatial data type provided by GEUS and the corresponding spatial data type provided by the shape of the Safefile data format are corresponding to points, simple lines, compound lines, polygons, rectangles, circles, and the like. Explaining.

The present invention described above is not limited to the above-described embodiments and the accompanying drawings, and various substitutions, modifications, and changes can be made in the art without departing from the technical spirit of the present invention. It will be apparent to those of ordinary knowledge.

As described above, the present invention provides a database management system (DBMS) for an object relational geographic information system (GIS), such as GEUS, for drawing data such as a data conversion format (DXF) or a safety file. By converting the data into the data of the system, the geographic information system for facility management using GEUS can use the drawings drawn in the CAD system or the drawings and facility information data constructed in other geographic information systems.

Claims (14)

In the method for converting the drawing data of another format into data of the database management system for object relational geographic information system, A first step of setting an initial environment by receiving a file name of the drawing data to be converted and a database name to be generated in a database management system (DBMS) for the object relational geographic information system (GIS); Reading a drawing data file to be converted from beginning to end and defining attributes having a class and spatial data types defined in the class in a database of the DBMS for object relational GIS; And A third step of reading the converted drawing data file again, extracting spatial data, converting the spatial data into a spatial data type provided by the object relational GIS DBMS, and storing the converted spatial data in a database of the object relational GIS DBMS; Drawing data conversion method comprising a. The method of claim 1, The drawing data file to be converted, A drawing data conversion method, characterized in that the data exchange format (DXF: Data eXchange Format) file. The method of claim 2, The second step, A fourth step of reading the DXF file from beginning to end and analyzing the file to extract information from each section; A fifth step of creating a database of the DBMS for object relational GIS according to the input database name; And A sixth step of identifying each layer of the DXF file and generating a class related to the rare layer in the database for the first layer to appear, and also generating necessary attributes according to the group code in the layer; Drawing data conversion method comprising a. The method of claim 3, wherein The fourth step, A seventh step of extracting information required for contour coordinates if information to be extracted exists in a header section of the DXF file; If there is information to be extracted in the table section of the DXF file, it affects the space type drawing elements such as the shape of the line, the text size, the designated color, the line pattern, the number of colors, and the line type. An eighth step of extracting the characteristics to give; A ninth step of constructing a symbol using the information since the block is a set of spatial objects in which a composite object is grouped when information to be extracted exists in a block section of the DXF file; And A tenth step of extracting spatial data of objects necessary to represent an actual drawing when information to be extracted exists in an entity section of the DXF file; Drawing data conversion method comprising a. The method according to any one of claims 1 to 4, The third step, An eleventh step of extracting spatial data for a layer in an entity section of the DXF file; A twelfth step of converting the extracted spatial data into a spatial data type provided by the object relational GIS DBMS; A thirteenth step of storing the converted spatial data in a database of the object relational GIS DBMS; And Step 14 of repeating from the eleventh step if there are other layers in the DXF file Drawing data conversion method comprising a. The method of claim 5, The eleventh step, Determining a type of spatial data to be extracted for a layer in an entity section of the DXF file; A sixteenth step of extracting coordinates, color of the point, whether or not an annotation, and annotation content information when the spatial data type to be extracted is a point or text as a result of the determination of the fifteenth step; As a result of the determination of the fifteenth step, if the spatial data type to be extracted is a simple line or a polyline, the spatial element of the space type such as the shape of the line, the text size, the designated color, the line pattern, the number of colors, the line type A seventeenth step of extracting coordinates for the characteristic and the actual space type that affects it; As a result of the determination of the fifteenth step, if the spatial data type to be extracted is a circle, a polygon, a solid, or a trace, the coordinates of the center, the fill, the fill color, An eighteenth step of extracting information such as a line pattern and thickness; And As a result of the determination of the fifteenth step, if the spatial data type to be extracted is a spatial data type other than the above types, the nineteenth step of extracting necessary information from the object relational GIS DBMS Drawing data conversion method comprising a. The method of claim 5, The twelfth step, Determining a type of the extracted spatial data; A sixteenth step of converting in correspondence to a point provided by the DBMS for object relational GIS when the spatial data type is a point; As a result of the determination of step 15, if the type of the spatial data is text, it corresponds to a point provided by the DBMS for object relational GIS and relates to an annotation in the annotation table of the DBMS for object relational GIS. A seventeenth step of correlating information such as fonts, colors, annotation contents, and annotation coordinates, and analyzing and converting the extracted color information to correspond to a color table; As a result of the determination of the fifteenth step, when the type of the spatial data is a simple line, the line corresponds to the simpleline type provided by the DBMS for object relational GIS and is provided by the DBMS for object relational GIS. An eighteenth step of matching the thickness, color, and line type of the line to the table, and analyzing and converting the extracted color information to correspond to the color table; As a result of the determination in the fifteenth step, when the spatial data type is a polyline, the spatial data type corresponds to a polyline type provided by the object relational GIS DBMS and is provided by the object relational GIS DBMS. A nineteenth step of matching a line table with a thickness, color, and line type, and analyzing and converting the extracted color information to correspond to the color table; The line table provided by the DBMS for object relational GIS corresponds to a polygon type provided by the DBMS for object relational GIS when the spatial data type is a polygon as a result of the determination in the fifteenth step. A twenty-stage step of matching the thickness, the color, and the type of the line with and analyzing and extracting the extracted color information to correspond to the color table; The line table provided by the DBMS for object relational GIS corresponds to a rectangle type provided by the DBMS for object relational GIS when the spatial data type is a rectangle as a result of the determination of the fifteenth step. A twenty-first step of matching the thickness, the color, and the type of the line with and analyzing and converting the extracted color information to correspond to the color table; And As a result of the determination of the fifteenth step, a type in which the spatial data type supports a symbol is converted into a form defined in a symbol table provided by the DBMS for object relational GIS, and if necessary, the line table and the color table. And a twenty-second step of converting in correspondence with the annotation table. Drawing data conversion method comprising a. The method of claim 5, The twelfth step, If the extracted spatial data has a characteristic of a line, the color, thickness, line type, line shape of the spatial data extracted in the line file header information attribute defined in the line table defined in the DBMS for object relational GIS, character size, A fifteenth step of correspondingly converting a designated color, a line pattern, and the number of colors; If the extracted spatial data has color characteristics, red (R: red), green (G: green), blue (B: blue), color name, and extraction are defined in the color table defined in the DBMS for object relational GIS. A sixteenth step of correspondingly converting color-related values of the spatial data extracted to an attribute such as an original color type; If the extracted spatial data has the characteristics of an annotation, the annotation-related values of the spatial data extracted from the annotations defined in the annotation table defined in the DBMS for object relational GIS correspond to attributes such as font size, color, and annotation content. A seventeenth step of converting; And If the extracted spatial data has the characteristics of a symbol, the maximum minimum area of the symbol defined in the symbol table defined in the DBMS for object relational GIS, the type of the symbol, and the original color type for each spatial type constituting the symbol, etc. An eighteenth step of correspondingly converting symbol-related values of the spatial data extracted in an attribute Drawing data conversion method comprising a. The method of claim 1, The drawing data to be converted, Method for converting drawing data, characterized in that it is substantially Safefile drawing data. The method of claim 9, The second step, A fourth step of reading the Shapefile from beginning to end and analyzing the file to extract information from a main file header; A fifth step of creating a database of the DBMS for object relational GIS according to the input database name; And A sixth step of generating a class and related attributes by referring to a shape data type and related information extracted from the main file header of the shape file; Drawing data conversion method comprising a. The method according to claim 9 or 10, The third step, A seventh step of extracting the spatial data with reference to the record header of the safefile; A twelfth step of converting the extracted spatial data into a spatial data type provided by the object relational GIS DBMS; A thirteenth step of storing the converted spatial data in a database of the object relational GIS DBMS; And 14th step of repeating from the eleventh step if there is another record header in the DXF file Drawing data conversion method comprising a. The method of claim 11, The twelfth step, A fifteenth step of converting the extracted spatial data in correspondence to a point type provided by the object relational GIS DBMS; A sixteenth step of converting the extracted spatial data in correspondence with a simple line type provided by the DBMS for object relational GIS if the extracted arc data type has an arc type and has a simple line property; A sixteenth step of converting the extracted spatial data in correspondence to a polyline type provided by the DBMS for object relational GIS if the extracted arc data type has an arc type and has a complex line property; A fifteenth step of converting the extracted spatial data in correspondence with a polygon type provided by the object relational GIS DBMS; And A fifteenth step of converting the extracted spatial data in correspondence with a rectangle type provided by the object relational GIS DBMS if the extracted spatial data is a rectangle; Drawing data conversion method comprising a. The method of claim 12, The DBMS for object relational GIS, Method for converting drawing data, characterized in that substantially GEUS. In a database management system for object relational geographic information system having a large processor, A first function of setting an initial environment by receiving a file name of the drawing data to be converted and a database name to be generated in a database management system (DBMS) for the object relational geographic information system (GIS); A second function of reading a drawing data file to be converted from beginning to end and defining attributes having a class and a spatial data type defined in the class in a database of the DBMS for object relational GIS; And A third function of reading the converted drawing data file again, extracting spatial data, converting the spatial data into a spatial data type provided by the object relational GIS DBMS, and storing the converted spatial data in a database of the object relational GIS DBMS; A computer-readable recording medium having recorded thereon a program for realizing this.