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

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

乌鲁木齐市餐饮业油烟污染的调查及防治初探

通过对乌鲁木齐市20家餐饮业油烟污染的调查分析，结果表明，乌鲁木齐市餐饮业油烟污染严重，并提出了防治措施。     

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.     

Using improved neural network model to analyze RSP,NOx and NO2 levels in urban air in Mong Kok,Hong Kong

As the health impact of air pollutants existing in ambient addresses much attention in recent years, forecasting of airpollutant parameters becomes an important and popular topic inenvironmental science. Airborne pollution is a serious, and willbe a major problem in Hong Kong within the next few years. InHong Kong, Respirable Suspended Particulate (RSP) and NitrogenOxides NO_x and NO₂ are major air pollutants due to thedominant diesel fuel usage by public transportation and heavyvehicles. Hence, the investigation and prediction of the influence and the tendency of these pollutants are ofsignificance to public and the city image. The multi-layerperceptron (MLP) neural network is regarded as a reliable andcost-effective method to achieve such tasks. The works presentedhere involve developing an improved neural network model, whichcombines the principal component analysis (PCA) technique and theradial basis function (RBF) network, and forecasting thepollutant levels and tendencies based in the recorded data. Inthe study, the PCA is firstly used to reduce and orthogonalizethe original input variables (data), these treated variables arethen used as new input vectors in RBF neural network modelestablished for forecasting the pollutant tendencies. Comparingwith the general neural network models, the proposed modelpossesses simpler network architecture, faster training speed,and more satisfactory predicting performance. This improvedmodel is evaluated by using hourly time series of RSP, NO_x and NO₂ concentrations collected at Mong Kok Roadside Gaseous Monitory Station in Hong Kong during the year 2000. By comparing the predicted RSP, NO_x and NO₂ concentrationswith the actual data of these pollutants recorded at the monitorystation, the effectiveness of the proposed model has been proven.Therefore, in authors' opinion, the model presented in the paper is a potential tool in forecasting air quality parameters and hasadvantages over the traditional neural network methods.     

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.     

一次监测值用于水质评价的研究

以2003年长江和淮河水系为例,通过计算各个评价项目的单月监测值分别与季均值和年均值的相对误差及其分布,以及水质类别相同的断面比例,认为对于旬报、月报短期水质评价,采用一次监测的数据评价水质是可靠的;对于季报和年报中、长期水质评价,采用一次监测数据评价的可靠程度较差,应采用2次或2次以上的监测数据平均值进行评价。     

辽河流域浑河沈阳段地表水重点控制有机污染物的筛选

采用美国环保局工业环境实验室提出的化学物质的“潜在危害指数法”,对辽河流域浑河沈阳段地表水和底质中检出的有机污染物的潜在危害进行了排序,参考国内外有毒化学品优先控制名单的筛选原则和方法,结合本流域的实际情况,制定出重点控制有机污染物的评分标准,提出辽河流域浑河沈阳段重点控制有机污染物名单。考虑到个别有机污染物在水中的浓度很低,但在底质中相对含量较高,所以将底质的检测结果也纳入评分标准。     

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.     

Sulphate, Nitrogen and Base Cation Budgets at 21 Forested Catchments in Canada, the United States and Europe

To assess the concern over declining base cation levels in forest soils caused by acid deposition, input-output budgets (1990s average) for sulphate (SO₄), inorganic nitrogen (NO₃-N; NH₄-N), calcium (Ca), magnesium (Mg) and potassium (K) were synthesised for 21 forested catchments from 17 regions in Canada, the United States and Europe. Trend analysis was conducted on monthly ion concentrations in deposition and runoff when more than 9 years of data were available (14 regions, 17 sites). Annual average SO₄ deposition during the 1990s ranged between 7.3 and 28.4 kg ha⁻¹ per year, and inorganic nitrogen (N) deposition was between 2.8 and 13.8 kg ha⁻¹ per year, of which 41–67% was nitrate (NO₃-N). Over the period of record, SO₄ concentration in deposition decreased in 13/14 (13 out of 14 total) regions and SO₄ in runoff decreased at 14/17 catchments. In contrast, NO₃-N concentrations in deposition decreased in only 1/14 regions, while NH₄-N concentration patterns varied; increasing at 3/14 regions and decreasing at 2/14 regions. Nitrate concentrations in runoff decreased at 4/17 catchments and increased at only 1 site, whereas runoff levels of NH₄-N increased at 5/17 catchments. Decreasing trends in deposition were also recorded for Ca, Mg, and K at many of the catchments and on an equivalent basis, accounted for up to 131% (median 22%) of the decrease in acid anion deposition. Base cation concentrations in streams generally declined over time, with significant decreases in Ca, Mg and K occurring at 8, 9 and 7 of 17 sites respectively, which accounted for up to 133% (median 48%) of the decrease in acid anion concentration. Sulphate export exceeded input at 18/21 catchments, likely due to dry deposition and/or internal sources. The majority of N in deposition (31–100%; median 94%) was retained in the catchments, although there was a tendency for greater NO₃-N leaching at sites receiving higher (<7 kg ha^-1 per year) bulk inorganic N deposition. Mass balance calculations show that export of Ca and Mg in runoff exceeds input at all 21 catchments, but K export only exceeds input at 16/21 sites. Estimates of base cation weathering were available for 18 sites. When included in the mass balance calculation, Ca, Mg and K exports exceeded inputs at 14, 10 and 2 sites respectively. Annual Ca and Mg losses represent appreciable proportions of the current exchangeable soil Ca and Mg pools, although losses at some of the sites likely occur from weathering reactions beneath the rooting zone and there is considerable uncertainty associated with mineral weathering estimates. Critical loads for sulphur (S) and N, using a critical base cation to aluminium ratio of 10 in soil solution, are currently exceeded at 7 of the 18 sites with base cation weathering estimates. Despite reductions in SO₄ and H⁺ deposition, mass balance estimates indicate that acid deposition continues to acidify soils in many regions with losses of Ca and Mg of primary concern. The U.S. Government's right to retain a non-exclusive, royalty free licence in and to any copyright is acknowledged. The Canadian Crown reserves the right to retain a non-exclusive, royalty free licence in and to any copyright.