农业面源污染论文：全国种植业污染物流失系数测算系统研究与实现

农业面源污染 论文 政研论文下载论文大学下载论文大学下载关于长拳的论文浙大论文封面下载 ：全国种植业污染物流失系数测算系统研究与实现 【中文摘要】我国水污染急剧恶化,主要表现为地表水的富营养化和地下水的硝酸盐污染。水污染的核心问题是水体的氮磷富营养化,水体富营养化的主要原因是农业面源污染。种植业污染物流失是农业面源污染的重要组成部分,为彻底弄清种植业污染物流失在农业面源污染中的比重,从2007年开始,农业部、环保部联合进行了全国面源污染普查和监测。普查和监测数据一直采用人工方式进行采集、分析和处理,存在效率低、可靠性差等问题。论文研究了全国种植业污染物流失系数测算项目中数据采集、统计、汇总等数据处理方法,设计并实现了基于网络的全国种植业污染物流失系数测算系统,首次将田间监测数据与实验室测试数据采集、统计、汇总、分析等功能全面集成,实现了监测数据的网络化、自动化,提高了面源污染监测数据处理的有效性、可靠性。主要研究内容和结果如下:(1)分析种植业污染监测数据人工采集中存在的问题,研究了监测数据采集与处理涉及的内容和数据采集与处理 流程 快递问题件怎么处理流程河南自建厂房流程下载关于规范招聘需求审批流程制作流程表下载邮件下载流程设计 ,提出了网络化的数据采集模式,实现了基于网络的远程数据采集,解决了监测数据手工上报、汇总中存在的诸多问题。(2)分析了田间试验监测数据和实验室测试数据特征,研究了以Mysql为工具,实现了数据的组织与管理,并通过视图和存储过程完成了大量数据的汇总统计功能。(3)分析了田间试验监测数据和实验室测试数据取值特点,研究了利用Excel强大的VBA编程功能,实现在Excel环境下对数据进行三重校验的方法和技术。(4)分析了全国种植业污染物流失系数项基本需求,研究了基于网络环境下的全国种植业污染监测平台架构、功能和实现技术,并按照软件工程思想啊和模块化设计方法完成了系统设计,实现了监测数据的远程半自动化采集、统计分析和Excel报表的导入导出等功能。论文论述了以Windows XP为平台,JSP+Mysql为编程技术,设计并实现基于B/S结构的全国种植业污染物流失系数测算系统的思想、方法和相关技术。系统经测试分析表明,可以满足种植业污染监测数据分析处理的应用需求,在提高监测数据采集的有效性、可靠性以及计算结果的准确性等方面,具有突出的优势,已经被全面应用于农业部行业专项——主要农区农业面源污染监测与氮磷投入阈值研究项目中,取得了较好的应用效果。 【英文摘要】Water pollution in domestic China deteriorates rapidly, mainly reflected as eutrophication of surface water and groundwater nitrate contamination. The core problem of water pollution is nitrogen and phosphorus eutrophication of water substance, which is mainly due to agricultural non-point source pollution. The loss of tillage farming pollution is an important component of agricultural non-point source pollution. In order to find out the weighingof the loss of crop contamination in the agricultural non-point source pollution, the Ministry of Agriculture and Ministry of Environmental Protection have jointly conducted a national non-point source pollution investigation and monitoring since 2007. The data out of the investigation have been collected, analyzed and processed manually, which are featured with problems such as low efficiency, poor reliability, etc.The present research explored the data processing methods, such as data collection, statistics, aggregation, etc. in the national pollutant loss coefficient estimates project, designed and implemented a national web-based tillage farming pollutant loss coefficient estimate system, took initiative to fully integrate field monitoring data with functions such as laboratory test data collection, statistics, compilation and analysis, etc. achieved the networking and automation in monitoring data, improved the effectiveness and reliability of data processing in monitoring non-point source pollution. The main research questions and results are as follows:(1) The study analyzed the problems in monitoring data manual collection, explored the process of content and data acquisition and processing involved in data collection and monitoring research, proposed the network model of data collection, achieved network-based remote data acquisition, solved many problems existing in monitoring data manual report and summary.(2) The research integrated the features of field testing monitoring data and laboratory test data, designed database by using Mysql, and completed a large amount of data summary statistics via views and storing process. (3) The present study exploited the powerful VBA programming function in Excel, combined data acquisition features of the project and achieved the data triple checking function in Excel.(4) The research explored web-based system architecture, system functions and implementation techniques, completed system design according to the modular design idea, implemented monitoring data collection, statistical analysis and reporting of import and export Excel functions, etc.The paper discussed the B/S structure, adopted JSP + Mysql programming technique, developed and explored a national pollutant loss coefficient estimates farming system and its process in Windows XP platform. System test analysis shows that the software system could meet the growing applications requirements of tillage farming pollution monitoring data analysis and processing, improved the effectiveness of monitoring data processing and reliability. It has been applied in the Ministry of Agriculture special project—main agricultural non-point source pollution monitoring nitrogen and phosphorus inputs threshold quantity research, and achieved good application effect. 【关键词】农业面源污染 Excel数据校验 数据采集 数据分析 信息系统 【英文关键词】agricultural non-point source pollution      Excel data validation      data collection      data analysis      information system 【备注】索购全文在线加我： 1399388.48 同时提供论文写作指导和论文发表委托服务 【目录】全国种植业污染物流失系数测算系统研究与实现摘要5-6ABSTRACT6-7第一章 绪论10-171.1 研究背景及意义10-111.2 国内外研究现状11-121.3 研究内容12-151.3.1 种植业源污染的普查技术路线121.3.2 种植业源污染的普查监测分区12-141.3.3 种植业源污染的普查监测布局14-151.3.4 目前数据处理存在的问题151.4 研究的主要内容及方法15-161.4.1 研究的主要内容15-161.4.2 研究方法161.5 论文组织结构16-17第二章 系统需求分析17-222.1 数据采集需求17-182.2 系统数据处理流程18-192.3 功能模块图19-202.4 系统性能分析20-212.5 本章小结21-22第三章 系统数据库设计22-383.1 数据库设计原则223.2 数据库的存储结构22-313.3 系统视图31-323.4 数据库存储过程设计与实现32-363.5 编码规则36-373.5.1 地块代码363.5.2 样品编码36-373.6 本章小结37-38第四章 系统设计与实现38-544.1 系统开发平台384.1.1 开发环境384.1.2 开发技术384.1.3 运行环境384.2 数据录入模块的设计与实现38-464.2.1 单元格级数据校验394.2.2 记录级数据校验39-414.2.3 工作薄级数据校验41-454.2.4 数据录入模块流程45-464.3 数据统计与查询模块设计与实现46-524.3.1 数据统计46-504.3.2 数据查询50-524.4 报表输出模块设计与实现524.5 系统管理模块设计与实现52-534.6 系统测试与评价534.7 本章小结53-54第五章 结论与展望54-55参考文献55-58致谢58-59作者简介59