Traducción técnica del capítulo III del libro Advanced Data Warehouse design: from conventional to spatial and temporal applications

The proposal to work on this final project came after several discussions held with Dr. Elzbieta Malinowski Gadja, who in 2008 published the book entitled Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications). The project was carried out under the technical supervision of Dr. Malinowski and the direct beneficiary was the University of Costa Rica (UCR) where Dr. Malinowski is a professor at the Department of Computer Science and Informatics. The purpose of this project was twofold: First, to translate chapter III of said book with the intention of generating educational material for the use of the UCR and, second, to venture in the field of technical translation related to data warehouse. For the first component, the goal was to generate a final product that would eventually serve as an educational tool for the post-graduate courses of the UCR. For the second component, this project allowed me to acquire new skills and put into practice techniques that have helped me not only to perfom better in my current job as an Assistant Translator of the Inter-American BAnk (IDB), but also to use them in similar projects. The process was lenggthy and required torough research and constant communication with the author. The investigation focused on the search of terms and definitions to prepare the glossary, which was the basis to start the translation project. The translation process itself was carried out by phases, so that comments and corrections by the author could be taken into account in subsequent stages. Later, based on the glossary and the translated text, illustrations had been created in the Visio software were translated. In addition to the technical revision by the author, professor Carme Mangiron was in charge of revising the non-technical text. The result was a high-quality document that is currently used as reference and study material by the Department of Computer Science and Informatics of Costa Rica.

Natural Science in the Bothnian Sea During 1975-2008: A Review

The Baltic Sea is one of the most studied areas in the world. However, parts of its northernmost reach, the Bothnian Sea, seem to be under represented in the natural scientific literature compared to other parts of the Baltic. The Bothnian Sea represents a unique inland sea environment for the scientific community to study due to its shallowness and low salinity. The natural sciences research carried out on the Bothnian Sea has been reviewed between 1975 and 2008. This time period was chosen to continue on from an earlier review paper ending in 1974. Along with the number of papers published the goal was also to review the content of the papers, indentifying dominating themes to evaluate gaps in the current knowledge on the Bothnian Sea and provide recommendations for topics of future research focus. In a classification into specific research topics biodiversity was the leading research focus followed by chemical and physical oceanography, pollution and toxins, and fish biology and fisheries. The current good condition of the Bothnian Sea is highly valued with its historically less eutrophic and clearer waters when compared to the Baltic. However, today the Bothnian Sea is facing eutrophication resulting from nutrient-rich water transported by the many rivers draining into it from Sweden and Finland making it an area in need of protection and preservation. More human activity will also concentrate on the Bothnian Sea in the future. Therefore the use of the sea and its coastal areas must be planned carefully to minimize the harmful effects of this increasing human activity. To achieve this more information is needed for the basis of Integrated Coastal Zone Management (ICZM) and maritime spatial planning (MSP). For example, for the Bothnian Sea the information on the underwater nature which is essential for ICZM is so far missing to a large extent. Specific biological, chemical and physical oceanographic information is needed to combine with economic analyses and environmental policies regarding this region. More research of a multidisciplinary nature is required on the unique Bothnian Sea environment and this we feel is best achieved through a joint Finnish-Swedish research strategy.

Geostical analysis of spatial dynamics of Citrus Variegated Chlorossis

The spatial dynamics of Citrus Variegated Chlorosis (CVC) was studied in a five-year old commercial orchard of 'Valencia' sweet orange (Citrus sp.) trees, located in the northern region of the state of São Paulo, Brazil. One thousand trees were assessed in 25 rows of 40 trees, planted at 8 x 5 m spacing. Disease incidence data were taken beginning in March 1994 and ending in January 1996, at intervals of four to five months. Disease aggregation was observed through the dispersion index analysis (Ib), which was calculated by dividing the area into quadrants. CVC spatial dynamics was examined using semivariogram analysis, which revealed that the disease was aggregated in the field forming foci of 10 to 14 m. For each well-fitted model, a kriging map was created to better visualize the distribution of the disease. The spherical model was the best fit for the data in this study. Kriging maps also revealed that the incidence of CVC increased in periods during which the trees underwent vegetative growth, coinciding with greater expected occurrence of insect vectors of the bacterium in the field.

