Programming & Development / April 11, 2025

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

El Salvador departments Java enum El Salvador ISO 3166-2 SV SQL El Salvador departments SV department codes El Salvador administrative divisions Spring Boot enum El Salvador backend data region enum for El Salvador

🇸🇻 Java Enum: El Salvador’s Departments

El Salvador is divided into 14 departments, each with an official ISO 3166-2:SV code. Here's the Java enum:

java

public enum ElSalvadorDepartment {
    AHUACHAPAN("SV-AH"),
    CABANAS("SV-CA"),
    CHALATENANGO("SV-CH"),
    CUSCATLAN("SV-CU"),
    LA_LIBERTAD("SV-LI"),
    LA_PAZ("SV-PA"),
    LA_UNION("SV-UN"),
    MORAZAN("SV-MO"),
    SAN_MIGUEL("SV-SM"),
    SAN_SALVADOR("SV-SS"),
    SAN_VICENTE("SV-SV"),
    SANTA_ANA("SV-SA"),
    SONSONATE("SV-SO"),
    USULUTAN("SV-US");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO el_salvador_departments (name, code) VALUES
('Ahuachapán', 'SV-AH'),
('Cabañas', 'SV-CA'),
('Chalatenango', 'SV-CH'),
('Cuscatlán', 'SV-CU'),
('La Libertad', 'SV-LI'),
('La Paz', 'SV-PA'),
('La Unión', 'SV-UN'),
('Morazán', 'SV-MO'),
('San Miguel', 'SV-SM'),
('San Salvador', 'SV-SS'),
('San Vicente', 'SV-SV'),
('Santa Ana', 'SV-SA'),
('Sonsonate', 'SV-SO'),
('Usulután', 'SV-US');

✅ Summary

This setup includes all 14 departments of El Salvador using official ISO 3166-2:SV codes. It's ideal for applications needing region data in Java backends 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