省市区三级联动（附数据库和导入模板的做法）

代码1，php

  1 <html>
  2 <head>
  3 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  4 <!--------------------------------------------------------------
  5 --省的字段是：province
  6 --市的字段是：city
  7 --县的字段是：area
  8 --------------------------------------------------------------------------->
  9 <mce:script type="text/javascript"><!--
 10 /********
 11 *定义创建XMLHttpRequest对象的方法
 12 *
 13 **************************************/
 14 var xmlHttp;//声明变量
 15 var requestType="";//声明初始类型为空
 16 function createXMLHttpRequest()//定义创建一个跨浏览器函数的开头
 17 {
 18     if(window.ActiveXObject)//ActiveXObject对象到找到的时候返回的是真，否则是假
 19     {
 20         xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");//这个是使用IE的方法创建XmlHttp
 21     }
 22     else if(window.XMLHttpRequest)
 23     {
 24         xmlHttp=new XMLHttpRequest();//这个是使用非IE的方法创建XmlHttp
 25     }
 26 }
 27 /***************
 28 *判断服务器响应的事件，如果返回是4则说明交互完成，判断标示头，
 29 *
 30 *************************************************/
 31 function handleStateChange(){//判断返回的一个函数，来确定执行那个的函数
 32     if(xmlHttp.readystate==4)
 33         {//4说明是执行交互完毕0 (未初始化)1 (正在装载)2 (装载完毕) 3 (交互中)4 (完成)
 34         if(xmlHttp.status==200)
 35             {//http的一个报头说明成功找到
 36             if(type=="city"){//判断查询的类型
 37                                 showcity();//返回响应的显示
 38                             }
 39             else if(type="area"){//判断响应的查询的类型
 40                                     showarea();//返回响应的显示
 41                                 }
 42             }
 43         }
 44 }
 45 /*************************
 46 *城市的一个查询函数
 47 *
 48 *********************************************************/
 49 function queryCity(citycode){//执行程序查询，查询城市的
 50     createXMLHttpRequest();//调用创建XmlHttp的函数
 51     type="city";//表示类型，查询城市处理显示的时候需要用到
 52     var url='data.php?provincecode='+citycode+'&n='+Math.random();//设定URL传值方法同时防止缓存
 53     xmlHttp.open("GET",url,true);//建立服务器连接，异步传输tree
 54     xmlHttp.onreadystatechange=handleStateChange;//处理这个响应所需要的函数
 55     xmlHttp.send(null);//执行程序函数这里的中间的参数是因为GET原因
 56 }
 57 /*********************
 58 *县区的一个查询函数
 59 ***********************************************************/
 60 function queryArea(citycode){//查询程序
 61     createXMLHttpRequest();//调用创建XmlHttp的函数
 62     type="area";//查询县的
 63     var url="data.php?citycode="+citycode+'&n='+Math.random();//设定URL传值方法同时防止缓存
 64     xmlHttp.open("GET",url,true);
 65     xmlHttp.onreadystatechange=handleStateChange;//处理响应的函数名
 66     xmlHttp.send(null);//执行程序函数这里的中间的参数是因为GET原因
 67 }
 68 /********************
 69 *一个显示函数
 70 **********************************************************/
 71 function showcity(){//显示函数
 72     document.getElementById("city").innerHTML=xmlHttp.responseText;//捕获ID显示返回的数据
 73 }
 74 function showarea(){
 75     document.getElementById("area").innerHTML=xmlHttp.responseText;//捕获ID显示返回的数据
 76 }
 77 // --></mce:script>
 78 </head>
 79 <body>
 80 <?php
 81     $conn=mysql_connect("localhost","root","");//链接数据库
 82     mysql_select_db("novel");//选择数据库
 83     mysql_query("set names 'utf8'");//设定字符集
 84     $sql="select * from province";//查询数据库province表也就是省
 85     $result=mysql_query($sql);//执行语句赋值给变量
 86     ?>
 87     <from id='form1'><!--输出表单头-->
 88     <!--输出下拉列表框，并设定onchange响应事件，把省值传递过去-->
 89     <select id='province' onchange='queryCity(this.options[this.selectedIndex].value)'>
 90     <!--输出下拉列表项值-->
 91     <option value='-1' selected>请选择省份</option>
 92     <?php
 93     while($row=mysql_fetch_row($result)){
 94     //循环循环查询显示省输出数据显示
 95         echo "<option value='$row[1]'>$row[2]</option>/n";
 96     }
 97     ?>
 98     </select><!--下拉列表项尾数-->
 99     <span id='city'></span><!--显示数据的城市的位置-->
100     <span id='area'></span><!--显示数据的城市的位置-->
101     </form><!--表单项结尾-->
102 </body>
103 </html>
104 　　
105 
106 1
107 2
108 3
109 4
110 5
111 6
112 7
113 8
114 9
115 10
116 11
117 12
118 13
119 14
120 15
121 16
122 17
123 18
124 19
125 20
126 21
127 22
128 23
129 24
130 25
131 26
132 27
133 28
134 29
135 30
136 <?php
137 $provincecode=$_GET['provincecode'];//接收省键值
138 $citycode=$_GET['citycode'];//接收城市键值
139 $conn=mysql_connect("localhost","root","");//连接主机
140 mysql_select_db("novel");//选择数据库
141 mysql_query("set names 'utf8'");
142 if($provincecode!=""){//如果传递过来的不为空则执行
143     $sql="select * from city where provincecode=$provincecode";//查询城市符合属于上边传递过来的省的字段
144     $result=mysql_query($sql);//执行SQL查询语句
145     print_r($row);
146 ?>
147     <select onchange='queryArea(this.options[this.selectedIndex].value)'><!--下拉列表框开头-->
148     <option value='-1' selected>请选择城市</option><!--下拉列表框值开头-->
149     <?php while($row=mysql_fetch_row($result)){//循环记录集?>
150         <option value="<?= $row[1]?>"><?=$row[2]?></option>
151     <?php }?>
152     </select>
153 <?php }?>
154 <?php
155     if($citycode!=""){
156     $sql="select * from area where citycode=$citycode";
157     $result=mysql_query($sql);
158     echo "<select>/n";
159     echo "<option value='-1' selected>请选择县</option>/n";
160     while($row=mysql_fetch_row($result)){
161         echo "<option value='$row[1]'>$row[2]</option>/n";
162     }
163     echo "</select>/n";
164 }
165 ?>

View Code

代码2

oracle数据库

建立表

 1 --创建表 省市区
 2 --表 province
 3 
 4 create table provinces
 5 (
 6    pro_id number(11) primary key ,
 7    pro_code varchar2(6) NOT NULL,
 8    pro_name varchar2(20) NOT NULL
 9 );
10 --表 city
11 drop table city;
12 CREATE TABLE city
13 (
14   city_id number(11)   PRIMARY KEY ,
15   city_code varchar2(6) NOT NULL,
16   city_name varchar2(40) NOT NULL,
17   pro_code varchar2(6) NOT NULL
18 ) 
19 --表 `area`
20 drop table area;
21 CREATE TABLE area (
22    are_id number(11) primary key ,
23    are_code varchar2(6) NOT NULL,
24    are_name varchar2(50) NOT NULL,
25    citycode varchar2(6) NOT NULL
26 );

View Code

插入数据--省

--插入省
insert into province values(1,'110000','北京市');
insert into province values(2,'120000','天津市');
insert into province values(3,'130000','河北省');
insert into province values(4,'140000','山西省');
insert into province values(5,'150000','内蒙古');
insert into province values(6,'210000','辽宁省');
insert into province values(7,'220000','吉林省');
insert into province values(8,'230000','黑龙江');
insert into province values(9,'310000','上海市');
insert into province values(10,'320000','江苏省');
insert into province values(11,'330000','浙江省');
insert into province values(12,'340000','安徽省');
insert into province values(13,'350000','福建省');
insert into province values(14,'360000','江西省');
insert into province values(15,'370000','山东省');
insert into province values(16,'410000','河南省');
insert into province values(17,'420000','湖北省');
insert into province values(18,'430000','湖南省');
insert into province values(19,'440000','广东省');
insert into province values(20,'450000','广  西');
insert into province values(21,'460000','海南省');
insert into province values(22,'500000','重庆市');
insert into province values(23,'510000','四川省');
insert into province values(24,'520000','贵州省');
insert into province values(25,'530000','云南省');
insert into province values(26,'540000','西  藏');
insert into province values(27,'610000','陕西省');
insert into province values(28,'620000','甘肃省');
insert into province values(29,'630000','青海省');
insert into province values(30,'640000','宁  夏');
insert into province values(31,'650000','新  疆');
insert into province values(32,'710000','台湾省');
insert into province values(33,'810000','香  港');
insert into province values(34,'820000','澳  门');
--select * from province for update

View Code

插入数据--市

  1 --插入 市 数据
  2 insert into city values(1,'110100','北京市','110000');
  3 insert into city values(2,'130100','石家庄市','130000');
  4 insert into city values(3,'130200','唐山市','130000');
  5 insert into city values(4,'130300','秦皇岛市','130000');
  6 insert into city values(5,'130400','邯郸市','130000');
  7 insert into city values(6,'130500','邢台市','130000');
  8 insert into city values(7,'130600','保定市','130000');
  9 insert into city values(8,'130700','张家口市','130000');
 10 insert into city values(9,'130800','承德市','130000');
 11 insert into city values(10,'130900','沧州市','130000');
 12 insert into city values(11,'131000','廊坊市','130000');
 13 insert into city values(12,'131100','衡水市','130000');
 14 insert into city values(13,'140100','太原市','140000');
 15 insert into city values(14,'140200','大同市','140000');
 16 insert into city values(15,'140300','阳泉市','140000');
 17 insert into city values(16,'140400','长治市','140000');
 18 insert into city values(17,'140500','晋城市','140000');
 19 insert into city values(18,'140600','朔州市','140000');
 20 insert into city values(19,'140700','晋中市','140000');
 21 insert into city values(20,'140800','运城市','140000');
 22 insert into city values(21,'140900','忻州市','140000');
 23 insert into city values(22,'141000','临汾市','140000');
 24 insert into city values(23,'141100','吕梁市','140000');
 25 insert into city values(24,'150100','呼和浩特市','150000');
 26 insert into city values(25,'150200','包头市','150000');
 27 insert into city values(26,'150300','乌海市','150000');
 28 insert into city values(27,'150400','赤峰市','150000');
 29 insert into city values(28,'150500','通辽市','150000');
 30 insert into city values(29,'150600','鄂尔多斯市','150000');
 31 insert into city values(30,'150700','呼伦贝尔市','150000');
 32 insert into city values(31,'150800','巴彦淖尔市','150000');
 33 insert into city values(32,'150900','乌兰察布市','150000');
 34 insert into city values(33,'152200','兴安盟','150000');
 35 insert into city values(34,'152500','锡林郭勒盟','150000');
 36 insert into city values(35,'152900','阿拉善盟','150000');
 37 insert into city values(36,'210100','沈阳市','210000');
 38 insert into city values(37,'210200','大连市','210000');
 39 insert into city values(38,'210300','鞍山市','210000');
 40 insert into city values(39,'210400','抚顺市','210000');
 41 insert into city values(40,'210500','本溪市','210000');
 42 insert into city values(41,'210600','丹东市','210000');
 43 insert into city values(42,'210700','锦州市','210000');
 44 insert into city values(43,'210800','营口市','210000');
 45 insert into city values(44,'210900','阜新市','210000');
 46 insert into city values(45,'211000','辽阳市','210000');
 47 insert into city values(46,'211100','盘锦市','210000');
 48 insert into city values(47,'211200','铁岭市','210000');
 49 insert into city values(48,'211300','朝阳市','210000');
 50 insert into city values(49,'211400','葫芦岛市','210000');
 51 insert into city values(50,'220100','长春市','220000');
 52 insert into city values(51,'220200','吉林市','220000');
 53 insert into city values(52,'220300','四平市','220000');
 54 insert into city values(53,'220400','辽源市','220000');
 55 insert into city values(54,'220500','通化市','220000');
 56 insert into city values(55,'220600','白山市','220000');
 57 insert into city values(56,'220700','松原市','220000');
 58 insert into city values(57,'220800','白城市','220000');
 59 insert into city values(58,'222400','延边朝鲜族自治州','220000');
 60 insert into city values(59,'230100','哈尔滨市','230000');
 61 insert into city values(60,'230200','齐齐哈尔市','230000');
 62 insert into city values(61,'230300','鸡西市','230000');
 63 insert into city values(62,'230400','鹤岗市','230000');
 64 insert into city values(63,'230500','双鸭山市','230000');
 65 insert into city values(64,'230600','大庆市','230000');
 66 insert into city values(65,'230700','伊春市','230000');
 67 insert into city values(66,'230800','佳木斯市','230000');
 68 insert into city values(67,'230900','七台河市','230000');
 69 insert into city values(68,'231000','牡丹江市','230000');
 70 insert into city values(69,'231100','黑河市','230000');
 71 insert into city values(70,'231200','绥化市','230000');
 72 insert into city values(71,'232700','大兴安岭地区','230000');
 73 insert into city values(72,'310100','市辖区','310000');
 74 insert into city values(73,'310200','县','310000');
 75 insert into city values(74,'320100','南京市','320000');
 76 insert into city values(75,'320200','无锡市','320000');
 77 insert into city values(76,'320300','徐州市','320000');
 78 insert into city values(77,'320400','常州市','320000');
 79 insert into city values(78,'320500','苏州市','320000');
 80 insert into city values(79,'320600','南通市','320000');
 81 insert into city values(80,'320700','连云港市','320000');
 82 insert into city values(81,'320800','淮安市','320000');
 83 insert into city values(82,'320900','盐城市','320000');
 84 insert into city values(83,'321000','扬州市','320000');
 85 insert into city values(84,'321100','镇江市','320000');
 86 insert into city values(85,'321200','泰州市','320000');
 87 insert into city values(86,'321300','宿迁市','320000');
 88 insert into city values(87,'330100','杭州市','330000');
 89 insert into city values(88,'330200','宁波市','330000');
 90 insert into city values(89,'330300','温州市','330000');
 91 insert into city values(90,'330400','嘉兴市','330000');
 92 insert into city values(91,'330500','湖州市','330000');
 93 insert into city values(92,'330600','绍兴市','330000');
 94 insert into city values(93,'330700','金华市','330000');
 95 insert into city values(94,'330800','衢州市','330000');
 96 insert into city values(95,'330900','舟山市','330000');
 97 insert into city values(96,'331000','台州市','330000');
 98 insert into city values(97,'331100','丽水市','330000');
 99 insert into city values(98,'340100','合肥市','340000');
100 insert into city values(99,'340200','芜湖市','340000');
101 insert into city values(100,'340300','蚌埠市','340000');
102 insert into city values(101,'340400','淮南市','340000');
103 insert into city values(102,'340500','马鞍山市','340000');
104 insert into city values(103,'340600','淮北市','340000');
105 insert into city values(104,'340700','铜陵市','340000');
106 insert into city values(105,'340800','安庆市','340000');
107 insert into city values(106,'341000','黄山市','340000');
108 insert into city values(107,'341100','滁州市','340000');
109 insert into city values(108,'341200','阜阳市','340000');
110 insert into city values(109,'341300','宿州市','340000');
111 insert into city values(110,'341400','巢湖市','340000');
112 insert into city values(111,'341500','六安市','340000');
113 insert into city values(112,'341600','亳州市','340000');
114 insert into city values(113,'341700','池州市','340000');
115 insert into city values(114,'341800','宣城市','340000');
116 insert into city values(115,'350100','福州市','350000');
117 insert into city values(116,'350200','厦门市','350000');
118 insert into city values(117,'350300','莆田市','350000');
119 insert into city values(118,'350400','三明市','350000');
120 insert into city values(119,'350500','泉州市','350000');
121 insert into city values(120,'350600','漳州市','350000');
122 insert into city values(121,'350700','南平市','350000');
123 insert into city values(122,'350800','龙岩市','350000');
124 insert into city values(123,'350900','宁德市','350000');
125 insert into city values(124,'360100','南昌市','360000');
126 insert into city values(125,'360200','景德镇市','360000');
127 insert into city values(126,'360300','萍乡市','360000');
128 insert into city values(127,'360400','九江市','360000');
129 insert into city values(128,'360500','新余市','360000');
130 insert into city values(129,'360600','鹰潭市','360000');
131 insert into city values(130,'360700','赣州市','360000');
132 insert into city values(131,'360800','吉安市','360000');
133 insert into city values(132,'360900','宜春市','360000');
134 insert into city values(133,'361000','抚州市','360000');
135 insert into city values(134,'361100','上饶市','360000');
136 insert into city values(135,'370100','济南市','370000');
137 insert into city values(136,'370200','青岛市','370000');
138 insert into city values(137,'370300','淄博市','370000');
139 insert into city values(138,'370400','枣庄市','370000');
140 insert into city values(139,'370500','东营市','370000');
141 insert into city values(140,'370600','烟台市','370000');
142 insert into city values(141,'370700','潍坊市','370000');
143 insert into city values(142,'370800','济宁市','370000');
144 insert into city values(143,'370900','泰安市','370000');
145 insert into city values(144,'371000','威海市','370000');
146 insert into city values(145,'371100','日照市','370000');
147 insert into city values(146,'371200','莱芜市','370000');
148 insert into city values(147,'371300','临沂市','370000');
149 insert into city values(148,'371400','德州市','370000');
150 insert into city values(149,'371500','聊城市','370000');
151 insert into city values(150,'371600','滨州市','370000');
152 insert into city values(151,'371700','荷泽市','370000');
153 insert into city values(152,'410100','郑州市','410000');
154 insert into city values(153,'410200','开封市','410000');
155 insert into city values(154,'410300','洛阳市','410000');
156 insert into city values(155,'410400','平顶山市','410000');
157 insert into city values(156,'410500','安阳市','410000');
158 insert into city values(157,'410600','鹤壁市','410000');
159 insert into city values(158,'410700','新乡市','410000');
160 insert into city values(159,'410800','焦作市','410000');
161 insert into city values(160,'410900','濮阳市','410000');
162 insert into city values(161,'411000','许昌市','410000');
163 insert into city values(162,'411100','漯河市','410000');
164 insert into city values(163,'411200','三门峡市','410000');
165 insert into city values(164,'411300','南阳市','410000');
166 insert into city values(165,'411400','商丘市','410000');
167 insert into city values(166,'411500','信阳市','410000');
168 insert into city values(167,'411600','周口市','410000');
169 insert into city values(168,'411700','驻马店市','410000');
170 insert into city values(169,'420100','武汉市','420000');
171 insert into city values(170,'420200','黄石市','420000');
172 insert into city values(171,'420300','十堰市','420000');
173 insert into city values(172,'420500','宜昌市','420000');
174 insert into city values(173,'420600','襄樊市','420000');
175 insert into city values(174,'420700','鄂州市','420000');
176 insert into city values(175,'420800','荆门市','420000');
177 insert into city values(176,'420900','孝感市','420000');
178 insert into city values(177,'421000','荆州市','420000');
179 insert into city values(178,'421100','黄冈市','420000');
180 insert into city values(179,'421200','咸宁市','420000');
181 insert into city values(180,'421300','随州市','420000');
182 insert into city values(181,'422800','恩施土家族苗族自治州','420000');
183 insert into city values(182,'429000','省直辖行政单位','420000');
184 insert into city values(183,'430100','长沙市','430000');
185 insert into city values(184,'430200','株洲市','430000');
186 insert into city values(185,'430300','湘潭市','430000');
187 insert into city values(186,'430400','衡阳市','430000');
188 insert into city values(187,'430500','邵阳市','430000');
189 insert into city values(188,'430600','岳阳市','430000');
190 insert into city values(189,'430700','常德市','430000');
191 insert into city values(190,'430800','张家界市','430000');
192 insert into city values(191,'430900','益阳市','430000');
193 insert into city values(192,'431000','郴州市','430000');
194 insert into city values(193,'431100','永州市','430000');
195 insert into city values(194,'431200','怀化市','430000');
196 insert into city values(195,'431300','娄底市','430000');
197 insert into city values(196,'433100','湘西土家族苗族自治州','430000');
198 insert into city values(197,'440100','广州市','440000');
199 insert into city values(198,'440200','韶关市','440000');
200 insert into city values(199,'440300','深圳市','440000');
201 insert into city values(200,'440400','珠海市','440000');
202 insert into city values(201,'440500','汕头市','440000');
203 insert into city values(202,'440600','佛山市','440000');
204 insert into city values(203,'440700','江门市','440000');
205 insert into city values(204,'440800','湛江市','440000');
206 insert into city values(205,'440900','茂名市','440000');
207 insert into city values(206,'441200','肇庆市','440000');
208 insert into city values(207,'441300','惠州市','440000');
209 insert into city values(208,'441400','梅州市','440000');
210 insert into city values(209,'441500','汕尾市','440000');
211 insert into city values(210,'441600','河源市','440000');
212 insert into city values(211,'441700','阳江市','440000');
213 insert into city values(212,'441800','清远市','440000');
214 insert into city values(213,'441900','东莞市','440000');
215 insert into city values(214,'442000','中山市','440000');
216 insert into city values(215,'445100','潮州市','440000');
217 insert into city values(216,'445200','揭阳市','440000');
218 insert into city values(217,'445300','云浮市','440000');
219 insert into city values(218,'450100','南宁市','450000');
220 insert into city values(219,'450200','柳州市','450000');
221 insert into city values(220,'450300','桂林市','450000');
222 insert into city values(221,'450400','梧州市','450000');
223 insert into city values(222,'450500','北海市','450000');
224 insert into city values(223,'450600','防城港市','450000');
225 insert into city values(224,'450700','钦州市','450000');
226 insert into city values(225,'450800','贵港市','450000');
227 insert into city values(226,'450900','玉林市','450000');
228 insert into city values(227,'451000','百色市','450000');
229 insert into city values(228,'451100','贺州市','450000');
230 insert into city values(229,'451200','河池市','450000');
231 insert into city values(230,'451300','来宾市','450000');
232 insert into city values(231,'451400','崇左市','450000');
233 insert into city values(232,'460100','海口市','460000');
234 insert into city values(233,'460200','三亚市','460000');
235 insert into city values(234,'469000','省直辖县级行政单位','460000');
236 insert into city values(235,'500100','市辖区','500000');
237 insert into city values(236,'500200','县','500000');
238 insert into city values(237,'500300','市','500000');
239 insert into city values(238,'510100','成都市','510000');
240 insert into city values(239,'510300','自贡市','510000');
241 insert into city values(240,'510400','攀枝花市','510000');
242 insert into city values(241,'510500','泸州市','510000');
243 insert into city values(242,'510600','德阳市','510000');
244 insert into city values(243,'510700','绵阳市','510000');
245 insert into city values(244,'510800','广元市','510000');
246 insert into city values(245,'510900','遂宁市','510000');
247 insert into city values(246,'511000','内江市','510000');
248 insert into city values(247,'511100','乐山市','510000');
249 insert into city values(248,'511300','南充市','510000');
250 insert into city values(249,'511400','眉山市','510000');
251 insert into city values(250,'511500','宜宾市','510000');
252 insert into city values(251,'511600','广安市','510000');
253 insert into city values(252,'511700','达州市','510000');
254 insert into city values(253,'511800','雅安市','510000');
255 insert into city values(254,'511900','巴中市','510000');
256 insert into city values(255,'512000','资阳市','510000');
257 insert into city values(256,'513200','阿坝藏族羌族自治州','510000');
258 insert into city values(257,'513300','甘孜藏族自治州','510000');
259 insert into city values(258,'513400','凉山彝族自治州','510000');
260 insert into city values(259,'520100','贵阳市','520000');
261 insert into city values(260,'520200','六盘水市','520000');
262 insert into city values(261,'520300','遵义市','520000');
263 insert into city values(262,'520400','安顺市','520000');
264 insert into city values(263,'522200','铜仁地区','520000');
265 insert into city values(264,'522300','黔西南布依族苗族自治州','520000');
266 insert into city values(265,'522400','毕节地区','520000');
267 insert into city values(266,'522600','黔东南苗族侗族自治州','520000');
268 insert into city values(267,'522700','黔南布依族苗族自治州','520000');
269 insert into city values(268,'530100','昆明市','530000');
270 insert into city values(269,'530300','曲靖市','530000');
271 insert into city values(270,'530400','玉溪市','530000');
272 insert into city values(271,'530500','保山市','530000');
273 insert into city values(272,'530600','昭通市','530000');
274 insert into city values(273,'530700','丽江市','530000');
275 insert into city values(274,'530800','思茅市','530000');
276 insert into city values(275,'530900','临沧市','530000');
277 insert into city values(276,'532300','楚雄彝族自治州','530000');
278 insert into city values(277,'532500','红河哈尼族彝族自治州','530000');
279 insert into city values(278,'532600','文山壮族苗族自治州','530000');
280 insert into city values(279,'532800','西双版纳傣族自治州','530000');
281 insert into city values(280,'532900','大理白族自治州','530000');
282 insert into city values(281,'533100','德宏傣族景颇族自治州','530000');
283 insert into city values(282,'533300','怒江傈僳族自治州','530000');
284 insert into city values(283,'533400','迪庆藏族自治州','530000');
285 insert into city values(284,'540100','拉萨市','540000');
286 insert into city values(285,'542100','昌都地区','540000');
287 insert into city values(286,'542200','山南地区','540000');
288 insert into city values(287,'542300','日喀则地区','540000');
289 insert into city values(288,'542400','那曲地区','540000');
290 insert into city values(289,'542500','阿里地区','540000');
291 insert into city values(290,'542600','林芝地区','540000');
292 insert into city values(291,'610100','西安市','610000');
293 insert into city values(292,'610200','铜川市','610000');
294 insert into city values(293,'610300','宝鸡市','610000');
295 insert into city values(294,'610400','咸阳市','610000');
296 insert into city values(295,'610500','渭南市','610000');
297 insert into city values(296,'610600','延安市','610000');
298 insert into city values(297,'610700','汉中市','610000');
299 insert into city values(298,'610800','榆林市','610000');
300 insert into city values(299,'610900','安康市','610000');
301 insert into city values(300,'611000','商洛市','610000');
302 insert into city values(301,'620100','兰州市','620000');
303 insert into city values(302,'620200','嘉峪关市','620000');
304 insert into city values(303,'620300','金昌市','620000');
305 insert into city values(304,'620400','白银市','620000');
306 insert into city values(305,'620500','天水市','620000');
307 insert into city values(306,'620600','武威市','620000');
308 insert into city values(307,'620700','张掖市','620000');
309 insert into city values(308,'620800','平凉市','620000');
310 insert into city values(309,'620900','酒泉市','620000');
311 insert into city values(310,'621000','庆阳市','620000');
312 insert into city values(311,'621100','定西市','620000');
313 insert into city values(312,'621200','陇南市','620000');
314 insert into city values(313,'622900','临夏回族自治州','620000');
315 insert into city values(314,'623000','甘南藏族自治州','620000');
316 insert into city values(315,'630100','西宁市','630000');
317 insert into city values(316,'632100','海东地区','630000');
318 insert into city values(317,'632200','海北藏族自治州','630000');
319 insert into city values(318,'632300','黄南藏族自治州','630000');
320 insert into city values(319,'632500','海南藏族自治州','630000');
321 insert into city values(320,'632600','果洛藏族自治州','630000');
322 insert into city values(321,'632700','玉树藏族自治州','630000');
323 insert into city values(322,'632800','海西蒙古族藏族自治州','630000');
324 insert into city values(323,'640100','银川市','640000');
325 insert into city values(324,'640200','石嘴山市','640000');
326 insert into city values(325,'640300','吴忠市','640000');
327 insert into city values(326,'640400','固原市','640000');
328 insert into city values(327,'640500','中卫市','640000');
329 insert into city values(328,'650100','乌鲁木齐市','650000');
330 insert into city values(329,'650200','克拉玛依市','650000');
331 insert into city values(330,'652100','吐鲁番地区','650000');
332 insert into city values(331,'652200','哈密地区','650000');
333 insert into city values(332,'652300','昌吉回族自治州','650000');
334 insert into city values(333,'652700','博尔塔拉蒙古自治州','650000');
335 insert into city values(334,'652800','巴音郭楞蒙古自治州','650000');
336 insert into city values(335,'652900','阿克苏地区','650000');
337 insert into city values(336,'653000','克孜勒苏柯尔克孜自治州','650000');
338 insert into city values(337,'653100','喀什地区','650000');
339 insert into city values(338,'653200','和田地区','650000');
340 insert into city values(339,'654000','伊犁哈萨克自治州','650000');
341 insert into city values(340,'654200','塔城地区','650000');
342 insert into city values(341,'654300','阿勒泰地区','650000');
343 insert into city values(342,'659000','省直辖行政单位','650000');