Spatial and Spectral Separability of Grasslands in the inner Turku Archipelago using Landsat Thematic Mapper Satellite Imagery

The present study investigates the spatial and spectral discrimination potential for grassland patches in the inner Turku Archipelago using Landsat Thematic Mapper satellite imagery. The spatial discrimination potential was computed through overlay analysis using official grassland parcel data and a hypothetical 30 m resolution satellite image capturing the site. It found that Landsat TM imagery’s ability to retrieve pure or near-pure pixels (90% purity or more) from grassland patches smaller than 1 hectare was limited to 13% success, compared to 52% success when upscaling the resolution to 10 x 10 m pixel size. Additionally, the perimeter/area patch metric is proposed as a predictor for the suitability of the spatial resolution of input imagery. Regression analysis showed that there is a strong negative correlation between a patch’s perimeter/area ratio and its pure pixel potential. The study goes on to characterise the spectral response and discrimination potential for the five main grassland types occurring in the study area: recreational grassland, traditional pasture, modern pasture, fodder production grassland and overgrown grassland. This was done through the construction of spectral response curves, a coincident spectral plot and a contingency matrix as well as by calculating the transformed divergence for the spectral signatures, all based on training samples from the TM imagery. Substantial differences in spectral discrimination potential between imagery from the beginning of the growing season and the middle of summer were found. This is because the spectral responses for these five grassland types converge as the peak of the growing season draws nearer. Recreational grassland shows a consistent discrimination advantage over other grassland types, whereas modern pasture is most easily confused. Traditional pasture land, perhaps the most biologically valuable grassland type, can be spectrally discriminated from other grassland types with satisfactory success rates provided early growing season imagery is used.

Biogeochemistry in acid sulphate soil landscapes and small urban centres in Western Finland

The overall purpose of this thesis was to increase the knowledge on the biogeochemistry of rural acid sulphate (AS) soil environments and urban forest ecosystems near small towns in Western Finland. In addition, the potential causal relationship between the distribution of AS soils and geographical occurence of multiple sclerosis (MS) disease was assessed based on a review of existing literature and data. Acid sulphate soils, which occupy an area of approximately 17–24 million hectare worldwide, are regarded as the nastiest soils in the world. Independent of the geographical locality of these soils, they pose a great threat to their surrounding environment if disturbed. The abundant metal-rich acid drainage from Finnish AS soils, which is a result of sulphide oxidation due to artificial farmland drainage, has significant but spatially and temporally variable ecotoxicological impacts on biodiversity and community structure of fish, benthic invertebrates and macrophytes. This has resulted in mass fish kills and even eradication of sensitive fish species in affected waters. Moreover, previous investigations demonstrated significantly enriched concentrations of Co, Ni, Mn and Al, metals which are abundantly mobilised in AS soils, in agricultural crops (timothy grass and oats) and approximately 50 times higher concentrations of Al in cow milk originating from AS soils in Western Finland. Nevertheless, the results presented here demonstrate, in general, relatively moderate metal concentrations in oats and cabbage grown on AS soils in Western Finland, although some of the studied fields showed anomalous values of metals (e.g. Co and Ni) in both the soil and target plants (especially oats), similar to that of the previous investigations. The results indicated that the concentrations of Co, Ni, Mn and Zn in oats and Co and Zn in cabbage were governed by soil geochemistry as these metals were correlated with corresponding concentrations extracted from the soil by NH4Ac-EDTA and NH4Ac, respectively. The concentrations of Cu and Fe in oats and cabbage were uncorrelated to that of the easily soluble concentrations in the soils, suggesting that biological processes (e.g. plant-root processes) overshadow geochemical variation. The concentrations of K and Mg in cabbage, which showed a low spread and were strongly correlated to the NH4Ac extractable contents in the soil, were governed by both the bioavailable fractions in the topsoil and plant-uptake mechanisms. The plant´s ability to regulate its uptake of Ca and P (e.g. through root exudates) seemed to be more important than the influence of soil geochemistry. The distribution of P, K, Ca, Mg, Mn and S within humus, moss and needles in and around small towns was to a high degree controlled by biological cycling, which was indicated by the low correlation coefficients for P, K, Ca, Mg and S between humus and moss, and the low spread of these nutrients in moss and needles. The concentration variations of elements in till are mainly due to natural processes (e.g. intrusions, weathering, mineralogical variations in the bedrock). There was a strong spatial pattern for B in humus, moss and needles, which was suggested to be associated with anthropogenic emissions from nearby town centres. Geogenic dust affected the spatial distribution of Fe and Cr in moss, while natural processes governed the Fe anomaly found in the needles. The spatial accumulation patterns of Zn, Cd, Cu, Ni and Pb in humus and moss were strong and diverse, and related to current industry, the former steel industry, coal combustion, and natural geochemical processes. An intriguing Cu anomaly was found in moss. Since it was located close to a main railway line and because the railway line´s electric cables are made of Cu, it was suggested that the reason for the Cu anomaly is corrosion of these cables. In Western Finland, where AS soils are particularly abundant and enrich the metal concentrations of stream waters, cow milk and to some extent crops, an environmental risk assessment would be motivated to elucidate if the metal dispersion affect human health. Within this context, a topic of concern is the distribution of multiple sclerosis as high MS prevalence rates are found in the main area of AS soils. Regionally, the AS soil type in the Seinäjoki area has been demonstrated to be very severe in terms of metal leaching, this area also shows one of the highest MS rates reported worldwide. On a local scale, these severe AS soil types coincide well with the corresponding MS clustering along the Kyrönjoki River in Seinäjoki. There are reasons to suspect that these spatial correlations are causal, as multiple sclerosis has been suggested to result from a combination of genetic and environmental factors.

