用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.     

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.     

A pilot project to detect and forecast harmful algal blooms in the northern Gulf of Mexico

More timely access to data and information on the initiation, evolution and effects of harmful algal blooms can reduce adverse impacts on valued natural resources and human health. To achieve this in the northern Gulf of Mexico, a pilot project was initiated to develop a user-driven, end-to-end (measurements to applications) observing system. A key strategy of the project is to coordinate existing state, federal and academic programs at an unprecedented level of collaboration and partnership. Resource managers charged with protection of public health and aquatic resources require immediate notice of algal events and a forecast of when, where and what adverse effects will likely occur. Further, managers require integrated analyses and interpretations, rather than raw data, to make effective decisions. Consequently, a functional observing system must collect and transform diverse measurements into usable forecasts. Data needed to support development of forecasts will include such properties as sea surface temperature, winds, currents and waves; precipitation and freshwater flows with related discharges of sediment and nutrients; salinity, dissolved oxygen, and chlorophyll concentrations (in vivo fluorescence); and remotely-sensed spatial images of sea surface chlorophyll concentrations. These data will be provided via a mixture of discrete and autonomous in situ sensing with near real-time data telemetry, and remote sensing from space (SeaWiFS), aircraft (hyperspectral imagery) or land (high-frequency radar). With calibration across these platforms, the project will ultimately provide a 4-dimensional visualization of harmful algae events in a time frame suitable to resource managers.     

Trihalomethanes in Drinking Water of Greater Québec Region (Canada): Occurrence, Variations and Modelling

The levels of trihalomethanes (THMs) – the main species of by-product from water chlorination – were monitored in thedistribution systems of the five major drinking water utilitiesof the greater area of Québec City in order to investigate andmodel their occurrence on a spatial and seasonal basis. Data forTHMs and other water quality and operational parametersassociated with their formation were generated through a 16 monthsampling program involving several sites representing variablewater residence times, from the plant to the system extremity.The results demonstrate that the differences in measured THMlevels between the five utilities are mainly due to the variablequality of raw waters, the type of water treatment process beingused and the type and levels of applied disinfectant. Dependingon the utility, average THM levels were from 1.3 to 2.5 timeshigher in the system extremities than in the water leaving thetreatment plant. Also, average levels of THMs measured in summerat the distribution system extremities were, depending on theutility, from 2.5 to 5 times higher than the average levelsmeasured in winter. The seasonal differences were found to besignificantly greater than those observed by others in waterutilities in the United States and Europe and are explained inlarge part by the considerable changes, over the year, in thequality and temperature of surface waters in Southern Québec. Forthe five utilities under study, multivariate regression modelswere developed in order to predict spatial and seasonalvariations of THMs. Both residual chlorine demand and temperaturewere found to be better, statistically, as predictors for THMoccurrence. The usefulness of the developed models for routineand long term water quality management, as well as for assessmentof human exposure to THMs, are also discussed.     

Determination of organophosphorus pesticides and related compounds in water samples by membrane extraction and gas chromatography

A membrane extraction-gas chromatography method was developed fordetermination of organophosphorus pesticides and related compounds including methamidophos, DDVP, dimethoate, methyl parathion, parathion, thiophosphoric acid trimethyl ester, and thiophosphoramidic acid dimethyl ester in water samples. In thismethod, surface-modified acetic cellulose membranes were used to extract the target analytes in water samples, the extracted analytes were back-extracted into a small amount of methanol, andgas chromatography with pulsed flame photometric detector (GC-PFPD) was used to determine the concentrations of targetanalytes in the extracts. The recoveries obtained for thetarget analytes spiked into the water samples ranged from 66to 94%. The method detection limit for each target analyte was 0.05 g L^-1. The method developed in this study had shown the advantages of being cheap, simple, fast, and reliable. It had been used successfully to determine the concentrations of target analytes in river water samples.     

Extractive Spectrofluorometric Determination of Quinalphos Using Fluorescein in Environmental Samples

A simple, sensitive, convenient and low cost spectrofluorometric technique for determination of quinalphos is described. Quinalphos is decomposed with sodium ethoxide. Resultant sodium diethyl thiophosphate (Na-DETP) is extracted with a cationic fluorescein as ion pair complex into 1-chloro-2-nitrobenzene. The fluorescence of the ion pair, fluorescein-DETP is measured at 530 nm after excitation at 490 nm. This technique is applicable for the determination of quinalphos in water, food grains and vegetable samples up to ng level with Amberlite XAD-4.     

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.