KR100321773B1 - Method of converting spatial data to postscript format in spatial database system - Google Patents

Abstract

1. TECHNICAL FIELD OF THE INVENTION

The present invention relates to a method of converting spatial data into a PostScript format in a spatial database system and a computer-readable recording medium having recorded thereon a program for realizing the same.

2. The technical problem to be solved by the invention

The present invention provides a method and method for converting spatial information of a spatial database system into a PostScript format that can be used on any operating system and supported by almost all printers, with an emphasis on efficient use of data for use in various applications. To provide a computer-readable recording medium that records a program for the purpose.

3. Summary of Solution to Invention

The present invention provides a method for converting spatial data in a database management system, comprising: a first step of receiving desired spatial information and output information from an input device; A second step of setting an output format in a PostScript file format using the received output information; Extracting, from a spatial database, a class or spatial data associated with the class included in the input spatial information; And analyzing all spatial data types of the class object with respect to the extracted spatial data, and converting the spatial data into the PostScript file format according to the analysis result.

4. Important uses of the invention

The present invention is used in a database management system and the like.

Description

How to convert spatial data to postscript format in spatial database system}

The present invention records a method for converting spatial data into PostScript format by converting spatial information into PostScript format focused on efficient use of data in a spatial database system and generating a drawing for output, and a program for realizing the same. The present invention relates to a computer-readable recording medium.

Conventionally, when processing spatial information in a spatial database system, different output functions have been shown according to system characteristics such as characteristics, accuracy, ease of use, and water solubility. In addition, when outputting spatial information, it is shown in the form of a map, a table according to attributes, or a file or report.

Therefore, it is difficult to output in different systems, and it is difficult to extract and output only desired spatial information from a spatial database for various applications.

SUMMARY OF THE INVENTION The present invention has been proposed to solve the above-mentioned problems. The present invention provides spatial information of a spatial database system so that it can be used in various applications, and can be used in any operating system with an emphasis on efficient use of data. The aim is to provide a computer-readable recording medium that records a program for converting to a PostScript format that can be supported by.

1 is an exemplary hardware configuration of a medium class computer to which the present invention is applied.

2 is a schematic structural diagram of a process of converting spatial data into a PostScript file in a spatial database system according to the present invention;

3 is a flow diagram of one embodiment of a method of converting a PostScript file using spatial data in a spatial database system in accordance with the present invention.

* Explanation of symbols for the main parts of the drawings

101: central processing unit (CPU) 102: main memory (memory)

103: auxiliary storage device 104: output device

105: input device

According to an aspect of the present invention, there is provided a method of converting spatial data in a database management system, comprising: a first step of receiving desired spatial information and output information from an input device; A second step of setting an output format in a PostScript file format using the received output information; Extracting, from a spatial database, a class or spatial data associated with the class included in the input spatial information; And a fourth step of analyzing all spatial data types of the class object with respect to the extracted spatial data and converting the corresponding spatial data into the PostScript file format according to the analysis result. .

The present invention also provides a database management system having a processor, comprising: a first function of receiving desired spatial information and output information from an input device; A second function of setting an output format in a PostScript file format using the received output information; A third function of extracting a spatial data related to a class or a class included in the input spatial information from a spatial database; And a program for analyzing all spatial data types of the class object with respect to the extracted spatial data and converting the spatial data into the PostScript file format according to the analysis result. It provides a recording medium that can be read by.

First, briefly look at the concept to help the understanding of the present invention.

The geographic information system manages the graphic elements of spatial objects including geographic attributes and their attributes as if they were processed by the database system, and presented graphical screens to the users so that they could be utilized for database design, input and output, and analysis. Support integrated system.

Geographic information system provides four functions such as data input, data processing, data manipulation and analysis, and data output to process spatial information. Dual output capabilities vary from system to system depending on characteristics, accuracy, ease of use and acceptability. It can be displayed in the form of a table, file, or report such as a map or property.

The present invention is a spatial database of various drawings and facilities management fields such as road, communication, power, gas, water and sewage, railway, airport, harbor, and various geographic information applications such as city planning, water resource management, land management, defense, firefighting, etc. You can create a drawing for outputting the spatial information you want, and in particular, set the output paper options, database area, class, and annotations as desired so that you can selectively print only the desired terrain for the required part. I would like to present.

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.

In the embodiment of the present invention, the spatial database uses a database provided by GEUS, which is a database management system (DBMS) for an object relational geographic information system (GIS).

1 is an exemplary hardware configuration of a medium class computer to which the present invention is applied.

As shown in FIG. 1, the process of converting spatial data into a PostScript format in the spatial database system is recorded in the main memory device 102 and executed by the central processing unit 101 according to the flow of control. . 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 structural diagram of a process of converting a PostScript file using spatial data in a spatial database system according to the present invention.

