The impact of spatial data redundancy on SOLAP query performance

Geographic Data Warehouses (GDW) are one of the main technologies used in decision-making processes and spatial analysis, and the literature proposes several conceptual and logical data models for GDW. However, little effort has been focused on studying how spatial data redundancy affects SOLAP (Spatial On-Line Analytical Processing) query performance over GDW. In this paper, we investigate this issue. Firstly, we compare redundant and non-redundant GDW schemas and conclude that redundancy is related to high performance losses. We also analyze the issue of indexing, aiming at improving SOLAP query performance on a redundant GDW. Comparisons of the SB-index approach, the star-join aided by R-tree and the star-join aided by GiST indicate that the SB-index significantly improves the elapsed time in query processing from 25% up to 99% with regard to SOLAP queries defined over the spatial predicates of intersection, enclosure and containment and applied to roll-up and drill-down operations. We also investigate the impact of the increase in data volume on the performance. The increase did not impair the performance of the SB-index, which highly improved the elapsed time in query processing. Performance tests also show that the SB-index is far more compact than the star-join, requiring only a small fraction of at most 0.20% of the volume. Moreover, we propose a specific enhancement of the SB-index to deal with spatial data redundancy. This enhancement improved performance from 80 to 91% for redundant GDW schemas.

An Eulerian Immersed Boundary Method for flow simulations over stationary and moving rigid bodies

The fluid flow over bodies with complex geometry has been the subject of research of many scientists and widely explored experimentally and numerically. The present study proposes an Eulerian Immersed Boundary Method for flows simulations over stationary or moving rigid bodies. The proposed method allows the use of Cartesians Meshes. Here, two-dimensional simulations of fluid flow over stationary and oscillating circular cylinders were used for verification and validation. Four different cases were explored: the flow over a stationary cylinder, the flow over a cylinder oscillating in the flow direction, the flow over a cylinder oscillating in the normal flow direction, and a cylinder with angular oscillation. The time integration was carried out by a classical 4th order Runge-Kutta scheme, with a time step of the same order of distance between two consecutive points in x direction. High-order compact finite difference schemes were used to calculate spatial derivatives. The drag and lift coefficients, the lock-in phenomenon and vorticity contour plots were used for the verification and validation of the proposed method. The extension of the current method allowing the study of a body with different geometry and three-dimensional simulations is straightforward. The results obtained show a good agreement with both numerical and experimental results, encouraging the use of the proposed method.

The Effect of Spatial Scale on Predicting Time Series: A Study on Epidemiological System Identification

A susceptible-infective-recovered (SIR) epidemiological model based on probabilistic cellular automaton (PCA) is employed for simulating the temporal evolution of the registered cases of chickenpox in Arizona, USA, between 1994 and 2004. At each time step, every individual is in one of the states S, I, or R. The parameters of this model are the probabilities of each individual (each cell forming the PCA lattice ) passing from a state to another state. Here, the values of these probabilities are identified by using a genetic algorithm. If nonrealistic values are allowed to the parameters, the predictions present better agreement with the historical series than if they are forced to present realistic values. A discussion about how the size of the PCA lattice affects the quality of the model predictions is presented. Copyright (C) 2009 L. H. A. Monteiro et al.

Geographic Information Systems (GIS) in Assessing Dental Health

The present study investigated the distribution profile of dental caries and its association with areas of social deprivation at the individual and contextual level. The cluster sample consisted of 1,002 12-year-old schoolchildren from Piracicaba, SP, Brazil. The DMFT Index was used for dental caries and the Care Index was used to determine access to dental services. On the individual level, variables were associated with a better oral status. On the contextual level, areas were not associated with oral status. However, maps enabled determining that the central districts have better social and oral conditions than the deprived outlying districts.

A spatial approach for the epidemiology of antibiotic use and resistance in community-based studies: the emergence of urban clusters of Escherichia coli quinolone resistance in Sao Paulo, Brasil

