Design and Implementation of Yunnan Province Soil Environmental Quality Database Based on ArcSDE for Oracle

Abstract

The environmental quality monitoring work in Yunnan Province began in the 1970s. After 40 years of development, the Yunnan Province Environmental Monitoring System was initially established. However, the soil environmental monitoring data of the province lacks a unified warehousing standard, and a spatial database of soil environmental quality has not been established to integrate and standardize the data. Based on the research and reference to the relevant standards of soil database construction method and management at home and abroad, GeoDatabase is used as the spatial data model, and the conceptual model, logical organization model and storage model of Yunnan Province soil environmental quality database are designed by using Oracle and ArcSDE technologies. In order to accurately reflect the spatial location of the soil sampling points and the characteristic properties of the samples, and to ensure the uniqueness and rationality of the primary key in the data table, this paper designs the coding of the soil environmental quality database. The construction of soil environmental quality database in Yunnan Province realized the seamless integration of spatial data and attribute data, and provided comprehensive and accurate basic data and scientific decision support for soil pollution prevention and soil ecological restoration in Yunnan Province.