基于LIMS数据库的环境监测数据统计方法——以上海市嘉定区实验室信息系统为例

实验室信息管理系统(Laboratory Information Management System,LIMS)在环境监测领域中,已经逐渐地得到了普及,在LIMS数据库中涵盖了大量的环境监测信息和数据,与传统的数据统计方法相比,通过SQL语句对LIMS数据库进行SELECT操作,能够大大提高统计的效率和准确性。     

Risk factors in urban road traffic accidents

INTRODUCTION: The urban road traffic accident (RTA) risks for the city of Zagreb, Croatia, from 1999 through 2000 were analyzed with the aim of reducing the increasing injury incidence. METHOD: Simple and bivariate analysis using chi(2), odds ratio, and confidence interval of 95% was used to determine risks in three outcome groups: killed, severely, and mildly injured. RESULTS: There were 528 RTA victims consisting of 260 severely, 213 mildly injured, and 55 killed at the scene of an accident and during transportation. More fatal accidents occurred during night hours (OR=3.78; 95% CI, 2.08-6.85), on urban road links (OR=2.33; 95% CI, 1.30-4.19), and at exceeding speed limit (OR=2.56; 95% CI, 1.43-4.61). More people were injured than killed on urban junctions (OR=5.27; 95% CI, 2.21-12.57). The highest combined risk of dying or being severely injured was found in males, driving at excessive speed, on urban links, and during bad visibility (OR=16.15; 95% CI, 3.901-66.881). CONCLUSION: These results will influence the urban traffic police enforcement measures, which will change inappropriate behavior of drivers and protect the least experienced road users.     

The impact of European Regional Development Fund on separate waste collection: Evidence from Italian regions

We analyze the impact of Regulation (EC) No 1080/2006 on separate collection rate of Italian regions. We exploit longitudinal data for 20 NUTS-2 Italian regions and eighteen years (from 1996 to 2013). We identify regions which are exposed to “Convergence” objective as the treatment group and regions which are not exposed to this objective as the control group and use a Difference in differences estimation. The estimates suggest that the Regulation (EC) No 1080/2006 has not influenced the convergence process among the Italian regions. The main policy implications are discussed.     

海城7.3级地震余震活动规律的探讨

本文主要对近30年来营口地震台记录的海城7.3级地震的余震观测资料进行分析,按不同的震级进行统计,分别作出M-T图和N-T图,可供今后监测工作参考。     

USING ARTIFICIAL NEURAL NETWORKS TO ESTIMATE MISSING RAINFALL DATA1

ABSTRACT: Missing rainfall data from a time series or a spatial field of observations can present a serious obstacle to data analysis, modeling studies and operational forecasting in hydrology. Numerous schemes for replacing missing data have been proposed, ranging from simple weighted averages of data points that are nearby in time and space to complex statistically-based interpolation methods and function fitting schemes. This paper presents a technique for replacing missing spatial data using a backpropagation neural network applied to concurrent data from nearby gauges. Tests performed on a sample of gauges in the Middle Atlantic region of the United States show that this technique produces results that compare favorably to simple techniques such as arithmetic and distance-weighted averages of the values from nearby gauges, and also to linear optimization methods such as regression.     

1994／1995全球重大自然灾害的统计分析

１９９４／１９９５年是６０年代以来全球自然灾害经济损失最大的两年。作者根据收集到的信息，对全球这两年的重大自然灾害的分布及灾情作了统计。结果表明，９０年代全球重大自然灾害的经济和保险损失存在上升趋势。最后，对其成因进行了分析     

What do significance tests really tell us about the environment?

Routine application of significance tests does not extract the maximum information from environmental data and can lead to misleading conclusions. Reasons leading to this are: a significant result can often be reached merely by collecting enough samples; a statistically significant result is not necessarily practically significant; and reports of the presence or absence of statistically significant differences for multiple tests are not comparable unless identical sample sizes are used. These problems are demonstrated by application to pH data for grazed and retired fields, and by discussion of significance tests used in recent US regulations for groundwater quality. The advantages of equivalence tests, where the tester must state the difference of practical difference, are discussed and applied to the field pH problem. We recommend that environmental managers and scientists pay more attention to statistical power and decide on what is a practical difference. Confidence intervals for the size of the differences, accompanied where necessary by equivalence tests, are the preferred means of addressing the question: “is there a difference of practical significance?”     

QUALITY ASSURANCE TECHNIQUES FOR ELECTRONIC DATA ACQUISITION1

ABSTRACT: Electronic instruments are increasingly being used to gather water quality data. Quality assurance protocols are needed which provide adequate documentation of the procedures followed in calibration, collection, and validation of electronically acquired data. The level of precision of many data loggers exceeds the technology which is commonly used to make field measurements. Overcoming this problem involves using laboratory quality equipment in the field or enhanced quality control at the time of instrument servicing. Time control procedures for data loggers are needed to allow direct comparisons of data between instruments. Electronic instruments provide a mechanism to study transient events in great detail, but, without time controls, multiple loggers produce data which contain artifacts due to timing errors. Individual sensors deployed with data loggers are subject to different degrees of drift over time. Certain measurements can be measured with defined precision and accuracy for long periods of time, while other sensors are subject to loss of both precision and accuracy with increasing time of use. Adequate quality assurance requires the levels of precision and accuracy be documented, particularly those which vary with increasing time deployment.     

DEVELOPING A FIELD COMPONENT IN HYDROLOGIC EDUCATION1

ABSTRACT: Recent assessments have emphasized the lack of a field and laboratory component in hydrologic education at the university level. Consequences of this lack include: (1) an unwarranted faith in published data; (2) lack of appreciation for the spatial and temporal variability of most hydrologic processes; (3) lack of appreciation for the difficulty of collecting good quality field data; (4) an inability to design and execute projects to collect field data; (5) a lack of field experience which can be applied when confronted with different problems or new environments; (6) an inability to evaluate published materials or models against “field reality;” (7) an excessive reliance on, and trust in, theoretical or conceptual models; and (8) reduced potential for lifelong learning through observation and analysis. Field courses need not be costly or difficult, but the instructor must be willing to adapt to the uncertainty and problems associated with field measurements. A recently updated course on watershed measurements at Colorado State University illustrates the type of field courses which can be developed if there is the necessary commitment and flexibility. The lack of a current text can be overcome by assembling selected portions of existing government documents, and a sample bibliography is included.     

SMOOTHED DATA AND GRADIENTS USING SLIDING POLYNOMIALS WITH OPTIONAL CONTROLS1

ABSTRACT: Sliding polynomials differ from other piecewise interpolation and smoothing methods in their functional continuity at the nodes. This functional continuity was used to establish optional spacing of nodes and optional boundary controls in data smoothing while still maintaining mathematically continuous rates or gradients. Cyclic as well as noncyclic data can be smoothed. Variance of the individual nodal values. derived through least-squares optimization, can be calculated using the rigorously determined weighting coefficients between data points and nodes. Such nodal variances are estimates of localized uncertainty in the data which complement the localization of smoothing through use of piecewise functions. Choice of controls in smoothing and calculation of variance have been incorporated in a computer program for user convenience.