Background: Population antimicrobial use may influence resistance emergence. Resistance is an ecological phenomenon due to potential transmissibility. We investigated spatial and temporal patterns of ciprofloxacin (CIP) population consumption related to E. coli resistance emergence and dissemination in a major Brazilian city. A total of 4,372 urinary tract infection E. coli cases, with 723 CIP resistant, were identified in 2002 from two outpatient centres. Cases were address geocoded in a digital map. Raw CIP consumption data was transformed into usage density in DDDs by CIP selling points influence zones determination. A stochastic model coupled with a Geographical Information System was applied for relating resistance and usage density and for detecting city areas of high/low resistance risk. Results: E. coli CIP resistant cluster emergence was detected and significantly related to usage density at a level of 5 to 9 CIP DDDs. There were clustered hot-spots and a significant global spatial variation in the residual resistance risk after allowing for usage density. Conclusions: There were clustered hot-spots and a significant global spatial variation in the residual resistance risk after allowing for usage density. The usage density of 5-9 CIP DDDs per 1,000 inhabitants within the same influence zone was the resistance triggering level. This level led to E. coli resistance clustering, proving that individual resistance emergence and dissemination was affected by antimicrobial population consumption.

Spatial patterns of malaria in a land reform colonization project, Juruena municipality, Mato Grosso, Brazil

Background: In Brazil, 99% of malaria cases are concentrated in the Amazon, and malaria's spatial distribution is commonly associated with socio-environmental conditions on a fine landscape scale. In this study, the spatial patterns of malaria and its determinants in a rural settlement of the Brazilian agricultural reform programme called ""Vale do Amanhecer"" in the northern Mato Grosso state were analysed. Methods: In a fine-scaled, exploratory ecological study, geocoded notification forms corresponding to malaria cases from 2005 were compared with spectral indices, such as the Normalized Difference Vegetation Index (NDVI) and the third component of the Tasseled Cap Transformation (TC_3) and thematic layers, derived from the visual interpretation of multispectral TM-Landsat 5 imagery and the application of GIS distance operators. Results: Of a total of 336 malaria cases, 102 (30.36%) were caused by Plasmodium falciparum and 174 (51.79%) by Plasmodium vivax. Of all the cases, 37.6% (133 cases) were from residents of a unique road. In total, 276 cases were reported for the southern part of the settlement, where the population density is higher, with notification rates higher than 10 cases per household. The local landscape mostly consists of open areas (38.79 km(2)). Training forest occupied 27.34 km(2) and midsize vegetation 7.01 km(2). Most domiciles with more than five notified malaria cases were located near areas with high NDVI values. Most domiciles (41.78%) and malaria cases (44.94%) were concentrated in areas with intermediate values of the TC_3, a spectral index representing surface and vegetation humidity. Conclusions: Environmental factors and their alteration are associated with the occurrence and spatial distribution of malaria cases in rural settlements.

A Dynamic Analysis of Tuberculosis Dissemination to Improve Control and Surveillance

Background: Detailed analysis of the dynamic interactions among biological, environmental, social, and economic factors that favour the spread of certain diseases is extremely useful for designing effective control strategies. Diseases like tuberculosis that kills somebody every 15 seconds in the world, require methods that take into account the disease dynamics to design truly efficient control and surveillance strategies. The usual and well established statistical approaches provide insights into the cause-effect relationships that favour disease transmission but they only estimate risk areas, spatial or temporal trends. Here we introduce a novel approach that allows figuring out the dynamical behaviour of the disease spreading. This information can subsequently be used to validate mathematical models of the dissemination process from which the underlying mechanisms that are responsible for this spreading could be inferred. Methodology/Principal Findings: The method presented here is based on the analysis of the spread of tuberculosis in a Brazilian endemic city during five consecutive years. The detailed analysis of the spatio-temporal correlation of the yearly geo-referenced data, using different characteristic times of the disease evolution, allowed us to trace the temporal path of the aetiological agent, to locate the sources of infection, and to characterize the dynamics of disease spreading. Consequently, the method also allowed for the identification of socio-economic factors that influence the process. Conclusions/Significance: The information obtained can contribute to more effective budget allocation, drug distribution and recruitment of human skilled resources, as well as guiding the design of vaccination programs. We propose that this novel strategy can also be applied to the evaluation of other diseases as well as other social processes.

Understanding the Influences of Spatial Patterns on N Availability Within the Brazilian Amazon Forest