As shown in FIG. 2, after the program is uploaded from the auxiliary memory device 103 to the main memory device 102, when the operation is started by the CPU 101, output information and spatial information are received from the input module 201. Receive input. The output information is paper type, paper size, margin period, size of area to be drawn on paper, map title, legend area, etc. Spatial information includes database name, database area to be drawn, names of classes to be selected, and comments about selected class. Whether it is set or not. Check that the output and space information is entered correctly, and set the paper type, paper size, and margin period in the PostScript file by referring to the output information.

Here, the spatial database refers to a database that processes and manages graphic elements of spatial objects including geographic attributes and attribute information thereof according to general data, and the spatial database system includes an environment, a city, a communication facility field and a defense field. It is a system widely used for facility management and planning in various fields such as development, civil engineering, water resources, transportation, and statistics.

Subsequently, the database input from the spatial information is accessed to check whether the desired class exists, and if the desired class exists, the extraction module 202 extracts instances for the class. At this time, not all instances related to the class are imported, but only instances that are satisfied in consideration of the topological relationship. In the spatial database, there are operators that represent the following topological relationships:

Disjoint: two spatial objects are separated from each other

Touch: Two spatial objects are in contact with each other

Overlap: Two spatial objects in a line or area have overlapping parts

Equal: Two spatial objects have the same shape and identical components

Match: Two spatial objects have the same shape and different components

Cross: Two objects cross each other

Cover: One spatial object contains another spatial object (when bounding)

Covered: One spatial object is included in another (when bounding)

Contain: One spatial object contains another spatial object (unless bounds meet)

Contained: One spatial object is contained in another (unbounded)

On the other hand, in order to examine the phase relationship with the input database area for the class included in the spatial information input by the extraction module 202, the instances satisfying each of the following conditions are extracted.

First, it finds an instance of a class that satisfies by checking whether the database area entered for all spatial data types of the class object is a containment without encountering a boundary with the class object.

Second, if the spatial data type of the class object is a point, it checks whether the input database area is in touch with the class object and obtains an instance of a satisfied class.

Third, if the spatial data type of the class object is any type other than a point, it checks whether the input database area covers the class object and includes a boundary to find an instance of a satisfied class.

Fourth, if the spatial data type of the class object is a simpleline or polyline, it checks whether the input database area crosses the class object and obtains an instance of a satisfied class.

Fifth, if the class object type is circle, rectangle, or polygon, it checks whether the input database area overlaps with the class object and checks whether it is an overlapping class instance. Obtain

The conversion module 203 converts the extracted instances from the extraction module 202 into PostScript format for the instances satisfying the condition.

Spatial data types provided by a spatial database may generally have a point, a simple line, a polyline, a polygon, a circle, a rectangle, and the like.

Here, the spatial data refers to data corresponding to the spatial data type provided by the spatial database. For example, the point is composed of x coordinates and y coordinates, and (10, 15), (200, 300), and the like are spatial data. The remaining spatial data types are also defined to represent their characteristics, and data can be generated accordingly.

The extraction module 202 converts the instance having the point object into a PostScript format by using a moveto command to move the coordinates provided by PostScript to a desired location and using the arc to draw the point. For instances with simple line objects, use the moveto command to move the coordinates provided by PostScript to go to the desired location and convert it to PostScript format using the lineto command. For instances with compound line objects, use the moveto command to move the coordinates provided by PostScript to the desired location and use the lineto to draw multiple lines to convert to PostScript format.

For instances with polygon objects, use Post to move the coordinates in PostScript (moveto) to the desired location and use Lineto to draw multiple lines, convert them to PostScript format, and A color fill command is used to indicate the color that represents the interior of the polygon. For instances with original objects, use the moveto command to move the coordinates in PostScript to the desired location and use the arc command to draw the points, convert them to PostScript format, and color the interior of the spatial object if necessary. Use the fill command to indicate the color of the interior of the circle. For instances with rectangular objects, use Post to move the coordinates in PostScript (moveto) to the desired location and use Lineto to draw multiple lines, convert them to PostScript format and, if necessary, convert the interior of the spatial object. A color fill command is used to indicate the color that represents the interior of the polygon.

In this case, a command (setrgbcolor) for setting the color of the spatial object is used to express the color of each spatial object, and a command (setlinewidth) for setting the thickness of the spatial object is used to indicate the thickness of each object. The above operation extracts the instances in the desired database area for a class in the spatial input.

3 is a flowchart illustrating an embodiment of a method of converting a PostScript file using spatial data in a spatial database system according to the present invention.

