Programming & Development / April 11, 2025

How to Represent Jamaica’s Parishes in Java and SQL Using ISO 3166-2 Codes

Jamaica parishes Java enum Jamaica ISO 3166-2 JM SQL Jamaica parishes JM parish codes Jamaica administrative divisions backend region enum Jamaica parishes Java SQL Spring Boot regions Jamaica

🇯🇲 Java Enum: Jamaica’s Parishes

Jamaica is divided into 14 parishes. Here’s the Java enum using ISO 3166-2:JM codes:

java

public enum JamaicaParish {
    KINGSTON("JM-K"),
    ST_ANDREW("JM-01"),
    ST_CATHERINE("JM-02"),
    ST_MARY("JM-03"),
    ST_ANN("JM-04"),
    ST_JAMES("JM-05"),
    HANOVER("JM-06"),
    WESTMORELAND("JM-07"),
    TRELLOWNY("JM-08"),
    ST_ELIZABETH("JM-09"),
    MANCHESTER("JM-10"),
    CLARENDON("JM-11"),
    ST_THOMAS("JM-12"),
    PORTLAND("JM-13");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO jamaica_parishes (name, code) VALUES
('Kingston', 'JM-K'),
('St. Andrew', 'JM-01'),
('St. Catherine', 'JM-02'),
('St. Mary', 'JM-03'),
('St. Ann', 'JM-04'),
('St. James', 'JM-05'),
('Hanover', 'JM-06'),
('Westmoreland', 'JM-07'),
('Trelawny', 'JM-08'),
('St. Elizabeth', 'JM-09'),
('Manchester', 'JM-10'),
('Clarendon', 'JM-11'),
('St. Thomas', 'JM-12'),
('Portland', 'JM-13');

✅ Summary

This setup covers all 14 parishes of Jamaica using ISO 3166-2:JM codes, ideal for backend systems, 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