Programming & Development / April 12, 2025

Enum Representation of Provinces in Turkey and SQL Table for Storing Provincial Data

Enum Turkey Provinces Java SQL Ankara Istanbul Administrative Divisions Province Code Turkey Enum Regions

✅ Enum Representation in Java

Turkey is divided into 81 provinces (iller), and each province has a unique administrative code.

Here’s the Java enum representing the provinces along with their standard two-letter codes:

java

public enum TurkeyProvince {
    ADANA("01"),
    ADIYAMAN("02"),
    AFYONKARAHISAR("03"),
    AĞRI("04"),
    AMASYA("05"),
    ANKARA("06"),
    ANTALYA("07"),
    ARDAHAN("75"),
    ARTVIN("08"),
    AYDIN("09"),
    BALIKESIR("10"),
    BARTIN("74"),
    BATMAN("72"),
    BAYBURT("69"),
    BİLECİK("11"),
    BINGÖL("12"),
    BITLIS("13"),
    BOLU("14"),
    BURDUR("15"),
    BURSA("16"),
    CANKIRI("18"),
    CEVAPLI("47"),
    CİREHAN("81"),
    ÇANAKKALE("17"),
    ÇORUM("19"),
    DENIZLI("20"),
    DİYARBAKIR("21"),
    DÜZCE("81"),
    ELAZIĞ("23"),
    ERZINCAN("24"),
    ERZURUM("25"),
    ESKİŞEHİR("26"),
    GAZİANTEP("27"),
    GİRESUN("28"),
    GÜMÜŞHANE("29"),
    HAKKARI("30"),
    HATAY("31"),
    IĞDIR("32"),
    ISPARTA("33"),
    İSTANBUL("34"),
    İZMIR("35"),
    KAHRAMANMARAŞ("46"),
    KARABÜK("78"),
    KARAMAN("70"),
    KASTAMONU("37"),
    KAYSERİ("38"),
    KIRIKKALE("71"),
    KIRKLARELİ("39"),
    KIRŞEHİR("40"),
    KOCAELİ("41"),
    KONYA("42"),
    KÜTAHYA("43"),
    MALATYA("44"),
    MANISA("45"),
    MARDİN("47"),
    MERSİN("33"),
    MUĞLA("48"),
    MUS("49"),
    NEVŞEHİR("50"),
    NİĞDE("51"),
    ORDU("52"),
    OSMANİYE("80"),
    RİZE("53"),
    SAKARYA("54"),
    SİİRT("56"),
    SİNOP("57"),
    SİVAS("58"),
    ŞANLIURFA("63"),
    ŞIRNAK("73"),
    TEKİRDAĞ("59"),
    TOKAT("60"),
    TRABZON("61"),
    TUNCELİ("62"),
    UŞAK("64"),
    VAN("65"),
    YALOVA("77"),
    YOZGAT("66"),
    ZONGULDAK("67");

    private final String code;

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

    public String getCode() {
        return this.code;
    }
}

✅ SQL Representation for Turkey’s Provinces

Here is the SQL schema and insert statements for the 81 provinces of Turkey:

sql

-- Table for Turkey provinces
CREATE TABLE turkey_provinces (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    code CHAR(2) NOT NULL
);

-- Insert provinces into the table
INSERT INTO turkey_provinces (name, code) VALUES
('Adana', '01'),
('Adıyaman', '02'),
('Afyonkarahisar', '03'),
('Ağrı', '04'),
('Amasya', '05'),
('Ankara', '06'),
('Antalya', '07'),
('Ardahan', '75'),
('Artvin', '08'),
('Aydın', '09'),
('Balıkesir', '10'),
('Bartın', '74'),
('Batman', '72'),
('Bayburt', '69'),
('Bilecik', '11'),
('Bingöl', '12'),
('Bitlis', '13'),
('Bolu', '14'),
('Burdur', '15'),
('Bursa', '16'),
('Çanakkale', '17'),
('Çorum', '19'),
('Denizli', '20'),
('Diyarbakır', '21'),
('Düzce', '81'),
('Elazığ', '23'),
('Erzincan', '24'),
('Erzurum', '25'),
('Eskişehir', '26'),
('Gaziantep', '27'),
('Giresun', '28'),
('Gümüşhane', '29'),
('Hakkari', '30'),
('Hatay', '31'),
('Iğdır', '32'),
('Isparta', '33'),
('İstanbul', '34'),
('İzmir', '35'),
('Kahramanmaraş', '46'),
('Karabük', '78'),
('Karaman', '70'),
('Kastamonu', '37'),
('Kayseri', '38'),
('Kırıkkale', '71'),
('Kırklareli', '39'),
('Kırşehir', '40'),
('Kocaeli', '41'),
('Konya', '42'),
('Kütahya', '43'),
('Malatya', '44'),
('Manisa', '45'),
('Mardin', '47'),
('Mersin', '33'),
('Muğla', '48'),
('Muş', '49'),
('Nevşehir', '50'),
('Niğde', '51'),
('Ordu', '52'),
('Osmaniye', '80'),
('Rize', '53'),
('Sakarya', '54'),
('Siirt', '56'),
('Sinop', '57'),
('Sivas', '58'),
('Şanlıurfa', '63'),
('Şırnak', '73'),
('Tekirdağ', '59'),
('Tokat', '60'),
('Trabzon', '61'),
('Tunceli', '62'),
('Uşak', '64'),
('Van', '65'),
('Yalova', '77'),
('Yozgat', '66'),
('Zonguldak', '67');

This setup supports applications managing demographic, administrative, or geographic data related to Turkey's provinces.



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