Nitrogen variations at different spatial scales and integrated across functional groups were addressed for lowland tropical forests in the Brazilian Amazon as follows: (1) how does N availability vary across the region over different spatial scales (regional x landscape scale); ( 2) how are these variations in N availability integrated across plant functional groups ( legume 9 non-legume trees). Leaf N, P, and Ca concentrations as well the leaf N isotope ratios (delta(15)N) from a large set of legume and non-legume tree species were measured. Legumes had higher foliar N/Ca ratios than non-legumes, consistent with the high energetic costs in plant growth associated with higher foliar P/Ca ratios found in legumes than in non-legumes. At the regional level, foliar delta(15)N decreased with increasing rainfall. At the landscape level, N availability was higher in the forests on clayey soils on the plateau than in forests on sandier soils. The isotope as well as the non-isotope data relationships here documented, explain to a large extent the variation in delta(15)N signatures across gradients of rainfall and soil. Although at the regional level, the precipitation regime is a major determinant of differences in N availability, at the landscape level, under the same precipitation regime, soil type seems to be a major factor influencing the availability of N in the Brazilian Amazon forest.

Small rivers in the southwestern Amazon and their role in CO(2) outgassing

A recent estimate of CO(2) outgassing from Amazonian wetlands suggests that an order of magnitude more CO(2) leaves rivers through gas exchange with the atmosphere than is exported to the ocean as organic plus inorganic carbon. However, the contribution of smaller rivers is still poorly understood, mainly because of limitations in mapping their spatial extent. Considering that the largest extension of the Amazon River network is composed of small rivers, the authors` objective was to elucidate their role in air-water CO(2) exchange by developing a geographic information system ( GIS)- based model to calculate the surface area covered by rivers with channels less than 100 m wide, combined with estimated CO(2) outgassing rates at the Ji-Parana River basin, in the western Amazon. Estimated CO(2) outgassing was the main carbon export pathway for this river basin, totaling 289 Gg C yr(-1), about 2.4 times the amount of carbon exported as dissolved inorganic carbon ( 121 Gg C yr(-1)) and 1.6 times the dissolved organic carbon export ( 185 Gg C yr(-1)). The relationships established here between drainage area and channel width provide a new model for determining small river surface area, allowing regional extrapolations of air - water gas exchange. Applying this model to the entire Amazon River network of channels less than 100 m wide ( third to fifth order), the authors calculate that the surface area of small rivers is 0.3 +/- 0.05 million km(2), and it is potentially evading to the atmosphere 170 +/- 42 Tg C yr(-1) as CO(2). Therefore, these ecosystems play an important role in the regional carbon balance.

GIS applied to geotechnical and environmental risk management in a Brazilian oil pipeline

The paper presents the development of a decision support system for the management of geotechnical and environmental risks in oil pipelines using a geographical information system. The system covers a 48.5 km long section of the So Paulo to Brasilia (OSBRA) oil pipeline, which crosses three municipalities in the northeast region of the So Paulo state (Brazil) and represents an area of 205.8 km(2). The spatial database was created using geo-processing procedures, surface and intrusive investigations and geotechnical reports. The risk assessment was based mainly on qualitative models (relative numeric weights and multicriteria decision analysis) and considered pluvial erosion, slope movements, soil corrosion and third party activities. The maps were produced at a scale of 1:10,000.

Compatibility of Neoseiulus paspalivorus and Proctolaelaps bickleyi, candidate biocontrol agents of the coconut mite Aceria guerreronis: spatial niche use and intraguild predation

The eriophyid mite Aceria guerreronis occurs in most coconut growing regions of the world and causes enormous damage to coconut fruits. The concealed environment of the fruit perianth under which the mite resides renders its control extremely difficult. Recent studies suggest that biological control could mitigate the problems caused by this pest. Neoseiulus paspalivorus and Proctolaelaps bickleyi are two of the most frequently found predatory mites associated with A. guerreronis on coconut fruits. Regarding biological control, the former has an advantage in invading the tight areas under the coconut fruit perianth while the latter is more voracious on the pest mites and has a higher reproductive capacity. Based on the idea of the combined use/release of both predators on coconut fruits, we studied their compatibility in spatial niche use and intraguild predation (IGP). Spatial niche use on coconut fruits was examined on artificial arenas mimicking the area under the coconut fruit perianth and the open fruit surface. Both N. paspalivorus and P. bickleyi preferentially resided and oviposited inside the tight artificial chamber. Oviposition rate of P. bickleyi and residence time of N. paspalivorus inside the chamber were reduced in the presence of a conspecific female. Residence of N. paspalivorus inside the chamber was also influenced by the presence of P. bickleyi. Both N. paspalivorus and P. bickleyi preyed upon each other with relatively moderate IGP rates of adult females on larvae but neither species yielded nutritional benefits from IGP in terms of adult survival and oviposition. We discuss the relevance of our findings for a hypothetic combined use of both predators in biological control of A. guerreronis.

Spatial pattern of black spot incidence within citrus trees related to disease severity and pathogen dispersal

Guignardia citricarpa, the causal agent of citrus black spot, forms airborne ascospores on decomposing citrus leaves and water-spread conidia on fruits, leaves and twigs. The spatial pattern of diseased fruit in citrus tree canopies was used to assess the importance of ascospores and conidia in citrus black spot epidemics in Sao Paulo State, Brazil. The aggregation of diseased fruit in the citrus tree canopy was quantified by the binomial dispersion index (D) and the binary form of Taylor`s Power Law for 303 trees in six groves. D was significantly greater than 1 in 251 trees. The intercept of the regression line of Taylor`s Power Law was significantly greater than 0 and the slope was not different from 1, implying that diseased fruit was aggregated in the canopy independent of disease incidence. Disease incidence (p) and severity (S) were assessed in 2875 citrus trees. The incidence-severity relationship was described (R-2 = 88.7%) by the model ln(S) = ln(a) + bCLL(p) where CLL = complementary log-log transformation. The high severity at low incidence observed in many cases is also indicative of low distance spread of G. citricarpa spores. For the same level of disease incidence, some trees had most of the diseased fruit with many lesions and high disease severity, whereas other trees had most of the fruit with few lesions and low disease severity. Aggregation of diseased fruit in the trees suggests that splash-dispersed conidia have an important role in increasing the disease in citrus trees in Brazil.

Spatial Modeling of a Soil Fertility Index using Visible-Near-Infrared Spectra and Terrain Attributes

Our objective was to develop a methodology to predict soil fertility using visible near-infrared (vis-NIR) diffuse reflectance spectra and terrain attributes derived from a digital elevation model (DEM). Specifically, our aims were to: (i) assemble a minimum data set to develop a soil fertility index for sugarcane (Sarcharum officinarum L.) (SFI-SC) for biofuel production in tropical soils; (ii) construct a model to predict the SFI-SC using soil vis-NIR spectra and terrain attributes; and (iii) produce a soil fertility map for our study area and assess it by comparing it with a green vegetation index (GVI). The study area was 185 ha located in sao Paulo State, Brazil. In total, 184 soil samples were collected and analyzed for a range of soil chemical and physical properties. Their vis-NIR spectra were collected from 400 to 2500 nm. The Shuttle Radar Topographic Mission 3-arcsec (90-m resolution) DEM of the area was used to derive 17 terrain attributes. A minimum data set of soil properties was selected to develop the SFI-SC. The SFI-SC consisted of three classes: Class 1, the highly fertile soils; Class 2, the fertile soils; and Class 3, the least fertile soils. It was derived heuristically with conditionals and using expert knowledge. The index was modeled with the spectra and terrain data using cross-validated decision trees. The cross-validation of the model correctly predicted Class 1 in 75% of cases, Class 2 in 61%, and Class 3 in 65%. A fertility map was derived for the study area and compared with a map of the GVI. Our approach offers a methodology that incorporates expert knowledge to derive the SFI-SC and uses a versatile spectro-spatial methodology that may be implemented for rapid and accurate determination of soil fertility and better exploration of areas suitable for production.

Neighborhood and Efficiency in Manufacturing in Brazilian Regions: A Spatial Markov Chain Analysis

This paper analyzes the geography of regional competitiveness in manufacturing in Brazil. The authors estimate stochastic frontiers to calculate regional efficiency of representative firms in 137 regions in the period 2000-2006, in four sectors defined by technological intensity. The efficiency results are analyzed using Markov Spatial Transition Matrices to provide insights into the transition of regions between efficiency levels, considering their local spatial context. The results indicate that geography plays an important role in manufacturing competitiveness. In particular, regions with more competitive neighbors are more likely to improve their relative efficiency (pull effect) over time, and regions with less competitive neighbors are more likely to lose relative efficiency (drag effect). The authors find that the pull effect is stronger than the drag effect.

Non-Spatial Government Policies and Regional Income Inequality in Brazil

Silveira Neto R. Da M. and Azzoni C. R. Non-spatial government policies and regional income inequality in Brazil, Regional Studies. This paper uses both macro- and micro-data to analyse the role of social programmes in the recent reduction in Brazilian regional income inequality. Convergence indicators are presented for different sources of regional income in the period 1995-2006. A decomposition of the Gini indicator allows the identification of the role of each of these income sources with respect to the reduction of regional inequality during the period. The results point out that both labour productivity and government non-spatial policies - mainly minimum wage changes and income transference programmes - do have a role in explaining regional inequality reduction during the period. [image omitted] Silveira Neto R. Da M. et Azzoni C. R. Les politiques gouvernementales non-spatiales et l`ecart des revenus regionaux au Bresil, Regional Studies. Cet article emploie des donnees a la fois macroeconomiques et microeconomiques afin d`analyser le role des programmes d`actions sociales quant a la baisse recente de l`ecart des revenus regionaux au Bresil. On presente des indicateurs de convergence pour diverses sources des revenus regionaux pour la periode allant de 1995 a 2006. Une decomposition du coefficient de Gini permet d`identifier le role de chacune de ces sources des revenus par rapport a la baisse de l`ecart des revenus pendant cette periode. Les resultats indiquent que la productivite du travail et les politiques gouvernementales non-spatiales - notamment la modification du salaire minimum et les programmes visant le transfert des revenus - ont un role a jouer pour expliquer la baisse de l`ecart des revenus regionaux pendant la periode en question. Convergence Productivite du travail Transfert des revenus Salaire minimum Effets spatiaux des politiques non-spatiales Silveira Neto R. Da M. und Azzoni C. R. Nicht raumliche Regierungspolitiken und das regionale Einkommensungleichgewicht in Brasilien, Regional Studies. In diesem Beitrag analysieren wir mit Hilfe von Makro- und Mikrodaten die Rolle von sozialen Programmen bei der unlangst erzielten Verringerung des regionalen Einkommensungleichgewichts in Brasilien. Wir stellen Konvergenz-Indikatoren fur verschiedene regionale Einkommensquellen im Zeitraum von 1995 bis 2006 vor. Eine Dekomposition des Gini-Indikators ermoglicht die Identifizierung der jeweiligen Rolle dieser Einkommensquellen fur die Verringerung des regionalen Ungleichgewichts im betreffenden Zeitraum. Die Ergebnisse weisen darauf hin, dass sowohl die Produktivitat der Arbeitskrafte als auch die nicht raumlichen Regierungspolitiken - in erster Linie Veranderungen beim Mindestlohn und Programme fur Einkommenstransfers - als Grunde fur die Verringerung des regionalen Ungleichgewichts in dieser Periode durchaus eine Rolle spielen. Konvergenz Arbeitsproduktivitat Einkommenstransfer Mindestlohn Raumliche Auswirkungen nicht raumlicher Politiken Silveira Neto R. Da M. y Azzoni C. R. Politicas gubernamentales no espaciales y desigualdades de ingresos regionales en Brasil, Regional Studies. En este articulo utilizamos datos macro y micro para analizar el papel de los programas sociales en la reciente reduccion en las desigualdades de ingresos regionales de Brasil. Presentamos los indicadores de convergencia para diferentes fuentes de ingresos regionales en el periodo de 1995 a 2006. Una descomposicion del indice Gini permite identificar el papel de cada una de estas fuentes de ingresos con respecto a la reduccion de las desiguadades regionales durante este periodo. Los resultados destacan que tanto la productividad laboral como las politicas no espaciales del gobierno - principalmente los cambios de salario minimo y los programas de transferencias de ingresos - desempenan una funcion a la hora de explicar la reduccion de las desigualdades regionales durante este periodo. Convergencia Productividad laboral Transferencias de ingresos Salario minimo Efectos espaciales de politicas no espaciales.