新北產業園區污水處理廠設有水質水量即時監測系統，由於設備更替，歷史資料收集不易，容易遺失且不易保存，且自動監測數據並未經過實驗室資料校正。本研究建立水質歷史資料庫管理系統，首先收集歷史入流及出流之水質資料及實驗室分析資料，包括pH、導電度(Electrical Conductivity, EC)、懸浮固體(Suspended Solids, SS)、化學需氧量(Chemical Oxygen Demand, COD)，據以建立二階正規化格式之資料庫及展示系統，再進行實驗室資料與即時監測資料之差異分析，建立即時監測資料修正公式。本研究透過資料庫建立，可查詢平均資料、極端值資料及修正後監測數據，未來可連結即時傳輸資料，建立即時資料查詢，並提供大數據分析之用。 Sewage Treatment Plant of Industrial Park in New Taipei city has an Real-Time Monitoring System (RTMS) for water quality. However, equipment replacement usually induces the loss of historical data. In addition, data from RTMS is never compared with laboratory data. This study establishes a historical data storage system for water quality. Firstly, historical data of RTMS and laboratory analysis data, including water quality data, pH, Electrical Conductivity (EC), Suspended Solids (SS) and Chemical Oxygen Demand (COD) were collected. A second-order normalized format database and display system were established. The difference between laboratory data and data from RTMS were compared to find the correction formula of RTMS. This study established a database and display system, which can display average data, extreme value, and modified RTMS data. In the future, the real-time data can be connected to this system for the real-time queue and the analysis of big data.
