KR101026107B1 - Inspection System and Method for River Information Management Geographic Information System - Google Patents

Abstract

The present invention relates to a river geographic information inspection system and method, and an object of the present invention is to provide a river geographic information inspection system and method for inspecting the standardized information obtained by the river management geographic information system (RIMGIS) from the linkage system .

River geographic information inspection system according to the present invention, the river integrated database 100 is implemented as a data warehouse structure and stored river information metadata and standardized river information; It is connected to the river integrated database 100 to manage stream information metadata, collect and standardize river information stored in at least one or more of the following linkage system 500, and store in the stream integrated database 100, search and A river management server 200 for extracting and processing information corresponding to the request from the spatial information and the attribute information stored in the river integrated database 100 in response to the inquiry request; A management system 300 connected to the river integrated database 100 to input, modify, search, search and manage river information; A web server 400 connected to the river integrated database 100; At least one linkage system (500) connected to the stream integration database (100) or directly through the web server (400); A client (600) connected to a wired / wireless network including the web server (400) and the Internet to search and search river information through the web server (400); The stream management geographic information system, characterized in that comprises a, river information obtained from at least one or more of the linkage system 500 and converted into a spatial information and attribute information by schema comparison based on the mapping table, It is characterized by inspecting according to the characteristics of spatial information and attribute information, and reporting and correcting errors that occur during conversion construction.

River Information, Data Warehouse, Spatial Information, Attribute Information, Linkage System, Inspection, Error

Description

River Geographic Information Inspection System and Method {Inspection System and Method for River Information Management Geographic Information System}

The present invention relates to a river geographic information inspection system and method for inspecting the standardized information acquired by the river management geographic information system (RIMGIS) from the linkage system.

Conventionally, comprehensive management of rivers has not been achieved because national and local first and second-class rivers are managed separately from national and local authorities. For example, some of the river services performed by local governments are targeted to local 1,2 grade rivers, but it is difficult to maximize utilization and share information due to the lack of computerization and sharing system related to local rivers. In addition, some local governments are planning to build a separate system and a database related to rivers for river management, which may cause problems in the future of system integration and information sharing system. In addition, most local governments handle river business by paper book managers and manpower, which causes many difficulties such as lack of computerization, lack of information sharing system, and duplication of work. Accordingly, in order to establish a systematic management system of rivers, the establishment of an integrated information provision system of national and local rivers should be preceded, and the necessity of organic business linkage and information sharing system through local and local government river support is required.

In addition, the river management task is a subordinate concept included in the water resource management task, and it is natural that the river management system should operate smoothly in connection with the integrated water resource management system. However, as mentioned above, the current river management work does not even integrate the work between the state and the province, and there are still some areas where the computerization of the work is not carried out. Figures 1a to 1e is a table showing the current state of river computerization of each municipality, as shown in Figures 1a to 1e, each of the development agencies, developers, infrastructure, etc. of the river management system of each local government . As such, it is possible to construct a linkage with a higher system, the National Water Resources Management System (WAMIS), and to link several sub-systems that have been developed or will be developed. System is desperately needed.

In addition, as described above, since the national river service and the local river service were operated separately, both the work system and the information system were different. In particular, this has resulted in the inability to integrate more. In addition, there has been a problem that management costs increase due to such inconsistency of work system and information system.

In order to overcome these problems, river management geographic information system (RIMGIS) has been developed and operated. FIG. 2 is a schematic system diagram of a river management geographic information system (RIMGIS) 1000. As shown, the river management geographic information system 1000 includes a river integrated database 100 that is implemented in a data warehouse structure and stores river information metadata and standardized river information; It is connected to the river integrated database 100 to manage stream information metadata, collect and standardize river information stored in at least one or more of the following linkage system 500, and store in the stream integrated database 100, search and A river management server 200 for extracting and processing information corresponding to the request from the spatial information and the attribute information stored in the river integrated database 100 in response to the inquiry request; A management system 300 connected to the river integrated database 100 to input, modify, search, search and manage river information; A web server 400 connected to the river integrated database 100; At least one linkage system (500) connected to the stream integration database (100) or directly through the web server (400); A client (600) connected to a wired / wireless network including the web server (400) and the Internet to search and search river information through the web server (400); It is made, including.

