SQL Server CE是应用于嵌入式移动设备的数据库产品。本文介绍了.NET Compact Framework下嵌入式移动数据库SQL Server CE的开发方法和SQLCE数据库在地下水资源调查野外采集系统中的应用,并利用Microsoft Sync Services for ADO.NET实现地下水资源调查野外数据采集系统中SQL Server CE 3.5与SQL Server 2005数据同步的解决方案。
根据地下水污染调查评价的工作需要,结合地下水污染调查内容和评价技术要求,使用SQL Server 2000建立了地下水污染调查数据库,利用VC++、MapGIS二次开发库和Delphi组件开发技术,设计开发了地下水污染调查信息系统。该系统实现了地下水污染调查数据的录入、管理、制图、质量评价、污染评价、统计、导出等功能。系统经过实际应用,在中国地质调查局系统建立了统一的地下水污染数据管理和信息平台,为地质勘查单位地下水污染调查数据管理和地下水污染评价提供了技术支撑。
Groundwater has been a major natural resource for human consumption in north China. It is necessary to appreciate the suitability of deep groundwater for drinking, agricultural irrigation, and industrial uses in this region. To this end, a total of 47 groundwater samples were collected from the study area; by comparing the concentrations of different hydrochemical variables with quality standard values, the variable fuzzy set (VFS) was applied to calculate the groundwater quality index (GQI) for various purposes, respectively. Afterward GQI spatial distribution maps were constructed using a geographic information system (GIS) tool to delineate spatial variations of groundwater quality. In this case study, the GQI spatial distribution maps reveal that the areas covered by "Maximum Permissible" groundwater for varying purposes (drinking, irrigation, and industrial) is 1377.2; 2354.7; and 3854.8 km2, respectively. The groundwater in the eastern part of the study area is suitable for drinking, with the southwestern region as the irrigation water source; the entire study area is acceptable for use in industrial, except the western part of Jiaozuo City. Therefore, the GQI spatial distribution maps can provide useful information for non-technical decision makers for better sustainable groundwater resources management.
