environmental data warehouse system2008In order to integrate the
「environmental data warehouse system2008In order to integrate the」於資料集「EPQSummary_EnvironmentalInformationSystem」由單位「行政院環境保護署」的陳先生所提供，聯繫電話是02-2311-7722#2386，最近更新時間為：2023-07-30 01:01:46。 欄位Project Title的內容是environmental data warehouse system ， 欄位Project Subject的內容是In order to integrate the data sufficiently, promote the efficiency of analysis and inquiry by theme, area, and time, the Environmental Protection Administration (EPA) of Executive Yuan handles this Project to establish the Environmental Data Warehouse, so as to use it as the basis to promote the “Taiwan Environmental Data Center” (TENDC) in the future.
The major work of this Project is to plan, design, develop, and establish the Environmental Data Warehouse system, purchase the relevant software and hardware, and regulate the operation standard and mechanism of data warehouse. The establishment process of data warehouse is to analyze the system requirement, interview the business unit, collect and analyze the data first, then discuss the category of theme, hold the consulting meeting of experts, plan the structure of warehouse, design the function of system, set up the software and hardware, complete the transformation of data files, extract, transfer, import the source data into data warehouse, and finish the development of inquire website finally.
The Environmental Data Warehouse system has already finished 30 databases from the business units of Environmental Protection Administration. The data warehouse is divided into 8 themes, including the air quality, water, waste and resource recovery, toxic substances and environmental pesticides, soil, noise and radiation, and environmental management and others. The source data include the important data from the environmental monitoring, environmental statistics, environmental protection fund, control and monitoring premises, investigation and disciplinary, and the Environmental Management System (EMS). After the above-mentioned data are inputted into the data warehouse, the specific data structure of data warehouse is followed to store the physical data by the integration of theme orientation, fact table and dimension table (time, space, test item etc.), in order to reach the theme orientation, integration, analysis and multiple dimensional report inquiry function. About 27,650,000 data has already been gathered into the data warehouse in 2008.
In order to assure the update of data in the data warehouse at any time, this Project stipulates the data update mechanism for data exchange, data loading, data transformation and import scheduling etc. Meantime, it provides the theme-type data display function, integrates the water quality monitoring data of the EPA and the river water amount data of the Water Resources Agency, controls and monitors the integrated data of pollution, and combines the comprehensive data of Google map and relevant authorities.
This Project also employs the On-Line Analytical Processing (OLAP) to finish a single-station type, inter-business and inter-authority system with multiple dimensional data inquiry function by the condition of area, time, and theme etc., in order to reach the efficacy of environmental data integration and application fully. In the future, it can adopt the specific storage structure of data warehouse again to combine the Geographical Information System (GIS) more easily, in order to develop more applications on OLAP analysis and data mining. ， 欄位Project Year的內容是2008 ， 欄位Organizer的內容是Department of Environmental Monitoring ＆amp; Information Management ， 欄位Executive Unit的內容是中興工程顧問工程社 ， 欄位Reporting download URL的內容是https://epq.epa.gov.tw ， 欄位Publish Date的內容是20090301 。
Project Title
environmental data warehouse system
Project Subject
In order to integrate the data sufficiently, promote the efficiency of analysis and inquiry by theme, area, and time, the Environmental Protection Administration (EPA) of Executive Yuan handles this Project to establish the Environmental Data Warehouse, so as to use it as the basis to promote the “Taiwan Environmental Data Center” (TENDC) in the future. The major work of this Project is to plan, design, develop, and establish the Environmental Data Warehouse system, purchase the relevant software and hardware, and regulate the operation standard and mechanism of data warehouse. The establishment process of data warehouse is to analyze the system requirement, interview the business unit, collect and analyze the data first, then discuss the category of theme, hold the consulting meeting of experts, plan the structure of warehouse, design the function of system, set up the software and hardware, complete the transformation of data files, extract, transfer, import the source data into data warehouse, and finish the development of inquire website finally. The Environmental Data Warehouse system has already finished 30 databases from the business units of Environmental Protection Administration. The data warehouse is divided into 8 themes, including the air quality, water, waste and resource recovery, toxic substances and environmental pesticides, soil, noise and radiation, and environmental management and others. The source data include the important data from the environmental monitoring, environmental statistics, environmental protection fund, control and monitoring premises, investigation and disciplinary, and the Environmental Management System (EMS). After the above-mentioned data are inputted into the data warehouse, the specific data structure of data warehouse is followed to store the physical data by the integration of theme orientation, fact table and dimension table (time, space, test item etc.), in order to reach the theme orientation, integration, analysis and multiple dimensional report inquiry function. About 27,650,000 data has already been gathered into the data warehouse in 2008. In order to assure the update of data in the data warehouse at any time, this Project stipulates the data update mechanism for data exchange, data loading, data transformation and import scheduling etc. Meantime, it provides the theme-type data display function, integrates the water quality monitoring data of the EPA and the river water amount data of the Water Resources Agency, controls and monitors the integrated data of pollution, and combines the comprehensive data of Google map and relevant authorities. This Project also employs the On-Line Analytical Processing (OLAP) to finish a single-station type, inter-business and inter-authority system with multiple dimensional data inquiry function by the condition of area, time, and theme etc., in order to reach the efficacy of environmental data integration and application fully. In the future, it can adopt the specific storage structure of data warehouse again to combine the Geographical Information System (GIS) more easily, in order to develop more applications on OLAP analysis and data mining.
Project Year
2008
Organizer
Department of Environmental Monitoring ＆amp; Information Management
Executive Unit
中興工程顧問工程社
Reporting download URL
Publish Date
20090301
「environmental data warehouse system2008In order to integrate the」所屬的資料集：「EPQSummary_EnvironmentalInformationSystem」的其他資料
Project Title：
Preliminary Research Project of Participating International Collaboration in Background Air Quality
Project Subject：
Taiwan is located in the downwind region of the Asian circulation system. Air pollutants emitted in
Project Year：
2010
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
"Analyze the Low Carbon and Sustainable Homeland Database for Practical Application and Manage Web S
Project Subject：
"The construction work of Low-Carbon and Sustainable Homeland Program involves technology and equipm
Project Year：
2016
Organizer：
"Department of Environmental Sanitation ＆amp; Toxic Substance Management"
Project Title：
Strengthen Sewage Sewer System Management and Continuous Water Monitoring System’s (CWMS) Transmissi
Project Subject：
This is an administrative assisting project with the following goals:
1.To enforce water pollution p
Project Year：
2021
Organizer：
Department of Water Quality Protection
Project Title：
"Text mining (including full-text search) software and build service"
Project Subject：
"The project consists of the following four main items of work:1. Case studies of big data applicati
Project Year：
2015
Organizer：
"Department of Environmental Monitoring ＆amp; Information Management"
Project Title：
Ministery of Environmental and Natural Resources' website constructed due to organization reform.
Project Subject：
Renew Environmental Protection Administration website, Plan and establish Ministry of Environmental
Project Year：
2010
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Quality Assurance and Data Validation on Ozone precursor Monitoring from PAMS in 2010
Project Subject：
The main objectives of this program included implementing the quality assurance audits of analytical
Project Year：
2010
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Investigation and Filing Plan of the Water Source Protection Area and Western Coastal Area -- Basic
Project Subject：
--
Project Year：
1993
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
"To Apply the Chemical Substances Management Information Project"
Project Subject：
" In terms of the improvement of efficiency and data maintenance of the ChemiCloud platform, we’v
Project Year：
2021
Organizer：
"Toxic and Chemical Substances Bureau"
Project Title：
The system expansion of central data exchange platform for the environmental and natural resources d
Project Subject：
The system expansion of central data exchange platform for the environmental and natural resources d
Project Year：
2012
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Taiwan Air Quality Monitoring Station Quality Assurance Project
Project Subject：
This project executing period was from May 8th 2009 to May 7th 2011. The main purpose of this projec
Project Year：
2009
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Upgrading Environmental Protection Administration, Executive Yuan Web Page Services
Project Subject：
The EPA aims to achieve a healthier and prosperous environment and a sustainable future. In addition
Project Year：
2007
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
The Primary Study of Multiple Functions and Site Selection for Atmospheric Background Station
Project Subject：
Environmental observation stations provide a critical function for monitoring regional atmospheric c
Project Year：
2009
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Environmental Spatial Data Expansion and Integration of GIS Applications
Project Subject：
In order to promote environmental perception, Environmental Protection Administration (EPA) releases
Project Year：
2016
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Living environmental information construction using Geographic Information Systems
Project Subject：
The Environmental Information System Data Exchange and Supply Operation Project consists 6 major tas
Project Year：
2005
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
2015 The Program of Environmental Agents Manage System Operation and Maintenance
Project Subject：
The key points of the program are divided into 3 aspects: systematic management、system optimization、
Project Year：
2015
Organizer：
Department of Environmental Sanitation ＆amp; Toxic Substance Management
Project Title：
Investigate the controlling processes of the formations and distributions of ozone and particulate m
Project Subject：
Project Year：
2002
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
2022 Project on Maintaining the Functional Groups of the Environmental Enforcement Management System
Project Subject：
The primary outcomes achieved by this project in 2022 are as follows:
1.Maintain the operation of th
Project Year：
2022
Organizer：
Bureau of Environmental Inspection
Project Title：
environmental data warehouse system
Project Subject：
In order to integrate the data sufficiently, promote the efficiency of analysis and inquiry by theme
Project Year：
2008
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
The frequently monitoring of secondary photochemical pollutants in Taipei metropolis.
Project Subject：
The frequently monitoring of secondary photochemical pollutants in Taipei metropolis.
Project Year：
2006
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
2020 Inspection Management Platform Improvement and Maintenance
Project Subject：
In 2020, the nine primary results of this project are as follows:
(I) Maintain and improve platform
Project Year：
2020
Organizer：
Bureau of Environmental Inspection
Project Title：
"Environmental Spatial Data Expansion and Integration of GIS Applications"
Project Subject：
"In order to promote environmental perception, Environmental Protection Administration (EPA) release
Project Year：
2016
Organizer：
"Department of Environmental Monitoring ＆amp; Information Management"
Project Title：
"107-108 Environmental and Natural Resources Data Services Display Platform Expansion and Maintenanc
Project Subject：
"The fifth phase of e-government program (2017 - 2020) establishes digital services and innovative a
Project Year：
2018
Organizer：
"Department of Environmental Monitoring ＆amp; Information Management"
Project Title：
Monitoring data analysis and air quality simulation of Wujih, Hsichou and Linnei incinerators.
Project Subject：
This project utilized ISCST3 to simulate the air pollutants diffusion, and concentration distributio
Project Year：
2005
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
"Improve “Environmental Geographic Information Service” and implement data standard"
Project Subject：
"At the end of 2000, EPA has planned environmental database system architecture in order to instantl
Project Year：
2014
Organizer：
"Department of Environmental Monitoring ＆amp; Information Management"
Project Title：
Nationwide air quality monitoring integration and application project
Project Subject：
The project tasks in this year are to survey the current situation of air quality monitoring nationw
Project Year：
2015
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Design Information Operation Process and Implement Information Service Management Standard
Project Subject：
This article is a final research report to project, entitle “Design Information Operation Process an
Project Year：
2006
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
Intensive Recreational Water Quality Monitoring of the Taiwan Coastal Area
Project Subject：
This project is designated to perform intensive recreational water quality monitoring of the Taiwan
Project Year：
2002
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
Project Title：
"The Development of an Integrated Information System for Forensic of Environmental Pollution Sources
Project Subject：
"Activating a GIS application as an auxiliary tool for environmental forensic is based on quality of
Project Year：
2020
Organizer：
"Environmental Analysis Laboratory"
Project Title：
Publishing National Sustainable Development Annual Report and Project for maintaining National Susta
Project Subject：
This program that started in May 2003 and end in March 2004 includes the construction of a National
Project Year：
2003
Organizer：
Office of Sustainable Development
Project Title：
Sampling and Analysis at the Lulin Atmospheric Background Station and International Collaboration P
Project Subject：
In recent years the inputs of Asian atmospheric pollutants (for instance, acid pollutants, Asian dus
Project Year：
2006
Organizer：
Department of Environmental Monitoring ＆amp; Information Management
行政院環境保護署 的其他資料集
特殊性工業區品保品管後監測值資料檔(一般空氣污染物)
每年更新更新,139丁小姐 | 02-2371-2121#6101 | 2022-01-15 01:06:51
行政院環境保護署已公告之飲用水水源水質保護區一覽表
不定期更新更新,66黃先生 | 02-23117722#2881 | 2022-01-15 01:10:25
行政院環境保護署沼液沼渣農地肥分使用計畫
不定期更新更新,43吳小姐 | 02-2311-7722#2842 | 2023-08-09 01:05:34
行政院環境保護署環保專案摘要資料_氣候變遷
不定期更新更新,65陳先生 | 02-2311-7722#2386 | 2023-07-30 01:01:40
行政院環境保護署符合噪音管制標準車輛-進口汽油引擎車
不定期更新更新,177林先生 | 02-23712121-6403 | 2022-01-14 01:18:56
行政院環境保護署
道路交通音量監測不合格時段數
每3月更新,103陳先生 | 02-23117722#2108 | 2023-07-30 01:01:06
行政院環境保護署PM2.5化學成分監測數據
每1月更新,183蘇先生 | (03)491-5818#2204 | 2023-07-27 01:03:08
行政院環境保護署空氣品質小時值_雲林縣_斗六站
每1時更新,114陳先生 | 02-2311-7722#2386 | 2023-08-02 00:57:53
行政院環境保護署環境音量監測結果統計(依時段分)
不定期更新更新,171章小姐 | 02-23712121#6407 | 2023-08-03 01:04:07
行政院環境保護署建檔公廁明細-新竹縣
不定期更新更新,128賴先生 | 04-2252-1718#53686 | 2023-07-27 01:02:00
行政院環境保護署
包裝及盛裝飲用水水源水質抽驗結果
每季更新更新,109黃先生 | 02-23117722#2881 | 2022-01-15 01:10:25
行政院環境保護署雲林縣水量水質自動監測連線傳輸監測紀錄值即時資料集
不定期更新更新,48許先生 | 02-2311-7722#2831 | 2022-01-18 01:24:47
行政院環境保護署0800資源回收免費專線-一般件問題查詢廢電子電器統計
每1年更新,44莊先生 | 02-23705888#3108 | 2023-07-27 01:00:02
行政院環境保護署空氣品質小時值_南投縣_埔里站
每1時更新,166陳先生 | 02-2311-7722#2386 | 2023-08-02 00:57:26
行政院環境保護署毒化物運作紀錄申報總量
每6月更新,159許先生 | 02-23257399#55328 | 2023-07-27 01:03:31
行政院環境保護署
空氣品質小時值_臺中市_忠明站
每1時更新,150陳先生 | 02-2311-7722#2386 | 2023-08-02 00:57:58
行政院環境保護署行政院環境保護署環境檢驗所法定預算
每1年更新,64莊小姐 | 03-4915818#3003 | 2023-08-09 01:05:46
行政院環境保護署南科樹谷環評監督委員會會議紀錄
不定期更新更新,50陳先生 | 04-2252-1718#51207 | 2022-01-14 01:21:54
行政院環境保護署土壤及地下水污染場址基本資料
每日更新更新,117賴小姐 | 02-2383-2389#8102 | 2022-01-15 01:12:31
行政院環境保護署環境影響評估技術顧問機構評鑑成果
2年更新,43劉先生 | 02-23117722#2743 | 2022-01-15 01:12:19
行政院環境保護署
醫療事業廢棄物再利用機構資料
每年更新更新,88李小姐 | 02-2311-7722#2633 | 2022-01-14 01:26:12
行政院環境保護署經過水庫集水區之環境影響評估報告書件
每2月更新,44黃先生 | 02-23117722#2748 | 2023-08-05 01:00:57
行政院環境保護署固定污染源CEMS監測數據紀錄值資料集(取前日所有測項)
不定期更新更新,67洪小姐 | 02-23117722#6221 | 2023-08-07 01:03:40
行政院環境保護署歷年公共建設計畫執行情形
不定期更新更新,45陳小姐 | 02-2311-7722#2913 | 2022-01-15 01:10:17
行政院環境保護署重點事業廢棄物-一般污泥之處理方式
每月更新更新,133陳先生 | 02-2311-7722#2682 | 2022-01-14 01:24:13
行政院環境保護署
模場試驗專案期末報告電子檔
不定期更新,52蘇先生 | 02-2311-7722#8110 | 2022-01-15 01:10:09
行政院環境保護署環保署官等年資統計資料
不定期更新更新,41黃小姐 | 02-23117722分機2132 | 2022-01-15 01:13:00
行政院環境保護署廢棄物稽查次數
每1年更新,149顏先生 | 02-23117722#2109 | 2023-07-27 01:00:46
行政院環境保護署毒性化學物質禁止運作事項資料
不定期更新更新,43許先生 | 02-23257399#55328 | 2023-07-30 00:59:58
行政院環境保護署經過山坡地之環境影響評估報告書件
每2月更新,63黃先生 | 02-23117722#2748 | 2023-08-05 01:00:56
行政院環境保護署