✅ 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.