一种快速实现比较分析的方法

比较分析法是监测部门分析数据的常用方法,使用EXCEL的数据库和列表函数可方便快捷地获得复杂条件下同比、环比或其它比较分析的结果。掌握EXCEL的单元格引用,可极大减轻大量重复类型公式的输入,迅速地完成数据比较分析。以城市环境空气监测数据的比较分析为例,展示了一种快速实现比较分析的方法与步骤。     

一种大气质量评价方法的改进及应用

将模糊数学应用于上海指数法 ,在评价函数中引入半梯形隶属函数和倍斜率隶属函数 ,提出模糊上海指数法 ;将此法应用于延安市的大气质量评价工作 ,与欧几里德贴近度法和上海指数法的评价结果进行比较表明 ,模糊上海指数法的评价结果是科学合理的。     

包头南海湖浮游植物优势种生态位及种间联结性季节分析

为了解寒旱区浮游植物群落年内结构变化和演替规律及其优势种的联结性,于2017年12月~2018年11月对包头市南海湖的浮游植物群落进行了调查分析.共鉴定出浮游植物7门66属151种,其中浮游植物优势种有4门15属15种,其种类和丰度随季节而变化.运用改进的Levins公式和Petraitis指数测定浮游植物优势种的生态位量度,发现不同季节各优势种的生态位宽度和生态位重叠不尽相同,各优势种对环境因子的适应能力也存在较大差异,在年内各种生境条件下,微小平裂藻生态位变化幅度最显著,依此认为微小平裂藻可作为南海湖水体污染状态指示种,且有可靠的生态学依据.生态位重叠值中ΔSO_ij值表示物种发展趋势,可第一时间反映南海湖水质是否受到外来因素干扰.群落物种相关性、种间联结性检验结果显示,南海湖浮游植物种间联结性总体上呈正关联关系,128对优势种对中仅有10对显现显著联结性,可见南海湖群落种间联结不紧密,群落结构不稳定,处于演替的初、中期阶段.     

Exploration of relationships between phytoplankton biomass and related environmental variables using multivariate statistic analysis in a eutrophic shallow lake:A 5-year study

Understanding the process of the changing phytoplankton patterns can be particularly useful in water quality improvement and management decisions.However,it is generally not easy to illustrate the interactions between phytoplankton biomass and related environmental variables given their high spatial and temporal heterogeneity.To elucidate relationships between them,in a eutrophic shallow lake,Taihu Lake,relative long-term data set of biotic and abiotic parameters of water quality in the lake were conducted using multivariate statistical analysis within seasonal periodicity.The results indicate that water temperature and total phosphorus(TP)played governing roles in phytoplankton dynamics in most seasons(i.e.temperature in winter,spring and summer; TP in spring,summer and autumn); COD(chemical oxygen demand)and BOD(biological oxygen demand)presented significant positive relationships with phytoplankton biomass in spring,summer and autumn.However,a complex interplay was found between phytoplankton biomass and nitrogen considering significant positive relationships occurring between them in spring and autumn,and conversely negative ones in summer.As the predatory factor,zooplankton presented significant grazing-pressure on phytoplankton biomass during summer in view of negative relationship between them in the season.Significant feedback effects of phytoplankton development were identified in summer and autumn in view that significant relationships were observed between phytoplankton biomass and pH,Trans(transparency of water)and DO.The results indicate that interactions between phytoplankton biomass and related environmental variables are highly sensitive to seasonal periodicity,which improves understanding of different roles of biotic and abiotic variables upon phytoplankton variability,and hence,advances management methods for eutrophic lakes.     

石化园区周边农田土壤重金属污染分析与评价

