Programming & Development / April 11, 2025

How to Represent Bulgaria’s Provinces in Java and SQL Using ISO 3166-2 Codes

Bulgaria provinces Java enum Bulgaria ISO 3166-2 BG SQL Bulgaria provinces Bulgaria administrative divisions Spring Boot enum Bulgaria regions list BG region codes provinces of Bulgaria

🇧🇬 Java Enum: Bulgaria’s Provinces

Bulgaria is divided into 28 provinces (oblasti). Here’s the Java enum using the ISO 3166-2:BG codes.

java

public enum BulgariaProvince {
    BLOVDIVO("BG-01"),
    BURGAS("BG-02"),
    VARNA("BG-03"),
    VIDIN("BG-04"),
    VELIKO_TARNOVO("BG-05"),
    VRAKA("BG-06"),
    GABROVO("BG-07"),
    DOBRICH("BG-08"),
    KARDJALI("BG-09"),
    KYUSTENDIL("BG-10"),
    LOVECH("BG-11"),
    MONTA("BG-12"),
    PERNIK("BG-13"),
    PLOVDIV("BG-14"),
    RUSE("BG-15"),
    SILIYANA("BG-16"),
    SLIVEN("BG-17"),
    SMOLYAN("BG-18"),
    SOFIA("BG-19"),
    STARA_ZAGORA("BG-20"),
    TARGOVISHTE("BG-21"),
    HASKOVO("BG-22"),
    SHUMEN("BG-23"),
    YAMBOL("BG-24"),
    HASKOVO("BG-25"),
    BULGARIA("BG-26"),
    VARNA("BG-27");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO bulgaria_provinces (name, code) VALUES
('Blovdivo', 'BG-01'),
('Burgas', 'BG-02'),
('Varna', 'BG-03'),
('Vidin', 'BG-04'),
('Veliko Tarnovo', 'BG-05'),
('Vraska', 'BG-06'),
('Gabrovo', 'BG-07'),
('Dobrich', 'BG-08'),
('Kardjali', 'BG-09'),
('Kyustendil', 'BG-10'),
('Lovech', 'BG-11'),
('Montana', 'BG-12'),
('Pernik', 'BG-13'),
('Plovdiv', 'BG-14'),
('Ruse', 'BG-15'),
('Siliyana', 'BG-16'),
('Sliven', 'BG-17'),
('Smolyan', 'BG-18'),
('Sofia', 'BG-19'),
('Stara Zagora', 'BG-20'),
('Targovishte', 'BG-21'),
('Haskovo', 'BG-22'),
('Shumen', 'BG-23'),
('Yambol', 'BG-24'),
('Haskovo', 'BG-25'),
('Bulgaria', 'BG-26'),
('Varna', 'BG-27');

✅ Summary

This setup represents Bulgaria’s 28 provinces using the ISO 3166-2:BG codes. It’s ideal for managing geographical data, administrative divisions, or region-based functionalities within your applications.


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