The stream management geographic information system 1000 is implemented in a data warehouse structure in which the stream integrated database 100 is operable in association with a plurality of local systems, and uses metadata, that is, data that describes data. Data obtained from the system is standardized and stored. A data warehouse is a database that is kept separate from an organization's operational database, so a data warehouse system is ready for integration with a variety of application systems and provides a solid platform for merged historical data for analysis. By helping to process information. Accordingly, the river management geographic information system enables integrated management of data stored in the local system.

However, the possibility of an error occurring in the standardization process of the data cannot be excluded, and if an error occurs in the standardization process, there is a problem that a malfunction occurs in the stream management geographic information system managing information. Therefore, it has been pointed out that in the process of standardizing data, not only the data standardization but also the process of inspecting the standardized data is required.

Accordingly, the present invention has been made to solve the problems of the prior art as described above, the object of the present invention is to examine the river geographic information that the river management geographic information system (RIMGIS) obtained from the linkage system to inspect the standardized information A system and method are provided.

River geographic information inspection system according to the present invention for achieving the object as described above, the river integrated database 100 is implemented as a data warehouse structure and stored stream information metadata and standardized river information; It is connected to the river integrated database 100 to manage stream information metadata, collect and standardize river information stored in at least one or more of the following linkage system 500, and store in the stream integrated database 100, search and A river management server 200 for extracting and processing information corresponding to the request from the spatial information and the attribute information stored in the river integrated database 100 in response to the inquiry request; A management system 300 connected to the river integrated database 100 to input, modify, search, search and manage river information; A web server 400 connected to the river integrated database 100; At least one linkage system (500) connected to the stream integration database (100) or directly through the web server (400); A client (600) connected to a wired / wireless network including the web server (400) and the Internet to search and search river information through the web server (400); The stream management geographic information system, characterized in that comprises a, river information obtained from at least one or more of the linkage system 500 and converted into a spatial information and attribute information by schema comparison based on the mapping table, It is characterized by inspecting according to the characteristics of spatial information and attribute information, and reporting and correcting errors that occur during conversion construction.

At this time, the river management integrated information inspection system is implemented in the form of software which is provided independently of the river management geographic information system 1000 and embedded in the computing processing means including a computer, or the river management geographic information system 1000 It is characterized in that it is implemented in the form of software embedded in the management system 300 or the river management server (200).

In addition, the stream geographic information inspection system includes a file menu, a spatial data inspection sub-menu, an attribute data inspection sub-menu, and matching verification including a server connection setting submenu, inspection data setting submenu, printing submenu, and ending submenu. Data including a data inspection menu comprising a sub menu, a data upload subdivision for managing data upload by dividing spatial information and attribute information, and a data download submenu for managing data download by dividing spatial information and attribute information. And a history management menu including a management menu, a metadata menu including a metadata management submenu, and a history information viewing submenu.

In addition, the river geographic information inspection method of the present invention, in the inspection method by the river geographic information inspection system, a) river information obtained from the at least one associated system 500 by the river geographic information inspection system is space Classified into information and attribute information; b) performing a table structure inspection on each of the spatial information and the attribute information by the river geographic information inspection system; c) performing data inspection on each of the spatial information and attribute information for which the table structure inspection is completed by the river geographic information inspection system; d) performing spatial error checking on spatial information on which data inspection is completed by the river geographic information inspection system; (e) performing matching verification on the spatial information on which the spatial error check is completed and on the attribute information on which the data check is completed by the stream geographic information inspection system; f) uploading and storing the spatial information and attribute information of the matching verification completed by the river geographic information inspection system to the river integrated database 100 of the river management geographic information system 1000; Characterized in that comprises a.

In addition, the river geographic information inspection method, if an error is found in the steps b) to e) is characterized in that the error file is classified and stored as an error file, and lists the error details and outputs. At this time, the river geographic information inspection system repeats the steps b) to e) until no error is found, and performs step f) if no error is found.