以某化工园区附近300km2区域为研究区,采用辐射状精确布点,采集表层土壤样品共计200个,以该区土壤环境自然背景值和《国家土壤环境质量标准》(GB15618-1995)二级标准值为评价标准,对土壤重金属Cd、Cr、Cu、Ni、Pb、Zn、Hg和As的污染进行了分析评价.结果表明,以自然背景值为评价标准,研究区表层土壤中Cd、Hg、Cu和Pb平均含量超过自然背景值,其中,Cd为首要污染因子;以国标二级标准为评价标准,除Cd和Hg以外的6种重金属的单项污染指数平均值均小于1,Cd仍是研究区表层土壤重金属污染的主要因子.化工区西北和西南方向农田土壤重金属含量变化表明,随着与化工区距离的增加,农田土壤中Cd、Cr、Cu、Ni、Pb、Zn和Hg的含量呈显著下降趋势.采用相关分析和主成分分析研究区内土壤中重金属的来源,主因子1和主因子2的贡献率分别为65.23%、19.93%,前者反映土壤中重金属Cd、Cr、Cu、Pb、Zn和Hg积累的差异,并主要与人类活动有关;后者体现了Ni和As的变化,主要与成土母质有关.     

Exploration of relationships between phytoplankton biomass and related environmental variables using multivariate statistic analysis in a eutrophic shallow lake： A S-year study

Understanding the process of the changing phytoplankton patterns can be particularly useful in water quality improvement and management decisions. However, it is generally not easy to illustrate the interactions between phytoplankton biomass and related environmental variables given their high spatial and temporal heterogeneity. To elucidate relationships between them, in a eutrophic shallow lake, Taihu Lake, relative long-term data set of biotic and abiotic parameters of water quality in the lake were conducted using multivariate statistical analysis within seasonal periodicity. The results indicate that water temperature and total phosphorus （TP） played governing roles in phytoplankton dynamics in most seasons （i.e. temperature in winter, spring and summer; TP in spring, summer and autumn）; COD （chemical oxygen demand） and BOD （biological oxygen demand） presented significant positive relationships with phytoplankton biomass in spring, summer and autumn. However, a complex interplay was found between phytoplankton biomass and nitrogen considering significant positive relationships occurring between them in spring and autumn, and conversely negative ones in summer. As the predatory factor, zooplankton presented significant grazing-pressure on phytoplankton biomass during summer in view of negative relationship between them in the season. Significant feedback effects of phytoplankton development were identified in summer and autumn in view that significant relationships were obser,qed between phytoplankton biomass and pH, Trans （transparency of water） and DO. The results indicate that interactions between phyto：plankton biomass and related environmental variables are highly sensitive to seasonal periodicity, which improves understanding of different roles of biotic and abiotic variables upon phytoplankton variability, and hence, advances management methods for eutrophic lakes.     

应用淡水生物毒性数据推导海水水质基准的可行性及适用性初探

在海洋环境风险评价及环境标准与基准的制定中,由于海水生物毒性数据的欠缺,通常引入淡水数据加以补充,以此推导海水的预测无效应浓度(PNEC),但该方法所推导PNEC的"失真"程度目前尚未完全清晰。本研究选取了Pb、Cd、马拉硫磷和狄氏剂四种典型化合物,应用SSD模型方法比较分析了分别基于淡水生物和海水生物以及二者一并使用推导的PNEC值之间的差异性和相关性。结果发现:淡水生物与海水生物对各化合物响应的敏感性具有一定的差异。对于重金属,淡水物种可能对其胁迫更具敏感性,将淡水数据与海水数据一并使用所获得PNEC可有效的保护海洋生物;对于有机磷和有机氯农药,海水生物通常更具敏感性,淡水数据的介入和应用可能会对部分海洋生物造成部分"欠保护"现象,但总体上,淡水HC5与海水HC5二者相差不大,可通过适当的安全因子加以校正。     

Effect of humic acids and sunlight on the cytotoxicity of engineered zinc oxide and titanium dioxide nanoparticles to a river bacterial assemblage

