Study on Construction and utilization of a comprehensive lake water quality database system

湖泊水质综合数据库系统的建设与利用研究

• 批准号: 14550543
• 负责人: FUJII Shigeo
• 金额: $ 2.24万
• 依托单位: Kyoto University
• 依托单位国家: 日本
• 项目类别: Grant-in-Aid for Scientific Research (C)
• 财政年份: 2002
• 资助国家: 日本
• 起止时间: 2002 至 2003
• 项目状态: 已结题
• 来源: https://kaken.nii.ac.jp/grant/KAKENHI-PROJECT-14550543/
• 关键词: Database; lakes; water quality; Access; monitoring; water quality surveys; Lake Biwa; relationships

Monitoring is a fundamental step to understand water quality conditions in lakes, and many lakes have been storing a huge amount of water quality data. However, these past records are not effectively used. This research project aims to develop a new water quality database system, which possesses almost all data recorded in a target lake with functions to use them skillfully, and satisfies not only the general public, but also specialists. Lake Biwa was chosen as the research lake.Then, past and present investigation projects in Lake Biwa were surveyed and their water quality data were collected and analyzed.The results indicate these investigations have various and different patterns on their investigation methods; the number of sampling stations ranges 1 to 5, that of depths ranges 1 to 12, that of times in a year ranges 1 to 365, and that of measured items ranges 8 to 100 more. The whole projects identified 86 different sampling stations and 44 different depths in the lake. The variety of investigation methods suggested that simple spread sheet can not handle the whole data systematically, and that the use of a relational database application software is needed. Then, Access 2000 was introduced to organize all of the data.The constructed database consists of one main table, two sub-main tables and seven minor explanatory tables, and has stored 670,000 WQI data for 50,000 samples from 15 survey projects. Its application softwares were also developed with the help of VBA (Visual Basic for Application) for general users who are not familiar to Access. This system has high flexibility on the data management and application, so that further extension of the system can be easily achieved.

监测是了解湖泊水质状况的基础步骤，许多湖泊已经存储了海量的水质数据。然而，这些过去的记录并没有得到有效的利用。本研究项目旨在开发一种新的水质数据库系统，该系统拥有目标湖泊中记录的几乎所有数据，并具有巧妙使用这些数据的功能，不仅满足普通公众的需求，也满足专家的需求。以琵琶湖为研究对象，对琵琶湖过去和现在的调查项目进行了调查，并对其水质数据进行了收集和分析。结果表明，这些调查在调查方法上有不同的模式，采样点数量为1~5个，深度为1~12个，一年中的次数为1~365个，测量项目为8~100个。整个项目确定了86个不同的采样点和44个不同的湖水深度。调查方法的多样性表明，单纯的电子表格不能系统地处理全部数据，需要使用关系数据库应用软件。建立的数据库由1个主表、2个次主表和7个次要解说表组成，存储了15个调查项目5万个样本的67万份WQI数据。针对不熟悉Access的普通用户，利用VBA(Visual Basic For Application)开发了其应用软件。该系统在数据管理和应用上具有很高的灵活性，便于实现系统的进一步扩展。

项目成果

藤井滋穂, Suwanna KITPATI: "アクセスVBAによる琵琶湖水質データ活用システムの開発"日本水環境学会年会講演集. 38巻. 297 (2004)

Shigeho Fujii、Suwanna KITPATI：“使用 Access VBA 开发利用琵琶湖水质数据的系统”日本水环境协会年会论文集 38. 297 (2004)。

Suwanna Kitpati, Shigeo FUJII, Hideaki NAGARE, Yoshihisa SHIMIZU: "Development of a comprehensive water quality database system and its application in Lake Biwa"CD Proceedings of IWA Asia-Pacific Regional Conference. Vol.9. 1QHL15 (2003)

Suwanna Kitpati、Shigeo FUJII、Hideaki NAGARE、Yoshihisa SHIMIZU：“综合水质数据库系统的开发及其在琵琶湖中的应用”IWA 亚太地区会议 CD 论文集。

Shigeo FUJII, Suwanna KITPATI: "Development of a water quality data utilization system for Lake Biwa by means of Access VBA."Proc. of JSWE annual conf.. Vol.38. 297 (2004)

Shigeo FUJII、Suwanna KITPATI：“通过 Access VBA 开发琵琶湖水质数据利用系统。”Proc。

Shigeo FUJII, Suwanna Kitpati, Hideaki NAGARE: "System development of data organization and utilization For lake water quality"Proc. of International Symposium on Southeast Asia n Water Environment. Vol.1. 502-510 (2003)

Shigeo FUJII、Suwanna Kitpati、Hideaki NAGARE：“湖泊水质数据组织和利用的系统开发”Proc。

Shigeo FUJII, Suwanna Kitpati, Hideaki NAGARE: "System development of data organization and utilization for lake water quality"Proc.of International Symposium on Southeast Asian Water Environment. Vol.1. 502-510 (2003)

Shigeo FUJII、Suwanna Kitpati、Hideaki NAGARE：“湖泊水质数据组织和利用的系统开发”东南亚水环境国际研讨会论文集。