• Search Research Projects
  • Search Researchers
  • How to Use
  1. Back to previous page

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

Research Project

Project/Area Number 14550543
Research Category

Grant-in-Aid for Scientific Research (C)

Allocation TypeSingle-year Grants
Section一般
Research Field Civil and environmental engineering
Research InstitutionKyoto University

Principal Investigator

FUJII Shigeo  Kyoto Univ., School of Engineering, Professor, 工学研究科, 教授 (10135535)

Co-Investigator(Kenkyū-buntansha) NAGARE Hideki  Kyoto Univ., School of Engineering, Lecturer, 工学研究科, 講師 (60359776)
SHIMIZU Yoshihisa  Kyoto Univ., School of Engineering, Associate Professor, 工学研究科, 助教授 (20226260)
TSUNO Hiroshi  Kyoto Univ., School of Engineering, Professor, 工学研究科, 教授 (40026315)
岸本 直之  京都大学, 工学研究科, 講師 (00293895)
Project Period (FY) 2002 – 2003
Project Status Completed (Fiscal Year 2003)
Budget Amount *help
¥3,500,000 (Direct Cost: ¥3,500,000)
Fiscal Year 2003: ¥1,400,000 (Direct Cost: ¥1,400,000)
Fiscal Year 2002: ¥2,100,000 (Direct Cost: ¥2,100,000)
KeywordsDatabase / lakes / water quality / Access / monitoring / water quality surveys / Lake Biwa / relationships
Research Abstract

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.

Report

(3 results)
  • 2003 Annual Research Report   Final Research Report Summary
  • 2002 Annual Research Report
  • Research Products

    (10 results)

All Other

All Publications (10 results)

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

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 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)

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 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)

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 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)

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 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)

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 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)

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2003 Final Research Report Summary
  • [Publications] 藤井滋穂, Suwanna KITPATI: "アクセスVBAによる琵琶湖水質データ活用システムの開発"日本水環境学会年会講演集. 38巻. 297 (2004)

    • Related Report
      2003 Annual Research Report
  • [Publications] 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 Environmen. Vol.1. 502-510 (2003)

    • Related Report
      2003 Annual Research Report
  • [Publications] 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)

    • Related Report
      2003 Annual Research Report
  • [Publications] 藤井滋穂, 永礼英明, 宗宮功: "琵琶湖水質データベースの構築とその活用システムの開発"日本水環境学会年会講演集. 37巻. 247 (2003)

    • Related Report
      2002 Annual Research Report

URL: 

Published: 2002-04-01   Modified: 2016-04-21  

Information User Guide FAQ News Terms of Use Attribution of KAKENHI

Powered by NII kakenhi