Excel应用软件在环境监测数据统计分析中的应用

针对环境监测通常需要对大量的监测和检测数据进行统计、处理与分析,且多为重复性计算过程,导致工作量大、人工工作效率低、处理与分析时间长等,以Excel电子表格软件为技术手段,提出了更为精确和方便的修约函数公式,并通过《2010环境质量报告》中水质数据的统计分析对修约函数公式进行了实际验证.结果表明,与普通手工计算方法相比,通过Excel函数的计算,Excel工作表格计算结果更准确,也减少了大量的重复性人工计算过程,节省了工作时间,提高了工作效率,还可通过函数公式自动计算完成因基础数据发生改变(因上报错误或输入错误等)而产生的新分析结果.     

运动环境下FEM-SPH耦合方法钢弹-钢板冲击响应研究

目的研究钢弹冲击钢板的动力学响应。方法采用ABAQUS/Explicit显式有限元分析软件,基于SPH-FEM耦合方法和常规FEM方法对钢弹冲击钢板进行数值模拟,对比两种方法得到的结果。结果用这两种方法模拟得到的钢板Mises应力分布、钢弹速度随时间变化规律及剩余速度基本一致。结论 SPH-FEM耦合方法用于模拟钢板冲击失效过程是可行的。     

石化企业35kV输电线路防雷对策研究

采用ATP-EMTP仿真软件建立有无避雷线输电线路的仿真模型,并考虑接地电阻、档距大小,进行仿真比较.结果表明:杆塔塔顶电压与接地电阻成正比,并呈线性增加,随着电阻值增加,杆塔塔顶电压增加越来越快;当杆塔水平档距小于100 m时,直击杆塔塔顶电压随档距的增加呈线性增长,当档距大于100 m时,杆塔塔顶电压的变化就不明显了;验证35 kV线路全线架设避雷线可有效降低输电线路杆塔塔顶电压幅值,提出石化企业35 kV输电线路应全线架设避雷线.     

2014年-2020年江苏省城镇化的边际资源环境影响预测分析研究

利用历史数据,选取合适计算模型,定量预测了2014年-2020年江苏省城镇化边际资源环境影响,即以与城镇化发展密切相关的资源使用量或者城镇生活污染物排放量较上一年的增量,除以当年城镇化率增量,得到江苏省城镇化水平每提高一个百分点带来的资源环境影响,以期为江苏环境管理及政府综合决策提供切实有效的数据依据.结果表明:未来7年,江苏省城镇化率每上升1个百分点,增加城镇生活用水量约0.5亿立方米、城镇建设用地面积16万亩;增加城镇生活污水排放量1.15亿吨、生活氮氧化物排放量10 228吨、生活垃圾产生量36.4万吨;减少生活COD排放量7 549吨、生活氨氮排放量762吨、生活二氧化硫(SO2)排放量371吨.     

Space-time analysis of the changing patterns of population pressure on the ecological environment in China

This paper examines the temporal change and spatial variation of population pressure on the ecological environment in China. We have collected sufficient data from the statistical yearbooks of 31 provincial administrative areas in 1990, 1995, 2000, 2005, and 2010. Using a geographic information system (GIS) and relevant models, we analyzed the trend of the population pressure on ecological environment and the change of the gravity center of ecological environment quality. We conclude that: (1) generally, population pressure on the ecological environment in China was becoming higher during 1990–2010, especially in some areas where the population and environment were in serious imbalance and the ecological environment experienced severe pollution; (2) during a certain period, population pressure on the ecological environment was becoming lower in some areas, but the ecological environment was getting worse; (3) the areas with super-high population pressure on the ecological environment were Beijing, Tianjin, and Shanghai; (4) the gravity center of population pressure on the ecological environment and the center of ecological environment quality move differently during the study time period, but the general trend was similar – both of them were moving from west to east. Based on the analysis, this paper also provides some policy suggestions on the control of ecological environment quality.     

基于致灾因子指标体系的海冰灾害风险评估和区划方法

