天堂国产午夜亚洲专区-少妇人妻综合久久蜜臀-国产成人户外露出视频在线-国产91传媒一区二区三区

基于Excel實(shí)現(xiàn)解析法預(yù)測(cè)典型污染源對(duì)地下水的環(huán)境影響

發(fā)布時(shí)間:2018-08-09 10:35
【摘要】:隨著我國(guó)經(jīng)濟(jì)的飛速發(fā)展,環(huán)境問(wèn)題變得越來(lái)越嚴(yán)重。為了避免工業(yè)生產(chǎn)加劇環(huán)境污染程度,我國(guó)于2003年9月頒布實(shí)施了《中國(guó)環(huán)境影響評(píng)價(jià)法》,規(guī)定新建或者改擴(kuò)建項(xiàng)目施工前期必須進(jìn)行環(huán)境影響評(píng)價(jià)。該法律對(duì)建設(shè)項(xiàng)目可能造成的環(huán)境污染起到了源頭控制的作用。2011年6月份,環(huán)境保護(hù)部頒布了《環(huán)境影響評(píng)價(jià)技術(shù)導(dǎo)則—地下水環(huán)境》(HJ 610-2011),對(duì)建設(shè)項(xiàng)目環(huán)境影響評(píng)價(jià)中的地下水環(huán)評(píng)工作起到了指導(dǎo)與規(guī)范作用。針對(duì)《環(huán)境影響評(píng)價(jià)技術(shù)導(dǎo)則地下水環(huán)境》在實(shí)施過(guò)程中,地下水環(huán)境影響預(yù)測(cè)模型選擇與應(yīng)用存在不一致性、非標(biāo)準(zhǔn)化、預(yù)測(cè)結(jié)果難于驗(yàn)證等問(wèn)題,急需研發(fā)適于我國(guó)地下水環(huán)境影響預(yù)測(cè)評(píng)價(jià)的指標(biāo)和模型,研發(fā)地下水環(huán)境影響預(yù)測(cè)評(píng)價(jià)法規(guī)模型平臺(tái),為地下水環(huán)境影響預(yù)測(cè)評(píng)價(jià)與管理法規(guī)化提供科學(xué)技術(shù)支撐。導(dǎo)則中明確要求二級(jí)評(píng)價(jià)采用解析法或數(shù)值法。對(duì)于數(shù)值法,雖然目前已有比較成熟的可視化軟件,例如GMS,Visual Modflow和Feflow等,但是它們都屬于商業(yè)軟件,軟件價(jià)格比較高。另外,數(shù)值模型的建立基于大量的基礎(chǔ)數(shù)據(jù)支持,整個(gè)模擬過(guò)程需經(jīng)歷模型建立、模型識(shí)別、模型驗(yàn)證三個(gè)階段,周期較長(zhǎng)且容易出現(xiàn)錯(cuò)誤,對(duì)于非地下水?dāng)?shù)值模擬出身的環(huán)境影響評(píng)價(jià)人員來(lái)說(shuō),應(yīng)用數(shù)值法進(jìn)行地下水二級(jí)評(píng)價(jià)更是困難。為克服數(shù)值法在二級(jí)評(píng)價(jià)應(yīng)用上的局限性,本論文以Excel為開(kāi)發(fā)平臺(tái),主要研究不同邊界條件下,污染物從包氣帶到含水層以及沿含水層運(yùn)動(dòng)的整個(gè)過(guò)程中濃度的變化,并應(yīng)用Excel VBA編程實(shí)現(xiàn)相應(yīng)的溶質(zhì)運(yùn)移解析模型的可視化操作界面。旨在服務(wù)《環(huán)境影響評(píng)價(jià)技術(shù)導(dǎo)則地下水環(huán)境》實(shí)施,為水文地質(zhì)條件單一,地下水流穩(wěn)定區(qū)域的地下水環(huán)境影響評(píng)價(jià)提供一種簡(jiǎn)單有效的方法,同時(shí)為法規(guī)模型在地下水飲用水源保護(hù)、地下水污染防治規(guī)劃等領(lǐng)域中提供支持。解析解還可以用于驗(yàn)證數(shù)值解的可靠性。在復(fù)雜的水文地質(zhì)系統(tǒng),解析解也非常有用,它可以估算溶質(zhì)的擴(kuò)散速度,對(duì)于數(shù)據(jù)的收集和水質(zhì)監(jiān)測(cè)具有重要意義。
[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.
【學(xué)位授予單位】:中國(guó)地質(zhì)大學(xué)(北京)
【學(xué)位級(jí)別】:碩士
【學(xué)位授予年份】:2015
【分類(lèi)號(hào)】:X523;X824

【參考文獻(xiàn)】

相關(guān)期刊論文 前2條

1 魏青軍;劉平;;基于EXCEL的函數(shù)功能實(shí)現(xiàn)地下水的質(zhì)量評(píng)判[J];地下水;2007年02期

2 黃金廷;尹立河;王曉勇;董佳秋;馬洪云;張俊;;包氣帶垂向滲透系數(shù)的原位試驗(yàn)研究[J];水資源與水工程學(xué)報(bào);2013年05期



本文編號(hào):2173807

資料下載
論文發(fā)表

本文鏈接:http://sikaile.net/kejilunwen/huanjinggongchenglunwen/2173807.html


Copyright(c)文論論文網(wǎng)All Rights Reserved | 網(wǎng)站地圖 |

版權(quán)申明:資料由用戶(hù)9d43b***提供,本站僅收錄摘要或目錄,作者需要?jiǎng)h除請(qǐng)E-mail郵箱bigeng88@qq.com