Benchmarking spatial joins a la carte

Spatial joins are join operations that involve spatial data types and operators. Spatial access methods are often used to speed up the computation of spatial joins. This paper addresses the issue of benchmarking spatial join operations. For this purpose, we first present a WWW-based benchmark generator to produce sets of rectangles. Using a Web browser, experimenters can specify the number of rectangles in a sample, as well as the statistical distributions of their sizes, shapes, and locations. Second, using the generator and a well-defined set of statistical models we define several tests to compare the performance of three spatial join algorithms: nested loop, scan-and-index, and synchronized tree traversal. We also added two real-life data sets from the Sequoia 2000 storage benchmark. Our results show that the relative performance of the different techniques mainly depends on the selectivity factor of the join predicate. All of the statistical models and algorithms are available on the Web, which allows for easy verification and modification of our experiments.     

Observation of Precipitating Systems over Complex Orography with Meteorological Doppler Radars: A Feasibility Study

Summary  This paper concerns the use of airborne or ground-based Doppler radars to observe precipitating systems over complex orography. As nearly all of the previous experiments involving Doppler radars were conducted over flat surfaces over the continents or the oceans, new techniques are needed firstly to separate ground clutter from meteorological signal and, in the case of airborne Doppler observations, to deduce navigational errors. Secondly, it is necessary to take the atmospheric circulation induced by orography into account in the three-dimensional wind field analysis. Variational techniques are presented to solve these problems. The proposed methods are tested with simulated ground-based and airborne Doppler radar observations for analytic flows over analytic terrains and for numerically simulated wind and reflectivity fields for the Brig event (22 September 1993) of heavy precipitation over the southern flank of the Alps (Cosma and Richard, 1998), and with actual airborne Doppler data relative to weak snow showers over the Rocky Mountains on 12 March 1995. Received March 22, 1999/Revised June 1, 1999     

Radiometric mapping of the Berg River estuary

Geographic Information Systems (GIS) consists of various tools to perform spatial analyses in a wide variety of disciplines, including radiometric analysis to characterize the distribution of natural radionuclide concentrations. Recently, open-source GIS has become popular among geospatial users because it can be freely used, and powerful tools are constantly developed to enhance software capabilities. Gamma-ray spectroscopy was used to measure the concentrations of these natural radionuclides by dragging a Delta Underwater Gamma System (DUGS) among the sediment in the Berg River estuary located in Velddrif, South Africa. In this study, QGIS was used to visually illustrate and interpret the distribution of natural radionuclides, that is, potassium (K⁴⁰), thorium (Th²³²), and uranium (U²³⁸). These concentrations can be used to investigate various geographical and geological phenomena, which include sediment processes. The data were then interpreted to derive sediment characteristics. Various features of tidal estuaries were demonstrated by the results.     

Correcting superconducting gravity time-series using rainfall modelling at the Vienna and Membach stations and application to Earth tide analysis

We demonstrate the possibility to improve the signal-to-noise ratio of superconducting gravity time-series by correcting for local hydrological effects. Short-term atmospheric events associated with heavy rain induce step-like gravity signals that deteriorate the frequency spectrum estimates. Based on 4D modeling constrained by high temporal resolution rain gauge data, rainfall admittances for the Vienna and Membach superconducting gravity stations are calculated. This allows routine correction for Newtonian rain water effects, which reduces the standard deviation of residuals after tidal parameter adjustment by 10%. It also improves the correction of steps of instrumental origin when they coincide with step-like water mass signals.     

Biokinetics of Radiocobalt in the Asteroid Asterias rubens (Echinodermata): Sea Water and Food Exposures

Uptake and loss of cobalt-57 were investigated in the starfish Asterias rubens, in order to assess its value as a sentinel organism for nearshore radionuclide contamination. Whole-body uptake from sea water was linear over a 32-day exposure period and reached wet weight concentration factor (CF) of 23 ± 5. Bioaccumulation of ⁵⁷Co was dependent upon body compartment, the aboral part of the body wall concentrating cobalt to the greatest degree (wet weight CF: 77 ± 16). After restoration of uncontaminated conditions, radiocobalt was released following an exponential loss kinetics characterized by a biological half-life (T_b1/2) of 27 ± 6 day. Dietary radiocobalt (taken up during a short-term feeding for 24 h on radiolabelled mussels) showed a much more rapid turnover time (T_b1/2: 14 ± 4 d), suggesting that A. rubens accumulates this radionuclide predominantly from sea water. A. rubens, and more particularly the aboral part of its body wall, would readily reveal the presence of an environmental contamination by radiocobalt and could preserve this information over a period of few months.     

A critical zone observatory dedicated to suspended sediment transport: The meso-scale Galabre catchment (southern French Alps)

The 20 km² Galabre catchment belongs to the French network of critical zone observatories (OZCAR; Gaillardet et al., Vadose Zone Journal, 2018, 17(1), 1–24). It is representative of the sedimentary lithology and meteorological forcing found in Mediterranean and mountainous areas. Due to the presence of highly erodible and sloping badlands on various lithologies, the site was instrumented in 2007 to understand the dynamics of suspended sediments (SS) in such areas. Two meteorological stations including measurements of air temperature, wind speed and direction, air moisture, rainfall intensity, raindrop size and velocity distribution were installed both in the upper and lower part of the catchment. At the catchment outlet, a gauging station records the water level, temperature and turbidity (10 min time-step). Stream water samples are collected automatically to estimate SS concentration-turbidity relationships, allowing quantification of SS fluxes with known uncertainty. The sediment samples are further characterized by measuring their particle size distributions and by applying a low-cost sediment fingerprinting approach using spectrocolorimetric tracers. Thus, the contributions of badlands located on different lithologies to total SS flux are quantified at a high temporal resolution, providing the opportunity to better analyse the links between meteorological forcing variability and watershed hydrosedimentary response. The set of measurements was extended to the dissolved phase in 2017. Both stream water electrical conductivity and major ion concentrations are measured each week and every 3 h during storm events. This extension of measurements to the dissolved phase will allow progress in understanding both the origin of the water during the events and the partitioning between particulate and dissolved fluxes of solutes in the critical zone. All data sets are available at https://doi.osug.fr/public/DRAIXBLEONE_GAL/index.html .     

