1 / 13

Integrated Database System for Conflict-Affected Areas in Somalia

This system combines different types and sources of data to analyze food security and nutrition in conflict-affected areas of Somalia, providing analytical and operational elements for informed decision-making.

mackj
Download Presentation

Integrated Database System for Conflict-Affected Areas in Somalia

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related