Embiro BI

Documentation › Charts

Maps and ISO codes

Draw maps of Uganda's districts, other countries' regions and the world in Embiro BI, with the ISO codes each map needs and where to look them up.

Embiro BI has three kinds of map. The first two colour areas, which needs a column holding each area's ISO code. This page explains which code each map expects, lists every Uganda district's code, and points to the official sources for other countries.

Map Shows Your data needs
Country Map One country's regions or districts, coloured by a metric An ISO 3166-2 code per row, such as UG-102
World Map Countries of the world, coloured or with bubbles A country code (ISO 3166-1) or the country's name
Point Cluster Map and the deck.gl maps Points at exact locations Latitude and longitude columns

ISO codes in a nutshell

ISO 3166-1
The international standard for country codes. Uganda is UG (alpha-2), UGA (alpha-3) and 800 (numeric). Kenya is KE / KEN, Tanzania TZ / TZA, Rwanda RW / RWA.
ISO 3166-2
Codes for each country's subdivisions (regions, provinces, districts). They start with the country's alpha-2 code: UG-102 is Kampala, KE-30 is Nairobi, TZ-02 is Dar es Salaam.

Official and reliable sources to look codes up:

Country Map: Uganda by district

  1. Add the codes to your data. Usually your table has a district name, so join it to the code list below. The quickest way:
    • download uganda-district-iso-codes.csv and upload it as a table, say uganda_districts, or paste it into a Google Sheet;
    • join it in a virtual dataset (see the SQL below), or add the code as a column in your own system.
  2. Create a chart on that dataset and choose Country Map.
  3. Set:
    • Country: uganda;
    • ISO 3166-2 Codes: your code column, such as district_iso;
    • Metric: what colours each district, such as SUM(revenue_ugx);
    • Linear Color Scheme and Number format to taste.
  4. Click Update chart. Hover over a district to see its name and value.

A Country Map of Uganda with districts coloured by revenue, set up with Country Uganda, ISO 3166-2 Codes District ISO code and Metric Revenue

A virtual dataset joining sales to codes by district name (PostgreSQL):

SELECT s.*, d.district_iso, d.region
FROM sales s
LEFT JOIN uganda_districts d
  ON lower(trim(s.district)) = lower(d.district)

Spellings in the list follow the map, which sometimes differs from today's official spelling: Kibaale is listed as Kibale (UG-407). Rows whose district doesn't match a name in the list get no code and don't appear on the map. Check them with:

SELECT DISTINCT s.district
FROM sales s
LEFT JOIN uganda_districts d ON lower(trim(s.district)) = lower(d.district)
WHERE d.district_iso IS NULL;

Uganda's newer districts

The Uganda map in Embiro BI has the 111 districts of the 2010 boundaries, the ones that have ISO codes. Districts created later, such as Kagadi (from Kibaale), Omoro (from Gulu) or Rubanda (from Kabale), have no ISO code of their own. Map their rows to the district they were created from, in a small lookup table or a CASE expression, so their numbers still appear on the map:

sql CASE lower(district) WHEN 'kagadi' THEN 'UG-407' -- Kibaale WHEN 'kakumiro' THEN 'UG-407' -- Kibaale WHEN 'omoro' THEN 'UG-304' -- Gulu WHEN 'rubanda' THEN 'UG-404' -- Kabale ELSE district_iso END

Cities such as Mbarara City or Gulu City are within their district's area on the map: use the district's code.

Other countries

Country also offers Kenya, Tanzania, Rwanda, Burundi, the Democratic Republic of the Congo, Ethiopia, Somalia, Zambia, Malawi, Nigeria, Ghana, South Africa and about 190 other countries. Each expects that country's ISO 3166-2 codes: Kenya's 47 counties are KE-01 (Baringo) to KE-47 (West Pokot), Tanzania's regions TZ-01 to TZ-30. Look them up on the ISO Online Browsing Platform or Wikipedia's ISO 3166-2:KE and ISO 3166-2:TZ pages.

World Map

  1. Choose World Map.
  2. Set Country Column to the column holding the country, and Country Field Type to what that column contains:
    • Full name, such as Uganda (English names, spelled as in the ISO list);
    • code ISO 3166-1 alpha-2 (cca2), such as UG (the most reliable choice);
    • code ISO 3166-1 alpha-3 (cca3), such as UGA;
    • code International Olympic Committee (cioc), such as UGA.
  3. Choose a Metric to colour countries. Optionally switch on Show Bubbles and choose a Bubble Size metric.

Names are easy to get wrong (Tanzania versus United Republic of Tanzania, DR Congo versus Democratic Republic of the Congo), so prefer two-letter codes.

