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

International Conference on Manufacturing Technology, Materials and Chemical Engineering

材料科学;化学工业

Zhao, Yi^1 ; Liang, Hong^1 ; Zhou, Ningshan^1 ; Zhao, Juan^2 ; Zhang, Yuxia^2 ; Peng, Yinxia^2

College of Information Science and Engineering, Yunnan University, Kunming

650500, China^1

Yunnan Environmental Monitoring Center, Kunming

650034, China^2

关键词: Characteristic properties;    Design and implementations;    Ecological restoration;    Environmental Monitoring;    Environmental monitoring system;    Environmental quality;    Scientific decisions;    Seamless integration;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/592/1/012194/pdf
DOI  :  10.1088/1757-899X/592/1/012194

学科分类：材料科学（综合）

来源: IOP

【 摘 要 】

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.