Logo Lanfrica
  • Accueil
  • Atlas
  • Analyses
  • Documentation
  • Sign in

© 2026 Lanfrica. Tous droits réservés. Tous les droits d'auteur des ressources affichées sur le site Web Lanfrica appartiennent aux détenteurs de droits d'auteur d'origine, sauf indication contraire explicite.

Democratizing Climate Analytics: A Local-First Approach using DuckDB, H3, and WASM

Domaine:

climategeospatial

Type de record:

softwaredataset
Créateur:
Din
Éditeur:
Zenodo
Hôte:avatar

Climate and Earth Observation datasets are growing rapidly, yet the infrastructure commonly used to process them can introduce significant overhead and slow analytical iteration. This abstract presents a local-first spatial analytics workflow; validated through operational deployments in Turkey, Madagascar, and the UK; built around DuckDB, an embedded analytical database engine, together with its Spatial and H3 hexagonal indexing extensions. The approach enables reproducible spatial SQL over efficient columnar file formats (Apache Parquet), supporting fast spatiotemporal aggregation, multi-resolution summaries, and boundary integration without heavyweight GIS server infrastructure. Results can be published as a portable database served via lightweight APIs, or explored entirely in-browser using WebAssembly. This work contributes to UN SDG 13 (Climate Action) and SDG 2 (Zero Hunger) by enabling accessible, low-cost climate monitoring for drought early warning and food security.

Visit

doi.org

Tags

Climate & EO data pipelines, Global Grid Systems & H3, DuckDB Spatial, WebAssembly, Serverless, Drought Monitoring

Licenses

info:eu-repo/semantics/openAccessCreative Commons Attribution 4.0 Internationalhttps://creativecommons.org/licenses/by/4.0/legalcode

Similaires

a-wahid123/newmont-local-content-analyticsOsman-Geomatics93/duckdb-sudan-Rethinking and reimagining corporate social responsibility as legislation in South Africa using a qualitative document analytics approachA Mathematical Approach to Healthcare Insurance Data AnalyticsThe African Neuroimaging Archive (AfNiA): An Approach for Democratizing AI in Medical ImagingA Paradigm for Democratizing Artificial Intelligence Research

a-wahid123/newmont-local-content-analytics

End-to-end analytics system for mining local content compliance and community impact measurement - G

Osman-Geomatics93/duckdb-sudan-

# DuckDB Sudan Extension **Unified SQL access to Sudan's humanitarian, development, and geos

Rethinking and reimagining corporate social responsibility as legislation in South Africa using a qualitative document analytics approach

South African legislation does not obligate companies to fulfill their corporate social responsibili

A Mathematical Approach to Healthcare Insurance Data Analytics

The emergence of big data analytics as a way of deriving insights from data has brought excitement t

The African Neuroimaging Archive (AfNiA): An Approach for Democratizing AI in Medical Imaging

Artificial intelligence (AI) can advance equitable access to high value care and improve health outcomes across all settings. Since the burden of non-communicable diseases is rising sharply in Sub-Saharan Africa (SSA) while decreasing in the Global North, the poten

A Paradigm for Democratizing Artificial Intelligence Research

International audience This proposal outlines a plan for bridging the gap between tec