View Code

插入数据--区

  1 --插入区数据
  2 insert into area values(1,'110101','东城区','110100');
  3 insert into area values(2,'110102','西城区','110100');
  4 insert into area values(3,'110103','崇文区','110100');
  5 insert into area values(4,'110104','宣武区','110100');
  6 insert into area values(5,'110105','朝阳区','110100');
  7 insert into area values(6,'110106','丰台区','110100');
  8 insert into area values(7,'110107','石景山区','110100');
  9 insert into area values(8,'110108','海淀区','110100');
 10 insert into area values(9,'110109','门头沟区','110100');
 11 insert into area values(10,'110111','房山区','110100');
 12 insert into area values(11,'110112','通州区','110100');
 13 insert into area values(12,'110113','顺义区','110100');
 14 insert into area values(13,'110114','昌平区','110100');
 15 insert into area values(14,'110115','大兴区','110100');
 16 insert into area values(15,'110116','怀柔区','110100');
 17 insert into area values(16,'110117','平谷区','110100');
 18 insert into area values(17,'110228','密云县','110200');
 19 insert into area values(18,'110229','延庆县','110200');
 20 insert into area values(19,'120101','和平区','120100');
 21 insert into area values(20,'120102','河东区','120100');
 22 insert into area values(21,'120103','河西区','120100');
 23 insert into area values(22,'120104','南开区','120100');
 24 insert into area values(23,'120105','河北区','120100');
 25 insert into area values(24,'120106','红桥区','120100');
 26 insert into area values(25,'120107','塘沽区','120100');
 27 insert into area values(26,'120108','汉沽区','120100');
 28 insert into area values(27,'120109','大港区','120100');
 29 insert into area values(28,'120110','东丽区','120100');
 30 insert into area values(29,'120111','西青区','120100');
 31 insert into area values(30,'120112','津南区','120100');
 32 insert into area values(31,'120113','北辰区','120100');
 33 insert into area values(32,'120114','武清区','120100');
 34 insert into area values(33,'120115','宝坻区','120100');
 35 insert into area values(34,'120221','宁河县','120200');
 36 insert into area values(35,'120223','静海县','120200');
 37 insert into area values(36,'120225','蓟　县','120200');
 38 insert into area values(37,'130101','市辖区','130100');
 39 insert into area values(38,'130102','长安区','130100');
 40 insert into area values(39,'130103','桥东区','130100');
 41 insert into area values(40,'130104','桥西区','130100');
 42 insert into area values(41,'130105','新华区','130100');
 43 insert into area values(42,'130107','井陉矿区','130100');
 44 insert into area values(43,'130108','裕华区','130100');
 45 insert into area values(44,'130121','井陉县','130100');
 46 insert into area values(45,'130123','正定县','130100');
 47 insert into area values(46,'130124','栾城县','130100');
 48 insert into area values(47,'130125','行唐县','130100');
 49 insert into area values(48,'130126','灵寿县','130100');
 50 insert into area values(49,'130127','高邑县','130100');
 51 insert into area values(50,'130128','深泽县','130100');
 52 insert into area values(51,'130129','赞皇县','130100');
 53 insert into area values(52,'130130','无极县','130100');
 54 insert into area values(53,'130131','平山县','130100');
 55 insert into area values(54,'130132','元氏县','130100');
 56 insert into area values(55,'130133','赵　县','130100');
 57 insert into area values(56,'130181','辛集市','130100');
 58 insert into area values(57,'130182','藁城市','130100');
 59 insert into area values(58,'130183','晋州市','130100');
 60 insert into area values(59,'130184','新乐市','130100');
 61 insert into area values(60,'130185','鹿泉市','130100');
 62 insert into area values(61,'130201','市辖区','130200');
 63 insert into area values(62,'130202','路南区','130200');
 64 insert into area values(63,'130203','路北区','130200');
 65 insert into area values(64,'130204','古冶区','130200');
 66 insert into area values(65,'130205','开平区','130200');
 67 insert into area values(66,'130207','丰南区','130200');
 68 insert into area values(67,'130208','丰润区','130200');
 69 insert into area values(68,'130223','滦　县','130200');
 70 insert into area values(69,'130224','滦南县','130200');
 71 insert into area values(70,'130225','乐亭县','130200');
 72 insert into area values(71,'130227','迁西县','130200');
 73 insert into area values(72,'130229','玉田县','130200');
 74 insert into area values(73,'130230','唐海县','130200');
 75 insert into area values(74,'130281','遵化市','130200');
 76 insert into area values(75,'130283','迁安市','130200');
 77 insert into area values(76,'130301','市辖区','130300');
 78 insert into area values(77,'130302','海港区','130300');
 79 insert into area values(78,'130303','山海关区','130300');
 80 insert into area values(79,'130304','北戴河区','130300');
 81 insert into area values(80,'130321','青龙满族自治县','130300');
 82 insert into area values(81,'130322','昌黎县','130300');
 83 insert into area values(82,'130323','抚宁县','130300');
 84 insert into area values(83,'130324','卢龙县','130300');
 85 insert into area values(84,'130401','市辖区','130400');
 86 insert into area values(85,'130402','邯山区','130400');
 87 insert into area values(86,'130403','丛台区','130400');
 88 insert into area values(87,'130404','复兴区','130400');
 89 insert into area values(88,'130406','峰峰矿区','130400');
 90 insert into area values(89,'130421','邯郸县','130400');
 91 insert into area values(90,'130423','临漳县','130400');
 92 insert into area values(91,'130424','成安县','130400');
 93 insert into area values(92,'130425','大名县','130400');
 94 insert into area values(93,'130426','涉　县','130400');
 95 insert into area values(94,'130427','磁　县','130400');
 96 insert into area values(95,'130428','肥乡县','130400');
 97 insert into area values(96,'130429','永年县','130400');
 98 insert into area values(97,'130430','邱　县','130400');
 99 insert into area values(98,'130431','鸡泽县','130400');
100 insert into area values(99,'130432','广平县','130400');
101 insert into area values(100,'130433','馆陶县','130400');
102 insert into area values(101,'130434','魏　县','130400');
103 insert into area values(102,'130435','曲周县','130400');
104 insert into area values(103,'130481','武安市','130400');
105 insert into area values(104,'130501','市辖区','130500');
106 insert into area values(105,'130502','桥东区','130500');
107 insert into area values(106,'130503','桥西区','130500');
108 insert into area values(107,'130521','邢台县','130500');
109 insert into area values(108,'130522','临城县','130500');
110 insert into area values(109,'130523','内丘县','130500');
111 insert into area values(110,'130524','柏乡县','130500');
112 insert into area values(111,'130525','隆尧县','130500');
113 insert into area values(112,'130526','任　县','130500');
114 insert into area values(113,'130527','南和县','130500');
115 insert into area values(114,'130528','宁晋县','130500');
116 insert into area values(115,'130529','巨鹿县','130500');
117 insert into area values(116,'130530','新河县','130500');
118 insert into area values(117,'130531','广宗县','130500');
119 insert into area values(118,'130532','平乡县','130500');
120 insert into area values(119,'130533','威　县','130500');
121 insert into area values(120,'130534','清河县','130500');
122 insert into area values(121,'130535','临西县','130500');
123 insert into area values(122,'130581','南宫市','130500');
124 insert into area values(123,'130582','沙河市','130500');
125 insert into area values(124,'130601','市辖区','130600');
126 insert into area values(125,'130602','新市区','130600');
127 insert into area values(126,'130603','北市区','130600');
128 insert into area values(127,'130604','南市区','130600');
129 insert into area values(128,'130621','满城县','130600');
130 insert into area values(129,'130622','清苑县','130600');
131 insert into area values(130,'130623','涞水县','130600');
132 insert into area values(131,'130624','阜平县','130600');
133 insert into area values(132,'130625','徐水县','130600');
134 insert into area values(133,'130626','定兴县','130600');
135 insert into area values(134,'130627','唐　县','130600');
136 insert into area values(135,'130628','高阳县','130600');
137 insert into area values(136,'130629','容城县','130600');
138 insert into area values(137,'130630','涞源县','130600');
139 insert into area values(138,'130631','望都县','130600');
140 insert into area values(139,'130632','安新县','130600');
141 insert into area values(140,'130633','易　县','130600');
142 insert into area values(141,'130634','曲阳县','130600');
143 insert into area values(142,'130635','蠡　县','130600');
144 insert into area values(143,'130636','顺平县','130600');
145 insert into area values(144,'130637','博野县','130600');
146 insert into area values(145,'130638','雄　县','130600');
147 insert into area values(146,'130681','涿州市','130600');
148 insert into area values(147,'130682','定州市','130600');
149 insert into area values(148,'130683','安国市','130600');
150 insert into area values(149,'130684','高碑店市','130600');
151 insert into area values(150,'130701','市辖区','130700');
152 insert into area values(151,'130702','桥东区','130700');
153 insert into area values(152,'130703','桥西区','130700');
154 insert into area values(153,'130705','宣化区','130700');
155 insert into area values(154,'130706','下花园区','130700');
156 insert into area values(155,'130721','宣化县','130700');
157 insert into area values(156,'130722','张北县','130700');
158 insert into area values(157,'130723','康保县','130700');
159 insert into area values(158,'130724','沽源县','130700');
160 insert into area values(159,'130725','尚义县','130700');
161 insert into area values(160,'130726','蔚　县','130700');
162 insert into area values(161,'130727','阳原县','130700');
163 insert into area values(162,'130728','怀安县','130700');
164 insert into area values(163,'130729','万全县','130700');
165 insert into area values(164,'130730','怀来县','130700');
166 insert into area values(165,'130731','涿鹿县','130700');
167 insert into area values(166,'130732','赤城县','130700');
168 insert into area values(167,'130733','崇礼县','130700');
169 insert into area values(168,'130801','市辖区','130800');
170 insert into area values(169,'130802','双桥区','130800');
171 insert into area values(170,'130803','双滦区','130800');
172 insert into area values(171,'130804','鹰手营子矿区','130800');
173 insert into area values(172,'130821','承德县','130800');
174 insert into area values(173,'130822','兴隆县','130800');
175 insert into area values(174,'130823','平泉县','130800');
176 insert into area values(175,'130824','滦平县','130800');
177 insert into area values(176,'130825','隆化县','130800');
178 insert into area values(177,'130826','丰宁满族自治县','130800');
179 insert into area values(178,'130827','宽城满族自治县','130800');
180 insert into area values(179,'130828','围场满族蒙古族自治县','130800');
181 insert into area values(180,'130901','市辖区','130900');
182 insert into area values(181,'130902','新华区','130900');
183 insert into area values(182,'130903','运河区','130900');
184 insert into area values(183,'130921','沧　县','130900');
185 insert into area values(184,'130922','青　县','130900');
186 insert into area values(185,'130923','东光县','130900');
187 insert into area values(186,'130924','海兴县','130900');
188 insert into area values(187,'130925','盐山县','130900');
189 insert into area values(188,'130926','肃宁县','130900');
190 insert into area values(189,'130927','南皮县','130900');
191 insert into area values(190,'130928','吴桥县','130900');
192 insert into area values(191,'130929','献　县','130900');
193 insert into area values(192,'130930','孟村回族自治县','130900');
194 insert into area values(193,'130981','泊头市','130900');
195 insert into area values(194,'130982','任丘市','130900');
196 insert into area values(195,'130983','黄骅市','130900');
197 insert into area values(196,'130984','河间市','130900');
198 insert into area values(197,'131001','市辖区','131000');
199 insert into area values(198,'131002','安次区','131000');
200 insert into area values(199,'131003','广阳区','131000');
201 insert into area values(200,'131022','固安县','131000');
202 insert into area values(201,'131023','永清县','131000');
203 insert into area values(202,'131024','香河县','131000');
204 insert into area values(203,'131025','大城县','131000');
205 insert into area values(204,'131026','文安县','131000');
206 insert into area values(205,'131028','大厂回族自治县','131000');
207 insert into area values(206,'131081','霸州市','131000');
208 insert into area values(207,'131082','三河市','131000');
209 insert into area values(208,'131101','市辖区','131100');
210 insert into area values(209,'131102','桃城区','131100');
211 insert into area values(210,'131121','枣强县','131100');
212 insert into area values(211,'131122','武邑县','131100');
213 insert into area values(212,'131123','武强县','131100');
214 insert into area values(213,'131124','饶阳县','131100');
215 insert into area values(214,'131125','安平县','131100');
216 insert into area values(215,'131126','故城县','131100');
217 insert into area values(216,'131127','景　县','131100');
218 insert into area values(217,'131128','阜城县','131100');
219 insert into area values(218,'131181','冀州市','131100');
220 insert into area values(219,'131182','深州市','131100');
221 insert into area values(220,'140101','市辖区','140100');
222 insert into area values(221,'140105','小店区','140100');
223 insert into area values(222,'140106','迎泽区','140100');
224 insert into area values(223,'140107','杏花岭区','140100');
225 insert into area values(224,'140108','尖草坪区','140100');
226 insert into area values(225,'140109','万柏林区','140100');
227 insert into area values(226,'140110','晋源区','140100');
228 insert into area values(227,'140121','清徐县','140100');
229 insert into area values(228,'140122','阳曲县','140100');
230 insert into area values(229,'140123','娄烦县','140100');
231 insert into area values(230,'140181','古交市','140100');
232 insert into area values(231,'140201','市辖区','140200');
233 insert into area values(232,'140202','城　区','140200');
234 insert into area values(233,'140203','矿　区','140200');
235 insert into area values(234,'140211','南郊区','140200');
236 insert into area values(235,'140212','新荣区','140200');
237 insert into area values(236,'140221','阳高县','140200');
238 insert into area values(237,'140222','天镇县','140200');
239 insert into area values(238,'140223','广灵县','140200');
240 insert into area values(239,'140224','灵丘县','140200');
241 insert into area values(240,'140225','浑源县','140200');
242 insert into area values(241,'140226','左云县','140200');
243 insert into area values(242,'140227','大同县','140200');
244 insert into area values(243,'140301','市辖区','140300');
245 insert into area values(244,'140302','城　区','140300');
246 insert into area values(245,'140303','矿　区','140300');
247 insert into area values(246,'140311','郊　区','140300');
248 insert into area values(247,'140321','平定县','140300');
249 insert into area values(248,'140322','盂　县','140300');
250 insert into area values(249,'140401','市辖区','140400');
251 insert into area values(250,'140402','城　区','140400');
252 insert into area values(251,'140411','郊　区','140400');
253 insert into area values(252,'140421','长治县','140400');
254 insert into area values(253,'140423','襄垣县','140400');
255 insert into area values(254,'140424','屯留县','140400');
256 insert into area values(255,'140425','平顺县','140400');
257 insert into area values(256,'140426','黎城县','140400');
258 insert into area values(257,'140427','壶关县','140400');
259 insert into area values(258,'140428','长子县','140400');
260 insert into area values(259,'140429','武乡县','140400');
261 insert into area values(260,'140430','沁　县','140400');
262 insert into area values(261,'140431','沁源县','140400');
263 insert into area values(262,'140481','潞城市','140400');
264 insert into area values(263,'140501','市辖区','140500');
265 insert into area values(264,'140502','城　区','140500');
266 insert into area values(265,'140521','沁水县','140500');
267 insert into area values(266,'140522','阳城县','140500');
268 insert into area values(267,'140524','陵川县','140500');
269 insert into area values(268,'140525','泽州县','140500');
270 insert into area values(269,'140581','高平市','140500');
271 insert into area values(270,'140601','市辖区','140600');
272 insert into area values(271,'140602','朔城区','140600');
273 insert into area values(272,'140603','平鲁区','140600');
274 insert into area values(273,'140621','山阴县','140600');
275 insert into area values(274,'140622','应　县','140600');
276 insert into area values(275,'140623','右玉县','140600');
277 insert into area values(276,'140624','怀仁县','140600');
278 insert into area values(277,'140701','市辖区','140700');
279 insert into area values(278,'140702','榆次区','140700');
280 insert into area values(279,'140721','榆社县','140700');
281 insert into area values(280,'140722','左权县','140700');
282 insert into area values(281,'140723','和顺县','140700');
283 insert into area values(282,'140724','昔阳县','140700');
284 insert into area values(283,'140725','寿阳县','140700');
285 insert into area values(284,'140726','太谷县','140700');
286 insert into area values(285,'140727','祁　县','140700');
287 insert into area values(286,'140728','平遥县','140700');
288 insert into area values(287,'140729','灵石县','140700');
289 insert into area values(288,'140781','介休市','140700');
290 insert into area values(289,'140801','市辖区','140800');
291 insert into area values(290,'140802','盐湖区','140800');
292 insert into area values(291,'140821','临猗县','140800');
293 insert into area values(292,'140822','万荣县','140800');
294 insert into area values(293,'140823','闻喜县','140800');
295 insert into area values(294,'140824','稷山县','140800');
296 insert into area values(295,'140825','新绛县','140800');
297 insert into area values(296,'140826','绛　县','140800');
298 insert into area values(297,'140827','垣曲县','140800');
299 insert into area values(298,'140828','夏　县','140800');
300 insert into area values(299,'140829','平陆县','140800');
301 insert into area values(300,'140830','芮城县','140800');
302 insert into area values(301,'140881','永济市','140800');
303 insert into area values(302,'140882','河津市','140800');
304 insert into area values(303,'140901','市辖区','140900');
305 insert into area values(304,'140902','忻府区','140900');
306 insert into area values(305,'140921','定襄县','140900');
307 insert into area values(306,'140922','五台县','140900');
308 insert into area values(307,'140923','代　县','140900');
309 insert into area values(308,'140924','繁峙县','140900');
310 insert into area values(309,'140925','宁武县','140900');
311 insert into area values(310,'140926','静乐县','140900');
312 insert into area values(311,'140927','神池县','140900');
313 insert into area values(312,'140928','五寨县','140900');
314 insert into area values(313,'140929','岢岚县','140900');
315 insert into area values(314,'140930','河曲县','140900');
316 insert into area values(315,'140931','保德县','140900');
317 insert into area values(316,'140932','偏关县','140900');
318 insert into area values(317,'140981','原平市','140900');
319 insert into area values(318,'141001','市辖区','141000');
320 insert into area values(319,'141002','尧都区','141000');
321 insert into area values(320,'141021','曲沃县','141000');
322 insert into area values(321,'141022','翼城县','141000');
323 insert into area values(322,'141023','襄汾县','141000');
324 insert into area values(323,'141024','洪洞县','141000');
325 insert into area values(324,'141025','古　县','141000');
326 insert into area values(325,'141026','安泽县','141000');
327 insert into area values(326,'141027','浮山县','141000');
328 insert into area values(327,'141028','吉　县','141000');
329 insert into area values(328,'141029','乡宁县','141000');
330 insert into area values(329,'141030','大宁县','141000');
331 insert into area values(330,'141031','隰　县','141000');
332 insert into area values(331,'141032','永和县','141000');
333 insert into area values(332,'141033','蒲　县','141000');
334 insert into area values(333,'141034','汾西县','141000');
335 insert into area values(334,'141081','侯马市','141000');
336 insert into area values(335,'141082','霍州市','141000');
337 insert into area values(336,'141101','市辖区','141100');
338 insert into area values(337,'141102','离石区','141100');
339 insert into area values(338,'141121','文水县','141100');
340 insert into area values(339,'141122','交城县','141100');
341 insert into area values(340,'141123','兴　县','141100');
342 insert into area values(341,'141124','临　县','141100');
343 insert into area values(342,'141125','柳林县','141100');
344 insert into area values(343,'141126','石楼县','141100');
345 insert into area values(344,'141127','岚　县','141100');
346 insert into area values(345,'141128','方山县','141100');
347 insert into area values(346,'141129','中阳县','141100');
348 insert into area values(347,'141130','交口县','141100');
349 insert into area values(348,'141181','孝义市','141100');
350 insert into area values(349,'141182','汾阳市','141100');
351 insert into area values(350,'150101','市辖区','150100');
352 insert into area values(351,'150102','新城区','150100');
353 insert into area values(352,'150103','回民区','150100');
354 insert into area values(353,'150104','玉泉区','150100');
355 insert into area values(354,'150105','赛罕区','150100');
356 insert into area values(355,'150121','土默特左旗','150100');
357 insert into area values(356,'150122','托克托县','150100');
358 insert into area values(357,'150123','和林格尔县','150100');

View Code