Receives output information and space information from the input module 201, checks that the output information and space information are correctly input (301), and sets the PostScript file for the paper type, the paper size, and the margin period by referring to the output information. (302).

After setting up the PostScript file (302), the database input from the spatial information is accessed to check whether the desired class exists (303), and if the desired class exists, the extraction module (202) extracts an instance for the class. 304. At this time, not all instances related to the class are imported, but only instances that are satisfied in consideration of the topological relationship.

The instances that satisfy the condition for the imported class are converted to PostScript format (305). Checks if there are other classes shown in the output information (306), extracts instances for the classes (304), and converts them to PostScript format (305) for the instances that meet the conditions, You can get the instances in the desired database area for the clad and convert them to PostScript format.

The method of the present invention as described above may be implemented as a program and stored in a computer-readable recording medium (CD-ROM, RAM, ROM, floppy disk, hard disk, magneto-optical disk, etc.).

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 is applicable to various drawings and roads, communication, electric power, gas, water and sewage, railway, airport, port, facility management field and city planning, water resource management, land management, national defense, firefighting, etc. You can create a drawing for output with the spatial data you want for the spatial database of the field. In particular, you can selectively print only the desired terrain for the required part by setting the output paper options, database area, class, and annotations as desired. It has an effect.

Claims (6)

In a method of transforming spatial data in a database management system, A first step of receiving desired spatial information and output information from an input device; A second step of setting an output format in a PostScript file format using the received output information; Extracting, from a spatial database, a class or spatial data associated with the class included in the input spatial information; And A fourth step of analyzing all spatial data types of the class object with respect to the extracted spatial data and converting the spatial data into the PostScript file format according to the analysis result; How to convert spatial data containing to PostScript format. The method of claim 1, The spatial database, Spatial data in PostScript format, which provides spatial data types such as points, simple lines, polylines, polygons, circles, and rectangles. How to convert. The method of claim 2, The spatial data is, Characterized by the characteristics of spatial data types such as points, simple lines, polylines, polygons, circles, and rectangles provided by the spatial database. To convert spatial data into PostScript format. The method according to any one of claims 1 to 3, The third step, A fourth step of obtaining an instance of a class that satisfies whether the input database area includes all the spatial data types of the class object without including a boundary with the class object; A fifth step of obtaining an instance of a satisfied class by checking whether the input database area is in touch with the class object when the spatial data type of the class object is a point; If the spatial data type of the class object is a type other than a point, a sixth step of obtaining an instance of a class that satisfies by examining whether the input database area includes a boundary that meets the class object and includes a boundary; The seventh step of obtaining an instance of a satisfied class by checking whether the input database area crosses the class object when the spatial data type of the class object is a simple line or a polyline. ; And When the class object type is circle, rectangle, or polygon, it checks whether the input database area is overlapping with the class object to find an instance of the satisfied class. 8th step How to convert spatial data containing to PostScript format. The method of claim 4, wherein The fourth step, A ninth step of analyzing a type of a spatial data type of a class object with respect to the extracted spatial data; A tenth step of converting coordinates provided by PostScript into a command for drawing a point and a command for drawing a point when the spatial data type of the class object is Point; An eleventh step of converting coordinates provided by PostScript into a command for drawing a line and a command for drawing a line when the spatial data type of the class object is a simple line as a result of the analysis of the ninth step; A twelfth step of converting the coordinates by converting the coordinates into a command for moving coordinates and a command for drawing a plurality of lines when the spatial data type of the class object is a polyline; As a result of the analysis of the ninth step, when the spatial data type of the class object is a polygon, a command for shifting coordinates provided by PostScript, a command for drawing multiple lines, and an interior of the spatial object, if necessary A thirteenth step of converting by converting the image into a color filling instruction; As a result of the analysis of the ninth step, when the spatial data type of the class object is a circle, a command for moving the coordinates provided by PostScript, a command for drawing a point, and a color of the interior of the spatial object, if necessary A fourteenth step corresponding to and converted into a command filled with a; And As a result of the analysis of the ninth step, when the spatial data type of the class object is a rectangle, a command for shifting coordinates provided by PostScript, a command for drawing multiple lines, and an interior of the spatial object, if necessary The fifteenth step of converting by matching How to convert spatial data containing to PostScript format. In a database management system having a processor, A first function of receiving desired spatial information and output information from an input device; A second function of setting an output format in a PostScript file format using the received output information; A third function of extracting a spatial data related to a class or a class included in the input spatial information from a spatial database; And A fourth function of analyzing all spatial data types of the class object with respect to the extracted spatial data and converting the spatial data into the PostScript file format according to the analysis result A computer-readable recording medium having recorded thereon a program for realizing this.