Information systems for water resources management improvement in developing countries

Water resources management, as also water service provision projects in developing countries have difficulties to take adequate decisions due to scarce reliable information, and a lack of proper information managing. Some appropriate tools need to be developed in order to improve decision making to improve water management and access of the poorest, through the design of Decision Support Systems (DSS). On the one side, a DSS for developing co-operation projects on water access improvement has been developed. Such a tool has specific context constrains (structure of the system, software requirements) and needs (Logical Framework Approach monitoring, organizational-learning, accountability and evaluation) that shall be considered for its design. Key aspects for its successful implementation have appeared to be a participatory design of the system and support of the managerial positions at the inception phase. A case study in Tanzania was conducted, together with the Spanish NGO ONGAWA – Ingeniería para el Desarrollo. On the other side, DSS are required also to improve decision making on water management resources in order to achieve a sustainable development that not only improves the living conditions of the population in developing countries, but that also does not hinder opportunities of the poorest on those context. A DSS made to fulfil these requirements shall be using information from water resources modelling, as also on the environment and the social context. Through the research, a case study has been conducted in the Central Rift Valley of Ethiopia, an endhorreic basin 160 km south of Addis Ababa. There, water has been modelled using ArcSWAT, a physically based model which can assess the impact of land management practices on large complex watersheds with varying soils, land use and management conditions over long periods of time. Moreover, governance on water and environment as also the socioeconomic context have been studied.

Non-conventional water resources in coastal areas: a review of the use of reclaimed water

In an era of increasing concern for limited water resources a wise joint management of conventional and nonconventional water resources must be considered. Water scarcity aggravates in coastal zones which are often characterised by high population density, intense economic activity and tourism; meaning heavy seasonal water demands. The relationships between sea and land-water can also compromise the quality of available freshwater. In this context, the use of non-conventional water increases the availability of water supplies. Non-conventional water resources of low quality could be directed to meet several needs (like watering lawns, washing cars, flushing toilets and cooling systems, among others). Therefore, significantly more potable water would be available to meet human demand for safe water.

Impacts of climate change on water resources in the Mediterranean basin : a case study in Catalonia, Spain

Most climate change projections show important decreases in water availability in the Mediterranean region by the end of this century. We assess those main climate change impacts on water resources in three medium-sized catchments with varying climatic conditions in north-eastern Spain. A combination of hydrological modelling and climate projections with B1 and A2 IPCC emission scenarios is performed to infer future stream flows. The largest reduction (22-48% for 2076-2100) of stream flows is expected in the headwaters of the two wettest catchments, while lower decreases (22-32% for 2076-2100) are expected in the drier one. In all three catchments, autumn and summer are the seasons with the most notable projected decreases in stream flow, 50% and 34%, respectively (2076-2100). Thus, ecological flows might be noticeably impacted by climate change in the catchments, especially in the headwaters of those wet catchments.

Ra isotopes and Rn as a tool for the water management resources: the Alberquillas aquifer (Málaga-Granada)

The aim of this project is to evaluate the importance of submarine groundwater discharge sector in order to improve the water balance in Málaga-Granada region. The approach of this study arose from the the geology and the aquifers that indicate that there could be some discharge to the sea between Maro (Málaga) and Almuñécar (Granada) and the Andalusian’s Government and its Water Agence were really interested in evaluating it because there is a lot of population and few water available and the magnitude of groundwater discharge has generated controversy. Is well known that water is a scarce resource in this area and it’s very important for the society and for the environment. The legislation, the water policies, the knowledge of the aquifer and the geology, the water dynamics, the land use and the water perception in the society might help the management of this resource not just in Andalusia but in all the Mediterranean basin. The main objective is to evaluate the submarine groundwater discharge from the Alberquillas Aqufier to the sea by measuring 222Rn and Ra isotopes. Specific objectives have been established to achieve the main objective: A) Reveal the importance of water resources in the Mediterranean basin; B) Learn radiometric techniques for the study of groundwater discharge to the sea; C) Learn of sampling techniques of water samples for the measurement of Ra and Rn; D) Learn the techniques for measuring Ra (RaDeCC) and Rn (RAD7); E) Interpretation and discussion of results. During this semester, and in addition of the present study in Málaga- Granada region, the author has participated in the initial phase (sampling, analysis and interpretation of preliminary results) of other research projects focused on the study of submarine groundwater discharges through the use of Ra isotopes and 222Rn. These studies have been developed in different areas, including Alt Empordà (Roses and Sant Pere Pescador), Maresme with CMIMA’s group (Mediterranean Center for Marine and Environmental Research), Delta de l’Ebre, Peñíscola and Mallorca with the IMEDEA’s group (Mediterranean Institute for Advanced Studies).