In addition, the river geographic information inspection method is a field name, field type, each field that each table has so as to check whether the table having the spatial information and the attribute information match the structure of the river integrated database 100 in step b) Comparing the inspection items including the field size is carried out and the error is detected.

At this time, the river geographic information inspection method is characterized in that the error is checked on the basis of the spatial information layer ID list described in the table below in step b).

In addition, the river geographic information inspection method is characterized in that the step of checking the error on the basis of the attribute information table ID list described in the table below in step b).

In addition, the stream geographic information inspection method is a stream code (R_STREAM) and the classification code to check whether the data in the table having the spatial information and the attribute information in step c) was prepared in accordance with the standard of the river integrated database 100 It is characterized by checking whether the code values including (F_CODE) are valid and detecting an error.

In addition, the river geographic information inspection method is characterized in that for detecting the validity of the logical and physical spatial information in step d), the error of disconnection, intersection or overlapping for spatial information constructed of lines and polygons is detected. .

In addition, the stream geographic information inspection method is characterized in that comparing the spatial information and the attribute information whether there is attribute information to match if there is spatial information to have the attribute information in step e).

According to the present invention, the river management geographic information system can be easily accessed from the river management geographic information system by accurately standardizing the information regardless of which system the river management geographic information system is linked to, so that the river management geographic information system can operate more efficiently and accurately. Giving effect.

Particularly, according to the present invention, when an error occurs, the error information is reported and the file having the error is classified separately so that the error can be corrected much more easily. It has the effect of making it possible.

Hereinafter, a river geographic information inspection system and method according to the present invention having the configuration as described above will be described in detail with reference to the accompanying drawings.

The river geographic information inspection system of the present invention is used in connection with the river management geographic information system 1000 as described above. Therefore, the inspection system of the present invention may be implemented independently of the river management geographic information system 1000 and may be implemented in the form of software embedded in an operation processing means including a computer, or the river management geographic information system 1000. It may be implemented in the form of software embedded in the management system 300 or the river management server 200.

The river management geographic information system (RIMGIS) 1000, which standardizes spatial information and attribute information, is connected to at least one associated system 500 and standardized information related to rivers stored in the associated system 500. Converted to and stored in the river integrated database 100. In this case, when an error occurs in the conversion process as described above, there is a problem that the river management geographic information system 1000 becomes difficult to manage information integrally. The stream geographic information inspection system of the present invention has a function of inspecting the converted data to determine or repair an error to solve such a problem.

FIG. 3 is a flowchart of transforming and inspecting linked data, in which a space and attribute information linked from a linked system 500 such as a local government can be constructed in a stream integrated database 100 of the stream management geographic information system 1000. It is automatically converted and stored, and at this time, the river geographic information inspection system of the present invention reports and corrects the errors for the conversion.

The river management geographic information system 1000 can be efficiently transformed to build an information sharing system for local governments (ie, the linkage system 500), and also considering that there is a different database structure for each municipality, The conversion is performed by defining the conversion method for each property information and configuring the mapping table in which the target data is defined. The mapping table defines the rules and methods for the type conversion of the spatial layer, the conversion of attribute information, and the automatic and manual conversions to enable simultaneous management. In other words, in order to establish a smooth conversion system of a local river DB, a common conversion engine is adopted that compares schema information transmitted with local stream information based on a mapping table and effectively converts each spatial and attribute information. The conversion is performed by assigning the conversion priority according to the characteristics of.

4 illustrates a process of constructing a river integrated database, and illustrates a process of converting and inspecting river information. In the case of converting the information of the linkage system 500 according to the guidelines of the river management geographic information system 1000, the standardization work is not necessary, but in the case of the linkage system 500 that is not, standardization work is performed. However, since there is a possibility that an error is included in the data on which the standardization is completed, there is a possibility that a problem such as malfunctioning occurs when the converted data is immediately stored in the river integrated database. Therefore, the data is inspected using the river geographic information inspection system according to the present invention. As shown in FIG. 4, the data inspection is performed by the stream geographic information inspection system of the present invention, and if there is an error, the correction is completed and the inspection is completed or the re-inspection is performed. Through such a process, the inspection is completed and the data whose integrity is determined is uploaded and stored in the river integrated database 100 of the river management geographic information system 1000.