insert into area values(358,'150124','清水河县','150100');
insert into area values(359,'150125','武川县','150100');
insert into area values(360,'150201','市辖区','150200');
insert into area values(361,'150202','东河区','150200');
insert into area values(362,'150203','昆都仑区','150200');
insert into area values(363,'150204','青山区','150200');
insert into area values(364,'150205','石拐区','150200');
insert into area values(365,'150206','白云矿区','150200');
insert into area values(366,'150207','九原区','150200');
insert into area values(367,'150221','土默特右旗','150200');
insert into area values(368,'150222','固阳县','150200');
insert into area values(369,'150223','达尔罕茂明安联合旗','150200');
insert into area values(370,'150301','市辖区','150300');
insert into area values(371,'150302','海勃湾区','150300');
insert into area values(372,'150303','海南区','150300');
insert into area values(373,'150304','乌达区','150300');
insert into area values(374,'150401','市辖区','150400');
insert into area values(375,'150402','红山区','150400');
insert into area values(376,'150403','元宝山区','150400');
insert into area values(377,'150404','松山区','150400');
insert into area values(378,'150421','阿鲁科尔沁旗','150400');
insert into area values(379,'150422','巴林左旗','150400');
insert into area values(380,'150423','巴林右旗','150400');
insert into area values(381,'150424','林西县','150400');
insert into area values(382,'150425','克什克腾旗','150400');
insert into area values(383,'150426','翁牛特旗','150400');
insert into area values(384,'150428','喀喇沁旗','150400');
insert into area values(385,'150429','宁城县','150400');
insert into area values(386,'150430','敖汉旗','150400');
insert into area values(387,'150501','市辖区','150500');
insert into area values(388,'150502','科尔沁区','150500');
insert into area values(389,'150521','科尔沁左翼中旗','150500');
insert into area values(390,'150522','科尔沁左翼后旗','150500');
insert into area values(391,'150523','开鲁县','150500');
insert into area values(392,'150524','库伦旗','150500');
insert into area values(393,'150525','奈曼旗','150500');
insert into area values(394,'150526','扎鲁特旗','150500');
insert into area values(395,'150581','霍林郭勒市','150500');
insert into area values(396,'150602','东胜区','150600');
insert into area values(397,'150621','达拉特旗','150600');
insert into area values(398,'150622','准格尔旗','150600');
insert into area values(399,'150623','鄂托克前旗','150600');
insert into area values(400,'150624','鄂托克旗','150600');
insert into area values(401,'150625','杭锦旗','150600');
insert into area values(402,'150626','乌审旗','150600');
insert into area values(403,'150627','伊金霍洛旗','150600');
insert into area values(404,'150701','市辖区','150700');
insert into area values(405,'150702','海拉尔区','150700');
insert into area values(406,'150721','阿荣旗','150700');
insert into area values(407,'150722','莫力达瓦达斡尔族自治旗','150700');
insert into area values(408,'150723','鄂伦春自治旗','150700');
insert into area values(409,'150724','鄂温克族自治旗','150700');
insert into area values(410,'150725','陈巴尔虎旗','150700');
insert into area values(411,'150726','新巴尔虎左旗','150700');
insert into area values(412,'150727','新巴尔虎右旗','150700');
insert into area values(413,'150781','满洲里市','150700');
insert into area values(414,'150782','牙克石市','150700');
insert into area values(415,'150783','扎兰屯市','150700');
insert into area values(416,'150784','额尔古纳市','150700');
insert into area values(417,'150785','根河市','150700');
insert into area values(418,'150801','市辖区','150800');
insert into area values(419,'150802','临河区','150800');
insert into area values(420,'150821','五原县','150800');
insert into area values(421,'150822','磴口县','150800');
insert into area values(422,'150823','乌拉特前旗','150800');
insert into area values(423,'150824','乌拉特中旗','150800');
insert into area values(424,'150825','乌拉特后旗','150800');
insert into area values(425,'150826','杭锦后旗','150800');
insert into area values(426,'150901','市辖区','150900');
insert into area values(427,'150902','集宁区','150900');
insert into area values(428,'150921','卓资县','150900');
insert into area values(429,'150922','化德县','150900');
insert into area values(430,'150923','商都县','150900');
insert into area values(431,'150924','兴和县','150900');
insert into area values(432,'150925','凉城县','150900');
insert into area values(433,'150926','察哈尔右翼前旗','150900');
insert into area values(434,'150927','察哈尔右翼中旗','150900');
insert into area values(435,'150928','察哈尔右翼后旗','150900');
insert into area values(436,'150929','四子王旗','150900');
insert into area values(437,'150981','丰镇市','150900');
insert into area values(438,'152201','乌兰浩特市','152200');
insert into area values(439,'152202','阿尔山市','152200');
insert into area values(440,'152221','科尔沁右翼前旗','152200');
insert into area values(441,'152222','科尔沁右翼中旗','152200');
insert into area values(442,'152223','扎赉特旗','152200');
insert into area values(443,'152224','突泉县','152200');
insert into area values(444,'152501','二连浩特市','152500');
insert into area values(445,'152502','锡林浩特市','152500');
insert into area values(446,'152522','阿巴嘎旗','152500');
insert into area values(447,'152523','苏尼特左旗','152500');
insert into area values(448,'152524','苏尼特右旗','152500');
insert into area values(449,'152525','东乌珠穆沁旗','152500');
insert into area values(450,'152526','西乌珠穆沁旗','152500');
insert into area values(451,'152527','太仆寺旗','152500');
insert into area values(452,'152528','镶黄旗','152500');
insert into area values(453,'152529','正镶白旗','152500');
insert into area values(454,'152530','正蓝旗','152500');
insert into area values(455,'152531','多伦县','152500');
insert into area values(456,'152921','阿拉善左旗','152900');
insert into area values(457,'152922','阿拉善右旗','152900');
insert into area values(458,'152923','额济纳旗','152900');
insert into area values(459,'210101','市辖区','210100');
insert into area values(460,'210102','和平区','210100');
insert into area values(461,'210103','沈河区','210100');
insert into area values(462,'210104','大东区','210100');
insert into area values(463,'210105','皇姑区','210100');
insert into area values(464,'210106','铁西区','210100');
insert into area values(465,'210111','苏家屯区','210100');
insert into area values(466,'210112','东陵区','210100');
insert into area values(467,'210113','新城子区','210100');
insert into area values(468,'210114','于洪区','210100');
insert into area values(469,'210122','辽中县','210100');
insert into area values(470,'210123','康平县','210100');
insert into area values(471,'210124','法库县','210100');
insert into area values(472,'210181','新民市','210100');
insert into area values(473,'210201','市辖区','210200');
insert into area values(474,'210202','中山区','210200');
insert into area values(475,'210203','西岗区','210200');
insert into area values(476,'210204','沙河口区','210200');
insert into area values(477,'210211','甘井子区','210200');
insert into area values(478,'210212','旅顺口区','210200');
insert into area values(479,'210213','金州区','210200');
insert into area values(480,'210224','长海县','210200');
insert into area values(481,'210281','瓦房店市','210200');
insert into area values(482,'210282','普兰店市','210200');
insert into area values(483,'210283','庄河市','210200');
insert into area values(484,'210301','市辖区','210300');
insert into area values(485,'210302','铁东区','210300');
insert into area values(486,'210303','铁西区','210300');
insert into area values(487,'210304','立山区','210300');
insert into area values(488,'210311','千山区','210300');
insert into area values(489,'210321','台安县','210300');
insert into area values(490,'210323','岫岩满族自治县','210300');
insert into area values(491,'210381','海城市','210300');
insert into area values(492,'210401','市辖区','210400');
insert into area values(493,'210402','新抚区','210400');
insert into area values(494,'210403','东洲区','210400');
insert into area values(495,'210404','望花区','210400');
insert into area values(496,'210411','顺城区','210400');
insert into area values(497,'210421','抚顺县','210400');
insert into area values(498,'210422','新宾满族自治县','210400');
insert into area values(499,'210423','清原满族自治县','210400');
insert into area values(500,'210501','市辖区','210500');
insert into area values(501,'210502','平山区','210500');
insert into area values(502,'210503','溪湖区','210500');
insert into area values(503,'210504','明山区','210500');
insert into area values(504,'210505','南芬区','210500');
insert into area values(505,'210521','本溪满族自治县','210500');
insert into area values(506,'210522','桓仁满族自治县','210500');
insert into area values(507,'210601','市辖区','210600');
insert into area values(508,'210602','元宝区','210600');
insert into area values(509,'210603','振兴区','210600');
insert into area values(510,'210604','振安区','210600');
insert into area values(511,'210624','宽甸满族自治县','210600');
insert into area values(512,'210681','东港市','210600');
insert into area values(513,'210682','凤城市','210600');
insert into area values(514,'210701','市辖区','210700');
insert into area values(515,'210702','古塔区','210700');
insert into area values(516,'210703','凌河区','210700');
insert into area values(517,'210711','太和区','210700');
insert into area values(518,'210726','黑山县','210700');
insert into area values(519,'210727','义　县','210700');
insert into area values(520,'210781','凌海市','210700');
insert into area values(521,'210782','北宁市','210700');
insert into area values(522,'210801','市辖区','210800');
insert into area values(523,'210802','站前区','210800');
insert into area values(524,'210803','西市区','210800');
insert into area values(525,'210804','鲅鱼圈区','210800');
insert into area values(526,'210811','老边区','210800');
insert into area values(527,'210881','盖州市','210800');
insert into area values(528,'210882','大石桥市','210800');
insert into area values(529,'210901','市辖区','210900');
insert into area values(530,'210902','海州区','210900');
insert into area values(531,'210903','新邱区','210900');
insert into area values(532,'210904','太平区','210900');
insert into area values(533,'210905','清河门区','210900');
insert into area values(534,'210911','细河区','210900');
insert into area values(535,'210921','阜新蒙古族自治县','210900');
insert into area values(536,'210922','彰武县','210900');
insert into area values(537,'211001','市辖区','211000');
insert into area values(538,'211002','白塔区','211000');
insert into area values(539,'211003','文圣区','211000');
insert into area values(540,'211004','宏伟区','211000');
insert into area values(541,'211005','弓长岭区','211000');
insert into area values(542,'211011','太子河区','211000');
insert into area values(543,'211021','辽阳县','211000');
insert into area values(544,'211081','灯塔市','211000');
insert into area values(545,'211101','市辖区','211100');
insert into area values(546,'211102','双台子区','211100');
insert into area values(547,'211103','兴隆台区','211100');
insert into area values(548,'211121','大洼县','211100');
insert into area values(549,'211122','盘山县','211100');
insert into area values(550,'211201','市辖区','211200');
insert into area values(551,'211202','银州区','211200');
insert into area values(552,'211204','清河区','211200');
insert into area values(553,'211221','铁岭县','211200');
insert into area values(554,'211223','西丰县','211200');
insert into area values(555,'211224','昌图县','211200');
insert into area values(556,'211281','调兵山市','211200');
insert into area values(557,'211282','开原市','211200');
insert into area values(558,'211301','市辖区','211300');
insert into area values(559,'211302','双塔区','211300');
insert into area values(560,'211303','龙城区','211300');
insert into area values(561,'211321','朝阳县','211300');
insert into area values(562,'211322','建平县','211300');
insert into area values(563,'211324','喀喇沁左翼蒙古族自治县','211300');
insert into area values(564,'211381','北票市','211300');
insert into area values(565,'211382','凌源市','211300');
insert into area values(566,'211401','市辖区','211400');
insert into area values(567,'211402','连山区','211400');
insert into area values(568,'211403','龙港区','211400');
insert into area values(569,'211404','南票区','211400');
insert into area values(570,'211421','绥中县','211400');
insert into area values(571,'211422','建昌县','211400');
insert into area values(572,'211481','兴城市','211400');
insert into area values(573,'220101','市辖区','220100');
insert into area values(574,'220102','南关区','220100');
insert into area values(575,'220103','宽城区','220100');
insert into area values(576,'220104','朝阳区','220100');
insert into area values(577,'220105','二道区','220100');
insert into area values(578,'220106','绿园区','220100');
insert into area values(579,'220112','双阳区','220100');
insert into area values(580,'220122','农安县','220100');
insert into area values(581,'220181','九台市','220100');
insert into area values(582,'220182','榆树市','220100');
insert into area values(583,'220183','德惠市','220100');
insert into area values(584,'220201','市辖区','220200');
insert into area values(585,'220202','昌邑区','220200');
insert into area values(586,'220203','龙潭区','220200');
insert into area values(587,'220204','船营区','220200');
insert into area values(588,'220211','丰满区','220200');
insert into area values(589,'220221','永吉县','220200');
insert into area values(590,'220281','蛟河市','220200');
insert into area values(591,'220282','桦甸市','220200');
insert into area values(592,'220283','舒兰市','220200');
insert into area values(593,'220284','磐石市','220200');
insert into area values(594,'220301','市辖区','220300');
insert into area values(595,'220302','铁西区','220300');
insert into area values(596,'220303','铁东区','220300');
insert into area values(597,'220322','梨树县','220300');
insert into area values(598,'220323','伊通满族自治县','220300');
insert into area values(599,'220381','公主岭市','220300');
insert into area values(600,'220382','双辽市','220300');
insert into area values(601,'220401','市辖区','220400');
insert into area values(602,'220402','龙山区','220400');
insert into area values(603,'220403','西安区','220400');
insert into area values(604,'220421','东丰县','220400');
insert into area values(605,'220422','东辽县','220400');
insert into area values(606,'220501','市辖区','220500');
insert into area values(607,'220502','东昌区','220500');
insert into area values(608,'220503','二道江区','220500');
insert into area values(609,'220521','通化县','220500');
insert into area values(610,'220523','辉南县','220500');
insert into area values(611,'220524','柳河县','220500');
insert into area values(612,'220581','梅河口市','220500');
insert into area values(613,'220582','集安市','220500');
insert into area values(614,'220601','市辖区','220600');
insert into area values(615,'220602','八道江区','220600');
insert into area values(616,'220621','抚松县','220600');
insert into area values(617,'220622','靖宇县','220600');
insert into area values(618,'220623','长白朝鲜族自治县','220600');
insert into area values(619,'220625','江源县','220600');
insert into area values(620,'220681','临江市','220600');
insert into area values(621,'220701','市辖区','220700');
insert into area values(622,'220702','宁江区','220700');
insert into area values(623,'220721','前郭尔罗斯蒙古族自治县','220700');
insert into area values(624,'220722','长岭县','220700');
insert into area values(625,'220723','乾安县','220700');
insert into area values(626,'220724','扶余县','220700');
insert into area values(627,'220801','市辖区','220800');
insert into area values(628,'220802','洮北区','220800');
insert into area values(629,'220821','镇赉县','220800');
insert into area values(630,'220822','通榆县','220800');
insert into area values(631,'220881','洮南市','220800');
insert into area values(632,'220882','大安市','220800');
insert into area values(633,'222401','延吉市','222400');
insert into area values(634,'222402','图们市','222400');
insert into area values(635,'222403','敦化市','222400');
insert into area values(636,'222404','珲春市','222400');
insert into area values(637,'222405','龙井市','222400');
insert into area values(638,'222406','和龙市','222400');
insert into area values(639,'222424','汪清县','222400');
insert into area values(640,'222426','安图县','222400');
insert into area values(641,'230101','市辖区','230100');
insert into area values(642,'230102','道里区','230100');
insert into area values(643,'230103','南岗区','230100');
insert into area values(644,'230104','道外区','230100');
insert into area values(645,'230106','香坊区','230100');
insert into area values(646,'230107','动力区','230100');
insert into area values(647,'230108','平房区','230100');
insert into area values(648,'230109','松北区','230100');
insert into area values(649,'230111','呼兰区','230100');
insert into area values(650,'230123','依兰县','230100');
insert into area values(651,'230124','方正县','230100');
insert into area values(652,'230125','宾　县','230100');
insert into area values(653,'230126','巴彦县','230100');
insert into area values(654,'230127','木兰县','230100');
insert into area values(655,'230128','通河县','230100');
insert into area values(656,'230129','延寿县','230100');
insert into area values(657,'230181','阿城市','230100');
insert into area values(658,'230182','双城市','230100');
insert into area values(659,'230183','尚志市','230100');
insert into area values(660,'230184','五常市','230100');
insert into area values(661,'230201','市辖区','230200');
insert into area values(662,'230202','龙沙区','230200');
insert into area values(663,'230203','建华区','230200');
insert into area values(664,'230204','铁锋区','230200');
insert into area values(665,'230205','昂昂溪区','230200');
insert into area values(666,'230206','富拉尔基区','230200');
insert into area values(667,'230207','碾子山区','230200');
insert into area values(668,'230208','梅里斯达斡尔族区','230200');
insert into area values(669,'230221','龙江县','230200');
insert into area values(670,'230223','依安县','230200');
insert into area values(671,'230224','泰来县','230200');
insert into area values(672,'230225','甘南县','230200');
insert into area values(673,'230227','富裕县','230200');
insert into area values(674,'230229','克山县','230200');
insert into area values(675,'230230','克东县','230200');
insert into area values(676,'230231','拜泉县','230200');
insert into area values(677,'230281','讷河市','230200');
insert into area values(678,'230301','市辖区','230300');
insert into area values(679,'230302','鸡冠区','230300');
insert into area values(680,'230303','恒山区','230300');
insert into area values(681,'230304','滴道区','230300');
insert into area values(682,'230305','梨树区','230300');
insert into area values(683,'230306','城子河区','230300');
insert into area values(684,'230307','麻山区','230300');
insert into area values(685,'230321','鸡东县','230300');
insert into area values(686,'230381','虎林市','230300');
insert into area values(687,'230382','密山市','230300');
insert into area values(688,'230401','市辖区','230400');
insert into area values(689,'230402','向阳区','230400');
insert into area values(690,'230403','工农区','230400');
insert into area values(691,'230404','南山区','230400');
insert into area values(692,'230405','兴安区','230400');
insert into area values(693,'230406','东山区','230400');
insert into area values(694,'230407','兴山区','230400');
insert into area values(695,'230421','萝北县','230400');
insert into area values(696,'230422','绥滨县','230400');
insert into area values(697,'230501','市辖区','230500');
insert into area values(698,'230502','尖山区','230500');
insert into area values(699,'230503','岭东区','230500');
insert into area values(700,'230505','四方台区','230500');
insert into area values(701,'230506','宝山区','230500');
insert into area values(702,'230521','集贤县','230500');
insert into area values(703,'230522','友谊县','230500');
insert into area values(704,'230523','宝清县','230500');
insert into area values(705,'230524','饶河县','230500');
insert into area values(706,'230601','市辖区','230600');
insert into area values(707,'230602','萨尔图区','230600');
insert into area values(708,'230603','龙凤区','230600');
insert into area values(709,'230604','让胡路区','230600');
insert into area values(710,'230605','红岗区','230600');
insert into area values(711,'230606','大同区','230600');
insert into area values(712,'230621','肇州县','230600');
insert into area values(713,'230622','肇源县','230600');
insert into area values(714,'230623','林甸县','230600');
insert into area values(715,'230624','杜尔伯特蒙古族自治县','230600');
insert into area values(716,'230701','市辖区','230700');
insert into area values(717,'230702','伊春区','230700');
insert into area values(718,'230703','南岔区','230700');
insert into area values(719,'230704','友好区','230700');
insert into area values(720,'230705','西林区','230700');
insert into area values(721,'230706','翠峦区','230700');
insert into area values(722,'230707','新青区','230700');
insert into area values(723,'230708','美溪区','230700');
insert into area values(724,'230709','金山屯区','230700');
insert into area values(725,'230710','五营区','230700');
insert into area values(726,'230711','乌马河区','230700');
insert into area values(727,'230712','汤旺河区','230700');
insert into area values(728,'230713','带岭区','230700');
insert into area values(729,'230714','乌伊岭区','230700');
insert into area values(730,'230715','红星区','230700');
insert into area values(731,'230716','上甘岭区','230700');
insert into area values(732,'230722','嘉荫县','230700');
insert into area values(733,'230781','铁力市','230700');
insert into area values(734,'230801','市辖区','230800');
insert into area values(735,'230802','永红区','230800');
insert into area values(736,'230803','向阳区','230800');
insert into area values(737,'230804','前进区','230800');
insert into area values(738,'230805','东风区','230800');
insert into area values(739,'230811','郊　区','230800');
insert into area values(740,'230822','桦南县','230800');
insert into area values(741,'230826','桦川县','230800');
insert into area values(742,'230828','汤原县','230800');
insert into area values(743,'230833','抚远县','230800');
insert into area values(744,'230881','同江市','230800');
insert into area values(745,'230882','富锦市','230800');
insert into area values(746,'230901','市辖区','230900');
insert into area values(747,'230902','新兴区','230900');
insert into area values(748,'230903','桃山区','230900');
insert into area values(749,'230904','茄子河区','230900');
insert into area values(750,'230921','勃利县','230900');
insert into area values(751,'231001','市辖区','231000');
insert into area values(752,'231002','东安区','231000');
insert into area values(753,'231003','阳明区','231000');
insert into area values(754,'231004','爱民区','231000');
insert into area values(755,'231005','西安区','231000');
insert into area values(756,'231024','东宁县','231000');
insert into area values(757,'231025','林口县','231000');
insert into area values(758,'231081','绥芬河市','231000');
insert into area values(759,'231083','海林市','231000');
insert into area values(760,'231084','宁安市','231000');
insert into area values(761,'231085','穆棱市','231000');
insert into area values(762,'231101','市辖区','231100');
insert into area values(763,'231102','爱辉区','231100');
insert into area values(764,'231121','嫩江县','231100');
insert into area values(765,'231123','逊克县','231100');
insert into area values(766,'231124','孙吴县','231100');
insert into area values(767,'231181','北安市','231100');
insert into area values(768,'231182','五大连池市','231100');
insert into area values(769,'231201','市辖区','231200');
insert into area values(770,'231202','北林区','231200');
insert into area values(771,'231221','望奎县','231200');
insert into area values(772,'231222','兰西县','231200');
insert into area values(773,'231223','青冈县','231200');
insert into area values(774,'231224','庆安县','231200');
insert into area values(775,'231225','明水县','231200');
insert into area values(776,'231226','绥棱县','231200');
insert into area values(777,'231281','安达市','231200');
insert into area values(778,'231282','肇东市','231200');
insert into area values(779,'231283','海伦市','231200');
insert into area values(780,'232721','呼玛县','232700');
insert into area values(781,'232722','塔河县','232700');
insert into area values(782,'232723','漠河县','232700');
insert into area values(783,'310101','黄浦区','310100');
insert into area values(784,'310103','卢湾区','310100');
insert into area values(785,'310104','徐汇区','310100');
insert into area values(786,'310105','长宁区','310100');
insert into area values(787,'310106','静安区','310100');
insert into area values(788,'310107','普陀区','310100');
insert into area values(789,'310108','闸北区','310100');
insert into area values(790,'310109','虹口区','310100');
insert into area values(791,'310110','杨浦区','310100');
insert into area values(792,'310112','闵行区','310100');
insert into area values(793,'310113','宝山区','310100');
insert into area values(794,'310114','嘉定区','310100');
insert into area values(795,'310115','浦东新区','310100');
insert into area values(796,'310116','金山区','310100');
insert into area values(797,'310117','松江区','310100');
insert into area values(798,'310118','青浦区','310100');
insert into area values(799,'310119','南汇区','310100');
insert into area values(800,'310120','奉贤区','310100');
insert into area values(801,'310230','崇明县','310200');
insert into area values(802,'320101','市辖区','320100');
insert into area values(803,'320102','玄武区','320100');
insert into area values(804,'320103','白下区','320100');
insert into area values(805,'320104','秦淮区','320100');
insert into area values(806,'320105','建邺区','320100');
insert into area values(807,'320106','鼓楼区','320100');
insert into area values(808,'320107','下关区','320100');
insert into area values(809,'320111','浦口区','320100');
insert into area values(810,'320113','栖霞区','320100');
insert into area values(811,'320114','雨花台区','320100');
insert into area values(812,'320115','江宁区','320100');
insert into area values(813,'320116','六合区','320100');
insert into area values(814,'320124','溧水县','320100');
insert into area values(815,'320125','高淳县','320100');
insert into area values(816,'320201','市辖区','320200');
insert into area values(817,'320202','崇安区','320200');
insert into area values(818,'320203','南长区','320200');
insert into area values(819,'320204','北塘区','320200');
insert into area values(820,'320205','锡山区','320200');
insert into area values(821,'320206','惠山区','320200');
insert into area values(822,'320211','滨湖区','320200');
insert into area values(823,'320281','江阴市','320200');
insert into area values(824,'320282','宜兴市','320200');
insert into area values(825,'320301','市辖区','320300');
insert into area values(826,'320302','鼓楼区','320300');
insert into area values(827,'320303','云龙区','320300');
insert into area values(828,'320304','九里区','320300');
insert into area values(829,'320305','贾汪区','320300');
insert into area values(830,'320311','泉山区','320300');
insert into area values(831,'320321','丰　县','320300');
insert into area values(832,'320322','沛　县','320300');
insert into area values(833,'320323','铜山县','320300');
insert into area values(834,'320324','睢宁县','320300');
insert into area values(835,'320381','新沂市','320300');
insert into area values(836,'320382','邳州市','320300');
insert into area values(837,'320401','市辖区','320400');
insert into area values(838,'320402','天宁区','320400');
insert into area values(839,'320404','钟楼区','320400');
insert into area values(840,'320405','戚墅堰区','320400');
insert into area values(841,'320411','新北区','320400');
insert into area values(842,'320412','武进区','320400');
insert into area values(843,'320481','溧阳市','320400');
insert into area values(844,'320482','金坛市','320400');
insert into area values(845,'320501','市辖区','320500');
insert into area values(846,'320502','沧浪区','320500');
insert into area values(847,'320503','平江区','320500');
insert into area values(848,'320504','金阊区','320500');
insert into area values(849,'320505','虎丘区','320500');
insert into area values(850,'320506','吴中区','320500');
insert into area values(851,'320507','相城区','320500');
insert into area values(852,'320581','常熟市','320500');
insert into area values(853,'320582','张家港市','320500');
insert into area values(854,'320583','昆山市','320500');
insert into area values(855,'320584','吴江市','320500');
insert into area values(856,'320585','太仓市','320500');
insert into area values(857,'320601','市辖区','320600');
insert into area values(858,'320602','崇川区','320600');
insert into area values(859,'320611','港闸区','320600');
insert into area values(860,'320621','海安县','320600');
insert into area values(861,'320623','如东县','320600');
insert into area values(862,'320681','启东市','320600');
insert into area values(863,'320682','如皋市','320600');
insert into area values(864,'320683','通州市','320600');
insert into area values(865,'320684','海门市','320600');
insert into area values(866,'320701','市辖区','320700');
insert into area values(867,'320703','连云区','320700');
insert into area values(868,'320705','新浦区','320700');
insert into area values(869,'320706','海州区','320700');
insert into area values(870,'320721','赣榆县','320700');
insert into area values(871,'320722','东海县','320700');
insert into area values(872,'320723','灌云县','320700');
insert into area values(873,'320724','灌南县','320700');
insert into area values(874,'320801','市辖区','320800');
insert into area values(875,'320802','清河区','320800');
insert into area values(876,'320803','楚州区','320800');
insert into area values(877,'320804','淮阴区','320800');
insert into area values(878,'320811','清浦区','320800');
insert into area values(879,'320826','涟水县','320800');
insert into area values(880,'320829','洪泽县','320800');
insert into area values(881,'320830','盱眙县','320800');
insert into area values(882,'320831','金湖县','320800');
insert into area values(883,'320901','市辖区','320900');
insert into area values(884,'320902','亭湖区','320900');
insert into area values(885,'320903','盐都区','320900');
insert into area values(886,'320921','响水县','320900');
insert into area values(887,'320922','滨海县','320900');
insert into area values(888,'320923','阜宁县','320900');
insert into area values(889,'320924','射阳县','320900');
insert into area values(890,'320925','建湖县','320900');
insert into area values(891,'320981','东台市','320900');
insert into area values(892,'320982','大丰市','320900');
insert into area values(893,'321001','市辖区','321000');
insert into area values(894,'321002','广陵区','321000');
insert into area values(895,'321003','邗江区','321000');
insert into area values(896,'321011','郊　区','321000');
insert into area values(897,'321023','宝应县','321000');
insert into area values(898,'321081','仪征市','321000');
insert into area values(899,'321084','高邮市','321000');
insert into area values(900,'321088','江都市','321000');
insert into area values(901,'321101','市辖区','321100');
insert into area values(902,'321102','京口区','321100');
insert into area values(903,'321111','润州区','321100');
insert into area values(904,'321112','丹徒区','321100');
insert into area values(905,'321181','丹阳市','321100');
insert into area values(906,'321182','扬中市','321100');
insert into area values(907,'321183','句容市','321100');
insert into area values(908,'321201','市辖区','321200');
insert into area values(909,'321202','海陵区','321200');
insert into area values(910,'321203','高港区','321200');
insert into area values(911,'321281','兴化市','321200');
insert into area values(912,'321282','靖江市','321200');
insert into area values(913,'321283','泰兴市','321200');
insert into area values(914,'321284','姜堰市','321200');
insert into area values(915,'321301','市辖区','321300');
insert into area values(916,'321302','宿城区','321300');
insert into area values(917,'321311','宿豫区','321300');
insert into area values(918,'321322','沭阳县','321300');
insert into area values(919,'321323','泗阳县','321300');
insert into area values(920,'321324','泗洪县','321300');
insert into area values(921,'330101','市辖区','330100');
insert into area values(922,'330102','上城区','330100');
insert into area values(923,'330103','下城区','330100');
insert into area values(924,'330104','江干区','330100');
insert into area values(925,'330105','拱墅区','330100');
insert into area values(926,'330106','西湖区','330100');
insert into area values(927,'330108','滨江区','330100');
insert into area values(928,'330109','萧山区','330100');
insert into area values(929,'330110','余杭区','330100');
insert into area values(930,'330122','桐庐县','330100');
insert into area values(931,'330127','淳安县','330100');
insert into area values(932,'330182','建德市','330100');
insert into area values(933,'330183','富阳市','330100');
insert into area values(934,'330185','临安市','330100');
insert into area values(935,'330201','市辖区','330200');
insert into area values(936,'330203','海曙区','330200');
insert into area values(937,'330204','江东区','330200');
insert into area values(938,'330205','江北区','330200');
insert into area values(939,'330206','北仑区','330200');
insert into area values(940,'330211','镇海区','330200');
insert into area values(941,'330212','鄞州区','330200');
insert into area values(942,'330225','象山县','330200');
insert into area values(943,'330226','宁海县','330200');
insert into area values(944,'330281','余姚市','330200');
insert into area values(945,'330282','慈溪市','330200');
insert into area values(946,'330283','奉化市','330200');
insert into area values(947,'330301','市辖区','330300');
insert into area values(948,'330302','鹿城区','330300');
insert into area values(949,'330303','龙湾区','330300');
insert into area values(950,'330304','瓯海区','330300');
insert into area values(951,'330322','洞头县','330300');
insert into area values(952,'330324','永嘉县','330300');
insert into area values(953,'330326','平阳县','330300');
insert into area values(954,'330327','苍南县','330300');
insert into area values(955,'330328','文成县','330300');
insert into area values(956,'330329','泰顺县','330300');
insert into area values(957,'330381','瑞安市','330300');
insert into area values(958,'330382','乐清市','330300');
insert into area values(959,'330401','市辖区','330400');
insert into area values(960,'330402','秀城区','330400');
insert into area values(961,'330411','秀洲区','330400');
insert into area values(962,'330421','嘉善县','330400');
insert into area values(963,'330424','海盐县','330400');
insert into area values(964,'330481','海宁市','330400');
insert into area values(965,'330482','平湖市','330400');
insert into area values(966,'330483','桐乡市','330400');
insert into area values(967,'330501','市辖区','330500');
insert into area values(968,'330502','吴兴区','330500');
insert into area values(969,'330503','南浔区','330500');
insert into area values(970,'330521','德清县','330500');
insert into area values(971,'330522','长兴县','330500');
insert into area values(972,'330523','安吉县','330500');
insert into area values(973,'330601','市辖区','330600');
insert into area values(974,'330602','越城区','330600');
insert into area values(975,'330621','绍兴县','330600');
insert into area values(976,'330624','新昌县','330600');
insert into area values(977,'330681','诸暨市','330600');
insert into area values(978,'330682','上虞市','330600');
insert into area values(979,'330683','嵊州市','330600');
insert into area values(980,'330701','市辖区','330700');
insert into area values(981,'330702','婺城区','330700');
insert into area values(982,'330703','金东区','330700');
insert into area values(983,'330723','武义县','330700');
insert into area values(984,'330726','浦江县','330700');
insert into area values(985,'330727','磐安县','330700');
insert into area values(986,'330781','兰溪市','330700');
insert into area values(987,'330782','义乌市','330700');
insert into area values(988,'330783','东阳市','330700');
insert into area values(989,'330784','永康市','330700');
insert into area values(990,'330801','市辖区','330800');
insert into area values(991,'330802','柯城区','330800');
insert into area values(992,'330803','衢江区','330800');
insert into area values(993,'330822','常山县','330800');
insert into area values(994,'330824','开化县','330800');
insert into area values(995,'330825','龙游县','330800');
insert into area values(996,'330881','江山市','330800');
insert into area values(997,'330901','市辖区','330900');
insert into area values(998,'330902','定海区','330900');
insert into area values(999,'330903','普陀区','330900');
insert into area values(1000,'330921','岱山县','330900');
insert into area values(1001,'330922','嵊泗县','330900');
insert into area values(1002,'331001','市辖区','331000');
insert into area values(1003,'331002','椒江区','331000');
insert into area values(1004,'331003','黄岩区','331000');
insert into area values(1005,'331004','路桥区','331000');
insert into area values(1006,'331021','玉环县','331000');
insert into area values(1007,'331022','三门县','331000');
insert into area values(1008,'331023','天台县','331000');
insert into area values(1009,'331024','仙居县','331000');
insert into area values(1010,'331081','温岭市','331000');
insert into area values(1011,'331082','临海市','331000');
insert into area values(1012,'331101','市辖区','331100');
insert into area values(1013,'331102','莲都区','331100');
insert into area values(1014,'331121','青田县','331100');
insert into area values(1015,'331122','缙云县','331100');
insert into area values(1016,'331123','遂昌县','331100');
insert into area values(1017,'331124','松阳县','331100');
insert into area values(1018,'331125','云和县','331100');
insert into area values(1019,'331126','庆元县','331100');
insert into area values(1020,'331127','景宁畲族自治县','331100');
insert into area values(1021,'331181','龙泉市','331100');
insert into area values(1022,'340101','市辖区','340100');
insert into area values(1023,'340102','瑶海区','340100');
insert into area values(1024,'340103','庐阳区','340100');
insert into area values(1025,'340104','蜀山区','340100');
insert into area values(1026,'340111','包河区','340100');
insert into area values(1027,'340121','长丰县','340100');
insert into area values(1028,'340122','肥东县','340100');
insert into area values(1029,'340123','肥西县','340100');
insert into area values(1030,'340201','市辖区','340200');
insert into area values(1031,'340202','镜湖区','340200');
insert into area values(1032,'340203','马塘区','340200');
insert into area values(1033,'340204','新芜区','340200');
insert into area values(1034,'340207','鸠江区','340200');
insert into area values(1035,'340221','芜湖县','340200');
insert into area values(1036,'340222','繁昌县','340200');
insert into area values(1037,'340223','南陵县','340200');
insert into area values(1038,'340301','市辖区','340300');
insert into area values(1039,'340302','龙子湖区','340300');
insert into area values(1040,'340303','蚌山区','340300');
insert into area values(1041,'340304','禹会区','340300');
insert into area values(1042,'340311','淮上区','340300');
insert into area values(1043,'340321','怀远县','340300');
insert into area values(1044,'340322','五河县','340300');
insert into area values(1045,'340323','固镇县','340300');
insert into area values(1046,'340401','市辖区','340400');
insert into area values(1047,'340402','大通区','340400');
insert into area values(1048,'340403','田家庵区','340400');
insert into area values(1049,'340404','谢家集区','340400');
insert into area values(1050,'340405','八公山区','340400');

