Programming & Development / April 11, 2025

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

Chad regions Java enum Chad ISO 3166-2 TD SQL Chad regions Chad administrative divisions Spring Boot enum Chad region list TD region codes provinces of Chad

🇹🇩 Java Enum: Chad’s Regions

Chad is divided into 23 regions. Below is the Java enum using the official ISO 3166-2:TD codes:

java

public enum ChadRegion {
    BATHA("TD-BA"),
    BAHR_EL_GHAZAL("TD-BG"),
    BORKOU("TD-BE"),
    CHARI_BAGUIRMI("TD-CB"),
    GUERA("TD-GR"),
    HADJER_LAMIS("TD-HL"),
    KANEM("TD-KA"),
    LAC("TD-LC"),
    LOGONE_OCCIDENTAL("TD-LO"),
    LOGONE_ORIENTAL("TD-LR"),
    MANDOUL("TD-MA"),
    MAYO_KEBBI_EAST("TD-ME"),
    MAYO_KEBBI_WEST("TD-MO"),
    MOUNDOU("TD-MD"),
    N'DJAMENA("TD-ND"),
    OUADDAI("TD-OD"),
    SALAMAT("TD-SA"),
    SILA("TD-SI"),
    TANDJILE("TD-TA"),
    TIBESTI("TD-TI"),
    WADI_FIRA("TD-WF"),
    ENNEDI_EAST("TD-EE"),
    ENNEDI_WEST("TD-EW");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO chad_regions (name, code) VALUES
('Batha', 'TD-BA'),
('Bahr el Ghazal', 'TD-BG'),
('Borkou', 'TD-BE'),
('Chari-Baguirmi', 'TD-CB'),
('Guéra', 'TD-GR'),
('Hadjer-Lamis', 'TD-HL'),
('Kanem', 'TD-KA'),
('Lac', 'TD-LC'),
('Logone Occidental', 'TD-LO'),
('Logone Oriental', 'TD-LR'),
('Mandoul', 'TD-MA'),
('Mayo-Kebbi Est', 'TD-ME'),
('Mayo-Kebbi Ouest', 'TD-MO'),
('Moundou', 'TD-MD'),
('N\'Djamena', 'TD-ND'),
('Ouaddaï', 'TD-OD'),
('Salamat', 'TD-SA'),
('Sila', 'TD-SI'),
('Tandjilé', 'TD-TA'),
('Tibesti', 'TD-TI'),
('Wadi Fira', 'TD-WF'),
('Ennedi-Est', 'TD-EE'),
('Ennedi-Ouest', 'TD-EW');

✅ Summary

This setup captures Chad’s 23 official regions using ISO 3166-2:TD codes—ideal for applications requiring standardized geographic region data.


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