Assessing the environmental impact of water consumption by energy crops grown in Spain

The environmental impact of the water consumption of four typical crop rotations grown in Spain, including energy crops, was analyzed and compared against Spanish agricultural and natural reference situations. The life cycle assessment (LCA) methodology was used for the assessment of the potential environmental impact of blue water (withdrawal from water bodies) and green water (uptake of soil moisture) consumption. The latter has so far been disregarded in LCA. To account for green water, two approaches have been applied: the first accounts for the difference in green water demand of the crops and a reference situation. The second is a green water scarcity index, which measures the fraction of the soil-water plant consumption to the available green water. Our results show that, if the aim is to minimize the environmental impacts of water consumption, the energy crop rotations assessed in this study were most suitable in basins in the northeast of Spain. In contrast, the energy crops grown in basins in the southeast of Spain were associated with the greatest environmental impacts. Further research into the integration of quantitative green water assessment in LCA is crucial in studies of systems with a high dependence on green water resources.

Disentangling water usage in the European Union: A decomposition analysis

The Water Framework Directive (WFD) defines common objectives for water resources throughout the European Union (EU). Given this general approach to water preservation and water policy, the objective of this paper is to analyse whether common patterns of water consumption exist within Europe. In particular, our study uses two methods to reveal the reasons behind sectoral water use in all EU countries. The first method is based on an accounting indicator that calculates the water intensity of an economy as the sum of sectoral water intensities. The second method is a subsystem input‐output model that divides total water use into different income channels within the production system. The application uses data for the years 2005 and 2009 on water consumption in the production system of the 27 countries of the EU. From our analysis it emerges that EU countries are characterized by very different patterns of water consumption. In particular water consumption by the agriculture sector is extremely high in Central/Eastern Europe, relative to the rest of Europe. In most countries, the water used by the fuel, power and water sector is consumed to satisfy domestic final demand. However, our analysis shows that for some countries exports from this sector are an important driver of water consumption. Focusing on the agricultural sector, the decomposition analysis suggests that water usage in Mediterranean countries is mainly driven by final demand for, and exports of, agricultural products. In Central/Eastern Europe domestic final demand is the main driver of water consumption, but in this region the proportion of water use driven by demand for exports is increasing over time. Given these heterogeneous water consumption patterns, our analysis suggests that Mediterranean and Central/Eastern European countries should adopt specific water policies in order to achieve efficient levels of water consumption in the European Union. JEL codes: N5; C67 Keywords: Water use, Subsystem input–output model; Water intensity, European Union.

Payments for environmental services in watersheds: insights from a comparative study of three cases in Central America

We have compared three cases of payments for water-related environmental services (PES) in Central America, in terms of socioeconomic background, opportunity costs of forest conservation and stakeholders’ perceptions on the conditions of water resources and other issues. We found that, in general, the foregone benefits from land uses alternative to forest cover are larger than the amount paid, which apparently contradicts the economic foundation of PES schemes. A number of possible explanations are explored. The results also suggest that trade-offs between different environmental and social goals are likely to emerge in PES schemes, posing some doubts on their ability to be multipurpose instruments for environmental improvement and rural development. We also found that PES schemes may work as a conflictresolution instrument, facilitating downstream -upstream problem solving, though at the same time they might introduce changes in social perceptions of property rights.

Gestió dels recursos hídrics del Monestir Budista Sakya Tashi Ling

Amb la finalitat de millorar l’autosuficiència hídrica del monestir budista del Garraf Sakya Tashi Ling, es fa una avaluació de l’estat dels recursos hídrics d’aquest sistema, així com els seus usos i punts de consum. L’avaluació s’ha realitzat mitjançant la integració i ús de paràmetres mediambientals, hídrics i arquitectònics. Amb l’estimació d’entrades i consums d’aigua, juntament amb els càlculs realitzats, s’ha diagnosticat l’estat actual del sistema. Mitjançant la realització d’un inventari dels diferents equipaments i dispositius instal·lats en els punts de consum d’aigua, s’han detectat mancances en la eficiència hídrica com l’escassa implementació de dispositius d’estalvi hídric o la inexistent captació de les aigües pluvials. El diagnòstic de les mancances ha orientat les propostes de millora aplicables al sistema. Aquestes incideixen principalment en la millora de l’estalvi d’aigua amb la instal·lació de dispositius estalviadors i en la captació d’aigües pluvials mitjançant una xarxa de recollida, emmagatzematge i distribució.

