Programming & Development / April 11, 2025

How to Represent Finland’s Regions in Java and SQL Using ISO 3166-2 Codes

Finland regions Java enum Finland ISO 3166-2 FI SQL Finland regions FI region codes Finland administrative divisions backend region enum Finland provinces Java SQL Spring Boot regions Finland

🇫🇮 Java Enum: Finland’s Regions

Finland is divided into 19 regions. Here’s the Java enum using ISO 3166-2:FI codes:

java

public enum FinlandRegion {
    AHVENANMAA("FI-01"),
    UUSIMAA("FI-18"),
    SATAKUNTA("FI-05"),
    PIRKANMAA("FI-06"),
    KAINUU("FI-07"),
    POHJOIS_SAVO("FI-08"),
    KESKI_SUOMI("FI-09"),
    POHJANMAA("FI-10"),
    KESKI_POHJANMAA("FI-11"),
    LAPPI("FI-12"),
    ETELA_KARJALA("FI-13"),
    ETELA_POHJANMAA("FI-14"),
    SAVO("FI-15"),
    VAAKSA("FI-16"),
    KARELIA("FI-17"),
    PÄIJÄNE("FI-19"),
    LÄNSI("FI-20");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO finland_regions (name, code) VALUES
('Ahvenanmaa', 'FI-01'),
('Uusimaa', 'FI-18'),
('Satakunta', 'FI-05'),
('Pirkanmaa', 'FI-06'),
('Kainuu', 'FI-07'),
('Pohjois Savo', 'FI-08'),
('Keski Suomi', 'FI-09'),
('Pohjanmaa', 'FI-10'),
('Keski Pohjanmaa', 'FI-11'),
('Lapland', 'FI-12'),
('Etela Karjala', 'FI-13'),
('Etela Pohjanmaa', 'FI-14'),
('Savon', 'FI-15'),
('Vakka', 'FI-16'),
('Karelia', 'FI-17'),
('Pajanne', 'FI-19'),
('Land', 'FI-20');

✅ Summary

This structure covers all 19 regions of Finland, using ISO 3166-2:FI 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