Programming & Development / April 11, 2025

How to Represent Bhutan’s Dzongkhags in Java and SQL Using ISO 3166-2 Codes

Bhutan dzongkhags Java enum Bhutan ISO 3166-2 BT SQL Bhutan dzongkhags Bhutan administrative divisions Spring Boot enum Bhutan regions list BT region codes dzongkhags of Bhutan

🇧🇹 Java Enum: Bhutan’s Dzongkhags

Bhutan is divided into 20 dzongkhags (districts). Here’s the Java enum using the ISO 3166-2:BT codes.

java

public enum BhutanDzongkhag {
    CHUKHA("BT-11"),
    GASA("BT-12"),
    HAA("BT-13"),
    LHUENTSE("BT-14"),
    MONGAR("BT-15"),
    PARO("BT-16"),
    PEMAGATSHEL("BT-17"),
    SAMDRUP_JONGKHAR("BT-18"),
    SAMTSE("BT-19"),
    SARPANG("BT-20"),
    THIMPHU("BT-21"),
    TRONGSA("BT-22"),
    WANGDUEPHODRANG("BT-23"),
    ZHEMGANG("BT-24"),
    BUMTHANG("BT-25"),
    DAGANA("BT-26"),
    PUNAKHA("BT-27"),
    TSIRANG("BT-28"),
    RENEGA ("BT-29"),
    DORJEE ("BT-30");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO bhutan_dzongkhags (name, code) VALUES
('Chukha', 'BT-11'),
('Gasa', 'BT-12'),
('Haa', 'BT-13'),
('Lhuentse', 'BT-14'),
('Mongar', 'BT-15'),
('Paro', 'BT-16'),
('Pemagatshel', 'BT-17'),
('Samdrup Jongkhar', 'BT-18'),
('Samtse', 'BT-19'),
('Sarpang', 'BT-20'),
('Thimphu', 'BT-21'),
('Trongsa', 'BT-22'),
('Wangduephodrang', 'BT-23'),
('Zhemgang', 'BT-24'),
('Bumthang', 'BT-25'),
('Dagana', 'BT-26'),
('Punakha', 'BT-27'),
('Tsirang', 'BT-28'),
('Renega', 'BT-29'),
('Dorjee', 'BT-30');

✅ Summary

This setup represents Bhutan’s 20 dzongkhags using the ISO 3166-2:BT codes. It’s ideal for managing administrative divisions, geographical data, or region-based functionalities 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