Programming & Development / April 11, 2025

Modeling Nigeria's States in Java and SQL Using ISO 3166-2:NG Codes

Nigeria states Nigeria regions Java enum Nigeria ISO 3166-2 NG SQL Nigeria Nigeria subdivisions Spring Boot geographic enum Nigeria administrative units backend regions Nigeria states of Nigeria

🇳🇬 Java Enum: Nigeria's States

Nigeria is divided into 36 states and 1 Federal Capital Territory, each with its official ISO 3166-2:NG code.

java

public enum NigeriaState {
    ABIA("NG-AB"),
    ADAMAWA("NG-AD"),
    AKWA_IBOM("NG-AK"),
    ANAMBRA("NG-AN"),
    BAUCHI("NG-BA"),
    BAYELSA("NG-BY"),
    BENUE("NG-BE"),
    BORNO("NG-BO"),
    CROSS_RIVER("NG-CR"),
    DELTA("NG-DE"),
    EBONYI("NG-EB"),
    EDO("NG-ED"),
    EKITI("NG-EK"),
    ENUGU("NG-EN"),
    GOMBE("NG-GO"),
    IMO("NG-IM"),
    JIGAWA("NG-JI"),
    KADUNA("NG-KD"),
    KANO("NG-KN"),
    KATSINA("NG-KT"),
    KEBBI("NG-KE"),
    KOGI("NG-KO"),
    KWARA("NG-KW"),
    LAGOS("NG-LA"),
    NASARAWA("NG-NA"),
    NIGER("NG-NI"),
    OGUN("NG-OG"),
    ONDO("NG-ON"),
    OSUN("NG-OS"),
    OYO("NG-OY"),
    PLATEAU("NG-PL"),
    RIVERS("NG-RI"),
    SOKOTO("NG-SO"),
    TARABA("NG-TA"),
    YOBE("NG-YO"),
    ZAMFARA("NG-ZA"),
    FCT("NG-FC");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO nigeria_states (name, code) VALUES
('Abia', 'NG-AB'),
('Adamawa', 'NG-AD'),
('Akwa Ibom', 'NG-AK'),
('Anambra', 'NG-AN'),
('Bauchi', 'NG-BA'),
('Bayelsa', 'NG-BY'),
('Benue', 'NG-BE'),
('Borno', 'NG-BO'),
('Cross River', 'NG-CR'),
('Delta', 'NG-DE'),
('Ebonyi', 'NG-EB'),
('Edo', 'NG-ED'),
('Ekiti', 'NG-EK'),
('Enugu', 'NG-EN'),
('Gombe', 'NG-GO'),
('Imo', 'NG-IM'),
('Jigawa', 'NG-JI'),
('Kaduna', 'NG-KD'),
('Kano', 'NG-KN'),
('Katsina', 'NG-KT'),
('Kebbi', 'NG-KE'),
('Kogi', 'NG-KO'),
('Kwara', 'NG-KW'),
('Lagos', 'NG-LA'),
('Nasarawa', 'NG-NA'),
('Niger', 'NG-NI'),
('Ogun', 'NG-OG'),
('Ondo', 'NG-ON'),
('Osun', 'NG-OS'),
('Oyo', 'NG-OY'),
('Plateau', 'NG-PL'),
('Rivers', 'NG-RI'),
('Sokoto', 'NG-SO'),
('Taraba', 'NG-TA'),
('Yobe', 'NG-YO'),
('Zamfara', 'NG-ZA'),
('Federal Capital Territory', 'NG-FC');

✅ Summary

This setup models Nigeria's 36 states and 1 Federal Capital Territory with their ISO 3166-2:NG codes. It can be used in backend systems, geographic data applications, or databases dealing with Nigeria's administrative regions.



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