Skip to main content
IGIbrahim Gamal

Case Study

UNCCD Land Restoration Observatory (Prototype)

Convention to Combat Desertification Web GIS Monitoring Sandbox

A semi-project prototype inspired by the United Nations Convention to Combat Desertification (UNCCD) delivery model. It focuses on Web GIS layers, application maintenance workflows, traffic/user monitoring, reporting automation, and backup/retention design for land-restoration data platforms.

3/11/2026Updated 3/11/20269 min read
React
Node.js
TypeScript
PostgreSQL
PostGIS
Leaflet
OpenStreetMap
SQL
Git
Power BI

Project Overview

The Challenge

UNCCD-facing technical teams typically need map-first information systems that combine geospatial layers, web/database maintenance, reporting workflows, and reliable backup policies. The challenge in this prototype was to design a realistic architecture and operations model for desertification-oriented data without depending on privileged infrastructure.

The Solution

I built a semi-project prototype called the UNCCD Land Restoration Observatory to simulate a practical UNCCD-style stack. The prototype combines React + Leaflet map interfaces, Node.js APIs, PostgreSQL/PostGIS geospatial storage, monitoring dashboards, reporting workflows, anomaly alerts, and backup/retention routines suitable for distributed stakeholders.

Impact

  • Produced a practical blueprint for Web GIS operations aligned with UNCCD-style program needs
  • Documented a maintenance and troubleshooting flow for development, testing, and production stages
  • Designed reporting-ready data structures for monthly traffic and quarterly analytical summaries
  • Defined backup/retention routines (daily incremental + weekly full) for analytics continuity
  • Connected geospatial outputs to dashboard workflows for KPI tracking and stakeholder visibility
  • Created a reusable prototype narrative for proposals, interviews, and technical scoping discussions

Key Metrics

6

Prototype Modules

GIS, maintenance, monitoring, reporting, backup, analytics

8+ entities

Data Model Scope

Users, layers, events, KPI, alerts, reports, backups, audit logs

Monthly / Quarterly

Reporting Cadence

Traffic and analytical summary workflow

Daily + Weekly

Backup Policy

Incremental plus full backup simulation

Technical Implementation

Architecture

The prototype uses a web-first architecture with React and Leaflet/OpenStreetMap on the frontend, a Node.js/Express API layer, and PostgreSQL/PostGIS for geospatial data modeling. The operational layer includes monitoring hooks for traffic and user behavior, scheduled report generation, anomaly detection triggers, and backup/retention pipelines. The design is intentionally maintainable and documentation-heavy to mirror consultant handoff expectations.

Technology Stack

Frontend

ReactTypeScriptLeafletOpenStreetMapDashboard UI

Backend

Node.jsExpress.jsRESTful APIsTask SchedulingAlert Triggers

Database

PostgreSQLPostGISSQLGeospatial Data ModelingRetention Tables

Infrastructure

GitHub ActionsDockerCI/CDBackup SchedulingEnvironment Segmentation

Tools

GitPostmanPower BIDocumentationIssue Tracking

Key Features

  • Map-based land-observatory interface for geospatial layer exploration
  • Standardized geospatial data structures for reporting and KPI alignment
  • Maintenance workflow for bug tracking, enhancement requests, and release notes
  • Traffic and user behavior monitoring with trend and anomaly outputs
  • Monthly reporting and quarterly analytical summary templates
  • Automated alert concept for unusual traffic drops/spikes
  • Daily incremental and weekly full backup workflow simulation
  • Audit-friendly logging to support transparency and operational handoff

Challenges and Solutions

Challenge

Designing a realistic UNCCD-style system without over-claiming real deployment scope

Solution

Explicitly framed the work as a prototype and focused on reusable architecture, implementation patterns, and operations playbooks instead of claiming production ownership.

Challenge

Balancing GIS complexity with maintainability for mixed technical audiences

Solution

Used a clear modular structure where geospatial processing, reporting logic, and maintenance operations are separated and documented for faster onboarding.

Challenge

Making monitoring and backup design practical, not theoretical

Solution

Added concrete cadence rules (monthly, quarterly, daily incremental, weekly full) and connected them to report generation and restoration-check workflows.

Related Projects

GreenRide Carpooling Platform (UNFCCC)

UNFCCC - Full-Stack Lead Developer. GIS-powered web application using OpenStreetMap, Leaflet, PostgreSQL/PostGIS, and Node.js to make delegate ride sharing simple and efficient.

OpenStreetMapLeafletopenrouteservice.org
View Project

Regional Command Center (RCC) Platform

Web/database platform for 26 hospitals with VoIP-backed dispatch, live WebSocket dashboards, open-source GEO ambulance tracking, STEMI/Stroke/Trauma portals, and 11-KPI monitoring/reporting analytics.

ReactReduxNestJS
View Project