Design And Realization Of Island's Spatial Database Based On Geodatabase And ArcEngine

The Islands of Shandong province were studied in the dissertation. According to the research, we got the islands'natural environment, resources and exploitation in different areas of Shandong province as a whole. Disposing and analyzing lots of data of islands which are achieved by fieldwork, we put forward the plan of utilizing Geodatabase data model to construct the Islands'Spatial Database of Shandong Province in order to organize and store islands'data. Furthermore, Using the ArcEngine which is the component of GIS software and program language, the dissertation has established Islands'Management System of Shandong Province.Shandong province is abundant in islands. On a whole, the islands of Shandong province own favorable geographic location and climatic conditions. The types of islands include rocky islands, sandy islands and man-made islands. However, most of islands are rocky islands. Sandy islands are distributed in Binzhou and Changyi areas which belong to the north of the Huanghe (Yellow River) delta. The islands'of Shandong province possess of plenty of fishery resources, aquatic resources, tourism resources, land resources, port resources, shell sand resources and so on. Depending on the resource superiority, the islands'exploitation focuses on breed aquatics, tourism, port construction and the like.Geodatabase data model can effectively define and organize spatial data, and the technology of ArcSDE provides the gateway that allows spatial data to store in a commercial relationship database. Therefore, it is possible that Geodatabase data model and ArcSDE together make spatial data and attribute data storing in the same large relationship database. The dissertation adopted Geodatabase data model, ArcSDE and SQL Server database in order to design a model which could store and manage islands'data together and construct the islands'spatial database after deposing data and importing them in a relationship database.The islands'management system of Shandong province was based on the component of GIS software (ArcEngine) and program language (vb.net). The system could connect with islands'data and add them, show and manipulate islands'map, use many ways to query islands'data, measure the geometric values on the map, integrate and synthetically analyze islands'data. In addition, the system could provide some functions about labeling layer, arranging the color of layer, moving and deleting layer. The islands'management system of Shandong province provided a useful platform for island's exploitation and management of Shandong province as well as served the decision-marking section.