5 illustrates a river information inspection process, FIG. 6 is an embodiment of a spatial information item, and FIGS. 7A and 7B are an embodiment of an attribute information item. This will be described in more detail the inspection process.

① Table structure inspection: In table structure inspection, it checks whether the tables of spatial data and attribute data match the structure of RIMGIS database. Error is detected by comparing and checking the field name, field type, and field size of the table.

② Data inspection: In data inspection, it checks whether the data in the table of spatial and attribute data are prepared in accordance with the standard of RIMGIS database. It checks whether the river code (R_STREAM) and the classification code (F_CODE) and other code values are valid and detects an error.

③ Spatial Error Checking: Spatial error checking is the process of checking whether there is an error about disconnection, intersection or overlapping of spatial data constructed from lines and polygons. The banks or banks can verify the validity of the logical and physical spatial data of the river database because each data cannot intersect other banks or banks, and the map data such as topographic maps cannot overlap. 8A to 8C illustrate a process of validating spatial information. FIG. 8A is a process of inspecting an intersection error, and as shown, an error in which lines cross each other in a spatial layer such as a river center line is inspected. FIG. 8B is a process of checking for a disconnection error, and as shown in FIG. FIG. 8C is a process of inspecting an overlapping error, and as one of the spatial error checks for surface data, as illustrated, an error in which spatial layers such as intellectual and river areas overlap each other is examined.

④ Matching verification: Matching verification is the process of comparing the spatial data and the attribute data to see if there is matching attribute information when there is spatial data that should have the attribute information. 9 shows a process of checking errors (table structure, field type, data validity, etc.) for attribute data as described above.

The river geographic information inspection system of the present invention classifies and stores a file in which an error occurs as an error file when an error is found, and lists and outputs an error so that the error can be easily corrected. After repeating the above process until no more error occurs, if no error occurs, upload and store the integrity-proven information to the river integrated database 100 of the river management geographic information system 1000. do. FIG. 10A illustrates a process of correcting an error occurring in a spatial layer, and FIG. 10B illustrates a process of correcting an error occurring in attribute information-an error.

The detailed inspection process of the river geographic information inspection system of the present invention will be described step by step.

FIG. 11A illustrates an embodiment of a main screen and a server setting screen output by the river geographic information inspection system according to the present invention. As shown in FIG. 11A (A), a menu and a toolbar are provided at the top of the screen. The main map screen is in the center, the index map and layer list window is on the left side of the map screen, and the data input window is on the right side. At the bottom of the screen is a status bar that shows the current coordinates and date. 11A (B) illustrates an embodiment of a server setting screen. The server selection, connection, and the like can be made by inputting a server name, an account, a password, and the like.

11B illustrates an example of a process of setting up inspection data, and setting up inspection data by selecting spatial data, attribute data, or rivers, and FIG. 11B (A) shows a inspection data setting window. (B) shows a spatial data selection window, FIG. 11B (C) shows an attribute data selection window, and FIG. 11B (D) shows a river selection window. Table 1 below describes a list of layer IDs of spatial information, which corresponds to the list of spatial information layer IDs of the stream integrated database 100 of the river management geographic information system 1000. In addition, Table 2 below describes a table ID list of attribute information, which also corresponds to the attribute information table ID list of the river integrated database 100 of the river management geographic information system 1000. 11C illustrates an embodiment of a verification data setting and verification process.

