環境資源報告成果查詢系統

環境資源資料庫建置

中文摘要 環保署於101年進行環境資源資料庫(ERDB)規劃,透過資料交換平台蒐集未來環境資源部各機關、地方政府之環境資源資料,包含大氣、水、土、林、生態、污染防治、其他等資料,形成完整環境資源資料庫,於101年已完成系統整體架構初步規劃,以此規劃架構為基礎,本計畫主要工作為建置實體環境資源資料庫架構及資料實體儲存。 本案執行方法參考Gartner智庫文件「First 100 Days:Leader of Data Management and Integration Initiatives」,將專案組織分為資料品質組、詮釋資料組、資料倉儲組、應用系統組、資料整合組,並聘請專業領域顧問。主要發展理念為導入資料雲(Data Cloud)之概念,跨機關之資料整合,使資料識別一致,進行資訊傳遞(Information Delivery),使資料透明化,提供一般民眾、研究單位、機關可透過瀏覽器擷取所需資料,進而加值利用。 本案以資料雲(Data Cloud)之概念設計環境資源資料庫,包含底層實體資料庫設計、實體儲存及非實體儲存之資料流程、資料交換運作方式、資料品質及錯誤處理機制、詮釋資料設計、ETL資料轉置規則、環境資料總歸戶、環境資料關聯分析以利整合查詢,並說明相關作業流程及命名規則。 以上述之設計為基礎,進一步進行系統分析及系統設計,包括使用案例分析(Use Case)、功能層次圖、資料庫設計、ETL資料轉置規則設計、畫面設計,並於102年10月31日完成系統開發,102年11月30日完成介接測試,陸續加入環境資源資料庫之資料包含雨量、天氣、輻射、紫外線、空氣品質、河川、土石流、水庫、地下水、近海水文、水質監測、污染防治、土壤、地理圖資、報告、影像(音)、統計、其他等主題資料。
中文關鍵字 環境資源資料庫、環境資源、資料倉儲

基本資訊

專案計畫編號 EPA-102-L103-03-002 經費年度 102 計畫經費 14000 千元
專案開始日期 2013/03/07 專案結束日期 2013/12/31 專案主持人 邵成武
主辦單位 監資處 承辦人 劉美慧 執行單位 凌群電腦股份有限公司

成果下載

類型 檔名 檔案大小 說明
期末報告 EPA-102-L103-03-002(結案報告定稿本).rar 7MB

The construction of environmental resources database

英文摘要 For the data integration and management of the to-be-established “Ministry of Environmental and Natural Resources” (MOENR), an environmental resources database (ERDB) project had been planned for the MOENR in 2012. The objective of the project is to build up an environmental resources database (ERDB) to collect environmental data of agencies or local government through established data exchange platform(CDX) including air, water, soil, forest, ecology, pollution prevention, and others information. It had been planned an initial framework of the system, based on the work of the project is to proceed to development and implementation in 2013. Based on the suggestion of Gartner’s reference document-"First 100 Days: Leader of Data Management and Integration Initiatives", the members of project are organized into data quality group, metadata group, data warehousing group, application group, data integration group. In addition, especially invite the professional consultants in the field of environmental resources to aid this project. The main development concept of this project is to implement “data cloud” as the role of information delivery. A data cloud is a means of reconciling, virtualizing, and integrating computer-based information that resides in different agencies, and making that integrated information appropriately available online so businesspeople can search, query, and analyze it in a free form manner using web browsers. Based on the concept of data cloud to implement the detail design of environmental resources database including physical database design, data storage mechanism such as physical storage or only data hyperlink, data exchange mechanism, data quality and error-handling mechanism, metadata design, ETL(Extract, Transform, Load) rules, data integration to specific key for query, data related analysis and naming rules. System analysis and design are then executed on the basis of above mechanism, including: use case analysis, function layer diagram, database design, detail design description for ETL function, and user interface design. The system development project was finished on 2013-10-31, followed by integration testing on 2013-11-30. The following data topics have been added into the environmental resources database such as rainfall, weather, radiation, ultraviolet radiation, air quality, rivers, landslides, reservoirs, groundwater, sea conditions, water quality monitoring, pollution control, soil, geographic map data, reports, image (video) data, statistics, or others topics.
英文關鍵字 Environmental Resources Database、Environmental Resources、