WFP and UNJLC SDI development and implementation

1
WFP and UNJLC SDIdevelopment and implementation
In cooperation with
2
Partners

• WFP (OMEP and VAM units)
• UN Joint Logistics Centre is a Humanitarian
  Common Service hosted by, and under financial
  oversight of WFP and mandated by the Inter-Agency
  Standing Committee (IASC). UNJLC aim is to
  facilitate and support the coordination of
  logistics capabilities among co-operating
  humanitarian partners, as well as complement and
  support the global and field Logistics Cluster
  through interalia the provision of Information
  Management services, (prioritization, GIS,
  infrastructures, commodities tracking,
  assessments, information sharing through meetings
  and reporting formats).
• ITHACA is a non-profit association, founded in
  November 2006 by the Politecnico of Torino and
  the Higher Institute on Innovation Territorial
  Systems. The Association proposes itself as a
  center of applied research and for the
  distribution of products and services related to
  Information Technology in support of humanitarian
  activities.
• In collaboration with UNOSAT, Columbia
  University - CIESIN, JRC - ISPC Institute -
  Critech Unit

3
General Purpose

• Fulfill UNGIWG requirements in terms of UNSDI
  development
• Data Services
• More efficient search of, and access to data in
  emergencies
• Develop core maps to avoid duplication.
• Standards
• Active support to implementation of standards
• Certification of spatial data/SDI that adhere to
  standards
• Access to standards and best practices for data
  collection, analysis and sharing
• Standards at international and national levels.
• Metadata
• Standardized Metadata population and the
  development of catalogue services
• Facilitate metadata creation, discover, retrieval
  and visualization.
• Capacity building
• Development of national capacity
• Repository of common technical knowledge
• Strengthening of GIS/Remote Sensing units within
  respective agencies.
• Organizational
• Focus more on governance and sustainability than
  mere technology
• Build partnerships.

4
Technical ApproachGeneral considerations

• Re-use and re-organization of currently managed
  dataset is has been a priority in the data
  modelling phase, together with direct access to
  open geographic sources (SRTM, archive satellite
  images, etc.) without any need for data
  pre-processing
• Based on the data structure submitted and
  approved by WFP units (ODAP, VAM and UNJLC), a
  UML data model has been consolidated and
  implemented using, as DBMS platform, an ORACLE
  10g database
• Interoperability and Open Source based
  architecture requirements must be combined with
  the necessity of already known, consolidated and
  ready-to-use solutions
• The development of representation rules and map
  templates allow to create a lowest common
  denominator for geographic analysis and mapping,
  in support to decision making during emergencies.

5
Specific Goals/Deliverables

• A Spatial Data Infrastructure (SDI) can be
  defined as an umbrella of policies, standards,
  terminology and procedures under which
  organizations and technologies interact to foster
  more efficient use, management and production of
  geo-spatial data

• A solid production/editing environment, accessed
  by high level users in charge of database
  management and of performing complex data
  analysis procedures
• A publication/analysis environment, for the
  broader community and dedicated to analysis,
  processing of project specific geographic data
  and exploratory aspects simple editing
  capabilities should be also included.

6
DataStandards
Compliant product
Registered product
7
Technical ApproachSystem architecture

• Database production network the architecture of
  the geodatabase servers, including
• master Geodatabase
• replica Geodatabase
• publication GeoDB.
• Internal backup and restore network
• Web Server The architecture of the system is
  composed by two servers with the same hardware
  configuration.

8
Technical ApproachData distribution schema
(workflow)
9
Technical ApproachData security (2/2)
Row level security and Columns Masking are also
considered
Virtual Private Database Columns Masking
Policy Masking Restriction
Select X coord,Y coord from ..
Label Security Authorizations
User/Roles Authorizations Policy
10
Technical Approach Analysis archive

• Images archive

• Analysis outputs (vector data) archive

• Analysis outputs (raster/map data) archive

• Reference to Dartmouth data

11
UNSDI-TChronology

• The UN Geographic Information Working Group
  (UNGIWG) is leading the development of a UN
  Spatial Data Infrastructure (UNSDI)
• October 2005 UN Geographic Information Working
  Group (UNGIWG) asked UNJLC to pilot the
  development of standards for Transportation
  datasets as a first step in the creation of a UN
  Spatial Data Infrastructure.
