Unified SQL access to Sudan's humanitarian, development, and geospatial data from 5 international APIs. وصول موحد عبر SQL لبيانات السودان الإنسانية والتنموية والجغرافية من 5 واجهات برمجة دولية.
-- Enable HTTPS downloads
INSTALL httpfs; LOAD httpfs;
-- Set the custom extension repository
SET custom_extension_repository = 'https://osman-geomatics93.github.io/duckdb-sudan-';
-- Install and load
INSTALL sudan;
LOAD sudan;
git clone --recurse-submodules https://github.com/Osman-Geomatics93/duckdb-sudan-.git
cd duckdb-sudan-
build_release.bat
build\release\duckdb.exe -unsigned
INSTALL sudan FROM community;
LOAD sudan;
Live connections to 5 international APIs. Green dot = API reachable. اتصالات مباشرة بـ 5 واجهات برمجة دولية. النقطة الخضراء = API متاح.
Development indicators, GDP, population, education
SUDAN_WorldBank('SP.POP.TOTL')
Health indicators, disease burden, mortality rates
SUDAN_WHO('MDG_0000000026')
Agricultural production, food security, land use
SUDAN_FAO('QCL', 'production')
Refugees, IDPs, asylum seekers, displacement data
SUDAN_UNHCR('refugees')
Employment, labor force, unemployment statistics
SUDAN_ILO('UNE_DEAP_SEX_AGE_RT')
Real data from Sudan's APIs, accessible through simple SQL queries. بيانات حقيقية من واجهات برمجة السودان.
Real polygon boundaries from GADM v4.1 embedded as MultiPolygon GeoJSON. Click a state for details. حدود مضلعات حقيقية من GADM v4.1 مدمجة كـ MultiPolygon GeoJSON. انقر على ولاية للتفاصيل.
Try example queries. Install the extension locally to run your own. جرب استعلامات المثال. ثبت الإضافة محلياً لتشغيل استعلاماتك.
| Function | Type | Description |
|---|---|---|
SUDAN_Providers() | table | List all 5 data providers with Arabic names and URLs |
SUDAN_WB_Indicators(search) | table | Search World Bank indicators by keyword |
SUDAN_WHO_Indicators(search) | table | Search WHO GHO indicators by keyword |
SUDAN_Search(query) | table | Cross-provider indicator search |
| Function | Signature | Source |
|---|---|---|
SUDAN_WorldBank | (indicator, countries := ['SDN']) | World Bank V2 API |
SUDAN_WHO | (indicator, countries := ['SDN']) | WHO GHO OData API |
SUDAN_FAO | (dataset, element, countries := ['SDN']) | FAOSTAT API |
SUDAN_UNHCR | (population_type, countries := ['SDN']) | UNHCR Population API |
SUDAN_ILO | (indicator, countries := ['SDN']) | ILO SDMX API |
| Function | Type | Description |
|---|---|---|
SUDAN_Boundaries(level) | table | Admin boundaries as MultiPolygon GeoJSON from GADM v4.1 ('country', 'state', 'locality') |
SUDAN_States() | table | 18 states with bilingual names, ISO codes, centroids, and polygon boundaries |
SUDAN_GeoCode(name) | scalar | State name (Arabic or English) → ISO code |
All functions default to Sudan. Use the countries parameter for regional comparison.
جميع الدوال تعمل افتراضياً للسودان. استخدم معامل countries للمقارنة الإقليمية.
SUDAN_Boundaries('state') now returns actual state polygons (780–53,852 chars each)SUDAN_Boundaries('country') returns full country outline (103K chars)SUDAN_States() geojson column now contains polygon boundariesgit clone --recurse-submodules https://github.com/Osman-Geomatics93/duckdb-sudan-.git
cd duckdb-sudan-
build_release.bat
build\release\duckdb.exe -unsigned
git clone --recurse-submodules https://github.com/Osman-Geomatics93/duckdb-sudan-.git
cd duckdb-sudan-
GEN=ninja make release
./build/release/duckdb -unsigned
Learn SQL and explore Sudan's data interactively in Google Colab. No installation needed — click and start querying. تعلّم SQL واستكشف بيانات السودان تفاعلياً في Google Colab. بدون تثبيت — انقر وابدأ الاستعلام.
A hands-on SQL tutorial using real Sudan data. Covers SELECT, WHERE, JOIN, GROUP BY, HAVING, CASE, and geospatial queries — all powered by live API data from the extension. دليل عملي لتعلم SQL باستخدام بيانات السودان الحقيقية. يغطي SELECT، WHERE، JOIN، GROUP BY، HAVING، CASE، والاستعلامات الجغرافية.
13 interactive visualizations: choropleth maps, animated population race, refugee Sankey flows, regional sunburst, health dashboard, agriculture treemap, dark-themed Folium map with popups, radar charts, GDP gauges, and an executive dashboard. 13 رسماً تفاعلياً: خرائط حرارية، سباق سكاني متحرك، مخطط سانكي للاجئين، شمسي إقليمي، لوحة صحية، خريطة شجرية للزراعة، خريطة Folium داكنة، مخطط راداري، ولوحة تنفيذية.