EXCEL VBA程序设计及在气象计量数据处理中的应用

利用EXCEL强大的数据处理功能,并结合EXCELVBA的特点进行程序设计,实现自动处理数据,自动生成原始数据报表以及计量器具的检定证书,大大提高了数据处理的效率和准确度。     

农户行为视角下的乡村生产空间系统运行机制及重构启示

农户行为转变是乡村生产空间系统量变或从量变到质变的重要驱动力,乡村生产空间系统的运行实质上是农户行为作用的外在表现,厘清农户行为可为诠释乡村生产空间系统的运行机制提供平台。本文在剖析农户行为转变与乡村生产空间系统运行响应的理论框架基础上,从农户行为转变和乡村生产空间系统响应入手构建指标体系,建立模糊综合评价量化模型,并以重庆市江津区恒和村作为实证,诠释乡村生产空间系统运行机制。主要研究结论为：不同农户行为对乡村生产空间系统运行的影响程度各异,大体为生产大户>合作社农户>传统农户;不同农户行为对系统运行响应结果的作用差异明显,生产大户行为主要影响乡村生产空间的利用效率,合作社农户行为对提升生产空间系统经济效益作用明显,传统农户行为对生产空间系统环境改善的贡献作用最小。并从经济、社会、空间重构视角提出发展多种形式的适度规模化经营、培育新型农业经营主体和职业农民、合理引导农户技术和资本投入等建议,以实现乡村生产空间系统协调与均衡发展。     

A Warning System for Stromboli Volcano Based on Statistical Analysis

In this paper we describe a warning system based on statistical analysis for the purpose of monitoring ground deformation at the Sciara del Fuoco (Stromboli Volcano, Sicily). After a statistical analysis of ground deformation time-series measured at Stromboli by the monitoring system known as THEODOROS (THEOdolite and Distancemeter Robot Observatory of Stromboli), the paper describes the solution adopted for implementing the warning system. A robust statistical index has been defined in order to evaluate the movements of the area. A fuzzy approach has been proposed to evaluate an AI (Alarm Intensity) index which indicates the level of hazard of the Sciara del Fuoco sliding.     

Effective typhoon characteristics and their effects on hourly reservoir inflow forecasting

This paper describes the identification of effective typhoon characteristics and the development of a new type of hourly reservoir inflow forecasting model with the effective typhoon characteristics. Firstly, a comparison of support vector machines (SVMs), which is a novel kind of neural networks (NNs), and back-propagation networks (BPNs) is made to select an appropriate NN-based model. The results show that SVM-based models are more appropriate than BPN-based models because of their higher accuracy and much higher efficiency. In addition, effective typhoon characteristics for improving forecasting performance are identified from all the collected typhoon information. Then the effective typhoon characteristics (the position of the typhoon and the distance between the typhoon center and the reservoir) are added to the proposed SVM-based models. Next, a performance comparison of models with and without effective typhoon characteristics is conducted to clearly highlight the effects of effective typhoon characteristics on hourly reservoir inflow forecasting. To reach a just conclusion, the performance is evaluated by cross validation, and the improvement in performance due to the addition of effective typhoon characteristics is tested by paired comparison t-tests at the 5% significance level. The results confirm that effective typhoon characteristics do improve the forecasting performance and the improvement increases with increasing lead-time, especially when the rainfall data are not available. For four- to six-hour ahead forecasts, the improvement due to the addition of effective typhoon characteristics increases from 3% to 18% and from 10% to 113% for Categories I (rainfall data are available) and II (rainfall data are not available), respectively. In conclusion, effective typhoon characteristics are recommended as key inputs for reservoir inflow forecasting during typhoons. The proposed SVM-based models with effective typhoon characteristics are expected to provide more accurate forecasts than BPN-based models. The proposed modeling technique is also expected to be useful to support reservoir operation systems and other disaster warning systems.     

A Parametric Approach for Dealing with Compositional Rounded Zeros

In this work, a parametric approach for replacing data below the detection limit, also known as rounded zeros, in compositional data sets is proposed. Compositional rounded zeros correspond to small proportions of some whole that cannot be reliably detected by the analytical instruments under given operating conditions. This kind of zeros appear frequently in the data collection process in geosciences. They must be treated in an adequate way before some multivariate analysis can be applied. Our procedure results from a modification of the Expectation-Maximization (EM) algorithm and is based on the additive log-ratio transformation. Its coherence with the nature of compositional data and with basic operations in the simplex sample space is checked. Using real data sets, we find that this approach improves other parametric and non-parametric techniques for compositional rounded zeros.     

Quantitative urban climate mapping based on a geographical database: A simulation approach using Hong Kong as a case study

The urban environment has been dramatically changed by artificial constructions. How the modified urban geometry affects the urban climate and therefore human thermal comfort has become a primary concern for urban planners. The present study takes a simulation approach to analyze the influence of urban geometry on the urban climate and maps this climatic understanding from a quantitative perspective. A geographical building database is used to characterize two widely discussed aspects: urban heat island effect (UHI) and wind dynamics. The parameters of the sky view factor (SVF) and the frontal area density (FAD) are simulated using ArcGIS-embedded computer programs to link urban geometry with the UHI and wind dynamic conditions. The simulated results are synergized and classified to evaluate different urban climatic conditions based on thermal comfort consideration. A climatic map is then generated implementing the classification. The climatic map shows reasonable agreement with thermal comfort understanding, as indicated by the biometeorological index of the physiological equivalent temperature (PET) obtained in an earlier study. The proposed climate mapping approach can provide both quantitative and visual evaluation of the urban environment for urban planners with climatic concerns. The map could be used as a decision support tool in planning and policy-making processes. An urban area in Hong Kong is used as a case study.     

计算机跟踪伺服系统的保护电路

本文介绍了为紫台13.7米射电望远镜跟踪系统设计制造的一套的简单实用的保护电路。实验证明该电路性能可靠、效果显著。     

瞬变电磁测深法的研究深度

研究发现,瞬变测深法研究深度除了与采样时间(采样间隔,起始和终止采样时间等)有关外,还与信号源强度、大地电导率、系统噪音水平以及仪器观测精度等因素有关,文中对研究深度与这些量之间的关系作了数学描述。     

综合台站观测资料信息管理系统的技术特点

介绍了为配合闽南地震示范工程的开展而开发的《综合地震台观测资料信息管理系统》程序设计的基本原则、总体结构及功能,并给出了操作流程示意图和简要说明。     

An international comparison of governmental disclosure of hydrocarbon spills from offshore oil and gas installations

The cumulative effect of accidental spills from oil and gas extraction in the marine environment can have significant impacts on marine wildlife. Oil and gas operators are typically required to report spill data as part of a regulatory process. We conducted a survey of the public disclosure of hydrocarbon spill data for four countries, Australia, Canada, United Kingdom and United States. There was significant variation in the spill data statistics that were publicly reported by the regulators. No country provided full disclosure of spill data or follow-up actions taken by the regulator on their website. The lack of disclosure of spill data is of concern because the scale of environmental effects is more difficult to assess, insufficient information is available to assess the accuracy of predictions made in the environmental assessment process, and without consistency of spill reporting there is no method to compare regional differences of spill rates.