Programming & Development / April 11, 2025

How to Represent Dominican Republic’s Provinces in Java and SQL Using ISO 3166-2 Codes

Dominican Republic provinces Java enum Dominican Republic ISO 3166-2 DO SQL Dominican provinces DO province codes Dominican administrative divisions Spring Boot enum Dominican backend data Dominican ISO codes

🇩🇴 Java Enum: Dominican Republic’s Provinces

The Dominican Republic is divided into 31 provinces and 1 National District (Distrito Nacional). Here's the Java enum:

java

public enum DominicanRepublicProvince {
    DISTRITO_NACIONAL("DO-01"),
    AZUA("DO-02"),
    BAORUCO("DO-03"),
    BARAHONA("DO-04"),
    DAJABON("DO-05"),
    DUARTE("DO-06"),
    EL_SEIBO("DO-07"),
    ELIAS_PINA("DO-08"),
    ESPAILLAT("DO-09"),
    INDEPENDENCIA("DO-10"),
    LA_ALTAGRACIA("DO-11"),
    LA_ROMANA("DO-12"),
    LA_VEGA("DO-13"),
    MARIA_TRINIDAD_SANCHEZ("DO-14"),
    MONSEÑOR_NOUEL("DO-15"),
    MONTE_CRISTI("DO-16"),
    PEDERNALES("DO-17"),
    PERAVIA("DO-18"),
    PUERTO_PLATA("DO-19"),
    HERMANAS_MIRABAL("DO-20"),
    SAMANA("DO-21"),
    SAN_CRISTOBAL("DO-22"),
    SAN_JOSE_DE_OCOA("DO-31"),
    SAN_JUAN("DO-23"),
    SAN_PEDRO_DE_MACORIS("DO-24"),
    SANCHEZ_RAMIREZ("DO-25"),
    SANTIAGO("DO-26"),
    SANTIAGO_RODRIGUEZ("DO-27"),
    VALVERDE("DO-28"),
    MONTE_PLATA("DO-29"),
    HATO_MAYOR("DO-30");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO dominican_republic_provinces (name, code) VALUES
('Distrito Nacional', 'DO-01'),
('Azua', 'DO-02'),
('Baoruco', 'DO-03'),
('Barahona', 'DO-04'),
('Dajabón', 'DO-05'),
('Duarte', 'DO-06'),
('El Seibo', 'DO-07'),
('Elías Piña', 'DO-08'),
('Espaillat', 'DO-09'),
('Independencia', 'DO-10'),
('La Altagracia', 'DO-11'),
('La Romana', 'DO-12'),
('La Vega', 'DO-13'),
('María Trinidad Sánchez', 'DO-14'),
('Monseñor Nouel', 'DO-15'),
('Monte Cristi', 'DO-16'),
('Pedernales', 'DO-17'),
('Peravia', 'DO-18'),
('Puerto Plata', 'DO-19'),
('Hermanas Mirabal', 'DO-20'),
('Samaná', 'DO-21'),
('San Cristóbal', 'DO-22'),
('San Juan', 'DO-23'),
('San Pedro de Macorís', 'DO-24'),
('Sánchez Ramírez', 'DO-25'),
('Santiago', 'DO-26'),
('Santiago Rodríguez', 'DO-27'),
('Valverde', 'DO-28'),
('Monte Plata', 'DO-29'),
('Hato Mayor', 'DO-30'),
('San José de Ocoa', 'DO-31');

✅ Summary

This setup includes all 31 provinces and the National District of the Dominican Republic with ISO 3166-2:DO codes. You can now easily integrate these into your Java apps or 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