Programming & Development / April 11, 2025

Modeling Panama's Provinces in Java and SQL Using ISO 3166-2:PA Codes

Panama provinces Panama regions Java enum Panama ISO 3166-2 PA SQL Panama Panama subdivisions Spring Boot geographic enum Panama administrative units backend regions Panama provinces of Panama

🇵🇦 Java Enum: Panama's Provinces

Panama is divided into 10 provinces and 5 indigenous regions. Each province and region has its official ISO 3166-2:PA code.

java

public enum PanamaProvince {
    BOCAS_DEL_TORO("PA-1"),
    COCLE("PA-2"),
    COLON("PA-3"),
    DARIEN("PA-4"),
    PANAMA("PA-5"),
    VERAGUAS("PA-6"),
    CHIRIQUI("PA-7"),
    HERRERA("PA-8"),
    LOS_SANTOS("PA-9"),
    COMARCA_GUNA_YALA("PA-10"),
    COMARCA_NOVO_HONDA("PA-11"),
    COMARCA_KUNA_YALA("PA-12"),
    PANAMA_REGIONS("PA-13");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO panama_provinces (name, code) VALUES
('Bocas del Toro', 'PA-1'),
('Cocle', 'PA-2'),
('Colon', 'PA-3'),
('Darien', 'PA-4'),
('Panama', 'PA-5'),
('Veraguas', 'PA-6'),
('Chiriqui', 'PA-7'),
('Herrera', 'PA-8'),
('Los Santos', 'PA-9'),
('Comarca Guna Yala', 'PA-10'),
('Comarca Novo Honda', 'PA-11'),
('Comarca Kuna Yala', 'PA-12'),
('Panama Regions', 'PA-13');

✅ Summary

This setup models Panama's provinces and regions with their ISO 3166-2:PA codes. It can be used in backend systems, geographic applications, or databases dealing with Panama'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