In terms of data expansion and maintenance, a total of 5 data were added and revised this year, and the continuous transfer of 44 systems were maintained.As to maintenance, 278 ChemiCloud accounts were established; 19 transfer systems were managed; data transposition program adjustment of 2 systems was complete; automatic transfer processing for 4 systems were completed; supplier data integration program was developed; 2,486 data of chemical substances and 24,288 data of suppliers were integrated.In order to improve the chemical substances and suppliers’ data link to more than 80%, the data cleaning process was carried out, and the related department was asked to add and rectify the information. Four systems were corrected and one system cannot be corrected. The rest systems will cooperate with the data transfer schedule and after the correction of the information, the CDX will be transferred.In order to achieve the goal of data sharing, a system field sharing survey was conducted, and a total of 30 systems agreed to share all the data and 14 systems agreed to share part of the data.In addition, the host transfer and modification of the transposition program were completed to reduce the database resource utilization rate and 35 temporary assignments are completed.
Regarding development and interface required by the related departments, a total of 17 functions were developed and refined. Nine functions of the ChemiCloud system were improved. Six functions were developed on the request of the related departments. Two Web Service functions including toxic and poisonous disaster prevention information were provided to the related departments for use. Furthermore, in response to the fire incident of Chin Poon Industrial Company, the ChemiCloud Platform conducted 78 functional adjustments and improved the platform functions so that the fire department and units can easily search for the information they need.
From the aspect of the analysis and application of ChemiCloud database,big data analysis was introduced this year; internal and external data of ChemiCloud database platform were integrated; the risk management of the industry were conducted from four aspects and function development and construction were carried out. The first aspect is to establish an intelligent transaction tracking process for real-time transaction tracking to analyze the chemical substances possessed by suppliers and trading situations of them. The purpose is to track the operation of chemical substances in real time and quickly grasp the trading flow. The second aspect is to analyze the domestic and international news events and the food safety alert anomaly mode through web scraping technology , and compare the mode with domestic suppliers to quickly respond to abnormality detection in the investigation and early warning system to improve the efficiency of investigation. The third aspect is to set up a supplier risk prediction analysis model to integrate the internal and external data of the ChemiCloud database platform, establish suppliers, chemical substances and operation information. Through the risk management analysis method, a list of suppliers who might violate the regulations will be produced. Then list can be the reference of the risk level and the decision makers can decide the sequence for inspecting suppliers prioritize the inspection according to the list to prevent the occurrence of chemical events, and thus better the management function of the ChemiCloud. The fourth aspect is to build up a cross-domain comparison for environmental monitoring systems, adopting environmental information stations or monitoring values of environmental IoT to obtain more dynamic and static datato achieve time-sensitive, real-time warnings and alerts.
In order to collecting and organizing the information about precursor chemicals of IED, we collected controlled chemical items. We also referred to the classification of explosives issued by the National Fire Protection Association (NFPA), and the “common explosive chemicals ranking” issued by United States National Research Council (NRC). The above data combined with the calculation formula of precursor chemicals of IED analyzed by ChemiCloud project of Toxic and Chemical Substances Bureau, EPA, Executive Yuan and then four criteria were set. A total of 108 substances were listed in the priority list for recommended assessment. The lists have already been uploaded to the ChemiCloud platform to provide cross-analysis for the declaration information. As to the screening mechanism for the risk assessment of drug precursors, we collected and organized the results from drug precursors list of the United Kingdom, Japan, the United States, Canada, China, the United Nations, the European Union, etc., and excluded the unsuitable lists and came up with 16 recommended lists. Furthermore, 8 recommended lists were derived from the literature and news events, and a total of 24 recommended lists for priority management were presented.In addition, the project also collected amphetamine precursors and 36 chemical substances were screened, including 22 types of raw materials (part of the drug structure), and 14 types of additives.Of the 36 chemical substances, 24 are listed in controlled list of Taiwan and the remaining 12 ones are included in the list of the 24 recommended lists for priority management of drug precursors.
In terms of the assessment of the possible ways of the unified declaration window mechanism for future chemical substances, we collected and organized the declaration column of toxic chemical substances, hazardous substances, dangerous goods, pesticide food additives, precursor chemicals, controlled drugs, and environmental drug users. It is suggested that a large number of areas that intensively operate chemical substances, including industrial zones, science parks, industrial parks,export processing zones, and large-scale operation plants, should be on the priority list of implementation of a single declaration window in the future.
Combined with the IoT and environmental cloud data cross-domain services of Environmental Protection Administration, Executive Yuan, the project has completed four cases analysis related to pollution (copper, zinc, cadmium, PM2.5). Through the substance flow analysis of heavy metal pollutants, three maps of metal pollution severity were drawn.The analysis method was conducted to verify the soil and water copper concentration of Nankan Riverpilot zone of the 2017 project of Soil and Groundwater Pollution Remediation Funds. The results were consistent with the maps drawn.In addition, the project adopted the air pollution environmental IoT of Environmental Protection Administration to detect the concentration of PM2.5 in Taichung Industrial Park in the second quarter of 2018 and then the test value sent back by EPA EdiGreen AirBox were analyzed through grid color blocks to find out the possible source suppliers that cause the pollution.