Resources ¶

• ​3W OCHA has been contacted via ​FIS-OCHA@un.org for information about formats that would be useful for data exchange.
• ​3W Search gives insight into how their data model is structured.
• ​3W Version 3.10 Database Schema and Application
• ​Google Doc with largely complete XML schema based on the 3W DB schema

CSV Import Formats for 3W Data ¶

​Taken form the interface of the 3W Application. The 3W application can import data from CSV files.

Items in bold are mandatory.

Organizations CSV Format ¶

"Organization Name", "Organization Acronym", "Organization Type Name", "Organization Web Site", "Organization Cluster Lead", "Total National Staff", "Total International Staff", "Total Number of Vehicles", "Types of Vehicles ( separated by , )" (end of line)

Offices CSV Format ¶

"Organization Name", "Office Name", "Office Type", "Office Status", "Land Phone (separated by ,)", "Email ", "Fax", "Address 1", "Address 2", "Zip/Postal "Zip/PostalOther Info", "Country", "Admin1Name", "Admin2Name", "Admin3Name", "Admin4Name", "PCode", "Latitude", "Longitude", (end of line)

Contacts CSV Format ¶

"Organization Name Or Acronym", "Sector (separated by , )", "Salutation", "First Name", "Last Name", "Title", "Mobile Phone", "Sat Phone", "Land Phone", "Email ( separated by , )", "Address 1", "Address 2", "Zip/Postal Code", "Country", "Admin1Name", "Admin2Name", "Admin3Name", "Admin4Name", "Responsibility (Head of Office / Security Focal Point / Public Information Liaison Officer/ Cluster Chair /Cluster CoChair - separated by , )", "Mission End Date (dd/mm/yyyy)", "Radio Call Sign", "Fax", "Mailing Group (separated by , )", "Theme ( separated by , )", "Office", "Privacy Status" (end of line)

Projects CSV Format ¶

"Organization Name", "Sector\Cluster Name" , "Sub Sector Name", "Country Name", "Admin 1 Name", "Admin 2 Name", "Admin 3 Name", "Admin 4 Name", "Place Name", "Project Title", "Project Objective", "Project Description", "Primary Beneficiary", "Number of Primary Beneficiaries", "Secondary Beneficiary (separated by , )", "Number of Secondary Beneficiaries", "Implementing Partners (separated by , )", "Project Type", "Project Status", "Project Theme", "CAP #", "Estimated Start Date (dd/mm/yyyy)", "Estimated End Date (dd/mm/yyyy)", "Funding Amount", "Funding Currency", "Funding Type", "Funding Status", "Funding Reported to FTS (Yes or No)", "Organization Funding Details For each organization funding the project, the details include: Organization Name,Amount Funded,Funding Currency;(separate the data by comma ,) (For multiple organizations separate each Organization's Dataset by a semi-colon ;) Example: "Org1,100000,US$ ; Org2,20000,Pound"" (end of line)

Place Names CSV Format ¶

"Place Name", "Place Type", "PCode", "Latitude Y", "Longitude X","Country", "Admin1Name", "Admin2Name", "Admin3Name", "Admin4Name", (end of line)

3W OCHA Controlled Vocabularies ¶

​Taken form the interface of the 3W Application.

Organization Type ¶

• Donor
• Government
• International NGO
• International Organization
• National NGO
• Military
• United Nations

Office Type ¶

• Headquarters
• Regional
• Country
• SubOffice
• Satellite Office

Office Status ¶

• Planned
• Establishing Office
• Operational
• Temporary Suspension
• Closed

Responsibility ¶

• Head Of Office
• Cluster Chair
• Cluster Co Chair
• Security Focal Point
• Public Information Liaison Officer

Vehicle Type ¶

• 4x4 - Land Cruiser
• Truck - 1 Tonne
• Truck - 5 Tonnes
• Truck - 15 Tonnes +
• Passenger Bus
• Motor Cycle

Cap Sector/Sector/Cluster ¶

• Agriculture
• Camp Coordination and Camp Management
• Capacity Building
• Coordination and Support Services
• Early Recovery
• Education
• Emergency Shelter
• Emergency Telecommunications
• Environment
• Food
• Health
• Logistics
• Mine Action
• Multi-Sector
• Nutrition
• Protection
• Security
• Water Hygiene and Sanitation

Project Type ¶

• DDR - Demobilization, Disarmament and Reintegratio
• Development
• Humanitarian Relief
• 3Rs - Recovery, Rehabilitation and Reconstruction

Project Status ¶

• Project Formulation and Design
• Approved
• Proposal
• Approved but Pending (Financing, Personnel,etc)
• Under Implementation
• Completed

Beneficiaries ¶

• Children
• Cooperatives
• Disadvantaged
• Family
• Gender
• General Population
• Handicapped/Disabled
• Host Community
• Institutions and Agencies
• Internally Displaced Persons
• Minorities
• Orphanages
• PLWHA - People Living With HIV/AIDS
• Population in Selected Provinces
• Pregnant and Nursing Women
• Refugees
• Returnees
• Rural Population
• Urban Population
• Vulnerable Population
• Women

Funding Type ¶

• Bi-Lateral
• Multi-Lateral

Funding Status ¶

• Approved
• Pending Approval
• Received

Project Theme ¶

• Aid co-ordination
• Avian Influenza
• Children
• Civil/Military Relations
• Conflict Prevention
• Demobilization, Disarmament and Reintegration
• Disability
• Drug Abuse
• Education
• Energy
• Engagement with Non-State Actors
• Environment and Sustainable Management
• Food and Agriculture
• Gender
• Good Humanitarian Donorship (GHD)
• Health and Disease Prevention
• HIV/AIDS
• Human Security
• Information Management
• Internally Displaced People
• Management Development
• Natural Diseases
• NGOs
• Orphanage
• Other
• Peace Building
• Peacekeeping
• Population
• Poverty Eradication
• Private Sector
• Refugees and Returnees
• Sanctions
• Security
• Technical co-operation with countries
• Transfer and adaptation of technology
• Transition
• Transport, storage and logistics
• Water and Sanitation
• Youth

Place Name Type ¶

• IDP Camp
• Refugee Camp
• Settlement