Potential impact of the global climate changes on the spatial distribution of areas of risk for the occurrence of eucalyptus rust in Brazil

Rust, caused by Puccinia psidii, is one of the most important diseases affecting eucalyptus in Brazil. This pathogen causes disease in mini-clonal garden and in young plants in the field, especially in leaves and juvenile shoots. Favorable climate conditions for infection by this pathogen in eucalyptus include temperature between 18 and 25 ºC, together with at least 6-hour leaf wetness periods, for 5 to 7 consecutive days. Considering the interaction between the environment and the pathogen, this study aimed to evaluate the potential impact of global climate changes on the spatial distribution of areas of risk for the occurrence of eucalyptus rust in Brazil. Thus, monthly maps of the areas of risk for the occurrence of this disease were elaborated, considering the current climate conditions, based on a historic series between 1961 and 1990, and the future scenarios A2 and B2, predicted by IPCC. The climate conditions were classified into three categories, according to the potential risk for the disease occurrence, considering temperature (T) and air relative humidity (RH): i) high risk (18 < T < 25 ºC and RH > 90%); ii) medium risk (18 < T < 25 ºC and RH < 90%; T< 18 or T > 25 ºC and RH > 90%); and iii) low risk (T < 18 or T > 25 ºC and RH < 90%). Data about the future climate scenarios were supplied by GCM Change Fields. In this study, the simulation model Hadley Centers for Climate Prediction and Research (HadCm3) was adopted, using the software Idrisi 32. The obtained results led to the conclusion that there will be a reduction in the area favorable to eucalyptus rust occurrence, and such a reduction will be gradual for the decades of 2020, 2050 and 2080 but more marked in scenario A2 than in B2. However, it is important to point out that extensive areas will still be favorable to the disease development, especially in the coldest months of the year, i.e., June and July. Therefore, the zoning of areas and periods of higher occurrence risk, considering the global climate changes, becomes important knowledge for the elaboration of predicting models and an alert for the integrated management of this disease.

POPULATION STRUCTURE AND SPATIAL DISTRIBUTION OF Bauhinia cheilantha (Bong.) Steud. IN TWO FRAGMENTS AT DIFFERENT REGENERATION STAGES IN THE CAATINGA, IN SERGIPE, BRAZIL

