Programming & Development / April 11, 2025

How to Represent Estonia’s Counties in Java and SQL Using ISO 3166-2 Codes

Estonia counties Java enum Estonia ISO 3166-2 EE SQL Estonia counties EE county codes Estonia administrative divisions backend region enum Estonia provinces Java SQL Spring Boot Estonia regions

🇪🇪 Java Enum: Estonia’s Counties

Estonia is divided into 15 counties. Here is the Java enum using ISO 3166-2:EE codes:

java

public enum EstoniaCounty {
    HIIU("EE-37"),
    HARJU("EE-39"),
    HIIU("EE-37"),
    JÕGEVA("EE-44"),
    JÄRVA("EE-49"),
    JÕGEVA("EE-44"),
    LÄÄNE("EE-57"),
    LÄÄNE_VIRU("EE-59"),
    PÕLVA("EE-64"),
    PÄRNU("EE-67"),
    RAPLA("EE-70"),
    SAARE("EE-74"),
    TARTU("EE-78"),
    VALGA("EE-82"),
    VILJANDI("EE-85");
    
    private final String code;
    EstoniaCounty(String code) {
        this.code = code;
    }
    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO estonia_counties (name, code) VALUES
('Hiiu', 'EE-37'),
('Harju', 'EE-39'),
('Jõgeva', 'EE-44'),
('Järva', 'EE-49'),
('Lääne', 'EE-57'),
('Lääne-Viru', 'EE-59'),
('Põlva', 'EE-64'),
('Pärnu', 'EE-67'),
('Rapla', 'EE-70'),
('Saare', 'EE-74'),
('Tartu', 'EE-78'),
('Valga', 'EE-82'),
('Viljandi', 'EE-85');

✅ Summary

This solution covers all 15 counties of Estonia, using ISO 3166-2:EE codes. It’s useful for backend services, region-based data handling in Java, and SQL database integrations.


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