高德地图城市代码及数据库插入语句

CREATE TABLE `city` (

  `id` varchar(20) NOT NULL COMMENT '城市代码',

  `city` varchar(20) default NULL COMMENT '城市中文名称',

  `lv` char(1) default NULL COMMENT '等级，1是省份，2是城市',

  `parentid` varchar(20) default NULL COMMENT '父类id',

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

说明：1：高德地图城市代码文件里头，高德并没有提供台湾地区的城市代码

          2：在省份的Id中，山西和陕西英文拼音一样，所以做一下区分：陕西用的id是shangxi。山西用的是shanxi。

          3：高德地图城市代码文件里头，高德将香港和澳门的城市代码都设置为1852，所以在此，我们将香港和澳门都当做一个地区，称为港澳地区。

insert into city(id,city,lv,parentid) values ("010","北京","1","1");

insert into city(id,city,lv,parentid) values ("021","上海","1","1");

insert into city(id,city,lv,parentid) values ("022","天津","1","1");

insert into city(id,city,lv,parentid) values ("023","重庆","1","1");

insert into city(id,city,lv,parentid) values ("anhui","安徽","1","1");

insert into city(id,city,lv,parentid) values ("0551","合肥","2","anhui");

insert into city(id,city,lv,parentid) values ("0553","芜湖","2","anhui");

insert into city(id,city,lv,parentid) values ("0556","安庆","2","anhui");

insert into city(id,city,lv,parentid) values ("0552","蚌埠","2","anhui");

insert into city(id,city,lv,parentid) values ("0558","亳州","2","anhui");

insert into city(id,city,lv,parentid) values ("0565","巢湖","2","anhui");

insert into city(id,city,lv,parentid) values ("0566","池州","2","anhui");

insert into city(id,city,lv,parentid) values ("0550","滁州","2","anhui");

insert into city(id,city,lv,parentid) values ("1558","阜阳","2","anhui");

insert into city(id,city,lv,parentid) values ("0559","黄山","2","anhui");

insert into city(id,city,lv,parentid) values ("0561","淮北","2","anhui");

insert into city(id,city,lv,parentid) values ("0554","淮南","2","anhui");

insert into city(id,city,lv,parentid) values ("0564","六安","2","anhui");

insert into city(id,city,lv,parentid) values ("0555","马鞍山","2","anhui");

insert into city(id,city,lv,parentid) values ("0557","宿州","2","anhui");

insert into city(id,city,lv,parentid) values ("0562","铜陵","2","anhui");

insert into city(id,city,lv,parentid) values ("0563","宣城","2","anhui");

insert into city(id,city,lv,parentid) values ("fujian","福建","1","1");

insert into city(id,city,lv,parentid) values ("0591","福州","2","fujian");

insert into city(id,city,lv,parentid) values ("0592","厦门","2","fujian");

insert into city(id,city,lv,parentid) values ("0595","泉州","2","fujian");

insert into city(id,city,lv,parentid) values ("0597","龙岩","2","fujian");

insert into city(id,city,lv,parentid) values ("0593","宁德","2","fujian");

insert into city(id,city,lv,parentid) values ("0599","南平","2","fujian");

insert into city(id,city,lv,parentid) values ("0594","莆田","2","fujian");

insert into city(id,city,lv,parentid) values ("0598","三明","2","fujian");

insert into city(id,city,lv,parentid) values ("0596","漳州","2","fujian");

insert into city(id,city,lv,parentid) values ("gansu","甘肃","1","1");

insert into city(id,city,lv,parentid) values ("0931","兰州","2","gansu");

insert into city(id,city,lv,parentid) values ("0943","白银","2","gansu");

insert into city(id,city,lv,parentid) values ("0932","定西","2","gansu");

insert into city(id,city,lv,parentid) values ("0935","金昌","2","gansu");

insert into city(id,city,lv,parentid) values ("0937","酒泉","2","gansu");

insert into city(id,city,lv,parentid) values ("0933","平凉","2","gansu");

insert into city(id,city,lv,parentid) values ("0934","庆阳","2","gansu");

insert into city(id,city,lv,parentid) values ("1935","武威","2","gansu");

insert into city(id,city,lv,parentid) values ("0938","天水","2","gansu");

insert into city(id,city,lv,parentid) values ("0936","张掖","2","gansu");

insert into city(id,city,lv,parentid) values ("0941","甘南","2","gansu");

insert into city(id,city,lv,parentid) values ("1937","嘉峪关","2","gansu");

insert into city(id,city,lv,parentid) values ("0930","临夏","2","gansu");

insert into city(id,city,lv,parentid) values ("2935","陇南","2","gansu");

insert into city(id,city,lv,parentid) values ("guangdong","广东","1","1");

insert into city(id,city,lv,parentid) values ("020","广州","2","guangdong");

insert into city(id,city,lv,parentid) values ("0755","深圳","2","guangdong");

insert into city(id,city,lv,parentid) values ("0756","珠海","2","guangdong");

insert into city(id,city,lv,parentid) values ("0769","东莞","2","guangdong");

insert into city(id,city,lv,parentid) values ("0757","佛山","2","guangdong");

insert into city(id,city,lv,parentid) values ("0752","惠州","2","guangdong");

insert into city(id,city,lv,parentid) values ("0750","江门","2","guangdong");

insert into city(id,city,lv,parentid) values ("0760","中山","2","guangdong");

insert into city(id,city,lv,parentid) values ("0754","汕头","2","guangdong");

insert into city(id,city,lv,parentid) values ("0759","湛江","2","guangdong");

insert into city(id,city,lv,parentid) values ("0768","潮州","2","guangdong");

insert into city(id,city,lv,parentid) values ("0762","河源","2","guangdong");

insert into city(id,city,lv,parentid) values ("0663","揭阳","2","guangdong");

insert into city(id,city,lv,parentid) values ("0668","茂名","2","guangdong");

insert into city(id,city,lv,parentid) values ("0753","梅州","2","guangdong");

insert into city(id,city,lv,parentid) values ("0763","清远","2","guangdong");

insert into city(id,city,lv,parentid) values ("0751","韶关","2","guangdong");

insert into city(id,city,lv,parentid) values ("0660","汕尾","2","guangdong");

insert into city(id,city,lv,parentid) values ("0662","阳江","2","guangdong");

insert into city(id,city,lv,parentid) values ("0766","云浮","2","guangdong");

insert into city(id,city,lv,parentid) values ("0758","肇庆","2","guangdong");

insert into city(id,city,lv,parentid) values ("guangxi","广西","1","1");

insert into city(id,city,lv,parentid) values ("0771","南宁","2","guangxi");

insert into city(id,city,lv,parentid) values ("0779","北海","2","guangxi");

insert into city(id,city,lv,parentid) values ("0770","防城港","2","guangxi");

insert into city(id,city,lv,parentid) values ("0773","桂林","2","guangxi");

insert into city(id,city,lv,parentid) values ("0772","柳州","2","guangxi");

insert into city(id,city,lv,parentid) values ("1771","崇左","2","guangxi");

insert into city(id,city,lv,parentid) values ("1772","来宾","2","guangxi");

insert into city(id,city,lv,parentid) values ("0774","梧州","2","guangxi");

insert into city(id,city,lv,parentid) values ("0778","河池","2","guangxi");

insert into city(id,city,lv,parentid) values ("0775","玉林","2","guangxi");

insert into city(id,city,lv,parentid) values ("1755","贵港","2","guangxi");

insert into city(id,city,lv,parentid) values ("1774","贺州","2","guangxi");

insert into city(id,city,lv,parentid) values ("0777","钦州","2","guangxi");

insert into city(id,city,lv,parentid) values ("0776","百色","2","guangxi");

insert into city(id,city,lv,parentid) values ("guizhou","贵州","1","1");

insert into city(id,city,lv,parentid) values ("0851","贵阳","2","guizhou");

insert into city(id,city,lv,parentid) values ("0853","安顺","2","guizhou");

insert into city(id,city,lv,parentid) values ("0852","遵义","2","guizhou");

insert into city(id,city,lv,parentid) values ("0858","六盘水","2","guizhou");

insert into city(id,city,lv,parentid) values ("0857","毕节","2","guizhou");

insert into city(id,city,lv,parentid) values ("0855","黔东南","2","guizhou");

insert into city(id,city,lv,parentid) values ("0859","黔西南","2","guizhou");

insert into city(id,city,lv,parentid) values ("0854","黔南","2","guizhou");

insert into city(id,city,lv,parentid) values ("0856","铜仁","2","guizhou");

insert into city(id,city,lv,parentid) values ("hainan","海南","1","1");

insert into city(id,city,lv,parentid) values ("0898","海口","2","hainan");

insert into city(id,city,lv,parentid) values ("0899","三亚","2","hainan");

insert into city(id,city,lv,parentid) values ("0802","白沙县","2","hainan");

insert into city(id,city,lv,parentid) values ("0801","保亭县","2","hainan");

insert into city(id,city,lv,parentid) values ("0803","昌江县","2","hainan");

insert into city(id,city,lv,parentid) values ("0804","澄迈县","2","hainan");

insert into city(id,city,lv,parentid) values ("0806","定安县","2","hainan");

insert into city(id,city,lv,parentid) values ("0807","东方","2","hainan");

insert into city(id,city,lv,parentid) values ("2802","乐东县","2","hainan");

insert into city(id,city,lv,parentid) values ("1896","临高县","2","hainan");

insert into city(id,city,lv,parentid) values ("0809","陵水县","2","hainan");

insert into city(id,city,lv,parentid) values ("1894","琼海","2","hainan");

insert into city(id,city,lv,parentid) values ("1899","琼中县","2","hainan");

insert into city(id,city,lv,parentid) values ("1892","屯昌县","2","hainan");

insert into city(id,city,lv,parentid) values ("1898","万宁","2","hainan");

insert into city(id,city,lv,parentid) values ("1893","文昌","2","hainan");

insert into city(id,city,lv,parentid) values ("1897","五指山","2","hainan");

insert into city(id,city,lv,parentid) values ("0805","儋州","2","hainan");

insert into city(id,city,lv,parentid) values ("hebei","河北","1","1");

insert into city(id,city,lv,parentid) values ("0311","石家庄","2","hebei");

insert into city(id,city,lv,parentid) values ("0312","保定","2","hebei");

insert into city(id,city,lv,parentid) values ("0314","承德","2","hebei");

insert into city(id,city,lv,parentid) values ("0310","邯郸","2","hebei");

insert into city(id,city,lv,parentid) values ("0315","唐山","2","hebei");

insert into city(id,city,lv,parentid) values ("0335","秦皇岛","2","hebei");

insert into city(id,city,lv,parentid) values ("0317","沧州","2","hebei");

insert into city(id,city,lv,parentid) values ("0318","衡水","2","hebei");

insert into city(id,city,lv,parentid) values ("0316","廊坊","2","hebei");

insert into city(id,city,lv,parentid) values ("0319","邢台","2","hebei");

insert into city(id,city,lv,parentid) values ("0313","张家口","2","hebei");

insert into city(id,city,lv,parentid) values ("henan","河南","1","1");

insert into city(id,city,lv,parentid) values ("0371","郑州","2","henan");

insert into city(id,city,lv,parentid) values ("0379","洛阳","2","henan");

insert into city(id,city,lv,parentid) values ("0378","开封","2","henan");

insert into city(id,city,lv,parentid) values ("0374","许昌","2","henan");

insert into city(id,city,lv,parentid) values ("0372","安阳","2","henan");

insert into city(id,city,lv,parentid) values ("0375","平顶山","2","henan");

insert into city(id,city,lv,parentid) values ("0392","鹤壁","2","henan");

insert into city(id,city,lv,parentid) values ("0391","焦作","2","henan");

insert into city(id,city,lv,parentid) values ("1391","济源","2","henan");

insert into city(id,city,lv,parentid) values ("0395","漯河","2","henan");

insert into city(id,city,lv,parentid) values ("0377","南阳","2","henan");

insert into city(id,city,lv,parentid) values ("0393","濮阳","2","henan");

insert into city(id,city,lv,parentid) values ("0398","三门峡","2","henan");

insert into city(id,city,lv,parentid) values ("0370","商丘","2","henan");

insert into city(id,city,lv,parentid) values ("0373","新乡","2","henan");

insert into city(id,city,lv,parentid) values ("0376","信阳","2","henan");

insert into city(id,city,lv,parentid) values ("0396","驻马店","2","henan");

insert into city(id,city,lv,parentid) values ("0394","周口","2","henan");

insert into city(id,city,lv,parentid) values ("heilongjiang","黑龙江","1","1");

insert into city(id,city,lv,parentid) values ("0451","哈尔滨","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0459","大庆","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0452","齐齐哈尔","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0454","佳木斯","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0457","大兴安岭","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0456","黑河","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0468","鹤岗","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0467","鸡西","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0453","牡丹江","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0464","七台河","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0455","绥化","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0469","双鸭山","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("0458","伊春","2","heilongjiang");

insert into city(id,city,lv,parentid) values ("hubei","湖北","1","1");

insert into city(id,city,lv,parentid) values ("027","武汉","2","hubei");

insert into city(id,city,lv,parentid) values ("0710","襄阳","2","hubei");

insert into city(id,city,lv,parentid) values ("0719","十堰","2","hubei");

insert into city(id,city,lv,parentid) values ("0714","黄石","2","hubei");

insert into city(id,city,lv,parentid) values ("0711","鄂州","2","hubei");

insert into city(id,city,lv,parentid) values ("0718","恩施","2","hubei");

insert into city(id,city,lv,parentid) values ("0713","黄冈","2","hubei");

insert into city(id,city,lv,parentid) values ("0716","荆州","2","hubei");

insert into city(id,city,lv,parentid) values ("0724","荆门","2","hubei");

insert into city(id,city,lv,parentid) values ("0722","随州","2","hubei");

insert into city(id,city,lv,parentid) values ("0717","宜昌","2","hubei");

insert into city(id,city,lv,parentid) values ("1728","天门","2","hubei");

insert into city(id,city,lv,parentid) values ("2728","潜江","2","hubei");

insert into city(id,city,lv,parentid) values ("0728","仙桃","2","hubei");

insert into city(id,city,lv,parentid) values ("0712","孝感","2","hubei");

insert into city(id,city,lv,parentid) values ("0715","咸宁","2","hubei");

insert into city(id,city,lv,parentid) values ("1719","神农架","2","hubei");

insert into city(id,city,lv,parentid) values ("hunan","湖南","1","1");

insert into city(id,city,lv,parentid) values ("0731","长沙","2","hunan");

insert into city(id,city,lv,parentid) values ("0730","岳阳","2","hunan");

insert into city(id,city,lv,parentid) values ("0732","湘潭","2","hunan");

insert into city(id,city,lv,parentid) values ("0736","常德","2","hunan");

insert into city(id,city,lv,parentid) values ("0735","郴州","2","hunan");

insert into city(id,city,lv,parentid) values ("0734","衡阳","2","hunan");

insert into city(id,city,lv,parentid) values ("0745","怀化","2","hunan");

insert into city(id,city,lv,parentid) values ("0738","娄底","2","hunan");

insert into city(id,city,lv,parentid) values ("0739","邵阳","2","hunan");

insert into city(id,city,lv,parentid) values ("0737","益阳","2","hunan");

insert into city(id,city,lv,parentid) values ("0746","永州","2","hunan");

insert into city(id,city,lv,parentid) values ("0733","株洲","2","hunan");

insert into city(id,city,lv,parentid) values ("0744","张家界","2","hunan");

insert into city(id,city,lv,parentid) values ("0743","湘西","2","hunan");

insert into city(id,city,lv,parentid) values ("jilin","吉林","1","1");

insert into city(id,city,lv,parentid) values ("0431","长春","2","jilin");

insert into city(id,city,lv,parentid) values ("0432","吉林","2","jilin");

insert into city(id,city,lv,parentid) values ("1433","延边","2","jilin");

insert into city(id,city,lv,parentid) values ("0436","白城","2","jilin");

insert into city(id,city,lv,parentid) values ("0439","白山","2","jilin");

insert into city(id,city,lv,parentid) values ("0437","辽源","2","jilin");

insert into city(id,city,lv,parentid) values ("0434","四平","2","jilin");

insert into city(id,city,lv,parentid) values ("0438","松原","2","jilin");

insert into city(id,city,lv,parentid) values ("0435","通化","2","jilin");

insert into city(id,city,lv,parentid) values ("jiangsu","江苏","1","1");

insert into city(id,city,lv,parentid) values ("025","南京","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0512","苏州","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0519","常州","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0518","连云港","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0523","泰州","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0510","无锡","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0516","徐州","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0514","扬州","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0511","镇江","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0517","淮安","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0513","南通","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0527","宿迁","2","jiangsu");

insert into city(id,city,lv,parentid) values ("0515","盐城","2","jiangsu");

insert into city(id,city,lv,parentid) values ("jiangxi","江西","1","1");

insert into city(id,city,lv,parentid) values ("0791","南昌","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0797","赣州","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0792","九江","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0798","景德镇","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0796","吉安","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0799","萍乡","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0793","上饶","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0790","新余","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0795","宜春","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0701","鹰潭","2","jiangxi");

insert into city(id,city,lv,parentid) values ("0794","抚州","2","jiangxi");

insert into city(id,city,lv,parentid) values ("liaoning","辽宁","1","1");

insert into city(id,city,lv,parentid) values ("024","沈阳","2","liaoning");

insert into city(id,city,lv,parentid) values ("0411","大连","2","liaoning");

insert into city(id,city,lv,parentid) values ("0412","鞍山","2","liaoning");

insert into city(id,city,lv,parentid) values ("0415","丹东","2","liaoning");

insert into city(id,city,lv,parentid) values ("0413","抚顺","2","liaoning");

insert into city(id,city,lv,parentid) values ("0416","锦州","2","liaoning");

insert into city(id,city,lv,parentid) values ("0417","营口","2","liaoning");

insert into city(id,city,lv,parentid) values ("0414","本溪","2","liaoning");

insert into city(id,city,lv,parentid) values ("0421","朝阳","2","liaoning");

insert into city(id,city,lv,parentid) values ("0418","阜新","2","liaoning");

insert into city(id,city,lv,parentid) values ("0429","葫芦岛","2","liaoning");

insert into city(id,city,lv,parentid) values ("0419","辽阳","2","liaoning");

insert into city(id,city,lv,parentid) values ("0427","盘锦","2","liaoning");

insert into city(id,city,lv,parentid) values ("0410","铁岭","2","liaoning");

insert into city(id,city,lv,parentid) values ("neimenggu","内蒙古","1","1");

insert into city(id,city,lv,parentid) values ("0471","呼和浩特","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0472","包头","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0476","赤峰","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0477","鄂尔多斯","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0474","乌兰察布","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0473","乌海","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0482","兴安盟","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0470","呼伦贝尔","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0475","通辽","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0483","阿拉善盟","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0478","巴彦淖尔","2","neimenggu");

insert into city(id,city,lv,parentid) values ("0479","锡林郭勒","2","neimenggu");

insert into city(id,city,lv,parentid) values ("ningxia","宁夏","1","1");

insert into city(id,city,lv,parentid) values ("0951","银川","2","ningxia");

insert into city(id,city,lv,parentid) values ("0952","石嘴山","2","ningxia");

insert into city(id,city,lv,parentid) values ("0954","固原","2","ningxia");

insert into city(id,city,lv,parentid) values ("0953","吴忠","2","ningxia");

insert into city(id,city,lv,parentid) values ("1953","中卫","2","ningxia");

insert into city(id,city,lv,parentid) values ("qinghai","青海","1","1");

insert into city(id,city,lv,parentid) values ("0971","西宁","2","qinghai");

insert into city(id,city,lv,parentid) values ("0973","黄南","2","qinghai");

insert into city(id,city,lv,parentid) values ("0976","玉树","2","qinghai");

insert into city(id,city,lv,parentid) values ("0975","果洛","2","qinghai");

insert into city(id,city,lv,parentid) values ("0972","海东","2","qinghai");

insert into city(id,city,lv,parentid) values ("0977","海西","2","qinghai");

insert into city(id,city,lv,parentid) values ("0974","海南","2","qinghai");

insert into city(id,city,lv,parentid) values ("0970","海北","2","qinghai");

insert into city(id,city,lv,parentid) values ("shandong","山东","1","1");

insert into city(id,city,lv,parentid) values ("0531","济南","2","shandong");

insert into city(id,city,lv,parentid) values ("0532","青岛","2","shandong");

insert into city(id,city,lv,parentid) values ("0631","威海","2","shandong");

insert into city(id,city,lv,parentid) values ("0535","烟台","2","shandong");

insert into city(id,city,lv,parentid) values ("0536","潍坊","2","shandong");

insert into city(id,city,lv,parentid) values ("0538","泰安","2","shandong");

insert into city(id,city,lv,parentid) values ("0543","滨州","2","shandong");

insert into city(id,city,lv,parentid) values ("0534","德州","2","shandong");

insert into city(id,city,lv,parentid) values ("0546","东营","2","shandong");

insert into city(id,city,lv,parentid) values ("0530","菏泽","2","shandong");

insert into city(id,city,lv,parentid) values ("0537","济宁","2","shandong");

insert into city(id,city,lv,parentid) values ("0635","聊城","2","shandong");

insert into city(id,city,lv,parentid) values ("0539","临沂","2","shandong");

insert into city(id,city,lv,parentid) values ("0634","莱芜","2","shandong");

insert into city(id,city,lv,parentid) values ("0633","日照","2","shandong");

insert into city(id,city,lv,parentid) values ("0533","淄博","2","shandong");

insert into city(id,city,lv,parentid) values ("0632","枣庄","2","shandong");

insert into city(id,city,lv,parentid) values ("shanxi","山西","1","1");

insert into city(id,city,lv,parentid) values ("0351","太原","2","shanxi");

insert into city(id,city,lv,parentid) values ("0355","长治","2","shanxi");

insert into city(id,city,lv,parentid) values ("0352","大同","2","shanxi");

insert into city(id,city,lv,parentid) values ("0356","晋城","2","shanxi");

insert into city(id,city,lv,parentid) values ("0354","晋中","2","shanxi");

insert into city(id,city,lv,parentid) values ("0357","临汾","2","shanxi");

insert into city(id,city,lv,parentid) values ("0358","吕梁","2","shanxi");

insert into city(id,city,lv,parentid) values ("0349","朔州","2","shanxi");

insert into city(id,city,lv,parentid) values ("0350","忻州","2","shanxi");

insert into city(id,city,lv,parentid) values ("0359","运城","2","shanxi");

insert into city(id,city,lv,parentid) values ("0353","阳泉","2","shanxi");

insert into city(id,city,lv,parentid) values ("shangxi","陕西","1","1");

insert into city(id,city,lv,parentid) values ("029","西安","2","shangxi");

insert into city(id,city,lv,parentid) values ("0915","安康","2","shangxi");

insert into city(id,city,lv,parentid) values ("0917","宝鸡","2","shangxi");

insert into city(id,city,lv,parentid) values ("0916","汉中","2","shangxi");

insert into city(id,city,lv,parentid) values ("0914","商洛","2","shangxi");

insert into city(id,city,lv,parentid) values ("0919","铜川","2","shangxi");

insert into city(id,city,lv,parentid) values ("0913","渭南","2","shangxi");

insert into city(id,city,lv,parentid) values ("0910","咸阳","2","shangxi");

insert into city(id,city,lv,parentid) values ("0911","延安","2","shangxi");

insert into city(id,city,lv,parentid) values ("0912","榆林","2","shangxi");

insert into city(id,city,lv,parentid) values ("sichuan","四川","1","1");

insert into city(id,city,lv,parentid) values ("028","成都","2","sichuan");

insert into city(id,city,lv,parentid) values ("0816","绵阳","2","sichuan");

insert into city(id,city,lv,parentid) values ("0832","资阳","2","sichuan");

insert into city(id,city,lv,parentid) values ("0827","巴中","2","sichuan");

insert into city(id,city,lv,parentid) values ("0838","德阳","2","sichuan");

insert into city(id,city,lv,parentid) values ("0818","达州","2","sichuan");

insert into city(id,city,lv,parentid) values ("0826","广安","2","sichuan");

insert into city(id,city,lv,parentid) values ("0839","广元","2","sichuan");

insert into city(id,city,lv,parentid) values ("0833","乐山","2","sichuan");

insert into city(id,city,lv,parentid) values ("0830","泸州","2","sichuan");

insert into city(id,city,lv,parentid) values ("1833","眉山","2","sichuan");

insert into city(id,city,lv,parentid) values ("1832","内江","2","sichuan");

insert into city(id,city,lv,parentid) values ("0817","南充","2","sichuan");

insert into city(id,city,lv,parentid) values ("0812","攀枝花","2","sichuan");

insert into city(id,city,lv,parentid) values ("0825","遂宁","2","sichuan");

insert into city(id,city,lv,parentid) values ("0831","宜宾","2","sichuan");

insert into city(id,city,lv,parentid) values ("0835","雅安","2","sichuan");

insert into city(id,city,lv,parentid) values ("0813","自贡","2","sichuan");

insert into city(id,city,lv,parentid) values ("0837","阿坝","2","sichuan");

insert into city(id,city,lv,parentid) values ("0836","甘孜","2","sichuan");

insert into city(id,city,lv,parentid) values ("0834","凉山","2","sichuan");

insert into city(id,city,lv,parentid) values ("xizang","西藏","1","1");

insert into city(id,city,lv,parentid) values ("0891","拉萨","2","xizang");

insert into city(id,city,lv,parentid) values ("0892","日喀则","2","xizang");

insert into city(id,city,lv,parentid) values ("0897","阿里","2","xizang");

insert into city(id,city,lv,parentid) values ("0895","昌都","2","xizang");

insert into city(id,city,lv,parentid) values ("0894","林芝","2","xizang");

insert into city(id,city,lv,parentid) values ("0896","那曲","2","xizang");

insert into city(id,city,lv,parentid) values ("0893","山南","2","xizang");

insert into city(id,city,lv,parentid) values ("xinjiang","新疆","1","1");

insert into city(id,city,lv,parentid) values ("0991","乌鲁木齐","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0993","石河子","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0995","吐鲁番","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0999","伊犁","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0997","阿克苏","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0906","阿勒泰","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0996","巴音","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0909","博尔塔拉","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0994","昌吉","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0902","哈密","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0903","和田","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0998","喀什","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0990","克拉玛依","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0908","克孜勒","2","xinjiang");

insert into city(id,city,lv,parentid) values ("0901","塔城","2","xinjiang");

insert into city(id,city,lv,parentid) values ("yunnan","云南","1","1");

insert into city(id,city,lv,parentid) values ("0871","昆明","2","yunnan");

insert into city(id,city,lv,parentid) values ("0877","玉溪","2","yunnan");

insert into city(id,city,lv,parentid) values ("0878","楚雄","2","yunnan");

insert into city(id,city,lv,parentid) values ("0872","大理","2","yunnan");

insert into city(id,city,lv,parentid) values ("0873","红河","2","yunnan");

insert into city(id,city,lv,parentid) values ("0874","曲靖","2","yunnan");

insert into city(id,city,lv,parentid) values ("0691","西双版纳","2","yunnan");

insert into city(id,city,lv,parentid) values ("0870","昭通","2","yunnan");

insert into city(id,city,lv,parentid) values ("0875","保山","2","yunnan");

insert into city(id,city,lv,parentid) values ("0692","德宏","2","yunnan");

insert into city(id,city,lv,parentid) values ("0887","迪庆","2","yunnan");

insert into city(id,city,lv,parentid) values ("0888","丽江","2","yunnan");

insert into city(id,city,lv,parentid) values ("0883","临沧","2","yunnan");

insert into city(id,city,lv,parentid) values ("0886","怒江","2","yunnan");

insert into city(id,city,lv,parentid) values ("0879","普洱","2","yunnan");

insert into city(id,city,lv,parentid) values ("0876","文山","2","yunnan");

insert into city(id,city,lv,parentid) values ("zhejiang","浙江","1","1");

insert into city(id,city,lv,parentid) values ("0571","杭州","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0574","宁波","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0573","嘉兴","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0575","绍兴","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0577","温州","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0580","舟山","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0572","湖州","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0579","金华","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0578","丽水","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0576","台州","2","zhejiang");

insert into city(id,city,lv,parentid) values ("0570","衢州","2","zhejiang");

insert into city(id,city,lv,parentid) values ("1852","港澳地区","1","1");

转载于:https://my.oschina.net/szwade/blog/352153