ABSTRACTThis study aimed to analyze the vertical and diameter structure and the spatial distribution pattern of Bauhinia cheilantha in two Caatinga fragments in Sergipe, Brazil, at different regeneration stages. Thirty plots were demarcated in area I (Canindé de São Francisco and Poço Redondo), which has vegetation regeneration, and 25 plots in area II (Porto da Folha) with preserved vegetation, both having 400 m2. All B. cheilanthaindividuals had their height and circumference (circumference at breast height > 6 cm) measured. Possible differences in height and diameter at breast height were tested in the two populations by using Student’s T-test. The distribution pattern of species was calculated through Payandeh’s index. We sampled 154 B. cheilantha individuals, equivalent to 33.3% of the plots in area I and in 1,027 individuals in area II, totaling 100% frequency. Height and the diameter of the two populations were statistically different, where AI achieved all values lower than AII. The spatial distribution pattern of B. cheilantha found in both areas was aggregate, with values of 11.85 and 9.00, respectively. Thus, it became clear that the population in AII is at a more advanced successional status than AI, due to its longer conservation time.

Spatial variability of leaf wetness duration in a 'Niagara Rosada' vineyard

Despite considerable efforts to develop accurate electronic sensors to measure leaf wetness duration (LWD), little attention has been given to studies about how is LWD variability in different positions of the crop canopy. In order to evaluate the influence of 'Niagara Rosada' (Vitis labrusca) grapevine structure on the spatial variability of LWD, the objective of this study was to determine the canopy position of the ‘Niagara Rosada’ table grape with longer LWD and its correlation with measured standard LWD over turfgrass. LWD was measured in four different canopy positions of the vineyard (sensors deployed at 45º with the horizontal): at the top of the plants, with sensors facing southwest and northeast (Top-SW and Top-NE), and at the grape bunches height, with sensors facing southwest and northeast (Bottom-SW and Bottom-NE). No significant difference was observed between the top (1.6 m) and the bottom (1.0 m) of the canopy and also between the southwest and northeast face of the plants. The relationship between standard LWD over turfgrass and crop LWD in different positions of the grape canopy showed a define correlation, with R² ranging from 0.86 to 0.89 for all period, from 0.72 to 0.77 for days without rain, and from 0.89 to 0.91 for days with rain.

Terrain forms and spatial variability of soil properties in an area cultivatedwith citrus

The technique of precision agriculture and soil-landscape allows delimiting areas for localized management, allowing a localized application of agricultural inputs and thereby may contribute to preservation of natural resources. Therefore, the objective of this work was to characterize the spatial variability of chemical properties and clay content in the context of soil-landscape relationship in a Latosol (Oxisol) under cultivation of citrus. Soil samples were collected at a depth of 0.0-0.2 m in an area of 83.5 ha planted with citrus, as a 50-m intervals grid, with 129 points in concave terrain and 206 points in flat terrain, totaling 335 points. Values for the variables that express the chemical characteristics and clay content of soil properties were analyzed with descriptive statistics and geostatistical modeling of semivariograms for making maps of kriging. The values of range and kriging maps indicated higher variability in the shape of concave topography (top segment) compared with the shape of flat topography (slope and hillside segments below). The identification of different forms of terrain proved to be efficient in understanding the spatial variability of chemical properties and clay content of soil under cultivation of citrus.

GPS receivers for georeferencing of spatial variability of soil attributes

The characterization of the spatial variability of soil attributes is essential to support agricultural practices in a sustainable manner. The use of geostatistics to characterize spatial variability of these attributes, such as soil resistance to penetration (RP) and gravimetric soil moisture (GM) is now usual practice in precision agriculture. The result of geostatistical analysis is dependent on the sample density and other factors according to the georeferencing methodology used. Thus, this study aimed to compare two methods of georeferencing to characterize the spatial variability of RP and GM as well as the spatial correlation of these variables. Sampling grid of 60 points spaced 20 m was used. For RP measurements, an electronic penetrometer was used and to determine the GM, a Dutch auger (0.0-0.1 m depth) was used. The samples were georeferenced using a GPS navigation receiver, Simple Point Positioning (SPP) with navigation GPS receiver, and Semi-Kinematic Relative Positioning (SKRP) with an L1 geodetic GPS receiver. The results indicated that the georeferencing conducted by PPS did not affect the characterization of spatial variability of RP or GM, neither the spatial structure relationship of these attributes.