Programming & Development / April 11, 2025

How to Represent Liberia’s Counties in Java and SQL Using ISO 3166-2 Codes

Liberia counties Java enum Liberia ISO 3166-2 LR SQL Liberia counties LR county codes Liberia administrative divisions backend region enum Liberia counties Java SQL Spring Boot regions Liberia

🇱🇷 Java Enum: Liberia’s Counties

Liberia is divided into 15 counties. Here’s the Java enum using ISO 3166-2:LR codes:

java

public enum LiberiaCounty {
    BONG("LR-BG"),
    GBARPOLU("LR-GP"),
    GRAND_BASSA("LR-GB"),
    GRAND_CAPE_MOUNT("LR-GC"),
    GRAND_GEDA("LR-GD"),
    LOFA("LR-LF"),
    MARGIBI("LR-MG"),
    MONTSERADO("LR-MO"),
    NIMBA("LR-NM"),
    RIVER_CESS("LR-RC"),
    RIVER_GEE("LR-RG"),
    SINOE("LR-SI"),
    MARYLAND("LR-MD"),
    BASSA("LR-BS"),
    BAMBOO("LR-BA");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO liberia_counties (name, code) VALUES
('Bong', 'LR-BG'),
('Gbarpolu', 'LR-GP'),
('Grand Bassa', 'LR-GB'),
('Grand Cape Mount', 'LR-GC'),
('Grand Geda', 'LR-GD'),
('Lofa', 'LR-LF'),
('Margibi', 'LR-MG'),
('Montserado', 'LR-MO'),
('Nimba', 'LR-NM'),
('River Cess', 'LR-RC'),
('River Gee', 'LR-RG'),
('Sinoe', 'LR-SI'),
('Maryland', 'LR-MD'),
('Bassa', 'LR-BS'),
('Bamboo', 'LR-BA');

✅ Summary

This setup covers all 15 counties of Liberia using ISO 3166-2:LR 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