Programming & Development / April 11, 2025

Modeling Mongolia's Provinces in Java and SQL Using ISO 3166-2:MN Codes

Mongolia provinces Java enum Mongolia ISO 3166-2 MN SQL Mongolia Mongolia regions Mongolian administrative units Spring Boot geography Mongolia districts backend Mongolia Mongolian provinces code

🇲🇳 Java Enum: Mongolia Provinces

Mongolia has 21 provinces (aimags) and 1 capital city (Ulaanbaatar), each with its official ISO 3166-2:MN code.

java

public enum MongoliaProvince {
    ARKHANGAI("MN-035"),
    BAYAN_OLGIY("MN-071"),
    BOGDAN("MN-057"),
    BULGAN("MN-061"),
    DARHAN("MN-041"),
    DORNOD("MN-025"),
    DORNGOVI("MN-053"),
    GOBI_ALTAI("MN-023"),
    GOBI_SUMU("MN-073"),
    KHOVD("MN-063"),
    KHOVD_AYMAG("MN-021"),
    OVOO("MN-081"),
    SUKHBAATAR("MN-029"),
    UMNUGOVI("MN-075"),
    UULANBAATAR("MN-014"),
    BAYANKHONGOR("MN-025");
    
    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO mongolia_provinces (name, code) VALUES
('Arkhangai', 'MN-035'),
('Bayan-Ölgii', 'MN-071'),
('Bogdan', 'MN-057'),
('Bulgan', 'MN-061'),
('Darhan', 'MN-041'),
('Dornod', 'MN-025'),
('Dornogovi', 'MN-053'),
('Gobi-Altai', 'MN-023'),
('Gobi-Sumu', 'MN-073'),
('Hovd', 'MN-063'),
('Hovd Aymag', 'MN-021'),
('Ovoo', 'MN-081'),
('Sukhbaatar', 'MN-029'),
('Umnugovi', 'MN-075'),
('Ulaanbaatar', 'MN-014'),
('Bayankhongor', 'MN-025');

✅ Summary

This setup models Mongolia's provinces and capital city with their ISO 3166-2:MN codes, representing all the important administrative regions. This can be used effectively for database management or backend applications that need to handle geographic 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