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

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

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.     

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

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

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.     

Exact reconstruction with directional wavelets on the sphere

A new formalism is derived for the analysis and exact reconstruction of band-limited signals on the sphere with directional wavelets. It represents an evolution of a previously developed wavelet formalism developed by Antoine & Vandergheynst and Wiaux et al. The translations of the wavelets at any point on the sphere and their proper rotations are still defined through the continuous three-dimensional rotations. The dilations of the wavelets are directly defined in harmonic space through a new kernel dilation, which is a modification of an existing harmonic dilation. A family of factorized steerable functions with compact harmonic support which are suitable for this kernel dilation are first identified. A scale-discretized wavelet formalism is then derived, relying on this dilation. The discrete nature of the analysis scales allows the exact reconstruction of band-limited signals. A corresponding exact multi-resolution algorithm is finally described and an implementation is tested. The formalism is of interest notably for the denoising or the deconvolution of signals on the sphere with a sparse expansion in wavelets. In astrophysics, it finds a particular application for the identification of localized directional features in the cosmic microwave background data, such as the imprint of topological defects, in particular, cosmic strings, and for their reconstruction after separation from the other signal components.     

Fluctuations of floods of the River Morava (Czech Republic) in the 1691–2009 period: interactions of natural and anthropogenic factors

Abstract

Floods from the middle part of the River Morava (eastern Czech Republic) are considered over the course of the past three centuries, the study being based on data derived from documentary evidence (1691–1880), measured peak water stages, H_k (1881–1920) and peak discharges, Q_k (1916–2009), evaluated with respect to their N-year return period (H_N and Q_N ). Changes in land use and water management (water reservoirs, channel modifications) are discussed, as are factors influencing runoff conditions in the Morava catchment. Decadal synthesis of flood series identifies the highest flood activity in the decades of 1911–1920 and 1961–1970 (11 floods each), 1831–1840, 1891–1900, 1901–1910 and 1931–1940 (10 floods each). Uncertainty in this series is related to some incompleteness of documentary data in the pre-1881 period. Very low flood frequency occurred in the 1990s–2000s, although the most disastrous floods were recorded in this particular period (July 1997 at Q ₁₀₀ and March/April 2006 at Q ₂₀–Q ₅₀). Changes in flood frequency correspond partly to long-term changes in temperature and precipitation patterns.

Citation Brázdil, R., ?ezní?ková, L., Valá?ek, H., Havlí?ek, M., Dobrovolný, P., Soukalová, E., ?ehánek, T. & Skokanová, H. (2011) Fluctuations of floods of the River Morava (Czech Republic) in the 1691–2009 period: interactions of natural and anthropogenic factors. Hydrol. Sci. J. 56(3), 468–485.     

广东省产业结构发展水平的空间格局研究

以广东省的市域为经济单元,利用空间自相关分析和密度分析法,对1994—2015年广东省产业结构发展水平空间格局进行了研究。结果表明:广东省逐渐形成了以广州、深圳、东莞为中心的第三产业圈,周边城市为第二产业外圈,并逐渐向四周扩散的圈层式空间格局。珠三角地区产业结构发展水平较高,其他地区相对落后。全省的全局空间自相关性比较高,产业发展水平的空间聚集特征明显,高-高区域集中在珠三角地区,低-低区域主要分布在其他地区,有较明显的两极分化异质性。     

地震勘探资源频率域叠加方法研究

在叠前共深度点道集内各地震道的动、静校正误差很小的情况下，地震资料时间域水平叠加方法有较好的叠加结果。但是，如果动、静校正的误差较大时，叠加效果将受到影响，即叠后振幅和分辨率都会降低。因此，提出一种频率域叠加方法。该方法既具有常规水平叠加方法能提高信噪比的优点，又能将共深度点道集内的走时时差消除，达到内相叠回的目的。几个比较叠加方法效果的有噪CDP道集叠加的例子证明了该方法的效果。     

Seismic images of a collision zone offshore NW Sabah/Borneo

Multichannel reflection seismic data from the southern South China Sea, refraction and gravity modelling were used to investigate the compressional sedimentary structures of the collision-prone continental margin off NW Borneo. An elongated imbricate deepwater fan, the toe Thrust Zone bounds the Northwest Borneo Trough to the southeast. The faults separating the individual imbricates cut through post-Early Miocene sediments and curve down to a carbonate platform at the top of the subsiding continental Dangerous Grounds platform that forms the major detachment surface. The age of deformation migrates outward toward the front of the wedge. We propose crustal shortening mechanisms as the main reason for the formation of the imbricate fan. At the location of the in the past defined Lower Tertiary Thrust Sheet tectonostratigraphic province a high velocity body was found but with a much smaller extend than the previously defined structure. The high velocity structure may be interpreted either as carbonates that limit the transfer of seismic energy into the sedimentary layers beneath or as Paleogene Crocker sediments dissected by remnants of a proto-South China Sea oceanic crust that were overthrust onto a southward migrating attenuated continental block of the Dangerous Grounds during plate convergence.     

Landsat 8陆地成像仪影像的缨帽变换推导

针对Landsat 8陆地成像仪影像,该文提出了一种缨帽变换系数的推算方法。利用准同步的Landsat ETM+影像缨帽变换结果为目标值,采用普鲁克算法对不同地理分布下的陆地成像仪影像样本点的主成分轴分别进行旋转,得到相应的初始变换系数;通过广义普鲁克分析对所得初始变换系数进行平均化,并以格拉姆-施密特算法保持其正交性,最终得到基于陆地成像仪大气表观反射率数据的缨帽变换系数。验证结果表明,与现有陆地成像仪变换系数相比,该文提出的缨帽变换精度相对较高,误差较小,变换后的不同地物覆盖类型具有更好的可分性。