Programming & Development / April 11, 2025

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

Dominica parishes Java enum Dominica ISO 3166-2 DM SQL Dominica parishes DM parish codes Dominica administrative divisions Spring Boot enum Dominica region list backend enum Dominica

🇩🇲 Java Enum: Dominica’s Parishes

Dominica is divided into 10 parishes. Here's the Java enum with ISO codes:

java

public enum DominicaParish {
    SAINT_ANDREW("DM-02"),
    SAINT_DAVID("DM-03"),
    SAINT_GEORGE("DM-04"),
    SAINT_JOHN("DM-05"),
    SAINT_JOSEPH("DM-06"),
    SAINT_LUKE("DM-07"),
    SAINT_MARK("DM-08"),
    SAINT_PATRICK("DM-09"),
    SAINT_PAUL("DM-10"),
    SAINT_PETER("DM-11");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO dominica_parishes (name, code) VALUES
('Saint Andrew', 'DM-02'),
('Saint David', 'DM-03'),
('Saint George', 'DM-04'),
('Saint John', 'DM-05'),
('Saint Joseph', 'DM-06'),
('Saint Luke', 'DM-07'),
('Saint Mark', 'DM-08'),
('Saint Patrick', 'DM-09'),
('Saint Paul', 'DM-10'),
('Saint Peter', 'DM-11');

✅ Summary

This Java enum and SQL table setup enables clean integration of Dominica’s 10 parishes, each with its official ISO 3166-2:DM code, into backend applications or 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