Maps of points

To plot customers, branches or sales at their exact location, your dataset needs latitude and longitude columns in decimal degrees, such as 0.3476 and 32.5825 for Kampala. Use Point Cluster Map for many points grouped into clusters, or deck.gl Scatterplot and deck.gl Heatmap for density.

Getting coordinates: Google Maps shows them when you right-click a place, and most mobile data-collection tools (KoboToolbox, ODK, Jotform's location field) record them with each submission.

Uganda district ISO codes

The full list, matching the Uganda map. Region digits: 1 Central, 2 Eastern, 3 Northern, 4 Western. Download it as CSV.

Show all 111 districts
ISO code District Region
UG-101 Kalangala Central
UG-102 Kampala Central
UG-103 Kiboga Central
UG-104 Luweero Central
UG-105 Masaka Central
UG-106 Mpigi Central
UG-107 Mubende Central
UG-108 Mukono Central
UG-109 Nakasongola Central
UG-110 Rakai Central
UG-111 Sembabule Central
UG-112 Kayunga Central
UG-113 Wakiso Central
UG-114 Mityana Central
UG-115 Nakaseke Central
UG-116 Lyantonde Central
UG-117 Buikwe Central
UG-118 Bukomansimbi Central
UG-119 Butambala Central
UG-120 Buvuma Central
UG-121 Gomba Central
UG-122 Kalungu Central
UG-123 Kyankwanzi Central
UG-124 Lwengo Central
UG-201 Bugiri Eastern
UG-202 Busia Eastern
UG-203 Iganga Eastern
UG-204 Jinja Eastern
UG-205 Kamuli Eastern
UG-206 Kapchorwa Eastern
UG-207 Katakwi Eastern
UG-208 Kumi Eastern
UG-209 Mbale Eastern
UG-210 Pallisa Eastern
UG-211 Soroti Eastern
UG-212 Tororo Eastern
UG-213 Kaberamaido Eastern
UG-214 Mayuge Eastern
UG-215 Sironko Eastern
UG-216 Amuria Eastern
UG-217 Budaka Eastern
UG-218 Bukwa Eastern
UG-219 Butaleja Eastern
UG-220 Kaliro Eastern
UG-221 Manafwa Eastern
UG-222 Namutumba Eastern
UG-223 Bududa Eastern
UG-224 Bukedea Eastern
UG-225 Bulambuli Eastern
UG-226 Buyende Eastern
UG-227 Kibuku Eastern
UG-228 Kween Eastern
UG-229 Luuka Eastern
UG-230 Namayingo Eastern
UG-231 Ngora Eastern
UG-232 Serere Eastern
UG-301 Adjumani Northern
UG-302 Apac Northern
UG-303 Arua Northern
UG-304 Gulu Northern
UG-305 Kitgum Northern
UG-306 Kotido Northern
UG-307 Lira Northern
UG-308 Moroto Northern
UG-309 Moyo Northern
UG-310 Nebbi Northern
UG-311 Nakapiripirit Northern
UG-312 Pader Northern
UG-313 Yumbe Northern
UG-314 Amolatar Northern
UG-315 Kaabong Northern
UG-316 Koboko Northern
UG-317 Abim Northern
UG-318 Dokolo Northern
UG-319 Amuru Northern
UG-320 Maracha Northern
UG-321 Oyam Northern
UG-322 Agago Northern
UG-323 Alebtong Northern
UG-324 Amudat Northern
UG-325 Buhweju Northern
UG-326 Kole Northern
UG-327 Lamwo Northern
UG-328 Napak Northern
UG-329 Nwoya Northern
UG-330 Otuke Northern
UG-331 Zombo Northern
UG-401 Bundibugyo Western
UG-402 Bushenyi Western
UG-403 Hoima Western
UG-404 Kabale Western
UG-405 Kabarole Western
UG-406 Kasese Western
UG-407 Kibale Western
UG-408 Kisoro Western
UG-409 Masindi Western
UG-410 Mbarara Western
UG-411 Ntungamo Western
UG-412 Rukungiri Western
UG-413 Kamwenge Western
UG-414 Kanungu Western
UG-415 Kyenjojo Western
UG-416 Ibanda Western
UG-417 Isingiro Western
UG-419 Buliisa Western
UG-420 Kiryandongo Western
UG-421 Kyegegwa Western
UG-422 Mitooma Western
UG-423 Ntoroko Western
UG-424 Rubirizi Western
UG-425 Sheema Western

Something unclear or missing? Tell us and we'll improve this page.