FIG. 11D illustrates an embodiment of a spatial information checking and error checking process, and FIG. 11E illustrates an embodiment of a spatial information error correcting process. As shown in (A) of FIG. 11D, inspection is automatically performed, and errors found in this process are listed and output as shown in (B) of FIG. 11D. The error generated in this way is selected from the list of (B) of FIG. 11D and can be corrected and edited. FIG. 11E (A) shows the step of checking the table structure (of spatial information) and correcting the error of FIG. (B) shows the data checking and error correcting step (of spatial information) of FIG. 5, and (C) of FIG. 11E shows the spatial error checking and error correcting process (of spatial information) of FIG. 5, respectively.

11F illustrates an embodiment of a process of inspecting and verifying attribute information. As in the spatial information inspection process, inspection is automatically performed as shown in FIG. 11F (A), and errors found in this process are listed and output as shown in FIG. 11F (B). The error generated in this way is selected from the list of (B) of FIG. 11F, and can be corrected and edited. The table structure (of attribute information) inspection and error correction step of FIG. 5 and the data (of attribute information) of FIG. And the error correction step is performed in the same manner as in (A) and (B) of FIG. 11E.

FIG. 11G illustrates an example of a matching verification process, in which FIG. 11G illustrates a matching verification screen, and FIG. 11G illustrates a screen during a matching verification process.

In this way, the data completed until the error correction and matching verification is finally uploaded to the stream integration database (100). 11H illustrates a screen for uploading data as an example of a data upload process.

FIG. 11I illustrates an example of a printing screen, in which a preview screen is provided to increase convenience in printing. FIG. 11J illustrates an example of a metadata management screen, which is configured to manage each metadata by dividing it into layer information, river information, and server information as shown. FIG. 11K illustrates an example of a history information view screen, which provides a search by period and a search by format (space / attribute) as shown.

12 illustrates an embodiment of a menu configuration when implementing the stream geographic information inspection system of the present invention. As shown in FIG. 12, the river geographic information inspection system of the present invention includes a file menu including a server connection setting submenu, a inspection data setting submenu, a printing submenu, and an ending submenu, and a spatial data inspection submenu. , Data inspection submenu including attribute data inspection submenu and matching verification submenu, data upload submenu which manages data upload by dividing spatial information and attribute information, and manages data download by dividing spatial information and attribute information A data management menu including a data download submenu, a metadata menu including a metadata management submenu, and a history management menu including a history information viewing submenu may be implemented. 12, the system may further include a help menu including a system information submenu for providing system information and a help view submenu for providing help. When the system of the present invention is actually implemented as in this embodiment, each submenu and menu are preferably named so as to intuitively know that the various operations described above are performed.

The form of the menu system as described above is only one specific embodiment, and of course, the present invention is not limited thereto.

13A to 13J show an embodiment of a class diagram of the river geographic information inspection system of the present invention. FIG. 13A shows the overall system model, which is composed of a class module implementing data input forms and functions (specialized in the river geographic inspection system of the present invention) and a user control implementing a progress display function. FIG. 13B is a form configuration model of the system, FIG. 13C is a spatial information inspection model, FIG. 13D is an attribute information inspection model, FIG. 13E is a spatial information upload model, FIG. 13F is an attribute information upload model, FIG. 13G is a spatial information download model, FIG. 13H shows an attribute information download model, FIG. 13I shows a metadata management model, and FIG. 13J shows an embodiment of a history management model.

The present invention is not limited to the above-described embodiments, and the scope of application of the present invention is not limited to those of ordinary skill in the art to which the present invention pertains without departing from the gist of the present invention as claimed in the claims. Of course, various modifications can be made.

1a to 1e is a river computerization status of each municipality.

2 is a system structure of RIMGIS.

3 is a flow chart for constructing and verifying transformed data.

4 is a river integrated database construction work process.

5 is a river information inspection process.

6 is an embodiment of a spatial information item.

7A and 7B illustrate one embodiment of attribute information items.

8a to 8c is a spatial information inspection process.

9 is an attribute information inspection process.

10A and 10B show an error correction process.

Figure 11a is an embodiment of a main screen and a server setting screen output by the river geographic information inspection system of the present invention.

11B is an embodiment of a screen for setting inspection data;

Figure 11c is an embodiment of a process for setting and verifying the verification data.

