PHP dinamik il ve ilçe seçim kutusu sorunu

Aşağı Git Tüm Forumlar Web Tasarım - Programlama Yazılım Geliştirme PHP / CGI PHP dinamik il ve ilçe seçim kutusu sorunu

Bu konudaki kullanıcılar: 1 misafir, 1 mobil kullanıcı

5
Cevap 545
Tıklama 0
Öne Çıkarma

1. sayfa

PHP dinamik il ve ilçe seçim kutusu sorunu

Cevap Yaz

esesdi

11 yıl

Onbaşı

Konu Sahibi

Merhaba

Bir php emlak sitesi düzenlemekteyım ve bu siteye internetten bulduğum bir dinamik il&ilçe seçim kutusu ekledim.Görüntüde veya işlemde herhangi bir sıkıntı yok çalışıyor ancak sorun şu ki ;

Seçim Yapıldığında ve ilan kaydedilip sergilendiğinde (il 1 Adana ve İlçesi 1 Merkez için)

ilanda il:1/ilçe:1 yazıyor

ilçeyi düzeltmek sorun değildi. option value $ilçe[ID] yerine $ilçe[ADI] yazdım ve artık il:1 ilçe:Merkez yazıyor.
ancak il'i düzelttiğimde çalışmamaya başlıyor..

 
   
  sql örnek tabloları 
  tablo adı: 
  secmeli_il 
   
  ID               ADI 
  1                 ADANA 
   
   
  tablo adı: 
  secmeli_ilce 
  ID           İL_ID       ADI 
  1                1           Merkez

script :

$(document).ready(function(e) { 
  	illeriGetir(); 
      $("#secmeli_il").bind('change',ilceleriGetir); 
  }); 
   
  function illeriGetir(){ 
  	$.post('dinamik.php',{ilId: 0},function(output){ 
  		$("#secmeli_il").append(output); 
  	});	 
  } 
   
  function ilceleriGetir(){ 
  	if($("#secmeli_il").val() != 0){ 
  		$.post('dinamik.php',{ilId: $("#secmeli_il").val()},function(output){ 
  			$("#secmeli_ilce option").remove(); 
  			$("#secmeli_ilce").append(output); 
  		}); 
  	} 
  	else{ 
  		$("#secmeli_ilce option").remove(); 
  		$("#secmeli_ilce").append('<option value="0">Önce İl Seçiniz</option>'); 
  	} 
  }

dinamik.php

<?php session_start(); 
  include("config.php"); 
  mysql_query("SET NAMES 'utf8'"); 
  mysql_query("SET CHARACTER SET utf8"); 
  mysql_query("SET COLLATION_CONNECTION = 'utf8_bin'"); ?> 
  <?php 
  	include('config.php'); 
  		 
  	 
  	 
  $ilId = $_POST['ilId']; 
  	$rv = ''; 
  	if($ilId != 0){ 
  		$query = mysql_query('select * from secmeli_ilce where IL_ID = "'.$ilId.'"'); 
  		while($ilce = mysql_fetch_array($query)){ 
  			$rv .= '<option value="'. $ilce['ID'].'">'.$ilce['ADI'].'</option>';	 
  		} 
  		 
  		echo $rv; 
  	}else{ 
  		$query = mysql_query('select * from secmeli_il '); 
  		while($il = mysql_fetch_array($query)){ 
  			$rv .= '<option value="'. $il['ID'].'">'.$il['ADI'].'</option>';	 
  		} 
  		 
  		echo $rv; 
  	} 
  ?>

sayfada form içerisinde bulunan form öğesi :

<h4>İl seçiniz:</h4> 
  	<select id="secmeli_il" name="il">  
      	<option value="0" >İl Seçiniz</option><br><br> 
      </select> 
      <h4>İlce seçiniz:</h4> 
      <select id="secmeli_ilce" name="ilce"> 
      	<option value="0">Önce İl Seçiniz</option><br><br> 
  						</select><br><br>

< Bu mesaj bu kişi tarafından değiştirildi esesdi -- 11 Kasım 2014; 15:34:55 >

Perceptron

11 yıl

Binbaşı

http://avukatkutusu.com da 0dan yazmıştım bunu. bir listede 81 il vardı, ilin + sına tıklayıp ilçelerinin görebiliyordun. yani avukat nerelerle ilgilendiğini ilçe hassasiyetinde seçebiliyordu.
fakat kodları seninle paylaşamam.(nasıl yaptığımı bende unuttum, bulmaya üşeniyorum) sadece veri tabanını konusunda yardımcı olabilirim.

tur ilmi ilçemi olduğu sehir ilcenin bulundu şehir. 1400 ilçemiz varmış bu arada

