Programming & Development / April 11, 2025

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

Guatemala departments Java enum Guatemala ISO 3166-2 GT SQL Guatemala departments GT department codes Guatemala administrative divisions backend region enum Guatemala provinces Java SQL Spring Boot regions Guatemala

🇬🇹 Java Enum: Guatemala’s Departments

Guatemala is divided into 22 departments. Here’s the Java enum using ISO 3166-2:GT codes:

java

public enum GuatemalaDepartment {
    ALTA_VERAPAZ("GT-AV"),
    BAJO_VERAPAZ("GT-BV"),
    CHIMALTENANGO("GT-CH"),
    CHIQUIMULA("GT-CQ"),
    ESCUINTLA("GT-ES"),
    GUATEMALA("GT-GU"),
    HUEHUETENANGO("GT-HU"),
    IZABAL("GT-IZ"),
    JALAPA("GT-JA"),
    JUTIAPA("GT-JU"),
    PETEN("GT-PE"),
    QUETZALTENANGO("GT-QZ"),
    QUICHE("GT-QC"),
    RETALHULEU("GT-RE"),
    SACATEPEQUEZ("GT-SA"),
    SAN_MARCOS("GT-SM"),
    SAN_SALVADOR("GT-SS"),
    SANTA_ROSA("GT-SR"),
    SOLOLA("GT-SO"),
    SUCHITEPEQUEZ("GT-SU"),
    TOTONICAPAN("GT-TO"),
    ZACAPA("GT-ZA");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO guatemala_departments (name, code) VALUES
('Alta Verapaz', 'GT-AV'),
('Bajo Verapaz', 'GT-BV'),
('Chimaltenango', 'GT-CH'),
('Chiquimula', 'GT-CQ'),
('Escuintla', 'GT-ES'),
('Guatemala', 'GT-GU'),
('Huehuetenango', 'GT-HU'),
('Izabal', 'GT-IZ'),
('Jalapa', 'GT-JA'),
('Jutiapa', 'GT-JU'),
('Peten', 'GT-PE'),
('Quetzaltenango', 'GT-QZ'),
('Quiche', 'GT-QC'),
('Retalhuleu', 'GT-RE'),
('Sacatepequez', 'GT-SA'),
('San Marcos', 'GT-SM'),
('San Salvador', 'GT-SS'),
('Santa Rosa', 'GT-SR'),
('Solola', 'GT-SO'),
('Suchitepequez', 'GT-SU'),
('Totonicapán', 'GT-TO'),
('Zacapa', 'GT-ZA');

✅ Summary

This setup covers all 22 departments of Guatemala using ISO 3166-2:GT codes, ready 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