Programming & Development / April 11, 2025

How to Represent Burkina Faso’s Regions in Java and SQL Using ISO 3166-2 Codes

Burkina Faso regions Java enum Burkina Faso ISO 3166-2 BF SQL Burkina Faso regions Burkina Faso administrative divisions Spring Boot enum Burkina Faso regions list BF region codes regions of Burkina Faso

🇧🇫 Java Enum: Burkina Faso’s Regions

Burkina Faso is divided into 13 regions. Here’s the Java enum using the ISO 3166-2:BF codes.

java

public enum BurkinaFasoRegion {
    CENTRE("BF-C"),
    CENTRE_EST("BF-CE"),
    CENTRE_NORD("BF-CN"),
    CENTRE_OUEST("BF-CO"),
    CENTRE_SUD("BF-CS"),
    EST("BF-E"),
    HAUTS_BASSINS("BF-HB"),
    JADE("BF-JD"),
    SUD_OUEST("BF-SO"),
    SAHEL("BF-SA"),
    SUD("BF-S"),
    TABAN("BF-TB"),
    YAGHIOU("BF-Y");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO burkina_faso_regions (name, code) VALUES
('Centre', 'BF-C'),
('Centre Est', 'BF-CE'),
('Centre Nord', 'BF-CN'),
('Centre Ouest', 'BF-CO'),
('Centre Sud', 'BF-CS'),
('Est', 'BF-E'),
('Hauts Bassins', 'BF-HB'),
('Jade', 'BF-JD'),
('Sud Ouest', 'BF-SO'),
('Sahel', 'BF-SA'),
('Sud', 'BF-S'),
('Taban', 'BF-TB'),
('Yaghio', 'BF-Y');

✅ Summary

This setup represents Burkina Faso’s 13 regions using the ISO 3166-2:BF codes. It’s useful for managing geographical data, administrative divisions, and location-based tasks 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