圖書典藏及影音數位平台

水不但是人類賴以維生的必需品，更是國家不可或缺的基本要素，保有充裕優質而無害的水環境，自古即是社會安定、政治和諧、與經濟繁榮的關鍵基石。政府為了解決水資源在發展上有關利水、治水與親水、活水的問題，進行有計畫的水資源研究、規劃，以期滿足人類現在及未來之需求，並維護生態資源。 而水文、水資源等水資訊之基本資料蒐集、流通使用為國家整理發展之重要基礎工作，凡舉防洪、救災、水源調配分析、營運管理，皆需仰賴長期而且完整之水文、水資源觀測數據，同時政策決定、產業發展亦需以水文及水資源資訊為重要之決策資訊。國內水文水資源相關資料長年皆由各水利機關依業務需要分別建置管理，造成資訊傳遞、應用之不易，後續加值應用仍需採用人工或半自動方式處理，造成加值應用之不便。 為因應新型態的應用與挑戰，強化資料加值應用及使用端應用之基礎資料，本計畫擬透過建置透過後端應用模組開發，提升資料交換效率及資料分析自動化速度，爰研提本計畫。

1、Forward During 2011 and 2013 the Water Resources Planning Institute (hereafter the Institute) established a platform that integrates databases in water resources planning so as to adapt to the applications and challenges in applying basic water resources data from the viewpoint of users and increase the efficiency on data exchange, analysis and automation. The platform was based on the planning result of Tien Hua Hu Reservoir and the WRASIM-E, a section of Regional Water Resources Allocation Simulation Model (WRASIM) developed by National Cheng-Gung University. This database platform supplies and manages information necessary for water resources planning and research. Our long-term goal is to build a platform that includes data of various stages of survey, monitoring, analysis, planning, design, construction and operation for existing management facilities, water resources projects in construction or under planning, so as to benefit future planning, design and management efforts. The purpose of the project is to continue to maintain the existing database platform, to fine-tune and expand its functions, and to assist on data feedback from other relevant projects. We also expanded on data collection sources according to the re-prioritization of water resources tasks and the need to integrate modules for the conjunctive use of surface and groundwater. Through data source integration we hope to widen the scope of application and enhance the efficiency of planning procedure. 2、Collection and analysis of basic information and water resources planning modules By analyzing the various tasks in water resources planning and understanding the frequently used modules, we selected types of data necessary and researched their sources in order to predict the demand on the database platform and its overall framework. The result can be utilized in establishing the data collection and supply system in the future. A water resources project can generally be divided into the following stages: survey and planning (including environmental impact assessment), design and construction, operation and maintenance. The current scope of the water resources integration database platform primarily supplies data for survey and planning. The way data sharing and management on the design and construction as well as operation and maintenance stages should be carried out as regarded necessary by the taskforce. The database platform can supply needed data through interfacing and linking. We referred to the Standard Methods for Water Resources Development (draft) and existing planning reports to determine data needed for the survey and planning stage of the water resources development. We also incorporated the procedures in planning reservoirs, dams, artificial lakes, seawater desalination plant, wastewater reclamation plant and facilities utilizing groundwater and sub-surface flow to understand the data necessary for the water resources integration database platform. As for the water resources planning modules, we studied and assessed the planning modules recently developed by the Water Resources Agency (including the Institute) and other commonly used modules to ensure that our platform provide necessary data and evaluate whether the results should be fed back to the databases. 3、Demand for the water resources integration database platform and the planning of overall framework This task intends to analyze the scope of data management for the water resources integration database platform and to plan for its overall framework in order to provide lessons for its future establishment. The main job is to plan the overall framework after realizing the demand and trend of the water resources integration database platform. Utilizing the results of previous analyses of the collected data, the trial run of data feedback as well as the conjunctive use simulation of ground and surface water, we have completed the data demand analyses in the following categories: physical environment (hydrological, weather, physiographical, geological, seismic data), natural resources (water right, material, ecological data), environmental quality (water quality data), socio-economic conditions (water use data), land (administration and use), and others (references, numerical models). We have partially incorporated these items and the remaining items can be considered for future data management and database platform expansion. In analyzing the trend of database platform, this project proposes to use an integrated cloud space for data management, so as to respond to the data sharing goal (IaaS) of the Water Resources Agency and provide data integration and supply service. On data application, we propose to continue to expand the existing functions in the water resources planning modules and to evolve the more complicated modules into Platform as a Service (PaaS). 4、Database platform maintenance and functional expansion The databases used in this project have been updated through data interfacing and management modules. The time span and number of items varies with databases. Following the rules of the Water Resources Agency, data security was maintained through Static Code Analyzer to avoid cross-site scripting (XSS) of bad programming, Application Buffer Overflow, SQL Injections and other major security pitfalls. We have also assisted the database feedback process by analyzing the data feeding back to the database platform from the water resources planning and research projects during the year and compared them with the existing database structure. We adjusted the database according to its demand and meanwhile modified the upload, supply and query functions for the corresponding items to ensure the data provided by the project can be properly managed. We also installed statistical functions to tabulate the types and items of the feedback data so as to examine the use of data feedback. Regarding system function expansion, we decided to maintain the original database platform structure but divide the users into different categories. This year we included a new system, the Water Resources Data Query Platform, which functions as the basic data query system. The primary role of the existing Water Resources Database Platform has been assigned to data management. The Water Resources Database Graphic Platform is a display platform of geo-referenced information. This year we sorted and adjusted graphic information to simplify the selection of needed layers and expanded on the regional geological graphs. 5、Water Resources Planning Modules Installation This project utilizes the existing results of related projects and adopted the updated Regional Water Resources Allocation Simulation Model (WRASIM) developed by Professor Nai Fang Chou of National Cheng Kung University. The model has now incorporated the surface water simulation model WRASIM and the groundwater flow simulation model MODFLOW. We used the model as the core and kept the original input, output and execution files upon installing the user-friendly interface for surface and groundwater conjunctive use simulation. As a result, beginning users will be able to conduct basic simulation tasks in the shortest amount of time. In order to link the surface water and groundwater models, the project installed the groundwater extraction function for WRASIM. Water extraction for the surface water model can be regarded as a node for water source and a well for the groundwater model. The newly included “extraction area” node can include multiple locations. The user has to define the capacity of pumps for the extraction locations in the area and the grid coordinates in the corresponding groundwater network of the MODFLOW model.