Programming & Development / April 11, 2025

How to Represent Colombia’s Departments in Java and SQL Using ISO 3166-2 Codes

Colombia departments Java enum Colombia ISO 3166-2 CO SQL Colombia departments Colombia administrative divisions Spring Boot enum Colombia department list CO department codes provinces of Colombia

🇨🇴 Java Enum: Colombia’s Departments

Colombia has 32 departments and 1 capital district (Bogotá D.C.), which are equivalent to provinces. Here's the Java enum with official ISO 3166-2:CO codes:

java

public enum ColombiaDepartment {
    AMAZONAS("CO-AMA"),
    ANTIOQUIA("CO-ANT"),
    ARAUCA("CO-ARA"),
    ATLANTICO("CO-ATL"),
    BOLIVAR("CO-BOL"),
    BOYACA("CO-BOY"),
    CALDAS("CO-CAL"),
    CAQUETA("CO-CAQ"),
    CASANARE("CO-CAS"),
    CAUCA("CO-CAU"),
    CESAR("CO-CES"),
    CHOCO("CO-CHO"),
    CORDOBA("CO-COR"),
    CUNDINAMARCA("CO-CUN"),
    GUAINIA("CO-GUA"),
    GUAVIARE("CO-GUV"),
    HUILA("CO-HUI"),
    LA_GUAJIRA("CO-LAG"),
    MAGDALENA("CO-MAG"),
    META("CO-MET"),
    NARINO("CO-NAR"),
    NORTE_DE_SANTANDER("CO-NSA"),
    PUTUMAYO("CO-PUT"),
    QUINDIO("CO-QUI"),
    RISARALDA("CO-RIS"),
    SAN_ANDRES("CO-SAP"),
    SANTANDER("CO-SAN"),
    SUCRE("CO-SUC"),
    TOLIMA("CO-TOL"),
    VALLE_DEL_CAUCA("CO-VAC"),
    VAUPES("CO-VAU"),
    VICHADA("CO-VID"),
    BOGOTA_DC("CO-DC");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO colombia_departments (name, code) VALUES
('Amazonas', 'CO-AMA'),
('Antioquia', 'CO-ANT'),
('Arauca', 'CO-ARA'),
('Atlántico', 'CO-ATL'),
('Bolívar', 'CO-BOL'),
('Boyacá', 'CO-BOY'),
('Caldas', 'CO-CAL'),
('Caquetá', 'CO-CAQ'),
('Casanare', 'CO-CAS'),
('Cauca', 'CO-CAU'),
('Cesar', 'CO-CES'),
('Chocó', 'CO-CHO'),
('Córdoba', 'CO-COR'),
('Cundinamarca', 'CO-CUN'),
('Guainía', 'CO-GUA'),
('Guaviare', 'CO-GUV'),
('Huila', 'CO-HUI'),
('La Guajira', 'CO-LAG'),
('Magdalena', 'CO-MAG'),
('Meta', 'CO-MET'),
('Nariño', 'CO-NAR'),
('Norte de Santander', 'CO-NSA'),
('Putumayo', 'CO-PUT'),
('Quindío', 'CO-QUI'),
('Risaralda', 'CO-RIS'),
('San Andrés, Providencia y Santa Catalina', 'CO-SAP'),
('Santander', 'CO-SAN'),
('Sucre', 'CO-SUC'),
('Tolima', 'CO-TOL'),
('Valle del Cauca', 'CO-VAC'),
('Vaupés', 'CO-VAU'),
('Vichada', 'CO-VID'),
('Bogotá D.C.', 'CO-DC');

✅ Summary

This Java enum and SQL setup represent Colombia's 32 departments plus Bogotá D.C., using ISO 3166-2:CO codes. It’s ideal for systems needing accurate regional data with international code standards.


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