View Code

   1 insert into area values(1051,'340406','潘集区','340400');
   2 insert into area values(1052,'340421','凤台县','340400');
   3 insert into area values(1053,'340501','市辖区','340500');
   4 insert into area values(1054,'340502','金家庄区','340500');
   5 insert into area values(1055,'340503','花山区','340500');
   6 insert into area values(1056,'340504','雨山区','340500');
   7 insert into area values(1057,'340521','当涂县','340500');
   8 insert into area values(1058,'340601','市辖区','340600');
   9 insert into area values(1059,'340602','杜集区','340600');
  10 insert into area values(1060,'340603','相山区','340600');
  11 insert into area values(1061,'340604','烈山区','340600');
  12 insert into area values(1062,'340621','濉溪县','340600');
  13 insert into area values(1063,'340701','市辖区','340700');
  14 insert into area values(1064,'340702','铜官山区','340700');
  15 insert into area values(1065,'340703','狮子山区','340700');
  16 insert into area values(1066,'340711','郊　区','340700');
  17 insert into area values(1067,'340721','铜陵县','340700');
  18 insert into area values(1068,'340801','市辖区','340800');
  19 insert into area values(1069,'340802','迎江区','340800');
  20 insert into area values(1070,'340803','大观区','340800');
  21 insert into area values(1071,'340811','郊　区','340800');
  22 insert into area values(1072,'340822','怀宁县','340800');
  23 insert into area values(1073,'340823','枞阳县','340800');
  24 insert into area values(1074,'340824','潜山县','340800');
  25 insert into area values(1075,'340825','太湖县','340800');
  26 insert into area values(1076,'340826','宿松县','340800');
  27 insert into area values(1077,'340827','望江县','340800');
  28 insert into area values(1078,'340828','岳西县','340800');
  29 insert into area values(1079,'340881','桐城市','340800');
  30 insert into area values(1080,'341001','市辖区','341000');
  31 insert into area values(1081,'341002','屯溪区','341000');
  32 insert into area values(1082,'341003','黄山区','341000');
  33 insert into area values(1083,'341004','徽州区','341000');
  34 insert into area values(1084,'341021','歙　县','341000');
  35 insert into area values(1085,'341022','休宁县','341000');
  36 insert into area values(1086,'341023','黟　县','341000');
  37 insert into area values(1087,'341024','祁门县','341000');
  38 insert into area values(1088,'341101','市辖区','341100');
  39 insert into area values(1089,'341102','琅琊区','341100');
  40 insert into area values(1090,'341103','南谯区','341100');
  41 insert into area values(1091,'341122','来安县','341100');
  42 insert into area values(1092,'341124','全椒县','341100');
  43 insert into area values(1093,'341125','定远县','341100');
  44 insert into area values(1094,'341126','凤阳县','341100');
  45 insert into area values(1095,'341181','天长市','341100');
  46 insert into area values(1096,'341182','明光市','341100');
  47 insert into area values(1097,'341201','市辖区','341200');
  48 insert into area values(1098,'341202','颍州区','341200');
  49 insert into area values(1099,'341203','颍东区','341200');
  50 insert into area values(1100,'341204','颍泉区','341200');
  51 insert into area values(1101,'341221','临泉县','341200');
  52 insert into area values(1102,'341222','太和县','341200');
  53 insert into area values(1103,'341225','阜南县','341200');
  54 insert into area values(1104,'341226','颍上县','341200');
  55 insert into area values(1105,'341282','界首市','341200');
  56 insert into area values(1106,'341301','市辖区','341300');
  57 insert into area values(1107,'341302','墉桥区','341300');
  58 insert into area values(1108,'341321','砀山县','341300');
  59 insert into area values(1109,'341322','萧　县','341300');
  60 insert into area values(1110,'341323','灵璧县','341300');
  61 insert into area values(1111,'341324','泗　县','341300');
  62 insert into area values(1112,'341401','市辖区','341400');
  63 insert into area values(1113,'341402','居巢区','341400');
  64 insert into area values(1114,'341421','庐江县','341400');
  65 insert into area values(1115,'341422','无为县','341400');
  66 insert into area values(1116,'341423','含山县','341400');
  67 insert into area values(1117,'341424','和　县','341400');
  68 insert into area values(1118,'341501','市辖区','341500');
  69 insert into area values(1119,'341502','金安区','341500');
  70 insert into area values(1120,'341503','裕安区','341500');
  71 insert into area values(1121,'341521','寿　县','341500');
  72 insert into area values(1122,'341522','霍邱县','341500');
  73 insert into area values(1123,'341523','舒城县','341500');
  74 insert into area values(1124,'341524','金寨县','341500');
  75 insert into area values(1125,'341525','霍山县','341500');
  76 insert into area values(1126,'341601','市辖区','341600');
  77 insert into area values(1127,'341602','谯城区','341600');
  78 insert into area values(1128,'341621','涡阳县','341600');
  79 insert into area values(1129,'341622','蒙城县','341600');
  80 insert into area values(1130,'341623','利辛县','341600');
  81 insert into area values(1131,'341701','市辖区','341700');
  82 insert into area values(1132,'341702','贵池区','341700');
  83 insert into area values(1133,'341721','东至县','341700');
  84 insert into area values(1134,'341722','石台县','341700');
  85 insert into area values(1135,'341723','青阳县','341700');
  86 insert into area values(1136,'341801','市辖区','341800');
  87 insert into area values(1137,'341802','宣州区','341800');
  88 insert into area values(1138,'341821','郎溪县','341800');
  89 insert into area values(1139,'341822','广德县','341800');
  90 insert into area values(1140,'341823','泾　县','341800');
  91 insert into area values(1141,'341824','绩溪县','341800');
  92 insert into area values(1142,'341825','旌德县','341800');
  93 insert into area values(1143,'341881','宁国市','341800');
  94 insert into area values(1144,'350101','市辖区','350100');
  95 insert into area values(1145,'350102','鼓楼区','350100');
  96 insert into area values(1146,'350103','台江区','350100');
  97 insert into area values(1147,'350104','仓山区','350100');
  98 insert into area values(1148,'350105','马尾区','350100');
  99 insert into area values(1149,'350111','晋安区','350100');
 100 insert into area values(1150,'350121','闽侯县','350100');
 101 insert into area values(1151,'350122','连江县','350100');
 102 insert into area values(1152,'350123','罗源县','350100');
 103 insert into area values(1153,'350124','闽清县','350100');
 104 insert into area values(1154,'350125','永泰县','350100');
 105 insert into area values(1155,'350128','平潭县','350100');
 106 insert into area values(1156,'350181','福清市','350100');
 107 insert into area values(1157,'350182','长乐市','350100');
 108 insert into area values(1158,'350201','市辖区','350200');
 109 insert into area values(1159,'350203','思明区','350200');
 110 insert into area values(1160,'350205','海沧区','350200');
 111 insert into area values(1161,'350206','湖里区','350200');
 112 insert into area values(1162,'350211','集美区','350200');
 113 insert into area values(1163,'350212','同安区','350200');
 114 insert into area values(1164,'350213','翔安区','350200');
 115 insert into area values(1165,'350301','市辖区','350300');
 116 insert into area values(1166,'350302','城厢区','350300');
 117 insert into area values(1167,'350303','涵江区','350300');
 118 insert into area values(1168,'350304','荔城区','350300');
 119 insert into area values(1169,'350305','秀屿区','350300');
 120 insert into area values(1170,'350322','仙游县','350300');
 121 insert into area values(1171,'350401','市辖区','350400');
 122 insert into area values(1172,'350402','梅列区','350400');
 123 insert into area values(1173,'350403','三元区','350400');
 124 insert into area values(1174,'350421','明溪县','350400');
 125 insert into area values(1175,'350423','清流县','350400');
 126 insert into area values(1176,'350424','宁化县','350400');
 127 insert into area values(1177,'350425','大田县','350400');
 128 insert into area values(1178,'350426','尤溪县','350400');
 129 insert into area values(1179,'350427','沙　县','350400');
 130 insert into area values(1180,'350428','将乐县','350400');
 131 insert into area values(1181,'350429','泰宁县','350400');
 132 insert into area values(1182,'350430','建宁县','350400');
 133 insert into area values(1183,'350481','永安市','350400');
 134 insert into area values(1184,'350501','市辖区','350500');
 135 insert into area values(1185,'350502','鲤城区','350500');
 136 insert into area values(1186,'350503','丰泽区','350500');
 137 insert into area values(1187,'350504','洛江区','350500');
 138 insert into area values(1188,'350505','泉港区','350500');
 139 insert into area values(1189,'350521','惠安县','350500');
 140 insert into area values(1190,'350524','安溪县','350500');
 141 insert into area values(1191,'350525','永春县','350500');
 142 insert into area values(1192,'350526','德化县','350500');
 143 insert into area values(1193,'350527','金门县','350500');
 144 insert into area values(1194,'350581','石狮市','350500');
 145 insert into area values(1195,'350582','晋江市','350500');
 146 insert into area values(1196,'350583','南安市','350500');
 147 insert into area values(1197,'350601','市辖区','350600');
 148 insert into area values(1198,'350602','芗城区','350600');
 149 insert into area values(1199,'350603','龙文区','350600');
 150 insert into area values(1200,'350622','云霄县','350600');
 151 insert into area values(1201,'350623','漳浦县','350600');
 152 insert into area values(1202,'350624','诏安县','350600');
 153 insert into area values(1203,'350625','长泰县','350600');
 154 insert into area values(1204,'350626','东山县','350600');
 155 insert into area values(1205,'350627','南靖县','350600');
 156 insert into area values(1206,'350628','平和县','350600');
 157 insert into area values(1207,'350629','华安县','350600');
 158 insert into area values(1208,'350681','龙海市','350600');
 159 insert into area values(1209,'350701','市辖区','350700');
 160 insert into area values(1210,'350702','延平区','350700');
 161 insert into area values(1211,'350721','顺昌县','350700');
 162 insert into area values(1212,'350722','浦城县','350700');
 163 insert into area values(1213,'350723','光泽县','350700');
 164 insert into area values(1214,'350724','松溪县','350700');
 165 insert into area values(1215,'350725','政和县','350700');
 166 insert into area values(1216,'350781','邵武市','350700');
 167 insert into area values(1217,'350782','武夷山市','350700');
 168 insert into area values(1218,'350783','建瓯市','350700');
 169 insert into area values(1219,'350784','建阳市','350700');
 170 insert into area values(1220,'350801','市辖区','350800');
 171 insert into area values(1221,'350802','新罗区','350800');
 172 insert into area values(1222,'350821','长汀县','350800');
 173 insert into area values(1223,'350822','永定县','350800');
 174 insert into area values(1224,'350823','上杭县','350800');
 175 insert into area values(1225,'350824','武平县','350800');
 176 insert into area values(1226,'350825','连城县','350800');
 177 insert into area values(1227,'350881','漳平市','350800');
 178 insert into area values(1228,'350901','市辖区','350900');
 179 insert into area values(1229,'350902','蕉城区','350900');
 180 insert into area values(1230,'350921','霞浦县','350900');
 181 insert into area values(1231,'350922','古田县','350900');
 182 insert into area values(1232,'350923','屏南县','350900');
 183 insert into area values(1233,'350924','寿宁县','350900');
 184 insert into area values(1234,'350925','周宁县','350900');
 185 insert into area values(1235,'350926','柘荣县','350900');
 186 insert into area values(1236,'350981','福安市','350900');
 187 insert into area values(1237,'350982','福鼎市','350900');
 188 insert into area values(1238,'360101','市辖区','360100');
 189 insert into area values(1239,'360102','东湖区','360100');
 190 insert into area values(1240,'360103','西湖区','360100');
 191 insert into area values(1241,'360104','青云谱区','360100');
 192 insert into area values(1242,'360105','湾里区','360100');
 193 insert into area values(1243,'360111','青山湖区','360100');
 194 insert into area values(1244,'360121','南昌县','360100');
 195 insert into area values(1245,'360122','新建县','360100');
 196 insert into area values(1246,'360123','安义县','360100');
 197 insert into area values(1247,'360124','进贤县','360100');
 198 insert into area values(1248,'360201','市辖区','360200');
 199 insert into area values(1249,'360202','昌江区','360200');
 200 insert into area values(1250,'360203','珠山区','360200');
 201 insert into area values(1251,'360222','浮梁县','360200');
 202 insert into area values(1252,'360281','乐平市','360200');
 203 insert into area values(1253,'360301','市辖区','360300');
 204 insert into area values(1254,'360302','安源区','360300');
 205 insert into area values(1255,'360313','湘东区','360300');
 206 insert into area values(1256,'360321','莲花县','360300');
 207 insert into area values(1257,'360322','上栗县','360300');
 208 insert into area values(1258,'360323','芦溪县','360300');
 209 insert into area values(1259,'360401','市辖区','360400');
 210 insert into area values(1260,'360402','庐山区','360400');
 211 insert into area values(1261,'360403','浔阳区','360400');
 212 insert into area values(1262,'360421','九江县','360400');
 213 insert into area values(1263,'360423','武宁县','360400');
 214 insert into area values(1264,'360424','修水县','360400');
 215 insert into area values(1265,'360425','永修县','360400');
 216 insert into area values(1266,'360426','德安县','360400');
 217 insert into area values(1267,'360427','星子县','360400');
 218 insert into area values(1268,'360428','都昌县','360400');
 219 insert into area values(1269,'360429','湖口县','360400');
 220 insert into area values(1270,'360430','彭泽县','360400');
 221 insert into area values(1271,'360481','瑞昌市','360400');
 222 insert into area values(1272,'360501','市辖区','360500');
 223 insert into area values(1273,'360502','渝水区','360500');
 224 insert into area values(1274,'360521','分宜县','360500');
 225 insert into area values(1275,'360601','市辖区','360600');
 226 insert into area values(1276,'360602','月湖区','360600');
 227 insert into area values(1277,'360622','余江县','360600');
 228 insert into area values(1278,'360681','贵溪市','360600');
 229 insert into area values(1279,'360701','市辖区','360700');
 230 insert into area values(1280,'360702','章贡区','360700');
 231 insert into area values(1281,'360721','赣　县','360700');
 232 insert into area values(1282,'360722','信丰县','360700');
 233 insert into area values(1283,'360723','大余县','360700');
 234 insert into area values(1284,'360724','上犹县','360700');
 235 insert into area values(1285,'360725','崇义县','360700');
 236 insert into area values(1286,'360726','安远县','360700');
 237 insert into area values(1287,'360727','龙南县','360700');
 238 insert into area values(1288,'360728','定南县','360700');
 239 insert into area values(1289,'360729','全南县','360700');
 240 insert into area values(1290,'360730','宁都县','360700');
 241 insert into area values(1291,'360731','于都县','360700');
 242 insert into area values(1292,'360732','兴国县','360700');
 243 insert into area values(1293,'360733','会昌县','360700');
 244 insert into area values(1294,'360734','寻乌县','360700');
 245 insert into area values(1295,'360735','石城县','360700');
 246 insert into area values(1296,'360781','瑞金市','360700');
 247 insert into area values(1297,'360782','南康市','360700');
 248 insert into area values(1298,'360801','市辖区','360800');
 249 insert into area values(1299,'360802','吉州区','360800');
 250 insert into area values(1300,'360803','青原区','360800');
 251 insert into area values(1301,'360821','吉安县','360800');
 252 insert into area values(1302,'360822','吉水县','360800');
 253 insert into area values(1303,'360823','峡江县','360800');
 254 insert into area values(1304,'360824','新干县','360800');
 255 insert into area values(1305,'360825','永丰县','360800');
 256 insert into area values(1306,'360826','泰和县','360800');
 257 insert into area values(1307,'360827','遂川县','360800');
 258 insert into area values(1308,'360828','万安县','360800');
 259 insert into area values(1309,'360829','安福县','360800');
 260 insert into area values(1310,'360830','永新县','360800');
 261 insert into area values(1311,'360881','井冈山市','360800');
 262 insert into area values(1312,'360901','市辖区','360900');
 263 insert into area values(1313,'360902','袁州区','360900');
 264 insert into area values(1314,'360921','奉新县','360900');
 265 insert into area values(1315,'360922','万载县','360900');
 266 insert into area values(1316,'360923','上高县','360900');
 267 insert into area values(1317,'360924','宜丰县','360900');
 268 insert into area values(1318,'360925','靖安县','360900');
 269 insert into area values(1319,'360926','铜鼓县','360900');
 270 insert into area values(1320,'360981','丰城市','360900');
 271 insert into area values(1321,'360982','樟树市','360900');
 272 insert into area values(1322,'360983','高安市','360900');
 273 insert into area values(1323,'361001','市辖区','361000');
 274 insert into area values(1324,'361002','临川区','361000');
 275 insert into area values(1325,'361021','南城县','361000');
 276 insert into area values(1326,'361022','黎川县','361000');
 277 insert into area values(1327,'361023','南丰县','361000');
 278 insert into area values(1328,'361024','崇仁县','361000');
 279 insert into area values(1329,'361025','乐安县','361000');
 280 insert into area values(1330,'361026','宜黄县','361000');
 281 insert into area values(1331,'361027','金溪县','361000');
 282 insert into area values(1332,'361028','资溪县','361000');
 283 insert into area values(1333,'361029','东乡县','361000');
 284 insert into area values(1334,'361030','广昌县','361000');
 285 insert into area values(1335,'361101','市辖区','361100');
 286 insert into area values(1336,'361102','信州区','361100');
 287 insert into area values(1337,'361121','上饶县','361100');
 288 insert into area values(1338,'361122','广丰县','361100');
 289 insert into area values(1339,'361123','玉山县','361100');
 290 insert into area values(1340,'361124','铅山县','361100');
 291 insert into area values(1341,'361125','横峰县','361100');
 292 insert into area values(1342,'361126','弋阳县','361100');
 293 insert into area values(1343,'361127','余干县','361100');
 294 insert into area values(1344,'361128','鄱阳县','361100');
 295 insert into area values(1345,'361129','万年县','361100');
 296 insert into area values(1346,'361130','婺源县','361100');
 297 insert into area values(1347,'361181','德兴市','361100');
 298 insert into area values(1348,'370101','市辖区','370100');
 299 insert into area values(1349,'370102','历下区','370100');
 300 insert into area values(1350,'370103','市中区','370100');
 301 insert into area values(1351,'370104','槐荫区','370100');
 302 insert into area values(1352,'370105','天桥区','370100');
 303 insert into area values(1353,'370112','历城区','370100');
 304 insert into area values(1354,'370113','长清区','370100');
 305 insert into area values(1355,'370124','平阴县','370100');
 306 insert into area values(1356,'370125','济阳县','370100');
 307 insert into area values(1357,'370126','商河县','370100');
 308 insert into area values(1358,'370181','章丘市','370100');
 309 insert into area values(1359,'370201','市辖区','370200');
 310 insert into area values(1360,'370202','市南区','370200');
 311 insert into area values(1361,'370203','市北区','370200');
 312 insert into area values(1362,'370205','四方区','370200');
 313 insert into area values(1363,'370211','黄岛区','370200');
 314 insert into area values(1364,'370212','崂山区','370200');
 315 insert into area values(1365,'370213','李沧区','370200');
 316 insert into area values(1366,'370214','城阳区','370200');
 317 insert into area values(1367,'370281','胶州市','370200');
 318 insert into area values(1368,'370282','即墨市','370200');
 319 insert into area values(1369,'370283','平度市','370200');
 320 insert into area values(1370,'370284','胶南市','370200');
 321 insert into area values(1371,'370285','莱西市','370200');
 322 insert into area values(1372,'370301','市辖区','370300');
 323 insert into area values(1373,'370302','淄川区','370300');
 324 insert into area values(1374,'370303','张店区','370300');
 325 insert into area values(1375,'370304','博山区','370300');
 326 insert into area values(1376,'370305','临淄区','370300');
 327 insert into area values(1377,'370306','周村区','370300');
 328 insert into area values(1378,'370321','桓台县','370300');
 329 insert into area values(1379,'370322','高青县','370300');
 330 insert into area values(1380,'370323','沂源县','370300');
 331 insert into area values(1381,'370401','市辖区','370400');
 332 insert into area values(1382,'370402','市中区','370400');
 333 insert into area values(1383,'370403','薛城区','370400');
 334 insert into area values(1384,'370404','峄城区','370400');
 335 insert into area values(1385,'370405','台儿庄区','370400');
 336 insert into area values(1386,'370406','山亭区','370400');
 337 insert into area values(1387,'370481','滕州市','370400');
 338 insert into area values(1388,'370501','市辖区','370500');
 339 insert into area values(1389,'370502','东营区','370500');
 340 insert into area values(1390,'370503','河口区','370500');
 341 insert into area values(1391,'370521','垦利县','370500');
 342 insert into area values(1392,'370522','利津县','370500');
 343 insert into area values(1393,'370523','广饶县','370500');
 344 insert into area values(1394,'370601','市辖区','370600');
 345 insert into area values(1395,'370602','芝罘区','370600');
 346 insert into area values(1396,'370611','福山区','370600');
 347 insert into area values(1397,'370612','牟平区','370600');
 348 insert into area values(1398,'370613','莱山区','370600');
 349 insert into area values(1399,'370634','长岛县','370600');
 350 insert into area values(1400,'370681','龙口市','370600');
 351 insert into area values(1401,'370682','莱阳市','370600');
 352 insert into area values(1402,'370683','莱州市','370600');
 353 insert into area values(1403,'370684','蓬莱市','370600');
 354 insert into area values(1404,'370685','招远市','370600');
 355 insert into area values(1405,'370686','栖霞市','370600');
 356 insert into area values(1406,'370687','海阳市','370600');
 357 insert into area values(1407,'370701','市辖区','370700');
 358 insert into area values(1408,'370702','潍城区','370700');
 359 insert into area values(1409,'370703','寒亭区','370700');
 360 insert into area values(1410,'370704','坊子区','370700');
 361 insert into area values(1411,'370705','奎文区','370700');
 362 insert into area values(1412,'370724','临朐县','370700');
 363 insert into area values(1413,'370725','昌乐县','370700');
 364 insert into area values(1414,'370781','青州市','370700');
 365 insert into area values(1415,'370782','诸城市','370700');
 366 insert into area values(1416,'370783','寿光市','370700');
 367 insert into area values(1417,'370784','安丘市','370700');
 368 insert into area values(1418,'370785','高密市','370700');
 369 insert into area values(1419,'370786','昌邑市','370700');
 370 insert into area values(1420,'370801','市辖区','370800');
 371 insert into area values(1421,'370802','市中区','370800');
 372 insert into area values(1422,'370811','任城区','370800');
 373 insert into area values(1423,'370826','微山县','370800');
 374 insert into area values(1424,'370827','鱼台县','370800');
 375 insert into area values(1425,'370828','金乡县','370800');
 376 insert into area values(1426,'370829','嘉祥县','370800');
 377 insert into area values(1427,'370830','汶上县','370800');
 378 insert into area values(1428,'370831','泗水县','370800');
 379 insert into area values(1429,'370832','梁山县','370800');
 380 insert into area values(1430,'370881','曲阜市','370800');
 381 insert into area values(1431,'370882','兖州市','370800');
 382 insert into area values(1432,'370883','邹城市','370800');
 383 insert into area values(1433,'370901','市辖区','370900');
 384 insert into area values(1434,'370902','泰山区','370900');
 385 insert into area values(1435,'370903','岱岳区','370900');
 386 insert into area values(1436,'370921','宁阳县','370900');
 387 insert into area values(1437,'370923','东平县','370900');
 388 insert into area values(1438,'370982','新泰市','370900');
 389 insert into area values(1439,'370983','肥城市','370900');
 390 insert into area values(1440,'371001','市辖区','371000');
 391 insert into area values(1441,'371002','环翠区','371000');
 392 insert into area values(1442,'371081','文登市','371000');
 393 insert into area values(1443,'371082','荣成市','371000');
 394 insert into area values(1444,'371083','乳山市','371000');
 395 insert into area values(1445,'371101','市辖区','371100');
 396 insert into area values(1446,'371102','东港区','371100');
 397 insert into area values(1447,'371103','岚山区','371100');
 398 insert into area values(1448,'371121','五莲县','371100');
 399 insert into area values(1449,'371122','莒　县','371100');
 400 insert into area values(1450,'371201','市辖区','371200');
 401 insert into area values(1451,'371202','莱城区','371200');
 402 insert into area values(1452,'371203','钢城区','371200');
 403 insert into area values(1453,'371301','市辖区','371300');
 404 insert into area values(1454,'371302','兰山区','371300');
 405 insert into area values(1455,'371311','罗庄区','371300');
 406 insert into area values(1456,'371312','河东区','371300');
 407 insert into area values(1457,'371321','沂南县','371300');
 408 insert into area values(1458,'371322','郯城县','371300');
 409 insert into area values(1459,'371323','沂水县','371300');
 410 insert into area values(1460,'371324','苍山县','371300');
 411 insert into area values(1461,'371325','费　县','371300');
 412 insert into area values(1462,'371326','平邑县','371300');
 413 insert into area values(1463,'371327','莒南县','371300');
 414 insert into area values(1464,'371328','蒙阴县','371300');
 415 insert into area values(1465,'371329','临沭县','371300');
 416 insert into area values(1466,'371401','市辖区','371400');
 417 insert into area values(1467,'371402','德城区','371400');
 418 insert into area values(1468,'371421','陵　县','371400');
 419 insert into area values(1469,'371422','宁津县','371400');
 420 insert into area values(1470,'371423','庆云县','371400');
 421 insert into area values(1471,'371424','临邑县','371400');
 422 insert into area values(1472,'371425','齐河县','371400');
 423 insert into area values(1473,'371426','平原县','371400');
 424 insert into area values(1474,'371427','夏津县','371400');
 425 insert into area values(1475,'371428','武城县','371400');
 426 insert into area values(1476,'371481','乐陵市','371400');
 427 insert into area values(1477,'371482','禹城市','371400');
 428 insert into area values(1478,'371501','市辖区','371500');
 429 insert into area values(1479,'371502','东昌府区','371500');
 430 insert into area values(1480,'371521','阳谷县','371500');
 431 insert into area values(1481,'371522','莘　县','371500');
 432 insert into area values(1482,'371523','茌平县','371500');
 433 insert into area values(1483,'371524','东阿县','371500');
 434 insert into area values(1484,'371525','冠　县','371500');
 435 insert into area values(1485,'371526','高唐县','371500');
 436 insert into area values(1486,'371581','临清市','371500');
 437 insert into area values(1487,'371601','市辖区','371600');
 438 insert into area values(1488,'371602','滨城区','371600');
 439 insert into area values(1489,'371621','惠民县','371600');
 440 insert into area values(1490,'371622','阳信县','371600');
 441 insert into area values(1491,'371623','无棣县','371600');
 442 insert into area values(1492,'371624','沾化县','371600');
 443 insert into area values(1493,'371625','博兴县','371600');
 444 insert into area values(1494,'371626','邹平县','371600');
 445 insert into area values(1495,'371701','市辖区','371700');
 446 insert into area values(1496,'371702','牡丹区','371700');
 447 insert into area values(1497,'371721','曹　县','371700');
 448 insert into area values(1498,'371722','单　县','371700');
 449 insert into area values(1499,'371723','成武县','371700');
 450 insert into area values(1500,'371724','巨野县','371700');
 451 insert into area values(1501,'371725','郓城县','371700');
 452 insert into area values(1502,'371726','鄄城县','371700');
 453 insert into area values(1503,'371727','定陶县','371700');
 454 insert into area values(1504,'371728','东明县','371700');
 455 insert into area values(1505,'410101','市辖区','410100');
 456 insert into area values(1506,'410102','中原区','410100');
 457 insert into area values(1507,'410103','二七区','410100');
 458 insert into area values(1508,'410104','管城回族区','410100');
 459 insert into area values(1509,'410105','金水区','410100');
 460 insert into area values(1510,'410106','上街区','410100');
 461 insert into area values(1511,'410108','邙山区','410100');
 462 insert into area values(1512,'410122','中牟县','410100');
 463 insert into area values(1513,'410181','巩义市','410100');
 464 insert into area values(1514,'410182','荥阳市','410100');
 465 insert into area values(1515,'410183','新密市','410100');
 466 insert into area values(1516,'410184','新郑市','410100');
 467 insert into area values(1517,'410185','登封市','410100');
 468 insert into area values(1518,'410201','市辖区','410200');
 469 insert into area values(1519,'410202','龙亭区','410200');
 470 insert into area values(1520,'410203','顺河回族区','410200');
 471 insert into area values(1521,'410204','鼓楼区','410200');
 472 insert into area values(1522,'410205','南关区','410200');
 473 insert into area values(1523,'410211','郊　区','410200');
 474 insert into area values(1524,'410221','杞　县','410200');
 475 insert into area values(1525,'410222','通许县','410200');
 476 insert into area values(1526,'410223','尉氏县','410200');
 477 insert into area values(1527,'410224','开封县','410200');
 478 insert into area values(1528,'410225','兰考县','410200');
 479 insert into area values(1529,'410301','市辖区','410300');
 480 insert into area values(1530,'410302','老城区','410300');
 481 insert into area values(1531,'410303','西工区','410300');
 482 insert into area values(1532,'410304','廛河回族区','410300');
 483 insert into area values(1533,'410305','涧西区','410300');
 484 insert into area values(1534,'410306','吉利区','410300');
 485 insert into area values(1535,'410307','洛龙区','410300');
 486 insert into area values(1536,'410322','孟津县','410300');
 487 insert into area values(1537,'410323','新安县','410300');
 488 insert into area values(1538,'410324','栾川县','410300');
 489 insert into area values(1539,'410325','嵩　县','410300');
 490 insert into area values(1540,'410326','汝阳县','410300');
 491 insert into area values(1541,'410327','宜阳县','410300');
 492 insert into area values(1542,'410328','洛宁县','410300');
 493 insert into area values(1543,'410329','伊川县','410300');
 494 insert into area values(1544,'410381','偃师市','410300');
 495 insert into area values(1545,'410401','市辖区','410400');
 496 insert into area values(1546,'410402','新华区','410400');
 497 insert into area values(1547,'410403','卫东区','410400');
 498 insert into area values(1548,'410404','石龙区','410400');
 499 insert into area values(1549,'410411','湛河区','410400');
 500 insert into area values(1550,'410421','宝丰县','410400');
 501 insert into area values(1551,'410422','叶　县','410400');
 502 insert into area values(1552,'410423','鲁山县','410400');
 503 insert into area values(1553,'410425','郏　县','410400');
 504 insert into area values(1554,'410481','舞钢市','410400');
 505 insert into area values(1555,'410482','汝州市','410400');
 506 insert into area values(1556,'410501','市辖区','410500');
 507 insert into area values(1557,'410502','文峰区','410500');
 508 insert into area values(1558,'410503','北关区','410500');
 509 insert into area values(1559,'410505','殷都区','410500');
 510 insert into area values(1560,'410506','龙安区','410500');
 511 insert into area values(1561,'410522','安阳县','410500');
 512 insert into area values(1562,'410523','汤阴县','410500');
 513 insert into area values(1563,'410526','滑　县','410500');
 514 insert into area values(1564,'410527','内黄县','410500');
 515 insert into area values(1565,'410581','林州市','410500');
 516 insert into area values(1566,'410601','市辖区','410600');
 517 insert into area values(1567,'410602','鹤山区','410600');
 518 insert into area values(1568,'410603','山城区','410600');
 519 insert into area values(1569,'410611','淇滨区','410600');
 520 insert into area values(1570,'410621','浚　县','410600');
 521 insert into area values(1571,'410622','淇　县','410600');
 522 insert into area values(1572,'410701','市辖区','410700');
 523 insert into area values(1573,'410702','红旗区','410700');
 524 insert into area values(1574,'410703','卫滨区','410700');
 525 insert into area values(1575,'410704','凤泉区','410700');
 526 insert into area values(1576,'410711','牧野区','410700');
 527 insert into area values(1577,'410721','新乡县','410700');
 528 insert into area values(1578,'410724','获嘉县','410700');
 529 insert into area values(1579,'410725','原阳县','410700');
 530 insert into area values(1580,'410726','延津县','410700');
 531 insert into area values(1581,'410727','封丘县','410700');
 532 insert into area values(1582,'410728','长垣县','410700');
 533 insert into area values(1583,'410781','卫辉市','410700');
 534 insert into area values(1584,'410782','辉县市','410700');
 535 insert into area values(1585,'410801','市辖区','410800');
 536 insert into area values(1586,'410802','解放区','410800');
 537 insert into area values(1587,'410803','中站区','410800');
 538 insert into area values(1588,'410804','马村区','410800');
 539 insert into area values(1589,'410811','山阳区','410800');
 540 insert into area values(1590,'410821','修武县','410800');
 541 insert into area values(1591,'410822','博爱县','410800');
 542 insert into area values(1592,'410823','武陟县','410800');
 543 insert into area values(1593,'410825','温　县','410800');
 544 insert into area values(1594,'410881','济源市','410800');
 545 insert into area values(1595,'410882','沁阳市','410800');
 546 insert into area values(1596,'410883','孟州市','410800');
 547 insert into area values(1597,'410901','市辖区','410900');
 548 insert into area values(1598,'410902','华龙区','410900');
 549 insert into area values(1599,'410922','清丰县','410900');
 550 insert into area values(1600,'410923','南乐县','410900');
 551 insert into area values(1601,'410926','范　县','410900');
 552 insert into area values(1602,'410927','台前县','410900');
 553 insert into area values(1603,'410928','濮阳县','410900');
 554 insert into area values(1604,'411001','市辖区','411000');
 555 insert into area values(1605,'411002','魏都区','411000');
 556 insert into area values(1606,'411023','许昌县','411000');
 557 insert into area values(1607,'411024','鄢陵县','411000');
 558 insert into area values(1608,'411025','襄城县','411000');
 559 insert into area values(1609,'411081','禹州市','411000');
 560 insert into area values(1610,'411082','长葛市','411000');
 561 insert into area values(1611,'411101','市辖区','411100');
 562 insert into area values(1612,'411102','源汇区','411100');
 563 insert into area values(1613,'411103','郾城区','411100');
 564 insert into area values(1614,'411104','召陵区','411100');
 565 insert into area values(1615,'411121','舞阳县','411100');
 566 insert into area values(1616,'411122','临颍县','411100');
 567 insert into area values(1617,'411201','市辖区','411200');
 568 insert into area values(1618,'411202','湖滨区','411200');
 569 insert into area values(1619,'411221','渑池县','411200');
 570 insert into area values(1620,'411222','陕　县','411200');
 571 insert into area values(1621,'411224','卢氏县','411200');
 572 insert into area values(1622,'411281','义马市','411200');
 573 insert into area values(1623,'411282','灵宝市','411200');
 574 insert into area values(1624,'411301','市辖区','411300');
 575 insert into area values(1625,'411302','宛城区','411300');
 576 insert into area values(1626,'411303','卧龙区','411300');
 577 insert into area values(1627,'411321','南召县','411300');
 578 insert into area values(1628,'411322','方城县','411300');
 579 insert into area values(1629,'411323','西峡县','411300');
 580 insert into area values(1630,'411324','镇平县','411300');
 581 insert into area values(1631,'411325','内乡县','411300');
 582 insert into area values(1632,'411326','淅川县','411300');
 583 insert into area values(1633,'411327','社旗县','411300');
 584 insert into area values(1634,'411328','唐河县','411300');
 585 insert into area values(1635,'411329','新野县','411300');
 586 insert into area values(1636,'411330','桐柏县','411300');
 587 insert into area values(1637,'411381','邓州市','411300');
 588 insert into area values(1638,'411401','市辖区','411400');
 589 insert into area values(1639,'411402','梁园区','411400');
 590 insert into area values(1640,'411403','睢阳区','411400');
 591 insert into area values(1641,'411421','民权县','411400');
 592 insert into area values(1642,'411422','睢　县','411400');
 593 insert into area values(1643,'411423','宁陵县','411400');
 594 insert into area values(1644,'411424','柘城县','411400');
 595 insert into area values(1645,'411425','虞城县','411400');
 596 insert into area values(1646,'411426','夏邑县','411400');
 597 insert into area values(1647,'411481','永城市','411400');
 598 insert into area values(1648,'411501','市辖区','411500');
 599 insert into area values(1649,'411502','师河区','411500');
 600 insert into area values(1650,'411503','平桥区','411500');
 601 insert into area values(1651,'411521','罗山县','411500');
 602 insert into area values(1652,'411522','光山县','411500');
 603 insert into area values(1653,'411523','新　县','411500');
 604 insert into area values(1654,'411524','商城县','411500');
 605 insert into area values(1655,'411525','固始县','411500');
 606 insert into area values(1656,'411526','潢川县','411500');
 607 insert into area values(1657,'411527','淮滨县','411500');
 608 insert into area values(1658,'411528','息　县','411500');
 609 insert into area values(1659,'411601','市辖区','411600');
 610 insert into area values(1660,'411602','川汇区','411600');
 611 insert into area values(1661,'411621','扶沟县','411600');
 612 insert into area values(1662,'411622','西华县','411600');
 613 insert into area values(1663,'411623','商水县','411600');
 614 insert into area values(1664,'411624','沈丘县','411600');
 615 insert into area values(1665,'411625','郸城县','411600');
 616 insert into area values(1666,'411626','淮阳县','411600');
 617 insert into area values(1667,'411627','太康县','411600');
 618 insert into area values(1668,'411628','鹿邑县','411600');
 619 insert into area values(1669,'411681','项城市','411600');
 620 insert into area values(1670,'411701','市辖区','411700');
 621 insert into area values(1671,'411702','驿城区','411700');
 622 insert into area values(1672,'411721','西平县','411700');
 623 insert into area values(1673,'411722','上蔡县','411700');
 624 insert into area values(1674,'411723','平舆县','411700');
 625 insert into area values(1675,'411724','正阳县','411700');
 626 insert into area values(1676,'411725','确山县','411700');
 627 insert into area values(1677,'411726','泌阳县','411700');
 628 insert into area values(1678,'411727','汝南县','411700');
 629 insert into area values(1679,'411728','遂平县','411700');
 630 insert into area values(1680,'411729','新蔡县','411700');
 631 insert into area values(1681,'420101','市辖区','420100');
 632 insert into area values(1682,'420102','江岸区','420100');
 633 insert into area values(1683,'420103','江汉区','420100');
 634 insert into area values(1684,'420104','乔口区','420100');
 635 insert into area values(1685,'420105','汉阳区','420100');
 636 insert into area values(1686,'420106','武昌区','420100');
 637 insert into area values(1687,'420107','青山区','420100');
 638 insert into area values(1688,'420111','洪山区','420100');
 639 insert into area values(1689,'420112','东西湖区','420100');
 640 insert into area values(1690,'420113','汉南区','420100');
 641 insert into area values(1691,'420114','蔡甸区','420100');
 642 insert into area values(1692,'420115','江夏区','420100');
 643 insert into area values(1693,'420116','黄陂区','420100');
 644 insert into area values(1694,'420117','新洲区','420100');
 645 insert into area values(1695,'420201','市辖区','420200');
 646 insert into area values(1696,'420202','黄石港区','420200');
 647 insert into area values(1697,'420203','西塞山区','420200');
 648 insert into area values(1698,'420204','下陆区','420200');
 649 insert into area values(1699,'420205','铁山区','420200');
 650 insert into area values(1700,'420222','阳新县','420200');
 651 insert into area values(1701,'420281','大冶市','420200');
 652 insert into area values(1702,'420301','市辖区','420300');
 653 insert into area values(1703,'420302','茅箭区','420300');
 654 insert into area values(1704,'420303','张湾区','420300');
 655 insert into area values(1705,'420321','郧　县','420300');
 656 insert into area values(1706,'420322','郧西县','420300');
 657 insert into area values(1707,'420323','竹山县','420300');
 658 insert into area values(1708,'420324','竹溪县','420300');
 659 insert into area values(1709,'420325','房　县','420300');
 660 insert into area values(1710,'420381','丹江口市','420300');
 661 insert into area values(1711,'420501','市辖区','420500');
 662 insert into area values(1712,'420502','西陵区','420500');
 663 insert into area values(1713,'420503','伍家岗区','420500');
 664 insert into area values(1714,'420504','点军区','420500');
 665 insert into area values(1715,'420505','猇亭区','420500');
 666 insert into area values(1716,'420506','夷陵区','420500');
 667 insert into area values(1717,'420525','远安县','420500');
 668 insert into area values(1718,'420526','兴山县','420500');
 669 insert into area values(1719,'420527','秭归县','420500');
 670 insert into area values(1720,'420528','长阳土家族自治县','420500');
 671 insert into area values(1721,'420529','五峰土家族自治县','420500');
 672 insert into area values(1722,'420581','宜都市','420500');
 673 insert into area values(1723,'420582','当阳市','420500');
 674 insert into area values(1724,'420583','枝江市','420500');
 675 insert into area values(1725,'420601','市辖区','420600');
 676 insert into area values(1726,'420602','襄城区','420600');
 677 insert into area values(1727,'420606','樊城区','420600');
 678 insert into area values(1728,'420607','襄阳区','420600');
 679 insert into area values(1729,'420624','南漳县','420600');
 680 insert into area values(1730,'420625','谷城县','420600');
 681 insert into area values(1731,'420626','保康县','420600');
 682 insert into area values(1732,'420682','老河口市','420600');
 683 insert into area values(1733,'420683','枣阳市','420600');
 684 insert into area values(1734,'420684','宜城市','420600');
 685 insert into area values(1735,'420701','市辖区','420700');
 686 insert into area values(1736,'420702','梁子湖区','420700');
 687 insert into area values(1737,'420703','华容区','420700');
 688 insert into area values(1738,'420704','鄂城区','420700');
 689 insert into area values(1739,'420801','市辖区','420800');
 690 insert into area values(1740,'420802','东宝区','420800');
 691 insert into area values(1741,'420804','掇刀区','420800');
 692 insert into area values(1742,'420821','京山县','420800');
 693 insert into area values(1743,'420822','沙洋县','420800');
 694 insert into area values(1744,'420881','钟祥市','420800');
 695 insert into area values(1745,'420901','市辖区','420900');
 696 insert into area values(1746,'420902','孝南区','420900');
 697 insert into area values(1747,'420921','孝昌县','420900');
 698 insert into area values(1748,'420922','大悟县','420900');
 699 insert into area values(1749,'420923','云梦县','420900');
 700 insert into area values(1750,'420981','应城市','420900');
 701 insert into area values(1751,'420982','安陆市','420900');
 702 insert into area values(1752,'420984','汉川市','420900');
 703 insert into area values(1753,'421001','市辖区','421000');
 704 insert into area values(1754,'421002','沙市区','421000');
 705 insert into area values(1755,'421003','荆州区','421000');
 706 insert into area values(1756,'421022','公安县','421000');
 707 insert into area values(1757,'421023','监利县','421000');
 708 insert into area values(1758,'421024','江陵县','421000');
 709 insert into area values(1759,'421081','石首市','421000');
 710 insert into area values(1760,'421083','洪湖市','421000');
 711 insert into area values(1761,'421087','松滋市','421000');
 712 insert into area values(1762,'421101','市辖区','421100');
 713 insert into area values(1763,'421102','黄州区','421100');
 714 insert into area values(1764,'421121','团风县','421100');
 715 insert into area values(1765,'421122','红安县','421100');
 716 insert into area values(1766,'421123','罗田县','421100');
 717 insert into area values(1767,'421124','英山县','421100');
 718 insert into area values(1768,'421125','浠水县','421100');
 719 insert into area values(1769,'421126','蕲春县','421100');
 720 insert into area values(1770,'421127','黄梅县','421100');
 721 insert into area values(1771,'421181','麻城市','421100');
 722 insert into area values(1772,'421182','武穴市','421100');
 723 insert into area values(1773,'421201','市辖区','421200');
 724 insert into area values(1774,'421202','咸安区','421200');
 725 insert into area values(1775,'421221','嘉鱼县','421200');
 726 insert into area values(1776,'421222','通城县','421200');
 727 insert into area values(1777,'421223','崇阳县','421200');
 728 insert into area values(1778,'421224','通山县','421200');
 729 insert into area values(1779,'421281','赤壁市','421200');
 730 insert into area values(1780,'421301','市辖区','421300');
 731 insert into area values(1781,'421302','曾都区','421300');
 732 insert into area values(1782,'421381','广水市','421300');
 733 insert into area values(1783,'422801','恩施市','422800');
 734 insert into area values(1784,'422802','利川市','422800');
 735 insert into area values(1785,'422822','建始县','422800');
 736 insert into area values(1786,'422823','巴东县','422800');
 737 insert into area values(1787,'422825','宣恩县','422800');
 738 insert into area values(1788,'422826','咸丰县','422800');
 739 insert into area values(1789,'422827','来凤县','422800');
 740 insert into area values(1790,'422828','鹤峰县','422800');
 741 insert into area values(1791,'429004','仙桃市','429000');
 742 insert into area values(1792,'429005','潜江市','429000');
 743 insert into area values(1793,'429006','天门市','429000');
 744 insert into area values(1794,'429021','神农架林区','429000');
 745 insert into area values(1795,'430101','市辖区','430100');
 746 insert into area values(1796,'430102','芙蓉区','430100');
 747 insert into area values(1797,'430103','天心区','430100');
 748 insert into area values(1798,'430104','岳麓区','430100');
 749 insert into area values(1799,'430105','开福区','430100');
 750 insert into area values(1800,'430111','雨花区','430100');
 751 insert into area values(1801,'430121','长沙县','430100');
 752 insert into area values(1802,'430122','望城县','430100');
 753 insert into area values(1803,'430124','宁乡县','430100');
 754 insert into area values(1804,'430181','浏阳市','430100');
 755 insert into area values(1805,'430201','市辖区','430200');
 756 insert into area values(1806,'430202','荷塘区','430200');
 757 insert into area values(1807,'430203','芦淞区','430200');
 758 insert into area values(1808,'430204','石峰区','430200');
 759 insert into area values(1809,'430211','天元区','430200');
 760 insert into area values(1810,'430221','株洲县','430200');
 761 insert into area values(1811,'430223','攸　县','430200');
 762 insert into area values(1812,'430224','茶陵县','430200');
 763 insert into area values(1813,'430225','炎陵县','430200');
 764 insert into area values(1814,'430281','醴陵市','430200');
 765 insert into area values(1815,'430301','市辖区','430300');
 766 insert into area values(1816,'430302','雨湖区','430300');
 767 insert into area values(1817,'430304','岳塘区','430300');
 768 insert into area values(1818,'430321','湘潭县','430300');
 769 insert into area values(1819,'430381','湘乡市','430300');
 770 insert into area values(1820,'430382','韶山市','430300');
 771 insert into area values(1821,'430401','市辖区','430400');
 772 insert into area values(1822,'430405','珠晖区','430400');
 773 insert into area values(1823,'430406','雁峰区','430400');
 774 insert into area values(1824,'430407','石鼓区','430400');
 775 insert into area values(1825,'430408','蒸湘区','430400');
 776 insert into area values(1826,'430412','南岳区','430400');
 777 insert into area values(1827,'430421','衡阳县','430400');
 778 insert into area values(1828,'430422','衡南县','430400');
 779 insert into area values(1829,'430423','衡山县','430400');
 780 insert into area values(1830,'430424','衡东县','430400');
 781 insert into area values(1831,'430426','祁东县','430400');
 782 insert into area values(1832,'430481','耒阳市','430400');
 783 insert into area values(1833,'430482','常宁市','430400');
 784 insert into area values(1834,'430501','市辖区','430500');
 785 insert into area values(1835,'430502','双清区','430500');
 786 insert into area values(1836,'430503','大祥区','430500');
 787 insert into area values(1837,'430511','北塔区','430500');
 788 insert into area values(1838,'430521','邵东县','430500');
 789 insert into area values(1839,'430522','新邵县','430500');
 790 insert into area values(1840,'430523','邵阳县','430500');
 791 insert into area values(1841,'430524','隆回县','430500');
 792 insert into area values(1842,'430525','洞口县','430500');
 793 insert into area values(1843,'430527','绥宁县','430500');
 794 insert into area values(1844,'430528','新宁县','430500');
 795 insert into area values(1845,'430529','城步苗族自治县','430500');
 796 insert into area values(1846,'430581','武冈市','430500');
 797 insert into area values(1847,'430601','市辖区','430600');
 798 insert into area values(1848,'430602','岳阳楼区','430600');
 799 insert into area values(1849,'430603','云溪区','430600');
 800 insert into area values(1850,'430611','君山区','430600');
 801 insert into area values(1851,'430621','岳阳县','430600');
 802 insert into area values(1852,'430623','华容县','430600');
 803 insert into area values(1853,'430624','湘阴县','430600');
 804 insert into area values(1854,'430626','平江县','430600');
 805 insert into area values(1855,'430681','汨罗市','430600');
 806 insert into area values(1856,'430682','临湘市','430600');
 807 insert into area values(1857,'430701','市辖区','430700');
 808 insert into area values(1858,'430702','武陵区','430700');
 809 insert into area values(1859,'430703','鼎城区','430700');
 810 insert into area values(1860,'430721','安乡县','430700');
 811 insert into area values(1861,'430722','汉寿县','430700');
 812 insert into area values(1862,'430723','澧　县','430700');
 813 insert into area values(1863,'430724','临澧县','430700');
 814 insert into area values(1864,'430725','桃源县','430700');
 815 insert into area values(1865,'430726','石门县','430700');
 816 insert into area values(1866,'430781','津市市','430700');
 817 insert into area values(1867,'430801','市辖区','430800');
 818 insert into area values(1868,'430802','永定区','430800');
 819 insert into area values(1869,'430811','武陵源区','430800');
 820 insert into area values(1870,'430821','慈利县','430800');
 821 insert into area values(1871,'430822','桑植县','430800');
 822 insert into area values(1872,'430901','市辖区','430900');
 823 insert into area values(1873,'430902','资阳区','430900');
 824 insert into area values(1874,'430903','赫山区','430900');
 825 insert into area values(1875,'430921','南　县','430900');
 826 insert into area values(1876,'430922','桃江县','430900');
 827 insert into area values(1877,'430923','安化县','430900');
 828 insert into area values(1878,'430981','沅江市','430900');
 829 insert into area values(1879,'431001','市辖区','431000');
 830 insert into area values(1880,'431002','北湖区','431000');
 831 insert into area values(1881,'431003','苏仙区','431000');
 832 insert into area values(1882,'431021','桂阳县','431000');
 833 insert into area values(1883,'431022','宜章县','431000');
 834 insert into area values(1884,'431023','永兴县','431000');
 835 insert into area values(1885,'431024','嘉禾县','431000');
 836 insert into area values(1886,'431025','临武县','431000');
 837 insert into area values(1887,'431026','汝城县','431000');
 838 insert into area values(1888,'431027','桂东县','431000');
 839 insert into area values(1889,'431028','安仁县','431000');
 840 insert into area values(1890,'431081','资兴市','431000');
 841 insert into area values(1891,'431101','市辖区','431100');
 842 insert into area values(1892,'431102','芝山区','431100');
 843 insert into area values(1893,'431103','冷水滩区','431100');
 844 insert into area values(1894,'431121','祁阳县','431100');
 845 insert into area values(1895,'431122','东安县','431100');
 846 insert into area values(1896,'431123','双牌县','431100');
 847 insert into area values(1897,'431124','道　县','431100');
 848 insert into area values(1898,'431125','江永县','431100');
 849 insert into area values(1899,'431126','宁远县','431100');
 850 insert into area values(1900,'431127','蓝山县','431100');
 851 insert into area values(1901,'431128','新田县','431100');
 852 insert into area values(1902,'431129','江华瑶族自治县','431100');
 853 insert into area values(1903,'431201','市辖区','431200');
 854 insert into area values(1904,'431202','鹤城区','431200');
 855 insert into area values(1905,'431221','中方县','431200');
 856 insert into area values(1906,'431222','沅陵县','431200');
 857 insert into area values(1907,'431223','辰溪县','431200');
 858 insert into area values(1908,'431224','溆浦县','431200');
 859 insert into area values(1909,'431225','会同县','431200');
 860 insert into area values(1910,'431226','麻阳苗族自治县','431200');
 861 insert into area values(1911,'431227','新晃侗族自治县','431200');
 862 insert into area values(1912,'431228','芷江侗族自治县','431200');
 863 insert into area values(1913,'431229','靖州苗族侗族自治县','431200');
 864 insert into area values(1914,'431230','通道侗族自治县','431200');
 865 insert into area values(1915,'431281','洪江市','431200');
 866 insert into area values(1916,'431301','市辖区','431300');
 867 insert into area values(1917,'431302','娄星区','431300');
 868 insert into area values(1918,'431321','双峰县','431300');
 869 insert into area values(1919,'431322','新化县','431300');
 870 insert into area values(1920,'431381','冷水江市','431300');
 871 insert into area values(1921,'431382','涟源市','431300');
 872 insert into area values(1922,'433101','吉首市','433100');
 873 insert into area values(1923,'433122','泸溪县','433100');
 874 insert into area values(1924,'433123','凤凰县','433100');
 875 insert into area values(1925,'433124','花垣县','433100');
 876 insert into area values(1926,'433125','保靖县','433100');
 877 insert into area values(1927,'433126','古丈县','433100');
 878 insert into area values(1928,'433127','永顺县','433100');
 879 insert into area values(1929,'433130','龙山县','433100');
 880 insert into area values(1930,'440101','市辖区','440100');
 881 insert into area values(1931,'440102','东山区','440100');
 882 insert into area values(1932,'440103','荔湾区','440100');
 883 insert into area values(1933,'440104','越秀区','440100');
 884 insert into area values(1934,'440105','海珠区','440100');
 885 insert into area values(1935,'440106','天河区','440100');
 886 insert into area values(1936,'440107','芳村区','440100');
 887 insert into area values(1937,'440111','白云区','440100');
 888 insert into area values(1938,'440112','黄埔区','440100');
 889 insert into area values(1939,'440113','番禺区','440100');
 890 insert into area values(1940,'440114','花都区','440100');
 891 insert into area values(1941,'440183','增城市','440100');
 892 insert into area values(1942,'440184','从化市','440100');
 893 insert into area values(1943,'440201','市辖区','440200');
 894 insert into area values(1944,'440203','武江区','440200');
 895 insert into area values(1945,'440204','浈江区','440200');
 896 insert into area values(1946,'440205','曲江区','440200');
 897 insert into area values(1947,'440222','始兴县','440200');
 898 insert into area values(1948,'440224','仁化县','440200');
 899 insert into area values(1949,'440229','翁源县','440200');
 900 insert into area values(1950,'440232','乳源瑶族自治县','440200');
 901 insert into area values(1951,'440233','新丰县','440200');
 902 insert into area values(1952,'440281','乐昌市','440200');
 903 insert into area values(1953,'440282','南雄市','440200');
 904 insert into area values(1954,'440301','市辖区','440300');
 905 insert into area values(1955,'440303','罗湖区','440300');
 906 insert into area values(1956,'440304','福田区','440300');
 907 insert into area values(1957,'440305','南山区','440300');
 908 insert into area values(1958,'440306','宝安区','440300');
 909 insert into area values(1959,'440307','龙岗区','440300');
 910 insert into area values(1960,'440308','盐田区','440300');
 911 insert into area values(1961,'440401','市辖区','440400');
 912 insert into area values(1962,'440402','香洲区','440400');
 913 insert into area values(1963,'440403','斗门区','440400');
 914 insert into area values(1964,'440404','金湾区','440400');
 915 insert into area values(1965,'440501','市辖区','440500');
 916 insert into area values(1966,'440507','龙湖区','440500');
 917 insert into area values(1967,'440511','金平区','440500');
 918 insert into area values(1968,'440512','濠江区','440500');
 919 insert into area values(1969,'440513','潮阳区','440500');
 920 insert into area values(1970,'440514','潮南区','440500');
 921 insert into area values(1971,'440515','澄海区','440500');
 922 insert into area values(1972,'440523','南澳县','440500');
 923 insert into area values(1973,'440601','市辖区','440600');
 924 insert into area values(1974,'440604','禅城区','440600');
 925 insert into area values(1975,'440605','南海区','440600');
 926 insert into area values(1976,'440606','顺德区','440600');
 927 insert into area values(1977,'440607','三水区','440600');
 928 insert into area values(1978,'440608','高明区','440600');
 929 insert into area values(1979,'440701','市辖区','440700');
 930 insert into area values(1980,'440703','蓬江区','440700');
 931 insert into area values(1981,'440704','江海区','440700');
 932 insert into area values(1982,'440705','新会区','440700');
 933 insert into area values(1983,'440781','台山市','440700');
 934 insert into area values(1984,'440783','开平市','440700');
 935 insert into area values(1985,'440784','鹤山市','440700');
 936 insert into area values(1986,'440785','恩平市','440700');
 937 insert into area values(1987,'440801','市辖区','440800');
 938 insert into area values(1988,'440802','赤坎区','440800');
 939 insert into area values(1989,'440803','霞山区','440800');
 940 insert into area values(1990,'440804','坡头区','440800');
 941 insert into area values(1991,'440811','麻章区','440800');
 942 insert into area values(1992,'440823','遂溪县','440800');
 943 insert into area values(1993,'440825','徐闻县','440800');
 944 insert into area values(1994,'440881','廉江市','440800');
 945 insert into area values(1995,'440882','雷州市','440800');
 946 insert into area values(1996,'440883','吴川市','440800');
 947 insert into area values(1997,'440901','市辖区','440900');
 948 insert into area values(1998,'440902','茂南区','440900');
 949 insert into area values(1999,'440903','茂港区','440900');
 950 insert into area values(2000,'440923','电白县','440900');
 951 insert into area values(2001,'440981','高州市','440900');
 952 insert into area values(2002,'440982','化州市','440900');
 953 insert into area values(2003,'440983','信宜市','440900');
 954 insert into area values(2004,'441201','市辖区','441200');
 955 insert into area values(2005,'441202','端州区','441200');
 956 insert into area values(2006,'441203','鼎湖区','441200');
 957 insert into area values(2007,'441223','广宁县','441200');
 958 insert into area values(2008,'441224','怀集县','441200');
 959 insert into area values(2009,'441225','封开县','441200');
 960 insert into area values(2010,'441226','德庆县','441200');
 961 insert into area values(2011,'441283','高要市','441200');
 962 insert into area values(2012,'441284','四会市','441200');
 963 insert into area values(2013,'441301','市辖区','441300');
 964 insert into area values(2014,'441302','惠城区','441300');
 965 insert into area values(2015,'441303','惠阳区','441300');
 966 insert into area values(2016,'441322','博罗县','441300');
 967 insert into area values(2017,'441323','惠东县','441300');
 968 insert into area values(2018,'441324','龙门县','441300');
 969 insert into area values(2019,'441401','市辖区','441400');
 970 insert into area values(2020,'441402','梅江区','441400');
 971 insert into area values(2021,'441421','梅　县','441400');
 972 insert into area values(2022,'441422','大埔县','441400');
 973 insert into area values(2023,'441423','丰顺县','441400');
 974 insert into area values(2024,'441424','五华县','441400');
 975 insert into area values(2025,'441426','平远县','441400');
 976 insert into area values(2026,'441427','蕉岭县','441400');
 977 insert into area values(2027,'441481','兴宁市','441400');
 978 insert into area values(2028,'441501','市辖区','441500');
 979 insert into area values(2029,'441502','城　区','441500');
 980 insert into area values(2030,'441521','海丰县','441500');
 981 insert into area values(2031,'441523','陆河县','441500');
 982 insert into area values(2032,'441581','陆丰市','441500');
 983 insert into area values(2033,'441601','市辖区','441600');
 984 insert into area values(2034,'441602','源城区','441600');
 985 insert into area values(2035,'441621','紫金县','441600');
 986 insert into area values(2036,'441622','龙川县','441600');
 987 insert into area values(2037,'441623','连平县','441600');
 988 insert into area values(2038,'441624','和平县','441600');
 989 insert into area values(2039,'441625','东源县','441600');
 990 insert into area values(2040,'441701','市辖区','441700');
 991 insert into area values(2041,'441702','江城区','441700');
 992 insert into area values(2042,'441721','阳西县','441700');
 993 insert into area values(2043,'441723','阳东县','441700');
 994 insert into area values(2044,'441781','阳春市','441700');
 995 insert into area values(2045,'441801','市辖区','441800');
 996 insert into area values(2046,'441802','清城区','441800');
 997 insert into area values(2047,'441821','佛冈县','441800');
 998 insert into area values(2048,'441823','阳山县','441800');
 999 insert into area values(2049,'441825','连山壮族瑶族自治县','441800');
