Programming & Development / April 11, 2025

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

Georgia regions Java enum Georgia ISO 3166-2 GE SQL Georgia regions GE region codes Georgia administrative divisions backend region enum Georgia provinces Java SQL Spring Boot regions Georgia

🇬🇪 Java Enum: Georgia’s Regions

Georgia is divided into 9 regions. Here’s the Java enum using ISO 3166-2:GE codes:

java

public enum GeorgiaRegion {
    ABKHAZIA("GE-AB"),
    AJARIA("GE-AJ"),
    GURIA("GE-GU"),
    IMERETI("GE-IM"),
    KAKHETI("GE-KA"),
    KHEVSURETI("GE-KV"),
    MTSKHETA_MTIANETI("GE-MM"),
    RACHHA_LECHKHUMI_KVEMO_SVANETI("GE-RL"),
    SAMTSKHE_JAVAKHETI("GE-SJ");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO georgia_regions (name, code) VALUES
('Abkhazia', 'GE-AB'),
('Ajaria', 'GE-AJ'),
('Guria', 'GE-GU'),
('Imereti', 'GE-IM'),
('Kakheti', 'GE-KA'),
('Khevsureti', 'GE-KV'),
('Mtskheta-Mtianeti', 'GE-MM'),
('Racha-Lechkhumi-Kvemo Svaneti', 'GE-RL'),
('Samtskhe-Javakheti', 'GE-SJ');

✅ Summary

This setup covers all 9 regions of Georgia using ISO 3166-2:GE codes, ideal for backend services, Java applications, and SQL databases.


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