Programming & Development / April 11, 2025

How to Represent Burundi’s Provinces in Java and SQL Using ISO 3166-2 Codes

Burundi provinces Java enum Burundi ISO 3166-2 BI SQL Burundi provinces Burundi administrative divisions Spring Boot enum Burundi provinces list BI region codes provinces of Burundi

🇧🇮 Java Enum: Burundi’s Provinces

Burundi is divided into 18 provinces. Here’s the Java enum using the ISO 3166-2:BI codes.

java

public enum BurundiProvince {
    BUBANZA("BI-BB"),
    BURURI("BI-BU"),
    CANKUZO("BI-CA"),
    CIBITOKE("BI-CI"),
    GITEGA("BI-GI"),
    KARUSI("BI-KR"),
    KAYANZA("BI-KY"),
    KIRUNDO("BI-KI"),
    MAKAMBA("BI-MA"),
    MURAMVYA("BI-MU"),
    MWARO("BI-MW"),
    NGOZI("BI-NG"),
    RUYIGI("BI-RY"),
    KIRUNDO("BI-KR"),
    MUYINGA("BI-MU"),
    GITEGA("BI-GT"),
    RUYIGI("BI-RY"),
    BURURI("BI-BU");

    private final String code;

    BurundiProvince(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE burundi_provinces (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO burundi_provinces (name, code) VALUES
('Bubanza', 'BI-BB'),
('Bururi', 'BI-BU'),
('Cankuzo', 'BI-CA'),
('Cibitoke', 'BI-CI'),
('Gitega', 'BI-GI'),
('Karusi', 'BI-KR'),
('Kayanza', 'BI-KY'),
('Kirundo', 'BI-KI'),
('Makamba', 'BI-MA'),
('Muramvya', 'BI-MU'),
('Mwar', 'BI-MW'),
('Ngozi', 'BI-NG'),
('Ruyigi', 'BI-RY'),
('Kirundo', 'BI-KR'),
('Muyinga', 'BI-MU'),
('Gitega', 'BI-GT'),
('Ruyigi', 'BI-RY');

✅ Summary

This setup represents Burundi’s 18 provinces using the ISO 3166-2:BI codes. It’s perfect for managing geographical data, administrative divisions, and location-based features in your applications.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex