Programming & Development / April 11, 2025

Modeling Mauritania's Regions in Java and SQL Using ISO 3166-2:MR Codes

Mauritania regions Java enum Mauritania ISO 3166-2 MR SQL Mauritania Spring Boot regional enum Mauritania database setup backend geography African countries data Mauritania provinces enum

🇲🇷 Java Enum: Mauritania Regions

Mauritania has 15 administrative regions (called wilayas), each with an official ISO 3166-2:MR code.

java

public enum MauritaniaRegion {
    ADRAR("MR-07"),
    ASSABA("MR-03"),
    BRAKNA("MR-05"),
    DAKHLET_NOUADHIBOU("MR-08"),
    GORGOL("MR-04"),
    GUIDIMAKA("MR-10"),
    HODH_ECH_CHARGHI("MR-01"),
    HODH_EL_GHARBI("MR-02"),
    INCHIRI("MR-12"),
    NOUAKCHOTT_NORD("MR-14"),
    NOUAKCHOTT_OUEST("MR-15"),
    NOUAKCHOTT_SUD("MR-13"),
    TAGANT("MR-09"),
    TIRIS_ZEMMOUR("MR-11"),
    TRARZA("MR-06");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO mauritania_regions (name, code) VALUES
('Adrar', 'MR-07'),
('Assaba', 'MR-03'),
('Brakna', 'MR-05'),
('Dakhlet Nouadhibou', 'MR-08'),
('Gorgol', 'MR-04'),
('Guidimaka', 'MR-10'),
('Hodh Ech Chargui', 'MR-01'),
('Hodh El Gharbi', 'MR-02'),
('Inchiri', 'MR-12'),
('Nouakchott Nord', 'MR-14'),
('Nouakchott Ouest', 'MR-15'),
('Nouakchott Sud', 'MR-13'),
('Tagant', 'MR-09'),
('Tiris Zemmour', 'MR-11'),
('Trarza', 'MR-06');

✅ Summary

This setup allows you to represent Mauritania's 15 regions in Java applications and relational databases using ISO standard codes. It's ideal for geographic applications, data pipelines, and backend APIs.



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