用EXCEL进行精密度-偏性分析质控数据处理

利用EXCEL强大的数据处理功能，可以方便地对精密度—偏性分析质控数据进行处理，具有较高的推广价值。     

阿图什市空气质量变化趋势分析

分析了阿图什市“八五”至“九五”期间空气质量监测数据不同年度、不同季节及不同污染因子的动态变化趋势．结合当地能源结构、气候特征、城市环境综合发展水平，指出影响阿图什市空气质量的主要因素，为防治和减轻阿图什市的空气污染提供了科学依据。     

How and why is Aquatic Quality Changing at Nahanni National Park Reserve, nwt, Canada?

Nahanni National Park Reserve is located at southwestern NWT-Yukon border. One of the first UNESCO World Heritage sites, Nahanni lies within Taiga Cordillera and Taiga Shield Ecozones. Base and precious metal mining occurred upstream of Nahanni prior to park establishment. Nahanni waters, sediments, fish, and caribou have naturally elevated metals levels. Baseline water, sediment and fish tissue quality data were collected and analyzed throughout Nahanni during 1988–91 and 1992–97. These two programs characterized how aquatic quality variables are naturally varying in space and time, affected by geology, stream flow, seasonality, and extreme meteorological and geological events. Possible anthropogenic causes of aquatic quality change were examined. Measured values were compared to existing Guidelines and site-specific objectives were established.     

Economic development and environmental protection: an ecological economics perspective

This paper argues on both theoretical and empirical grounds that, beyond a certain point, there is an unavoidable conflictbetween economic development (generally taken to mean 'materialeconomic growth') and environmental protection. Think for a moment of natural forests, grasslands, marine estuaries, salt marshes, and coral reefs; and of arable soils, aquifers, mineraldeposits, petroleum, and coal. These are all forms of 'natural capital' that represent highly-ordered self-producing ecosystemsor rich accumulations of energy/matter with high use potential (low entropy). Now contemplate despoiled landscapes, eroding farmlands, depleted fisheries, anthropogenic greenhouse gases,acid rain, poisonous mine tailings and toxic synthetic compounds.These all represent disordered systems or degraded forms of energy and matter with little use potential (high entropy). The main thing connecting these two states is human economic activity. Ecological economics interprets the environment-economyrelationship in terms of the second law of thermodynamics. The second law sees economic activity as a dissipative process. Fromthis perspective, the production of economic goods andservices invariably requires the consumption of available energy and matter. To grow and develop, the economynecessarily 'feeds' on sources of high-quality energy/matter first produced by nature. This tends to disorder and homogenizethe ecosphere, The ascendance of humankind has consistently been accompanied by an accelerating rate of ecological degradation, particularly biodiversity loss, the simplificationof natural systems and pollution. In short, contemporary political rhetoric to the contrary, the prevailing growth-oriented global development paradigm is fundamentally incompatible with long-term ecological and social sustainability. Unsustainability is not a technical nor economic problem as usually conceived, but rather a state of systemic incompatibilitybetween a economy that is a fully-contained, growing, dependent sub-system of a non-growing ecosphere. Potential solutions fly inthe face of contemporary development trends and cultural values.     

Water Quality Evaluation and Trend Analysis in Selected Watersheds of the Atlantic Region of Canada

Water quality indices (WQIs) have been developed to assess the suitability of water for a variety of uses. These indices reflect the status of water quality in lakes, streams, rivers, and reservoirs. The concept of WQIs is based on a comparison of the concentration of contaminants with the respective environmental standards. The number, frequency, and magnitude by which the environmental standards for specific variables are not met in a given time period are reflected in WQIs. Further, the water quality trend analysis predicts the behavior of the water quality parameters and overall water quality in the time domain. In this paper, the concept of WQI was applied to three selected watersheds of Atlantic region: the Mersey River, the Point Wolfe River, and the Dunk River sites. To have robust study, two different water quality indices are used: Canadian Water Quality Index (CWQI), and British Columbia Water Quality Index (BWQI). The complete study was conducted in two steps. The first step was to organize and process the data into a format compatible with WQI analysis. After processing the input data, the WQI was calculated. The second step outlined in the paper discusses detailed trend analysis using linear and quadratic models for all the three sites. As per the 25 years trend analysis, overall water quality for agriculture use observed an improving trend at all the three sites studied. Water quality for raw water used for drinking (prior to treatment) and aquatic uses has shown improving trend at Point Wolfe River. It is further observed that pH, SO₄, and NO₃ concentrations are improving at Dunk River, Mersey River, and Point Wolfe River sites. To ascertain the reliability and significance of the trend analysis, a detailed error analysis and parametric significance tests were also conducted It was observed that for most of the sites and water uses quadratic trend models were a better fit than the linear models.     

Application of the benthic index of biotic integrity to environmental monitoring in Chesapeake Bay

