korhan-Ö
11/4/2016 - 6:51 PM

tüm il ve ilçeler

tüm il ve ilçeler



Begin transaction

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


INSERT INTO "ilce" ("ilceID",  "il_ilID", "ilceAdi") VALUES
(1, 1, 'MERKEZ'),
(2, 1, 'ALADAG'),
(3, 1, 'CEYHAN'),
(4, 1, 'FEKE'),
(5, 1, 'IMAMOGLU'),
(6, 1, 'KARAISALI'),
(7, 1, 'KARATAS'),
(8, 1, 'KOZAN'),
(9, 1, 'POZANTI'),
(10, 1, 'SAIMBEYLI'),
(11, 1, 'SEYHAN'),
(12, 1, 'TUFANBEYLI'),
(13, 1, 'YUMURTALIK'),
(14, 1, 'YÜREGIR'),
(15, 2, 'MERKEZ'),
(16, 2, 'BESNI'),
(17, 2, 'ÇELIKHAN'),
(18, 2, 'GERGER'),
(19, 2, 'GÖLBASI'),
(20, 2, 'KAHTA'),
(21, 2, 'SAMSAT'),
(22, 2, 'SINCIK'),
(23, 2, 'TUT'),
(24, 3,'MERKEZ'),
(25, 3, 'BASMAKÇI'),
(26, 3, 'BAYAT'),
(27, 3, 'BOLVADIN'),
(28, 3, 'ÇOBANLAR'),
(29, 3, 'ÇAY'),
(30, 3, 'DAZKIRI'),
(31, 3, 'DINAR'),
(32, 3, 'EMIRDAG'),
(33, 3, 'EVCILER'),
(34, 3, 'HOCALAR'),
(35, 3, 'IHSANIYE'),
(36, 3, 'ISCEHISAR'),
(37, 3, 'KIZILÖREN'),
(38, 3, 'SANDIKLI'),
(39, 3, 'SINCANLI'),
(40, 3, 'SULTANDAGI'),
(41, 3, 'SUHUT'),
(42, 4,'MERKEZ'),
(43, 4, 'DIYADIN'),
(44, 4, 'DOGUBEYAZIT'),
(45, 4, 'ELESKIRT'),
(46, 4, 'HAMUR'),
(47, 4, 'PATNOS'),
(48, 4, 'TASLIÇAY'),
(49, 4, 'TUTAK'),
(50, 5,'MERKEZ'),
(51, 5, 'GÖYNÜCEK'),
(52, 5, 'GÜMÜSHACIKÖY'),
(53, 5, 'HAMAMÖZÜ'),
(54, 5, 'MERZIFON'),
(55, 5, 'SULUOVA'),
(56, 5, 'TASOVA'),
(57, 6,'MERKEZ'),
(58, 6, 'AKYURT'),
(59, 6, 'ALTINDAG'),
(60, 6, 'AYAS'),
(61, 6, 'BALA'),
(62, 6, 'BEYPAZARI'),
(63, 6, 'ÇAMLIDERE'),
(64, 6, 'ÇANKAYA'),
(65, 6, 'ÇUBUK'),
(66, 6, 'ELMADAG'),
(67, 6, 'ETIMESGUT'),
(68, 6, 'EVREN'),
(69, 6, 'GÖLBASI'),
(70, 6, 'GÜDÜL'),
(71, 6, 'HAYMANA'),
(72, 6, 'KALECIK'),
(73, 6, 'KAZAN'),
(74, 6, 'KEÇIÖREN'),
(75, 6, 'KIZILCAHAMAM'),
(76, 6, 'MAMAK'),
(77, 6, 'NALLIHAN'),
(78, 6, 'POLATLI'),
(79, 6, 'SINCAN'),
(80, 6, 'SEREFLIKOÇ'),
(81, 6, 'YENIMAHALLE'),
(82, 7,'MERKEZ'),
(83, 7, 'AKSEKI'),
(84, 7, 'ALANYA'),
(85, 7, 'DEMRE'),
(86, 7, 'ELMALI'),
(87, 7, 'FINIKE'),
(88, 7, 'GAZIPASA'),
(89, 7, 'GÜNDOGMUS'),
(90, 7, 'IBRADI'),
(91, 7, 'KALE'),
(92, 7, 'KAS'),
(93, 7, 'KEMER'),
(94, 7, 'KORKUTELI'),
(95, 7, 'KUMLUCA'),
(96, 7, 'MANAVGAT'),
(97, 7, 'SERIK'),
(98, 8,'MERKEZ'),
(99, 8, 'ARDANUÇ'),
(100, 8, 'ARHAVI'),
(101, 8, 'BORÇKA'),
(102, 8, 'HOPA'),
(103, 8, 'MURGUL'),
(104, 8, 'SAVSAT'),
(105, 8, 'YUSUFELI'),
(106, 9,'MERKEZ'),
(107, 9, 'BOZDOGAN'),
(108, 9, 'BUHARKENT'),
(109, 9, 'ÇINE'),
(110, 9, 'GERMENCIK'),
(111, 9, 'INCIRLIOVA'),
(112, 9, 'KARACASU'),
(113, 9, 'KARPUZLU'),
(114, 9, 'KOÇARLI'),
(115, 9, 'KÖSK'),
(116, 9, 'KUSADASI'),
(117, 9, 'KUYUCAK'),
(118, 9, 'NAZILLI'),
(119, 9, 'SÖKE'),
(120, 9, 'SULTANHISAR'),
(121, 9, 'YENIHISAR'),
(122, 9, 'YENIPAZAR'),
(123, 10, 'MERKEZ'),
(124, 10, 'AYVALIK'),
(125, 10, 'AKÇAY'),
(126, 10, 'BALYA'),
(127, 10, 'BANDIRMA'),
(128, 10, 'BIGADIÇ'),
(129, 10, 'BURHANIYE'),
(130, 10, 'DURSUNBEY'),
(131, 10, 'EDREMIT'),
(132, 10, 'ERDEK'),
(133, 10, 'GÖNEN'),
(134, 10, 'GÖMEÇ'),
(135, 10, 'HAVRAN'),
(136, 10, 'IVRINDI'),
(137, 10, 'KEPSUT'),
(138, 10, 'MANYAS'),
(139, 10, 'MARMARA'),
(140, 10, 'SAVASTEPE'),
(141, 10, 'SINDIRGI'),
(142, 10, 'SUSURLUK'),
(143, 11,'MERKEZ'),
(144, 11, 'BOZÖYÜK'),
(145, 11, 'GÖLPAZARI'),
(146, 11, 'INHISAR'),
(147, 11, 'OSMANELI'),
(148, 11, 'PAZARYERI'),
(149, 11, 'SÖGÜT'),
(150, 11, 'YENIPAZAR'),
(151, 12,'MERKEZ'),
(152, 12, 'ADAKLI'),
(153, 12, 'GENÇ'),
(154, 12, 'KARLIOVA'),
(155, 12, 'KIGI'),
(156, 12, 'SOLHAN'),
(157, 12, 'YAYLADERE'),
(158, 12, 'YEDISU'),
(159, 13,'MERKEZ'),
(160, 13, 'ADILCEVAZ'),
(161, 13, 'AHLAT'),
(162, 13, 'GÜROYMAK'),
(163, 13, 'HIZAN'),
(164, 13, 'MUTKI'),
(165, 13, 'TATVAN'),
(166, 14,'MERKEZ'),
(167, 14, 'DÖRTDIVAN'),
(168, 14, 'GEREDE'),
(169, 14, 'GÖYNÜK'),
(170, 14, 'KIBRISCIK'),
(171, 14, 'MENGEN'),
(172, 14, 'MUDURNU'),
(173, 14, 'SEBEN'),
(174, 14, 'YENIÇAGA'),
(175, 15,'MERKEZ'),
(176, 15, 'ALTINYAYLA'),
(177, 15, 'AGLASUN'),
(178, 15, 'BUCAK'),
(179, 15, 'ÇAVDIR'),
(180, 15, 'ÇELTIKÇI'),
(181, 15, 'GÖLHISAR'),
(182, 15, 'KARAMANLI'),
(183, 15, 'KEMER'),
(184, 15, 'TEFENNI'),
(185, 15, 'YESILOVA'),
(186, 16,'MERKEZ'),
(187, 16, 'BÜYÜKORHAN'),
(188, 16, 'GEMLIK'),
(189, 16, 'GÜRSU'),
(190, 16, 'HARMANCIK'),
(191, 16, 'INEGÖL'),
(192, 16, 'IZNIK'),
(193, 16, 'KARACABEY'),
(194, 16, 'KELES'),
(195, 16, 'KESTEL'),
(196, 16, 'MUDANYA'),
(197, 16, 'MUSTAFAKEMA'),
(198, 16, 'NILÜFER'),
(199, 16, 'ORHANELI'),
(200, 16, 'ORHANGAZI'),
(201, 16, 'OSMANGAZI'),
(202, 16, 'YENISEHIR'),
(203, 16, 'YILDIRIM'),
(204, 17,'MERKEZ'),
(205, 17, 'AYVACIK'),
(206, 17, 'BAYRAMIÇ'),
(207, 17, 'BOZCAADA'),
(208, 17, 'BIGA'),
(209, 17, 'ÇAN'),
(210, 17, 'ECEABAT'),
(211, 17, 'EZINE'),
(212, 17, 'GELIBOLU'),
(213, 17, 'GÖKÇEADA'),
(214, 17, 'LAPSEKI'),
(215, 17, 'YENICE'),
(216, 18,'MERKEZ'),
(217, 18, 'ATKARACALAR'),
(218, 18, 'BAYRAMÖREN'),
(219, 18, 'ÇERKES'),
(220, 18, 'ELDIVAN'),
(221, 18, 'ILGAZ'),
(222, 18, 'KIZILIRMAK'),
(223, 18, 'KORGUN'),
(224, 18, 'KURSUNLU'),
(225, 18, 'ORTA'),
(226, 18, 'OVACIK'),
(227, 18, 'SABANÖZÜ'),
(228, 18, 'YAPRAKLI'),
(229, 19,'MERKEZ'),
(230, 19, 'ALACA'),
(231, 19, 'BAYAT'),
(232, 19, 'BOGAZKALE'),
(233, 19, 'DODURGA'),
(234, 19, 'ISKILIP'),
(235, 19, 'KARGI'),
(236, 19, 'LAÇIN'),
(237, 19, 'MECITÖZÜ'),
(238, 19, 'OGUZLAR'),
(239, 19, 'ORTAKÖY'),
(240, 19, 'OSMANCIK'),
(241, 19, 'SUNGURLU'),
(242, 19, 'UGURLUDAG'),
(243, 20,'MERKEZ'),
(244, 20, 'ACIPAYAM'),
(245, 20, 'AKKÖY'),
(246, 20, 'BABADAG'),
(247, 20, 'BAKLAN'),
(248, 20, 'BEKILLI'),
(249, 20, 'BEYAGAÇ'),
(250, 20, 'BULDAN'),
(251, 20, 'BOZKURT'),
(252, 20, 'ÇAL'),
(253, 20, 'ÇAMELI'),
(254, 20, 'ÇARDAK'),
(255, 20, 'ÇIVRIL'),
(256, 20, 'GÜNEY'),
(257, 20, 'HONAZ'),
(258, 20, 'KALE'),
(259, 20, 'SARAYKÖY'),
(260, 20, 'SERINHISAR'),
(261, 20, 'TAVAS'),
(262, 21,'MERKEZ'),
(263, 21, 'BISMIL'),
(264, 21, 'ÇERMIK'),
(265, 21, 'ÇINAR'),
(266, 21, 'ÇÜNGÜS'),
(267, 21, 'DICLE'),
(268, 21, 'EGIL'),
(269, 21, 'ERGANI'),
(270, 21, 'HANI'),
(271, 21, 'HAZRO'),
(272, 21, 'KOCAKÖY'),
(273, 21, 'KULP'),
(274, 21, 'LICE'),
(275, 21, 'SILVAN'),
(276, 22,'MERKEZ'),
(277, 22, 'ENEZ'),
(278, 22, 'HAVSA'),
(279, 22, 'IPSALA'),
(280, 22, 'KESAN'),
(281, 22, 'LALAPASA'),
(282, 22, 'MERIÇ'),
(283, 22, 'SÜLOGLU'),
(284, 22, 'UZUNKÖPRÜ'),
(285, 23,'MERKEZ'),
(286, 23, 'AGIN'),
(287, 23, 'ALACAKAYA'),
(288, 23, 'ARICAK'),
(289, 23, 'BASKIL'),
(290, 23, 'KARAKOÇAN'),
(291, 23, 'KEBAN'),
(292, 23, 'KOVANCILAR'),
(293, 23, 'MADEN'),
(294, 23, 'PALU'),
(295, 23, 'SIVRICE'),
(296, 24,'MERKEZ'),
(297, 24, 'ÇAYIRLI'),
(298, 24, 'ILIÇ'),
(299, 24, 'KEMAH'),
(300, 24, 'KEMALIYE'),
(301, 24, 'OTLUKBELI'),
(302, 24, 'REFAHIYE'),
(303, 24, 'TERCAN'),
(304, 24, 'ÜZÜMLÜ'),
(305, 25,'MERKEZ'),
(306, 25, 'ASKALE'),
(307, 25, 'ÇAT'),
(308, 25, 'HINIS'),
(309, 25, 'HORASAN'),
(310, 25, 'ILICA'),
(311, 25, 'ISPIR'),
(312, 25, 'KARAÇOBAN'),
(313, 25, 'KARAYAZI'),
(314, 25, 'KÖPRÜKÖY'),
(315, 25, 'NARMAN'),
(316, 25, 'OLTU'),
(317, 25, 'OLUR'),
(318, 25, 'PASINLER'),
(319, 25, 'PAZARYOLU'),
(320, 25, 'SENKAYA'),
(321, 25, 'TEKMAN'),
(322, 25, 'TORTUM'),
(323, 25, 'UZUNDERE'),
(324, 26,'MERKEZ'),
(325, 26, 'ALPU'),
(326, 26, 'BEYLIKOVA'),
(327, 26, 'ÇIFTELER'),
(328, 26, 'GÜNYÜZÜ'),
(329, 26, 'HAN'),
(330, 26, 'INÖNÜ'),
(331, 26, 'MAHMUDIYE'),
(332, 26, 'MIHALGAZI'),
(333, 26, 'MIHALIÇÇIK'),
(334, 26, 'SARICAKAYA'),
(335, 26, 'SEYITGAZI'),
(336, 26, 'SIVRIHISAR'),
(337, 27,'MERKEZ'),
(338, 27, 'ARABAN'),
(339, 27, 'ISLAHIYE'),
(340, 27, 'KILIS'),
(341, 27, 'KARGAMIS'),
(342, 27, 'NIZIP'),
(343, 27, 'NURDAGI'),
(344, 27, 'OGUZELI'),
(345, 27, 'SAHINBEY'),
(346, 27, 'SEHITKAMIL'),
(347, 27, 'YAVUZELI'),
(348, 28,'MERKEZ'),
(349, 28, 'ALUCRA'),
(350, 28, 'BULANCAK'),
(351, 28, 'ÇAMOLUK'),
(352, 28, 'ÇANAKÇI'),
(353, 28, 'DERELI'),
(354, 28, 'DOGANKENT'),
(355, 28, 'ESPIYE'),
(356, 28, 'EYNESIL'),
(357, 28, 'GÖRELE'),
(358, 28, 'GÜCE'),
(359, 28, 'KESAP'),
(360, 28, 'PIRAZIZ'),
(361, 28, 'SEBINKARAHISAR'),
(362, 28, 'TIREBOLU'),
(363, 28, 'YAGLIDERE'),
(364, 29,'MERKEZ'),
(365, 29, 'KELKIT'),
(366, 29, 'KÖSE'),
(367, 29, 'KÜRTÜN'),
(368, 29, 'SIRAN'),
(369, 29, 'TORUL'),
(370, 30,'MERKEZ'),
(371, 30, 'ÇUKURCA'),
(372, 30, 'SEMDINLI'),
(373, 30, 'YÜKSEKOVA'),
(374, 31,'MERKEZ'),
(375, 31, 'ALTINÖZÜ'),
(376, 31, 'BELEN'),
(377, 31, 'DÖRTYOL'),
(378, 31, 'ERZIN'),
(379, 31, 'HASSA'),
(380, 31, 'ISKENDERUN'),
(381, 31, 'KIRIKHAN'),
(382, 31, 'KUMLU'),
(383, 31, 'REYHANLI'),
(384, 31, 'SAMANDAGI'),
(385, 31, 'YAYLADAGI'),
(386, 32,'MERKEZ'),
(387, 32, 'AKSU'),
(388, 32, 'ATABEY'),
(389, 32, 'EGIRDIR'),
(390, 32, 'GELENDOST'),
(391, 32, 'GÖNEN'),
(392, 32, 'KEÇIBORLU'),
(393, 32, 'SENIRKENT'),
(394, 32, 'SÜTÇÜLER'),
(395, 32, 'SARKIKARAAG'),
(396, 32, 'ULUBORLU'),
(397, 32, 'YENISARBADE'),
(398, 32, 'YALVAÇ'),
(399, 33,'MERKEZ'),
(400, 33, 'ANAMUR'),
(401, 33, 'AYDINCIK'),
(402, 33, 'BOZYAZI'),
(403, 33, 'ÇAMLIYAYLA'),
(404, 33, 'ERDEMLI'),
(405, 33, 'GÜLNAR'),
(406, 33, 'MUT'),
(407, 33, 'SILIFKE'),
(408, 33, 'TARSUS'),
(409, 34,'MERKEZ'),
(410, 34, 'ADALAR'),
(411, 34, 'AVCILAR'),
(412, 34, 'BAGCILAR'),
(413, 34, 'BAKIRKÖY'),
(414, 34, 'BAHÇELIEVLE'),
(415, 34, 'BAYRAMPASA'),
(416, 34, 'BESIKTAS'),
(417, 34, 'BEYKOZ'),
(418, 34, 'BEYOGLU'),
(419, 34, 'BÜYÜKÇEKMECE'),
(420, 34, 'ÇATALCA'),
(421, 34, 'EMINÖNÜ'),
(422, 34, 'EYÜP'),
(423, 34, 'ESENLER'),
(424, 34, 'FATIH'),
(425, 34, 'GAZIOSMANPASA'),
(426, 34, 'GÜNGÖREN'),
(427, 34, 'KADIKÖY'),
(428, 34, 'KAGITHANE'),
(429, 34, 'KARTAL'),
(430, 34, 'KÜÇÜKÇEKMECE'),
(431, 34, 'MALTEPE'),
(432, 34, 'PENDIK'),
(433, 34, 'SARIYER'),
(434, 34, 'SILIVRI'),
(435, 34, 'SULTANBEYLI'),
(436, 34, 'SILE'),
(437, 34, 'SISLI'),
(438, 34, 'TUZLA'),
(439, 34, 'ÜMRANIYE'),
(440, 34, 'ÜSKÜDAR'),
(441, 34, 'YALOVA'),
(442, 34, 'ZEYTINBURNU'),
(443, 35,'MERKEZ'),
(444, 35, 'ALIAGA'),
(445, 35, 'BAYINDIR'),
(446, 35, 'BALÇOVA'),
(447, 35, 'BERGAMA'),
(448, 35, 'BEYDAG'),
(449, 35, 'BORNOVA'),
(450, 35, 'BUCA'),
(451, 35, 'ÇESME'),
(452, 35, 'ÇIGLI'),
(453, 35, 'DIKILI'),
(454, 35, 'FOÇA'),
(455, 35, 'GAZIEMIR'),
(456, 35, 'GÜZELBAHÇE'),
(457, 35, 'KARABURUN'),
(458, 35, 'KARSIYAKA'),
(459, 35, 'KEMALPASA'),
(460, 35, 'KINIK'),
(461, 35, 'KIRAZ'),
(462, 35, 'KONAK'),
(463, 35, 'MENDERES'),
(464, 35, 'MENEMEN'),
(465, 35, 'NARLIDERE'),
(466, 35, 'ÖDEMIS'),
(467, 35, 'SEFERIHISAR'),
(468, 35, 'SELÇUK'),
(469, 35, 'TIRE'),
(470, 35, 'TORBALI'),
(471, 35, 'URLA'),
(472, 36,'MERKEZ'),
(473, 36, 'AKYAKA'),
(474, 36, 'ARPAÇAY'),
(475, 36, 'DIGOR'),
(476, 36, 'KAGIZMAN'),
(477, 36, 'SARIKAMIS'),
(478, 36, 'SELIM'),
(479, 36, 'SUSUZ'),
(480, 37,'MERKEZ'),
(481, 37, 'ABANA'),
(482, 37, 'AGLI'),
(483, 37, 'ARAÇ'),
(484, 37, 'AZDAVAY'),
(485, 37, 'BOZKURT'),
(486, 37, 'CIDE'),
(487, 37, 'ÇATALZEYTIN'),
(488, 37, 'DADAY'),
(489, 37, 'DEVREKANI'),
(490, 37, 'DOGANYURT'),
(491, 37, 'HANÖNÜ'),
(492, 37, 'IHSANGAZI'),
(493, 37, 'INEBOLU'),
(494, 37, 'KÜRE'),
(495, 37, 'PINARBASI'),
(496, 37, 'SEYDILER'),
(497, 37, 'SENPAZAR'),
(498, 37, 'TASKÖPRÜ'),
(499, 37, 'TOSYA'),
(500, 38,'MERKEZ'),
(501, 38, 'AKKISLA'),
(502, 38, 'BÜNYAN'),
(503, 38, 'DEVELI'),
(504, 38, 'FELAHIYE'),
(505, 38, 'HACILAR'),
(506, 38, 'INCESU'),
(507, 38, 'KOCASINAN'),
(508, 38, 'MELIKGAZI'),
(509, 38, 'ÖZVATAN'),
(510, 38, 'PINARBASI'),
(511, 38, 'SARIOGLAN'),
(512, 38, 'SARIZ'),
(513, 38, 'TALAS'),
(514, 38, 'TOMARZA'),
(515, 38, 'YAHYALI'),
(516, 38, 'YESILHISAR'),
(517, 39,'MERKEZ'),
(518, 39, 'BABAESKI'),
(519, 39, 'DEMIRKÖY'),
(520, 39, 'KOFÇAZ'),
(521, 39, 'LÜLEBURGAZ'),
(522, 39, 'PEHLIVANKÖY'),
(523, 39, 'PINARHISAR'),
(524, 39, 'VIZE'),
(525, 40,'MERKEZ'),
(526, 40, 'AKÇAKENT'),
(527, 40, 'AKPINAR'),
(528, 40, 'BOZTEPE'),
(529, 40, 'ÇIÇEKDAGI'),
(530, 40, 'KAMAN'),
(531, 40, 'MUCUR'),
(532, 41,'MERKEZ'),
(533, 41, 'DARICA'),
(534, 41, 'GEBZE'),
(535, 41, 'GÖLCÜK'),
(536, 41, 'KANDIRA'),
(537, 41, 'KARAMÜRSEL'),
(538, 41, 'KÖRFEZ'),
(539, 42,'MERKEZ'),
(540, 42, 'AHIRLI'),
(541, 42, 'AKÖREN'),
(542, 42, 'AKSEHIR'),
(543, 42, 'ALTINEKIN'),
(544, 42, 'BEYSEHIR'),
(545, 42, 'BOZKIR'),
(546, 42, 'DEREBUCAK'),
(547, 42, 'CIHANBEYLI'),
(548, 42, 'ÇUMRA'),
(549, 42, 'ÇELTIK'),
(550, 42, 'DERBENT'),
(551, 42, 'DOGANHISAR'),
(552, 42, 'EMIRGAZI'),
(553, 42, 'EREGLI'),
(554, 42, 'GÜNEYSINIR'),
(555, 42, 'HALKAPINAR'),
(556, 42, 'HADIM'),
(557, 42, 'HALKAPINAR'),
(558, 42, 'HÜYÜK'),
(559, 42, 'ILGIN'),
(560, 42, 'KADINHANI'),
(561, 42, 'KARAPINAR'),
(562, 42, 'KARATAY'),
(563, 42, 'KULU'),
(564, 42, 'MERAM'),
(565, 42, 'SARAYÖNÜ'),
(566, 42, 'SELÇUKLU'),
(567, 42, 'SEYDISEHIR'),
(568, 42, 'TASKENT'),
(569, 42, 'TUZLUKÇU'),
(570, 42, 'YALIHÖYÜK'),
(571, 42, 'YUNAK'),
(572, 43,'MERKEZ'),
(573, 43, 'ALTINTAS'),
(574, 43, 'ASLANAPA'),
(575, 43, 'CAVDARHISAR'),
(576, 43, 'DOMANIÇ'),
(577, 43, 'DUMLUPINAR'),
(578, 43, 'EMET'),
(579, 43, 'GEDIZ'),
(580, 43, 'HISARCIK'),
(581, 43, 'PAZARLAR'),
(582, 43, 'SIMAV'),
(583, 43, 'SAPHANE'),
(584, 43, 'TAVSANLI'),
(585, 44,'MERKEZ'),
(586, 44, 'AKÇADAG'),
(587, 44, 'ARAPGIR'),
(588, 44, 'ARGUVAN'),
(589, 44, 'BATTALGAZI'),
(590, 44, 'DARENDE'),
(591, 44, 'DOGANSEHIR'),
(592, 44, 'DOGANYOL'),
(593, 44, 'HEKIMHAN'),
(594, 44, 'KALE'),
(595, 44, 'KULUNCAK'),
(596, 44, 'PÖTÜRGE'),
(597, 44, 'YAZIHAN'),
(598, 44, 'YESILYURT'),
(599, 45,'MERKEZ'),
(600, 45, 'AHMETLI'),
(601, 45, 'AKHISAR'),
(602, 45, 'ALASEHIR'),
(603, 45, 'DEMIRCI'),
(604, 45, 'GÖLMARMARA'),
(605, 45, 'GÖRDES'),
(606, 45, 'KIRKAGAÇ'),
(607, 45, 'KÖPRÜBASI'),
(608, 45, 'KULA'),
(609, 45, 'SALIHLI'),
(610, 45, 'SARIGÖL'),
(611, 45, 'SARUHANLI'),
(612, 45, 'SELENDI'),
(613, 45, 'SOMA'),
(614, 45, 'TURGUTLU'),
(615, 46,'MERKEZ'),
(616, 46, 'AFSIN'),
(617, 46, 'ANDIRIN'),
(618, 46, 'ÇAGLAYANCER'),
(619, 46, 'EKINÖZÜ'),
(620, 46, 'ELBISTAN'),
(621, 46, 'GÖKSUN'),
(622, 46, 'NURHAK'),
(623, 46, 'PAZARCIK'),
(624, 46, 'TÜRKOGLU'),
(625, 47,'MERKEZ'),
(626, 47, 'DARGEÇIT'),
(627, 47, 'DERIK'),
(628, 47, 'KIZILTEPE'),
(629, 47, 'MAZIDAGI'),
(630, 47, 'MIDYAT'),
(631, 47, 'NUSAYBIN'),
(632, 47, 'ÖMERLI'),
(633, 47, 'SAVUR'),
(634, 47, 'YESILLI'),
(635, 48,'MERKEZ'),
(636, 48, 'BODRUM'),
(637, 48, 'DALAMAN'),
(638, 48, 'DATÇA'),
(639, 48, 'FETHIYE'),
(640, 48, 'KAVAKLIDERE'),
(641, 48, 'KÖYCEGIZ'),
(642, 48, 'MARMARIS'),
(643, 48, 'MILAS'),
(644, 48, 'ORTACA'),
(645, 48, 'ULA'),
(646, 48, 'YATAGAN'),
(647, 49,'MERKEZ'),
(648, 49, 'BULANIK'),
(649, 49, 'HASKÖY'),
(650, 49, 'KORKUT'),
(651, 49, 'MALAZGIRT'),
(652, 49, 'VARTO'),
(653, 50,'MERKEZ'),
(654, 50, 'ACIGÖL'),
(655, 50, 'AVANOS'),
(656, 50, 'DERINKUYU'),
(657, 50, 'GÜLSEHIR'),
(658, 50, 'HACIBEKTAS'),
(659, 50, 'KOZAKLI'),
(660, 50, 'ÜRGÜP'),
(661, 51,'MERKEZ'),
(662, 51, 'ALTUNHISAR'),
(663, 51, 'BOR'),
(664, 51, 'ÇAMARDI'),
(665, 51, 'ÇIFTLIK'),
(666, 51, 'ULUKISLA'),
(667, 52,'MERKEZ'),
(668, 52, 'AKKUS'),
(669, 52, 'AYBASTI'),
(670, 52, 'ÇAMAS'),
(671, 52, 'ÇATALPINAR'),
(672, 52, 'ÇAYBASI'),
(673, 52, 'FATSA'),
(674, 52, 'GÖLKÖY'),
(675, 52, 'GÖLYALI'),
(676, 52, 'GÜRGENTEPE'),
(677, 52, 'IKIZCE'),
(678, 52, 'KORGAN'),
(679, 52, 'KABADÜZ'),
(680, 52, 'KABATAS'),
(681, 52, 'KUMRU'),
(682, 52, 'MESUDIYE'),
(683, 52, 'PERSEMBE'),
(684, 52, 'ULUBEY'),
(685, 52, 'ÜNYE'),
(686, 53,'MERKEZ'),
(687, 53, 'ARDESEN'),
(688, 53, 'ÇAMLIHEMSIN'),
(689, 53, 'ÇAYELI'),
(690, 53, 'DEREPAZARI'),
(691, 53, 'FINDIKLI'),
(692, 53, 'GÜNEYSU'),
(693, 53, 'HEMSIN'),
(694, 53, 'IKIZDERE'),
(695, 53, 'IYIDERE'),
(696, 53, 'KALKANDERE'),
(697, 53, 'PAZAR'),
(698, 54,'MERKEZ'),
(699, 54, 'AKYAZI'),
(700, 54, 'FERIZLI'),
(701, 54, 'GEYVE'),
(702, 54, 'HENDEK'),
(703, 54, 'KARAPÜRÇEK'),
(704, 54, 'KARASU'),
(705, 54, 'KAYNARCA'),
(706, 54, 'KOCAALI'),
(707, 54, 'PAMUKOVA'),
(708, 54, 'SAPANCA'),
(709, 54, 'SÖGÜTLÜ'),
(710, 54, 'TARAKLI'),
(711, 55,'MERKEZ'),
(712, 55, 'ALAÇAM'),
(713, 55, 'ASARCIK'),
(714, 55, 'AYVACIK'),
(715, 55, 'BAFRA'),
(716, 55, 'ÇARSAMBA'),
(717, 55, 'HAVZA'),
(718, 55, 'KAVAK'),
(719, 55, 'LADIK'),
(720, 55, '19MAYIS'),
(721, 55, 'SALIPAZARI'),
(722, 55, 'TEKKEKÖY'),
(723, 55, 'TERME'),
(724, 55, 'VEZIRKÖPRÜ'),
(725, 55, 'YAKAKENT'),
(726, 56,'MERKEZ'),
(727, 56, 'AYDINLAR'),
(728, 56, 'BAYKAN'),
(729, 56, 'ERUH'),
(730, 56, 'KOZLUK'),
(731, 56, 'KURTALAN'),
(732, 56, 'PERVARI'),
(733, 56, 'SIRVAN'),
(734, 57,'MERKEZ'),
(735, 57, 'AYANCIK'),
(736, 57, 'BOYABAT'),
(737, 57, 'DIKMEN'),
(738, 57, 'DURAGAN'),
(739, 57, 'ERFELEK'),
(740, 57, 'GERZE'),
(741, 57, 'SARAYDÜZÜ'),
(742, 57, 'TÜRKELI'),
(743, 58,'MERKEZ'),
(744, 58, 'AKINCILAR'),
(745, 58, 'ALTINYAYLA'),
(746, 58, 'DIVRIGI'),
(747, 58, 'DOGANSAR'),
(748, 58, 'GEMEREK'),
(749, 58, 'GÖLOVA'),
(750, 58, 'GÜRÜN'),
(751, 58, 'HAFIK'),
(752, 58, 'IMRANLI'),
(753, 58, 'KANGAL'),
(754, 58, 'KOYULHISAR'),
(755, 58, 'SUSEHRI'),
(756, 58, 'SARKISLA'),
(757, 58, 'ULAS'),
(758, 58, 'YILDIZELI'),
(759, 58, 'ZARA'),
(760, 59,'MERKEZ'),
(761, 59, 'ÇERKEZKÖY'),
(762, 59, 'ÇORLU'),
(763, 59, 'HAYRABOLU'),
(764, 59, 'MALKARA'),
(765, 59, 'MARMARAEREGLI'),
(766, 59, 'MURATLI'),
(767, 59, 'SARAY'),
(768, 59, 'SARKÖY'),
(769, 60,'MERKEZ'),
(770, 60, 'ALMUS'),
(771, 60, 'ARTOVA'),
(772, 60, 'BASÇIFTLIK'),
(773, 60, 'ERBAA'),
(774, 60, 'NIKSAR'),
(775, 60, 'PAZAR'),
(776, 60, 'RESADIYE'),
(777, 60, 'SULUSARAY'),
(778, 60, 'TURHAL'),
(779, 60, 'YESILYURT'),
(780, 60, 'ZILE'),
(781, 61,'MERKEZ'),
(782, 61, 'AKÇAABAT'),
(783, 61, 'ARAKLI'),
(784, 61, 'ARSIN'),
(785, 61, 'BESIKDÜZÜ'),
(786, 61, 'ÇARSIBASI'),
(787, 61, 'ÇAYKARA'),
(788, 61, 'DERNEKPAZAR'),
(789, 61, 'DÜZKÖY'),
(790, 61, 'HAYRAT'),
(791, 61, 'KÖPRÜBASI'),
(792, 61, 'MAÇKA'),
(793, 61, 'OF'),
(794, 61, 'SÜRMENE'),
(795, 61, 'SALPAZARI'),
(796, 61, 'TONYA'),
(797, 61, 'VAKFIKEBIR'),
(798, 61, 'YOMRA'),
(799, 62,'MERKEZ'),
(800, 62, 'ÇEMISGEZEK'),
(801, 62, 'HOZAT'),
(802, 62, 'MAZGIRT'),
(803, 62, 'NAZIMIYE'),
(804, 62, 'OVACIK'),
(805, 62, 'PERTEK'),
(806, 62, 'PÜLÜMÜR'),
(807, 63,'MERKEZ'),
(808, 63, 'AKÇAKALE'),
(809, 63, 'BIRECIK'),
(810, 63, 'BOZOVA'),
(811, 63, 'CEYLANPINAR'),
(812, 63, 'HALFETI'),
(813, 63, 'HARRAN'),
(814, 63, 'HILVAN'),
(815, 63, 'SIVEREK'),
(816, 63, 'SURUÇ'),
(817, 63, 'VIRANSEHIR'),
(818, 64,'MERKEZ'),
(819, 64, 'BANAZ'),
(820, 64, 'ESME'),
(821, 64, 'KARAHALLI'),
(822, 64, 'SIVASLI'),
(823, 64, 'ULUBEY'),
(824, 65,'MERKEZ'),
(825, 65, 'BAHÇESARAY'),
(826, 65, 'BASKALE'),
(827, 65, 'ÇALDIRAN'),
(828, 65, 'ÇATAK'),
(829, 65, 'EDREMIT'),
(830, 65, 'ERCIS'),
(831, 65, 'GEVAS'),
(832, 65, 'GÜRPINAR'),
(833, 65, 'MURADIYE'),
(834, 65, 'ÖZALP'),
(835, 65, 'SARAY'),
(836, 66,'MERKEZ'),
(837, 66, 'AKDAGMADENI'),
(838, 66, 'AYDINCIK'),
(839, 66, 'BOGAZLIYAN'),
(840, 66, 'ÇANDIR'),
(841, 66, 'ÇAYIRALAN'),
(842, 66, 'ÇEKEREK'),
(843, 66, 'KADISEHRI'),
(844, 66, 'SARIKAYA'),
(845, 66, 'SARAYKENT'),
(846, 66, 'SORGUN'),
(847, 66, 'SEFAATLI'),
(848, 66, 'YENIFAKILI'),
(849, 66, 'YERKÖY'),
(850, 67,'MERKEZ'),
(851, 67, 'ALAPLI'),
(852, 67, 'ÇAMOLUK'),
(853, 67, 'ÇAYCUMA'),
(854, 67, 'DEVREK'),
(855, 67, 'EFLANI'),
(856, 67, 'EREGLI'),
(857, 67, 'GÖKÇEBEY'),
(858, 68,'MERKEZ'),
(859, 68, 'AGAÇÖREN'),
(860, 68, 'ESKIL'),
(861, 68, 'GÜLAGAÇ'),
(862, 68, 'GÜZELYURT'),
(863, 68, 'ORTAKÖY'),
(864, 68, 'SARIYAHSI'),
(865, 69,'MERKEZ'),
(866, 69, 'AYDINTEPE'),
(867, 69, 'DEMIRÖZÜ'),
(868, 70,'MERKEZ'),
(869, 70, 'AYRANCI'),
(870, 70, 'BASYAYLA'),
(871, 70, 'ERMENEK'),
(872, 70, 'KAZIMKARABEKIR'),
(873, 70, 'SARIVELILER'),
(874, 71,'MERKEZ'),
(875, 71, 'BAHSILI'),
(876, 71, 'BAGLISEYH'),
(877, 71, 'ÇELEBI'),
(878, 71, 'DELICE'),
(879, 71, 'KARAKEÇILI'),
(880, 71, 'KESKIN'),
(881, 71, 'SULAKYURT'),
(882, 71, 'YAHSIHAN'),
(883, 72,'MERKEZ'),
(884, 72, 'GERCÜS'),
(885, 72, 'HASANKEYF'),
(886, 72, 'BESIRI'),
(887, 72, 'KOZLUK'),
(888, 72, 'SASON'),
(889, 73,'MERKEZ'),
(890, 73, 'BEYTÜSSEBA'),
(891, 73, 'ULUDERE'),
(892, 73, 'CIZRE'),
(893, 73, 'IDIL'),
(894, 73, 'SILOPI'),
(895, 73, 'GÜÇLÜKONAK'),
(896, 74,'MERKEZ'),
(897, 74, 'AMASRA'),
(898, 74, 'KURUCASILE'),
(899, 74, 'ULUS'),
(900, 75,'MERKEZ'),
(901, 75, 'ÇILDIR'),
(902, 75, 'DAMAL'),
(903, 75, 'GÖLE'),
(904, 75, 'HANAK'),
(905, 75, 'POSOF'),
(906, 76,'MERKEZ'),
(907, 76, 'ARALIK'),
(908, 76, 'KARAKOYUNLU'),
(909, 76, 'TUZLUCA'),
(910, 77,'MERKEZ'),
(911, 77, 'ALTINOVA'),
(912, 77, 'ARMUTLU'),
(913, 77, 'CINARCIK'),
(914, 77, 'CIFTLIKKOY'),
(915, 77, 'TERMAL'),
(916, 78,'MERKEZ'),
(917, 78, 'EFLANI'),
(918, 78, 'ESKIPAZAR'),
(919, 78, 'OVACIK'),
(920, 78, 'SAFRANBOLU'),
(921, 78, 'YENICE'),
(922, 79,'MERKEZ'),
(923, 79, 'ELBEYLI'),
(924, 79, 'MUSABEYLI'),
(925, 79, 'POLATELI'),
(926, 80,'MERKEZ'),
(927, 80, 'BAHÇE'),
(928, 80, 'HASANBEYLI'),
(929, 80, 'DÜZIÇI'),
(930, 80, 'KADIRLI'),
(931, 80, 'SUNBAS'),
(932, 80, 'TOPRAKKALE'),
(933, 81,'MERKEZ'),
(934, 81, 'AKÇAKOCA'),
(935, 81, 'CUMAYERI'),
(936, 81, 'ÇILIMLI'),
(937, 81, 'GÖLYAKA'),
(938, 81, 'GÜMÜSOVA'),
(939, 81, 'KAYNASLI'),
(940, 81, 'YIGILCA'),
(941, 3, 'SINANPASA'),
(942, 9, 'DIDIM'),
(943, 41, 'DERINCE');

commit transaction