Coseismic and post-seismic signatures of the Sumatra 2004 December and 2005 March earthquakes in GRACE satellite gravity

The GRACE satellite mission has been measuring the Earth's gravity field and its temporal variations since 2002 April. Although these variations are mainly due to mass transfer within the geofluid envelops, they also result from mass displacements associated with phenomena including glacial isostatic adjustment and earthquakes. However, these last contributions are difficult to isolate because of the presence of noise and of geofluid signals, and because of GRACE's coarse spatial resolution (>400 km half-wavelength). In this paper, we show that a wavelet analysis on the sphere helps to retrieve earthquake signatures from GRACE geoid products. Using a wavelet analysis of GRACE geoids products, we show that the geoid variations caused by the 2004 December ( M _w= 9.2) and 2005 March ( M _w= 8.7) Sumatra earthquakes can be detected. At GRACE resolution, the 2004 December earthquake produced a strong coseismic decrease of the gravity field in the Andaman Sea, followed by relaxation in the area affected by both the Andaman 2004 and the Nias 2005 earthquakes. We find two characteristic timescales for the relaxation, with a fast variation occurring in the vicinity of the Central Andaman ridge. We discuss our coseismic observations in terms of density changes of crustal and upper-mantle rocks, and of the vertical displacements in the Andaman Sea. We interpret the post-seismic signal in terms of the viscoelastic response of the Earth's mantle. The transient component of the relaxation may indicate the presence of hot, viscous material beneath the active Central Andaman Basin.     

Stable carbon-isotopic compositions of lipids isolated from the ammonia-oxidizing chemoautotroph Nitrosomonas europaea

For the ammonia-oxidizing bacterium Nitrosomonas europaea, grown autotrophically using semicontinuous culturing, average biomass was depleted in ¹³C relative to CO₂ dissolved in the medium by ca. 20‰ and the total-lipid extract was depleted in ¹³C relative to biomass by 3.7‰. The n-alkyl lipids (weighted average of fatty acids) and isoprenoid lipids (weighted average of hopanoids) were both depleted in ¹³C relative to biomass by about 9‰. The large depletion in the isoprenoid lipids seems to indicate that isotopic fractionations associated with the biosynthesis of methylerythritol phosphate (MEP) affected at least two carbon positions in each isoprene unit. Among the fatty acids, trans-9-hexadecenoic acid was most depleted (13.0‰ relative to biomass), followed by cis-9- hexadecenoic acid (9.6‰) and hexadecanoic acid (6.9‰). Isotopic relationships between the three acids suggest that significant isotope effects were associated with the desaturation and cis to trans isomerization of fatty acids. Given these observations, hopanoids produced by ammonia-oxidizing bacteria growing in natural waters are likely to be depleted in ¹³C by 26–30‰ relative to dissolved CO₂. Since CO₂ at aquatic oxyclines is often depleted in ¹³C, the range of δ values expected for hopanoids is ca. −34‰ to −55‰. The δ values of geohopanoids observed in numerous studies and attributed to unspecified chemoautotrophs fall within this range.     

The European coastal zone: characterization and first assessment of ecosystem metabolism

The geomorphic, oceanographic, terrestrial and anthropogenic attributes of the European coastal zone are described and published data on ecosystem function (primary production and respiration) are reviewed. Four regions are considered: the Baltic Sea, Mediterranean Sea, Black Sea and the European Atlantic coast including the North Sea. The metabolic database (194 papers) suffers from a non-homogeneous geographical coverage with no usable data for the Black Sea which was therefore excluded from this part of our study. Pelagic gross primary production in European open shelves is, by far, the most documented parameter with an estimated mean of 41 mmol C m⁻² d⁻¹, the lowest value is reported in the Mediterranean Sea (21 mmol C m⁻² d⁻¹) and the highest one in the Atlantic/North Sea area (51 mmol C m⁻² d⁻¹). Microphytobenthic primary production, mostly measured in shallow areas, is extrapolated to the entire 0–200 m depth range. Its contribution to total primary production is low in all regions (mean: 1.5 mmol C m⁻² d⁻¹). Although macrophyte beds are very productive, a regional production estimate is not provided in this study because their geographical distribution along the European coastline remains unknown. Measurements of pelagic community respiration are clearly too sparse, especially below the euphotic zone, to yield an accurate picture of the fate of organic matter produced in the water column. With a mean value of 17 mmol C m⁻² d⁻¹, benthic community respiration consumes approximately 40% of the pelagic organic matter production. Estuaries generally exhibit high metabolic rates and a large range of variation in all parameters, except microphytobenthic primary production. Finally, the problem of eutrophication in Europe is discussed and the metabolic data obtained in the framework of the Land–Ocean Interactions in the Coastal Zone (LOICZ) project are compared with available direct measurements of net ecosystem production.