基于Excel实现解析法预测典型污染源对地下水的环境影响
发布时间：2018-08-09 10:35
【摘要】：随着我国经济的飞速发展,环境问题变得越来越严重。为了避免工业生产加剧环境污染程度,我国于2003年9月颁布实施了《中国环境影响评价法》,规定新建或者改扩建项目施工前期必须进行环境影响评价。该法律对建设项目可能造成的环境污染起到了源头控制的作用。2011年6月份,环境保护部颁布了《环境影响评价技术导则—地下水环境》(HJ 610-2011),对建设项目环境影响评价中的地下水环评工作起到了指导与规范作用。针对《环境影响评价技术导则地下水环境》在实施过程中,地下水环境影响预测模型选择与应用存在不一致性、非标准化、预测结果难于验证等问题,急需研发适于我国地下水环境影响预测评价的指标和模型,研发地下水环境影响预测评价法规模型平台,为地下水环境影响预测评价与管理法规化提供科学技术支撑。导则中明确要求二级评价采用解析法或数值法。对于数值法,虽然目前已有比较成熟的可视化软件,例如GMS,Visual Modflow和Feflow等,但是它们都属于商业软件,软件价格比较高。另外,数值模型的建立基于大量的基础数据支持,整个模拟过程需经历模型建立、模型识别、模型验证三个阶段,周期较长且容易出现错误,对于非地下水数值模拟出身的环境影响评价人员来说,应用数值法进行地下水二级评价更是困难。为克服数值法在二级评价应用上的局限性,本论文以Excel为开发平台,主要研究不同边界条件下,污染物从包气带到含水层以及沿含水层运动的整个过程中浓度的变化,并应用Excel VBA编程实现相应的溶质运移解析模型的可视化操作界面。旨在服务《环境影响评价技术导则地下水环境》实施,为水文地质条件单一,地下水流稳定区域的地下水环境影响评价提供一种简单有效的方法,同时为法规模型在地下水饮用水源保护、地下水污染防治规划等领域中提供支持。解析解还可以用于验证数值解的可靠性。在复杂的水文地质系统,解析解也非常有用,它可以估算溶质的扩散速度,对于数据的收集和水质监测具有重要意义。
[Abstract]:With the rapid development of our economy, environmental problems become more and more serious. In order to avoid the environmental pollution caused by industrial production, the Environmental impact Assessment Law of China was promulgated and implemented in September 2003, which stipulates that environmental impact assessment must be carried out before the construction of new or expanded projects. The law acts as a source of control over possible environmental pollution from construction projects. In June 2011, The Ministry of Environmental Protection has promulgated the Technical guideline of Environmental impact Assessment-groundwater Environment (HJ610-2011), which plays a guiding and normative role in environmental impact assessment of construction projects. In view of the problems such as inconsistency between selection and application of groundwater environmental impact prediction model, non-standardization and difficulty in verification of prediction results, etc., during the implementation of "Technical guidelines for Environmental impact Assessment", groundwater environment is difficult to verify. There is an urgent need to develop indicators and models suitable for groundwater environmental impact prediction and assessment in China, and to develop a scale platform for groundwater environmental impact prediction assessment to provide scientific and technological support for groundwater environmental impact prediction assessment and regulatory management. The guidelines explicitly require two-level evaluation to be analytical or numerical. For numerical method, although there are some mature visualization software, such as GMS Visual Modflow and Feflow, they belong to commercial software and the price of software is relatively high. In addition, the establishment of numerical model is based on a large number of basic data support, the whole simulation process needs to go through three stages: model establishment, model recognition, model verification, the period is longer and error is easy to occur. For non-groundwater numerical simulation, it is more difficult to apply numerical method to secondary groundwater assessment. In order to overcome the limitation of numerical method in the application of secondary evaluation, this paper takes Excel as the development platform to study the concentration change of pollutants from aeration to aquifer and the whole process of moving along the aquifer under different boundary conditions. The visual operation interface of solute transport analytical model is realized by Excel VBA programming. The purpose of this paper is to provide a simple and effective method for groundwater environmental impact assessment in areas with single hydrogeological conditions and stable groundwater flow, in order to serve the implementation of the Technical guidelines for Environmental impact Assessment (EIA). At the same time, it provides support for the regulation model in the fields of groundwater drinking water source protection, groundwater pollution prevention planning and so on. The analytical solution can also be used to verify the reliability of the numerical solution. In complex hydrogeological systems, analytical solutions are also very useful, which can estimate the diffusion velocity of solutes and play an important role in data collection and water quality monitoring.
【学位授予单位】：中国地质大学(北京)
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：X523;X824
本文编号：2173807
[Abstract]:With the rapid development of our economy, environmental problems become more and more serious. In order to avoid the environmental pollution caused by industrial production, the Environmental impact Assessment Law of China was promulgated and implemented in September 2003, which stipulates that environmental impact assessment must be carried out before the construction of new or expanded projects. The law acts as a source of control over possible environmental pollution from construction projects. In June 2011, The Ministry of Environmental Protection has promulgated the Technical guideline of Environmental impact Assessment-groundwater Environment (HJ610-2011), which plays a guiding and normative role in environmental impact assessment of construction projects. In view of the problems such as inconsistency between selection and application of groundwater environmental impact prediction model, non-standardization and difficulty in verification of prediction results, etc., during the implementation of "Technical guidelines for Environmental impact Assessment", groundwater environment is difficult to verify. There is an urgent need to develop indicators and models suitable for groundwater environmental impact prediction and assessment in China, and to develop a scale platform for groundwater environmental impact prediction assessment to provide scientific and technological support for groundwater environmental impact prediction assessment and regulatory management. The guidelines explicitly require two-level evaluation to be analytical or numerical. For numerical method, although there are some mature visualization software, such as GMS Visual Modflow and Feflow, they belong to commercial software and the price of software is relatively high. In addition, the establishment of numerical model is based on a large number of basic data support, the whole simulation process needs to go through three stages: model establishment, model recognition, model verification, the period is longer and error is easy to occur. For non-groundwater numerical simulation, it is more difficult to apply numerical method to secondary groundwater assessment. In order to overcome the limitation of numerical method in the application of secondary evaluation, this paper takes Excel as the development platform to study the concentration change of pollutants from aeration to aquifer and the whole process of moving along the aquifer under different boundary conditions. The visual operation interface of solute transport analytical model is realized by Excel VBA programming. The purpose of this paper is to provide a simple and effective method for groundwater environmental impact assessment in areas with single hydrogeological conditions and stable groundwater flow, in order to serve the implementation of the Technical guidelines for Environmental impact Assessment (EIA). At the same time, it provides support for the regulation model in the fields of groundwater drinking water source protection, groundwater pollution prevention planning and so on. The analytical solution can also be used to verify the reliability of the numerical solution. In complex hydrogeological systems, analytical solutions are also very useful, which can estimate the diffusion velocity of solutes and play an important role in data collection and water quality monitoring.
【学位授予单位】：中国地质大学(北京)
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：X523;X824
【参考文献】
相关期刊论文 前2条
1 魏青军;刘平;;基于EXCEL的函数功能实现地下水的质量评判[J];地下水;2007年02期
2 黄金廷;尹立河;王晓勇;董佳秋;马洪云;张俊;;包气带垂向渗透系数的原位试验研究[J];水资源与水工程学报;2013年05期
，本文编号：2173807
本文链接：https://www.wllwen.com/kejilunwen/huanjinggongchenglunwen/2173807.html
最近更新
教材专著
