Programming & Development / April 11, 2025

How to Represent Egypt’s Governorates in Java and SQL Using ISO 3166-2 Codes

Egypt governorates Java enum Egypt ISO 3166-2 EG SQL Egypt governorates EG governorate codes Egypt administrative divisions Spring Boot enum Egypt region list backend region enum Egypt

🇪🇬 Java Enum: Egypt’s Governorates

Egypt is divided into 27 governorates. Here’s the Java enum with official ISO 3166-2:EG codes:

java

public enum EgyptGovernorate {
    ALEXANDRIA("EG-ALX"),
    ASWAN("EG-ASN"),
    ASYUT("EG-AST"),
    BEHEIRA("EG-BH"),
    BENI_SUEF("EG-BNS"),
    CAIRO("EG-C"),
    DAKAHLIYA("EG-DK"),
    DAMIETTA("EG-DT"),
    FAIYUM("EG-FYM"),
    GHARBIA("EG-GH"),
    GIZA("EG-GZ"),
    ISMAILIA("EG-IS"),
    KAFR_EL_SHEIKH("EG-KFS"),
    LUXOR("EG-LX"),
    MATRUH("EG-MT"),
    MINYA("EG-MN"),
    MONUFIA("EG-MNF"),
    NEW_VALLEY("EG-WAD"),
    NORTH_SINAI("EG-SIN"),
    PORT_SAID("EG-PTS"),
    QALYUBIA("EG-KB"),
    QENA("EG-KN"),
    RED_SEA("EG-BA"),
    SHARQIYA("EG-SHR"),
    SOHAG("EG-SHG"),
    SOUTH_SINAI("EG-JS"),
    SUEZ("EG-SUZ");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO egypt_governorates (name, code) VALUES
('Alexandria', 'EG-ALX'),
('Aswan', 'EG-ASN'),
('Asyut', 'EG-AST'),
('Beheira', 'EG-BH'),
('Beni Suef', 'EG-BNS'),
('Cairo', 'EG-C'),
('Dakahlia', 'EG-DK'),
('Damietta', 'EG-DT'),
('Faiyum', 'EG-FYM'),
('Gharbia', 'EG-GH'),
('Giza', 'EG-GZ'),
('Ismailia', 'EG-IS'),
('Kafr El Sheikh', 'EG-KFS'),
('Luxor', 'EG-LX'),
('Matruh', 'EG-MT'),
('Minya', 'EG-MN'),
('Monufia', 'EG-MNF'),
('New Valley', 'EG-WAD'),
('North Sinai', 'EG-SIN'),
('Port Said', 'EG-PTS'),
('Qalyubia', 'EG-KB'),
('Qena', 'EG-KN'),
('Red Sea', 'EG-BA'),
('Sharqia', 'EG-SHR'),
('Sohag', 'EG-SHG'),
('South Sinai', 'EG-JS'),
('Suez', 'EG-SUZ');

✅ Summary

This setup enables seamless integration of all 27 Egyptian governorates using ISO 3166-2:EG codes, ideal for building backend services, dropdowns, and database seeding.


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