njerinjuguna-svg/kenya-climate-intelligence-platform

# Kenya Climate Intelligence Platform ### Full-Stack GIS + Satellite Data Pipeline System A production-deployed geospatial web application that extracts, processes, and visualizes 20 years of real satellite climate data across all 47 counties of Kenya connecting Google Earth Engine, a PostGIS spatial database, a REST API, and an interactive React dashboard into a single end-to-end system. 🌐 **Live:** kenya-climate-intelligence-platform-henna.vercel.app 🔗 **API:** kenya-climate-intelligence-platform.onrender.com --- **Overview This project is a practical attempt to turn environmental data into something usable. Across Kenya, climate-related challenges like drought, vegetation loss, and flooding are often discussed in reports but rarely translated into tools that allow exploration, comparison, and decision-making at a local level. This platform brings together satellite data, geospatial analysis, and a backend system to: track environmental indicators over time analyze patterns at the county level generate a simple, interpretable climate risk score expose the data through an API and interactive interface It’s not just a visualization it’s a working pipeline from raw data to usable insights. **What This Project Does At its core, the platform: extracts satellite data (NDVI, rainfall proxies) aggregates it spatially to Kenya’s 47 counties builds a time-series dataset (2000–2024) computes a simplified climate risk score serves the results through an API visualizes them in a web interface ## Technical Deep Dive ### Data Pipeline ``` Google Earth Engine MODIS MOD13A2 (NDVI, 1km, 16-day composites) CHIRPS Daily (rainfall, 5km resolution) | Spatial reduction using reduceRegions() Aggregated to county level (mean per polygon) Exported as CSV to Google Drive | Python pipeline (pandas, SQLAlchemy, psycopg2) Column mapping, health classification, county ID join Inserted into PostGIS tables | PostgreSQL with PostGIS extension Spatial tables: counties, vegetation_in …