Programming & Development / April 11, 2025

How to Represent Angola’s Provinces in Java and SQL Using ISO 3166-2 Codes

Angola provinces Java enum Angola ISO 3166-2 AO SQL Angola provinces Angola administrative divisions Spring Boot enum Angola region codes Angola address validation provinces of Angola AO ISO codes

🇦🇴 Java Enum: Angola’s 18 Provinces (ISO 3166-2:AO)

java

public enum AngolaProvince {
    BENGO("AO-BGO"),
    BENGUELA("AO-BGU"),
    BIE("AO-BIE"),
    CABINDA("AO-CAB"),
    CUANDO_CUBANGO("AO-CCU"),
    CUNENE("AO-CNN"),
    CUANZA_NORTE("AO-CNO"),
    CUANZA_SUL("AO-CUS"),
    HUAMBO("AO-HUA"),
    HUILA("AO-HUI"),
    LUANDA("AO-LUA"),
    LUNDA_NORTE("AO-LNO"),
    LUNDA_SUL("AO-LSU"),
    MALANJE("AO-MAL"),
    MOXICO("AO-MOX"),
    NAMIBE("AO-NAM"),
    UIGE("AO-UIG"),
    ZAIRE("AO-ZAI");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table + Insert Statements

sql

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

INSERT INTO angola_provinces (name, code) VALUES
('Bengo', 'AO-BGO'),
('Benguela', 'AO-BGU'),
('Bié', 'AO-BIE'),
('Cabinda', 'AO-CAB'),
('Cuando Cubango', 'AO-CCU'),
('Cunene', 'AO-CNN'),
('Cuanza Norte', 'AO-CNO'),
('Cuanza Sul', 'AO-CUS'),
('Huambo', 'AO-HUA'),
('Huíla', 'AO-HUI'),
('Luanda', 'AO-LUA'),
('Lunda Norte', 'AO-LNO'),
('Lunda Sul', 'AO-LSU'),
('Malanje', 'AO-MAL'),
('Moxico', 'AO-MOX'),
('Namibe', 'AO-NAM'),
('Uíge', 'AO-UIG'),
('Zaire', 'AO-ZAI');

✅ Summary

This setup includes all 18 provinces of Angola using official ISO 3166-2:AO codes. It's perfect for regional data structures, backend validation, address processing, and data analytics.


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