Programming & Development / April 11, 2025

How to Represent Maldives' Administrative Atolls in Java and SQL Using ISO 3166-2 Codes

Maldives atolls Java enum Maldives ISO 3166-2 MV SQL Maldives atolls MV code list Maldives administrative divisions backend region enum Spring Boot regions Maldives Maldives Java SQL

🇲🇻 Java Enum: Maldives’ Administrative Atolls

Maldives is divided into 21 administrative divisions (atolls), each with an ISO 3166-2:MV code. Here's the Java enum representation:

java

public enum MaldivesAtoll {
    AA("MV-02"),  // Alif Alif
    AD("MV-00"),  // Addu City
    AE("MV-27"),  // Addu Atoll (deprecated, same as AD)
    BA("MV-20"),  // Baa
    DH("MV-17"),  // Dhaalu
    FA("MV-14"),  // Faafu
    GA("MV-03"),  // Gaafu Alif
    GD("MV-29"),  // Gaafu Dhaalu
    HA("MV-23"),  // Haa Alif
    HD("MV-24"),  // Haa Dhaalu
    KL("MV-05"),  // Kaafu (includes Male’)
    LA("MV-26"),  // Laamu
    LD("MV-28"),  // Lhaviyani
    MA("MV-MLE"), // Malé (capital)
    ME("MV-12"),  // Meemu
    ML("MV-13"),  // Miladhunmadulu
    MU("MV-25"),  // Mulaku
    NA("MV-01"),  // Noonu
    RAA("MV-08"), // Raa
    SH("MV-21"),  // Shaviyani
    TH("MV-18"),  // Thaa
    VA("MV-04");  // Vaavu

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO maldives_atolls (name, code) VALUES
('Alif Alif', 'MV-02'),
('Addu City', 'MV-00'),
('Baa', 'MV-20'),
('Dhaalu', 'MV-17'),
('Faafu', 'MV-14'),
('Gaafu Alif', 'MV-03'),
('Gaafu Dhaalu', 'MV-29'),
('Haa Alif', 'MV-23'),
('Haa Dhaalu', 'MV-24'),
('Kaafu', 'MV-05'),
('Laamu', 'MV-26'),
('Lhaviyani', 'MV-28'),
('Malé', 'MV-MLE'),
('Meemu', 'MV-12'),
('Miladhunmadulu', 'MV-13'),
('Mulaku', 'MV-25'),
('Noonu', 'MV-01'),
('Raa', 'MV-08'),
('Shaviyani', 'MV-21'),
('Thaa', 'MV-18'),
('Vaavu', 'MV-04');

✅ Summary

This setup includes all 21 administrative atolls of Maldives using ISO 3166-2:MV codes. It's ideal for backend applications, regional mapping, and location-based services.



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