1000 insert into area values(2050,'441826','连南瑶族自治县','441800');
1001 insert into area values(2051,'441827','清新县','441800');
1002 insert into area values(2052,'441881','英德市','441800');
1003 insert into area values(2053,'441882','连州市','441800');
1004 insert into area values(2054,'445101','市辖区','445100');
1005 insert into area values(2055,'445102','湘桥区','445100');
1006 insert into area values(2056,'445121','潮安县','445100');
1007 insert into area values(2057,'445122','饶平县','445100');
1008 insert into area values(2058,'445201','市辖区','445200');
1009 insert into area values(2059,'445202','榕城区','445200');
1010 insert into area values(2060,'445221','揭东县','445200');
1011 insert into area values(2061,'445222','揭西县','445200');
1012 insert into area values(2062,'445224','惠来县','445200');
1013 insert into area values(2063,'445281','普宁市','445200');
1014 insert into area values(2064,'445301','市辖区','445300');
1015 insert into area values(2065,'445302','云城区','445300');
1016 insert into area values(2066,'445321','新兴县','445300');
1017 insert into area values(2067,'445322','郁南县','445300');
1018 insert into area values(2068,'445323','云安县','445300');
1019 insert into area values(2069,'445381','罗定市','445300');
1020 insert into area values(2070,'450101','市辖区','450100');
1021 insert into area values(2071,'450102','兴宁区','450100');
1022 insert into area values(2072,'450103','青秀区','450100');
1023 insert into area values(2073,'450105','江南区','450100');
1024 insert into area values(2074,'450107','西乡塘区','450100');
1025 insert into area values(2075,'450108','良庆区','450100');
1026 insert into area values(2076,'450109','邕宁区','450100');
1027 insert into area values(2077,'450122','武鸣县','450100');
1028 insert into area values(2078,'450123','隆安县','450100');
1029 insert into area values(2079,'450124','马山县','450100');
1030 insert into area values(2080,'450125','上林县','450100');
1031 insert into area values(2081,'450126','宾阳县','450100');
1032 insert into area values(2082,'450127','横　县','450100');
1033 insert into area values(2083,'450201','市辖区','450200');
1034 insert into area values(2084,'450202','城中区','450200');
1035 insert into area values(2085,'450203','鱼峰区','450200');
1036 insert into area values(2086,'450204','柳南区','450200');
1037 insert into area values(2087,'450205','柳北区','450200');
1038 insert into area values(2088,'450221','柳江县','450200');
1039 insert into area values(2089,'450222','柳城县','450200');
1040 insert into area values(2090,'450223','鹿寨县','450200');
1041 insert into area values(2091,'450224','融安县','450200');
1042 insert into area values(2092,'450225','融水苗族自治县','450200');
1043 insert into area values(2093,'450226','三江侗族自治县','450200');
1044 insert into area values(2094,'450301','市辖区','450300');
1045 insert into area values(2095,'450302','秀峰区','450300');
1046 insert into area values(2096,'450303','叠彩区','450300');
1047 insert into area values(2097,'450304','象山区','450300');
1048 insert into area values(2098,'450305','七星区','450300');
1049 insert into area values(2099,'450311','雁山区','450300');
1050 insert into area values(2100,'450321','阳朔县','450300');
1051 insert into area values(2101,'450322','临桂县','450300');
1052 insert into area values(2102,'450323','灵川县','450300');
1053 insert into area values(2103,'450324','全州县','450300');
1054 insert into area values(2104,'450325','兴安县','450300');
1055 insert into area values(2105,'450326','永福县','450300');
1056 insert into area values(2106,'450327','灌阳县','450300');
1057 insert into area values(2107,'450328','龙胜各族自治县','450300');
1058 insert into area values(2108,'450329','资源县','450300');
1059 insert into area values(2109,'450330','平乐县','450300');
1060 insert into area values(2110,'450331','荔蒲县','450300');
1061 insert into area values(2111,'450332','恭城瑶族自治县','450300');
1062 insert into area values(2112,'450401','市辖区','450400');
1063 insert into area values(2113,'450403','万秀区','450400');
1064 insert into area values(2114,'450404','蝶山区','450400');
1065 insert into area values(2115,'450405','长洲区','450400');
1066 insert into area values(2116,'450421','苍梧县','450400');
1067 insert into area values(2117,'450422','藤　县','450400');
1068 insert into area values(2118,'450423','蒙山县','450400');
1069 insert into area values(2119,'450481','岑溪市','450400');
1070 insert into area values(2120,'450501','市辖区','450500');
1071 insert into area values(2121,'450502','海城区','450500');
1072 insert into area values(2122,'450503','银海区','450500');
1073 insert into area values(2123,'450512','铁山港区','450500');
1074 insert into area values(2124,'450521','合浦县','450500');
1075 insert into area values(2125,'450601','市辖区','450600');
1076 insert into area values(2126,'450602','港口区','450600');
1077 insert into area values(2127,'450603','防城区','450600');
1078 insert into area values(2128,'450621','上思县','450600');
1079 insert into area values(2129,'450681','东兴市','450600');
1080 insert into area values(2130,'450701','市辖区','450700');
1081 insert into area values(2131,'450702','钦南区','450700');
1082 insert into area values(2132,'450703','钦北区','450700');
1083 insert into area values(2133,'450721','灵山县','450700');
1084 insert into area values(2134,'450722','浦北县','450700');
1085 insert into area values(2135,'450801','市辖区','450800');
1086 insert into area values(2136,'450802','港北区','450800');
1087 insert into area values(2137,'450803','港南区','450800');
1088 insert into area values(2138,'450804','覃塘区','450800');
1089 insert into area values(2139,'450821','平南县','450800');
1090 insert into area values(2140,'450881','桂平市','450800');
1091 insert into area values(2141,'450901','市辖区','450900');
1092 insert into area values(2142,'450902','玉州区','450900');
1093 insert into area values(2143,'450921','容　县','450900');
1094 insert into area values(2144,'450922','陆川县','450900');
1095 insert into area values(2145,'450923','博白县','450900');
1096 insert into area values(2146,'450924','兴业县','450900');
1097 insert into area values(2147,'450981','北流市','450900');
1098 insert into area values(2148,'451001','市辖区','451000');
1099 insert into area values(2149,'451002','右江区','451000');
1100 insert into area values(2150,'451021','田阳县','451000');
1101 insert into area values(2151,'451022','田东县','451000');
1102 insert into area values(2152,'451023','平果县','451000');
1103 insert into area values(2153,'451024','德保县','451000');
1104 insert into area values(2154,'451025','靖西县','451000');
1105 insert into area values(2155,'451026','那坡县','451000');
1106 insert into area values(2156,'451027','凌云县','451000');
1107 insert into area values(2157,'451028','乐业县','451000');
1108 insert into area values(2158,'451029','田林县','451000');
1109 insert into area values(2159,'451030','西林县','451000');
1110 insert into area values(2160,'451031','隆林各族自治县','451000');
1111 insert into area values(2161,'451101','市辖区','451100');
1112 insert into area values(2162,'451102','八步区','451100');
1113 insert into area values(2163,'451121','昭平县','451100');
1114 insert into area values(2164,'451122','钟山县','451100');
1115 insert into area values(2165,'451123','富川瑶族自治县','451100');
1116 insert into area values(2166,'451201','市辖区','451200');
1117 insert into area values(2167,'451202','金城江区','451200');
1118 insert into area values(2168,'451221','南丹县','451200');
1119 insert into area values(2169,'451222','天峨县','451200');
1120 insert into area values(2170,'451223','凤山县','451200');
1121 insert into area values(2171,'451224','东兰县','451200');
1122 insert into area values(2172,'451225','罗城仫佬族自治县','451200');
1123 insert into area values(2173,'451226','环江毛南族自治县','451200');
1124 insert into area values(2174,'451227','巴马瑶族自治县','451200');
1125 insert into area values(2175,'451228','都安瑶族自治县','451200');
1126 insert into area values(2176,'451229','大化瑶族自治县','451200');
1127 insert into area values(2177,'451281','宜州市','451200');
1128 insert into area values(2178,'451301','市辖区','451300');
1129 insert into area values(2179,'451302','兴宾区','451300');
1130 insert into area values(2180,'451321','忻城县','451300');
1131 insert into area values(2181,'451322','象州县','451300');
1132 insert into area values(2182,'451323','武宣县','451300');
1133 insert into area values(2183,'451324','金秀瑶族自治县','451300');
1134 insert into area values(2184,'451381','合山市','451300');
1135 insert into area values(2185,'451401','市辖区','451400');
1136 insert into area values(2186,'451402','江洲区','451400');
1137 insert into area values(2187,'451421','扶绥县','451400');
1138 insert into area values(2188,'451422','宁明县','451400');
1139 insert into area values(2189,'451423','龙州县','451400');
1140 insert into area values(2190,'451424','大新县','451400');
1141 insert into area values(2191,'451425','天等县','451400');
1142 insert into area values(2192,'451481','凭祥市','451400');
1143 insert into area values(2193,'460101','市辖区','460100');
1144 insert into area values(2194,'460105','秀英区','460100');
1145 insert into area values(2195,'460106','龙华区','460100');
1146 insert into area values(2196,'460107','琼山区','460100');
1147 insert into area values(2197,'460108','美兰区','460100');
1148 insert into area values(2198,'460201','市辖区','460200');
1149 insert into area values(2199,'469001','五指山市','469000');
1150 insert into area values(2200,'469002','琼海市','469000');
1151 insert into area values(2201,'469003','儋州市','469000');
1152 insert into area values(2202,'469005','文昌市','469000');
1153 insert into area values(2203,'469006','万宁市','469000');
1154 insert into area values(2204,'469007','东方市','469000');
1155 insert into area values(2205,'469025','定安县','469000');
1156 insert into area values(2206,'469026','屯昌县','469000');
1157 insert into area values(2207,'469027','澄迈县','469000');
1158 insert into area values(2208,'469028','临高县','469000');
1159 insert into area values(2209,'469030','白沙黎族自治县','469000');
1160 insert into area values(2210,'469031','昌江黎族自治县','469000');
1161 insert into area values(2211,'469033','乐东黎族自治县','469000');
1162 insert into area values(2212,'469034','陵水黎族自治县','469000');
1163 insert into area values(2213,'469035','保亭黎族苗族自治县','469000');
1164 insert into area values(2214,'469036','琼中黎族苗族自治县','469000');
1165 insert into area values(2215,'469037','西沙群岛','469000');
1166 insert into area values(2216,'469038','南沙群岛','469000');
1167 insert into area values(2217,'469039','中沙群岛的岛礁及其海域','469000');
1168 insert into area values(2218,'500101','万州区','500100');
1169 insert into area values(2219,'500102','涪陵区','500100');
1170 insert into area values(2220,'500103','渝中区','500100');
1171 insert into area values(2221,'500104','大渡口区','500100');
1172 insert into area values(2222,'500105','江北区','500100');
1173 insert into area values(2223,'500106','沙坪坝区','500100');
1174 insert into area values(2224,'500107','九龙坡区','500100');
1175 insert into area values(2225,'500108','南岸区','500100');
1176 insert into area values(2226,'500109','北碚区','500100');
1177 insert into area values(2227,'500110','万盛区','500100');
1178 insert into area values(2228,'500111','双桥区','500100');
1179 insert into area values(2229,'500112','渝北区','500100');
1180 insert into area values(2230,'500113','巴南区','500100');
1181 insert into area values(2231,'500114','黔江区','500100');
1182 insert into area values(2232,'500115','长寿区','500100');
1183 insert into area values(2233,'500222','綦江县','500200');
1184 insert into area values(2234,'500223','潼南县','500200');
1185 insert into area values(2235,'500224','铜梁县','500200');
1186 insert into area values(2236,'500225','大足县','500200');
1187 insert into area values(2237,'500226','荣昌县','500200');
1188 insert into area values(2238,'500227','璧山县','500200');
1189 insert into area values(2239,'500228','梁平县','500200');
1190 insert into area values(2240,'500229','城口县','500200');
1191 insert into area values(2241,'500230','丰都县','500200');
1192 insert into area values(2242,'500231','垫江县','500200');
1193 insert into area values(2243,'500232','武隆县','500200');
1194 insert into area values(2244,'500233','忠　县','500200');
1195 insert into area values(2245,'500234','开　县','500200');
1196 insert into area values(2246,'500235','云阳县','500200');
1197 insert into area values(2247,'500236','奉节县','500200');
1198 insert into area values(2248,'500237','巫山县','500200');
1199 insert into area values(2249,'500238','巫溪县','500200');
1200 insert into area values(2250,'500240','石柱土家族自治县','500200');
1201 insert into area values(2251,'500241','秀山土家族苗族自治县','500200');
1202 insert into area values(2252,'500242','酉阳土家族苗族自治县','500200');
1203 insert into area values(2253,'500243','彭水苗族土家族自治县','500200');