11d illustrates an embodiment of a process of checking spatial information and checking an error;

11E illustrates an embodiment of a spatial information error correction process.

11F is an embodiment of a process of checking attribute information and checking an error;

11G illustrates one embodiment of a matching verification process.

11H illustrates one embodiment of a data upload process.

11I illustrates one embodiment of a print screen.

11J illustrates one embodiment of a metadata management screen.

11K is an embodiment of a history information view screen;

DESCRIPTION OF REFERENCE NUMERALS

1000: River Management Geographic Information System (RIMGIS)

100: River Integration Database

200: river management server

300: management system

400: web server

500: linked system

600: client

Claims (12)

delete delete delete A river integrated database 100 implemented with a data warehouse structure and storing river information metadata and standardized river information; It is connected to the river integrated database 100 to manage stream information metadata, collect and standardize river information stored in at least one or more of the following linkage system 500, and store in the stream integrated database 100, search and A river management server 200 for extracting and processing information corresponding to the request from the spatial information and the attribute information stored in the river integrated database 100 in response to the inquiry request; A management system 300 connected to the river integrated database 100 to input, modify, search, search and manage river information; A web server 400 connected to the river integrated database 100; At least one linkage system (500) connected to the stream integration database (100) or directly through the web server (400); A client (600) connected to a wired / wireless network including the web server (400) and the Internet to search and search river information through the web server (400); It is provided in the river management geographic information system comprising a, River information obtained from at least one or more of the linkage systems 500 and classified and converted into spatial information and attribute information by schema comparison based on a mapping table is inspected according to the characteristics of the spatial information and attribute information, In the inspection method by the river geographic information inspection system which reports and corrects an error, a) classifying river information obtained from at least one associated system 500 by the river geographic information inspection system into spatial information and attribute information; b) performing a table structure inspection on each of the spatial information and the attribute information by the river geographic information inspection system; c) performing data inspection on each of the spatial information and attribute information for which the table structure inspection is completed by the river geographic information inspection system; d) performing spatial error checking on spatial information on which data inspection is completed by the river geographic information inspection system; (e) performing matching verification on the spatial information on which the spatial error check is completed and on the attribute information on which the data check is completed by the stream geographic information inspection system; f) uploading and storing the spatial information and attribute information of the matching verification completed by the river geographic information inspection system to the river integrated database 100 of the river management geographic information system 1000; , ≪ / RTI > The river geographic information inspection method in step c) Inspect the code values including the stream code (R_STREAM) and the discrimination code (F_CODE) to check whether the data in the table having the spatial information and the attribute information have been prepared in accordance with the standards of the river integrated database 100, and make an error. River geographic information inspection method characterized in that for detecting. The method of claim 4, wherein the river geographic information inspection method is performed in steps b) to e). If an error is found, the error file is classified into an error file, stored, and the error list is output. The method of claim 5, wherein the river geographic information inspection method Repeat steps b) to e) until no errors are found; If no error is found, step f) is performed. The method of claim 4, wherein the river geographic information inspection method is performed in step b). In order to check whether the table having the spatial information and the attribute information matches the structure of the stream integrated database 100, the comparison inspection on the inspection item including the field name, field type, and field size of each table is performed. River geographic information inspection method characterized in that for detecting the error. The method of claim 7, wherein the river geographic information inspection method is performed in step b). River geographic information inspection method characterized in that the error is inspected based on the spatial information layer ID list described in the table below.

The method of claim 7, wherein the river geographic information inspection method is performed in step b). The river geographic information inspection method, characterized in that the error is inspected based on the attribute information table ID list described in the following table.

delete The method of claim 4, wherein the river geographic information inspection method is performed in step d). A method for inspecting river geographic information, comprising detecting errors in disconnection, intersection, or overlapping of spatial information constructed of lines and polygons so as to verify logical and physical spatial information validity. The method of claim 4, wherein the river geographic information inspection method is performed in step e). A method for inspecting river geographic information, comprising comparing spatial information and attribute information to determine whether there is attribute information that matches if spatial information that should have attribute information exists.

Images