環保專案成果報告查詢系統

專案計畫編號
經費年度	113
計畫經費	10,300 千元
預算科目	檢測認證管理-綜合規劃
專案開始日期	2024/03/13
專案結束日期	2024/12/31
專案主持人	張景舜
主辦單位	國環院綜合規劃組
承辦人	林思宏
執行單位	資拓宏宇國際股份有限公司
專案分類	環境資訊系統
中文關鍵字	環境研究、數據分析
英文關鍵字	Environmental Research, Data Analysis
協同主持人
共同主持人
計畫聯絡人	張景舜
計畫聯絡電話	02-81758888#1739
計畫聯絡信箱	jody.chang@iisigroup.com

中文摘要	113 年環境研究數據分析暨邊緣運算平臺建置案主要係為建立國家環境研究院數據驅動之資訊環境，以推動環境資料科學相關發展。資料倉儲與分析平臺為組織內進行分析應用之本，輔以ETL 工具進行資料處理，將資料載入資料倉儲。再透過視覺化呈現與互動工具展示分析成果，可讓使用者更快發掘隱藏的資訊，甚至做出具影響力的業務決策。本專案執行團隊依與業務單位需求訪談內容，已建置「戴奧辛檢測相關性分析」、「桃園飲用水水質檢驗」、「水污定檢議題分析」、「PM2.5化學成分監測議題分析」等4個分析主題儀表板，共有7個儀表板，並完成三層式資料倉儲建置(STAGE 層、ODS 層、DW 層)，其中包含4 個分析主題所使用之資料，共25 個資料表，以及規劃外部開放資料收檔架構與開發20 個ETL Job 進行資料處理。執行團隊亦已建置知識庫入口網作為國內外環境研究新知、國家環境研究院研究成果、本專案建置分析平臺資訊等知識存放，並提供電子報發送服務。執行團隊辦理3場教育訓練，分別為「系統平臺教育訓練」、「Vertica 資料倉儲教育訓練」、「分析主題應用教育訓練」。另與國家環境研究院進行需求訪談，提出國家環境研究院資料治理規劃，此外，亦蒐集財政部與內政部之大數據分析應用案例，提出可行建置精進方案作為國家環境研究院大數據發展參考。
中文關鍵字	環境研究、數據分析

中文摘要

113 年環境研究數據分析暨邊緣運算平臺建置案主要係為建立國家環境研究院數據驅動之資訊環境，以推動環境資料科學相關發展。資料倉儲與分析平臺為組織內進行分析應用之本，輔以ETL 工具進行資料處理，將資料載入資料倉儲。再透過視覺化呈現與互動工具展示分析成果，可讓使用者更快發掘隱藏的資訊，甚至做出具影響力的業務決策。本專案執行團隊依與業務單位需求訪談內容，已建置「戴奧辛檢測相關性分析」、「桃園飲用水水質檢驗」、「水污定檢議題分析」、「PM2.5化學成分監測議題分析」等4個分析主題儀表板，共有7個儀表板，並完成三層式資料倉儲建置(STAGE 層、ODS 層、DW 層)，其中包含4 個分析主題所使用之資料，共25 個資料表，以及規劃外部開放資料收檔架構與開發20 個ETL Job 進行資料處理。執行團隊亦已建置知識庫入口網作為國內外環境研究新知、國家環境研究院研究成果、本專案建置分析平臺資訊等知識存放，並提供電子報發送服務。執行團隊辦理3場教育訓練，分別為「系統平臺教育訓練」、「Vertica 資料倉儲教育訓練」、「分析主題應用教育訓練」。另與國家環境研究院進行需求訪談，提出國家環境研究院資料治理規劃，此外，亦蒐集財政部與內政部之大數據分析應用案例，提出可行建置精進方案作為國家環境研究院大數據發展參考。

中文關鍵字

環境研究、數據分析

類型	檔名	檔案大小	說明	最新版公開日期
期末報告	113FA010_資拓宏宇_113年環境研究數據分析系統_成果報告書20241231.PDF.pdf	43MB		2025/1/31 上午 12:00:00

摘要	This project, 2024 Environmental Research Data Analysis & Edge Computing Platform, primarily aims to establish a data-driven information environment for the Institute to promote developments in environmental data science. The data warehouse and analysis platform serve as the foundation for applications of data analysis, utilizing ETL tools for data processing to load data into the warehouse. Through visualization and interactive tools, the analysis results are presented, allowing users to quickly uncover hidden insights and even make impactful business decisions. Based on interviews with relevant departments, the project executive team has set up dashboards for 4 data analysis topics: “Dioxin Detection Correlation Analysis,” “Taoyuan Drinking Water Quality Inspection,”“Water Pollution Inspection Issue Analysis,” and “PM2.5 Chemical Composition Monitoring Issue Analysis,” totaling 7 dashboards.Additionally, a three-tier data warehouse has been established (including STAGE, ODS, and DW layers), comprising 25 tables used for the 4 data analysis topics, and an external open data archive framework has been designed along with the development of 20 ETL jobs for data processing. The team has also built a knowledge base for the latest environmental research insights, the Institute's research outcomes, and information on the data analysis platform developed by the project, as well as providing an e-newsletter service. The project executive team conducted three training sessions: “System Platform Training,” “Vertica Data Warehouse Training,” and “Data Analysis Application Training.” Furthermore, the team conducted interviews to understand the Institute’s needs and proposed a data governance plan. In addition, big data analysis application cases from the Ministry of Finance and the Ministry of the Interior were collected to suggest feasible advancements as references for the Institute’s big data development.
英文關鍵字	Environmental Research, Data Analysis

摘要

This project, 2024 Environmental Research Data Analysis & Edge Computing Platform, primarily aims to establish a data-driven information environment for the Institute to promote developments in environmental data science. The data warehouse and analysis platform serve as the foundation for applications of data analysis, utilizing ETL tools for data processing to load data into the warehouse. Through visualization and interactive tools, the analysis results are presented, allowing users to quickly uncover hidden insights and even make impactful business decisions. Based on interviews with relevant departments, the project executive team has set up dashboards for 4 data analysis topics: “Dioxin Detection Correlation Analysis,” “Taoyuan Drinking Water Quality Inspection,”“Water Pollution Inspection Issue Analysis,” and “PM2.5 Chemical Composition Monitoring Issue Analysis,” totaling 7 dashboards.Additionally, a three-tier data warehouse has been established (including STAGE, ODS, and DW layers), comprising 25 tables used for the 4 data analysis topics, and an external open data archive framework has been designed along with the development of 20 ETL jobs for data processing. The team has also built a knowledge base for the latest environmental research insights, the Institute's research outcomes, and information on the data analysis platform developed by the project, as well as providing an e-newsletter service. The project executive team conducted three training sessions: “System Platform Training,” “Vertica Data Warehouse Training,” and “Data Analysis Application Training.” Furthermore, the team conducted interviews to understand the Institute’s needs and proposed a data governance plan. In addition, big data analysis application cases from the Ministry of Finance and the Ministry of the Interior were collected to suggest feasible advancements as references for the Institute’s big data development.

英文關鍵字

Environmental Research, Data Analysis