Integrated Database System for Conflict-Affected Areas in Somalia

1. Data from Conflict- Affected Areas - Filling in the Blanks June 10th 2011 Food Security and Nutrition Analysis Unit Somalia Fostering conflict data synergies – combining types and sources Swiss Agency for Development SDC EUROPEAN COMMISSION

2. FSNAU Food Security and Nutrition Analysis System (FSNAS) Integration of Conceptual, Analytical & Operational Elements for Analyzing Food Security with a Livelihoods Approach Discrete Event Analysis shocks/seasons Describe & Quantify (nature, magnitude, historic comp, spatial extent, affected pop., effects on livelihoods) Analytical Sectors Core Analytical Activities Analytical Processes Linking Information To Action Agriculture Macro Level Analysis: political, socio-economic, civil, institutional, historical, bio-physical, cultural… Nutrition Nutrition Situation Classification Seasonal Food Security Analysis and Projections Early warning & Interventions Markets Livelihood System Effects / Causes Describe & Quantify Affects on Livelihood Strategies & Assets Climate Integrated Phase Classification Meso Level Baseline Livelihoods Analysis vulnerability, hazards Livelihood Strategies income & food sources, expenditures, coping strategies Livelihood Assets human, natural, social, physical, and financial capitals Nutrition Surveillance and Analysis Analysis of Trends & Causes Conflict Summary Statement Linking Analysis to Intervention Livelihoods Key Indicator Monitoring Macro and Community Early Warning, Projections Livestock Actual & Projected Food Security & Nutrition Outcomes Describe & Quantify Number, location, social groups, duration through analysis of access, availability, stability utilization, and resilience resilience, risk Mangmnt) Urban Communication Strategy Emergency Food Security and Nutrition Assessment Early warning & Interventions Humanitarian Relief Recovery & Rehabilitation Sustainable Development Policy Formulation Applied Research Underlying and Long-term Dynamics Micro Level Analysis: Gender, hh resource allocation, care, utilization, social services… Information Management Operations Personnel Management Institutional Relationships

3. ORGANOGRAM

4. The Integrated Database System (IDS) • MySQL data platform for storing all the datasets including, nutrition, crop, livestock, imports and exports • Uses common geographical data/units (districts, zones, livelihood zones) to integrate different sources • Trend analysis can be conducted for data from different sources

5. The Integrated Database System (IDS) • Nutrition:- stored in excel sheets that are imported into the MySQL database. • Crop data:- yield, area cultivated and production estimates. Available in excel sheets dating as far back as 1995 • Livestock exports:- data from official statistics in the ports of Berbera and Bossaso. Dates back since 1994 and available for camel, cattle, goats and sheep. • Cereal imports data:- source is also official port statistics, since 1999. Stored in excel sheets • Markets data:- data from more than 40 markets  • available for over 50 commodities including food • and a variety of non-food items important for a typical • household in Somali context. Available via the web and • dates as far back as 1994. • Baselines:- livelihood based datasets that define the • livelihood systems of Somalia. Currently being updated. • Data available internally in form of excel spreadsheets • and reports

6. www.fsnau.org

7. Web Registration and Access A web-based query interface for accessing FSNAU’s datasets; it has export facilities to MS Excel as well as dynamic graphing for selected datasets; Datasets featured include:- Market data; Livestock data; Import/Export data (Exports: camels, cattle, gum/frankincense, hides/skins, shoats | Imports: pasta, rice, sugar, wheat flour); Crop data; Nutrition data. Currently, there are 254 registered users.

8. Components of the IDS

9. The Field Integrated Database System (FIDS) A field based application that allows field staff to connect to the database in Nairobi remotely. Updates and synchronizes data between Nairobi and field automatically. Ensures data cleaning and validation is effected across the field and Nairobi automatically

10. Nutrition Situation AnalysisIntegrated analysis 6 months using data from a range of sources including:Nutrition AssessmentsRapid MUAC assessmentsHIS dataSelective Feeding CentresDisease SurveillancePartner secondary dataUsed for identifying priority area and monitoring trends

11. Integrated Food Security Phase Classification Combined IPC Populations January – June 2011 • It is a tool for classifying food security in five phases • generally food secure • chronically food insecure • acute food and livelihood crisis • humanitarian emergency • famine/humanitarian catastrophe • The IPC is not an assessment method per se. • It integrates information and analyses from diverse sources to classify food security according to indicators that are drawn from recognized international standards (e.g. on nutrition). • The approach developed by FSAU is now a global interagency initiative and has been rolled out in several countries and is going through an intensive review

12. IPC Review ongoing over the last 2 years – commissioned specific studies and many consultation with field and TAGIPC Version 2 due to the coming monthswww.ipcinfo.org