The Chesapeake Bay benthic index of biotic integrity (B-IBI) was developed to assess benthic community health and environmental quality in Chesapeake Bay. The B-IBI provides Chesapeake Bay monitoring programs with a uniform tool with which to characterize bay-wide benthic community condition and assess the health of the Bay. A probability-based design permits unbiased annual estimates of areal degradation within the Chesapeake Bay and its tributaries with quantifiable precision. However, of greatest interest to managers is the identification of problem areas most in need of restoration. Here we apply the B-IBI to benthic data collected in the Bay since 1994 to assess benthic community degradation by Chesapeake Bay Program segment and water depth. We used a new B-IBI classification system that improves the reliability of the estimates of degradation. Estimates were produced for 67 Chesapeake Bay Program segments. Greatest degradation was found in areas that are known to experience hypoxia or show toxic contamination, such as the mesohaline portion of the Potomac River, the Patapsco River, and the Maryland mainstem. Logistic regression models revealed increased probability of degraded benthos with depth for the lower Potomac River, Patapsco River, Nanticoke River, lower York River, and the Maryland mainstem. Our assessment of degradation by segment and water depth provided greater resolution of relative condition than previously available, and helped define the extent of degradation in Chesapeake Bay.     

Selecting Socio-Economic Metrics for Watershed Management

The selection of social and economic metrics to document baseline conditions and analyze the dynamic relationships between ecosystems and human communities are important decisions for scientists, managers, and watershed citizens. A large variety of social and economic data is available but these have limited use without theoretical frameworks. In this paper, several frameworks for reviewing social-ecosystem relations are offered, namely social sanctions, sense of place, civic structure, and cultural differences. Underlying all of these frameworks are attitudes, beliefs, values, and norms that affect which questions are asked and which indicators are chosen. Much work and significant challenges remain in developing a standard set of spatially based socio-economic metrics for watershed management.     

Linking Land Cover and Water Quality in New York City’S Water Supply Watersheds

The Catskill/Delaware reservoirs supply 90% of New York City’s drinking water. The City has implemented a series of watershed protection measures, including land acquisition, aimed at preserving water quality in the Catskill/Delaware watersheds. The objective of this study was to examine how relationships between landscape and surface water measurements change between years. Thirty-two drainage areas delineated from surface water sample points (total nitrogen, total phosphorus, and fecal coliform bacteria concentrations) were used in step-wise regression analyses to test landscape and surface-water quality relationships. Two measurements of land use, percent agriculture and percent urban development, were positively related to water quality and consistently present in all regression models. Together these two land uses explained 25 to 75% of the regression model variation. However, the contribution of agriculture to water quality condition showed a decreasing trend with time as overall agricultural land cover decreased. Results from this study demonstrate that relationships between land cover and surface water concentrations of total nitrogen, total phosphorus, and fecal coliform bacteria counts over a large area can be evaluated using a relatively simple geographic information system method. Land managers may find this method useful for targeting resources in relation to a particular water quality concern, focusing best management efforts, and maximizing benefits to water quality with minimal costs.The United States Environmental Protection Agency through its Office of Research and Development funded and managed the research described here. It has been subjected to Agency’s administrative review and approved for publication as an EPA document.     

Evaluation of Water Quality in the Chillán River (Central Chile) Using Physicochemical Parameters and a Modified Water Quality Index

The Chillán River in Central Chile plays a fundamental role in local society, as a source of irrigation and drinking water, and as a sink for urban wastewater. In order to characterize the spatial and temporal variability of surface water quality in the watershed, a Water Quality Index (WQI) was calculated from nine physicochemical parameters, periodically measured at 18 sampling sites (January–November 2000). The results indicated a good water quality in the upper and middle parts of the watershed. Downstream of the City of Chillán, water quality conditions were critical during the dry season, mainly due to the effects of the urban wastewater discharge. On the basis of the results from a Principal Component Analysis (PCA), modifications were introduced into the original WQI to reduce the costs associated with its implementation. WQI_DIR2 and WQI_DIR, which are both based on a laboratory analysis (Chemical Oxygen Demand) and three (pH, temperature and conductivity), respectively, four field measurements (pH, temperature, conductivity and Dissolved Oxygen), adequately reproduce the most important spatial and temporal variations observed with the original index. They are proposed as useful tools for monitoring global water quality trends in this and other, similar agricultural watersheds in the Chilean Central Valley. Possibilities and limitations for the application of the used methodology to watersheds in other parts of the world are discussed.     

Prediction of Leachate Level in Kimpo Metropolitan Landfill Site by Total Water Balance

Kimpo metropolitan landfill has received various kinds of wastessince January 1992. The leachate level was measured to be 10.3 m in May 1995 and the level increased to 12.2 m in August 1996. Therefore, to prove the reason for the increasing leachate level, we calibrated hydraulic conductivity of each waste andintermediate layer using the HELP (Hydrologic Evaluation ofLandfill Performance) model. The leachate generation data measured from February 1993 to October 1995 was used in the model calibration. As a result of a model calibration, we obtained anaverage infiltration ratio and used this in analysis of the total water balance to predict elevation of leachate level. Main causes of the elevation of the leachate level were the high water content of the waste and the degradation of the leachate-drainage system caused by the subsidence of a naturalbarrier layer.