• October 2006 onwards Operational use of UNSDI-T
  prototypes in UNJLC/Global Logistics Cluster
  deployments (Sudan, Pakistan, Uganda, Ethiopia)
• May 2007 cooperation with ITHACA as UNJLC/WFP
  implementing partner.
• August 2007 UNSDI-T Version 1.2 released
• April 2008 UNSDI-T Version 2.0 draft released
  (publication mid June 2008).
• April 2008 UNJLC past operational geo data
  integrated in UNSDI-T V2.0 alongside with global
  transportation layers. ORACLE DB basic web
  interface associated services under test
  about to be launched.

12
UNSDI-TUNJLC approach
1. Semantic/ Terminology - Data Model DB schema

• 2. Technical Implementation (logical framework,
  methodology, technology) Operational use
• Development of data collection and database
  structure relying on ESRI products (operational
  reasons) ITHACA as UNJLC (and WFP) implementing
  partner.
• DB prototypes and package implemented and tested
  in operations.
• Synergies from those two parallel processes
• 3. Institutional (adoption)

13
UNSDI-TThe process
UNSDI-T
Web-based Tools
GPS-based Tools
Analysis
Reports
Maps
14
UNSDI-TApproach to terminology

• Collection of existing road assessment practices
  (LCA, UNJLC forms, common datasets)
• Rationalizing attribute and value domain
  definitions (disaggregating attribute fields)
• Compilation of 'Dictionary of Terms (online,
  interactive, reference source)
• Validation of UNSDI-T semantic achievements
  through a constant participatory process
  involving WFP and other Humanitarian Logistics
  expertise
• Achievements Glossary attached to UNSDIT V1.0
  recognised as a standard within WFP (and other
  Groups), Global Log Cluster, Logs from UN
  Agencies, NGOs, Private groups

15
UNSDI-TAdoption

• Logistics Cluster/UNJLC and partners in
  operations
• CILT (UK) aligning their work on humanitarian
  logistics standards with UNSDI-T
• WFP SDI
• UNOCHA Humanitarian SDI
• UNOSAT
• UNHCR WebGIS
• WHO - WebGIS
• ECA/TIMP
• FAO Somalia road mapping project
• CartONG (Uganda) road mapping project
• INTERSOS WebGIS
• OpenStreetMap
• CODATA Working Group Global Road development .
  Aim Global Roads Layer (1/200K and infra)
• Global Bio Development Assessment Model
  (Netherlands Environmental Assessment Agency).

16
UNSDI-TVersion 2.0

• The UNJLC GIS unit has drafted the version 2.0 of
  the UN Spatial Data Infrastructure for Transport
  database schema (UNSDIT v2.0) building on half a
  year of user feedbacks and UNJLC operational
  lessons learned.
• A database structure with sufficient scope to
  accommodate for the generation of a la carte
  UNSDIT-compliant spatial databases and assessment
  forms.
• The Light subset of the Comprehensive UNSDIT
  package designed to better match responses to
  sudden-onset emergencies version represents one
  such subset, but not the only possible selection
  of the attributes available in the
  Comprehensive version.
• This draft release encompasses both Light and
  Comprehensive UNSDIT packages, each with the
  following elements
• Version 2.0 UNSDIT schema (XML)
• Version 2.0 schema documentation (XML, MS Visio,
  HTML and MS Excel)
• Blank template databases in ESRI Personal
  Geodatabase (PGDB) and shapefile (SHP).
• A set of assessment forms for the Light UNSDIT
  package only.
• http//www.unjlc.org/mapcenter/unsdi/unsdit-v2/

17
DataSources

• And others
• Results of geographic analysis
• GAUL administrative levels (up to sublevel 5 in
  some countries)
• WFP facilities
• Refugee camps
• UNESCO World Heritage List

18
Publication EnvironmentInfrastructure for web
applications
GEOSERVER
19
Publication EnvironmentInfrastructure for web
services
WMS WFS WCS
GEOSERVER
20
WEB GIS ServicesPreliminary list

• Direct data access to a common repository,
  including grants and rules for data management

• On-line archive catalogue of past events
  consequences

• Development of map templates and representation
  rules

• Tools for early-warning (flood modelling,
  drought, etc.)

• Tools for direct estimation on affected areas
  extent and population numbers

• Tools for report generation