运用Excel函数汇总环境臭气样品嗅辨数据

本文以环境臭气样品的嗅辨分析数据为例。通过办公软件Excel中的If．Countif,And、Max等函数的嵌套应用,实现环境臭气样品嗅辨数据的自动统计并得出分析结果。     

多源专题数据在国家重点生态功能区生态环境状况评价中的应用

为了建立一套生态遥感快速监测方法,实现生态环境状况评价,以2015年广西40个国家重点生态功能区为例,以全国第一次地理国情普查、高分影像、地貌为基础数据,利用RPC模型及网络刺点进行影像纠正,使用空间分析等程序化处理方法进行代码转换和信息抽取,实现了广西国情普查成果转化,得到了2014年和2015年生态遥感数据,形成一套较为完整的生态遥感快速监测方法,最终得到2015年全区重点生态功能县生态环境状况指数, 40个重点生态功能县中有15个县生态环境质量状况等级为"优",25个为"良"。     

Trait groups as management entities in a complex,multispecies reef fishery

Localized stressors compound the ongoing climate-driven decline of coral reefs, requiring natural resource managers to work with rapidly shifting paradigms. Trait-based adaptive management (TBAM) is a new framework to help address changing conditions by choosing and implementing management actions specific to species groups that share key traits, vulnerabilities, and management responses. In TBAM maintenance of functioning ecosystems is balanced with provisioning for human subsistence and livelihoods. We first identified trait-based groups of food fish in a Pacific coral reef with hierarchical clustering. Positing that trait-based groups performing comparable functions respond similarly to both stressors and management actions, we ascertained biophysical and socioeconomic drivers of trait-group biomass and evaluated their vulnerabilities with generalized additive models. Clustering identified 7 trait groups from 131 species. Groups responded to different drivers and displayed divergent vulnerabilities; human activities emerged as important predictors of community structuring. Biomass of small, solitary reef-associated species increased with distance from key fishing ports, and large, solitary piscivores exhibited a decline in biomass with distance from a port. Group biomass also varied in response to different habitat types, the presence or absence of reported dynamite fishing activity, and exposure to wave energy. The differential vulnerabilities of trait groups revealed how the community structure of food fishes is driven by different aspects of resource use and habitat. This inherent variability in the responses of trait-based groups presents opportunities to apply selective TBAM strategies for complex, multispecies fisheries. This approach can be widely adjusted to suit local contexts and priorities.