Nowadays, the world is facing disasters on an unprecedented scale: millions of people are affected by natural disasters globally each year and, only in the last decade, more than 80% of all disaster-related deaths were caused by natural hazards. Scientific predictions and evidence indicate that global climate changes are increasing the number of extreme events, creating more frequent and intensified natural hazards such as floods and windstorms. Population growth, urbanization and the inability of poor populations to escape from the vicious cycle of poverty are conditions to foresee that there will most likely be an increase in the number of people who are vulnerable to natural hazards, with a resulting increase of natural disasters and environmental emergencies. In recent years, international preoccupation for disasters and their impacts has intensified and risen closer to the top of the development agenda. For many years, response to disasters was largely confined to emergency relief and short-term life-saving actions. But over the last two decades, the critical importance of disaster preparedness, mitigation, and prevention has been widely recognized. The humanitarian and the United Nations system are therefore called to intensify their efforts to improve their capacity in order to provide support to the countries in need and to be better prepared to intervene. Such request came, amongst others, from the UN General Secretary in various occasions. In the frame of humanitarian operations, the World Food Programme (WFP) of the United Nations is in the front line. The WFP is the biggest UN Agency and responds to more than 120 emergencies per year worldwide. According to the UN reform, WFP is also the leader of logistics for UN and international bodies during emergency response operations. WFP initiated a process to reinforce its capacity to be a leading force in the area of emergency response, improving its Information Management capacity in support to emergency preparedness and response. To do so, an agreement of collaboration with the recently formed Information Technology for Humanitarian Assistance Cooperation and Action (ITHACA) Association has been signed and a joint collaboration started in February 2007. One of the objectives of the collaboration is about the use of Geomatics and Information Technology instruments in the Early Warning and Early Impact analysis field. Many worldwide experiences conducted in this area, show that the use of remote sensing and Geographic Information Systems (GIS) technologies, combined with up-to-date, reliable and easily accessible reference base geographic datasets, constitute the key factor for the success of emergency operations and for developing valuable natural disaster preparedness, mitigation and prevention systems. As a matter of fact, the unique characteristics associated with geographic, or geospatial, information technologies facilitate the integration of scientific, social and economic data through space and time, opening up interesting possibilities for monitoring, assessment and change detection activities, thus enabling better informed interventions in human and natural systems. Besides its proven value, the geospatial information is an expensive resource and needs to be fully utilized to maximize the return on investment required for its generation, management and use. Reuse and sharing of spatial information for multiple purposes is an important approach applied in countries where investment in spatial data collection and in their appropriate management has advanced on the basis of its known asset value. Very substantial economic benefits have been estimated by countries that have moved in the direction of optimizing data reuse. However, it is still relatively easy to find examples of projects and other development activities from around the globe that required expensive recapture of essential spatial data because they were originally captured in unique or non-standard file formats, or perhaps discarded after initial use. Recapture of data has also been undertaken in many cases simply because its prior existence was known only by its originators. The United Nations has not been immune to this problem, both within and between the multitude of entities that make up the Secretariat and its agencies, funds and programmes. Historically, the production and use of geospatial data within the UN entities has been accomplished by its component organizations, according to their individual needs and expertise. This has resulted in multiple efforts, reduced opportunities for sharing and reuse of data, and a unnecessary cost burden for the UN system as a whole. Thus, a framework data development approach has been considered necessary. This has resulted in the proposal that implement an UN Spatial Data Infrastructure (SDI). The term SDI is used to denote the relevant base collection of technologies, policies and institutional arrangements that facilitate the availability of and access to spatial data. A SDI hosts geographic data and attributes, sufficient documentation (metadata), a means to discover, visualize and evaluate the data (catalogues and Web mapping), and some methods to provide access to the geographic data. Beyond this, it will also host additional services or software to support applications of the data. The concept of developing a Spatial Data Infrastructure to fulfil UN data management needs was duly approved by United Nations Geographic Information Working Group (UNGIWG) members in 2005 at their 6th Plenary Meeting in Addis Ababa, in the context of a UN-specific SDI, or UNSDI. The WFP, like all other UN agencies, has been called to develop a Spatial Data Infrastructure, according to the UNGIWG recommendations. Therefore, during the last year the different units of WFP involved in the use of geospatial data worked at defining and implementing a WFP SDI with the aim of contributing at the whole UNSDI project. This effort was coordinated and supported by the ITHACA association. Aim of the study The objective of the conducted research has been to investigate the better solution for collecting and organizing geospatial data within a suitable geodatabase with two main purposes: to support the WFP SDI effort: the development of consistent reusable themes of base cartographic content, known as Framework, Fundamental or Core Data, is recognized as a main and first ingredient in the construction of a SDI. Therefore, the definition of a geodatabase supporting all the WFP units dealing with GIS and geospatial data can be considered a fundamental and necessary step in the whole complex process of the development of the WFP SDI. Common used data provide key for the integration and, in the context of the SDI implementation, the definition of a Core Data geodatabase can be thought as one instrumentality to help improving interoperability, reducing expenses resulting from the inevitable duplications. Moreover, the major aim of the planned geodatabase is to supply all WFP users of a "minimum spatial dataset" which assures valuable geographic analyses and mapping, in support to decision makers during emergencies operations. to support all activities carried out by ITHACA: the planned geodatabase must constitute a suitable instrument which realizes the integration and the organization of the large geospatial data needed by all ITHACA units in their activities, allowing their effective distribution, sharing and reuse, avoiding any duplication. Moreover, the implemented solution must also guarantee the correct management and updating of the data, keeping their integrity. Finally, this instrument must also allow the easy and fast sharing of necessary information produced by ITHACA during Early Impact activities with the WFP's users engaged in the emergencies rescue operations. In conclusion, the major expected output of the study carried out, described in this thesis, has been the design and the development of a global database and of related rules and procedures in order to correctly store, manage, and exchange geospatial data needed either by WFP humanitarian workers and ITHACA users. The developed database solution allows integrating and updating globally consistent geographic data coming from different sources in many formats, providing each user with the latest datasets, thus avoiding duplications and mistakes. In methodological terms, the following procedure has been adopted: - defining requirements, identification of all activities supported by the geodatabase, analysis of the data flows expected in all supported activities, examining existing data sources and relevant standards (particularly those proposed by the UNGIWG); - development of the data model. The data model has been shaped according to specific needs and demands of the involved user groups within the different interested organizations. The adopted design techniques do not wander off the techniques proposed in literature for general database design, even if it has been necessary, in some steps, to consider the specific features of geographic data; - geodatabase schema generation and implementation of the defined geographic database model as an ESRI ArcSDE Enterprise Geodatabase based on Oracle 10g as DBM