Ecoetiqueta de serveis i aprofitament dels recursos hídrics i energètics als establiments hotelers de Sitges

Aquest projecte té com a objectiu l’estudi de l’estat ambiental dels hotels del municipi de Sitges i l’estudi d’aprofitament dels recursos hídrics i energètics característics d’aquesta zona del Mediterrani per hotels de 4 i 5 estrelles. Sitges és un municipi que al període estival dobla la població, i que amb una superfície de 43,85 Km2 conta amb 35 hotels i apart pensions, hostals i càmpings, per tant, el turisme és l’activitat més important a Sitges. Per desenvolupar aquest projecte s’ha realitzat una enquesta senzilla sobre qualitat ambiental per conèixer el comportament ambiental dels diferents hotels. En aquest estudi han participat 15 dels 35 hotels del municipi, ja que el 49% d’aquests romanen tancats des d’Octubre fins a Març i dels 18 hotels restants 15 han accedit a formar part d’aquest estudi. A través d’una prova pilot s’ha avaluat la implantació del Distintiu de Garantia de Qualitat Ambiental a l’hotel Antemare i a l’hotel Sunway Playa Golf, aquests dos hotels pertanyen a la categoria de quatre estrelles, categoria que reuneix més nombre d’hotels i el tant per cent d’ocupació és major en comparació amb les altres categories. El DGQA és una ecoetiqueta de serveis que atorga la Generalitat de Catalunya a partir de la revisió de l’establiment per mitjà d’un tècnic autoritzat. S’ha analitzat l’aprofitament dels recursos local com, les aigües pluvials i la radiació solar en els hotels de 4 i 5 estrelles per obtenir l’autosuficiència individual dels 9 hotels objecte d’estudi. Els resultats obtinguts en aquest estudi reflecteixen la possibilitat de millorar l’estat ambiental dels establiments hotelers, duent a terme alguns criteris bàsics com, la recollida selectiva i una major implantació d’energies renovables, així com també la utilització d’aquestes per assolir un cert nivell d’autosuficiència energètica i hídrica. La prova pilot mostra que els dos hotels estudiats estan molt a prop d’aconseguir el DGQA, els vectors on s’haurien de fer millores són, informació ambiental, energia, aigua i residus.

TFC Magatzems de dades: construcció i explotació d'un magatzem de dades de planificació hidrològica

Aquest TFC consisteix en la creació d'un magatzem de dades que automatitzi la recollida de dades de l'estat dels embassaments de la Confederació Hidrogràfica Nord-Est mitjançant processos ETL, per posteriorment tractar aquestes dades amb processos PL/SQL amb l'objectiu de poder explotar aquestes dades mitjançant eines de Business Intelligence.

Construcción y explotación de un almacén de datos de planificación hidrológica

Construcción y explotación de un almacén de datos de planificación hidrológica para la Confederación Hidrográfica del Norte y Este.

Construcció i explotació d'un magatzem de dades de planificació hidrològica

Memòria del treball de fi de carrera on s'ha construït i explotat un magatzem de dades, partint d'unes dades en un sistema OLTP a un sistema multidimensional OLAP, tot això sobre amb les eines Oracle Express Edition 10v i Oracle Discoverer.

Construcción y explotación de un almacén de datos de planificación hidrológica

Este documento es la memoria del trabajo de final de carrera (TFC) del área de almacenes de datos, dentro de los estudios de Ingeniería Técnica en Informática de Gestión de la Universitat Oberta de Catalunya (UOC).El proyecto a desarrollar en dicho TFC versa sobre el diseño, implementación y explotación de un almacén de datos para la Confederación Hidrográfica del Noreste (CHNE). Partiendo de sus fuentes de datos construiremos un almacén de datos del cual poder obtener un conjunto de informes predefinidos, según las especificaciones del CHNE.

Construcción y explotación de un almacén de datos de planificación hidrológica

Este documento describe el plan de trabajo, el análisis y la implementación del trabajo de fin de carrera de los estudios de Ingeniería Técnica de Informática de Gestión, en concreto del área de almacén de datos.El objetivo de este trabajo es familiarizarse con la arquitectura de un DW: el diseño de un DW, tratamiento de datos, así como conocer las herramientas de que dispone el mercado para trabajar con estos modelos y realizar los análisis dirigidos a usuarios finales.

Projecte de viabilitat de la proposta de gestió de les aigües pluvials al municipi de Begur

Estudi sobre les riuades provocades per les pluges torrencials al municipi de Begur i proposta d’un projecte alternatiu més sostenible respecte al creat per l’Ajuntament sobre la gestió d’aquestes aigües pluvials