View Code

  1 insert into area values(2254,'500381','江津市','500300');
  2 insert into area values(2255,'500382','合川市','500300');
  3 insert into area values(2256,'500383','永川市','500300');
  4 insert into area values(2257,'500384','南川市','500300');
  5 insert into area values(2258,'510101','市辖区','510100');
  6 insert into area values(2259,'510104','锦江区','510100');
  7 insert into area values(2260,'510105','青羊区','510100');
  8 insert into area values(2261,'510106','金牛区','510100');
  9 insert into area values(2262,'510107','武侯区','510100');
 10 insert into area values(2263,'510108','成华区','510100');
 11 insert into area values(2264,'510112','龙泉驿区','510100');
 12 insert into area values(2265,'510113','青白江区','510100');
 13 insert into area values(2266,'510114','新都区','510100');
 14 insert into area values(2267,'510115','温江区','510100');
 15 insert into area values(2268,'510121','金堂县','510100');
 16 insert into area values(2269,'510122','双流县','510100');
 17 insert into area values(2270,'510124','郫　县','510100');
 18 insert into area values(2271,'510129','大邑县','510100');
 19 insert into area values(2272,'510131','蒲江县','510100');
 20 insert into area values(2273,'510132','新津县','510100');
 21 insert into area values(2274,'510181','都江堰市','510100');
 22 insert into area values(2275,'510182','彭州市','510100');
 23 insert into area values(2276,'510183','邛崃市','510100');
 24 insert into area values(2277,'510184','崇州市','510100');
 25 insert into area values(2278,'510301','市辖区','510300');
 26 insert into area values(2279,'510302','自流井区','510300');
 27 insert into area values(2280,'510303','贡井区','510300');
 28 insert into area values(2281,'510304','大安区','510300');
 29 insert into area values(2282,'510311','沿滩区','510300');
 30 insert into area values(2283,'510321','荣　县','510300');
 31 insert into area values(2284,'510322','富顺县','510300');
 32 insert into area values(2285,'510401','市辖区','510400');
 33 insert into area values(2286,'510402','东　区','510400');
 34 insert into area values(2287,'510403','西　区','510400');
 35 insert into area values(2288,'510411','仁和区','510400');
 36 insert into area values(2289,'510421','米易县','510400');
 37 insert into area values(2290,'510422','盐边县','510400');
 38 insert into area values(2291,'510501','市辖区','510500');
 39 insert into area values(2292,'510502','江阳区','510500');
 40 insert into area values(2293,'510503','纳溪区','510500');
 41 insert into area values(2294,'510504','龙马潭区','510500');
 42 insert into area values(2295,'510521','泸　县','510500');
 43 insert into area values(2296,'510522','合江县','510500');
 44 insert into area values(2297,'510524','叙永县','510500');
 45 insert into area values(2298,'510525','古蔺县','510500');
 46 insert into area values(2299,'510601','市辖区','510600');
 47 insert into area values(2300,'510603','旌阳区','510600');
 48 insert into area values(2301,'510623','中江县','510600');
 49 insert into area values(2302,'510626','罗江县','510600');
 50 insert into area values(2303,'510681','广汉市','510600');
 51 insert into area values(2304,'510682','什邡市','510600');
 52 insert into area values(2305,'510683','绵竹市','510600');
 53 insert into area values(2306,'510701','市辖区','510700');
 54 insert into area values(2307,'510703','涪城区','510700');
 55 insert into area values(2308,'510704','游仙区','510700');
 56 insert into area values(2309,'510722','三台县','510700');
 57 insert into area values(2310,'510723','盐亭县','510700');
 58 insert into area values(2311,'510724','安　县','510700');
 59 insert into area values(2312,'510725','梓潼县','510700');
 60 insert into area values(2313,'510726','北川羌族自治县','510700');
 61 insert into area values(2314,'510727','平武县','510700');
 62 insert into area values(2315,'510781','江油市','510700');
 63 insert into area values(2316,'510801','市辖区','510800');
 64 insert into area values(2317,'510802','市中区','510800');
 65 insert into area values(2318,'510811','元坝区','510800');
 66 insert into area values(2319,'510812','朝天区','510800');
 67 insert into area values(2320,'510821','旺苍县','510800');
 68 insert into area values(2321,'510822','青川县','510800');
 69 insert into area values(2322,'510823','剑阁县','510800');
 70 insert into area values(2323,'510824','苍溪县','510800');
 71 insert into area values(2324,'510901','市辖区','510900');
 72 insert into area values(2325,'510903','船山区','510900');
 73 insert into area values(2326,'510904','安居区','510900');
 74 insert into area values(2327,'510921','蓬溪县','510900');
 75 insert into area values(2328,'510922','射洪县','510900');
 76 insert into area values(2329,'510923','大英县','510900');
 77 insert into area values(2330,'511001','市辖区','511000');
 78 insert into area values(2331,'511002','市中区','511000');
 79 insert into area values(2332,'511011','东兴区','511000');
 80 insert into area values(2333,'511024','威远县','511000');
 81 insert into area values(2334,'511025','资中县','511000');
 82 insert into area values(2335,'511028','隆昌县','511000');
 83 insert into area values(2336,'511101','市辖区','511100');
 84 insert into area values(2337,'511102','市中区','511100');
 85 insert into area values(2338,'511111','沙湾区','511100');
 86 insert into area values(2339,'511112','五通桥区','511100');
 87 insert into area values(2340,'511113','金口河区','511100');
 88 insert into area values(2341,'511123','犍为县','511100');
 89 insert into area values(2342,'511124','井研县','511100');
 90 insert into area values(2343,'511126','夹江县','511100');
 91 insert into area values(2344,'511129','沐川县','511100');
 92 insert into area values(2345,'511132','峨边彝族自治县','511100');
 93 insert into area values(2346,'511133','马边彝族自治县','511100');
 94 insert into area values(2347,'511181','峨眉山市','511100');
 95 insert into area values(2348,'511301','市辖区','511300');
 96 insert into area values(2349,'511302','顺庆区','511300');
 97 insert into area values(2350,'511303','高坪区','511300');
 98 insert into area values(2351,'511304','嘉陵区','511300');
 99 insert into area values(2352,'511321','南部县','511300');