The effect of a terrestrial humic acid (HA) and Suwannee River HA on the cytotoxicity of engineered zinc oxide nanoparticles (ZnONPs) and titanium dioxide nanoparticles (TiO2NPs) to natural aquatic bacterial assemblages was measured with spread plate counting. The effect of HA (10 and 40 ppm) on the cytotoxicity of ZnONPs and TiO2NPs was tested factorially in the presence and absence of natural sunlight (light irradiation (LI)). The experiment was of full factorial, completely randomized design and the results were analyzed using the General Linear Model in SAS analytical software. The method of least squares means was used to separate the means or combinations of means. We determined the mechanism of toxicity via measurements of oxidative stress and metal ions. The toxicity of ZnONPs and TiO2NPs to natural aquatic bacterial assemblages appears to be concentration dependent. Moreover, the cytotoxicity of ZnONPs and TiO2NPs appeared to be affected by HA concentration, the presence of sunlight irradiation, and the dynamic multiple interactions among these factors. With respect to light versus darkness in the control group, the data indicate that bacterial viability was inhibited more in the light exposure than in the darkness exposure. The same was true in the HA treatment groups. With respect to terrestrial versus Suwanee River HA for a given nanoparticle, in light versus darkness, bacterial viability was more inhibited in the light treatment groups containing the terrestrial HA than in those containing Suwanee River HA. Differences in the extent of reactive oxygen species formation, adsorption/binding of ZnONPs/TiO2NPs by HA, and the levels of free metal ions were speculated to account for the observed cytotoxicity. TEM images indicate the attachment and binding of the tested nanoparticles to natural bacterial assemblages. Besides the individual parameter, significant effects on bacterial viability count were also observed in the following combined treatments: HA-ZnONPs, HA-LI, ZnONPs-LI, and HA-ZnONPs-LI. The main effects of all independent variables, plus interaction effects in all cases were significant with TiO2NPs.     

基于输出系数法及土地利用方式识别的营养盐空间负荷解析—以十堰市为例

在过去的几十年里,我国氮肥和磷肥的施用量增长显著。然而,过量的营养物质也导致内陆和沿海水域水体富营养化问题。氮、磷营养盐的控制通常被认为是减少湖泊富营养化和蓝藻水华的重要组成部分。目前,准确识别营养物质的来源和定量分析过量营养物质浓度在空间上的表现仍需要特别关注。根据十堰市污染物统计及生态环境部门相关监测数据,通过输出系数法及土地利用方式识别,分析了氮、磷营养盐来源及其空间负荷分布。结果表明：十堰市总氮、总磷均主要来源于面源,占比分别为81.84%和80.08%,点源占比较小。其中总氮污染负荷主要来源于农田径流污染源,占45.72%,其次是干湿沉降污染源,占11.43%;总磷污染负荷也主要来源于农田径流污染源,占30.51%,其次是水土流失污染源,占22.28%。总氮入河负荷强度最高为22.71 t/km²,总磷入河负荷强度最高为5.22 t/km²。

     

Monitoring bioaccumulation and toxic e ects of hexachlorobenzene using the polyurethane foam unit method in the microbial communities of the Fuhe River,Wuhan

Hexachlorobenzene （HCB） is a chlorinated aromatic hydrocarbon that was widely used for seed dressing in prevention of fungal growth on crops, and also as a component of fireworks, ammunition, and synthetic rubbers. Because of its resistance to degradation and mobility, HCB is widely distributed throughout the environment and is accumulated through food chains in different ecosystems. In this study, a preliminary investigation was carried out on the bioaccumulation and the toxic effects of HCB in the microbial （protozoan in particular） communities in the Fuhe River, Wuhan, a water body receiving industrial wastewaters containing HCB and other pollutants, using the standardized polyurethane foam units （PFU） method. Field samples were taken from eight stations established along the Fuhe River in January and August 2006. The concentration ratios of HCB in microbial communities and in water were 9.66-18.64, and the microbial communities accumulated 13.29-56.88 μg/L of HCB in January and 0.82-10.25 μg/L HCB in August. Correlation analysis showed a negative correlation between the HCB contents in the microbial assemblage, and the number of species and the diversity index of the protozoan communities. This study demonstrated the applicability of the PFU method in monitoring the effects of HCB on the level of microbial communities.