othmanus algeria city Splitter

فصل الولايات و الدوائر و البلديات إلي جداول منفردة

   {
        "id": 22,
        "commune_name_ascii": "Timekten",
        "commune_name": "تيمقتن",
        "daira_name_ascii": "Aoulef",
        "daira_name": "أولف",
        "wilaya_code": "01",
        "wilaya_name_ascii": "Adrar",
        "wilaya_name": "أدرار"
    }
	

تحويلها إلي

baladiyas.sql

dairas.sql

state.sql

        TABLE    state 
 
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wilaya_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,


         TABLE   dairas
	   
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_state` int(11) NOT NULL,


          TABLE baladiyas

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_daira` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `daira_arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `daira_french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

Data	total
Wilayas	58
Daïras	546
baladiyahs	1541

🇩🇿 Algeria administrative division 🇩🇿

🇩🇿 Algeria administrative division 🇩🇿

Helpful ressources:

• othmanus

Authors

• zahsadz: github

zahrane sa facebook / @zah4dz