100 insert into area values(2353,'511322','营山县','511300');
101 insert into area values(2354,'511323','蓬安县','511300');
102 insert into area values(2355,'511324','仪陇县','511300');
103 insert into area values(2356,'511325','西充县','511300');
104 insert into area values(2357,'511381','阆中市','511300');
105 insert into area values(2358,'511401','市辖区','511400');
106 insert into area values(2359,'511402','东坡区','511400');
107 insert into area values(2360,'511421','仁寿县','511400');
108 insert into area values(2361,'511422','彭山县','511400');
109 insert into area values(2362,'511423','洪雅县','511400');
110 insert into area values(2363,'511424','丹棱县','511400');
111 insert into area values(2364,'511425','青神县','511400');
112 insert into area values(2365,'511501','市辖区','511500');
113 insert into area values(2366,'511502','翠屏区','511500');
114 insert into area values(2367,'511521','宜宾县','511500');
115 insert into area values(2368,'511522','南溪县','511500');
116 insert into area values(2369,'511523','江安县','511500');
117 insert into area values(2370,'511524','长宁县','511500');
118 insert into area values(2371,'511525','高　县','511500');
119 insert into area values(2372,'511526','珙　县','511500');
120 insert into area values(2373,'511527','筠连县','511500');
121 insert into area values(2374,'511528','兴文县','511500');
122 insert into area values(2375,'511529','屏山县','511500');
123 insert into area values(2376,'511601','市辖区','511600');
124 insert into area values(2377,'511602','广安区','511600');
125 insert into area values(2378,'511621','岳池县','511600');
126 insert into area values(2379,'511622','武胜县','511600');
127 insert into area values(2380,'511623','邻水县','511600');
128 insert into area values(2381,'511681','华莹市','511600');
129 insert into area values(2382,'511701','市辖区','511700');
130 insert into area values(2383,'511702','通川区','511700');
131 insert into area values(2384,'511721','达　县','511700');
132 insert into area values(2385,'511722','宣汉县','511700');
133 insert into area values(2386,'511723','开江县','511700');
134 insert into area values(2387,'511724','大竹县','511700');
135 insert into area values(2388,'511725','渠　县','511700');
136 insert into area values(2389,'511781','万源市','511700');
137 insert into area values(2390,'511801','市辖区','511800');
138 insert into area values(2391,'511802','雨城区','511800');
139 insert into area values(2392,'511821','名山县','511800');
140 insert into area values(2393,'511822','荥经县','511800');
141 insert into area values(2394,'511823','汉源县','511800');
142 insert into area values(2395,'511824','石棉县','511800');
143 insert into area values(2396,'511825','天全县','511800');
144 insert into area values(2397,'511826','芦山县','511800');
145 insert into area values(2398,'511827','宝兴县','511800');
146 insert into area values(2399,'511901','市辖区','511900');
147 insert into area values(2400,'511902','巴州区','511900');
148 insert into area values(2401,'511921','通江县','511900');
149 insert into area values(2402,'511922','南江县','511900');
150 insert into area values(2403,'511923','平昌县','511900');
151 insert into area values(2404,'512001','市辖区','512000');
152 insert into area values(2405,'512002','雁江区','512000');
153 insert into area values(2406,'512021','安岳县','512000');
154 insert into area values(2407,'512022','乐至县','512000');
155 insert into area values(2408,'512081','简阳市','512000');
156 insert into area values(2409,'513221','汶川县','513200');
157 insert into area values(2410,'513222','理　县','513200');
158 insert into area values(2411,'513223','茂　县','513200');
159 insert into area values(2412,'513224','松潘县','513200');
160 insert into area values(2413,'513225','九寨沟县','513200');
161 insert into area values(2414,'513226','金川县','513200');
162 insert into area values(2415,'513227','小金县','513200');
163 insert into area values(2416,'513228','黑水县','513200');
164 insert into area values(2417,'513229','马尔康县','513200');
165 insert into area values(2418,'513230','壤塘县','513200');
166 insert into area values(2419,'513231','阿坝县','513200');
167 insert into area values(2420,'513232','若尔盖县','513200');
168 insert into area values(2421,'513233','红原县','513200');
169 insert into area values(2422,'513321','康定县','513300');
170 insert into area values(2423,'513322','泸定县','513300');
171 insert into area values(2424,'513323','丹巴县','513300');
172 insert into area values(2425,'513324','九龙县','513300');
173 insert into area values(2426,'513325','雅江县','513300');
174 insert into area values(2427,'513326','道孚县','513300');
175 insert into area values(2428,'513327','炉霍县','513300');
176 insert into area values(2429,'513328','甘孜县','513300');
177 insert into area values(2430,'513329','新龙县','513300');
178 insert into area values(2431,'513330','德格县','513300');
179 insert into area values(2432,'513331','白玉县','513300');
180 insert into area values(2433,'513332','石渠县','513300');
181 insert into area values(2434,'513333','色达县','513300');
182 insert into area values(2435,'513334','理塘县','513300');
183 insert into area values(2436,'513335','巴塘县','513300');
184 insert into area values(2437,'513336','乡城县','513300');
185 insert into area values(2438,'513337','稻城县','513300');
186 insert into area values(2439,'513338','得荣县','513300');
187 insert into area values(2440,'513401','西昌市','513400');
188 insert into area values(2441,'513422','木里藏族自治县','513400');
189 insert into area values(2442,'513423','盐源县','513400');
190 insert into area values(2443,'513424','德昌县','513400');
191 insert into area values(2444,'513425','会理县','513400');
192 insert into area values(2445,'513426','会东县','513400');
193 insert into area values(2446,'513427','宁南县','513400');
194 insert into area values(2447,'513428','普格县','513400');
195 insert into area values(2448,'513429','布拖县','513400');
196 insert into area values(2449,'513430','金阳县','513400');
197 insert into area values(2450,'513431','昭觉县','513400');
198 insert into area values(2451,'513432','喜德县','513400');
199 insert into area values(2452,'513433','冕宁县','513400');
200 insert into area values(2453,'513434','越西县','513400');
201 insert into area values(2454,'513435','甘洛县','513400');
202 insert into area values(2455,'513436','美姑县','513400');
203 insert into area values(2456,'513437','雷波县','513400');
204 insert into area values(2457,'520101','市辖区','520100');
205 insert into area values(2458,'520102','南明区','520100');
206 insert into area values(2459,'520103','云岩区','520100');
207 insert into area values(2460,'520111','花溪区','520100');
208 insert into area values(2461,'520112','乌当区','520100');
209 insert into area values(2462,'520113','白云区','520100');
210 insert into area values(2463,'520114','小河区','520100');
211 insert into area values(2464,'520121','开阳县','520100');
212 insert into area values(2465,'520122','息烽县','520100');
213 insert into area values(2466,'520123','修文县','520100');
214 insert into area values(2467,'520181','清镇市','520100');
215 insert into area values(2468,'520201','钟山区','520200');
216 insert into area values(2469,'520203','六枝特区','520200');
217 insert into area values(2470,'520221','水城县','520200');
218 insert into area values(2471,'520222','盘　县','520200');
219 insert into area values(2472,'520301','市辖区','520300');
220 insert into area values(2473,'520302','红花岗区','520300');
221 insert into area values(2474,'520303','汇川区','520300');
222 insert into area values(2475,'520321','遵义县','520300');
223 insert into area values(2476,'520322','桐梓县','520300');
224 insert into area values(2477,'520323','绥阳县','520300');
225 insert into area values(2478,'520324','正安县','520300');
226 insert into area values(2479,'520325','道真仡佬族苗族自治县','520300');
227 insert into area values(2480,'520326','务川仡佬族苗族自治县','520300');
228 insert into area values(2481,'520327','凤冈县','520300');
229 insert into area values(2482,'520328','湄潭县','520300');
230 insert into area values(2483,'520329','余庆县','520300');
231 insert into area values(2484,'520330','习水县','520300');
232 insert into area values(2485,'520381','赤水市','520300');
233 insert into area values(2486,'520382','仁怀市','520300');
234 insert into area values(2487,'520401','市辖区','520400');
235 insert into area values(2488,'520402','西秀区','520400');
236 insert into area values(2489,'520421','平坝县','520400');
237 insert into area values(2490,'520422','普定县','520400');
238 insert into area values(2491,'520423','镇宁布依族苗族自治县','520400');
239 insert into area values(2492,'520424','关岭布依族苗族自治县','520400');
240 insert into area values(2493,'520425','紫云苗族布依族自治县','520400');
241 insert into area values(2494,'522201','铜仁市','522200');
242 insert into area values(2495,'522222','江口县','522200');
243 insert into area values(2496,'522223','玉屏侗族自治县','522200');
244 insert into area values(2497,'522224','石阡县','522200');
245 insert into area values(2498,'522225','思南县','522200');
246 insert into area values(2499,'522226','印江土家族苗族自治县','522200');
247 insert into area values(2500,'522227','德江县','522200');
248 insert into area values(2501,'522228','沿河土家族自治县','522200');
249 insert into area values(2502,'522229','松桃苗族自治县','522200');
250 insert into area values(2503,'522230','万山特区','522200');
251 insert into area values(2504,'522301','兴义市','522300');
252 insert into area values(2505,'522322','兴仁县','522300');
253 insert into area values(2506,'522323','普安县','522300');
254 insert into area values(2507,'522324','晴隆县','522300');
255 insert into area values(2508,'522325','贞丰县','522300');
256 insert into area values(2509,'522326','望谟县','522300');
257 insert into area values(2510,'522327','册亨县','522300');
258 insert into area values(2511,'522328','安龙县','522300');
259 insert into area values(2512,'522401','毕节市','522400');
260 insert into area values(2513,'522422','大方县','522400');
261 insert into area values(2514,'522423','黔西县','522400');
262 insert into area values(2515,'522424','金沙县','522400');
263 insert into area values(2516,'522425','织金县','522400');
264 insert into area values(2517,'522426','纳雍县','522400');
265 insert into area values(2518,'522427','威宁彝族回族苗族自治县','522400');
266 insert into area values(2519,'522428','赫章县','522400');
267 insert into area values(2520,'522601','凯里市','522600');
268 insert into area values(2521,'522622','黄平县','522600');
269 insert into area values(2522,'522623','施秉县','522600');
270 insert into area values(2523,'522624','三穗县','522600');
271 insert into area values(2524,'522625','镇远县','522600');
272 insert into area values(2525,'522626','岑巩县','522600');
273 insert into area values(2526,'522627','天柱县','522600');
274 insert into area values(2527,'522628','锦屏县','522600');
275 insert into area values(2528,'522629','剑河县','522600');
276 insert into area values(2529,'522630','台江县','522600');
277 insert into area values(2530,'522631','黎平县','522600');
278 insert into area values(2531,'522632','榕江县','522600');
279 insert into area values(2532,'522633','从江县','522600');
280 insert into area values(2533,'522634','雷山县','522600');
281 insert into area values(2534,'522635','麻江县','522600');
282 insert into area values(2535,'522636','丹寨县','522600');
283 insert into area values(2536,'522701','都匀市','522700');
284 insert into area values(2537,'522702','福泉市','522700');
285 insert into area values(2538,'522722','荔波县','522700');
286 insert into area values(2539,'522723','贵定县','522700');
287 insert into area values(2540,'522725','瓮安县','522700');
288 insert into area values(2541,'522726','独山县','522700');
289 insert into area values(2542,'522727','平塘县','522700');
290 insert into area values(2543,'522728','罗甸县','522700');
291 insert into area values(2544,'522729','长顺县','522700');
292 
293 insert into area values(2545,'522730','龙里县','522700');
294 insert into area values(2546,'522731','惠水县','522700');
295 insert into area values(2547,'522732','三都水族自治县','522700');
296 insert into area values(2548,'530101','市辖区','530100');
297 insert into area values(2549,'530102','五华区','530100');
298 insert into area values(2550,'530103','盘龙区','530100');
299 insert into area values(2551,'530111','官渡区','530100');
300 insert into area values(2552,'530112','西山区','530100');
301 insert into area values(2553,'530113','东川区','530100');
302 insert into area values(2554,'530121','呈贡县','530100');
303 insert into area values(2555,'530122','晋宁县','530100');
304 insert into area values(2556,'530124','富民县','530100');
305 insert into area values(2557,'530125','宜良县','530100');
306 insert into area values(2558,'530126','石林彝族自治县','530100');
307 insert into area values(2559,'530127','嵩明县','530100');
308 insert into area values(2560,'530128','禄劝彝族苗族自治县','530100');
309 insert into area values(2561,'530129','寻甸回族彝族自治县','530100');
310 insert into area values(2562,'530181','安宁市','530100');
311 insert into area values(2563,'530301','市辖区','530300');
312 insert into area values(2564,'530302','麒麟区','530300');
313 insert into area values(2565,'530321','马龙县','530300');
314 insert into area values(2566,'530322','陆良县','530300');
315 insert into area values(2567,'530323','师宗县','530300');
316 insert into area values(2568,'530324','罗平县','530300');
317 insert into area values(2569,'530325','富源县','530300');
318 insert into area values(2570,'530326','会泽县','530300');
319 insert into area values(2571,'530328','沾益县','530300');
320 insert into area values(2572,'530381','宣威市','530300');
321 insert into area values(2573,'530401','市辖区','530400');
322 insert into area values(2574,'530402','红塔区','530400');
323 insert into area values(2575,'530421','江川县','530400');
324 insert into area values(2576,'530422','澄江县','530400');
325 insert into area values(2577,'530423','通海县','530400');
326 insert into area values(2578,'530424','华宁县','530400');
327 insert into area values(2579,'530425','易门县','530400');
328 insert into area values(2580,'530426','峨山彝族自治县','530400');
329 insert into area values(2581,'530427','新平彝族傣族自治县','530400');
330 insert into area values(2582,'530428','元江哈尼族彝族傣族自治县','530400');
331 insert into area values(2583,'530501','市辖区','530500');
332 insert into area values(2584,'530502','隆阳区','530500');
333 insert into area values(2585,'530521','施甸县','530500');
334 insert into area values(2586,'530522','腾冲县','530500');
335 insert into area values(2587,'530523','龙陵县','530500');
336 insert into area values(2588,'530524','昌宁县','530500');
337 insert into area values(2589,'530601','市辖区','530600');
338 insert into area values(2590,'530602','昭阳区','530600');
339 insert into area values(2591,'530621','鲁甸县','530600');
340 insert into area values(2592,'530622','巧家县','530600');
341 insert into area values(2593,'530623','盐津县','530600');
342 insert into area values(2594,'530624','大关县','530600');
343 insert into area values(2595,'530625','永善县','530600');
344 insert into area values(2596,'530626','绥江县','530600');
345 insert into area values(2597,'530627','镇雄县','530600');
346 insert into area values(2598,'530628','彝良县','530600');
347 insert into area values(2599,'530629','威信县','530600');
348 insert into area values(2600,'530630','水富县','530600');
349 insert into area values(2601,'530701','市辖区','530700');
350 insert into area values(2602,'530702','古城区','530700');
351 insert into area values(2603,'530721','玉龙纳西族自治县','530700');
352 insert into area values(2604,'530722','永胜县','530700');
353 insert into area values(2605,'530723','华坪县','530700');
354 insert into area values(2606,'530724','宁蒗彝族自治县','530700');
355 insert into area values(2607,'530801','市辖区','530800');
356 insert into area values(2608,'530802','翠云区','530800');
357 insert into area values(2609,'530821','普洱哈尼族彝族自治县','530800');
358 insert into area values(2610,'530822','墨江哈尼族自治县','530800');
359 insert into area values(2611,'530823','景东彝族自治县','530800');
360 insert into area values(2612,'530824','景谷傣族彝族自治县','530800');
361 insert into area values(2613,'530825','镇沅彝族哈尼族拉祜族自治县','530800');
362 insert into area values(2614,'530826','江城哈尼族彝族自治县','530800');
363 insert into area values(2615,'530827','孟连傣族拉祜族佤族自治县','530800');
364 insert into area values(2616,'530828','澜沧拉祜族自治县','530800');
365 insert into area values(2617,'530829','西盟佤族自治县','530800');
366 insert into area values(2618,'530901','市辖区','530900');
367 insert into area values(2619,'530902','临翔区','530900');
368 insert into area values(2620,'530921','凤庆县','530900');
369 insert into area values(2621,'530922','云　县','530900');
370 insert into area values(2622,'530923','永德县','530900');
371 insert into area values(2623,'530924','镇康县','530900');
372 insert into area values(2624,'530925','双江拉祜族佤族布朗族傣族自治县','530900');
373 insert into area values(2625,'530926','耿马傣族佤族自治县','530900');
374 insert into area values(2626,'530927','沧源佤族自治县','530900');
375 insert into area values(2627,'532301','楚雄市','532300');
376 insert into area values(2628,'532322','双柏县','532300');
377 insert into area values(2629,'532323','牟定县','532300');
378 insert into area values(2630,'532324','南华县','532300');
379 insert into area values(2631,'532325','姚安县','532300');
380 insert into area values(2632,'532326','大姚县','532300');
381 insert into area values(2633,'532327','永仁县','532300');
382 insert into area values(2634,'532328','元谋县','532300');
383 insert into area values(2635,'532329','武定县','532300');
384 insert into area values(2636,'532331','禄丰县','532300');
385 insert into area values(2637,'532501','个旧市','532500');
386 insert into area values(2638,'532502','开远市','532500');
387 insert into area values(2639,'532522','蒙自县','532500');
388 insert into area values(2640,'532523','屏边苗族自治县','532500');
389 insert into area values(2641,'532524','建水县','532500');
390 insert into area values(2642,'532525','石屏县','532500');
391 insert into area values(2643,'532526','弥勒县','532500');
392 insert into area values(2644,'532527','泸西县','532500');
393 insert into area values(2645,'532528','元阳县','532500');
394 insert into area values(2646,'532529','红河县','532500');
395 insert into area values(2647,'532530','金平苗族瑶族傣族自治县','532500');
396 insert into area values(2648,'532531','绿春县','532500');
397 insert into area values(2649,'532532','河口瑶族自治县','532500');
398 insert into area values(2650,'532621','文山县','532600');
399 insert into area values(2651,'532622','砚山县','532600');
400 insert into area values(2652,'532623','西畴县','532600');
401 insert into area values(2653,'532624','麻栗坡县','532600');
402 insert into area values(2654,'532625','马关县','532600');
403 insert into area values(2655,'532626','丘北县','532600');
404 insert into area values(2656,'532627','广南县','532600');
405 insert into area values(2657,'532628','富宁县','532600');
406 insert into area values(2658,'532801','景洪市','532800');
407 insert into area values(2659,'532822','勐海县','532800');
408 insert into area values(2660,'532823','勐腊县','532800');
409 insert into area values(2661,'532901','大理市','532900');
410 insert into area values(2662,'532922','漾濞彝族自治县','532900');
411 insert into area values(2663,'532923','祥云县','532900');
412 insert into area values(2664,'532924','宾川县','532900');
413 insert into area values(2665,'532925','弥渡县','532900');
414 insert into area values(2666,'532926','南涧彝族自治县','532900');
415 insert into area values(2667,'532927','巍山彝族回族自治县','532900');
416 insert into area values(2668,'532928','永平县','532900');
417 insert into area values(2669,'532929','云龙县','532900');
418 insert into area values(2670,'532930','洱源县','532900');
419 insert into area values(2671,'532931','剑川县','532900');
420 insert into area values(2672,'532932','鹤庆县','532900');
421 insert into area values(2673,'533102','瑞丽市','533100');
422 insert into area values(2674,'533103','潞西市','533100');
423 insert into area values(2675,'533122','梁河县','533100');
424 insert into area values(2676,'533123','盈江县','533100');
425 insert into area values(2677,'533124','陇川县','533100');
426 insert into area values(2678,'533321','泸水县','533300');
427 insert into area values(2679,'533323','福贡县','533300');
428 insert into area values(2680,'533324','贡山独龙族怒族自治县','533300');
429 insert into area values(2681,'533325','兰坪白族普米族自治县','533300');
430 insert into area values(2682,'533421','香格里拉县','533400');
431 insert into area values(2683,'533422','德钦县','533400');
432 insert into area values(2684,'533423','维西傈僳族自治县','533400');
433 insert into area values(2685,'540101','市辖区','540100');
434 insert into area values(2686,'540102','城关区','540100');
435 insert into area values(2687,'540121','林周县','540100');
436 insert into area values(2688,'540122','当雄县','540100');
437 insert into area values(2689,'540123','尼木县','540100');
438 insert into area values(2690,'540124','曲水县','540100');
439 insert into area values(2691,'540125','堆龙德庆县','540100');
440 insert into area values(2692,'540126','达孜县','540100');
441 insert into area values(2693,'540127','墨竹工卡县','540100');
442 insert into area values(2694,'542121','昌都县','542100');
443 insert into area values(2695,'542122','江达县','542100');
444 insert into area values(2696,'542123','贡觉县','542100');
445 insert into area values(2697,'542124','类乌齐县','542100');
446 insert into area values(2698,'542125','丁青县','542100');
447 insert into area values(2699,'542126','察雅县','542100');
448 insert into area values(2700,'542127','八宿县','542100');
449 insert into area values(2701,'542128','左贡县','542100');
450 insert into area values(2702,'542129','芒康县','542100');
451 insert into area values(2703,'542132','洛隆县','542100');
452 insert into area values(2704,'542133','边坝县','542100');
453 insert into area values(2705,'542221','乃东县','542200');
454 insert into area values(2706,'542222','扎囊县','542200');
455 insert into area values(2707,'542223','贡嘎县','542200');
456 insert into area values(2708,'542224','桑日县','542200');
457 insert into area values(2709,'542225','琼结县','542200');
458 insert into area values(2710,'542226','曲松县','542200');
459 insert into area values(2711,'542227','措美县','542200');
460 insert into area values(2712,'542228','洛扎县','542200');
461 insert into area values(2713,'542229','加查县','542200');
462 insert into area values(2714,'542231','隆子县','542200');
463 insert into area values(2715,'542232','错那县','542200');
464 insert into area values(2716,'542233','浪卡子县','542200');
465 insert into area values(2717,'542301','日喀则市','542300');
466 insert into area values(2718,'542322','南木林县','542300');
467 insert into area values(2719,'542323','江孜县','542300');
468 insert into area values(2720,'542324','定日县','542300');
469 insert into area values(2721,'542325','萨迦县','542300');
470 insert into area values(2722,'542326','拉孜县','542300');
471 insert into area values(2723,'542327','昂仁县','542300');
472 insert into area values(2724,'542328','谢通门县','542300');
473 insert into area values(2725,'542329','白朗县','542300');
474 insert into area values(2726,'542330','仁布县','542300');
475 insert into area values(2727,'542331','康马县','542300');
476 insert into area values(2728,'542332','定结县','542300');
477 insert into area values(2729,'542333','仲巴县','542300');
478 insert into area values(2730,'542334','亚东县','542300');
479 insert into area values(2731,'542335','吉隆县','542300');
480 insert into area values(2732,'542336','聂拉木县','542300');
481 insert into area values(2733,'542337','萨嘎县','542300');
482 insert into area values(2734,'542338','岗巴县','542300');
483 insert into area values(2735,'542421','那曲县','542400');
484 insert into area values(2736,'542422','嘉黎县','542400');
485 insert into area values(2737,'542423','比如县','542400');
486 insert into area values(2738,'542424','聂荣县','542400');
487 insert into area values(2739,'542425','安多县','542400');
488 insert into area values(2740,'542426','申扎县','542400');
489 insert into area values(2741,'542427','索　县','542400');
490 insert into area values(2742,'542428','班戈县','542400');
491 insert into area values(2743,'542429','巴青县','542400');
492 insert into area values(2744,'542430','尼玛县','542400');
493 insert into area values(2745,'542521','普兰县','542500');
494 insert into area values(2746,'542522','札达县','542500');
495 insert into area values(2747,'542523','噶尔县','542500');
496 insert into area values(2748,'542524','日土县','542500');
497 insert into area values(2749,'542525','革吉县','542500');
498 insert into area values(2750,'542526','改则县','542500');
499 insert into area values(2751,'542527','措勤县','542500');
500 insert into area values(2752,'542621','林芝县','542600');
501 insert into area values(2753,'542622','工布江达县','542600');
502 insert into area values(2754,'542623','米林县','542600');
503 insert into area values(2755,'542624','墨脱县','542600');
504 insert into area values(2756,'542625','波密县','542600');
505 insert into area values(2757,'542626','察隅县','542600');
506 insert into area values(2758,'542627','朗　县','542600');
507 insert into area values(2759,'610101','市辖区','610100');
508 insert into area values(2760,'610102','新城区','610100');
509 insert into area values(2761,'610103','碑林区','610100');
510 insert into area values(2762,'610104','莲湖区','610100');
511 insert into area values(2763,'610111','灞桥区','610100');
512 insert into area values(2764,'610112','未央区','610100');
513 insert into area values(2765,'610113','雁塔区','610100');
514 insert into area values(2766,'610114','阎良区','610100');
515 insert into area values(2767,'610115','临潼区','610100');
516 insert into area values(2768,'610116','长安区','610100');
517 insert into area values(2769,'610122','蓝田县','610100');
518 insert into area values(2770,'610124','周至县','610100');
519 insert into area values(2771,'610125','户　县','610100');
520 insert into area values(2772,'610126','高陵县','610100');
521 insert into area values(2773,'610201','市辖区','610200');
522 insert into area values(2774,'610202','王益区','610200');
523 insert into area values(2775,'610203','印台区','610200');
524 insert into area values(2776,'610204','耀州区','610200');
525 insert into area values(2777,'610222','宜君县','610200');
526 insert into area values(2778,'610301','市辖区','610300');
527 insert into area values(2779,'610302','渭滨区','610300');
528 insert into area values(2780,'610303','金台区','610300');
529 insert into area values(2781,'610304','陈仓区','610300');
530 insert into area values(2782,'610322','凤翔县','610300');
531 insert into area values(2783,'610323','岐山县','610300');
532 insert into area values(2784,'610324','扶风县','610300');
533 insert into area values(2785,'610326','眉　县','610300');
534 insert into area values(2786,'610327','陇　县','610300');
535 insert into area values(2787,'610328','千阳县','610300');
536 insert into area values(2788,'610329','麟游县','610300');
537 insert into area values(2789,'610330','凤　县','610300');
538 insert into area values(2790,'610331','太白县','610300');
539 insert into area values(2791,'610401','市辖区','610400');
540 insert into area values(2792,'610402','秦都区','610400');
541 insert into area values(2793,'610403','杨凌区','610400');
542 insert into area values(2794,'610404','渭城区','610400');
543 insert into area values(2795,'610422','三原县','610400');
544 insert into area values(2796,'610423','泾阳县','610400');
545 insert into area values(2797,'610424','乾　县','610400');
546 insert into area values(2798,'610425','礼泉县','610400');
547 insert into area values(2799,'610426','永寿县','610400');
548 insert into area values(2800,'610427','彬　县','610400');
549 insert into area values(2801,'610428','长武县','610400');
550 insert into area values(2802,'610429','旬邑县','610400');
551 insert into area values(2803,'610430','淳化县','610400');
552 insert into area values(2804,'610431','武功县','610400');
553 insert into area values(2805,'610481','兴平市','610400');
554 insert into area values(2806,'610501','市辖区','610500');
555 insert into area values(2807,'610502','临渭区','610500');
556 insert into area values(2808,'610521','华　县','610500');
557 insert into area values(2809,'610522','潼关县','610500');
558 insert into area values(2810,'610523','大荔县','610500');
559 insert into area values(2811,'610524','合阳县','610500');
560 insert into area values(2812,'610525','澄城县','610500');
561 insert into area values(2813,'610526','蒲城县','610500');
562 insert into area values(2814,'610527','白水县','610500');
563 insert into area values(2815,'610528','富平县','610500');
564 insert into area values(2816,'610581','韩城市','610500');
565 insert into area values(2817,'610582','华阴市','610500');
566 insert into area values(2818,'610601','市辖区','610600');
567 insert into area values(2819,'610602','宝塔区','610600');
568 insert into area values(2820,'610621','延长县','610600');
569 insert into area values(2821,'610622','延川县','610600');
570 insert into area values(2822,'610623','子长县','610600');
571 insert into area values(2823,'610624','安塞县','610600');
572 insert into area values(2824,'610625','志丹县','610600');
573 insert into area values(2825,'610626','吴旗县','610600');
574 insert into area values(2826,'610627','甘泉县','610600');
575 insert into area values(2827,'610628','富　县','610600');
576 insert into area values(2828,'610629','洛川县','610600');
577 insert into area values(2829,'610630','宜川县','610600');
578 insert into area values(2830,'610631','黄龙县','610600');
579 insert into area values(2831,'610632','黄陵县','610600');
580 insert into area values(2832,'610701','市辖区','610700');
581 insert into area values(2833,'610702','汉台区','610700');
582 insert into area values(2834,'610721','南郑县','610700');
583 insert into area values(2835,'610722','城固县','610700');
584 insert into area values(2836,'610723','洋　县','610700');
585 insert into area values(2837,'610724','西乡县','610700');
586 insert into area values(2838,'610725','勉　县','610700');
587 insert into area values(2839,'610726','宁强县','610700');
588 insert into area values(2840,'610727','略阳县','610700');
589 insert into area values(2841,'610728','镇巴县','610700');
590 insert into area values(2842,'610729','留坝县','610700');
591 insert into area values(2843,'610730','佛坪县','610700');
592 insert into area values(2844,'610801','市辖区','610800');
593 insert into area values(2845,'610802','榆阳区','610800');
594 insert into area values(2846,'610821','神木县','610800');
595 insert into area values(2847,'610822','府谷县','610800');
596 insert into area values(2848,'610823','横山县','610800');
597 insert into area values(2849,'610824','靖边县','610800');
598 insert into area values(2850,'610825','定边县','610800');
599 insert into area values(2851,'610826','绥德县','610800');
600 insert into area values(2852,'610827','米脂县','610800');
601 insert into area values(2853,'610828','佳　县','610800');
602 insert into area values(2854,'610829','吴堡县','610800');
603 insert into area values(2855,'610830','清涧县','610800');
604 insert into area values(2856,'610831','子洲县','610800');
605 insert into area values(2857,'610901','市辖区','610900');
606 insert into area values(2858,'610902','汉滨区','610900');
607 insert into area values(2859,'610921','汉阴县','610900');
608 insert into area values(2860,'610922','石泉县','610900');
609 insert into area values(2861,'610923','宁陕县','610900');
610 insert into area values(2862,'610924','紫阳县','610900');
611 insert into area values(2863,'610925','岚皋县','610900');
612 insert into area values(2864,'610926','平利县','610900');
613 insert into area values(2865,'610927','镇坪县','610900');
614 insert into area values(2866,'610928','旬阳县','610900');
615 insert into area values(2867,'610929','白河县','610900');
616 insert into area values(2868,'611001','市辖区','611000');
617 insert into area values(2869,'611002','商州区','611000');
618 insert into area values(2870,'611021','洛南县','611000');
619 insert into area values(2871,'611022','丹凤县','611000');
620 insert into area values(2872,'611023','商南县','611000');
621 insert into area values(2873,'611024','山阳县','611000');
622 insert into area values(2874,'611025','镇安县','611000');
623 insert into area values(2875,'611026','柞水县','611000');
624 insert into area values(2876,'620101','市辖区','620100');
625 insert into area values(2877,'620102','城关区','620100');
626 insert into area values(2878,'620103','七里河区','620100');
627 insert into area values(2879,'620104','西固区','620100');
628 insert into area values(2880,'620105','安宁区','620100');
629 insert into area values(2881,'620111','红古区','620100');
630 insert into area values(2882,'620121','永登县','620100');
631 insert into area values(2883,'620122','皋兰县','620100');
632 insert into area values(2884,'620123','榆中县','620100');
633 insert into area values(2885,'620201','市辖区','620200');
634 insert into area values(2886,'620301','市辖区','620300');
635 insert into area values(2887,'620302','金川区','620300');
636 insert into area values(2888,'620321','永昌县','620300');
637 insert into area values(2889,'620401','市辖区','620400');
638 insert into area values(2890,'620402','白银区','620400');
639 insert into area values(2891,'620403','平川区','620400');
640 insert into area values(2892,'620421','靖远县','620400');
641 insert into area values(2893,'620422','会宁县','620400');
642 insert into area values(2894,'620423','景泰县','620400');
643 insert into area values(2895,'620501','市辖区','620500');
644 insert into area values(2896,'620502','秦城区','620500');
645 insert into area values(2897,'620503','北道区','620500');
646 insert into area values(2898,'620521','清水县','620500');
647 insert into area values(2899,'620522','秦安县','620500');
648 insert into area values(2900,'620523','甘谷县','620500');
649 insert into area values(2901,'620524','武山县','620500');
650 insert into area values(2902,'620525','张家川回族自治县','620500');
651 insert into area values(2903,'620601','市辖区','620600');
652 insert into area values(2904,'620602','凉州区','620600');
653 insert into area values(2905,'620621','民勤县','620600');
654 insert into area values(2906,'620622','古浪县','620600');
655 insert into area values(2907,'620623','天祝藏族自治县','620600');
656 insert into area values(2908,'620701','市辖区','620700');
657 insert into area values(2909,'620702','甘州区','620700');
658 insert into area values(2910,'620721','肃南裕固族自治县','620700');
659 insert into area values(2911,'620722','民乐县','620700');
660 insert into area values(2912,'620723','临泽县','620700');
661 insert into area values(2913,'620724','高台县','620700');
662 insert into area values(2914,'620725','山丹县','620700');
663 insert into area values(2915,'620801','市辖区','620800');
664 insert into area values(2916,'620802','崆峒区','620800');
665 insert into area values(2917,'620821','泾川县','620800');
666 insert into area values(2918,'620822','灵台县','620800');
667 insert into area values(2919,'620823','崇信县','620800');
668 insert into area values(2920,'620824','华亭县','620800');
669 insert into area values(2921,'620825','庄浪县','620800');
670 insert into area values(2922,'620826','静宁县','620800');
671 insert into area values(2923,'620901','市辖区','620900');
672 insert into area values(2924,'620902','肃州区','620900');
673 insert into area values(2925,'620921','金塔县','620900');
674 insert into area values(2926,'620922','安西县','620900');
675 insert into area values(2927,'620923','肃北蒙古族自治县','620900');
676 insert into area values(2928,'620924','阿克塞哈萨克族自治县','620900');
677 insert into area values(2929,'620981','玉门市','620900');
678 insert into area values(2930,'620982','敦煌市','620900');
679 insert into area values(2931,'621001','市辖区','621000');
680 insert into area values(2932,'621002','西峰区','621000');
681 insert into area values(2933,'621021','庆城县','621000');
682 insert into area values(2934,'621022','环　县','621000');
683 insert into area values(2935,'621023','华池县','621000');
684 insert into area values(2936,'621024','合水县','621000');
685 insert into area values(2937,'621025','正宁县','621000');
686 insert into area values(2938,'621026','宁　县','621000');
687 insert into area values(2939,'621027','镇原县','621000');
688 insert into area values(2940,'621101','市辖区','621100');
689 insert into area values(2941,'621102','安定区','621100');
690 insert into area values(2942,'621121','通渭县','621100');
691 insert into area values(2943,'621122','陇西县','621100');
692 insert into area values(2944,'621123','渭源县','621100');
693 insert into area values(2945,'621124','临洮县','621100');
694 insert into area values(2946,'621125','漳　县','621100');
695 insert into area values(2947,'621126','岷　县','621100');
696 insert into area values(2948,'621201','市辖区','621200');
697 insert into area values(2949,'621202','武都区','621200');
698 insert into area values(2950,'621221','成　县','621200');
699 insert into area values(2951,'621222','文　县','621200');
700 insert into area values(2952,'621223','宕昌县','621200');
701 insert into area values(2953,'621224','康　县','621200');
702 insert into area values(2954,'621225','西和县','621200');
703 insert into area values(2955,'621226','礼　县','621200');
704 insert into area values(2956,'621227','徽　县','621200');
705 insert into area values(2957,'621228','两当县','621200');
706 insert into area values(2958,'622901','临夏市','622900');
707 insert into area values(2959,'622921','临夏县','622900');
708 insert into area values(2960,'622922','康乐县','622900');
709 insert into area values(2961,'622923','永靖县','622900');
710 insert into area values(2962,'622924','广河县','622900');
711 insert into area values(2963,'622925','和政县','622900');
712 insert into area values(2964,'622926','东乡族自治县','622900');
713 insert into area values(2965,'622927','积石山保安族东乡族撒拉族自治县','622900');
714 insert into area values(2966,'623001','合作市','623000');
715 insert into area values(2967,'623021','临潭县','623000');
716 insert into area values(2968,'623022','卓尼县','623000');
717 insert into area values(2969,'623023','舟曲县','623000');
718 insert into area values(2970,'623024','迭部县','623000');
719 insert into area values(2971,'623025','玛曲县','623000');
720 insert into area values(2972,'623026','碌曲县','623000');
721 insert into area values(2973,'623027','夏河县','623000');
722 insert into area values(2974,'630101','市辖区','630100');
723 insert into area values(2975,'630102','城东区','630100');
724 insert into area values(2976,'630103','城中区','630100');
725 insert into area values(2977,'630104','城西区','630100');
726 insert into area values(2978,'630105','城北区','630100');
727 insert into area values(2979,'630121','大通回族土族自治县','630100');
728 insert into area values(2980,'630122','湟中县','630100');
729 insert into area values(2981,'630123','湟源县','630100');
730 insert into area values(2982,'632121','平安县','632100');
731 insert into area values(2983,'632122','民和回族土族自治县','632100');
732 insert into area values(2984,'632123','乐都县','632100');
733 insert into area values(2985,'632126','互助土族自治县','632100');
734 insert into area values(2986,'632127','化隆回族自治县','632100');
735 insert into area values(2987,'632128','循化撒拉族自治县','632100');
736 insert into area values(2988,'632221','门源回族自治县','632200');
737 insert into area values(2989,'632222','祁连县','632200');
738 insert into area values(2990,'632223','海晏县','632200');
739 insert into area values(2991,'632224','刚察县','632200');
740 insert into area values(2992,'632321','同仁县','632300');
741 insert into area values(2993,'632322','尖扎县','632300');
742 insert into area values(2994,'632323','泽库县','632300');
743 insert into area values(2995,'632324','河南蒙古族自治县','632300');
744 insert into area values(2996,'632521','共和县','632500');
745 insert into area values(2997,'632522','同德县','632500');
746 insert into area values(2998,'632523','贵德县','632500');
747 insert into area values(2999,'632524','兴海县','632500');
748 insert into area values(3000,'632525','贵南县','632500');
749 insert into area values(3001,'632621','玛沁县','632600');
750 insert into area values(3002,'632622','班玛县','632600');
751 insert into area values(3003,'632623','甘德县','632600');
752 insert into area values(3004,'632624','达日县','632600');
753 insert into area values(3005,'632625','久治县','632600');
754 insert into area values(3006,'632626','玛多县','632600');
755 insert into area values(3007,'632721','玉树县','632700');
756 insert into area values(3008,'632722','杂多县','632700');
757 insert into area values(3009,'632723','称多县','632700');
758 insert into area values(3010,'632724','治多县','632700');
759 insert into area values(3011,'632725','囊谦县','632700');
760 insert into area values(3012,'632726','曲麻莱县','632700');
761 insert into area values(3013,'632801','格尔木市','632800');
762 insert into area values(3014,'632802','德令哈市','632800');
763 insert into area values(3015,'632821','乌兰县','632800');
764 insert into area values(3016,'632822','都兰县','632800');
765 insert into area values(3017,'632823','天峻县','632800');
766 insert into area values(3018,'640101','市辖区','640100');
767 insert into area values(3019,'640104','兴庆区','640100');
768 insert into area values(3020,'640105','西夏区','640100');
769 insert into area values(3021,'640106','金凤区','640100');
770 insert into area values(3022,'640121','永宁县','640100');
771 insert into area values(3023,'640122','贺兰县','640100');
772 insert into area values(3024,'640181','灵武市','640100');
773 insert into area values(3025,'640201','市辖区','640200');
774 insert into area values(3026,'640202','大武口区','640200');
775 insert into area values(3027,'640205','惠农区','640200');
776 insert into area values(3028,'640221','平罗县','640200');
777 insert into area values(3029,'640301','市辖区','640300');
778 insert into area values(3030,'640302','利通区','640300');
779 insert into area values(3031,'640323','盐池县','640300');
780 insert into area values(3032,'640324','同心县','640300');
781 insert into area values(3033,'640381','青铜峡市','640300');
782 insert into area values(3034,'640401','市辖区','640400');
783 insert into area values(3035,'640402','原州区','640400');
784 insert into area values(3036,'640422','西吉县','640400');
785 insert into area values(3037,'640423','隆德县','640400');
786 insert into area values(3038,'640424','泾源县','640400');
787 insert into area values(3039,'640425','彭阳县','640400');
788 insert into area values(3040,'640501','市辖区','640500');
789 insert into area values(3041,'640502','沙坡头区','640500');
790 insert into area values(3042,'640521','中宁县','640500');
791 insert into area values(3043,'640522','海原县','640500');
792 insert into area values(3044,'650101','市辖区','650100');
793 insert into area values(3045,'650102','天山区','650100');
794 insert into area values(3046,'650103','沙依巴克区','650100');
795 insert into area values(3047,'650104','新市区','650100');
796 insert into area values(3048,'650105','水磨沟区','650100');
797 insert into area values(3049,'650106','头屯河区','650100');
798 insert into area values(3050,'650107','达坂城区','650100');
799 insert into area values(3051,'650108','东山区','650100');
800 insert into area values(3052,'650121','乌鲁木齐县','650100');
801 insert into area values(3053,'650201','市辖区','650200');
802 insert into area values(3054,'650202','独山子区','650200');
803 insert into area values(3055,'650203','克拉玛依区','650200');
804 insert into area values(3056,'650204','白碱滩区','650200');
805 insert into area values(3057,'650205','乌尔禾区','650200');
806 insert into area values(3058,'652101','吐鲁番市','652100');
807 insert into area values(3059,'652122','鄯善县','652100');
808 insert into area values(3060,'652123','托克逊县','652100');
809 insert into area values(3061,'652201','哈密市','652200');
810 insert into area values(3062,'652222','巴里坤哈萨克自治县','652200');
811 insert into area values(3063,'652223','伊吾县','652200');
812 insert into area values(3064,'652301','昌吉市','652300');
813 insert into area values(3065,'652302','阜康市','652300');
814 insert into area values(3066,'652303','米泉市','652300');
815 insert into area values(3067,'652323','呼图壁县','652300');
816 insert into area values(3068,'652324','玛纳斯县','652300');
817 insert into area values(3069,'652325','奇台县','652300');
818 insert into area values(3070,'652327','吉木萨尔县','652300');
819 insert into area values(3071,'652328','木垒哈萨克自治县','652300');
820 insert into area values(3072,'652701','博乐市','652700');
821 insert into area values(3073,'652722','精河县','652700');
822 insert into area values(3074,'652723','温泉县','652700');
823 insert into area values(3075,'652801','库尔勒市','652800');
824 insert into area values(3076,'652822','轮台县','652800');
825 insert into area values(3077,'652823','尉犁县','652800');
826 insert into area values(3078,'652824','若羌县','652800');
827 insert into area values(3079,'652825','且末县','652800');
828 insert into area values(3080,'652826','焉耆回族自治县','652800');
829 insert into area values(3081,'652827','和静县','652800');
830 insert into area values(3082,'652828','和硕县','652800');
831 insert into area values(3083,'652829','博湖县','652800');
832 insert into area values(3084,'652901','阿克苏市','652900');
833 insert into area values(3085,'652922','温宿县','652900');
834 insert into area values(3086,'652923','库车县','652900');
835 insert into area values(3087,'652924','沙雅县','652900');
836 insert into area values(3088,'652925','新和县','652900');
837 insert into area values(3089,'652926','拜城县','652900');
838 insert into area values(3090,'652927','乌什县','652900');
839 insert into area values(3091,'652928','阿瓦提县','652900');
840 insert into area values(3092,'652929','柯坪县','652900');
841 insert into area values(3093,'653001','阿图什市','653000');
842 insert into area values(3094,'653022','阿克陶县','653000');
843 insert into area values(3095,'653023','阿合奇县','653000');
844 insert into area values(3096,'653024','乌恰县','653000');
845 insert into area values(3097,'653101','喀什市','653100');
846 insert into area values(3098,'653121','疏附县','653100');
847 insert into area values(3099,'653122','疏勒县','653100');
848 insert into area values(3100,'653123','英吉沙县','653100');
849 insert into area values(3101,'653124','泽普县','653100');
850 insert into area values(3102,'653125','莎车县','653100');
851 insert into area values(3103,'653126','叶城县','653100');
852 insert into area values(3104,'653127','麦盖提县','653100');
853 insert into area values(3105,'653128','岳普湖县','653100');
854 insert into area values(3106,'653129','伽师县','653100');
855 insert into area values(3107,'653130','巴楚县','653100');
856 insert into area values(3108,'653131','塔什库尔干塔吉克自治县','653100');
857 insert into area values(3109,'653201','和田市','653200');
858 insert into area values(3110,'653221','和田县','653200');
859 insert into area values(3111,'653222','墨玉县','653200');
860 insert into area values(3112,'653223','皮山县','653200');
861 insert into area values(3113,'653224','洛浦县','653200');
862 insert into area values(3114,'653225','策勒县','653200');
863 insert into area values(3115,'653226','于田县','653200');
864 insert into area values(3116,'653227','民丰县','653200');
865 insert into area values(3117,'654002','伊宁市','654000');
866 insert into area values(3118,'654003','奎屯市','654000');
867 insert into area values(3119,'654021','伊宁县','654000');
868 insert into area values(3120,'654022','察布查尔锡伯自治县','654000');
869 insert into area values(3121,'654023','霍城县','654000');
870 insert into area values(3122,'654024','巩留县','654000');
871 insert into area values(3123,'654025','新源县','654000');
872 insert into area values(3124,'654026','昭苏县','654000');
873 insert into area values(3125,'654027','特克斯县','654000');
874 insert into area values(3126,'654028','尼勒克县','654000');
875 insert into area values(3127,'654201','塔城市','654200');
876 insert into area values(3128,'654202','乌苏市','654200');
877 insert into area values(3129,'654221','额敏县','654200');
878 insert into area values(3130,'654223','沙湾县','654200');
879 insert into area values(3131,'654224','托里县','654200');
880 insert into area values(3132,'654225','裕民县','654200');
881 insert into area values(3133,'654226','和布克赛尔蒙古自治县','654200');
882 insert into area values(3134,'654301','阿勒泰市','654300');
883 insert into area values(3135,'654321','布尔津县','654300');
884 insert into area values(3136,'654322','富蕴县','654300');
885 insert into area values(3137,'654323','福海县','654300');
886 insert into area values(3138,'654324','哈巴河县','654300');
887 insert into area values(3139,'654325','青河县','654300');
888 insert into area values(3140,'654326','吉木乃县','654300');
889 insert into area values(3141,'659001','石河子市','659000');
890 insert into area values(3142,'659002','阿拉尔市','659000');
891 insert into area values(3143,'659003','图木舒克市','659000');
892 insert into area values(3144,'659004','五家渠市','659000');

View Code

http://mp.weixin.qq.com/s?__biz=MjM5MDgxNjc0MA==&mid=2650986101&idx=1&sn=90a39b1102e90ffa3be42eee593703cf&mpshare=1&scene=1&srcid=1011m13vjo2P2tM7SgWuCVa7#wechat_redirect

posted @ 2016-10-11 14:46 张老师的小黑屋阅读(3925) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

省市区三级联动（附数据库和导入模板的做法）

公告