CREATE TABLE `av_kapsam` ( 
    `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, 
    `tur` tinyint(1) NOT NULL, 
    `sehir` tinyint(3) unsigned NOT NULL DEFAULT '0', 
    `ad` varchar(64) NOT NULL, 
    PRIMARY KEY (`id`) 
  ) ENGINE=MyISAM AUTO_INCREMENT=1039 DEFAULT CHARSET=utf8; 
     INSERT INTO `av_kapsam` VALUES ('1', '0', '0', 'ADANA'); 
  INSERT INTO `av_kapsam` VALUES ('2', '0', '0', 'ADIYAMAN'); 
  INSERT INTO `av_kapsam` VALUES ('3', '0', '0', 'AFYON'); 
  INSERT INTO `av_kapsam` VALUES ('4', '0', '0', 'AĞRI'); 
  INSERT INTO `av_kapsam` VALUES ('5', '0', '0', 'AMASYA'); 
  INSERT INTO `av_kapsam` VALUES ('6', '0', '0', 'ANKARA'); 
  INSERT INTO `av_kapsam` VALUES ('7', '0', '0', 'ANTALYA'); 
  INSERT INTO `av_kapsam` VALUES ('8', '0', '0', 'ARTVİN'); 
  INSERT INTO `av_kapsam` VALUES ('9', '0', '0', 'AYDIN'); 
  INSERT INTO `av_kapsam` VALUES ('10', '0', '0', 'BALIKESİR'); 
  INSERT INTO `av_kapsam` VALUES ('11', '0', '0', 'BİLECİK'); 
  INSERT INTO `av_kapsam` VALUES ('12', '0', '0', 'BİNGÖL'); 
  INSERT INTO `av_kapsam` VALUES ('13', '0', '0', 'BİTLİS'); 
  INSERT INTO `av_kapsam` VALUES ('14', '0', '0', 'BOLU'); 
  INSERT INTO `av_kapsam` VALUES ('15', '0', '0', 'BURDUR'); 
  INSERT INTO `av_kapsam` VALUES ('16', '0', '0', 'BURSA'); 
  INSERT INTO `av_kapsam` VALUES ('17', '0', '0', 'ÇANAKKALE'); 
  INSERT INTO `av_kapsam` VALUES ('18', '0', '0', 'ÇANKIRI'); 
  INSERT INTO `av_kapsam` VALUES ('19', '0', '0', 'ÇORUM'); 
  INSERT INTO `av_kapsam` VALUES ('20', '0', '0', 'DENİZLİ'); 
  INSERT INTO `av_kapsam` VALUES ('21', '0', '0', 'DİYARBAKIR'); 
  INSERT INTO `av_kapsam` VALUES ('22', '0', '0', 'EDİRNE'); 
  INSERT INTO `av_kapsam` VALUES ('23', '0', '0', 'ELAZIĞ'); 
  INSERT INTO `av_kapsam` VALUES ('24', '0', '0', 'ERZİNCAN'); 
  INSERT INTO `av_kapsam` VALUES ('25', '0', '0', 'ERZURUM'); 
  INSERT INTO `av_kapsam` VALUES ('26', '0', '0', 'ESKİŞEHİR'); 
  INSERT INTO `av_kapsam` VALUES ('27', '0', '0', 'GAZİANTEP'); 
  INSERT INTO `av_kapsam` VALUES ('28', '0', '0', 'GİRESUN'); 
  INSERT INTO `av_kapsam` VALUES ('29', '0', '0', 'GÜMÜŞHANE'); 
  INSERT INTO `av_kapsam` VALUES ('30', '0', '0', 'HAKKARİ'); 
  INSERT INTO `av_kapsam` VALUES ('31', '0', '0', 'HATAY'); 
  INSERT INTO `av_kapsam` VALUES ('32', '0', '0', 'ISPARTA'); 
  INSERT INTO `av_kapsam` VALUES ('33', '0', '0', 'İÇEL'); 
  INSERT INTO `av_kapsam` VALUES ('34', '0', '0', 'İSTANBUL'); 
  INSERT INTO `av_kapsam` VALUES ('35', '0', '0', 'İZMİR'); 
  INSERT INTO `av_kapsam` VALUES ('36', '0', '0', 'KARS'); 
  INSERT INTO `av_kapsam` VALUES ('37', '0', '0', 'KASTAMONU'); 
  INSERT INTO `av_kapsam` VALUES ('38', '0', '0', 'KAYSERİ'); 
  INSERT INTO `av_kapsam` VALUES ('39', '0', '0', 'KIRKLARELİ'); 
  INSERT INTO `av_kapsam` VALUES ('40', '0', '0', 'KIRŞEHİR'); 
  INSERT INTO `av_kapsam` VALUES ('41', '0', '0', 'KOCAELİ'); 
  INSERT INTO `av_kapsam` VALUES ('42', '0', '0', 'KONYA'); 
  INSERT INTO `av_kapsam` VALUES ('43', '0', '0', 'KÜTAHYA'); 
  INSERT INTO `av_kapsam` VALUES ('44', '0', '0', 'MALATYA'); 
  INSERT INTO `av_kapsam` VALUES ('45', '0', '0', 'MANİSA'); 
  INSERT INTO `av_kapsam` VALUES ('46', '0', '0', 'KAHRAMANMARAŞ'); 
  INSERT INTO `av_kapsam` VALUES ('47', '0', '0', 'MARDİN'); 
  INSERT INTO `av_kapsam` VALUES ('48', '0', '0', 'MUĞLA'); 
  INSERT INTO `av_kapsam` VALUES ('49', '0', '0', 'MUŞ'); 
  INSERT INTO `av_kapsam` VALUES ('50', '0', '0', 'NEVŞEHİR'); 
  INSERT INTO `av_kapsam` VALUES ('51', '0', '0', 'NİĞDE'); 
  INSERT INTO `av_kapsam` VALUES ('52', '0', '0', 'ORDU'); 
  INSERT INTO `av_kapsam` VALUES ('53', '0', '0', 'RİZE'); 
  INSERT INTO `av_kapsam` VALUES ('54', '0', '0', 'SAKARYA'); 
  INSERT INTO `av_kapsam` VALUES ('55', '0', '0', 'SAMSUN'); 
  INSERT INTO `av_kapsam` VALUES ('56', '0', '0', 'SİİRT'); 
  INSERT INTO `av_kapsam` VALUES ('57', '0', '0', 'SİNOP'); 
  INSERT INTO `av_kapsam` VALUES ('58', '0', '0', 'SİVAS'); 
  INSERT INTO `av_kapsam` VALUES ('59', '0', '0', 'TEKİRDAĞ'); 
  INSERT INTO `av_kapsam` VALUES ('60', '0', '0', 'TOKAT'); 
  INSERT INTO `av_kapsam` VALUES ('61', '0', '0', 'TRABZON'); 
  INSERT INTO `av_kapsam` VALUES ('62', '0', '0', 'TUNCELİ'); 
  INSERT INTO `av_kapsam` VALUES ('63', '0', '0', 'ŞANLIURFA'); 
  INSERT INTO `av_kapsam` VALUES ('64', '0', '0', 'UŞAK'); 
  INSERT INTO `av_kapsam` VALUES ('65', '0', '0', 'VAN'); 
  INSERT INTO `av_kapsam` VALUES ('66', '0', '0', 'YOZGAT'); 
  INSERT INTO `av_kapsam` VALUES ('67', '0', '0', 'ZONGULDAK'); 
  INSERT INTO `av_kapsam` VALUES ('68', '0', '0', 'AKSARAY'); 
  INSERT INTO `av_kapsam` VALUES ('69', '0', '0', 'BAYBURT'); 
  INSERT INTO `av_kapsam` VALUES ('70', '0', '0', 'KARAMAN'); 
  INSERT INTO `av_kapsam` VALUES ('71', '0', '0', 'KIRIKKALE'); 
  INSERT INTO `av_kapsam` VALUES ('72', '0', '0', 'BATMAN'); 
  INSERT INTO `av_kapsam` VALUES ('73', '0', '0', 'ŞIRNAK'); 
  INSERT INTO `av_kapsam` VALUES ('74', '0', '0', 'BARTIN'); 
  INSERT INTO `av_kapsam` VALUES ('75', '0', '0', 'ARDAHAN'); 
  INSERT INTO `av_kapsam` VALUES ('76', '0', '0', 'IĞDIR'); 
  INSERT INTO `av_kapsam` VALUES ('77', '0', '0', 'YALOVA'); 
  INSERT INTO `av_kapsam` VALUES ('78', '0', '0', 'KARABÜK'); 
  INSERT INTO `av_kapsam` VALUES ('79', '0', '0', 'KİLİS'); 
  INSERT INTO `av_kapsam` VALUES ('80', '0', '0', 'OSMANİYE'); 
  INSERT INTO `av_kapsam` VALUES ('81', '0', '0', 'DÜZCE'); 
  INSERT INTO `av_kapsam` VALUES ('82', '1', '1', 'Aladağ'); 
  INSERT INTO `av_kapsam` VALUES ('83', '1', '1', 'Ceyhan'); 
  INSERT INTO `av_kapsam` VALUES ('84', '1', '1', 'Çukurova'); 
  INSERT INTO `av_kapsam` VALUES ('85', '1', '1', 'Feke'); 
  INSERT INTO `av_kapsam` VALUES ('86', '1', '1', 'İmamoğlu'); 
  INSERT INTO `av_kapsam` VALUES ('87', '1', '1', 'Karaisalı'); 
  INSERT INTO `av_kapsam` VALUES ('88', '1', '1', 'Karataş'); 
  INSERT INTO `av_kapsam` VALUES ('89', '1', '1', 'Kozan'); 
  INSERT INTO `av_kapsam` VALUES ('90', '1', '1', 'Pozantı'); 
  INSERT INTO `av_kapsam` VALUES ('91', '1', '1', 'Saimbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('92', '1', '1', 'Sarıçam'); 
  INSERT INTO `av_kapsam` VALUES ('93', '1', '1', 'Seyhan'); 
  INSERT INTO `av_kapsam` VALUES ('94', '1', '1', 'Tufanbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('95', '1', '1', 'Yumurtalık'); 
  INSERT INTO `av_kapsam` VALUES ('96', '1', '1', 'Yüreğir'); 
  INSERT INTO `av_kapsam` VALUES ('97', '1', '2', 'AdıyamanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('98', '1', '2', 'Besni'); 
  INSERT INTO `av_kapsam` VALUES ('99', '1', '2', 'Çelikhan'); 
  INSERT INTO `av_kapsam` VALUES ('100', '1', '2', 'Gerger'); 
  INSERT INTO `av_kapsam` VALUES ('101', '1', '2', 'Gölbaşı/Adıyaman'); 
  INSERT INTO `av_kapsam` VALUES ('102', '1', '2', 'Kahta'); 
  INSERT INTO `av_kapsam` VALUES ('103', '1', '2', 'Samsat'); 
  INSERT INTO `av_kapsam` VALUES ('104', '1', '2', 'Sincik'); 
  INSERT INTO `av_kapsam` VALUES ('105', '1', '2', 'Tut'); 
  INSERT INTO `av_kapsam` VALUES ('106', '1', '3', 'AfyonkarahisarMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('107', '1', '3', 'Başmakçı'); 
  INSERT INTO `av_kapsam` VALUES ('108', '1', '3', 'Bayat/Afyonkarahisar'); 
  INSERT INTO `av_kapsam` VALUES ('109', '1', '3', 'Bolvadin'); 
  INSERT INTO `av_kapsam` VALUES ('110', '1', '3', 'Çay'); 
  INSERT INTO `av_kapsam` VALUES ('111', '1', '3', 'Çobanlar'); 
  INSERT INTO `av_kapsam` VALUES ('112', '1', '3', 'Dazkırı'); 
  INSERT INTO `av_kapsam` VALUES ('113', '1', '3', 'Dinar'); 
  INSERT INTO `av_kapsam` VALUES ('114', '1', '3', 'Emirdağ'); 
  INSERT INTO `av_kapsam` VALUES ('115', '1', '3', 'Evciler'); 
  INSERT INTO `av_kapsam` VALUES ('116', '1', '3', 'Hocalar'); 
  INSERT INTO `av_kapsam` VALUES ('117', '1', '3', 'İhsaniye'); 
  INSERT INTO `av_kapsam` VALUES ('118', '1', '3', 'İscehisar'); 
  INSERT INTO `av_kapsam` VALUES ('119', '1', '3', 'Kızılören'); 
  INSERT INTO `av_kapsam` VALUES ('120', '1', '3', 'Sandıklı'); 
  INSERT INTO `av_kapsam` VALUES ('121', '1', '3', 'Sinanpaşa'); 
  INSERT INTO `av_kapsam` VALUES ('122', '1', '3', 'Sultandağı'); 
  INSERT INTO `av_kapsam` VALUES ('123', '1', '3', 'Şuhut'); 
  INSERT INTO `av_kapsam` VALUES ('124', '1', '4', 'AğrıMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('125', '1', '4', 'Diyadin'); 
  INSERT INTO `av_kapsam` VALUES ('126', '1', '4', 'Doğubayazıt'); 
  INSERT INTO `av_kapsam` VALUES ('127', '1', '4', 'Eleşkirt'); 
  INSERT INTO `av_kapsam` VALUES ('128', '1', '4', 'Hamur'); 
  INSERT INTO `av_kapsam` VALUES ('129', '1', '4', 'Patnos'); 
  INSERT INTO `av_kapsam` VALUES ('130', '1', '4', 'Taşlıçay'); 
  INSERT INTO `av_kapsam` VALUES ('131', '1', '4', 'Tutak'); 
  INSERT INTO `av_kapsam` VALUES ('132', '1', '5', 'AmasyaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('133', '1', '5', 'Göynücek'); 
  INSERT INTO `av_kapsam` VALUES ('134', '1', '5', 'Gümüşhacıköy'); 
  INSERT INTO `av_kapsam` VALUES ('135', '1', '5', 'Hamamözü'); 
  INSERT INTO `av_kapsam` VALUES ('136', '1', '5', 'Merzifon'); 
  INSERT INTO `av_kapsam` VALUES ('137', '1', '5', 'Suluova'); 
  INSERT INTO `av_kapsam` VALUES ('138', '1', '5', 'Taşova'); 
  INSERT INTO `av_kapsam` VALUES ('139', '1', '6', 'Akyurt'); 
  INSERT INTO `av_kapsam` VALUES ('140', '1', '6', 'Altındağ'); 
  INSERT INTO `av_kapsam` VALUES ('141', '1', '6', 'Ayaş'); 
  INSERT INTO `av_kapsam` VALUES ('142', '1', '6', 'Bala'); 
  INSERT INTO `av_kapsam` VALUES ('143', '1', '6', 'Beypazarı'); 
  INSERT INTO `av_kapsam` VALUES ('144', '1', '6', 'Çamlıdere'); 
  INSERT INTO `av_kapsam` VALUES ('145', '1', '6', 'Çankaya'); 
  INSERT INTO `av_kapsam` VALUES ('146', '1', '6', 'Çubuk'); 
  INSERT INTO `av_kapsam` VALUES ('147', '1', '6', 'Elmadağ'); 
  INSERT INTO `av_kapsam` VALUES ('148', '1', '6', 'Etimesgut'); 
  INSERT INTO `av_kapsam` VALUES ('149', '1', '6', 'Evren'); 
  INSERT INTO `av_kapsam` VALUES ('150', '1', '6', 'Gölbaşı/Ankara'); 
  INSERT INTO `av_kapsam` VALUES ('151', '1', '6', 'Güdül'); 
  INSERT INTO `av_kapsam` VALUES ('152', '1', '6', 'Haymana'); 
  INSERT INTO `av_kapsam` VALUES ('153', '1', '6', 'Kalecik'); 
  INSERT INTO `av_kapsam` VALUES ('154', '1', '6', 'Kazan'); 
  INSERT INTO `av_kapsam` VALUES ('155', '1', '6', 'Keçiören'); 
  INSERT INTO `av_kapsam` VALUES ('156', '1', '6', 'Kızılcahamam'); 
  INSERT INTO `av_kapsam` VALUES ('157', '1', '6', 'Mamak'); 
  INSERT INTO `av_kapsam` VALUES ('158', '1', '6', 'Nallıhan'); 
  INSERT INTO `av_kapsam` VALUES ('159', '1', '6', 'Polatlı'); 
  INSERT INTO `av_kapsam` VALUES ('160', '1', '6', 'Pursaklar'); 
  INSERT INTO `av_kapsam` VALUES ('161', '1', '6', 'Sincan'); 
  INSERT INTO `av_kapsam` VALUES ('162', '1', '6', 'Şereflikoçhisar'); 
  INSERT INTO `av_kapsam` VALUES ('163', '1', '6', 'Yenimahalle'); 
  INSERT INTO `av_kapsam` VALUES ('164', '1', '7', 'Akseki'); 
  INSERT INTO `av_kapsam` VALUES ('165', '1', '7', 'Aksu/Antalya'); 
  INSERT INTO `av_kapsam` VALUES ('166', '1', '7', 'Alanya'); 
  INSERT INTO `av_kapsam` VALUES ('167', '1', '7', 'Demre'); 
  INSERT INTO `av_kapsam` VALUES ('168', '1', '7', 'Döşemealtı'); 
  INSERT INTO `av_kapsam` VALUES ('169', '1', '7', 'Elmalı'); 
  INSERT INTO `av_kapsam` VALUES ('170', '1', '7', 'Finike'); 
  INSERT INTO `av_kapsam` VALUES ('171', '1', '7', 'Gazipaşa'); 
  INSERT INTO `av_kapsam` VALUES ('172', '1', '7', 'Gündoğmuş'); 
  INSERT INTO `av_kapsam` VALUES ('173', '1', '7', 'İbradı'); 
  INSERT INTO `av_kapsam` VALUES ('174', '1', '7', 'Kaş'); 
  INSERT INTO `av_kapsam` VALUES ('175', '1', '7', 'Kemer/Antalya'); 
  INSERT INTO `av_kapsam` VALUES ('176', '1', '7', 'Kepez'); 
  INSERT INTO `av_kapsam` VALUES ('177', '1', '7', 'Konyaaltı'); 
  INSERT INTO `av_kapsam` VALUES ('178', '1', '7', 'Korkuteli'); 
  INSERT INTO `av_kapsam` VALUES ('179', '1', '7', 'Kumluca'); 
  INSERT INTO `av_kapsam` VALUES ('180', '1', '7', 'Manavgat'); 
  INSERT INTO `av_kapsam` VALUES ('181', '1', '7', 'Muratpaşa'); 
  INSERT INTO `av_kapsam` VALUES ('182', '1', '7', 'Serik'); 
  INSERT INTO `av_kapsam` VALUES ('183', '1', '8', 'Ardanuç'); 
  INSERT INTO `av_kapsam` VALUES ('184', '1', '8', 'Arhavi'); 
  INSERT INTO `av_kapsam` VALUES ('185', '1', '8', 'ArtvinMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('186', '1', '8', 'Borçka'); 
  INSERT INTO `av_kapsam` VALUES ('187', '1', '8', 'Hopa'); 
  INSERT INTO `av_kapsam` VALUES ('188', '1', '8', 'Murgul'); 
  INSERT INTO `av_kapsam` VALUES ('189', '1', '8', 'Şavşat'); 
  INSERT INTO `av_kapsam` VALUES ('190', '1', '8', 'Yusufeli'); 
  INSERT INTO `av_kapsam` VALUES ('191', '1', '9', 'AydınMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('192', '1', '9', 'Bozdoğan'); 
  INSERT INTO `av_kapsam` VALUES ('193', '1', '9', 'Buharkent'); 
  INSERT INTO `av_kapsam` VALUES ('194', '1', '9', 'Çine'); 
  INSERT INTO `av_kapsam` VALUES ('195', '1', '9', 'Didim'); 
  INSERT INTO `av_kapsam` VALUES ('196', '1', '9', 'Germencik'); 
  INSERT INTO `av_kapsam` VALUES ('197', '1', '9', 'İncirliova'); 
  INSERT INTO `av_kapsam` VALUES ('198', '1', '9', 'Karacasu'); 
  INSERT INTO `av_kapsam` VALUES ('199', '1', '9', 'Karpuzlu'); 
  INSERT INTO `av_kapsam` VALUES ('200', '1', '9', 'Koçarlı'); 
  INSERT INTO `av_kapsam` VALUES ('201', '1', '9', 'Köşk'); 
  INSERT INTO `av_kapsam` VALUES ('202', '1', '9', 'Kuşadası'); 
  INSERT INTO `av_kapsam` VALUES ('203', '1', '9', 'Kuyucak'); 
  INSERT INTO `av_kapsam` VALUES ('204', '1', '9', 'Nazilli'); 
  INSERT INTO `av_kapsam` VALUES ('205', '1', '9', 'Söke'); 
  INSERT INTO `av_kapsam` VALUES ('206', '1', '9', 'Sultanhisar'); 
  INSERT INTO `av_kapsam` VALUES ('207', '1', '9', 'Yenipazar/Aydın'); 
  INSERT INTO `av_kapsam` VALUES ('208', '1', '10', 'Ayvalık'); 
  INSERT INTO `av_kapsam` VALUES ('209', '1', '10', 'BalıkesirMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('210', '1', '10', 'Balya'); 
  INSERT INTO `av_kapsam` VALUES ('211', '1', '10', 'Bandırma'); 
  INSERT INTO `av_kapsam` VALUES ('212', '1', '10', 'Bigadiç'); 
  INSERT INTO `av_kapsam` VALUES ('213', '1', '10', 'Burhaniye'); 
  INSERT INTO `av_kapsam` VALUES ('214', '1', '10', 'Dursunbey'); 
  INSERT INTO `av_kapsam` VALUES ('215', '1', '10', 'Edremit/Balıkesir'); 
  INSERT INTO `av_kapsam` VALUES ('216', '1', '10', 'Erdek'); 
  INSERT INTO `av_kapsam` VALUES ('217', '1', '10', 'Gömeç'); 
  INSERT INTO `av_kapsam` VALUES ('218', '1', '10', 'Gönen/Balıkesir'); 
  INSERT INTO `av_kapsam` VALUES ('219', '1', '10', 'Havran'); 
  INSERT INTO `av_kapsam` VALUES ('220', '1', '10', 'İvrindi'); 
  INSERT INTO `av_kapsam` VALUES ('221', '1', '10', 'Kepsut'); 
  INSERT INTO `av_kapsam` VALUES ('222', '1', '10', 'Manyas'); 
  INSERT INTO `av_kapsam` VALUES ('223', '1', '10', 'Marmara'); 
  INSERT INTO `av_kapsam` VALUES ('224', '1', '10', 'Savaştepe'); 
  INSERT INTO `av_kapsam` VALUES ('225', '1', '10', 'Sındırgı'); 
  INSERT INTO `av_kapsam` VALUES ('226', '1', '10', 'Susurluk'); 
  INSERT INTO `av_kapsam` VALUES ('227', '1', '11', 'BilecikMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('228', '1', '11', 'Bozüyük'); 
  INSERT INTO `av_kapsam` VALUES ('229', '1', '11', 'Gölpazarı'); 
  INSERT INTO `av_kapsam` VALUES ('230', '1', '11', 'İnhisar'); 
  INSERT INTO `av_kapsam` VALUES ('231', '1', '11', 'Osmaneli'); 
  INSERT INTO `av_kapsam` VALUES ('232', '1', '11', 'Pazaryeri'); 
  INSERT INTO `av_kapsam` VALUES ('233', '1', '11', 'Söğüt'); 
  INSERT INTO `av_kapsam` VALUES ('234', '1', '11', 'Yenipazar/Bilecik'); 
  INSERT INTO `av_kapsam` VALUES ('235', '1', '12', 'Adaklı'); 
  INSERT INTO `av_kapsam` VALUES ('236', '1', '12', 'BingölMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('237', '1', '12', 'Genç'); 
  INSERT INTO `av_kapsam` VALUES ('238', '1', '12', 'Karlıova'); 
  INSERT INTO `av_kapsam` VALUES ('239', '1', '12', 'Kiğı'); 
  INSERT INTO `av_kapsam` VALUES ('240', '1', '12', 'Solhan'); 
  INSERT INTO `av_kapsam` VALUES ('241', '1', '12', 'Yayladere'); 
  INSERT INTO `av_kapsam` VALUES ('242', '1', '12', 'Yedisu'); 
  INSERT INTO `av_kapsam` VALUES ('243', '1', '13', 'Adilcevaz'); 
  INSERT INTO `av_kapsam` VALUES ('244', '1', '13', 'Ahlat'); 
  INSERT INTO `av_kapsam` VALUES ('245', '1', '13', 'BitlisMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('246', '1', '13', 'Güroymak'); 
  INSERT INTO `av_kapsam` VALUES ('247', '1', '13', 'Hizan'); 
  INSERT INTO `av_kapsam` VALUES ('248', '1', '13', 'Mutki'); 
  INSERT INTO `av_kapsam` VALUES ('249', '1', '13', 'Tatvan'); 
  INSERT INTO `av_kapsam` VALUES ('250', '1', '14', 'BoluMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('251', '1', '14', 'Dörtdivan'); 
  INSERT INTO `av_kapsam` VALUES ('252', '1', '14', 'Gerede'); 
  INSERT INTO `av_kapsam` VALUES ('253', '1', '14', 'Göynük'); 
  INSERT INTO `av_kapsam` VALUES ('254', '1', '14', 'Kıbrıscık'); 
  INSERT INTO `av_kapsam` VALUES ('255', '1', '14', 'Mengen'); 
  INSERT INTO `av_kapsam` VALUES ('256', '1', '14', 'Mudurnu'); 
  INSERT INTO `av_kapsam` VALUES ('257', '1', '14', 'Seben'); 
  INSERT INTO `av_kapsam` VALUES ('258', '1', '14', 'Yeniçağa'); 
  INSERT INTO `av_kapsam` VALUES ('259', '1', '15', 'Ağlasun'); 
  INSERT INTO `av_kapsam` VALUES ('260', '1', '15', 'Altınyayla/Burdur'); 
  INSERT INTO `av_kapsam` VALUES ('261', '1', '15', 'Bucak'); 
  INSERT INTO `av_kapsam` VALUES ('262', '1', '15', 'BurdurMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('263', '1', '15', 'Çavdır'); 
  INSERT INTO `av_kapsam` VALUES ('264', '1', '15', 'Çeltikçi'); 
  INSERT INTO `av_kapsam` VALUES ('265', '1', '15', 'Gölhisar'); 
  INSERT INTO `av_kapsam` VALUES ('266', '1', '15', 'Karamanlı'); 
  INSERT INTO `av_kapsam` VALUES ('267', '1', '15', 'Kemer/Burdur'); 
  INSERT INTO `av_kapsam` VALUES ('268', '1', '15', 'Tefenni'); 
  INSERT INTO `av_kapsam` VALUES ('269', '1', '15', 'Yeşilova'); 
  INSERT INTO `av_kapsam` VALUES ('270', '1', '16', 'Büyükorhan'); 
  INSERT INTO `av_kapsam` VALUES ('271', '1', '16', 'Gemlik'); 
  INSERT INTO `av_kapsam` VALUES ('272', '1', '16', 'Gürsu'); 
  INSERT INTO `av_kapsam` VALUES ('273', '1', '16', 'Harmancık'); 
  INSERT INTO `av_kapsam` VALUES ('274', '1', '16', 'İnegöl'); 
  INSERT INTO `av_kapsam` VALUES ('275', '1', '16', 'İznik'); 
  INSERT INTO `av_kapsam` VALUES ('276', '1', '16', 'Karacabey'); 
  INSERT INTO `av_kapsam` VALUES ('277', '1', '16', 'Keles'); 
  INSERT INTO `av_kapsam` VALUES ('278', '1', '16', 'Kestel'); 
  INSERT INTO `av_kapsam` VALUES ('279', '1', '16', 'Mudanya'); 
  INSERT INTO `av_kapsam` VALUES ('280', '1', '16', 'Mustafakemalpaşa'); 
  INSERT INTO `av_kapsam` VALUES ('281', '1', '16', 'Nilüfer'); 
  INSERT INTO `av_kapsam` VALUES ('282', '1', '16', 'Orhaneli'); 
  INSERT INTO `av_kapsam` VALUES ('283', '1', '16', 'Orhangazi'); 
  INSERT INTO `av_kapsam` VALUES ('284', '1', '16', 'Osmangazi'); 
  INSERT INTO `av_kapsam` VALUES ('285', '1', '16', 'Yenişehir/Bursa'); 
  INSERT INTO `av_kapsam` VALUES ('286', '1', '16', 'Yıldırım'); 
  INSERT INTO `av_kapsam` VALUES ('287', '1', '17', 'Ayvacık/Çanakkale'); 
  INSERT INTO `av_kapsam` VALUES ('288', '1', '17', 'Bayramiç'); 
  INSERT INTO `av_kapsam` VALUES ('289', '1', '17', 'Biga'); 
  INSERT INTO `av_kapsam` VALUES ('290', '1', '17', 'Bozcaada'); 
  INSERT INTO `av_kapsam` VALUES ('291', '1', '17', 'Çan'); 
  INSERT INTO `av_kapsam` VALUES ('292', '1', '17', 'ÇanakkaleMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('293', '1', '17', 'Eceabat'); 
  INSERT INTO `av_kapsam` VALUES ('294', '1', '17', 'Ezine'); 
  INSERT INTO `av_kapsam` VALUES ('295', '1', '17', 'Gelibolu'); 
  INSERT INTO `av_kapsam` VALUES ('296', '1', '17', 'Gökçeada'); 
  INSERT INTO `av_kapsam` VALUES ('297', '1', '17', 'Lapseki'); 
  INSERT INTO `av_kapsam` VALUES ('298', '1', '17', 'Yenice/Çanakkale'); 
  INSERT INTO `av_kapsam` VALUES ('299', '1', '18', 'Atkaracalar'); 
  INSERT INTO `av_kapsam` VALUES ('300', '1', '18', 'Bayramören'); 
  INSERT INTO `av_kapsam` VALUES ('301', '1', '18', 'ÇankırıMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('302', '1', '18', 'Çerkeş'); 
  INSERT INTO `av_kapsam` VALUES ('303', '1', '18', 'Eldivan'); 
  INSERT INTO `av_kapsam` VALUES ('304', '1', '18', 'Ilgaz'); 
  INSERT INTO `av_kapsam` VALUES ('305', '1', '18', 'Kızılırmak'); 
  INSERT INTO `av_kapsam` VALUES ('306', '1', '18', 'Korgun'); 
  INSERT INTO `av_kapsam` VALUES ('307', '1', '18', 'Kurşunlu'); 
  INSERT INTO `av_kapsam` VALUES ('308', '1', '18', 'Orta'); 
  INSERT INTO `av_kapsam` VALUES ('309', '1', '18', 'Şabanözü'); 
  INSERT INTO `av_kapsam` VALUES ('310', '1', '18', 'Yapraklı'); 
  INSERT INTO `av_kapsam` VALUES ('311', '1', '19', 'Alaca'); 
  INSERT INTO `av_kapsam` VALUES ('312', '1', '19', 'Bayat/Çorum'); 
  INSERT INTO `av_kapsam` VALUES ('313', '1', '19', 'Boğazkale'); 
  INSERT INTO `av_kapsam` VALUES ('314', '1', '19', 'ÇorumMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('315', '1', '19', 'Dodurga'); 
  INSERT INTO `av_kapsam` VALUES ('316', '1', '19', 'İskilip'); 
  INSERT INTO `av_kapsam` VALUES ('317', '1', '19', 'Kargı'); 
  INSERT INTO `av_kapsam` VALUES ('318', '1', '19', 'Laçin'); 
  INSERT INTO `av_kapsam` VALUES ('319', '1', '19', 'Mecitözü'); 
  INSERT INTO `av_kapsam` VALUES ('320', '1', '19', 'Oğuzlar'); 
  INSERT INTO `av_kapsam` VALUES ('321', '1', '19', 'Ortaköy/Çorum'); 
  INSERT INTO `av_kapsam` VALUES ('322', '1', '19', 'Osmancık'); 
  INSERT INTO `av_kapsam` VALUES ('323', '1', '19', 'Sungurlu'); 
  INSERT INTO `av_kapsam` VALUES ('324', '1', '19', 'Uğurludağ'); 
  INSERT INTO `av_kapsam` VALUES ('325', '1', '20', 'Acıpayam'); 
  INSERT INTO `av_kapsam` VALUES ('326', '1', '20', 'Akköy'); 
  INSERT INTO `av_kapsam` VALUES ('327', '1', '20', 'Babadağ'); 
  INSERT INTO `av_kapsam` VALUES ('328', '1', '20', 'Baklan'); 
  INSERT INTO `av_kapsam` VALUES ('329', '1', '20', 'Bekilli'); 
  INSERT INTO `av_kapsam` VALUES ('330', '1', '20', 'Beyağaç'); 
  INSERT INTO `av_kapsam` VALUES ('331', '1', '20', 'Bozkurt/Denizli'); 
  INSERT INTO `av_kapsam` VALUES ('332', '1', '20', 'Buldan'); 
  INSERT INTO `av_kapsam` VALUES ('333', '1', '20', 'Çal'); 
  INSERT INTO `av_kapsam` VALUES ('334', '1', '20', 'Çameli'); 
  INSERT INTO `av_kapsam` VALUES ('335', '1', '20', 'Çardak'); 
  INSERT INTO `av_kapsam` VALUES ('336', '1', '20', 'Çivril'); 
  INSERT INTO `av_kapsam` VALUES ('337', '1', '20', 'DenizliMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('338', '1', '20', 'Güney'); 
  INSERT INTO `av_kapsam` VALUES ('339', '1', '20', 'Honaz'); 
  INSERT INTO `av_kapsam` VALUES ('340', '1', '20', 'Kale/Denizli'); 
  INSERT INTO `av_kapsam` VALUES ('341', '1', '20', 'Sarayköy'); 
  INSERT INTO `av_kapsam` VALUES ('342', '1', '20', 'Serinhisar'); 
  INSERT INTO `av_kapsam` VALUES ('343', '1', '20', 'Tavas'); 
  INSERT INTO `av_kapsam` VALUES ('344', '1', '21', 'Bağlar'); 
  INSERT INTO `av_kapsam` VALUES ('345', '1', '21', 'Bismil'); 
  INSERT INTO `av_kapsam` VALUES ('346', '1', '21', 'Çermik'); 
  INSERT INTO `av_kapsam` VALUES ('347', '1', '21', 'Çınar'); 
  INSERT INTO `av_kapsam` VALUES ('348', '1', '21', 'Çüngüş'); 
  INSERT INTO `av_kapsam` VALUES ('349', '1', '21', 'Dicle'); 
  INSERT INTO `av_kapsam` VALUES ('350', '1', '21', 'Eğil'); 
  INSERT INTO `av_kapsam` VALUES ('351', '1', '21', 'Ergani'); 
  INSERT INTO `av_kapsam` VALUES ('352', '1', '21', 'Hani'); 
  INSERT INTO `av_kapsam` VALUES ('353', '1', '21', 'Hazro'); 
  INSERT INTO `av_kapsam` VALUES ('354', '1', '21', 'Kayapınar'); 
  INSERT INTO `av_kapsam` VALUES ('355', '1', '21', 'Kocaköy'); 
  INSERT INTO `av_kapsam` VALUES ('356', '1', '21', 'Kulp'); 
  INSERT INTO `av_kapsam` VALUES ('357', '1', '21', 'Lice'); 
  INSERT INTO `av_kapsam` VALUES ('358', '1', '21', 'Silvan'); 
  INSERT INTO `av_kapsam` VALUES ('359', '1', '21', 'Sur'); 
  INSERT INTO `av_kapsam` VALUES ('360', '1', '21', 'Yenişehir/Diyarbakır'); 
  INSERT INTO `av_kapsam` VALUES ('361', '1', '22', 'EdirneMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('362', '1', '22', 'Enez'); 
  INSERT INTO `av_kapsam` VALUES ('363', '1', '22', 'Havsa'); 
  INSERT INTO `av_kapsam` VALUES ('364', '1', '22', 'İpsala'); 
  INSERT INTO `av_kapsam` VALUES ('365', '1', '22', 'Keşan'); 
  INSERT INTO `av_kapsam` VALUES ('366', '1', '22', 'Lalapaşa'); 
  INSERT INTO `av_kapsam` VALUES ('367', '1', '22', 'Meriç'); 
  INSERT INTO `av_kapsam` VALUES ('368', '1', '22', 'Süloğlu'); 
  INSERT INTO `av_kapsam` VALUES ('369', '1', '22', 'Uzunköprü'); 
  INSERT INTO `av_kapsam` VALUES ('370', '1', '23', 'Ağın'); 
  INSERT INTO `av_kapsam` VALUES ('371', '1', '23', 'Alacakaya'); 
  INSERT INTO `av_kapsam` VALUES ('372', '1', '23', 'Arıcak'); 
  INSERT INTO `av_kapsam` VALUES ('373', '1', '23', 'Baskil'); 
  INSERT INTO `av_kapsam` VALUES ('374', '1', '23', 'ElazığMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('375', '1', '23', 'Karakoçan'); 
  INSERT INTO `av_kapsam` VALUES ('376', '1', '23', 'Keban'); 
  INSERT INTO `av_kapsam` VALUES ('377', '1', '23', 'Kovancılar'); 
  INSERT INTO `av_kapsam` VALUES ('378', '1', '23', 'Maden'); 
  INSERT INTO `av_kapsam` VALUES ('379', '1', '23', 'Palu'); 
  INSERT INTO `av_kapsam` VALUES ('380', '1', '23', 'Sivrice'); 
  INSERT INTO `av_kapsam` VALUES ('381', '1', '24', 'Çayırlı'); 
  INSERT INTO `av_kapsam` VALUES ('382', '1', '24', 'ErzincanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('383', '1', '24', 'İliç'); 
  INSERT INTO `av_kapsam` VALUES ('384', '1', '24', 'Kemah'); 
  INSERT INTO `av_kapsam` VALUES ('385', '1', '24', 'Kemaliye'); 
  INSERT INTO `av_kapsam` VALUES ('386', '1', '24', 'Otlukbeli'); 
  INSERT INTO `av_kapsam` VALUES ('387', '1', '24', 'Refahiye'); 
  INSERT INTO `av_kapsam` VALUES ('388', '1', '24', 'Tercan'); 
  INSERT INTO `av_kapsam` VALUES ('389', '1', '24', 'Üzümlü'); 
  INSERT INTO `av_kapsam` VALUES ('390', '1', '25', 'Aşkale'); 
  INSERT INTO `av_kapsam` VALUES ('391', '1', '25', 'Aziziye'); 
  INSERT INTO `av_kapsam` VALUES ('392', '1', '25', 'Çat'); 
  INSERT INTO `av_kapsam` VALUES ('393', '1', '25', 'Hınıs'); 
  INSERT INTO `av_kapsam` VALUES ('394', '1', '25', 'Horasan'); 
  INSERT INTO `av_kapsam` VALUES ('395', '1', '25', 'İspir'); 
  INSERT INTO `av_kapsam` VALUES ('396', '1', '25', 'Karaçoban'); 
  INSERT INTO `av_kapsam` VALUES ('397', '1', '25', 'Karayazı'); 
  INSERT INTO `av_kapsam` VALUES ('398', '1', '25', 'Köprüköy'); 
  INSERT INTO `av_kapsam` VALUES ('399', '1', '25', 'Narman'); 
  INSERT INTO `av_kapsam` VALUES ('400', '1', '25', 'Oltu'); 
  INSERT INTO `av_kapsam` VALUES ('401', '1', '25', 'Olur'); 
  INSERT INTO `av_kapsam` VALUES ('402', '1', '25', 'Palandöken'); 
  INSERT INTO `av_kapsam` VALUES ('403', '1', '25', 'Pasinler'); 
  INSERT INTO `av_kapsam` VALUES ('404', '1', '25', 'Pazaryolu'); 
  INSERT INTO `av_kapsam` VALUES ('405', '1', '25', 'Şenkaya'); 
  INSERT INTO `av_kapsam` VALUES ('406', '1', '25', 'Tekman'); 
  INSERT INTO `av_kapsam` VALUES ('407', '1', '25', 'Tortum'); 
  INSERT INTO `av_kapsam` VALUES ('408', '1', '25', 'Uzundere'); 
  INSERT INTO `av_kapsam` VALUES ('409', '1', '25', 'Yakutiye'); 
  INSERT INTO `av_kapsam` VALUES ('410', '1', '26', 'Alpu'); 
  INSERT INTO `av_kapsam` VALUES ('411', '1', '26', 'Beylikova'); 
  INSERT INTO `av_kapsam` VALUES ('412', '1', '26', 'Çifteler'); 
  INSERT INTO `av_kapsam` VALUES ('413', '1', '26', 'Günyüzü'); 
  INSERT INTO `av_kapsam` VALUES ('414', '1', '26', 'Han'); 
  INSERT INTO `av_kapsam` VALUES ('415', '1', '26', 'İnönü'); 
  INSERT INTO `av_kapsam` VALUES ('416', '1', '26', 'Mahmudiye'); 
  INSERT INTO `av_kapsam` VALUES ('417', '1', '26', 'Mihalgazi'); 
  INSERT INTO `av_kapsam` VALUES ('418', '1', '26', 'Mihalıççık'); 
  INSERT INTO `av_kapsam` VALUES ('419', '1', '26', 'Odunpazarı'); 
  INSERT INTO `av_kapsam` VALUES ('420', '1', '26', 'Sarıcakaya'); 
  INSERT INTO `av_kapsam` VALUES ('421', '1', '26', 'Seyitgazi'); 
  INSERT INTO `av_kapsam` VALUES ('422', '1', '26', 'Sivrihisar'); 
  INSERT INTO `av_kapsam` VALUES ('423', '1', '26', 'Tepebaşı'); 
  INSERT INTO `av_kapsam` VALUES ('424', '1', '27', 'Araban'); 
  INSERT INTO `av_kapsam` VALUES ('425', '1', '27', 'İslahiye'); 
  INSERT INTO `av_kapsam` VALUES ('426', '1', '27', 'Karkamış'); 
  INSERT INTO `av_kapsam` VALUES ('427', '1', '27', 'Nizip'); 
  INSERT INTO `av_kapsam` VALUES ('428', '1', '27', 'Nurdağı'); 
  INSERT INTO `av_kapsam` VALUES ('429', '1', '27', 'Oğuzeli'); 
  INSERT INTO `av_kapsam` VALUES ('430', '1', '27', 'Şahinbey'); 
  INSERT INTO `av_kapsam` VALUES ('431', '1', '27', 'Şehitkamil'); 
  INSERT INTO `av_kapsam` VALUES ('432', '1', '27', 'Yavuzeli'); 
  INSERT INTO `av_kapsam` VALUES ('433', '1', '28', 'Alucra'); 
  INSERT INTO `av_kapsam` VALUES ('434', '1', '28', 'Bulancak'); 
  INSERT INTO `av_kapsam` VALUES ('435', '1', '28', 'Çamoluk'); 
  INSERT INTO `av_kapsam` VALUES ('436', '1', '28', 'Çanakçı'); 
  INSERT INTO `av_kapsam` VALUES ('437', '1', '28', 'Dereli'); 
  INSERT INTO `av_kapsam` VALUES ('438', '1', '28', 'Doğankent'); 
  INSERT INTO `av_kapsam` VALUES ('439', '1', '28', 'Espiye'); 
  INSERT INTO `av_kapsam` VALUES ('440', '1', '28', 'Eynesil'); 
  INSERT INTO `av_kapsam` VALUES ('441', '1', '28', 'GiresunMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('442', '1', '28', 'Görele'); 
  INSERT INTO `av_kapsam` VALUES ('443', '1', '28', 'Güce'); 
  INSERT INTO `av_kapsam` VALUES ('444', '1', '28', 'Keşap'); 
  INSERT INTO `av_kapsam` VALUES ('445', '1', '28', 'Piraziz'); 
  INSERT INTO `av_kapsam` VALUES ('446', '1', '28', 'Şebinkarahisar'); 
  INSERT INTO `av_kapsam` VALUES ('447', '1', '28', 'Tirebolu'); 
  INSERT INTO `av_kapsam` VALUES ('448', '1', '28', 'Yağlıdere'); 
  INSERT INTO `av_kapsam` VALUES ('449', '1', '29', 'GümüşhaneMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('450', '1', '29', 'Kelkit'); 
  INSERT INTO `av_kapsam` VALUES ('451', '1', '29', 'Köse'); 
  INSERT INTO `av_kapsam` VALUES ('452', '1', '29', 'Kürtün'); 
  INSERT INTO `av_kapsam` VALUES ('453', '1', '29', 'Şiran'); 
  INSERT INTO `av_kapsam` VALUES ('454', '1', '29', 'Torul'); 
  INSERT INTO `av_kapsam` VALUES ('455', '1', '30', 'Çukurca'); 
  INSERT INTO `av_kapsam` VALUES ('456', '1', '30', 'HakkariMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('457', '1', '30', 'Şemdinli'); 
  INSERT INTO `av_kapsam` VALUES ('458', '1', '30', 'Yüksekova'); 
  INSERT INTO `av_kapsam` VALUES ('459', '1', '31', 'Altınözü'); 
  INSERT INTO `av_kapsam` VALUES ('460', '1', '31', 'Belen'); 
  INSERT INTO `av_kapsam` VALUES ('461', '1', '31', 'Dörtyol'); 
  INSERT INTO `av_kapsam` VALUES ('462', '1', '31', 'Erzin'); 
  INSERT INTO `av_kapsam` VALUES ('463', '1', '31', 'Hassa'); 
  INSERT INTO `av_kapsam` VALUES ('464', '1', '31', 'HatayMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('465', '1', '31', 'İskenderun'); 
  INSERT INTO `av_kapsam` VALUES ('466', '1', '31', 'Kırıkhan'); 
  INSERT INTO `av_kapsam` VALUES ('467', '1', '31', 'Kumlu'); 
  INSERT INTO `av_kapsam` VALUES ('468', '1', '31', 'Reyhanlı'); 
  INSERT INTO `av_kapsam` VALUES ('469', '1', '31', 'Samandağ'); 
  INSERT INTO `av_kapsam` VALUES ('470', '1', '31', 'Yayladağı'); 
  INSERT INTO `av_kapsam` VALUES ('471', '1', '32', 'Aksu/Isparta'); 
  INSERT INTO `av_kapsam` VALUES ('472', '1', '32', 'Atabey'); 
  INSERT INTO `av_kapsam` VALUES ('473', '1', '32', 'Eğirdir'); 
  INSERT INTO `av_kapsam` VALUES ('474', '1', '32', 'Gelendost'); 
  INSERT INTO `av_kapsam` VALUES ('475', '1', '32', 'Gönen/Isparta'); 
  INSERT INTO `av_kapsam` VALUES ('476', '1', '32', 'IspartaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('477', '1', '32', 'Keçiborlu'); 
  INSERT INTO `av_kapsam` VALUES ('478', '1', '32', 'Senirkent'); 
  INSERT INTO `av_kapsam` VALUES ('479', '1', '32', 'Sütçüler'); 
  INSERT INTO `av_kapsam` VALUES ('480', '1', '32', 'Şarkikaraağaç'); 
  INSERT INTO `av_kapsam` VALUES ('481', '1', '32', 'Uluborlu'); 
  INSERT INTO `av_kapsam` VALUES ('482', '1', '32', 'Yalvaç'); 
  INSERT INTO `av_kapsam` VALUES ('483', '1', '32', 'Yenişarbademli'); 
  INSERT INTO `av_kapsam` VALUES ('484', '1', '33', 'Akdeniz'); 
  INSERT INTO `av_kapsam` VALUES ('485', '1', '33', 'Anamur'); 
  INSERT INTO `av_kapsam` VALUES ('486', '1', '33', 'Aydıncık/Mersin'); 
  INSERT INTO `av_kapsam` VALUES ('487', '1', '33', 'Bozyazı'); 
  INSERT INTO `av_kapsam` VALUES ('488', '1', '33', 'Çamlıyayla'); 
  INSERT INTO `av_kapsam` VALUES ('489', '1', '33', 'Erdemli'); 
  INSERT INTO `av_kapsam` VALUES ('490', '1', '33', 'Gülnar'); 
  INSERT INTO `av_kapsam` VALUES ('491', '1', '33', 'Mezitli'); 
  INSERT INTO `av_kapsam` VALUES ('492', '1', '33', 'Mut'); 
  INSERT INTO `av_kapsam` VALUES ('493', '1', '33', 'Silifke'); 
  INSERT INTO `av_kapsam` VALUES ('494', '1', '33', 'Tarsus'); 
  INSERT INTO `av_kapsam` VALUES ('495', '1', '33', 'Toroslar'); 
  INSERT INTO `av_kapsam` VALUES ('496', '1', '33', 'Yenişehir/Mersin'); 
  INSERT INTO `av_kapsam` VALUES ('497', '1', '34', 'Adalar'); 
  INSERT INTO `av_kapsam` VALUES ('498', '1', '34', 'Arnavutköy'); 
  INSERT INTO `av_kapsam` VALUES ('499', '1', '34', 'Ataşehir'); 
  INSERT INTO `av_kapsam` VALUES ('500', '1', '34', 'Avcılar'); 
  INSERT INTO `av_kapsam` VALUES ('501', '1', '34', 'Bağcılar'); 
  INSERT INTO `av_kapsam` VALUES ('502', '1', '34', 'Bahçelievler'); 
  INSERT INTO `av_kapsam` VALUES ('503', '1', '34', 'Bakırköy'); 
  INSERT INTO `av_kapsam` VALUES ('504', '1', '34', 'Başakşehir'); 
  INSERT INTO `av_kapsam` VALUES ('505', '1', '34', 'Bayrampaşa'); 
  INSERT INTO `av_kapsam` VALUES ('506', '1', '34', 'Beşiktaş'); 
  INSERT INTO `av_kapsam` VALUES ('507', '1', '34', 'Beykoz'); 
  INSERT INTO `av_kapsam` VALUES ('508', '1', '34', 'Beylikdüzü'); 
  INSERT INTO `av_kapsam` VALUES ('509', '1', '34', 'Beyoğlu'); 
  INSERT INTO `av_kapsam` VALUES ('510', '1', '34', 'Büyükçekmece'); 
  INSERT INTO `av_kapsam` VALUES ('511', '1', '34', 'Çatalca'); 
  INSERT INTO `av_kapsam` VALUES ('512', '1', '34', 'Çekmeköy'); 
  INSERT INTO `av_kapsam` VALUES ('513', '1', '34', 'Esenler'); 
  INSERT INTO `av_kapsam` VALUES ('514', '1', '34', 'Esenyurt'); 
  INSERT INTO `av_kapsam` VALUES ('515', '1', '34', 'Eyüp'); 
  INSERT INTO `av_kapsam` VALUES ('516', '1', '34', 'Fatih'); 
  INSERT INTO `av_kapsam` VALUES ('517', '1', '34', 'Gaziosmanpaşa'); 
  INSERT INTO `av_kapsam` VALUES ('518', '1', '34', 'Güngören'); 
  INSERT INTO `av_kapsam` VALUES ('519', '1', '34', 'Kadıköy'); 
  INSERT INTO `av_kapsam` VALUES ('520', '1', '34', 'Kağıthane'); 
  INSERT INTO `av_kapsam` VALUES ('521', '1', '34', 'Kartal'); 
  INSERT INTO `av_kapsam` VALUES ('522', '1', '34', 'Küçükçekmece'); 
  INSERT INTO `av_kapsam` VALUES ('523', '1', '34', 'Maltepe'); 
  INSERT INTO `av_kapsam` VALUES ('524', '1', '34', 'Pendik'); 
  INSERT INTO `av_kapsam` VALUES ('525', '1', '34', 'Sancaktepe'); 
  INSERT INTO `av_kapsam` VALUES ('526', '1', '34', 'Sarıyer'); 
  INSERT INTO `av_kapsam` VALUES ('527', '1', '34', 'Silivri'); 
  INSERT INTO `av_kapsam` VALUES ('528', '1', '34', 'Sultanbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('529', '1', '34', 'Sultangazi'); 
  INSERT INTO `av_kapsam` VALUES ('530', '1', '34', 'Şile'); 
  INSERT INTO `av_kapsam` VALUES ('531', '1', '34', 'Şişli'); 
  INSERT INTO `av_kapsam` VALUES ('532', '1', '34', 'Tuzla'); 
  INSERT INTO `av_kapsam` VALUES ('533', '1', '34', 'Ümraniye'); 
  INSERT INTO `av_kapsam` VALUES ('534', '1', '34', 'Üsküdar'); 
  INSERT INTO `av_kapsam` VALUES ('535', '1', '34', 'Zeytinburnu'); 
  INSERT INTO `av_kapsam` VALUES ('536', '1', '35', 'Aliağa'); 
  INSERT INTO `av_kapsam` VALUES ('537', '1', '35', 'Balçova'); 
  INSERT INTO `av_kapsam` VALUES ('538', '1', '35', 'Bayındır'); 
  INSERT INTO `av_kapsam` VALUES ('539', '1', '35', 'Bayraklı'); 
  INSERT INTO `av_kapsam` VALUES ('540', '1', '35', 'Bergama'); 
  INSERT INTO `av_kapsam` VALUES ('541', '1', '35', 'Beydağ'); 
  INSERT INTO `av_kapsam` VALUES ('542', '1', '35', 'Bornova'); 
  INSERT INTO `av_kapsam` VALUES ('543', '1', '35', 'Buca'); 
  INSERT INTO `av_kapsam` VALUES ('544', '1', '35', 'Çeşme'); 
  INSERT INTO `av_kapsam` VALUES ('545', '1', '35', 'Çiğli'); 
  INSERT INTO `av_kapsam` VALUES ('546', '1', '35', 'Dikili'); 
  INSERT INTO `av_kapsam` VALUES ('547', '1', '35', 'Foça'); 
  INSERT INTO `av_kapsam` VALUES ('548', '1', '35', 'Gaziemir'); 
  INSERT INTO `av_kapsam` VALUES ('549', '1', '35', 'Güzelbahçe'); 
  INSERT INTO `av_kapsam` VALUES ('550', '1', '35', 'Karabağlar'); 
  INSERT INTO `av_kapsam` VALUES ('551', '1', '35', 'Karaburun'); 
  INSERT INTO `av_kapsam` VALUES ('552', '1', '35', 'Karşıyaka'); 
  INSERT INTO `av_kapsam` VALUES ('553', '1', '35', 'Kemalpaşa'); 
  INSERT INTO `av_kapsam` VALUES ('554', '1', '35', 'Kınık'); 
  INSERT INTO `av_kapsam` VALUES ('555', '1', '35', 'Kiraz'); 
  INSERT INTO `av_kapsam` VALUES ('556', '1', '35', 'Konak'); 
  INSERT INTO `av_kapsam` VALUES ('557', '1', '35', 'Menderes'); 
  INSERT INTO `av_kapsam` VALUES ('558', '1', '35', 'Menemen'); 
  INSERT INTO `av_kapsam` VALUES ('559', '1', '35', 'Narlıdere'); 
  INSERT INTO `av_kapsam` VALUES ('560', '1', '35', 'Ödemiş'); 
  INSERT INTO `av_kapsam` VALUES ('561', '1', '35', 'Seferihisar'); 
  INSERT INTO `av_kapsam` VALUES ('562', '1', '35', 'Selçuk'); 
  INSERT INTO `av_kapsam` VALUES ('563', '1', '35', 'Tire'); 
  INSERT INTO `av_kapsam` VALUES ('564', '1', '35', 'Torbalı'); 
  INSERT INTO `av_kapsam` VALUES ('565', '1', '35', 'Urla'); 
  INSERT INTO `av_kapsam` VALUES ('566', '1', '36', 'Akyaka'); 
  INSERT INTO `av_kapsam` VALUES ('567', '1', '36', 'Arpaçay'); 
  INSERT INTO `av_kapsam` VALUES ('568', '1', '36', 'Digor'); 
  INSERT INTO `av_kapsam` VALUES ('569', '1', '36', 'Kağızman'); 
  INSERT INTO `av_kapsam` VALUES ('570', '1', '36', 'KarsMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('571', '1', '36', 'Sarıkamış'); 
  INSERT INTO `av_kapsam` VALUES ('572', '1', '36', 'Selim'); 
  INSERT INTO `av_kapsam` VALUES ('573', '1', '36', 'Susuz'); 
  INSERT INTO `av_kapsam` VALUES ('574', '1', '37', 'Abana'); 
  INSERT INTO `av_kapsam` VALUES ('575', '1', '37', 'Ağlı'); 
  INSERT INTO `av_kapsam` VALUES ('576', '1', '37', 'Araç'); 
  INSERT INTO `av_kapsam` VALUES ('577', '1', '37', 'Azdavay'); 
  INSERT INTO `av_kapsam` VALUES ('578', '1', '37', 'Bozkurt/Kastamonu'); 
  INSERT INTO `av_kapsam` VALUES ('579', '1', '37', 'Cide'); 
  INSERT INTO `av_kapsam` VALUES ('580', '1', '37', 'Çatalzeytin'); 
  INSERT INTO `av_kapsam` VALUES ('581', '1', '37', 'Daday'); 
  INSERT INTO `av_kapsam` VALUES ('582', '1', '37', 'Devrekani'); 
  INSERT INTO `av_kapsam` VALUES ('583', '1', '37', 'Doğanyurt'); 
  INSERT INTO `av_kapsam` VALUES ('584', '1', '37', 'Hanönü'); 
  INSERT INTO `av_kapsam` VALUES ('585', '1', '37', 'İhsangazi'); 
  INSERT INTO `av_kapsam` VALUES ('586', '1', '37', 'İnebolu'); 
  INSERT INTO `av_kapsam` VALUES ('587', '1', '37', 'KastamonuMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('588', '1', '37', 'Küre'); 
  INSERT INTO `av_kapsam` VALUES ('589', '1', '37', 'Pınarbaşı/Kastamonu'); 
  INSERT INTO `av_kapsam` VALUES ('590', '1', '37', 'Seydiler'); 
  INSERT INTO `av_kapsam` VALUES ('591', '1', '37', 'Şenpazar'); 
  INSERT INTO `av_kapsam` VALUES ('592', '1', '37', 'Taşköprü'); 
  INSERT INTO `av_kapsam` VALUES ('593', '1', '37', 'Tosya'); 
  INSERT INTO `av_kapsam` VALUES ('594', '1', '38', 'Akkışla'); 
  INSERT INTO `av_kapsam` VALUES ('595', '1', '38', 'Bünyan'); 
  INSERT INTO `av_kapsam` VALUES ('596', '1', '38', 'Develi'); 
  INSERT INTO `av_kapsam` VALUES ('597', '1', '38', 'Felahiye'); 
  INSERT INTO `av_kapsam` VALUES ('598', '1', '38', 'Hacılar'); 
  INSERT INTO `av_kapsam` VALUES ('599', '1', '38', 'İncesu'); 
  INSERT INTO `av_kapsam` VALUES ('600', '1', '38', 'Kocasinan'); 
  INSERT INTO `av_kapsam` VALUES ('601', '1', '38', 'Melikgazi'); 
  INSERT INTO `av_kapsam` VALUES ('602', '1', '38', 'Özvatan'); 
  INSERT INTO `av_kapsam` VALUES ('603', '1', '38', 'Pınarbaşı/Kayseri'); 
  INSERT INTO `av_kapsam` VALUES ('604', '1', '38', 'Sarıoğlan'); 
  INSERT INTO `av_kapsam` VALUES ('605', '1', '38', 'Sarız'); 
  INSERT INTO `av_kapsam` VALUES ('606', '1', '38', 'Talas'); 
  INSERT INTO `av_kapsam` VALUES ('607', '1', '38', 'Tomarza'); 
  INSERT INTO `av_kapsam` VALUES ('608', '1', '38', 'Yahyalı'); 
  INSERT INTO `av_kapsam` VALUES ('609', '1', '38', 'Yeşilhisar'); 
  INSERT INTO `av_kapsam` VALUES ('610', '1', '39', 'Babaeski'); 
  INSERT INTO `av_kapsam` VALUES ('611', '1', '39', 'Demirköy'); 
  INSERT INTO `av_kapsam` VALUES ('612', '1', '39', 'KırklareliMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('613', '1', '39', 'Kofçaz'); 
  INSERT INTO `av_kapsam` VALUES ('614', '1', '39', 'Lüleburgaz'); 
  INSERT INTO `av_kapsam` VALUES ('615', '1', '39', 'Pehlivanköy'); 
  INSERT INTO `av_kapsam` VALUES ('616', '1', '39', 'Pınarhisar'); 
  INSERT INTO `av_kapsam` VALUES ('617', '1', '39', 'Vize'); 
  INSERT INTO `av_kapsam` VALUES ('618', '1', '40', 'Akçakent'); 
  INSERT INTO `av_kapsam` VALUES ('619', '1', '40', 'Akpınar'); 
  INSERT INTO `av_kapsam` VALUES ('620', '1', '40', 'Boztepe'); 
  INSERT INTO `av_kapsam` VALUES ('621', '1', '40', 'Çiçekdağı'); 
  INSERT INTO `av_kapsam` VALUES ('622', '1', '40', 'Kaman'); 
  INSERT INTO `av_kapsam` VALUES ('623', '1', '40', 'KırşehirMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('624', '1', '40', 'Mucur'); 
  INSERT INTO `av_kapsam` VALUES ('625', '1', '41', 'Başiskele'); 
  INSERT INTO `av_kapsam` VALUES ('626', '1', '41', 'Çayırova'); 
  INSERT INTO `av_kapsam` VALUES ('627', '1', '41', 'Darıca'); 
  INSERT INTO `av_kapsam` VALUES ('628', '1', '41', 'Derince'); 
  INSERT INTO `av_kapsam` VALUES ('629', '1', '41', 'Dilovası'); 
  INSERT INTO `av_kapsam` VALUES ('630', '1', '41', 'Gebze'); 
  INSERT INTO `av_kapsam` VALUES ('631', '1', '41', 'Gölcük'); 
  INSERT INTO `av_kapsam` VALUES ('632', '1', '41', 'İzmit'); 
  INSERT INTO `av_kapsam` VALUES ('633', '1', '41', 'Kandıra'); 
  INSERT INTO `av_kapsam` VALUES ('634', '1', '41', 'Karamürsel'); 
  INSERT INTO `av_kapsam` VALUES ('635', '1', '41', 'Kartepe'); 
  INSERT INTO `av_kapsam` VALUES ('636', '1', '41', 'Körfez'); 
  INSERT INTO `av_kapsam` VALUES ('637', '1', '42', 'Ahırlı'); 
  INSERT INTO `av_kapsam` VALUES ('638', '1', '42', 'Akören'); 
  INSERT INTO `av_kapsam` VALUES ('639', '1', '42', 'Akşehir'); 
  INSERT INTO `av_kapsam` VALUES ('640', '1', '42', 'Altınekin'); 
  INSERT INTO `av_kapsam` VALUES ('641', '1', '42', 'Beyşehir'); 
  INSERT INTO `av_kapsam` VALUES ('642', '1', '42', 'Bozkır'); 
  INSERT INTO `av_kapsam` VALUES ('643', '1', '42', 'Cihanbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('644', '1', '42', 'Çeltik'); 
  INSERT INTO `av_kapsam` VALUES ('645', '1', '42', 'Çumra'); 
  INSERT INTO `av_kapsam` VALUES ('646', '1', '42', 'Derbent'); 
  INSERT INTO `av_kapsam` VALUES ('647', '1', '42', 'Derebucak'); 
  INSERT INTO `av_kapsam` VALUES ('648', '1', '42', 'Doğanhisar'); 
  INSERT INTO `av_kapsam` VALUES ('649', '1', '42', 'Emirgazi'); 
  INSERT INTO `av_kapsam` VALUES ('650', '1', '42', 'Ereğli/Konya'); 
  INSERT INTO `av_kapsam` VALUES ('651', '1', '42', 'Güneysınır'); 
  INSERT INTO `av_kapsam` VALUES ('652', '1', '42', 'Hadim'); 
  INSERT INTO `av_kapsam` VALUES ('653', '1', '42', 'Halkapınar'); 
  INSERT INTO `av_kapsam` VALUES ('654', '1', '42', 'Hüyük'); 
  INSERT INTO `av_kapsam` VALUES ('655', '1', '42', 'Ilgın'); 
  INSERT INTO `av_kapsam` VALUES ('656', '1', '42', 'Kadınhanı'); 
  INSERT INTO `av_kapsam` VALUES ('657', '1', '42', 'Karapınar'); 
  INSERT INTO `av_kapsam` VALUES ('658', '1', '42', 'Karatay'); 
  INSERT INTO `av_kapsam` VALUES ('659', '1', '42', 'Kulu'); 
  INSERT INTO `av_kapsam` VALUES ('660', '1', '42', 'Meram'); 
  INSERT INTO `av_kapsam` VALUES ('661', '1', '42', 'Sarayönü'); 
  INSERT INTO `av_kapsam` VALUES ('662', '1', '42', 'Selçuklu'); 
  INSERT INTO `av_kapsam` VALUES ('663', '1', '42', 'Seydişehir'); 
  INSERT INTO `av_kapsam` VALUES ('664', '1', '42', 'Taşkent'); 
  INSERT INTO `av_kapsam` VALUES ('665', '1', '42', 'Tuzlukçu'); 
  INSERT INTO `av_kapsam` VALUES ('666', '1', '42', 'Yalıhüyük'); 
  INSERT INTO `av_kapsam` VALUES ('667', '1', '42', 'Yunak'); 
  INSERT INTO `av_kapsam` VALUES ('668', '1', '43', 'Altıntaş'); 
  INSERT INTO `av_kapsam` VALUES ('669', '1', '43', 'Aslanapa'); 
  INSERT INTO `av_kapsam` VALUES ('670', '1', '43', 'Çavdarhisar'); 
  INSERT INTO `av_kapsam` VALUES ('671', '1', '43', 'Domaniç'); 
  INSERT INTO `av_kapsam` VALUES ('672', '1', '43', 'Dumlupınar'); 
  INSERT INTO `av_kapsam` VALUES ('673', '1', '43', 'Emet'); 
  INSERT INTO `av_kapsam` VALUES ('674', '1', '43', 'Gediz'); 
  INSERT INTO `av_kapsam` VALUES ('675', '1', '43', 'Hisarcık'); 
  INSERT INTO `av_kapsam` VALUES ('676', '1', '43', 'KütahyaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('677', '1', '43', 'Pazarlar'); 
  INSERT INTO `av_kapsam` VALUES ('678', '1', '43', 'Simav'); 
  INSERT INTO `av_kapsam` VALUES ('679', '1', '43', 'Şaphane'); 
  INSERT INTO `av_kapsam` VALUES ('680', '1', '43', 'Tavşanlı'); 
  INSERT INTO `av_kapsam` VALUES ('681', '1', '44', 'Akçadağ'); 
  INSERT INTO `av_kapsam` VALUES ('682', '1', '44', 'Arapgir'); 
  INSERT INTO `av_kapsam` VALUES ('683', '1', '44', 'Arguvan'); 
  INSERT INTO `av_kapsam` VALUES ('684', '1', '44', 'Battalgazi'); 
  INSERT INTO `av_kapsam` VALUES ('685', '1', '44', 'Darende'); 
  INSERT INTO `av_kapsam` VALUES ('686', '1', '44', 'Doğanşehir'); 
  INSERT INTO `av_kapsam` VALUES ('687', '1', '44', 'Doğanyol'); 
  INSERT INTO `av_kapsam` VALUES ('688', '1', '44', 'Hekimhan'); 
  INSERT INTO `av_kapsam` VALUES ('689', '1', '44', 'Kale/Malatya'); 
  INSERT INTO `av_kapsam` VALUES ('690', '1', '44', 'Kuluncak'); 
  INSERT INTO `av_kapsam` VALUES ('691', '1', '44', 'MalatyaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('692', '1', '44', 'Pütürge'); 
  INSERT INTO `av_kapsam` VALUES ('693', '1', '44', 'Yazıhan'); 
  INSERT INTO `av_kapsam` VALUES ('694', '1', '44', 'Yeşilyurt/Malatya'); 
  INSERT INTO `av_kapsam` VALUES ('695', '1', '45', 'Ahmetli'); 
  INSERT INTO `av_kapsam` VALUES ('696', '1', '45', 'Akhisar'); 
  INSERT INTO `av_kapsam` VALUES ('697', '1', '45', 'Alaşehir'); 
  INSERT INTO `av_kapsam` VALUES ('698', '1', '45', 'Demirci'); 
  INSERT INTO `av_kapsam` VALUES ('699', '1', '45', 'Gölmarmara'); 
  INSERT INTO `av_kapsam` VALUES ('700', '1', '45', 'Gördes'); 
  INSERT INTO `av_kapsam` VALUES ('701', '1', '45', 'Kırkağaç'); 
  INSERT INTO `av_kapsam` VALUES ('702', '1', '45', 'Köprübaşı/Manisa'); 
  INSERT INTO `av_kapsam` VALUES ('703', '1', '45', 'Kula'); 
  INSERT INTO `av_kapsam` VALUES ('704', '1', '45', 'ManisaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('705', '1', '45', 'Salihli'); 
  INSERT INTO `av_kapsam` VALUES ('706', '1', '45', 'Sarıgöl'); 
  INSERT INTO `av_kapsam` VALUES ('707', '1', '45', 'Saruhanlı'); 
  INSERT INTO `av_kapsam` VALUES ('708', '1', '45', 'Selendi'); 
  INSERT INTO `av_kapsam` VALUES ('709', '1', '45', 'Soma'); 
  INSERT INTO `av_kapsam` VALUES ('710', '1', '45', 'Turgutlu'); 
  INSERT INTO `av_kapsam` VALUES ('711', '1', '46', 'Afşin'); 
  INSERT INTO `av_kapsam` VALUES ('712', '1', '46', 'Andırın'); 
  INSERT INTO `av_kapsam` VALUES ('713', '1', '46', 'Çağlıyancerit'); 
  INSERT INTO `av_kapsam` VALUES ('714', '1', '46', 'Ekinözü'); 
  INSERT INTO `av_kapsam` VALUES ('715', '1', '46', 'Elbistan'); 
  INSERT INTO `av_kapsam` VALUES ('716', '1', '46', 'Göksun'); 
  INSERT INTO `av_kapsam` VALUES ('717', '1', '46', 'KahramanmaraşMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('718', '1', '46', 'Nurhak'); 
  INSERT INTO `av_kapsam` VALUES ('719', '1', '46', 'Pazarcık'); 
  INSERT INTO `av_kapsam` VALUES ('720', '1', '46', 'Türkoğlu'); 
  INSERT INTO `av_kapsam` VALUES ('721', '1', '47', 'Dargeçit'); 
  INSERT INTO `av_kapsam` VALUES ('722', '1', '47', 'Derik'); 
  INSERT INTO `av_kapsam` VALUES ('723', '1', '47', 'Kızıltepe'); 
  INSERT INTO `av_kapsam` VALUES ('724', '1', '47', 'MardinMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('725', '1', '47', 'Mazıdağı'); 
  INSERT INTO `av_kapsam` VALUES ('726', '1', '47', 'Midyat'); 
  INSERT INTO `av_kapsam` VALUES ('727', '1', '47', 'Nusaybin'); 
  INSERT INTO `av_kapsam` VALUES ('728', '1', '47', 'Ömerli'); 
  INSERT INTO `av_kapsam` VALUES ('729', '1', '47', 'Savur'); 
  INSERT INTO `av_kapsam` VALUES ('730', '1', '47', 'Yeşilli'); 
  INSERT INTO `av_kapsam` VALUES ('731', '1', '48', 'Bodrum'); 
  INSERT INTO `av_kapsam` VALUES ('732', '1', '48', 'Dalaman'); 
  INSERT INTO `av_kapsam` VALUES ('733', '1', '48', 'Datça'); 
  INSERT INTO `av_kapsam` VALUES ('734', '1', '48', 'Fethiye'); 
  INSERT INTO `av_kapsam` VALUES ('735', '1', '48', 'Kavaklıdere'); 
  INSERT INTO `av_kapsam` VALUES ('736', '1', '48', 'Köyceğiz'); 
  INSERT INTO `av_kapsam` VALUES ('737', '1', '48', 'Marmaris'); 
  INSERT INTO `av_kapsam` VALUES ('738', '1', '48', 'Milas'); 
  INSERT INTO `av_kapsam` VALUES ('739', '1', '48', 'MuğlaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('740', '1', '48', 'Ortaca'); 
  INSERT INTO `av_kapsam` VALUES ('741', '1', '48', 'Ula'); 
  INSERT INTO `av_kapsam` VALUES ('742', '1', '48', 'Yatağan'); 
  INSERT INTO `av_kapsam` VALUES ('743', '1', '49', 'Bulanık'); 
  INSERT INTO `av_kapsam` VALUES ('744', '1', '49', 'Hasköy'); 
  INSERT INTO `av_kapsam` VALUES ('745', '1', '49', 'Korkut'); 
  INSERT INTO `av_kapsam` VALUES ('746', '1', '49', 'Malazgirt'); 
  INSERT INTO `av_kapsam` VALUES ('747', '1', '49', 'MuşMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('748', '1', '49', 'Varto'); 
  INSERT INTO `av_kapsam` VALUES ('749', '1', '50', 'Acıgöl'); 
  INSERT INTO `av_kapsam` VALUES ('750', '1', '50', 'Avanos'); 
  INSERT INTO `av_kapsam` VALUES ('751', '1', '50', 'Derinkuyu'); 
  INSERT INTO `av_kapsam` VALUES ('752', '1', '50', 'Gülşehir'); 
  INSERT INTO `av_kapsam` VALUES ('753', '1', '50', 'Hacıbektaş'); 
  INSERT INTO `av_kapsam` VALUES ('754', '1', '50', 'Kozaklı'); 
  INSERT INTO `av_kapsam` VALUES ('755', '1', '50', 'NevşehirMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('756', '1', '50', 'Ürgüp'); 
  INSERT INTO `av_kapsam` VALUES ('757', '1', '51', 'Altunhisar'); 
  INSERT INTO `av_kapsam` VALUES ('758', '1', '51', 'Bor'); 
  INSERT INTO `av_kapsam` VALUES ('759', '1', '51', 'Çamardı'); 
  INSERT INTO `av_kapsam` VALUES ('760', '1', '51', 'Çiftlik'); 
  INSERT INTO `av_kapsam` VALUES ('761', '1', '51', 'NiğdeMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('762', '1', '51', 'Ulukışla'); 
  INSERT INTO `av_kapsam` VALUES ('763', '1', '52', 'Akkuş'); 
  INSERT INTO `av_kapsam` VALUES ('764', '1', '52', 'Aybastı'); 
  INSERT INTO `av_kapsam` VALUES ('765', '1', '52', 'Çamaş'); 
  INSERT INTO `av_kapsam` VALUES ('766', '1', '52', 'Çatalpınar'); 
  INSERT INTO `av_kapsam` VALUES ('767', '1', '52', 'Çaybaşı'); 
  INSERT INTO `av_kapsam` VALUES ('768', '1', '52', 'Fatsa'); 
  INSERT INTO `av_kapsam` VALUES ('769', '1', '52', 'Gölköy'); 
  INSERT INTO `av_kapsam` VALUES ('770', '1', '52', 'Gülyalı'); 
  INSERT INTO `av_kapsam` VALUES ('771', '1', '52', 'Gürgentepe'); 
  INSERT INTO `av_kapsam` VALUES ('772', '1', '52', 'İkizce'); 
  INSERT INTO `av_kapsam` VALUES ('773', '1', '52', 'Kabadüz'); 
  INSERT INTO `av_kapsam` VALUES ('774', '1', '52', 'Kabataş'); 
  INSERT INTO `av_kapsam` VALUES ('775', '1', '52', 'Korgan'); 
  INSERT INTO `av_kapsam` VALUES ('776', '1', '52', 'Kumru'); 
  INSERT INTO `av_kapsam` VALUES ('777', '1', '52', 'Mesudiye'); 
  INSERT INTO `av_kapsam` VALUES ('778', '1', '52', 'OrduMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('779', '1', '52', 'Perşembe'); 
  INSERT INTO `av_kapsam` VALUES ('780', '1', '52', 'Ulubey/Ordu'); 
  INSERT INTO `av_kapsam` VALUES ('781', '1', '52', 'Ünye'); 
  INSERT INTO `av_kapsam` VALUES ('782', '1', '53', 'Ardeşen'); 
  INSERT INTO `av_kapsam` VALUES ('783', '1', '53', 'Çamlıhemşin'); 
  INSERT INTO `av_kapsam` VALUES ('784', '1', '53', 'Çayeli'); 
  INSERT INTO `av_kapsam` VALUES ('785', '1', '53', 'Derepazarı'); 
  INSERT INTO `av_kapsam` VALUES ('786', '1', '53', 'Fındıklı'); 
  INSERT INTO `av_kapsam` VALUES ('787', '1', '53', 'Güneysu'); 
  INSERT INTO `av_kapsam` VALUES ('788', '1', '53', 'Hemşin'); 
  INSERT INTO `av_kapsam` VALUES ('789', '1', '53', 'İkizdere'); 
  INSERT INTO `av_kapsam` VALUES ('790', '1', '53', 'İyidere'); 
  INSERT INTO `av_kapsam` VALUES ('791', '1', '53', 'Kalkandere'); 
  INSERT INTO `av_kapsam` VALUES ('792', '1', '53', 'Pazar/Rize'); 
  INSERT INTO `av_kapsam` VALUES ('793', '1', '53', 'RizeMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('794', '1', '54', 'Adapazarı'); 
  INSERT INTO `av_kapsam` VALUES ('795', '1', '54', 'Akyazı'); 
  INSERT INTO `av_kapsam` VALUES ('796', '1', '54', 'Arifiye'); 
  INSERT INTO `av_kapsam` VALUES ('797', '1', '54', 'Erenler'); 
  INSERT INTO `av_kapsam` VALUES ('798', '1', '54', 'Ferizli'); 
  INSERT INTO `av_kapsam` VALUES ('799', '1', '54', 'Geyve'); 
  INSERT INTO `av_kapsam` VALUES ('800', '1', '54', 'Hendek'); 
  INSERT INTO `av_kapsam` VALUES ('801', '1', '54', 'Karapürçek'); 
  INSERT INTO `av_kapsam` VALUES ('802', '1', '54', 'Karasu'); 
  INSERT INTO `av_kapsam` VALUES ('803', '1', '54', 'Kaynarca'); 
  INSERT INTO `av_kapsam` VALUES ('804', '1', '54', 'Kocaali'); 
  INSERT INTO `av_kapsam` VALUES ('805', '1', '54', 'Pamukova'); 
  INSERT INTO `av_kapsam` VALUES ('806', '1', '54', 'Sapanca'); 
  INSERT INTO `av_kapsam` VALUES ('807', '1', '54', 'Serdivan'); 
  INSERT INTO `av_kapsam` VALUES ('808', '1', '54', 'Söğütlü'); 
  INSERT INTO `av_kapsam` VALUES ('809', '1', '54', 'Taraklı'); 
  INSERT INTO `av_kapsam` VALUES ('810', '1', '55', 'Alaçam'); 
  INSERT INTO `av_kapsam` VALUES ('811', '1', '55', 'Asarcık'); 
  INSERT INTO `av_kapsam` VALUES ('812', '1', '55', 'Atakum'); 
  INSERT INTO `av_kapsam` VALUES ('813', '1', '55', 'Ayvacık/Samsun'); 
  INSERT INTO `av_kapsam` VALUES ('814', '1', '55', 'Bafra'); 
  INSERT INTO `av_kapsam` VALUES ('815', '1', '55', 'Canik'); 
  INSERT INTO `av_kapsam` VALUES ('816', '1', '55', 'Çarşamba'); 
  INSERT INTO `av_kapsam` VALUES ('817', '1', '55', 'Havza'); 
  INSERT INTO `av_kapsam` VALUES ('818', '1', '55', 'İlkadım'); 
  INSERT INTO `av_kapsam` VALUES ('819', '1', '55', 'Kavak'); 
  INSERT INTO `av_kapsam` VALUES ('820', '1', '55', 'Ladik'); 
  INSERT INTO `av_kapsam` VALUES ('821', '1', '55', 'Ondokuzmayıs'); 
  INSERT INTO `av_kapsam` VALUES ('822', '1', '55', 'Salıpazarı'); 
  INSERT INTO `av_kapsam` VALUES ('823', '1', '55', 'Tekkeköy'); 
  INSERT INTO `av_kapsam` VALUES ('824', '1', '55', 'Terme'); 
  INSERT INTO `av_kapsam` VALUES ('825', '1', '55', 'Vezirköprü'); 
  INSERT INTO `av_kapsam` VALUES ('826', '1', '55', 'Yakakent'); 
  INSERT INTO `av_kapsam` VALUES ('827', '1', '56', 'Aydınlar'); 
  INSERT INTO `av_kapsam` VALUES ('828', '1', '56', 'Baykan'); 
  INSERT INTO `av_kapsam` VALUES ('829', '1', '56', 'Eruh'); 
  INSERT INTO `av_kapsam` VALUES ('830', '1', '56', 'Kurtalan'); 
  INSERT INTO `av_kapsam` VALUES ('831', '1', '56', 'Pervari'); 
  INSERT INTO `av_kapsam` VALUES ('832', '1', '56', 'SiirtMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('833', '1', '56', 'Şirvan'); 
  INSERT INTO `av_kapsam` VALUES ('834', '1', '57', 'Ayancık'); 
  INSERT INTO `av_kapsam` VALUES ('835', '1', '57', 'Boyabat'); 
  INSERT INTO `av_kapsam` VALUES ('836', '1', '57', 'Dikmen'); 
  INSERT INTO `av_kapsam` VALUES ('837', '1', '57', 'Durağan'); 
  INSERT INTO `av_kapsam` VALUES ('838', '1', '57', 'Erfelek'); 
  INSERT INTO `av_kapsam` VALUES ('839', '1', '57', 'Gerze'); 
  INSERT INTO `av_kapsam` VALUES ('840', '1', '57', 'Saraydüzü'); 
  INSERT INTO `av_kapsam` VALUES ('841', '1', '57', 'SinopMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('842', '1', '57', 'Türkeli'); 
  INSERT INTO `av_kapsam` VALUES ('843', '1', '58', 'Akıncılar'); 
  INSERT INTO `av_kapsam` VALUES ('844', '1', '58', 'Altınyayla/Sivas'); 
  INSERT INTO `av_kapsam` VALUES ('845', '1', '58', 'Divriği'); 
  INSERT INTO `av_kapsam` VALUES ('846', '1', '58', 'Doğanşar'); 
  INSERT INTO `av_kapsam` VALUES ('847', '1', '58', 'Gemerek'); 
  INSERT INTO `av_kapsam` VALUES ('848', '1', '58', 'Gölova'); 
  INSERT INTO `av_kapsam` VALUES ('849', '1', '58', 'Gürün'); 
  INSERT INTO `av_kapsam` VALUES ('850', '1', '58', 'Hafik'); 
  INSERT INTO `av_kapsam` VALUES ('851', '1', '58', 'İmranlı'); 
  INSERT INTO `av_kapsam` VALUES ('852', '1', '58', 'Kangal'); 
  INSERT INTO `av_kapsam` VALUES ('853', '1', '58', 'Koyulhisar'); 
  INSERT INTO `av_kapsam` VALUES ('854', '1', '58', 'SivasMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('855', '1', '58', 'Suşehri'); 
  INSERT INTO `av_kapsam` VALUES ('856', '1', '58', 'Şarkışla'); 
  INSERT INTO `av_kapsam` VALUES ('857', '1', '58', 'Ulaş'); 
  INSERT INTO `av_kapsam` VALUES ('858', '1', '58', 'Yıldızeli'); 
  INSERT INTO `av_kapsam` VALUES ('859', '1', '58', 'Zara'); 
  INSERT INTO `av_kapsam` VALUES ('860', '1', '59', 'Çerkezköy'); 
  INSERT INTO `av_kapsam` VALUES ('861', '1', '59', 'Çorlu'); 
  INSERT INTO `av_kapsam` VALUES ('862', '1', '59', 'Hayrabolu'); 
  INSERT INTO `av_kapsam` VALUES ('863', '1', '59', 'Malkara'); 
  INSERT INTO `av_kapsam` VALUES ('864', '1', '59', 'Marmaraereğlisi'); 
  INSERT INTO `av_kapsam` VALUES ('865', '1', '59', 'Muratlı'); 
  INSERT INTO `av_kapsam` VALUES ('866', '1', '59', 'Saray/Tekirdağ'); 
  INSERT INTO `av_kapsam` VALUES ('867', '1', '59', 'Şarköy'); 
  INSERT INTO `av_kapsam` VALUES ('868', '1', '59', 'TekirdağMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('869', '1', '60', 'Almus'); 
  INSERT INTO `av_kapsam` VALUES ('870', '1', '60', 'Artova'); 
  INSERT INTO `av_kapsam` VALUES ('871', '1', '60', 'Başçiftlik'); 
  INSERT INTO `av_kapsam` VALUES ('872', '1', '60', 'Erbaa'); 
  INSERT INTO `av_kapsam` VALUES ('873', '1', '60', 'Niksar'); 
  INSERT INTO `av_kapsam` VALUES ('874', '1', '60', 'Pazar/Tokat'); 
  INSERT INTO `av_kapsam` VALUES ('875', '1', '60', 'Reşadiye'); 
  INSERT INTO `av_kapsam` VALUES ('876', '1', '60', 'Sulusaray'); 
  INSERT INTO `av_kapsam` VALUES ('877', '1', '60', 'TokatMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('878', '1', '60', 'Turhal'); 
  INSERT INTO `av_kapsam` VALUES ('879', '1', '60', 'Yeşilyurt/Tokat'); 
  INSERT INTO `av_kapsam` VALUES ('880', '1', '60', 'Zile'); 
  INSERT INTO `av_kapsam` VALUES ('881', '1', '61', 'Akçaabat'); 
  INSERT INTO `av_kapsam` VALUES ('882', '1', '61', 'Araklı'); 
  INSERT INTO `av_kapsam` VALUES ('883', '1', '61', 'Arsin'); 
  INSERT INTO `av_kapsam` VALUES ('884', '1', '61', 'Beşikdüzü'); 
  INSERT INTO `av_kapsam` VALUES ('885', '1', '61', 'Çarşıbaşı'); 
  INSERT INTO `av_kapsam` VALUES ('886', '1', '61', 'Çaykara'); 
  INSERT INTO `av_kapsam` VALUES ('887', '1', '61', 'Dernekpazarı'); 
  INSERT INTO `av_kapsam` VALUES ('888', '1', '61', 'Düzköy'); 
  INSERT INTO `av_kapsam` VALUES ('889', '1', '61', 'Hayrat'); 
  INSERT INTO `av_kapsam` VALUES ('890', '1', '61', 'Köprübaşı/Trabzon'); 
  INSERT INTO `av_kapsam` VALUES ('891', '1', '61', 'Maçka'); 
  INSERT INTO `av_kapsam` VALUES ('892', '1', '61', 'Of'); 
  INSERT INTO `av_kapsam` VALUES ('893', '1', '61', 'Sürmene'); 
  INSERT INTO `av_kapsam` VALUES ('894', '1', '61', 'Şalpazarı'); 
  INSERT INTO `av_kapsam` VALUES ('895', '1', '61', 'Tonya'); 
  INSERT INTO `av_kapsam` VALUES ('896', '1', '61', 'TrabzonMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('897', '1', '61', 'Vakfıkebir'); 
  INSERT INTO `av_kapsam` VALUES ('898', '1', '61', 'Yomra'); 
  INSERT INTO `av_kapsam` VALUES ('899', '1', '62', 'Çemişgezek'); 
  INSERT INTO `av_kapsam` VALUES ('900', '1', '62', 'Hozat'); 
  INSERT INTO `av_kapsam` VALUES ('901', '1', '62', 'Mazgirt'); 
  INSERT INTO `av_kapsam` VALUES ('902', '1', '62', 'Nazımiye'); 
  INSERT INTO `av_kapsam` VALUES ('903', '1', '62', 'Ovacık/Tunceli'); 
  INSERT INTO `av_kapsam` VALUES ('904', '1', '62', 'Pertek'); 
  INSERT INTO `av_kapsam` VALUES ('905', '1', '62', 'Pülümür'); 
  INSERT INTO `av_kapsam` VALUES ('906', '1', '62', 'TunceliMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('907', '1', '63', 'Akçakale'); 
  INSERT INTO `av_kapsam` VALUES ('908', '1', '63', 'Birecik'); 
  INSERT INTO `av_kapsam` VALUES ('909', '1', '63', 'Bozova'); 
  INSERT INTO `av_kapsam` VALUES ('910', '1', '63', 'Ceylanpınar'); 
  INSERT INTO `av_kapsam` VALUES ('911', '1', '63', 'Halfeti'); 
  INSERT INTO `av_kapsam` VALUES ('912', '1', '63', 'Harran'); 
  INSERT INTO `av_kapsam` VALUES ('913', '1', '63', 'Hilvan'); 
  INSERT INTO `av_kapsam` VALUES ('914', '1', '63', 'Siverek'); 
  INSERT INTO `av_kapsam` VALUES ('915', '1', '63', 'Suruç'); 
  INSERT INTO `av_kapsam` VALUES ('916', '1', '63', 'ŞanlıurfaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('917', '1', '63', 'Viranşehir'); 
  INSERT INTO `av_kapsam` VALUES ('918', '1', '64', 'Banaz'); 
  INSERT INTO `av_kapsam` VALUES ('919', '1', '64', 'Eşme'); 
  INSERT INTO `av_kapsam` VALUES ('920', '1', '64', 'Karahallı'); 
  INSERT INTO `av_kapsam` VALUES ('921', '1', '64', 'Sivaslı'); 
  INSERT INTO `av_kapsam` VALUES ('922', '1', '64', 'Ulubey/Uşak'); 
  INSERT INTO `av_kapsam` VALUES ('923', '1', '64', 'UşakMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('924', '1', '65', 'Bahçesaray'); 
  INSERT INTO `av_kapsam` VALUES ('925', '1', '65', 'Başkale'); 
  INSERT INTO `av_kapsam` VALUES ('926', '1', '65', 'Çaldıran'); 
  INSERT INTO `av_kapsam` VALUES ('927', '1', '65', 'Çatak'); 
  INSERT INTO `av_kapsam` VALUES ('928', '1', '65', 'Edremit/Van'); 
  INSERT INTO `av_kapsam` VALUES ('929', '1', '65', 'Erciş'); 
  INSERT INTO `av_kapsam` VALUES ('930', '1', '65', 'Gevaş'); 
  INSERT INTO `av_kapsam` VALUES ('931', '1', '65', 'Gürpınar'); 
  INSERT INTO `av_kapsam` VALUES ('932', '1', '65', 'Muradiye'); 
  INSERT INTO `av_kapsam` VALUES ('933', '1', '65', 'Özalp'); 
  INSERT INTO `av_kapsam` VALUES ('934', '1', '65', 'Saray/Van'); 
  INSERT INTO `av_kapsam` VALUES ('935', '1', '65', 'VanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('936', '1', '66', 'Akdağmadeni'); 
  INSERT INTO `av_kapsam` VALUES ('937', '1', '66', 'Aydıncık/Yozgat'); 
  INSERT INTO `av_kapsam` VALUES ('938', '1', '66', 'Boğazlıyan'); 
  INSERT INTO `av_kapsam` VALUES ('939', '1', '66', 'Çandır'); 
  INSERT INTO `av_kapsam` VALUES ('940', '1', '66', 'Çayıralan'); 
  INSERT INTO `av_kapsam` VALUES ('941', '1', '66', 'Çekerek'); 
  INSERT INTO `av_kapsam` VALUES ('942', '1', '66', 'Kadışehri'); 
  INSERT INTO `av_kapsam` VALUES ('943', '1', '66', 'Saraykent'); 
  INSERT INTO `av_kapsam` VALUES ('944', '1', '66', 'Sarıkaya'); 
  INSERT INTO `av_kapsam` VALUES ('945', '1', '66', 'Sorgun'); 
  INSERT INTO `av_kapsam` VALUES ('946', '1', '66', 'Şefaatli'); 
  INSERT INTO `av_kapsam` VALUES ('947', '1', '66', 'Yenifakılı'); 
  INSERT INTO `av_kapsam` VALUES ('948', '1', '66', 'Yerköy'); 
  INSERT INTO `av_kapsam` VALUES ('949', '1', '66', 'YozgatMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('950', '1', '67', 'Alaplı'); 
  INSERT INTO `av_kapsam` VALUES ('951', '1', '67', 'Çaycuma'); 
  INSERT INTO `av_kapsam` VALUES ('952', '1', '67', 'Devrek'); 
  INSERT INTO `av_kapsam` VALUES ('953', '1', '67', 'Ereğli/Zonguldak'); 
  INSERT INTO `av_kapsam` VALUES ('954', '1', '67', 'Gökçebey'); 
  INSERT INTO `av_kapsam` VALUES ('955', '1', '67', 'ZonguldakMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('956', '1', '68', 'Ağaçören'); 
  INSERT INTO `av_kapsam` VALUES ('957', '1', '68', 'AksarayMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('958', '1', '68', 'Eskil'); 
  INSERT INTO `av_kapsam` VALUES ('959', '1', '68', 'Gülağaç'); 
  INSERT INTO `av_kapsam` VALUES ('960', '1', '68', 'Güzelyurt'); 
  INSERT INTO `av_kapsam` VALUES ('961', '1', '68', 'Ortaköy'); 
  INSERT INTO `av_kapsam` VALUES ('962', '1', '68', 'Sarıyahşi'); 
  INSERT INTO `av_kapsam` VALUES ('963', '1', '69', 'Aydıntepe'); 
  INSERT INTO `av_kapsam` VALUES ('964', '1', '69', 'BayburtMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('965', '1', '69', 'Demirözü'); 
  INSERT INTO `av_kapsam` VALUES ('966', '1', '70', 'Ayrancı'); 
  INSERT INTO `av_kapsam` VALUES ('967', '1', '70', 'Başyayla'); 
  INSERT INTO `av_kapsam` VALUES ('968', '1', '70', 'Ermenek'); 
  INSERT INTO `av_kapsam` VALUES ('969', '1', '70', 'KaramanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('970', '1', '70', 'Kazımkarabekir'); 
  INSERT INTO `av_kapsam` VALUES ('971', '1', '70', 'Sarıveliler'); 
  INSERT INTO `av_kapsam` VALUES ('972', '1', '71', 'Bahşili'); 
  INSERT INTO `av_kapsam` VALUES ('973', '1', '71', 'Balışeyh'); 
  INSERT INTO `av_kapsam` VALUES ('974', '1', '71', 'Çelebi'); 
  INSERT INTO `av_kapsam` VALUES ('975', '1', '71', 'Delice'); 
  INSERT INTO `av_kapsam` VALUES ('976', '1', '71', 'Karakeçili'); 
  INSERT INTO `av_kapsam` VALUES ('977', '1', '71', 'Keskin'); 
  INSERT INTO `av_kapsam` VALUES ('978', '1', '71', 'KırıkkaleMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('979', '1', '71', 'Sulakyurt'); 
  INSERT INTO `av_kapsam` VALUES ('980', '1', '71', 'Yahşihan'); 
  INSERT INTO `av_kapsam` VALUES ('981', '1', '72', 'BatmanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('982', '1', '72', 'Beşiri'); 
  INSERT INTO `av_kapsam` VALUES ('983', '1', '72', 'Gercüş'); 
  INSERT INTO `av_kapsam` VALUES ('984', '1', '72', 'Hasankeyf'); 
  INSERT INTO `av_kapsam` VALUES ('985', '1', '72', 'Kozluk'); 
  INSERT INTO `av_kapsam` VALUES ('986', '1', '72', 'Sason'); 
  INSERT INTO `av_kapsam` VALUES ('987', '1', '73', 'Beytüşşebap'); 
  INSERT INTO `av_kapsam` VALUES ('988', '1', '73', 'Cizre'); 
  INSERT INTO `av_kapsam` VALUES ('989', '1', '73', 'Güçlükonak'); 
  INSERT INTO `av_kapsam` VALUES ('990', '1', '73', 'İdil'); 
  INSERT INTO `av_kapsam` VALUES ('991', '1', '73', 'Silopi'); 
  INSERT INTO `av_kapsam` VALUES ('992', '1', '73', 'ŞırnakMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('993', '1', '73', 'Uludere'); 
  INSERT INTO `av_kapsam` VALUES ('994', '1', '74', 'Amasra'); 
  INSERT INTO `av_kapsam` VALUES ('995', '1', '74', 'BartınMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('996', '1', '74', 'Kurucaşile'); 
  INSERT INTO `av_kapsam` VALUES ('997', '1', '74', 'Ulus'); 
  INSERT INTO `av_kapsam` VALUES ('998', '1', '75', 'ArdahanMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('999', '1', '75', 'Çıldır'); 
  INSERT INTO `av_kapsam` VALUES ('1000', '1', '75', 'Damal'); 
  INSERT INTO `av_kapsam` VALUES ('1001', '1', '75', 'Göle'); 
  INSERT INTO `av_kapsam` VALUES ('1002', '1', '75', 'Hanak'); 
  INSERT INTO `av_kapsam` VALUES ('1003', '1', '75', 'Posof'); 
  INSERT INTO `av_kapsam` VALUES ('1004', '1', '76', 'Aralık'); 
  INSERT INTO `av_kapsam` VALUES ('1005', '1', '76', 'IğdırMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1006', '1', '76', 'Karakoyunlu'); 
  INSERT INTO `av_kapsam` VALUES ('1007', '1', '76', 'Tuzluca'); 
  INSERT INTO `av_kapsam` VALUES ('1008', '1', '77', 'Altınova'); 
  INSERT INTO `av_kapsam` VALUES ('1009', '1', '77', 'Armutlu'); 
  INSERT INTO `av_kapsam` VALUES ('1010', '1', '77', 'Çınarcık'); 
  INSERT INTO `av_kapsam` VALUES ('1011', '1', '77', 'Çiftlikköy'); 
  INSERT INTO `av_kapsam` VALUES ('1012', '1', '77', 'Termal'); 
  INSERT INTO `av_kapsam` VALUES ('1013', '1', '77', 'YalovaMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1014', '1', '78', 'Eflani'); 
  INSERT INTO `av_kapsam` VALUES ('1015', '1', '78', 'Eskipazar'); 
  INSERT INTO `av_kapsam` VALUES ('1016', '1', '78', 'KarabükMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1017', '1', '78', 'Ovacık/Karabük'); 
  INSERT INTO `av_kapsam` VALUES ('1018', '1', '78', 'Safranbolu'); 
  INSERT INTO `av_kapsam` VALUES ('1019', '1', '78', 'Yenice/Karabük'); 
  INSERT INTO `av_kapsam` VALUES ('1020', '1', '79', 'Elbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('1021', '1', '79', 'KilisMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1022', '1', '79', 'Musabeyli'); 
  INSERT INTO `av_kapsam` VALUES ('1023', '1', '79', 'Polateli'); 
  INSERT INTO `av_kapsam` VALUES ('1024', '1', '80', 'Bahçe'); 
  INSERT INTO `av_kapsam` VALUES ('1025', '1', '80', 'Düziçi'); 
  INSERT INTO `av_kapsam` VALUES ('1026', '1', '80', 'Hasanbeyli'); 
  INSERT INTO `av_kapsam` VALUES ('1027', '1', '80', 'Kadirli'); 
  INSERT INTO `av_kapsam` VALUES ('1028', '1', '80', 'OsmaniyeMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1029', '1', '80', 'Sumbas'); 
  INSERT INTO `av_kapsam` VALUES ('1030', '1', '80', 'Toprakkale'); 
  INSERT INTO `av_kapsam` VALUES ('1031', '1', '81', 'Akçakoca'); 
  INSERT INTO `av_kapsam` VALUES ('1032', '1', '81', 'Cumayeri'); 
  INSERT INTO `av_kapsam` VALUES ('1033', '1', '81', 'Çilimli'); 
  INSERT INTO `av_kapsam` VALUES ('1034', '1', '81', 'DüzceMerkez'); 
  INSERT INTO `av_kapsam` VALUES ('1035', '1', '81', 'Gölyaka'); 
  INSERT INTO `av_kapsam` VALUES ('1036', '1', '81', 'Gümüşova'); 
  INSERT INTO `av_kapsam` VALUES ('1037', '1', '81', 'Kaynaşlı'); 
  INSERT INTO `av_kapsam` VALUES ('1038', '1', '81', 'Yığılca');

< Bu mesaj bu kişi tarafından değiştirildi Perceptron -- 11 Kasım 2014; 22:41:33 >
Bu mesaja 1 cevap geldi.

Perceptron

11 yıl

Binbaşı

ayrıca jquery.dynatree.js kullanarak yaptım.
umarım yukardaki vt ve bu kütüphane yardımcı olur.

Bu mesaja 1 cevap geldi.

esesdi

11 yıl

Onbaşı

Konu Sahibi

Teşekkürler Dostum :) Gayet Güzel :)
0'dan yazmıştım derken baya sıfırdan satır satır yazdın mı

Bu mesajda bahsedilenler: @.fcan

unforgiven1127

11 yıl

Binbaşı

iller için sql

-- phpMyAdmin SQL Dump
-- version 3.3.10
--http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 12 Kasım 2014 saat 17:39:55
-- Sunucu sürümü: 5.5.11
-- PHP Sürümü: 5.3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Veritabanı: `gps_hr`
--

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(14) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`flag` enum('a','p') NOT NULL,
`first_activity` int(10) NOT NULL,
`last_activity` int(10) NOT NULL,
`ip_address` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ;

--
-- Tablo döküm verisi `cities`
--

INSERT INTO `cities` (`id`, `title`, `user_id`, `flag`, `first_activity`, `last_activity`, `ip_address`) VALUES
(1, 'Adana', 0, 'a', 0, 0, ''),
(2, 'Adıyaman', 0, 'a', 0, 0, ''),
(3, 'Afyonkarahisar', 0, 'a', 0, 0, ''),
(4, 'Ağrı', 0, 'a', 0, 0, ''),
(5, 'Amasya', 0, 'a', 0, 0, ''),
(6, 'Ankara', 0, 'a', 0, 0, ''),
(7, 'Antalya', 0, 'a', 0, 0, ''),
(8, 'Artvin', 0, 'a', 0, 0, ''),
(9, 'Aydın', 0, 'a', 0, 0, ''),
(10, 'Balıkesir', 0, 'a', 0, 0, ''),
(11, 'Bilecik', 0, 'a', 0, 0, ''),
(12, 'Bingöl', 0, 'a', 0, 0, ''),
(13, 'Bitlis', 0, 'a', 0, 0, ''),
(14, 'Bolu', 0, 'a', 0, 0, ''),
(15, 'Burdur', 0, 'a', 0, 0, ''),
(16, 'Bursa', 0, 'a', 0, 0, ''),
(17, 'Çanakkale', 0, 'a', 0, 0, ''),
(18, 'Çankırı', 0, 'a', 0, 0, ''),
(19, 'Çorum', 0, 'a', 0, 0, ''),
(20, 'Denizli', 0, 'a', 0, 0, ''),
(21, 'Diyarbakır', 0, 'a', 0, 0, ''),
(22, 'Edirne', 0, 'a', 0, 0, ''),
(23, 'Elazığ', 0, 'a', 0, 0, ''),
(24, 'Erzincan', 0, 'a', 0, 0, ''),
(25, 'Erzurum', 0, 'a', 0, 0, ''),
(26, 'Eskişehir', 0, 'a', 0, 0, ''),
(27, 'Gaziantep', 0, 'a', 0, 0, ''),
(28, 'Giresun', 0, 'a', 0, 0, ''),
(29, 'Gümüşhane', 0, 'a', 0, 0, ''),
(30, 'Hakkari', 0, 'a', 0, 0, ''),
(31, 'Hatay', 0, 'a', 0, 0, ''),
(32, 'Isparta', 0, 'a', 0, 0, ''),
(33, 'Mersin', 0, 'a', 0, 0, ''),
(34, 'İstanbul', 0, 'a', 0, 0, ''),
(35, 'İzmir', 0, 'a', 0, 0, ''),
(36, 'Kars', 0, 'a', 0, 0, ''),
(37, 'Kastamonu', 0, 'a', 0, 0, ''),
(38, 'Kayseri', 0, 'a', 0, 0, ''),
(39, 'Kırklareli', 0, 'a', 0, 0, ''),
(40, 'Kırşehir', 0, 'a', 0, 0, ''),
(41, 'Kocaeli', 0, 'a', 0, 0, ''),
(42, 'Konya', 0, 'a', 0, 0, ''),
(43, 'Kütahya', 0, 'a', 0, 0, ''),
(44, 'Malatya', 0, 'a', 0, 0, ''),
(45, 'Manisa', 0, 'a', 0, 0, ''),
(46, 'Kahramanmaraş', 0, 'a', 0, 0, ''),
(47, 'Mardin', 0, 'a', 0, 0, ''),
(48, 'Muğla', 0, 'a', 0, 0, ''),
(49, 'Muş', 0, 'a', 0, 0, ''),
(50, 'Nevşehir', 0, 'a', 0, 0, ''),
(51, 'Niğde', 0, 'a', 0, 0, ''),
(52, 'Ordu', 0, 'a', 0, 0, ''),
(53, 'Rize', 0, 'a', 0, 0, ''),
(54, 'Sakarya', 0, 'a', 0, 0, ''),
(55, 'Samsun', 0, 'a', 0, 0, ''),
(56, 'Siirt', 0, 'a', 0, 0, ''),
(57, 'Sinop', 0, 'a', 0, 0, ''),
(58, 'Sivas', 0, 'a', 0, 0, ''),
(59, 'Tekirdağ', 0, 'a', 0, 0, ''),
(60, 'Tokat', 0, 'a', 0, 0, ''),
(61, 'Trabzon', 0, 'a', 0, 0, ''),
(62, 'Tunceli', 0, 'a', 0, 0, ''),
(63, 'Şanlıurfa', 0, 'a', 0, 0, ''),
(64, 'Uşak', 0, 'a', 0, 0, ''),
(65, 'Van', 0, 'a', 0, 0, ''),
(66, 'Yozgat', 0, 'a', 0, 0, ''),
(67, 'Zonguldak', 0, 'a', 0, 0, ''),
(68, 'Aksaray', 0, 'a', 0, 0, ''),
(69, 'Bayburt', 0, 'a', 0, 0, ''),
(70, 'Karaman', 0, 'a', 0, 0, ''),
(71, 'Kırıkkale', 0, 'a', 0, 0, ''),
(72, 'Batman', 0, 'a', 0, 0, ''),
(73, 'Şırnak', 0, 'a', 0, 0, ''),
(74, 'Bartın', 0, 'a', 0, 0, ''),
(75, 'Ardahan', 0, 'a', 0, 0, ''),
(76, 'Iğdır', 0, 'a', 0, 0, ''),
(77, 'Yalova', 0, 'a', 0, 0, ''),
(78, 'Karabük', 0, 'a', 0, 0, ''),
(79, 'Kilis', 0, 'a', 0, 0, ''),
(80, 'Osmaniye', 0, 'a', 0, 0, ''),
(81, 'Düzce', 0, 'a', 0, 0, '');

ilçeler için sql

-- phpMyAdmin SQL Dump
-- version 3.3.10
--http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 12 Kasım 2014 saat 17:39:38
-- Sunucu sürümü: 5.5.11
-- PHP Sürümü: 5.3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Veritabanı: `gps_hr`
--

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `towns`
--

CREATE TABLE IF NOT EXISTS `towns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`city_id` int(2) DEFAULT NULL,
`title` varchar(24) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`flag` enum('a','p') NOT NULL,
`first_activity` int(10) NOT NULL,
`last_activity` int(10) NOT NULL,
`ip_address` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=968 ;

--
-- Tablo döküm verisi `towns`
--

INSERT INTO `towns` (`id`, `city_id`, `title`, `user_id`, `flag`, `first_activity`, `last_activity`, `ip_address`) VALUES
(1, 1, 'Seyhan', 0, 'a', 0, 0, '0'),
(2, 1, 'Ceyhan', 0, 'a', 0, 0, '0'),
(3, 1, 'Feke', 0, 'a', 0, 0, '0'),
(4, 1, 'Karaisalı', 0, 'a', 0, 0, '0'),
(5, 1, 'Karataş', 0, 'a', 0, 0, '0'),
(6, 1, 'Kozan', 0, 'a', 0, 0, '0'),
(7, 1, 'Pozantı', 0, 'a', 0, 0, '0'),
(8, 1, 'Saimbeyli', 0, 'a', 0, 0, '0'),
(9, 1, 'Tufanbeyli', 0, 'a', 0, 0, '0'),
(10, 1, 'Yumurtalık', 0, 'a', 0, 0, '0'),
(11, 1, 'Yüreğir', 0, 'a', 0, 0, '0'),
(12, 1, 'Aladağ', 0, 'a', 0, 0, '0'),
(13, 1, 'İmamoğlu', 0, 'a', 0, 0, '0'),
(14, 1, 'Sarıçam', 0, 'a', 0, 0, '0'),
(15, 1, 'Çukurova', 0, 'a', 0, 0, '0'),
(16, 2, 'Adıyaman Merkez', 0, 'a', 0, 0, '0'),
(17, 2, 'Besni', 0, 'a', 0, 0, '0'),
(18, 2, 'Çelikhan', 0, 'a', 0, 0, '0'),
(19, 2, 'Gerger', 0, 'a', 0, 0, '0'),
(20, 2, 'Gölbaşı / Adıyaman', 0, 'a', 0, 0, '0'),
(21, 2, 'Kahta', 0, 'a', 0, 0, '0'),
(22, 2, 'Samsat', 0, 'a', 0, 0, '0'),
(23, 2, 'Sincik', 0, 'a', 0, 0, '0'),
(24, 2, 'Tut', 0, 'a', 0, 0, '0'),
(25, 3, 'Afyonkarahisar Merkez', 0, 'a', 0, 0, '0'),
(26, 3, 'Bolvadin', 0, 'a', 0, 0, '0'),
(27, 3, 'Çay', 0, 'a', 0, 0, '0'),
(28, 3, 'Dazkırı', 0, 'a', 0, 0, '0'),
(29, 3, 'Dinar', 0, 'a', 0, 0, '0'),
(30, 3, 'Emirdağ', 0, 'a', 0, 0, '0'),
(31, 3, 'İhsaniye', 0, 'a', 0, 0, '0'),
(32, 3, 'Sandıklı', 0, 'a', 0, 0, '0'),
(33, 3, 'Sinanpaşa', 0, 'a', 0, 0, '0'),
(34, 3, 'Sultandağı', 0, 'a', 0, 0, '0'),
(35, 3, 'Şuhut', 0, 'a', 0, 0, '0'),
(36, 3, 'Başmakçı', 0, 'a', 0, 0, '0'),
(37, 3, 'Bayat / Afyonkarahisar', 0, 'a', 0, 0, '0'),
(38, 3, 'İscehisar', 0, 'a', 0, 0, '0'),
(39, 3, 'Çobanlar', 0, 'a', 0, 0, '0'),
(40, 3, 'Evciler', 0, 'a', 0, 0, '0'),
(41, 3, 'Hocalar', 0, 'a', 0, 0, '0'),
(42, 3, 'Kızılören', 0, 'a', 0, 0, '0'),
(43, 4, 'Ağrı Merkez', 0, 'a', 0, 0, '0'),
(44, 4, 'Diyadin', 0, 'a', 0, 0, '0'),
(45, 4, 'Doğubayazıt', 0, 'a', 0, 0, '0'),
(46, 4, 'Eleşkirt', 0, 'a', 0, 0, '0'),
(47, 4, 'Hamur', 0, 'a', 0, 0, '0'),
(48, 4, 'Patnos', 0, 'a', 0, 0, '0'),
(49, 4, 'Taşlıçay', 0, 'a', 0, 0, '0'),
(50, 4, 'Tutak', 0, 'a', 0, 0, '0'),
(51, 5, 'Amasya Merkez', 0, 'a', 0, 0, '0'),
(52, 5, 'Göynücek', 0, 'a', 0, 0, '0'),
(53, 5, 'Gümüşhacıköy', 0, 'a', 0, 0, '0'),
(54, 5, 'Merzifon', 0, 'a', 0, 0, '0'),
(55, 5, 'Suluova', 0, 'a', 0, 0, '0'),
(56, 5, 'Taşova', 0, 'a', 0, 0, '0'),
(57, 5, 'Hamamözü', 0, 'a', 0, 0, '0'),
(58, 6, 'Altındağ', 0, 'a', 0, 0, '0'),
(59, 6, 'Ayaş', 0, 'a', 0, 0, '0'),
(60, 6, 'Bala', 0, 'a', 0, 0, '0'),
(61, 6, 'Beypazarı', 0, 'a', 0, 0, '0'),
(62, 6, 'Çamlıdere', 0, 'a', 0, 0, '0'),
(63, 6, 'Çankaya', 0, 'a', 0, 0, '0'),
(64, 6, 'Çubuk', 0, 'a', 0, 0, '0'),
(65, 6, 'Elmadağ', 0, 'a', 0, 0, '0'),
(66, 6, 'Güdül', 0, 'a', 0, 0, '0'),
(67, 6, 'Haymana', 0, 'a', 0, 0, '0'),
(68, 6, 'Kalecik', 0, 'a', 0, 0, '0'),
(69, 6, 'Kızılcahamam', 0, 'a', 0, 0, '0'),
(70, 6, 'Nallıhan', 0, 'a', 0, 0, '0'),
(71, 6, 'Polatlı', 0, 'a', 0, 0, '0'),
(72, 6, 'Şereflikoçhisar', 0, 'a', 0, 0, '0'),
(73, 6, 'Yenimahalle', 0, 'a', 0, 0, '0'),
(74, 6, 'Gölbaşı / Ankara', 0, 'a', 0, 0, '0'),
(75, 6, 'Keçiören', 0, 'a', 0, 0, '0'),
(76, 6, 'Mamak', 0, 'a', 0, 0, '0'),
(77, 6, 'Sincan', 0, 'a', 0, 0, '0'),
(78, 6, 'Kazan', 0, 'a', 0, 0, '0'),
(79, 6, 'Akyurt', 0, 'a', 0, 0, '0'),
(80, 6, 'Etimesgut', 0, 'a', 0, 0, '0'),
(81, 6, 'Evren', 0, 'a', 0, 0, '0'),
(82, 6, 'Pursaklar', 0, 'a', 0, 0, '0'),
(83, 7, 'Akseki', 0, 'a', 0, 0, '0'),
(84, 7, 'Alanya', 0, 'a', 0, 0, '0'),
(85, 7, 'Elmalı', 0, 'a', 0, 0, '0'),
(86, 7, 'Finike', 0, 'a', 0, 0, '0'),
(87, 7, 'Gazipaşa', 0, 'a', 0, 0, '0'),
(88, 7, 'Gündoğmuş', 0, 'a', 0, 0, '0'),
(89, 7, 'Kaş', 0, 'a', 0, 0, '0'),
(90, 7, 'Korkuteli', 0, 'a', 0, 0, '0'),
(91, 7, 'Kumluca', 0, 'a', 0, 0, '0'),
(92, 7, 'Manavgat', 0, 'a', 0, 0, '0'),
(93, 7, 'Serik', 0, 'a', 0, 0, '0'),
(94, 7, 'Demre', 0, 'a', 0, 0, '0'),
(95, 7, 'İbradı', 0, 'a', 0, 0, '0'),
(96, 7, 'Kemer / Antalya', 0, 'a', 0, 0, '0'),
(97, 7, 'Aksu / Antalya', 0, 'a', 0, 0, '0'),
(98, 7, 'Döşemealtı', 0, 'a', 0, 0, '0'),
(99, 7, 'Kepez', 0, 'a', 0, 0, '0'),
(100, 7, 'Konyaaltı', 0, 'a', 0, 0, '0'),
(101, 7, 'Muratpaşa', 0, 'a', 0, 0, '0'),
(102, 8, 'Ardanuç', 0, 'a', 0, 0, '0'),
(103, 8, 'Arhavi', 0, 'a', 0, 0, '0'),
(104, 8, 'Artvin Merkez', 0, 'a', 0, 0, '0'),
(105, 8, 'Borçka', 0, 'a', 0, 0, '0'),
(106, 8, 'Hopa', 0, 'a', 0, 0, '0'),
(107, 8, 'Şavşat', 0, 'a', 0, 0, '0'),
(108, 8, 'Yusufeli', 0, 'a', 0, 0, '0'),
(109, 8, 'Murgul', 0, 'a', 0, 0, '0'),
(110, 9, 'Bozdoğan', 0, 'a', 0, 0, '0'),
(111, 9, 'Çine', 0, 'a', 0, 0, '0'),
(112, 9, 'Germencik', 0, 'a', 0, 0, '0'),
(113, 9, 'Karacasu', 0, 'a', 0, 0, '0'),
(114, 9, 'Koçarlı', 0, 'a', 0, 0, '0'),
(115, 9, 'Kuşadası', 0, 'a', 0, 0, '0'),
(116, 9, 'Kuyucak', 0, 'a', 0, 0, '0'),
(117, 9, 'Nazilli', 0, 'a', 0, 0, '0'),
(118, 9, 'Söke', 0, 'a', 0, 0, '0'),
(119, 9, 'Sultanhisar', 0, 'a', 0, 0, '0'),
(120, 9, 'Yenipazar / Aydın', 0, 'a', 0, 0, '0'),
(121, 9, 'Buharkent', 0, 'a', 0, 0, '0'),
(122, 9, 'İncirliova', 0, 'a', 0, 0, '0'),
(123, 9, 'Karpuzlu', 0, 'a', 0, 0, '0'),
(124, 9, 'Köşk', 0, 'a', 0, 0, '0'),
(125, 9, 'Didim', 0, 'a', 0, 0, '0'),
(126, 9, 'Efeler', 0, 'a', 0, 0, '0'),
(127, 10, 'Ayvalık', 0, 'a', 0, 0, '0'),
(128, 10, 'Balya', 0, 'a', 0, 0, '0'),
(129, 10, 'Bandırma', 0, 'a', 0, 0, '0'),
(130, 10, 'Bigadiç', 0, 'a', 0, 0, '0'),
(131, 10, 'Burhaniye', 0, 'a', 0, 0, '0'),
(132, 10, 'Dursunbey', 0, 'a', 0, 0, '0'),
(133, 10, 'Edremit / Balıkesir', 0, 'a', 0, 0, '0'),
(134, 10, 'Erdek', 0, 'a', 0, 0, '0'),
(135, 10, 'Gönen / Balıkesir', 0, 'a', 0, 0, '0'),
(136, 10, 'Havran', 0, 'a', 0, 0, '0'),
(137, 10, 'İvrindi', 0, 'a', 0, 0, '0'),
(138, 10, 'Kepsut', 0, 'a', 0, 0, '0'),
(139, 10, 'Manyas', 0, 'a', 0, 0, '0'),
(140, 10, 'Savaştepe', 0, 'a', 0, 0, '0'),
(141, 10, 'Sındırgı', 0, 'a', 0, 0, '0'),
(142, 10, 'Susurluk', 0, 'a', 0, 0, '0'),
(143, 10, 'Marmara', 0, 'a', 0, 0, '0'),
(144, 10, 'Gömeç', 0, 'a', 0, 0, '0'),
(145, 10, 'Altıeylül', 0, 'a', 0, 0, '0'),
(146, 10, 'Karesi', 0, 'a', 0, 0, '0'),
(147, 11, 'Bilecik Merkez', 0, 'a', 0, 0, '0'),
(148, 11, 'Bozüyük', 0, 'a', 0, 0, '0'),
(149, 11, 'Gölpazarı', 0, 'a', 0, 0, '0'),
(150, 11, 'Osmaneli', 0, 'a', 0, 0, '0'),
(151, 11, 'Pazaryeri', 0, 'a', 0, 0, '0'),
(152, 11, 'Söğüt', 0, 'a', 0, 0, '0'),
(153, 11, 'Yenipazar / Bilecik', 0, 'a', 0, 0, '0'),
(154, 11, 'İnhisar', 0, 'a', 0, 0, '0'),
(155, 12, 'Bingöl Merkez', 0, 'a', 0, 0, '0'),
(156, 12, 'Genç', 0, 'a', 0, 0, '0'),
(157, 12, 'Karlıova', 0, 'a', 0, 0, '0'),
(158, 12, 'Kiğı', 0, 'a', 0, 0, '0'),
(159, 12, 'Solhan', 0, 'a', 0, 0, '0'),
(160, 12, 'Adaklı', 0, 'a', 0, 0, '0'),
(161, 12, 'Yayladere', 0, 'a', 0, 0, '0'),
(162, 12, 'Yedisu', 0, 'a', 0, 0, '0'),
(163, 13, 'Adilcevaz', 0, 'a', 0, 0, '0'),
(164, 13, 'Ahlat', 0, 'a', 0, 0, '0'),
(165, 13, 'Bitlis Merkez', 0, 'a', 0, 0, '0'),
(166, 13, 'Hizan', 0, 'a', 0, 0, '0'),
(167, 13, 'Mutki', 0, 'a', 0, 0, '0'),
(168, 13, 'Tatvan', 0, 'a', 0, 0, '0'),
(169, 13, 'Güroymak', 0, 'a', 0, 0, '0'),
(170, 14, 'Bolu Merkez', 0, 'a', 0, 0, '0'),
(171, 14, 'Gerede', 0, 'a', 0, 0, '0'),
(172, 14, 'Göynük', 0, 'a', 0, 0, '0'),
(173, 14, 'Kıbrıscık', 0, 'a', 0, 0, '0'),
(174, 14, 'Mengen', 0, 'a', 0, 0, '0'),
(175, 14, 'Mudurnu', 0, 'a', 0, 0, '0'),
(176, 14, 'Seben', 0, 'a', 0, 0, '0'),
(177, 14, 'Dörtdivan', 0, 'a', 0, 0, '0'),
(178, 14, 'Yeniçağa', 0, 'a', 0, 0, '0'),
(179, 15, 'Ağlasun', 0, 'a', 0, 0, '0'),
(180, 15, 'Bucak', 0, 'a', 0, 0, '0'),
(181, 15, 'Burdur Merkez', 0, 'a', 0, 0, '0'),
(182, 15, 'Gölhisar', 0, 'a', 0, 0, '0'),
(183, 15, 'Tefenni', 0, 'a', 0, 0, '0'),
(184, 15, 'Yeşilova', 0, 'a', 0, 0, '0'),
(185, 15, 'Karamanlı', 0, 'a', 0, 0, '0'),
(186, 15, 'Kemer / Burdur', 0, 'a', 0, 0, '0'),
(187, 15, 'Altınyayla / Burdur', 0, 'a', 0, 0, '0'),
(188, 15, 'Çavdır', 0, 'a', 0, 0, '0'),
(189, 15, 'Çeltikçi', 0, 'a', 0, 0, '0'),
(190, 16, 'Gemlik', 0, 'a', 0, 0, '0'),
(191, 16, 'İnegöl', 0, 'a', 0, 0, '0'),
(192, 16, 'İznik', 0, 'a', 0, 0, '0'),
(193, 16, 'Karacabey', 0, 'a', 0, 0, '0'),
(194, 16, 'Keles', 0, 'a', 0, 0, '0'),
(195, 16, 'Mudanya', 0, 'a', 0, 0, '0'),
(196, 16, 'Mustafakemalpaşa', 0, 'a', 0, 0, '0'),
(197, 16, 'Orhaneli', 0, 'a', 0, 0, '0'),
(198, 16, 'Orhangazi', 0, 'a', 0, 0, '0'),
(199, 16, 'Yenişehir / Bursa', 0, 'a', 0, 0, '0'),
(200, 16, 'Büyükorhan', 0, 'a', 0, 0, '0'),
(201, 16, 'Harmancık', 0, 'a', 0, 0, '0'),
(202, 16, 'Nilüfer', 0, 'a', 0, 0, '0'),
(203, 16, 'Osmangazi', 0, 'a', 0, 0, '0'),
(204, 16, 'Yıldırım', 0, 'a', 0, 0, '0'),
(205, 16, 'Gürsu', 0, 'a', 0, 0, '0'),
(206, 16, 'Kestel', 0, 'a', 0, 0, '0'),
(207, 17, 'Ayvacık / Çanakkale', 0, 'a', 0, 0, '0'),
(208, 17, 'Bayramiç', 0, 'a', 0, 0, '0'),
(209, 17, 'Biga', 0, 'a', 0, 0, '0'),
(210, 17, 'Bozcaada', 0, 'a', 0, 0, '0'),
(211, 17, 'Çan', 0, 'a', 0, 0, '0'),
(212, 17, 'Çanakkale Merkez', 0, 'a', 0, 0, '0'),
(213, 17, 'Eceabat', 0, 'a', 0, 0, '0'),
(214, 17, 'Ezine', 0, 'a', 0, 0, '0'),
(215, 17, 'Gelibolu', 0, 'a', 0, 0, '0'),
(216, 17, 'Gökçeada', 0, 'a', 0, 0, '0'),
(217, 17, 'Lapseki', 0, 'a', 0, 0, '0'),
(218, 17, 'Yenice / Çanakkale', 0, 'a', 0, 0, '0'),
(219, 18, 'Çankırı Merkez', 0, 'a', 0, 0, '0'),
(220, 18, 'Çerkeş', 0, 'a', 0, 0, '0'),
(221, 18, 'Eldivan', 0, 'a', 0, 0, '0'),
(222, 18, 'Ilgaz', 0, 'a', 0, 0, '0'),
(223, 18, 'Kurşunlu', 0, 'a', 0, 0, '0'),
(224, 18, 'Orta', 0, 'a', 0, 0, '0'),
(225, 18, 'Şabanözü', 0, 'a', 0, 0, '0'),
(226, 18, 'Yapraklı', 0, 'a', 0, 0, '0'),
(227, 18, 'Atkaracalar', 0, 'a', 0, 0, '0'),
(228, 18, 'Kızılırmak', 0, 'a', 0, 0, '0'),
(229, 18, 'Bayramören', 0, 'a', 0, 0, '0'),
(230, 18, 'Korgun', 0, 'a', 0, 0, '0'),
(231, 19, 'Alaca', 0, 'a', 0, 0, '0'),
(232, 19, 'Bayat / Çorum', 0, 'a', 0, 0, '0'),
(233, 19, 'Çorum Merkez', 0, 'a', 0, 0, '0'),
(234, 19, 'İskilip', 0, 'a', 0, 0, '0'),
(235, 19, 'Kargı', 0, 'a', 0, 0, '0'),
(236, 19, 'Mecitözü', 0, 'a', 0, 0, '0'),
(237, 19, 'Ortaköy / Çorum', 0, 'a', 0, 0, '0'),
(238, 19, 'Osmancık', 0, 'a', 0, 0, '0'),
(239, 19, 'Sungurlu', 0, 'a', 0, 0, '0'),
(240, 19, 'Boğazkale', 0, 'a', 0, 0, '0'),
(241, 19, 'Uğurludağ', 0, 'a', 0, 0, '0'),
(242, 19, 'Dodurga', 0, 'a', 0, 0, '0'),
(243, 19, 'Laçin', 0, 'a', 0, 0, '0'),
(244, 19, 'Oğuzlar', 0, 'a', 0, 0, '0'),
(245, 20, 'Acıpayam', 0, 'a', 0, 0, '0'),
(246, 20, 'Buldan', 0, 'a', 0, 0, '0'),
(247, 20, 'Çal', 0, 'a', 0, 0, '0'),
(248, 20, 'Çameli', 0, 'a', 0, 0, '0'),
(249, 20, 'Çardak', 0, 'a', 0, 0, '0'),
(250, 20, 'Çivril', 0, 'a', 0, 0, '0'),
(251, 20, 'Güney', 0, 'a', 0, 0, '0'),
(252, 20, 'Kale / Denizli', 0, 'a', 0, 0, '0'),
(253, 20, 'Sarayköy', 0, 'a', 0, 0, '0'),
(254, 20, 'Tavas', 0, 'a', 0, 0, '0'),
(255, 20, 'Babadağ', 0, 'a', 0, 0, '0'),
(256, 20, 'Bekilli', 0, 'a', 0, 0, '0'),
(257, 20, 'Honaz', 0, 'a', 0, 0, '0'),
(258, 20, 'Serinhisar', 0, 'a', 0, 0, '0'),
(259, 20, 'Pamukkale', 0, 'a', 0, 0, '0'),
(260, 20, 'Baklan', 0, 'a', 0, 0, '0'),
(261, 20, 'Beyağaç', 0, 'a', 0, 0, '0'),
(262, 20, 'Bozkurt / Denizli', 0, 'a', 0, 0, '0'),
(263, 20, 'Merkezefendi', 0, 'a', 0, 0, '0'),
(264, 21, 'Bismil', 0, 'a', 0, 0, '0'),
(265, 21, 'Çermik', 0, 'a', 0, 0, '0'),
(266, 21, 'Çınar', 0, 'a', 0, 0, '0'),
(267, 21, 'Çüngüş', 0, 'a', 0, 0, '0'),
(268, 21, 'Dicle', 0, 'a', 0, 0, '0'),
(269, 21, 'Ergani', 0, 'a', 0, 0, '0'),
(270, 21, 'Hani', 0, 'a', 0, 0, '0'),
(271, 21, 'Hazro', 0, 'a', 0, 0, '0'),
(272, 21, 'Kulp', 0, 'a', 0, 0, '0'),
(273, 21, 'Lice', 0, 'a', 0, 0, '0'),
(274, 21, 'Silvan', 0, 'a', 0, 0, '0'),
(275, 21, 'Eğil', 0, 'a', 0, 0, '0'),
(276, 21, 'Kocaköy', 0, 'a', 0, 0, '0'),
(277, 21, 'Bağlar', 0, 'a', 0, 0, '0'),
(278, 21, 'Kayapınar', 0, 'a', 0, 0, '0'),
(279, 21, 'Sur', 0, 'a', 0, 0, '0'),
(280, 21, 'Yenişehir / Diyarbakır', 0, 'a', 0, 0, '0'),
(281, 22, 'Edirne Merkez', 0, 'a', 0, 0, '0'),
(282, 22, 'Enez', 0, 'a', 0, 0, '0'),
(283, 22, 'Havsa', 0, 'a', 0, 0, '0'),
(284, 22, 'İpsala', 0, 'a', 0, 0, '0'),
(285, 22, 'Keşan', 0, 'a', 0, 0, '0'),
(286, 22, 'Lalapaşa', 0, 'a', 0, 0, '0'),
(287, 22, 'Meriç', 0, 'a', 0, 0, '0'),
(288, 22, 'Uzunköprü', 0, 'a', 0, 0, '0'),
(289, 22, 'Süloğlu', 0, 'a', 0, 0, '0'),
(290, 23, 'Ağın', 0, 'a', 0, 0, '0'),
(291, 23, 'Baskil', 0, 'a', 0, 0, '0'),
(292, 23, 'Elazığ Merkez', 0, 'a', 0, 0, '0'),
(293, 23, 'Karakoçan', 0, 'a', 0, 0, '0'),
(294, 23, 'Keban', 0, 'a', 0, 0, '0'),
(295, 23, 'Maden', 0, 'a', 0, 0, '0'),
(296, 23, 'Palu', 0, 'a', 0, 0, '0'),
(297, 23, 'Sivrice', 0, 'a', 0, 0, '0'),
(298, 23, 'Arıcak', 0, 'a', 0, 0, '0'),
(299, 23, 'Kovancılar', 0, 'a', 0, 0, '0'),
(300, 23, 'Alacakaya', 0, 'a', 0, 0, '0'),
(301, 24, 'Çayırlı', 0, 'a', 0, 0, '0'),
(302, 24, 'Erzincan Merkez', 0, 'a', 0, 0, '0'),
(303, 24, 'İliç', 0, 'a', 0, 0, '0'),
(304, 24, 'Kemah', 0, 'a', 0, 0, '0'),
(305, 24, 'Kemaliye', 0, 'a', 0, 0, '0'),
(306, 24, 'Refahiye', 0, 'a', 0, 0, '0'),
(307, 24, 'Tercan', 0, 'a', 0, 0, '0'),
(308, 24, 'Üzümlü', 0, 'a', 0, 0, '0'),
(309, 24, 'Otlukbeli', 0, 'a', 0, 0, '0'),
(310, 25, 'Aşkale', 0, 'a', 0, 0, '0'),
(311, 25, 'Çat', 0, 'a', 0, 0, '0'),
(312, 25, 'Hınıs', 0, 'a', 0, 0, '0'),
(313, 25, 'Horasan', 0, 'a', 0, 0, '0'),
(314, 25, 'İspir', 0, 'a', 0, 0, '0'),
(315, 25, 'Karayazı', 0, 'a', 0, 0, '0'),
(316, 25, 'Narman', 0, 'a', 0, 0, '0'),
(317, 25, 'Oltu', 0, 'a', 0, 0, '0'),
(318, 25, 'Olur', 0, 'a', 0, 0, '0'),
(319, 25, 'Pasinler', 0, 'a', 0, 0, '0'),
(320, 25, 'Şenkaya', 0, 'a', 0, 0, '0'),
(321, 25, 'Tekman', 0, 'a', 0, 0, '0'),
(322, 25, 'Tortum', 0, 'a', 0, 0, '0'),
(323, 25, 'Karaçoban', 0, 'a', 0, 0, '0'),
(324, 25, 'Uzundere', 0, 'a', 0, 0, '0'),
(325, 25, 'Pazaryolu', 0, 'a', 0, 0, '0'),
(326, 25, 'Aziziye', 0, 'a', 0, 0, '0'),
(327, 25, 'Köprüköy', 0, 'a', 0, 0, '0'),
(328, 25, 'Palandöken', 0, 'a', 0, 0, '0'),
(329, 25, 'Yakutiye', 0, 'a', 0, 0, '0'),
(330, 26, 'Çifteler', 0, 'a', 0, 0, '0'),
(331, 26, 'Mahmudiye', 0, 'a', 0, 0, '0'),
(332, 26, 'Mihalıççık', 0, 'a', 0, 0, '0'),
(333, 26, 'Sarıcakaya', 0, 'a', 0, 0, '0'),
(334, 26, 'Seyitgazi', 0, 'a', 0, 0, '0'),
(335, 26, 'Sivrihisar', 0, 'a', 0, 0, '0'),
(336, 26, 'Alpu', 0, 'a', 0, 0, '0'),
(337, 26, 'Beylikova', 0, 'a', 0, 0, '0'),
(338, 26, 'İnönü', 0, 'a', 0, 0, '0'),
(339, 26, 'Günyüzü', 0, 'a', 0, 0, '0'),
(340, 26, 'Han', 0, 'a', 0, 0, '0'),
(341, 26, 'Mihalgazi', 0, 'a', 0, 0, '0'),
(342, 26, 'Odunpazarı', 0, 'a', 0, 0, '0'),
(343, 26, 'Tepebaşı', 0, 'a', 0, 0, '0'),
(344, 27, 'Araban', 0, 'a', 0, 0, '0'),
(345, 27, 'İslahiye', 0, 'a', 0, 0, '0'),
(346, 27, 'Nizip', 0, 'a', 0, 0, '0'),
(347, 27, 'Oğuzeli', 0, 'a', 0, 0, '0'),
(348, 27, 'Yavuzeli', 0, 'a', 0, 0, '0'),
(349, 27, 'Şahinbey', 0, 'a', 0, 0, '0'),
(350, 27, 'Şehitkamil', 0, 'a', 0, 0, '0'),
(351, 27, 'Karkamış', 0, 'a', 0, 0, '0'),
(352, 27, 'Nurdağı', 0, 'a', 0, 0, '0'),
(353, 28, 'Alucra', 0, 'a', 0, 0, '0'),
(354, 28, 'Bulancak', 0, 'a', 0, 0, '0'),
(355, 28, 'Dereli', 0, 'a', 0, 0, '0'),
(356, 28, 'Espiye', 0, 'a', 0, 0, '0'),
(357, 28, 'Eynesil', 0, 'a', 0, 0, '0'),
(358, 28, 'Giresun Merkez', 0, 'a', 0, 0, '0'),
(359, 28, 'Görele', 0, 'a', 0, 0, '0'),
(360, 28, 'Keşap', 0, 'a', 0, 0, '0'),
(361, 28, 'Şebinkarahisar', 0, 'a', 0, 0, '0'),
(362, 28, 'Tirebolu', 0, 'a', 0, 0, '0'),
(363, 28, 'Piraziz', 0, 'a', 0, 0, '0'),
(364, 28, 'Yağlıdere', 0, 'a', 0, 0, '0'),
(365, 28, 'Çamoluk', 0, 'a', 0, 0, '0'),
(366, 28, 'Çanakçı', 0, 'a', 0, 0, '0'),
(367, 28, 'Doğankent', 0, 'a', 0, 0, '0'),
(368, 28, 'Güce', 0, 'a', 0, 0, '0'),
(369, 29, 'Gümüşhane Merkez', 0, 'a', 0, 0, '0'),
(370, 29, 'Kelkit', 0, 'a', 0, 0, '0'),
(371, 29, 'Şiran', 0, 'a', 0, 0, '0'),
(372, 29, 'Torul', 0, 'a', 0, 0, '0'),
(373, 29, 'Köse', 0, 'a', 0, 0, '0'),
(374, 29, 'Kürtün', 0, 'a', 0, 0, '0'),
(375, 30, 'Çukurca', 0, 'a', 0, 0, '0'),
(376, 30, 'Hakkari Merkez', 0, 'a', 0, 0, '0'),
(377, 30, 'Şemdinli', 0, 'a', 0, 0, '0'),
(378, 30, 'Yüksekova', 0, 'a', 0, 0, '0'),
(379, 31, 'Altınözü', 0, 'a', 0, 0, '0'),
(380, 31, 'Dörtyol', 0, 'a', 0, 0, '0'),
(381, 31, 'Hassa', 0, 'a', 0, 0, '0'),
(382, 31, 'İskenderun', 0, 'a', 0, 0, '0'),
(383, 31, 'Kırıkhan', 0, 'a', 0, 0, '0'),
(384, 31, 'Reyhanlı', 0, 'a', 0, 0, '0'),
(385, 31, 'Samandağ', 0, 'a', 0, 0, '0'),
(386, 31, 'Yayladağı', 0, 'a', 0, 0, '0'),
(387, 31, 'Erzin', 0, 'a', 0, 0, '0'),
(388, 31, 'Belen', 0, 'a', 0, 0, '0'),
(389, 31, 'Kumlu', 0, 'a', 0, 0, '0'),
(390, 31, 'Antakya', 0, 'a', 0, 0, '0'),
(391, 31, 'Arsuz', 0, 'a', 0, 0, '0'),
(392, 31, 'Defne', 0, 'a', 0, 0, '0'),
(393, 31, 'Payas', 0, 'a', 0, 0, '0'),
(394, 32, 'Atabey', 0, 'a', 0, 0, '0'),
(395, 32, 'Eğirdir', 0, 'a', 0, 0, '0'),
(396, 32, 'Gelendost', 0, 'a', 0, 0, '0'),
(397, 32, 'Isparta Merkez', 0, 'a', 0, 0, '0'),
(398, 32, 'Keçiborlu', 0, 'a', 0, 0, '0'),
(399, 32, 'Senirkent', 0, 'a', 0, 0, '0'),
(400, 32, 'Sütçüler', 0, 'a', 0, 0, '0'),
(401, 32, 'Şarkikaraağaç', 0, 'a', 0, 0, '0'),
(402, 32, 'Uluborlu', 0, 'a', 0, 0, '0'),
(403, 32, 'Yalvaç', 0, 'a', 0, 0, '0'),
(404, 32, 'Aksu / Isparta', 0, 'a', 0, 0, '0'),
(405, 32, 'Gönen / Isparta', 0, 'a', 0, 0, '0'),
(406, 32, 'Yenişarbademli', 0, 'a', 0, 0, '0'),
(407, 33, 'Anamur', 0, 'a', 0, 0, '0'),
(408, 33, 'Erdemli', 0, 'a', 0, 0, '0'),
(409, 33, 'Gülnar', 0, 'a', 0, 0, '0'),
(410, 33, 'Mut', 0, 'a', 0, 0, '0'),
(411, 33, 'Silifke', 0, 'a', 0, 0, '0'),
(412, 33, 'Tarsus', 0, 'a', 0, 0, '0'),
(413, 33, 'Aydıncık / Mersin', 0, 'a', 0, 0, '0'),
(414, 33, 'Bozyazı', 0, 'a', 0, 0, '0'),
(415, 33, 'Çamlıyayla', 0, 'a', 0, 0, '0'),
(416, 33, 'Akdeniz', 0, 'a', 0, 0, '0'),
(417, 33, 'Mezitli', 0, 'a', 0, 0, '0'),
(418, 33, 'Toroslar', 0, 'a', 0, 0, '0'),
(419, 33, 'Yenişehir / Mersin', 0, 'a', 0, 0, '0'),
(420, 34, 'Adalar', 0, 'a', 0, 0, '0'),
(421, 34, 'Bakırköy', 0, 'a', 0, 0, '0'),
(422, 34, 'Beşiktaş', 0, 'a', 0, 0, '0'),
(423, 34, 'Beykoz', 0, 'a', 0, 0, '0'),
(424, 34, 'Beyoğlu', 0, 'a', 0, 0, '0'),
(425, 34, 'Çatalca', 0, 'a', 0, 0, '0'),
(426, 34, 'Eyüp', 0, 'a', 0, 0, '0'),
(427, 34, 'Fatih', 0, 'a', 0, 0, '0'),
(428, 34, 'Gaziosmanpaşa', 0, 'a', 0, 0, '0'),
(429, 34, 'Kadıköy', 0, 'a', 0, 0, '0'),
(430, 34, 'Kartal', 0, 'a', 0, 0, '0'),
(431, 34, 'Sarıyer', 0, 'a', 0, 0, '0'),
(432, 34, 'Silivri', 0, 'a', 0, 0, '0'),
(433, 34, 'Şile', 0, 'a', 0, 0, '0'),
(434, 34, 'Şişli', 0, 'a', 0, 0, '0'),
(435, 34, 'Üsküdar', 0, 'a', 0, 0, '0'),
(436, 34, 'Zeytinburnu', 0, 'a', 0, 0, '0'),
(437, 34, 'Büyükçekmece', 0, 'a', 0, 0, '0'),
(438, 34, 'Kağıthane', 0, 'a', 0, 0, '0'),
(439, 34, 'Küçükçekmece', 0, 'a', 0, 0, '0'),
(440, 34, 'Pendik', 0, 'a', 0, 0, '0'),
(441, 34, 'Ümraniye', 0, 'a', 0, 0, '0'),
(442, 34, 'Bayrampaşa', 0, 'a', 0, 0, '0'),
(443, 34, 'Avcılar', 0, 'a', 0, 0, '0'),
(444, 34, 'Bağcılar', 0, 'a', 0, 0, '0'),
(445, 34, 'Bahçelievler', 0, 'a', 0, 0, '0'),
(446, 34, 'Güngören', 0, 'a', 0, 0, '0'),
(447, 34, 'Maltepe', 0, 'a', 0, 0, '0'),
(448, 34, 'Sultanbeyli', 0, 'a', 0, 0, '0'),
(449, 34, 'Tuzla', 0, 'a', 0, 0, '0'),
(450, 34, 'Esenler', 0, 'a', 0, 0, '0'),
(451, 34, 'Arnavutköy', 0, 'a', 0, 0, '0'),
(452, 34, 'Ataşehir', 0, 'a', 0, 0, '0'),
(453, 34, 'Başakşehir', 0, 'a', 0, 0, '0'),
(454, 34, 'Beylikdüzü', 0, 'a', 0, 0, '0'),
(455, 34, 'Çekmeköy', 0, 'a', 0, 0, '0'),
(456, 34, 'Esenyurt', 0, 'a', 0, 0, '0'),
(457, 34, 'Sancaktepe', 0, 'a', 0, 0, '0'),
(458, 34, 'Sultangazi', 0, 'a', 0, 0, '0'),
(459, 35, 'Aliağa', 0, 'a', 0, 0, '0'),
(460, 35, 'Bayındır', 0, 'a', 0, 0, '0'),
(461, 35, 'Bergama', 0, 'a', 0, 0, '0'),
(462, 35, 'Bornova', 0, 'a', 0, 0, '0'),
(463, 35, 'Çeşme', 0, 'a', 0, 0, '0'),
(464, 35, 'Dikili', 0, 'a', 0, 0, '0'),
(465, 35, 'Foça', 0, 'a', 0, 0, '0'),
(466, 35, 'Karaburun', 0, 'a', 0, 0, '0'),
(467, 35, 'Karşıyaka', 0, 'a', 0, 0, '0'),
(468, 35, 'Kemalpaşa', 0, 'a', 0, 0, '0'),
(469, 35, 'Kınık', 0, 'a', 0, 0, '0'),
(470, 35, 'Kiraz', 0, 'a', 0, 0, '0'),
(471, 35, 'Menemen', 0, 'a', 0, 0, '0'),
(472, 35, 'Ödemiş', 0, 'a', 0, 0, '0'),
(473, 35, 'Seferihisar', 0, 'a', 0, 0, '0'),
(474, 35, 'Selçuk', 0, 'a', 0, 0, '0'),
(475, 35, 'Tire', 0, 'a', 0, 0, '0'),
(476, 35, 'Torbalı', 0, 'a', 0, 0, '0'),
(477, 35, 'Urla', 0, 'a', 0, 0, '0'),
(478, 35, 'Beydağ', 0, 'a', 0, 0, '0'),
(479, 35, 'Buca', 0, 'a', 0, 0, '0'),
(480, 35, 'Konak', 0, 'a', 0, 0, '0'),
(481, 35, 'Menderes', 0, 'a', 0, 0, '0'),
(482, 35, 'Balçova', 0, 'a', 0, 0, '0'),
(483, 35, 'Çiğli', 0, 'a', 0, 0, '0'),
(484, 35, 'Gaziemir', 0, 'a', 0, 0, '0'),
(485, 35, 'Narlıdere', 0, 'a', 0, 0, '0'),
(486, 35, 'Güzelbahçe', 0, 'a', 0, 0, '0'),
(487, 35, 'Bayraklı', 0, 'a', 0, 0, '0'),
(488, 35, 'Karabağlar', 0, 'a', 0, 0, '0'),
(489, 36, 'Arpaçay', 0, 'a', 0, 0, '0'),
(490, 36, 'Digor', 0, 'a', 0, 0, '0'),
(491, 36, 'Kağızman', 0, 'a', 0, 0, '0'),
(492, 36, 'Kars Merkez', 0, 'a', 0, 0, '0'),
(493, 36, 'Sarıkamış', 0, 'a', 0, 0, '0'),
(494, 36, 'Selim', 0, 'a', 0, 0, '0'),
(495, 36, 'Susuz', 0, 'a', 0, 0, '0'),
(496, 36, 'Akyaka', 0, 'a', 0, 0, '0'),
(497, 37, 'Abana', 0, 'a', 0, 0, '0'),
(498, 37, 'Araç', 0, 'a', 0, 0, '0'),
(499, 37, 'Azdavay', 0, 'a', 0, 0, '0'),
(500, 37, 'Bozkurt / Kastamonu', 0, 'a', 0, 0, '0'),
(501, 37, 'Cide', 0, 'a', 0, 0, '0'),
(502, 37, 'Çatalzeytin', 0, 'a', 0, 0, '0'),
(503, 37, 'Daday', 0, 'a', 0, 0, '0'),
(504, 37, 'Devrekani', 0, 'a', 0, 0, '0'),
(505, 37, 'İnebolu', 0, 'a', 0, 0, '0'),
(506, 37, 'Kastamonu Merkez', 0, 'a', 0, 0, '0'),
(507, 37, 'Küre', 0, 'a', 0, 0, '0'),
(508, 37, 'Taşköprü', 0, 'a', 0, 0, '0'),
(509, 37, 'Tosya', 0, 'a', 0, 0, '0'),
(510, 37, 'İhsangazi', 0, 'a', 0, 0, '0'),
(511, 37, 'Pınarbaşı / Kastamonu', 0, 'a', 0, 0, '0'),
(512, 37, 'Şenpazar', 0, 'a', 0, 0, '0'),
(513, 37, 'Ağlı', 0, 'a', 0, 0, '0'),
(514, 37, 'Doğanyurt', 0, 'a', 0, 0, '0'),
(515, 37, 'Hanönü', 0, 'a', 0, 0, '0'),
(516, 37, 'Seydiler', 0, 'a', 0, 0, '0'),
(517, 38, 'Bünyan', 0, 'a', 0, 0, '0'),
(518, 38, 'Develi', 0, 'a', 0, 0, '0'),
(519, 38, 'Felahiye', 0, 'a', 0, 0, '0'),
(520, 38, 'İncesu', 0, 'a', 0, 0, '0'),
(521, 38, 'Pınarbaşı / Kayseri', 0, 'a', 0, 0, '0'),
(522, 38, 'Sarıoğlan', 0, 'a', 0, 0, '0'),
(523, 38, 'Sarız', 0, 'a', 0, 0, '0'),
(524, 38, 'Tomarza', 0, 'a', 0, 0, '0'),
(525, 38, 'Yahyalı', 0, 'a', 0, 0, '0'),
(526, 38, 'Yeşilhisar', 0, 'a', 0, 0, '0'),
(527, 38, 'Akkışla', 0, 'a', 0, 0, '0'),
(528, 38, 'Talas', 0, 'a', 0, 0, '0'),
(529, 38, 'Kocasinan', 0, 'a', 0, 0, '0'),
(530, 38, 'Melikgazi', 0, 'a', 0, 0, '0'),
(531, 38, 'Hacılar', 0, 'a', 0, 0, '0'),
(532, 38, 'Özvatan', 0, 'a', 0, 0, '0'),
(533, 39, 'Babaeski', 0, 'a', 0, 0, '0'),
(534, 39, 'Demirköy', 0, 'a', 0, 0, '0'),
(535, 39, 'Kırklareli Merkez', 0, 'a', 0, 0, '0'),
(536, 39, 'Kofçaz', 0, 'a', 0, 0, '0'),
(537, 39, 'Lüleburgaz', 0, 'a', 0, 0, '0'),
(538, 39, 'Pehlivanköy', 0, 'a', 0, 0, '0'),
(539, 39, 'Pınarhisar', 0, 'a', 0, 0, '0'),
(540, 39, 'Vize', 0, 'a', 0, 0, '0'),
(541, 40, 'Çiçekdağı', 0, 'a', 0, 0, '0'),
(542, 40, 'Kaman', 0, 'a', 0, 0, '0'),
(543, 40, 'Kırşehir Merkez', 0, 'a', 0, 0, '0'),
(544, 40, 'Mucur', 0, 'a', 0, 0, '0'),
(545, 40, 'Akpınar', 0, 'a', 0, 0, '0'),
(546, 40, 'Akçakent', 0, 'a', 0, 0, '0'),
(547, 40, 'Boztepe', 0, 'a', 0, 0, '0'),
(548, 41, 'Gebze', 0, 'a', 0, 0, '0'),
(549, 41, 'Gölcük', 0, 'a', 0, 0, '0'),
(550, 41, 'Kandıra', 0, 'a', 0, 0, '0'),
(551, 41, 'Karamürsel', 0, 'a', 0, 0, '0'),
(552, 41, 'Körfez', 0, 'a', 0, 0, '0'),
(553, 41, 'Derince', 0, 'a', 0, 0, '0'),
(554, 41, 'Başiskele', 0, 'a', 0, 0, '0'),
(555, 41, 'Çayırova', 0, 'a', 0, 0, '0'),
(556, 41, 'Darıca', 0, 'a', 0, 0, '0'),
(557, 41, 'Dilovası', 0, 'a', 0, 0, '0'),
(558, 41, 'İzmit', 0, 'a', 0, 0, '0'),
(559, 41, 'Kartepe', 0, 'a', 0, 0, '0'),
(560, 42, 'Akşehir', 0, 'a', 0, 0, '0'),
(561, 42, 'Beyşehir', 0, 'a', 0, 0, '0'),
(562, 42, 'Bozkır', 0, 'a', 0, 0, '0'),
(563, 42, 'Cihanbeyli', 0, 'a', 0, 0, '0'),
(564, 42, 'Çumra', 0, 'a', 0, 0, '0'),
(565, 42, 'Doğanhisar', 0, 'a', 0, 0, '0'),
(566, 42, 'Ereğli / Konya', 0, 'a', 0, 0, '0'),
(567, 42, 'Hadim', 0, 'a', 0, 0, '0'),
(568, 42, 'Ilgın', 0, 'a', 0, 0, '0'),
(569, 42, 'Kadınhanı', 0, 'a', 0, 0, '0'),
(570, 42, 'Karapınar', 0, 'a', 0, 0, '0'),
(571, 42, 'Kulu', 0, 'a', 0, 0, '0'),
(572, 42, 'Sarayönü', 0, 'a', 0, 0, '0'),
(573, 42, 'Seydişehir', 0, 'a', 0, 0, '0'),
(574, 42, 'Yunak', 0, 'a', 0, 0, '0'),
(575, 42, 'Akören', 0, 'a', 0, 0, '0'),
(576, 42, 'Altınekin', 0, 'a', 0, 0, '0'),
(577, 42, 'Derebucak', 0, 'a', 0, 0, '0'),
(578, 42, 'Hüyük', 0, 'a', 0, 0, '0'),
(579, 42, 'Karatay', 0, 'a', 0, 0, '0'),
(580, 42, 'Meram', 0, 'a', 0, 0, '0'),
(581, 42, 'Selçuklu', 0, 'a', 0, 0, '0'),
(582, 42, 'Taşkent', 0, 'a', 0, 0, '0'),
(583, 42, 'Ahırlı', 0, 'a', 0, 0, '0'),
(584, 42, 'Çeltik', 0, 'a', 0, 0, '0'),
(585, 42, 'Derbent', 0, 'a', 0, 0, '0'),
(586, 42, 'Emirgazi', 0, 'a', 0, 0, '0'),
(587, 42, 'Güneysınır', 0, 'a', 0, 0, '0'),
(588, 42, 'Halkapınar', 0, 'a', 0, 0, '0'),
(589, 42, 'Tuzlukçu', 0, 'a', 0, 0, '0'),
(590, 42, 'Yalıhüyük', 0, 'a', 0, 0, '0'),
(591, 43, 'Altıntaş', 0, 'a', 0, 0, '0'),
(592, 43, 'Domaniç', 0, 'a', 0, 0, '0'),
(593, 43, 'Emet', 0, 'a', 0, 0, '0'),
(594, 43, 'Gediz', 0, 'a', 0, 0, '0'),
(595, 43, 'Kütahya Merkez', 0, 'a', 0, 0, '0'),
(596, 43, 'Simav', 0, 'a', 0, 0, '0'),
(597, 43, 'Tavşanlı', 0, 'a', 0, 0, '0'),
(598, 43, 'Aslanapa', 0, 'a', 0, 0, '0'),
(599, 43, 'Dumlupınar', 0, 'a', 0, 0, '0'),
(600, 43, 'Hisarcık', 0, 'a', 0, 0, '0'),
(601, 43, 'Şaphane', 0, 'a', 0, 0, '0'),
(602, 43, 'Çavdarhisar', 0, 'a', 0, 0, '0'),
(603, 43, 'Pazarlar', 0, 'a', 0, 0, '0'),
(604, 44, 'Akçadağ', 0, 'a', 0, 0, '0'),
(605, 44, 'Arapgir', 0, 'a', 0, 0, '0'),
(606, 44, 'Arguvan', 0, 'a', 0, 0, '0'),
(607, 44, 'Darende', 0, 'a', 0, 0, '0'),
(608, 44, 'Doğanşehir', 0, 'a', 0, 0, '0'),
(609, 44, 'Hekimhan', 0, 'a', 0, 0, '0'),
(610, 44, 'Pütürge', 0, 'a', 0, 0, '0'),
(611, 44, 'Yeşilyurt / Malatya', 0, 'a', 0, 0, '0'),
(612, 44, 'Battalgazi', 0, 'a', 0, 0, '0'),
(613, 44, 'Doğanyol', 0, 'a', 0, 0, '0'),
(614, 44, 'Kale / Malatya', 0, 'a', 0, 0, '0'),
(615, 44, 'Kuluncak', 0, 'a', 0, 0, '0'),
(616, 44, 'Yazıhan', 0, 'a', 0, 0, '0'),
(617, 45, 'Akhisar', 0, 'a', 0, 0, '0'),
(618, 45, 'Alaşehir', 0, 'a', 0, 0, '0'),
(619, 45, 'Demirci', 0, 'a', 0, 0, '0'),
(620, 45, 'Gördes', 0, 'a', 0, 0, '0'),
(621, 45, 'Kırkağaç', 0, 'a', 0, 0, '0'),
(622, 45, 'Kula', 0, 'a', 0, 0, '0'),
(623, 45, 'Salihli', 0, 'a', 0, 0, '0'),
(624, 45, 'Sarıgöl', 0, 'a', 0, 0, '0'),
(625, 45, 'Saruhanlı', 0, 'a', 0, 0, '0'),
(626, 45, 'Selendi', 0, 'a', 0, 0, '0'),
(627, 45, 'Soma', 0, 'a', 0, 0, '0'),
(628, 45, 'Turgutlu', 0, 'a', 0, 0, '0'),
(629, 45, 'Ahmetli', 0, 'a', 0, 0, '0'),
(630, 45, 'Gölmarmara', 0, 'a', 0, 0, '0'),
(631, 45, 'Köprübaşı / Manisa', 0, 'a', 0, 0, '0'),
(632, 45, 'Şehzadeler', 0, 'a', 0, 0, '0'),
(633, 45, 'Yunusemre', 0, 'a', 0, 0, '0'),
(634, 46, 'Afşin', 0, 'a', 0, 0, '0'),
(635, 46, 'Andırın', 0, 'a', 0, 0, '0'),
(636, 46, 'Elbistan', 0, 'a', 0, 0, '0'),
(637, 46, 'Göksun', 0, 'a', 0, 0, '0'),
(638, 46, 'Pazarcık', 0, 'a', 0, 0, '0'),
(639, 46, 'Türkoğlu', 0, 'a', 0, 0, '0'),
(640, 46, 'Çağlayancerit', 0, 'a', 0, 0, '0'),
(641, 46, 'Ekinözü', 0, 'a', 0, 0, '0'),
(642, 46, 'Nurhak', 0, 'a', 0, 0, '0'),
(643, 46, 'Dulkadiroğlu', 0, 'a', 0, 0, '0'),
(644, 46, 'Onikişubat', 0, 'a', 0, 0, '0'),
(645, 47, 'Derik', 0, 'a', 0, 0, '0'),
(646, 47, 'Kızıltepe', 0, 'a', 0, 0, '0'),
(647, 47, 'Mazıdağı', 0, 'a', 0, 0, '0'),
(648, 47, 'Midyat', 0, 'a', 0, 0, '0'),
(649, 47, 'Nusaybin', 0, 'a', 0, 0, '0'),
(650, 47, 'Ömerli', 0, 'a', 0, 0, '0'),
(651, 47, 'Savur', 0, 'a', 0, 0, '0'),
(652, 47, 'Dargeçit', 0, 'a', 0, 0, '0'),
(653, 47, 'Yeşilli', 0, 'a', 0, 0, '0'),
(654, 47, 'Artuklu', 0, 'a', 0, 0, '0'),
(655, 48, 'Bodrum', 0, 'a', 0, 0, '0'),
(656, 48, 'Datça', 0, 'a', 0, 0, '0'),
(657, 48, 'Fethiye', 0, 'a', 0, 0, '0'),
(658, 48, 'Köyceğiz', 0, 'a', 0, 0, '0'),
(659, 48, 'Marmaris', 0, 'a', 0, 0, '0'),
(660, 48, 'Milas', 0, 'a', 0, 0, '0'),
(661, 48, 'Ula', 0, 'a', 0, 0, '0'),
(662, 48, 'Yatağan', 0, 'a', 0, 0, '0'),
(663, 48, 'Dalaman', 0, 'a', 0, 0, '0'),
(664, 48, 'Ortaca', 0, 'a', 0, 0, '0'),
(665, 48, 'Kavaklıdere', 0, 'a', 0, 0, '0'),
(666, 48, 'Menteşe', 0, 'a', 0, 0, '0'),
(667, 48, 'Seydikemer', 0, 'a', 0, 0, '0'),
(668, 49, 'Bulanık', 0, 'a', 0, 0, '0'),
(669, 49, 'Malazgirt', 0, 'a', 0, 0, '0'),
(670, 49, 'Muş Merkez', 0, 'a', 0, 0, '0'),
(671, 49, 'Varto', 0, 'a', 0, 0, '0'),
(672, 49, 'Hasköy', 0, 'a', 0, 0, '0'),
(673, 49, 'Korkut', 0, 'a', 0, 0, '0'),
(674, 50, 'Avanos', 0, 'a', 0, 0, '0'),
(675, 50, 'Derinkuyu', 0, 'a', 0, 0, '0'),
(676, 50, 'Gülşehir', 0, 'a', 0, 0, '0'),
(677, 50, 'Hacıbektaş', 0, 'a', 0, 0, '0'),
(678, 50, 'Kozaklı', 0, 'a', 0, 0, '0'),
(679, 50, 'Nevşehir Merkez', 0, 'a', 0, 0, '0'),
(680, 50, 'Ürgüp', 0, 'a', 0, 0, '0'),
(681, 50, 'Acıgöl', 0, 'a', 0, 0, '0'),
(682, 51, 'Bor', 0, 'a', 0, 0, '0'),
(683, 51, 'Çamardı', 0, 'a', 0, 0, '0'),
(684, 51, 'Niğde Merkez', 0, 'a', 0, 0, '0'),
(685, 51, 'Ulukışla', 0, 'a', 0, 0, '0'),
(686, 51, 'Altunhisar', 0, 'a', 0, 0, '0'),
(687, 51, 'Çiftlik', 0, 'a', 0, 0, '0'),
(688, 52, 'Akkuş', 0, 'a', 0, 0, '0'),
(689, 52, 'Aybastı', 0, 'a', 0, 0, '0'),
(690, 52, 'Fatsa', 0, 'a', 0, 0, '0'),
(691, 52, 'Gölköy', 0, 'a', 0, 0, '0'),
(692, 52, 'Korgan', 0, 'a', 0, 0, '0'),
(693, 52, 'Kumru', 0, 'a', 0, 0, '0'),
(694, 52, 'Mesudiye', 0, 'a', 0, 0, '0'),
(695, 52, 'Perşembe', 0, 'a', 0, 0, '0'),
(696, 52, 'Ulubey / Ordu', 0, 'a', 0, 0, '0'),
(697, 52, 'Ünye', 0, 'a', 0, 0, '0'),
(698, 52, 'Gülyalı', 0, 'a', 0, 0, '0'),
(699, 52, 'Gürgentepe', 0, 'a', 0, 0, '0'),
(700, 52, 'Çamaş', 0, 'a', 0, 0, '0'),
(701, 52, 'Çatalpınar', 0, 'a', 0, 0, '0'),
(702, 52, 'Çaybaşı', 0, 'a', 0, 0, '0'),
(703, 52, 'İkizce', 0, 'a', 0, 0, '0'),
(704, 52, 'Kabadüz', 0, 'a', 0, 0, '0'),
(705, 52, 'Kabataş', 0, 'a', 0, 0, '0'),
(706, 52, 'Altınordu', 0, 'a', 0, 0, '0'),
(707, 53, 'Ardeşen', 0, 'a', 0, 0, '0'),
(708, 53, 'Çamlıhemşin', 0, 'a', 0, 0, '0'),
(709, 53, 'Çayeli', 0, 'a', 0, 0, '0'),
(710, 53, 'Fındıklı', 0, 'a', 0, 0, '0'),
(711, 53, 'İkizdere', 0, 'a', 0, 0, '0'),
(712, 53, 'Kalkandere', 0, 'a', 0, 0, '0'),
(713, 53, 'Pazar / Rize', 0, 'a', 0, 0, '0'),
(714, 53, 'Rize Merkez', 0, 'a', 0, 0, '0'),
(715, 53, 'Güneysu', 0, 'a', 0, 0, '0'),
(716, 53, 'Derepazarı', 0, 'a', 0, 0, '0'),
(717, 53, 'Hemşin', 0, 'a', 0, 0, '0'),
(718, 53, 'İyidere', 0, 'a', 0, 0, '0'),
(719, 54, 'Akyazı', 0, 'a', 0, 0, '0'),
(720, 54, 'Geyve', 0, 'a', 0, 0, '0'),
(721, 54, 'Hendek', 0, 'a', 0, 0, '0'),
(722, 54, 'Karasu', 0, 'a', 0, 0, '0'),
(723, 54, 'Kaynarca', 0, 'a', 0, 0, '0'),
(724, 54, 'Sapanca', 0, 'a', 0, 0, '0'),
(725, 54, 'Kocaali', 0, 'a', 0, 0, '0'),
(726, 54, 'Pamukova', 0, 'a', 0, 0, '0'),
(727, 54, 'Taraklı', 0, 'a', 0, 0, '0'),
(728, 54, 'Ferizli', 0, 'a', 0, 0, '0'),
(729, 54, 'Karapürçek', 0, 'a', 0, 0, '0'),
(730, 54, 'Söğütlü', 0, 'a', 0, 0, '0'),
(731, 54, 'Adapazarı', 0, 'a', 0, 0, '0'),
(732, 54, 'Arifiye', 0, 'a', 0, 0, '0'),
(733, 54, 'Erenler', 0, 'a', 0, 0, '0'),
(734, 54, 'Serdivan', 0, 'a', 0, 0, '0'),
(735, 55, 'Alaçam', 0, 'a', 0, 0, '0'),
(736, 55, 'Bafra', 0, 'a', 0, 0, '0'),
(737, 55, 'Çarşamba', 0, 'a', 0, 0, '0'),
(738, 55, 'Havza', 0, 'a', 0, 0, '0'),
(739, 55, 'Kavak', 0, 'a', 0, 0, '0'),
(740, 55, 'Ladik', 0, 'a', 0, 0, '0'),
(741, 55, 'Terme', 0, 'a', 0, 0, '0'),
(742, 55, 'Vezirköprü', 0, 'a', 0, 0, '0'),
(743, 55, 'Asarcık', 0, 'a', 0, 0, '0'),
(744, 55, '19 Mayıs', 0, 'a', 0, 0, '0'),
(745, 55, 'Salıpazarı', 0, 'a', 0, 0, '0'),
(746, 55, 'Tekkeköy', 0, 'a', 0, 0, '0'),
(747, 55, 'Ayvacık / Samsun', 0, 'a', 0, 0, '0'),
(748, 55, 'Yakakent', 0, 'a', 0, 0, '0'),
(749, 55, 'Atakum', 0, 'a', 0, 0, '0'),
(750, 55, 'Canik', 0, 'a', 0, 0, '0'),
(751, 55, 'İlkadım', 0, 'a', 0, 0, '0'),
(752, 56, 'Baykan', 0, 'a', 0, 0, '0'),
(753, 56, 'Eruh', 0, 'a', 0, 0, '0'),
(754, 56, 'Kurtalan', 0, 'a', 0, 0, '0'),
(755, 56, 'Pervari', 0, 'a', 0, 0, '0'),
(756, 56, 'Siirt Merkez', 0, 'a', 0, 0, '0'),
(757, 56, 'Şirvan', 0, 'a', 0, 0, '0'),
(758, 56, 'Tillo', 0, 'a', 0, 0, '0'),
(759, 57, 'Ayancık', 0, 'a', 0, 0, '0'),
(760, 57, 'Boyabat', 0, 'a', 0, 0, '0'),
(761, 57, 'Durağan', 0, 'a', 0, 0, '0'),
(762, 57, 'Erfelek', 0, 'a', 0, 0, '0'),
(763, 57, 'Gerze', 0, 'a', 0, 0, '0'),
(764, 57, 'Sinop Merkez', 0, 'a', 0, 0, '0'),
(765, 57, 'Türkeli', 0, 'a', 0, 0, '0'),
(766, 57, 'Dikmen', 0, 'a', 0, 0, '0'),
(767, 57, 'Saraydüzü', 0, 'a', 0, 0, '0'),
(768, 58, 'Divriği', 0, 'a', 0, 0, '0'),
(769, 58, 'Gemerek', 0, 'a', 0, 0, '0'),
(770, 58, 'Gürün', 0, 'a', 0, 0, '0'),
(771, 58, 'Hafik', 0, 'a', 0, 0, '0'),
(772, 58, 'İmranlı', 0, 'a', 0, 0, '0'),
(773, 58, 'Kangal', 0, 'a', 0, 0, '0'),
(774, 58, 'Koyulhisar', 0, 'a', 0, 0, '0'),
(775, 58, 'Sivas Merkez', 0, 'a', 0, 0, '0'),
(776, 58, 'Suşehri', 0, 'a', 0, 0, '0'),
(777, 58, 'Şarkışla', 0, 'a', 0, 0, '0'),
(778, 58, 'Yıldızeli', 0, 'a', 0, 0, '0'),
(779, 58, 'Zara', 0, 'a', 0, 0, '0'),
(780, 58, 'Akıncılar', 0, 'a', 0, 0, '0'),
(781, 58, 'Altınyayla / Sivas', 0, 'a', 0, 0, '0'),
(782, 58, 'Doğanşar', 0, 'a', 0, 0, '0'),
(783, 58, 'Gölova', 0, 'a', 0, 0, '0'),
(784, 58, 'Ulaş', 0, 'a', 0, 0, '0'),
(785, 59, 'Çerkezköy', 0, 'a', 0, 0, '0'),
(786, 59, 'Çorlu', 0, 'a', 0, 0, '0'),
(787, 59, 'Hayrabolu', 0, 'a', 0, 0, '0'),
(788, 59, 'Malkara', 0, 'a', 0, 0, '0'),
(789, 59, 'Muratlı', 0, 'a', 0, 0, '0'),
(790, 59, 'Saray / Tekirdağ', 0, 'a', 0, 0, '0'),
(791, 59, 'Şarköy', 0, 'a', 0, 0, '0'),
(792, 59, 'Marmaraereğlisi', 0, 'a', 0, 0, '0'),
(793, 59, 'Ergene', 0, 'a', 0, 0, '0'),
(794, 59, 'Süleymanpaşa', 0, 'a', 0, 0, '0'),
(795, 60, 'Almus', 0, 'a', 0, 0, '0'),
(796, 60, 'Artova', 0, 'a', 0, 0, '0'),
(797, 60, 'Erbaa', 0, 'a', 0, 0, '0'),
(798, 60, 'Niksar', 0, 'a', 0, 0, '0'),
(799, 60, 'Reşadiye', 0, 'a', 0, 0, '0'),
(800, 60, 'Tokat Merkez', 0, 'a', 0, 0, '0'),
(801, 60, 'Turhal', 0, 'a', 0, 0, '0'),
(802, 60, 'Zile', 0, 'a', 0, 0, '0'),
(803, 60, 'Pazar / Tokat', 0, 'a', 0, 0, '0'),
(804, 60, 'Yeşilyurt / Tokat', 0, 'a', 0, 0, '0'),
(805, 60, 'Başçiftlik', 0, 'a', 0, 0, '0'),
(806, 60, 'Sulusaray', 0, 'a', 0, 0, '0'),
(807, 61, 'Akçaabat', 0, 'a', 0, 0, '0'),
(808, 61, 'Araklı', 0, 'a', 0, 0, '0'),
(809, 61, 'Arsin', 0, 'a', 0, 0, '0'),
(810, 61, 'Çaykara', 0, 'a', 0, 0, '0'),
(811, 61, 'Maçka', 0, 'a', 0, 0, '0'),
(812, 61, 'Of', 0, 'a', 0, 0, '0'),
(813, 61, 'Sürmene', 0, 'a', 0, 0, '0'),
(814, 61, 'Tonya', 0, 'a', 0, 0, '0'),
(815, 61, 'Vakfıkebir', 0, 'a', 0, 0, '0'),
(816, 61, 'Yomra', 0, 'a', 0, 0, '0'),
(817, 61, 'Beşikdüzü', 0, 'a', 0, 0, '0'),
(818, 61, 'Şalpazarı', 0, 'a', 0, 0, '0'),
(819, 61, 'Çarşıbaşı', 0, 'a', 0, 0, '0'),
(820, 61, 'Dernekpazarı', 0, 'a', 0, 0, '0'),
(821, 61, 'Düzköy', 0, 'a', 0, 0, '0'),
(822, 61, 'Hayrat', 0, 'a', 0, 0, '0'),
(823, 61, 'Köprübaşı / Trabzon', 0, 'a', 0, 0, '0'),
(824, 61, 'Ortahisar', 0, 'a', 0, 0, '0'),
(825, 62, 'Çemişgezek', 0, 'a', 0, 0, '0'),
(826, 62, 'Hozat', 0, 'a', 0, 0, '0'),
(827, 62, 'Mazgirt', 0, 'a', 0, 0, '0'),
(828, 62, 'Nazımiye', 0, 'a', 0, 0, '0'),
(829, 62, 'Ovacık / Tunceli', 0, 'a', 0, 0, '0'),
(830, 62, 'Pertek', 0, 'a', 0, 0, '0'),
(831, 62, 'Pülümür', 0, 'a', 0, 0, '0'),
(832, 62, 'Tunceli Merkez', 0, 'a', 0, 0, '0'),
(833, 63, 'Akçakale', 0, 'a', 0, 0, '0'),
(834, 63, 'Birecik', 0, 'a', 0, 0, '0'),
(835, 63, 'Bozova', 0, 'a', 0, 0, '0'),
(836, 63, 'Ceylanpınar', 0, 'a', 0, 0, '0'),
(837, 63, 'Halfeti', 0, 'a', 0, 0, '0'),
(838, 63, 'Hilvan', 0, 'a', 0, 0, '0'),
(839, 63, 'Siverek', 0, 'a', 0, 0, '0'),
(840, 63, 'Suruç', 0, 'a', 0, 0, '0'),
(841, 63, 'Viranşehir', 0, 'a', 0, 0, '0'),
(842, 63, 'Harran', 0, 'a', 0, 0, '0'),
(843, 63, 'Eyyübiye', 0, 'a', 0, 0, '0'),
(844, 63, 'Haliliye', 0, 'a', 0, 0, '0'),
(845, 63, 'Karaköprü', 0, 'a', 0, 0, '0'),
(846, 64, 'Banaz', 0, 'a', 0, 0, '0'),
(847, 64, 'Eşme', 0, 'a', 0, 0, '0'),
(848, 64, 'Karahallı', 0, 'a', 0, 0, '0'),
(849, 64, 'Sivaslı', 0, 'a', 0, 0, '0'),
(850, 64, 'Ulubey / Uşak', 0, 'a', 0, 0, '0'),
(851, 64, 'Uşak Merkez', 0, 'a', 0, 0, '0'),
(852, 65, 'Başkale', 0, 'a', 0, 0, '0'),
(853, 65, 'Çatak', 0, 'a', 0, 0, '0'),
(854, 65, 'Erciş', 0, 'a', 0, 0, '0'),
(855, 65, 'Gevaş', 0, 'a', 0, 0, '0'),
(856, 65, 'Gürpınar', 0, 'a', 0, 0, '0'),
(857, 65, 'Muradiye', 0, 'a', 0, 0, '0'),
(858, 65, 'Özalp', 0, 'a', 0, 0, '0'),
(859, 65, 'Bahçesaray', 0, 'a', 0, 0, '0'),
(860, 65, 'Çaldıran', 0, 'a', 0, 0, '0'),
(861, 65, 'Edremit / Van', 0, 'a', 0, 0, '0'),
(862, 65, 'Saray / Van', 0, 'a', 0, 0, '0'),
(863, 65, 'İpekyolu', 0, 'a', 0, 0, '0'),
(864, 65, 'Tuşba', 0, 'a', 0, 0, '0'),
(865, 66, 'Akdağmadeni', 0, 'a', 0, 0, '0'),
(866, 66, 'Boğazlıyan', 0, 'a', 0, 0, '0'),
(867, 66, 'Çayıralan', 0, 'a', 0, 0, '0'),
(868, 66, 'Çekerek', 0, 'a', 0, 0, '0'),
(869, 66, 'Sarıkaya', 0, 'a', 0, 0, '0'),
(870, 66, 'Sorgun', 0, 'a', 0, 0, '0'),
(871, 66, 'Şefaatli', 0, 'a', 0, 0, '0'),
(872, 66, 'Yerköy', 0, 'a', 0, 0, '0'),
(873, 66, 'Yozgat Merkez', 0, 'a', 0, 0, '0'),
(874, 66, 'Aydıncık / Yozgat', 0, 'a', 0, 0, '0'),
(875, 66, 'Çandır', 0, 'a', 0, 0, '0'),
(876, 66, 'Kadışehri', 0, 'a', 0, 0, '0'),
(877, 66, 'Saraykent', 0, 'a', 0, 0, '0'),
(878, 66, 'Yenifakılı', 0, 'a', 0, 0, '0'),
(879, 67, 'Çaycuma', 0, 'a', 0, 0, '0'),
(880, 67, 'Devrek', 0, 'a', 0, 0, '0'),
(881, 67, 'Ereğli / Zonguldak', 0, 'a', 0, 0, '0'),
(882, 67, 'Zonguldak Merkez', 0, 'a', 0, 0, '0'),
(883, 67, 'Alaplı', 0, 'a', 0, 0, '0'),
(884, 67, 'Gökçebey', 0, 'a', 0, 0, '0'),
(885, 68, 'Aksaray Merkez', 0, 'a', 0, 0, '0'),
(886, 68, 'Ortaköy / Aksaray', 0, 'a', 0, 0, '0'),
(887, 68, 'Ağaçören', 0, 'a', 0, 0, '0'),
(888, 68, 'Güzelyurt', 0, 'a', 0, 0, '0'),
(889, 68, 'Sarıyahşi', 0, 'a', 0, 0, '0'),
(890, 68, 'Eskil', 0, 'a', 0, 0, '0'),
(891, 68, 'Gülağaç', 0, 'a', 0, 0, '0'),
(892, 69, 'Bayburt Merkez', 0, 'a', 0, 0, '0'),
(893, 69, 'Aydıntepe', 0, 'a', 0, 0, '0'),
(894, 69, 'Demirözü', 0, 'a', 0, 0, '0'),
(895, 70, 'Ermenek', 0, 'a', 0, 0, '0'),
(896, 70, 'Karaman Merkez', 0, 'a', 0, 0, '0'),
(897, 70, 'Ayrancı', 0, 'a', 0, 0, '0'),
(898, 70, 'Kazımkarabekir', 0, 'a', 0, 0, '0'),
(899, 70, 'Başyayla', 0, 'a', 0, 0, '0'),
(900, 70, 'Sarıveliler', 0, 'a', 0, 0, '0'),
(901, 71, 'Delice', 0, 'a', 0, 0, '0'),
(902, 71, 'Keskin', 0, 'a', 0, 0, '0'),
(903, 71, 'Kırıkkale Merkez', 0, 'a', 0, 0, '0'),
(904, 71, 'Sulakyurt', 0, 'a', 0, 0, '0'),
(905, 71, 'Bahşili', 0, 'a', 0, 0, '0'),
(906, 71, 'Balışeyh', 0, 'a', 0, 0, '0'),
(907, 71, 'Çelebi', 0, 'a', 0, 0, '0'),
(908, 71, 'Karakeçili', 0, 'a', 0, 0, '0'),
(909, 71, 'Yahşihan', 0, 'a', 0, 0, '0'),
(910, 72, 'Batman Merkez', 0, 'a', 0, 0, '0'),
(911, 72, 'Beşiri', 0, 'a', 0, 0, '0'),
(912, 72, 'Gercüş', 0, 'a', 0, 0, '0'),
(913, 72, 'Kozluk', 0, 'a', 0, 0, '0'),
(914, 72, 'Sason', 0, 'a', 0, 0, '0'),
(915, 72, 'Hasankeyf', 0, 'a', 0, 0, '0'),
(916, 73, 'Beytüşşebap', 0, 'a', 0, 0, '0'),
(917, 73, 'Cizre', 0, 'a', 0, 0, '0'),
(918, 73, 'İdil', 0, 'a', 0, 0, '0'),
(919, 73, 'Silopi', 0, 'a', 0, 0, '0'),
(920, 73, 'Şırnak Merkez', 0, 'a', 0, 0, '0'),
(921, 73, 'Uludere', 0, 'a', 0, 0, '0'),
(922, 73, 'Güçlükonak', 0, 'a', 0, 0, '0'),
(923, 74, 'Bartın Merkez', 0, 'a', 0, 0, '0'),
(924, 74, 'Kurucaşile', 0, 'a', 0, 0, '0'),
(925, 74, 'Ulus', 0, 'a', 0, 0, '0'),
(926, 74, 'Amasra', 0, 'a', 0, 0, '0'),
(927, 75, 'Ardahan Merkez', 0, 'a', 0, 0, '0'),
(928, 75, 'Çıldır', 0, 'a', 0, 0, '0'),
(929, 75, 'Göle', 0, 'a', 0, 0, '0'),
(930, 75, 'Hanak', 0, 'a', 0, 0, '0'),
(931, 75, 'Posof', 0, 'a', 0, 0, '0'),
(932, 75, 'Damal', 0, 'a', 0, 0, '0'),
(933, 76, 'Aralık', 0, 'a', 0, 0, '0'),
(934, 76, 'Iğdır Merkez', 0, 'a', 0, 0, '0'),
(935, 76, 'Tuzluca', 0, 'a', 0, 0, '0'),
(936, 76, 'Karakoyunlu', 0, 'a', 0, 0, '0'),
(937, 77, 'Yalova Merkez', 0, 'a', 0, 0, '0'),
(938, 77, 'Altınova', 0, 'a', 0, 0, '0'),
(939, 77, 'Armutlu', 0, 'a', 0, 0, '0'),
(940, 77, 'Çınarcık', 0, 'a', 0, 0, '0'),
(941, 77, 'Çiftlikköy', 0, 'a', 0, 0, '0'),
(942, 77, 'Termal', 0, 'a', 0, 0, '0'),
(943, 78, 'Eflani', 0, 'a', 0, 0, '0'),
(944, 78, 'Eskipazar', 0, 'a', 0, 0, '0'),
(945, 78, 'Karabük Merkez', 0, 'a', 0, 0, '0'),
(946, 78, 'Ovacık / Karabük', 0, 'a', 0, 0, '0'),
(947, 78, 'Safranbolu', 0, 'a', 0, 0, '0'),
(948, 78, 'Yenice / Karabük', 0, 'a', 0, 0, '0'),
(949, 79, 'Kilis Merkez', 0, 'a', 0, 0, '0'),
(950, 79, 'Elbeyli', 0, 'a', 0, 0, '0'),
(951, 79, 'Musabeyli', 0, 'a', 0, 0, '0'),
(952, 79, 'Polateli', 0, 'a', 0, 0, '0'),
(953, 80, 'Bahçe', 0, 'a', 0, 0, '0'),
(954, 80, 'Kadirli', 0, 'a', 0, 0, '0'),
(955, 80, 'Osmaniye Merkez', 0, 'a', 0, 0, '0'),
(956, 80, 'Düziçi', 0, 'a', 0, 0, '0'),
(957, 80, 'Hasanbeyli', 0, 'a', 0, 0, '0'),
(958, 80, 'Sumbas', 0, 'a', 0, 0, '0'),
(959, 80, 'Toprakkale', 0, 'a', 0, 0, '0'),
(960, 81, 'Akçakoca', 0, 'a', 0, 0, '0'),
(961, 81, 'Düzce Merkez', 0, 'a', 0, 0, '0'),
(962, 81, 'Yığılca', 0, 'a', 0, 0, '0'),
(963, 81, 'Cumayeri', 0, 'a', 0, 0, '0'),
(964, 81, 'Gölyaka', 0, 'a', 0, 0, '0'),
(965, 81, 'Çilimli', 0, 'a', 0, 0, '0'),
(966, 81, 'Gümüşova', 0, 'a', 0, 0, '0'),
(967, 81, 'Kaynaşlı', 0, 'a', 0, 0, '0');

bunları txt ye yapıştır uzantısını sql yap db ye import et sonra kutulara koyarsın. il için de $(#il).change(function(){}); der ilçeleri çağırırsın.

Bu mesaja 1 cevap geldi.

Bu mesajda bahsedilenler: @esesdi

esesdi

11 yıl

Onbaşı

Konu Sahibi

Çok Teşekkür Ederim Dostum,

Bu mesajda bahsedilenler: @unforgiven1127

Cevap Yaz

1. sayfa

Tüm Forumlar Web Tasarım - Programlama Yazılım Geliştirme PHP / CGI PHP dinamik il ve ilçe seçim kutusu sorunu