中国是世界上受海冰危害严重的国家之一,历史上曾发生过多次严重海冰灾害,造成重大损失。根据我国结冰海区海冰灾害风险的自然过程、社会经济状况和成灾机制,综合考虑致灾因子危险性、承灾体分类、分布及脆弱性以及防灾减灾能力等因素,对海冰灾害发生的可能性及其不确定性等进行综合分析,提出了开展海冰灾害风险评估和区划的理论依据,同时给出了利用致灾因子指标体系对海冰灾害风险进行评估和区划的具体方法。     

Assessment of the Effectiveness of Environmental Dredging in South Lake,China

Environmental dredging is a primary remedial option for removal of the contaminated material from aquatic environment. Of primary concern in environmental dredging is the effectiveness of the intended sediment removal. A 5-year field monitoring study was conducted to assess the effectiveness of the environmental dredging in South Lake, China. The concentrations of total nitrogen (TN), total phosphors, and heavy metals (Zn, Pb, Cd, Cu, Cr, Ni, Hg, and As) before and after dredging in sediment were determined and compared. Multiple ecological risk indices were employed to assess the contamination of heavy metals before and after dredging. Our results showed that the total phosphorus levels reduced 42% after dredging. Similar changes for Hg, Zn, As Pb, Cd, Cu, Cr, and Ni were observed, with reduction percentages of 97.0, 93.1, 82.6, 63.9, 52.7, 50.1, 32.0, and 23.6, respectively, and the quality of sediment improved based on the criterion of Sediment Quality Guidelines by USEPA and contamination degree values (C_d) decreased significantly (paired t-test, p < 0.05). Unexpectedly, the TN increased 49% after dredging compared to before dredging. Findings from the study demonstrated that the environmental dredging was an effective mechanism for removal of total phosphorus and heavy metals from South Lake. Nevertheless, the dredging was ineffective to remove total nitrogen from sediment. We conclude that the reason for the observed increase in TN after dredging was likely ammonia release from the sediment impairing the dredging effectiveness.     

不同施肥方式对东北旱田黑土nirK和nirS型反硝化细菌群落结构的影响及黑土保护建议

反硝化过程是土壤氮素循环的重要过程之一,与土壤氮肥损失和温室气体排放紧密相关。通过分析不同施肥方式对东北旱田黑土nirK型和nirS型反硝化细菌群落结构的影响及其与N₂O排放的关系,证实黑土中nirK型比nirS型反硝化细菌多样性丰富,且更易受土壤理化性质的影响。施入化肥会降低东北旱田黑土反硝化细菌多样性、N₂O释放量和土壤养分含量,而有机肥的施入虽然可提高土壤养分含量,但是也会显著增加土壤反硝化作用,存在潜在的负面环境效应。因此对黑土地的保护要积极推行种养结合,建立可循环农业体系;适当配施有机肥料,调节黑土微生物活力;大力完善相关制度,营造科学管理新规范,从而构建我国黑土保护的立体格局。     

Cultivar-dependent rhizobacteria community and cadmium accumulation in rice: Effects on cadmium availability in soils and iron-plaque formation

The association between the rhizospheric microbial community and Cd accumulation in rice is poorly understood. A field trial was conducted to investigate the different rhizobacterial communities of two rice cultivars with high Cd accumulation (HA) and low Cd accumulation (LA) at four growth stages. Results showed that the Cd content in the roots of the HA cultivar was 1.23 - 27.53 higher than that of the LA cultivar (0.08 - 10.5 µg/plant) at four stages. The LA cultivar had a significantly lower Cd availability in rhizosphere and a higher quantity of iron plaque (IP) on the root surface than the HA cultivar at four stages. This resulted in the reduction of Cd concentration in IPs and Cd translocation from IP-to-root. Microbial analysis indicated that the LA cultivar formed a distinct rhizobacterial community from the HA cultivar and had less α-diversity. The rhizosphere of the LA cultivar was enriched in specific bacterial taxa (e.g., Massilia and Bacillus) involved in Cd immobilization by phosphate precipitation and IP formation by iron oxidization. However, the rhizosphere in the HA cultivar assembled abundant sulfur-oxidizing bacteria (e.g., Sulfuricurvum) and iron reduction bacteria (Geobacter). They promoted Cd mobilization and reduced IP formation via the metal redox process. This study reveals a potential approach in which specific rhizobacteria decrease or increase Cd accumulation in rice on contaminated soil and provides a new perspective for secure rice production.