ALZ-11/urbanization-africa

Dynamic geospatial dashboard analyzing African urbanization and trade infrastructure by fusing live Wikidata SPARQL queries and World Bank API indicators. # Urbanization in Africa - Dynamic Geospatial Analysis ## Description This platform provides a dynamic data pipeline and interactive analytics dashboard exploring urbanization, demographic trends, and transport logistics across the African continent. The project demonstrates dynamic data fusion and geospatial visualization by pulling live relational data from the Wikidata triple-store (via SPARQL) and merging it with macroeconomic indicators from the World Bank API. ## Live Dashboard * **Interactive Web App:** urbanization-africa.streaml… ## Advanced Features * **Live SPARQL ETL Engine**: Python-driven query orchestration communicating directly with the Wikidata API with customized compliant User-Agent headers and local configuration loading. * **Decoupled SPARQL Files**: Multi-dimensional semantic queries decoupled into standalone `.sparql` files inside a queries registry module. * **Interactive GIS Mapping**: Mapbox OpenStreetMap scatter maps displaying city density, maritime ports, and aviation hubs color-coded by infrastructure type. * **Multi-Source Data Fusion**: Integration with the World Bank API to overlay city-level demographic data on top of national urbanization trajectories (`SP.URB.TOTL.IN.ZS`). * **Performance Telemetry**: Real-time pipeline latency tracking in the sidebar showing database access speeds and verifying local cache efficiency. * **Data Export**: CSV compilation allowing users to download any of the live-generated datasets with a single click. ## Project Structure * `src/`: Core Python modules managing extraction, configurations, and transformations. * `src/queries/`: Decoupled standalone `.sparql` query files. * `src/queries.py`: Helper module loading queries dynamically. * `src/extract.py`: Direct network clients handling Wikidata and World Bank API requests. * `src/transform.py`: Standardized dataset cleaning, datatype conversions, and parsing routines. * `src/constants.py`: Dedicated config …